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

PASS SQLRally Professional Development Vote Done and the Development Track Vote is open

Congratulations to the winners in the Professional Development Track Vote for PASS SQLRally.  You can see the winners at http://www.sqlpass.org/sqlrally/2011/Agenda/Sessions/SessionsProfessionalDevelopment.aspx. Now the voting is open for the Database &...

SQL Lunch - Build Your First PerformancePoint Dashboard with MVP Adam Jorgensen

SQL Lunch - Building a Performance Point Dashboard

Don't forget to attend the SQLLunch tomorrow.

#35-Building your first PerformancePoint Dashboard in SharePoint 2010

Speaker:...

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

PowerShell Week at SQL University – Post 4

Recap So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using PowerShell variables, what cmdlets and functions are, what...

PowerShell Week at SQL University – Post 4

Recap
So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using...

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

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

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

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