Splitting It Up: Side by Side Queries In SSMS
There are times when you are writing a query while referencing another piece of information: the results of another query, a variable value, a webpage, etc...
If using two monitors...
2018-02-27
10 reads
Bert Wagner
OR vs UNION ALL – Is One Better For Performance?
Today I want to show you a trick that could make your queries run faster.
It won’t always work, but when...
2018-02-20
201 reads
OR vs UNION ALL - Is One Better For Performance?
Today I want to show you a trick that could make your queries run faster.
It won't always work, but when it does everyone will be impressed with your performance...
2018-02-20
6 reads
What I Do When I’m NOT Writing SQL
This post is a response to this month’s T-SQL Tuesday prompt created by Aaron Bertrand. Adam Machanic created T-SQL Tuesday...
2018-02-13
132 reads
What I Do When I'm NOT Writing SQL
This post is a response to this month's T-SQL Tuesday prompt created by Aaron Bertrand. Adam Machanic created T-SQL Tuesday as a way for SQL users to share ideas...
2018-02-13
4 reads
“How do I contribute to dbatools?” with Drew Furgiuele
This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the...
2018-02-06
109 reads
"How do I contribute to dbatools?" with Drew Furgiuele
Watch this week's video on YouTube
This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the open-source dbatools PowerShell module.
If...
2018-02-06
3 reads
The Fastest Way To Locate Errors In Your SQL Query
Photo by N. on UnsplashIn about 60 seconds you will never debug error messages in SQL Server Management Studio the same way again.
Coming...
2018-01-30
1,950 reads
The Fastest Way To Locate Errors In Your SQL Query
In about 60 seconds you will never debug error messages in SQL Server Management Studio the same way again.
Coming from a .NET background, I'm used to receiving relatively helpful...
2018-01-30
6 reads
Inverted Polygons? How to Troubleshoot SQL Server’s Left Hand Rule
Last week we looked at how easy it is to import GeoJSON data into SQL Server’s geography datatype.
Sometimes your source...
2018-01-23
442 reads
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
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
UNISTR Basics
Comments posted to this topic are about the item UNISTR Basics
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