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
424 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)
531 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)
321 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,071 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)
624 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)
405 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)
249 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
38 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)
462 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers