-
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 readingCategory: Cloud, Microsoft SQL Server, Powershell, SQL Database, SQLServerPedia Syndication, T-SQL | Tags: Azure, Azure SQL Database, Cloud, Microsoft, Powershell, SQL, T-SQL
-
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 readingCategory: SQLServerPedia Syndication, T-SQL Tuesday | Tags: Soft Skills, T-SQL Tuesday
-
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 readingCategory: SQLServerPedia Syndication
-
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 readingCategory: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, Microsoft SQL Server, query, SQL, SQL Server, T-SQL
-
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 readingCategory: Backups, Microsoft SQL Server, SQLServerPedia Syndication, System Databases | Tags: backups, Microsoft SQL Server, system databases
-
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 readingCategory: Extended Events, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL Tuesday | Tags: Extended Events, Microsoft SQL Server, T-SQL Tuesday
-
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 readingCategory: Microsoft SQL Server, SQL Homework, SQLServerPedia Syndication | Tags: Microsoft SQL Server, SQL Homework, temporal table
-
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 readingCategory: DBA Humor, SQL Agent Jobs, SQLServerPedia Syndication | Tags: Humor, SQL Agent Jobs
-
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 readingCategory: Microsoft SQL Server, Problem Resolution, Security, SQLServerPedia Syndication | Tags: Microsoft SQL Server, problem resolution, security
-
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 readingCategory: Cloud, Managed Instance, Microsoft SQL Server, SQL Database, SQLServerPedia Syndication | Tags: Azure SQL Database, Managed Instance, Microsoft SQL Server, study