Backup database in CMS

Sometime you know the database name which you want to backup, but you don't know which server it is on....

Denali — Day 9: Additional Scalability Features

Denali – Day 9: Additional Scalability Features

15,000 Partitions earlier it was 1000For the enterprise system having huge amount of data to...

DQS Domain Validation Rules

A compelling feature of the new Data Quality Services in SQL Server 2012 is the ability to apply rules to...

Thank You to the People That Get Us There

http://www.flickr.com/photos/saygoodie/4548042971/
Hello Dear Reader starting today out in Dallas Texas at the Dallas Convention Center is the Second Annual SQL Rally. ...

Top 20 Reasons Why Bill 101 Is a Nuisance to Modern Quebec Society: Greatest Hits of the Tyranny of Bill 101

Quebec's Shameful, Coercive Language Law‘Je me souviens’ les palmarès Top 20 de la loi 101 sacrée qui nuit à la...

Your SQL Server database just failed, can you restore the backup?

It’s one thing to be able to backup a database, it’s another thing to be able to restore it into...

“Thou Shall Not Shrink the Database” #TSQL2sDay

This month, Chris Shaw (Blog | @sqlshaw)  is leading the charge on the T-SQL Tuesday.  This event is basically a blogging...

Denali — Day 8: Startup Parameter

Denali – Day 8: Startup Parameter

Startup Parameters means you are providing the parameter to sql server at the start of sql...

Favorite DBA Books

In the April 2012 Question of the Month, I asked readers to tell me their favorite DBA books. I have...

How To Use T-SQL TIMESTAMP (ROWVERSION) in SSIS

In some database designs, you may encounter SQL Server columns with a TIMESTAMP or ROWVERSION data type.  What are these, and how do you deal with them in SQL...