Define IOPs for all database servers
Purpose
The storage guy is configuring a new storage system. It includes RAID arrays, SVC, HBA & Fibre Channel configurations.
He’s asked me...
2011-08-22
2,115 reads
Chance to win a free seat in my Performance Troubleshooting Workshop in London!
As you might know, I'm running my "Advanced SQL Server Performance Troubleshooting
Workshop" from September 12 – 14 in Central London. You...
2011-08-21
967 reads
Pull Performance Data from Perfmon Logs with PowerShell
For the last year and a half or so I've been presenting a session on how to gather perfmon data...
2011-08-21
2,423 reads
What Will Be New for Reporting Services in 2012?
Drum roll, please! We’re in the throws of refreshing the Wrox Professional Series book on Reporting Services and, as we...
2011-08-21
1,277 reads
Thoughts on DBA Professional Development
As a DBA, we have a lot to work on and also we have a lot to learn about. The...
2011-08-20
1,404 reads
ORDER BY Clause with clustered index
One thing that I have seen repeatedly is that (too) many people believe that if you have a clustered index...
2011-08-20
1,978 reads
Win a Ticket to the “Advanced Programming” Course
We are opening another class of the “Advanced Programming in SQL Server” course on 28/08. You can find all the...
2011-08-20
472 reads
JAX Code Camp 2011
For the past 7 years, Bayer White and other Jacksonville .Net leaders have put on great Code Camps for .Net...
2011-08-19
1,010 reads
SQL Server – "Denali" – PERCENT_RANK() Analytic Function
PERCENT_RANK() returns the position of a row within the result set. In contrast to RANK() function, PERCENT_RANK() ranks rows between...
2011-08-19
1,060 reads
SQL Server 2008 SP2 cumulative update 9
AdvertisementsSQL Server 2008 latest cumulative updates 9 build 10.50.1804 available now. You may download and test itCumulative Update 9 for...
2011-08-19
1,026 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers