BACKUP LOG WITH TRUNCATE_ONLY These two statements, which are functionally equivalent, have been around since the early days of SQL Server and were typically used to truncate the transaction log ...

Now in SQL Server 2008, Transparent Data Encryption allows a DBA to encrypt an entire database without the need for any application code changes.

From that standpoint, moving to ODBC-based APIs for SQL Server may make things easier for developers who are considering porting their SQL Server-based applications to Microsoft's cloud.

I needed to copy the SQL Server database, with its most recent schema changes, down to my laptop for a client demonstration at a location where Internet connectivity might not be available. Even ...