7 Best Online Advanced SQL Training Courses to Learn in 2024
The world runs on data, and SQL is the key to unlocking its secrets. If you're ready to level up your SQL game, online training is a power move....
2024-07-23
313 reads
Blog Posts
Calling a REST Endpoint from Azure SQL DB
External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas before, we might have needed an intermediate technology to make a REST call to an...
2024-07-23
19 reads
Calling a REST Endpoint from Azure SQL DB
External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas before, we might have needed an intermediate technology to make a REST call to an...
2024-07-23
6 reads
Calling a REST Endpoint from Azure SQL DB
External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas before, we might have needed an intermediate technology to make a REST call to an...
2024-07-23
80 reads
THAT Conference 2024 in Wisconsin Dells
I’m headed back to Wisconsin Dells next week for THAT! Conference 2024. This is my second time in Wisconsin and third THAT overall. This time I didn’t submit, but...
2024-07-23
17 reads
Identify Tables With Dropped Columns
On my last article - What happens when we drop a column on a SQL Server table? Where’s my space? - I have shown what happens when we drop...
2024-07-22 (first published: 2024-07-09)
358 reads
Latest Update for Undercover Catalogue Powershell Interrogation Script
We’ve been hearing of a few people getting errors from the latest Undercover Catalogue, Powershell interrogation script. The issue seems to be happening when the scripts tries downloading automatic...
2024-07-22
27 reads
Microsoft 365 Security and Compliance for Administrators, a Book Review
I was asked to review the following book by the publisher, and I must say that it was a good experience for me. I used the book to help...
2024-07-22
15 reads
Monday Monitor Tips – Adding Redgate Monitor Custom Metrics from SQLMonitorMetrics
This post talks about adding custom metrics from the sqlmonitormetrics.com site automatically and how this works (and how it doesn’t). This is part of a series of posts on...
2024-07-22
70 reads
Set a Runtime Variable in an Azure DevOps Pipeline
Note: I DO NOT recommend this. Any changes to a pipeline should be in code and through a PR. That being said, I know this information is out there...
2024-07-22 (first published: 2024-07-05)
337 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers