Elastic Jobs for Azure SQL DB
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-18 (first published: 2024-04-16)
38 reads
Blog Posts
Microsoft Purview new data governance features
Starting last week is a rollout of the public preview of a new and fully reimagined Microsoft Purview data governance solution. Data governance has become so much more important...
2024-04-18 (first published: 2024-04-17)
23 reads
SQL Database Administration: Not For Everyone (But Maybe It’s for You)
Let's get one thing straight: database administration isn't the most glamorous tech job out there. You won't be building flashy user interfaces or trendy AI models. But if you...
2024-04-18 (first published: 2024-04-17)
21 reads
Undercover Catalogue 0.4.4 Released – Database Last Accessed Time and NEW Snapshot Module
Full documentation on the Undercover Catalogue can be found HERE It’s been a while since the Undercover Catalogue last received an update but having had a few of those...
2024-04-18 (first published: 2024-04-16)
11 reads
Check your regions people
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing came up. I mentioned an F2 is only around €250 a month, but a colleague...
2024-04-17
8 reads
RTO and RPO are myths unless you’ve tested recovery
I’ve watched teams spend a lot of time on backup strategy. They plan out the full, differential, and log backups to ensure they can successfully meet the recovery point...
2024-04-17 (first published: 2024-04-05)
206 reads
SQL Quickstart Guide by Walter Shields – Book Review & Summary
In today’s world, data is everywhere. Companies collect it, governments analyze it, and it influences everything from what products we buy to how we vote. But all that data...
2024-04-17 (first published: 2024-04-05)
119 reads
Using Git Prune–#SQLNewBlogger
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated a lot of branches. Even though I’m a solo developer, I decided to use branches,...
2024-04-17
26 reads
Derby City Data Days
It was awesome to see the Kentucky data community come out for the first Derby City Data Days in Louisville, KY! Bringing together communities from Ohio, Tennessee, and Kentucky,...
2024-04-16
6 reads
Familiar Sights
Yesterday was a long day in London. I arrived late in the am, and as I was walking from the plane to the border check, I went down the...
2024-04-16
9 reads
Blogs
Check your regions people
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
Using Git Prune–#SQLNewBlogger
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
Microsoft Purview new data governance features
By James Serra
Starting last week is a rollout of the public preview of a new and...
Forums
Degraded Performance in 2017 vs 2008 R2 with inserts
We're finally upgrading from SQL Server 2008 R2 Enterprise to SQL Server 2017 Standard...
Do I need a recursive query for this? bill of materials (sort of)
I am working on a data warehouse project for a bakery. For the most...
Do I need a recursive query for this? bill of materials (sort of)
I am working on a data warehouse project for a bakery. For the most...
Question of the Day
Restoring the Resource Database
How can I restore a version of the Resource Database in SQL Server 2022?
See possible answers