SQL Rally Deck's and Demo's Up

Hello Dear Reader!  I'm coming to you live from the wonderful SQL Rally in Dallas Texas.  I have two sessions...

Logical Fallacy Poster

Ran across this recently, YourLogicalFallacyIs.com is a site that lists all the ways you can apply logic badly, and they’ve...

One Way to Work Around the .NET Setup Project’s Picky Version Number Behavior

If you don’t change the version number of your .NET project output every time you create a setup package, you...

SQLRally 2012–Wednesday

Had a nice lunch at On The Border at Orlando International before my flight, used that time to finish some...

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