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,270 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
663 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
848 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,408 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,005 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,244 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,298 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,653 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
602 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
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers