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

Command line to configure windows firewall for SQL server access

I regularly deploy SQL Server to new Windows Server 2008 hosts and one thing that I find quite a chore...

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

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

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

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

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

Speaking at Rocky Mountain Tech Trifecta 2012 on May 19

I will be presenting two sessions at the Rocky Mountain Tech Trifecta in Denver on May 19, 2012. This is...