Getting Inspired with SQL Someday

Recently, I caught my during a kickoff with a new client saying, “Hello I am John, and I love SQL....

Denali — Day 10: Sequence object

Denali – Day 10: Sequence object

Sequence is an object introduced in Denali, this is similar to ORACLE sequence, earlier sql server...

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

“Query cost (relative to the batch)” <> Query cost relative to batch

OK, so that is quite a contradictory title, but unfortunately it is true.  There is a common misconception that the query with...

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