SQL Server 2008 adds Backup Compression. I back up AdventureWorks with and without compression, compare file sizes and show how to turn it on at server level.
SQL SERVER – Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
The SQL Server 2008 Reporting Services Add-in for SharePoint (RC0) brings report viewing, subscriptions and report management into WSS 3.0 and SharePoint Server 2007.
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Silly Mistake
A developer lost a backup, and the forum replies turned into dark SQL humor: write a resignation letter, or make vendors block DELETE without a WHERE clause.
SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf) – Part 2
A last resort for corrupt datafiles with no backup: emergency mode, single user, then DBCC CHECKDB with repair_allow_data_loss. Back up the files first.
SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf)
Can you restore database using corrupt datafiles when there is no full backup and both .mdf and .ldf are damaged? My honest answer and the one thing to try.
SQL SERVER – Sharpen Your Basic SQL Server Skills – Database backup demystified
Database backup demystified was my article in the January 2007 edition of SQL Server Magazine, written to sharpen your basic SQL Server skills.
SQL SERVER – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table
A simple Table Partitioning tutorial for SQL Server 2005 that shows, step by step, how to horizontally partition a database table across two filegroups.