Large System Databases on SQL Server
This one is an oldie in my blog drafts, but a goodie! So, I will finally post it after nearly three years of sitting around. Thank you, past self,...
2024-06-04
108 reads
This one is an oldie in my blog drafts, but a goodie! So, I will finally post it after nearly three years of sitting around. Thank you, past self,...
2024-06-04
108 reads
I posted on Terraform and Azure SQL last year but wanted to see what Bicep could do this year. I’m going to test Bicep out with Elastic Jobs. TL;DR—My...
2024-05-22 (first published: 2024-05-02)
182 reads
I know if you are a SQL Server DBA using Azure SQL DB, you’ve been sorely missing the agent. Enter Elastic Jobs to help you schedule jobs more easily...
2024-04-29 (first published: 2024-04-16)
381 reads
In today’s fast-paced digital world, keeping your data safe and accessible is more important than ever. That’s where Azure SQL Database steps in, offering a suite of tools to...
2024-04-22 (first published: 2024-04-05)
451 reads
There are so many choices and so little time. How do you go about deciding what to learn? I have to delicately balance everything I think I want to...
2024-04-15 (first published: 2024-04-02)
438 reads
We use SQL elastic pools at work. I needed to learn more about their nuances and help you with some of their challenges. Setting Up Elastic Pools Here‘s some...
2024-04-05 (first published: 2024-03-29)
538 reads
Last year, I submitted and was accepted to present at the EightKB conference. At first, I thought my current presentation wasn’t advanced enough, but Tracy Boggiano convinced me otherwise....
2024-03-29 (first published: 2024-03-21)
190 reads
Erik Darling, founder of Darling Data, has created these fantastic stored procedures to query SQL Server more efficiently to get health, log, or performance information. I will go through...
2024-02-16 (first published: 2024-01-30)
555 reads
There are plenty of times I’m called upon to fix data. To do this, I must know what dependencies are in the database. Foreign keys are a crucial aspect...
2024-01-17 (first published: 2024-01-02)
203 reads
Building a Terraform module for Azure SQL DB is like packaging your infrastructure magic into a reusable box. It’s the kind of thing that makes your IT life smoother....
2024-01-10 (first published: 2023-12-29)
378 reads
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
By Steve Jones
This month I want to look at a few of the things I’ve seen...
By SQLPals
SQL Server 2016 Has Reached End of Support. Now What? On...
Comments posted to this topic are about the item PostgreSQL 19 Is Late
Comments posted to this topic are about the item Hyperscale Replicas V
Comments posted to this topic are about the item A Heavy Heart
I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?
See possible answers