Determining Default Trace Location
While working on some scripts against SQL Server’s default trace, I wanted to develop a sure fire way to find...
2013-01-09
1,805 reads
StrateSQL
Index Analysis Update – January 2012
In the past couple weeks, I’ve gotten a couple reports of issues with sp_indexanalysis. The update today fixes those issues....
2013-01-08
748 reads
SQL Saturday Fargo Update
It’s been a while since I mentioned anything about the SQL Saturday in Fargo. So I thought I would let...
2013-01-08
577 reads
January 2013 – Monthly SQL Server Checklist
Today is the first Monday of 2013. Do you know if your servers are ready to take on the first...
2013-01-07
681 reads
Last Weeks Top 10 “Reading” Links #14
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-07
908 reads
Reblog: December 28 to January 3
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-01-04
1,037 reads
Last Weeks Top 10 “Reading” Links #13
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-31
1,723 reads
Wrapping Up 2012
Last year, I did a wrap up post of the year to see where I landed from where I wanted...
2012-12-31
1,630 reads
Index Analysis Post Christmas Update
Last week I mentioned that I had put up a few new versions of my index analysis script. Turns out...
2012-12-28
703 reads
PASSMN Presentation Materials
Last week, I presented on extended events at the Minnesota SQL Server user group (PASSMN). The turnout was quite excellent...
2012-12-28
734 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers