I recently had to copy an Azure SQL database (SQL db) from one subscription to an Azure SQL Server instance ... Continue reading| SQL Studies
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| SQL Studies
It’s the last Friday of the year and I’ve been struggling to think of a good way to close things ... Continue reading| SQL Studies
Alternate title: How do I tell how far I am on that command? This little command (frequently with a WHERE ... Continue reading| SQL Studies
In one of the sessions I attended during the Pass Data Community Summit the speaker asked “If master is in ... Continue reading| SQL Studies
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 Studies
Recently I needed to use temporal tables. And not just for the job history table in a managed instance. In ... Continue reading| SQL Studies
Three batch jobs that run all night.Seven for the DBAs to maintain and protect.Nine quick little jobs run by the ... Continue reading| SQL Studies
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| SQL Studies
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