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 ...

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, ...

Early discussions on SQL Server 2008 seemed to suggest that it would really only be a point release, quite unlike what occurred with SQL Server 2005. Anyone looking at the new and upgraded features in ...

A free tool from Microsoft can make backing up data in Windows Server 2008 R2 efficient and almost hassle-free. Here's how to use it effectively. Back in the day, Microsoft's free backup tool was the ...

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 ...

Microsoft SQL Server 2008 is the most recent version of the Redmond, Wash., company's data management and business intelligence platform. According to Microsoft, the version provides new capabilities ...

It's official: Microsoft has released to manufacturing its SQL Server 2008 database. Developers can download the much-anticipated upgrade to the company's database server immediately from MSDN or ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...