Do You Work for #1?
Someone recently asked me if I would work for a company if I didn’t believe in their products or services...
2011-07-28
648 reads
Blog Posts
How to move Cluster MSDTC Drive
I recently had the need to move the MSDTC for a cluster to a new SAN drive. It’s a quite simple...
2011-07-28
2,861 reads
T-SQL refactoring
Keeping your SQL objects’ naming rules during furious development is hard. New levels of information are added continuously, entities are...
2011-07-28
2,734 reads
When Did That Restore Finish?
I saw this question come across Twitter under the #sqlhelp tag one day and was wondering myself. Someone suggested the...
2011-07-28
7,597 reads
Exceptional DBA of the Year 2011 - Please vote for Jeff Moden
Every year Redgate has a competition to find the most
exceptional DBA of the year. This year too they are conducting....
2011-07-27
1,600 reads
Lookup functions in SSRS 2008 R2 - II
Introduction
In my last post on Lookup functions related to SSRS 2008 R2, I had explained Lookup(). It is used to...
2011-07-27
8,556 reads
Preparing for #sqlsat81
SQL Saturday 81 is coming up this weekend in Birmingham AL. This will be my 5th SQL Saturday to speak...
2011-07-27
589 reads
Searching for Wild Card Characters
I got asked an interesting question recently, I was demonstrating how you can use wild cards in a WHERE clauses...
2011-07-27
773 reads
Some Common Disk Drives Compared
Since I talked about how wonderful the newer Western Digital Black 6Gbps SATA III hard drives are a couple of...
2011-07-27
1,125 reads
SQL Server does not script indexes by default
Here is a got-ya that happened to me. In SQL Server I want to generate a script of all the...
2011-07-27
9,105 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers