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

Getting Fast Counts of Large Service Broker Queues

Getting Fast Counts of Large Service Broker Queues
This question regarding getting a fast count from a service broker queue came...

January OPASS Meeting

January’s OPASS meeting will be held this Thursday, January 20th at 6pm.  We will be meeting at the Hampton Inn, 850 Village Oak Lane, Lake Mary. SQL Server...

January OPASS Meeting

January’s OPASS meeting will be held this Thursday, January 20th at 6pm.  We will be meeting at the Hampton Inn,...

New Cumulative Updates for SQL Server 2008 SP1 and SP2

Microsoft has released new cumulative updates for both SQL Server 2008 SP1 and SQL Server 2008 SP2. Remember, both of...