SQL Server Hardware Book
One reason (besides laziness) that I have been fairly light on my blogging lately is that I have been working...
2010-12-14
1,267 reads
Glenn Berry
SQL Server 2008 Diagnostic Information Queries (Dec 2010)
I have been quite the slacker (by my usual standards) for blogging over the past few weeks, but my excuse...
2010-12-14
660 reads
Presenting to the PASS Database Administration Virtual Chapter
I will be giving a presentation and demo to the PASS Database Administration Virtual Chapter on Wednesday, December 8 2010...
2010-12-02
847 reads
Dynamically Backing Up All User Databases in SQL Server
I recently had a request from a client to come up with a routine to do a full compressed database...
2010-11-16
1,407 reads
SQL Server 2008 Service Pack 2 Cumulative Update 1
Microsoft has released SQL Server 2008 Service Pack 2 Cumulative Update 1, which is Build 4266. I count 67 fixes...
2010-11-16
1,004 reads
Handy Hardware Assessment Tools For SQL Server
Here is a small selection of useful tools for getting some specific hardware information from any Windows based system you...
2010-11-16
2,240 reads
New Path to MCM in SQL Server 2008
Last week, during the first day of the PASS 2010 Summit, Microsoft’s Joe Sack announced the revamped testing program for...
2010-11-15
1,297 reads
SQL Server 2005 Diagnostic Information Queries (November 2010)
Here is the November 2010 version of my diagnostic information queries for SQL Server 2005. Many of these queries are...
2010-11-15
2,644 reads
My Conversation with Ted Kummert at the PASS 2010 Summit
For some mysterious reason, I was selected as one of the “official” bloggers/tweeters during the PASS Keynotes last week. This...
2010-11-15
601 reads
XBox 360 250GB and Kinect Bundle
I took the plunge and bought one of the new 250GB XBox 360 and Kinect bundles for $399 at Best...
2010-11-14
799 reads
Blogs
Adding Test data to msdb.sysjobhistory
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Forums
% processor Time in Activity monitor is greyed out
When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...
Tools for MySQL memory estimations and optimization?
Hi all! I’ve been using MySQLCalculator.com for memory calculations, but I’m looking for alternatives...
Question of the Day
The Hash Join II
Which of these inputs is the smaller input to a hash join?
See possible answers