SQL Server Wait Type Repository
Microsoft’s Bob Ward has a good post up on the CSS SQL Server Engineers blog about an upcoming web page...
2009-11-08
1,340 reads
Glenn Berry
Worldwide Operating System Market Share for October 2009
Ars Technica has a good post up showing that Windows 7, (which has been out for two weeks) has already...
2009-11-07
1,454 reads
SQL Server 2008 R2 Running on “Big Iron”
During the opening keynote on Tuesday at the PASS Summit in Seattle, Microsoft’s Bob Muglia showed a demonstration of a...
2009-11-05
1,169 reads
New Pricing and Editions For SQL Server 2008 R2
Mary-Jo Foley recently posted about some announcements about SQL Server 2008 R2 out of the PASS Summit. There will be...
2009-11-05
1,022 reads
Day 1 At SQL PASS in Seattle
Today was my big, somewhat stressful day at the PASS summit in Seattle. I gave two, 75-minute Community session presentations,...
2009-11-04
1,441 reads
SQL Server 2008 Diagnostic Information Queries
Here is the script that I used in my Dr. DMV presentation this afternoon at PASS. It is a set...
2009-11-04
1,642 reads
Basic iFTS Monitoring Queries
This is one of the scripts that I will be using for my presentation “Tips and Tricks for Using SQL...
2009-11-03
1,474 reads
Minor Setup Issue with SQL Server 2008 or SQL Server 2008 R2 on Windows 7
Microsoft’s Peter Saddow, who is a Program Manager on the SQL Server Setup team has a post in the SQL...
2009-11-02
426 reads
Two Very Important Configuration Settings For SQL Server 2005/2008
Two settings that I always enable when I install SQL Server 2005 or 2008 on an x64 production database server...
2009-11-01
5,910 reads
Suggested Max Memory Settings for SQL Server 2005/2008
It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something...
2009-10-29
253,544 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
Huge frustration - Database watcher with two elastic pools
Think there's a reason why this is still in preview, but have someone manage...
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers