SQL Server – Purging Database Mail History

SQL Server stores all mails and attachments in msdb database. To avoid unnecessary growth of msdb database you should remove...

DQS Composite Domains and Value Combinations

As I’ve been working with Data Quality Services over the past few weeks, I’ve spent a lot of time working...

DQS Composite Domains and Value Combinations

As I’ve been working with Data Quality Services over the past few weeks, I’ve spent a lot of time working...

Implementing Infinite Scroll With ASP.Net MVC 4

There are a lot of ways you could implement this but in this case I will be using the following…
ASP.Net...

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

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

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

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

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