Copying an Azure SQL database between two Azure SQL Instances in two different subscriptions.
I recently had to copy an Azure SQL database (SQL db) from one subscription to an Azure SQL Server instance ... Continue reading
2025-07-14
355 reads
Kenneth Fisher
A temper, soft skills, and almost losing a job : T-SQL Tuesday #170
It’s T-SQL Tuesday again! In fact, it’s the first of the year and our intrepid host is Reitse Eskens (blog|twitter). ... Continue reading
2024-01-24 (first published: 2024-01-09)
528 reads
Baby Steps and Continuous Improvement
It’s the last Friday of the year and I’ve been struggling to think of a good way to close things ... Continue reading
2024-01-12 (first published: 2023-12-29)
318 reads
SELECT FORMAT(COUNT(1),’N’) FROM TableName WITH (NOLOCK);
Alternate title: How do I tell how far I am on that command? This little command (frequently with a WHERE ... Continue reading
2024-01-05 (first published: 2023-12-26)
1,070 reads
Can you take a differential backup of master?
In one of the sessions I attended during the Pass Data Community Summit the speaker asked “If master is in ... Continue reading
2023-12-29 (first published: 2023-12-19)
280 reads
Making Extended Events a bit more usable : T-SQL Tuesday #166
Running a bit late this month for T-SQL Tuesday (it’s not exactly Tuesday is it!) but that’s Grant Fritchey’s (blog|twitter) ... Continue reading
2023-10-04 (first published: 2023-09-14)
617 reads
SQL Homework – September 2023 – Time for temporal tables.
Recently I needed to use temporal tables. And not just for the job history table in a managed instance. In ... Continue reading
2023-09-27 (first published: 2023-09-05)
404 reads
Windows Hello may cause a “SSPI Context” error
I’m going to start out by saying I don’t know a tremendous amount about this subject. I’ll tell you what ... Continue reading
2023-09-13 (first published: 2023-08-22)
237 reads
One job to rule them all
Three batch jobs that run all night.Seven for the DBAs to maintain and protect.Nine quick little jobs run by the ... Continue reading
2023-09-01
36 reads
What’s in a SQL Server Managed Instance?
My current position involves a lot of work with SQL Server Managed Instances so you’ll probably be hearing a lot ... Continue reading
2023-08-23 (first published: 2023-08-03)
460 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers