SQL Rally Wrap Up

Another SQL Rally has wrapped up in Dallas, TX and it was great event.  My favorite part about these larger...

SQL Saturday #119 – One week to go

One week from today I’ll be boarding a plane for my very first visit to Chicago* (airports not included).
One week...

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

When SQLCommunity disappoints....

Everyone who is involved in, and follows me in the SQL Server Community, and my blog, knows, that I am one...

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