SQLSaturday #129 - City of Rochester, NY

Long before it was announced that coming August 4, 2012, SQLSaturday #158 returns to the NYC  (<< see recent announcement, New York...

The Difference Between Change Tracking and Change Data Capture

Change Tracking (CT) and Change Data Capture (CDC) were both added to SQL Server in 2008. At first it seems...

Working with bitwise data in SQL Server

I was working with a group of students on a design brief. The brief was to partially implement a database...

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