1/ In SQL server 2008, there is a new whole database encryption option (TDE). I suspect that using this option will make the backups incompatible with SQL 2005.

XQuery support has been, in some quarters at least, one of the anticipated features of the new release. But XQuery has moved somewhat slowly toward becoming a standard. Standard XQuery support in SQL ...

We are currently tracking an issue with Sharepoint and use of the SQL Server "Force Encryption" option. In our case, Sharepoint 2007 with SQL Server 2008 R2. The results are pretty consistent.

Once the file is successfully restored, the user gets a pop-up message and can access the database. Key features of DataNumen SQL Recovery: – Support of SQL Server versions from 2005 to 2019 ...

Microsoft on Monday revealed that hospitals and other IT shops should expect the next generation of its database to be available on June 1. Dubbed SQL Server 2016, the forthcoming iteration brings a ...

Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth ...