Clarity in T-SQL: Adjoining Socks
One of my children is very literal, a true pedantic. “Is there any homework you need to do?” “No.” “Really?...
2014-01-04
590 reads
Blog Posts
Day 11 – Purging syspolicy
This is the eleventh installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2014-01-04
51 reads
12 Webcasts from Pragmatic Works Training On The T’s
In the past year, I’ve done a few presentations for Pragmatic WorksTraining on the T’s. If you aren’t familiar with Training...
2014-01-03 (first published: 2013-12-31)
3,296 reads
2013 – A Year In Review
It is in our nature as humans to look back in order to understand where we have been.
Warning – some of...
2014-01-03
728 reads
Day 10 – Retention of XE Session Data in a Table
Gathering event information is a pretty good thing. It can do wonders for helping to troubleshoot. What do you do if you need or want to be able to...
2014-01-03
14 reads
Day 10 – Retention of XE Session Data in a Table
This is the tenth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2014-01-03
921 reads
Friday Followup For January 3, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-01-03
408 reads
Presenting “AlwaysOn Multisite Cluster Implementation In The Cloud”
On 8th Jan 6.30 PM, I will be presenting “AlwaysOn Multisite Cluster Implementation In The Cloud”@ at San Francisco SQL...
2014-01-03
579 reads
Presenting “AlwaysOn Multisite Cluster Implementation In The Cloud”
On 8th Jan 6.30 PM, I will be presenting “AlwaysOn Multisite Cluster Implementation In The Cloud”@ at San Francisco SQL...
2014-01-03
356 reads
2014-01-03
5 reads
Blogs
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers