SQLRally 2012–Thursday

Arrived at the convention center about 7:30, managed to arrive at the right end of the convention center and walked...

Tech Days 2012 in Kosovo

Another Tech Days Prishtina where I will speak about SQL Server 2012 for IT Pros. After a success event in...

Which SELECT * Is Better?

The short answer is, of course, none of them, but testing is the only way to be sure.
I was asked,...

#SQLRally Women in Technology Panel of WIN AND AWESOMENESS

Best. Luncheon. EVAR.

I just finished up moderating this year’s Women in Technology panel here at SQLRally, and it was fantastic. ...

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