New PASS Chapter in Orlando–MagicPASS

Kendal Van Dyke is launching a new PASS Chapter called MagicPASS in Orlando this week, with the first meeting on...

SSMSDeploy Now Available!

I have finished my website, done all my recompilations, checked all my settings, and finally SSMSDeploy is on the internet,...

Time To Get Your #SQLRally Vote On!

It’s week two of voting for the upcoming SQLRally.  This week, we are voting for the Database & Application Development sessions...

Un-SQL Friday: Your Tech Giants

This started as just a regular blog…but it’s sparked such a big conversation online, I’ve decided to make it an...

Who do you want to see at SQLRally and 24HOP?

I dig democracy: I like all this voting for SQL sessions at events.

Voting is open this week, Jan17 – 23, for...

You Need Two SLAs for Disaster Recovery

Continuing on with my MCM prep, I was listening to the High Availability/DR prep module today and I was once...

31 Days of SSIS – Environmental Variable(17/31)

31 Days of SSIS
It’s time to go back to discussing the environment when it comes to SSIS packages.  For the...

Another Example of CPU Throttling Due to Balanced Power Plan in Windows Server 2008 R2

Here is another example CPU throttling from someone who had a server running with the default “Balanced” Power Plan in...

DBA 101: Why is my log file full?

This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central....

Distincting an IN subquery

This is going to be a quick one…
I keep seeing forum code (and production code) that includes the DISTINCT in...