Because SQL Server manages security identifiers (SIDs) for any user logging into SQL Server, you risk "orphaning" users when you do a restore. It's a common problem, and here's why. Typically, ...
Microsoft on Monday announced that Azure Backup for SQL Server had reached "general availability" status, meaning it's deemed ready for production-environment use. This service is used to backup SQL ...
Now in SQL Server 2008, Transparent Data Encryption allows a DBA to encrypt an entire database without the need for any application code changes. In fact, all we need to do is set a database option ...