Azure Workbooks
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I am trying to reproduce it in workbooks. While it isn’t an exact match, workbooks provide...
2023-12-13 (first published: 2023-11-29)
311 reads
SQLKitty
Importing Flat Files into Azure SQL DB
Initially, I thought I would have to use sqlcmd because I’m on a Mac and don’t have SSMS. It turns out Azure Data Studio has a nifty way to...
2023-12-04 (first published: 2023-11-20)
578 reads
Part 1: The Modern Azure Data Warehouse – Choosing The Tech
With reports hitting the transactional databases, we were encountering performance issues. We needed to choose a path forward that would lighten the load on the prod database servers and...
2023-11-27 (first published: 2023-11-16)
597 reads
Help! My Docker SQL Instance Won’t Start!
One day, I shut down my computer, as I usually do nightly. This time, I shut it down on a Friday and turned it back on after a holiday...
2023-11-17 (first published: 2023-11-03)
177 reads
Setup Ola Index Maintenance with Azure Runbooks and Terraform
Yes, you still need to do some work to maintain indexes in Azure SQL Database. This post will walk you through setting up statistic updates and index maintenance using...
2023-11-06 (first published: 2023-10-19)
491 reads
Temporal Table Data Fixes
I found myself in a situation where I needed to modify temporal tables. We do this outside business hours because we don’t want clients changing data while versioning is...
2023-09-29 (first published: 2023-09-05)
566 reads
T-SQL Tuesday #165: Database Job Titles Roundup
This month I prompted bloggers to talk about what database job titles mean to them. Thank you to all who posted on this topic! Don’t worry; if you still...
2023-08-16 (first published: 2023-08-15)
12 reads
T-SQL Tuesday #165: What Do All The Database Job Titles Actually Mean?
It’s an honor to host this month’s T-SQL Tuesday. In case you don’t know the rules already, here is a recap of them: Earlier this year, when I was...
2023-08-01
134 reads
Azure Data Studio Schema Compare Extension
A coworker recently introduced me to the SQL Server Schema Compare extension in Azure Data Studio. It has come in handy since we don’t have any paid-for tools, so...
2023-07-13
64 reads
Microsoft Fabric Overview
First, thank you to Guy in a Cube for a great licensing/cost video. My company is exploring what data warehousing technology to use in Azure. I needed to learn...
2023-07-19 (first published: 2023-07-10)
465 reads
Blogs
T-SQL Tuesday #187–Solving Problems
By Steve Jones
This month we have a great invite from Joe Fleming, a first time host...
T-SQL Tuesday #187: It’s Extended Events. It’s Always Extended Events
Joe Fleming wants to know how I solve weird problems. I’m not sure I’m...
Starting Points for Quantum Computing Learning
By Brian Kelley
I didn't have these in my slides for the Techno Security & Digital Forensics...
Forums
How to add metadata for every record in Azure postgres tables
Hi, I have a situation in one of the applications I am working on...
average duration increasing inline with exec counts
As the title says , I've got a handful of stored procs where the...
Window Functions in a View
Is there a trick to get a where clause filter to push into a...
Question of the Day
Adding Lots of Dates
The second parameter for the EOMONTH() function is an integer. In June 2025, if I run this code, what is returned?
DECLARE @d DATE = GETDATE() SELECT EOMONTH(@d, 95695)See possible answers