-
Copying an Azure SQL database between two Azure SQL Instances in two different subscriptions.
3July 14, 2025 by Kenneth Fisher
I recently had to copy an Azure SQL database (SQL db) from one subscription to an Azure SQL Server instance …
Continue reading -
A temper, soft skills, and almost losing a job : T-SQL Tuesday #170
4January 9, 2024 by Kenneth Fisher
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 -
Baby Steps and Continuous Improvement
1December 29, 2023 by Kenneth Fisher
It’s the last Friday of the year and I’ve been struggling to think of a good way to close things …
Continue reading -
SELECT FORMAT(COUNT(1),’N’) FROM TableName WITH (NOLOCK);
9December 26, 2023 by Kenneth Fisher
Alternate title: How do I tell how far I am on that command? This little command (frequently with a WHERE …
Continue reading -
Can you take a differential backup of master?
2December 19, 2023 by Kenneth Fisher
In one of the sessions I attended during the Pass Data Community Summit the speaker asked “If master is in …
Continue reading -
Making Extended Events a bit more usable : T-SQL Tuesday #166
1September 14, 2023 by Kenneth Fisher
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 -
SQL Homework – September 2023 – Time for temporal tables.
1September 5, 2023 by Kenneth Fisher
Recently I needed to use temporal tables. And not just for the job history table in a managed instance. In …
Continue reading -
One job to rule them all
Leave a commentAugust 31, 2023 by Kenneth Fisher
Three batch jobs that run all night.Seven for the DBAs to maintain and protect.Nine quick little jobs run by the …
Continue reading -
Windows Hello may cause a “SSPI Context” error
2August 22, 2023 by Kenneth Fisher
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 -
What’s in a SQL Server Managed Instance?
Leave a commentAugust 3, 2023 by Kenneth Fisher
My current position involves a lot of work with SQL Server Managed Instances so you’ll probably be hearing a lot …
Continue reading
SQL Studies
Live, Learn, Share
