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
184 reads
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
184 reads
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)
522 reads
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)
310 reads
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,060 reads
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)
273 reads
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)
580 reads
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)
395 reads
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
27 reads
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)
232 reads
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)
451 reads
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
Comments posted to this topic are about the item Change Tracking Default Retention
I am trying to create a subscription that posts to a one drive directory. ...
Comments posted to this topic are about the item What is Delayed Durability in...
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers