Kusto (KQL) for Azure SQL Audit
According to Rod Trent, Kusto is named after Jacques Cousteau. He says, “We are exploring the depths of our data” by searching and querying our Azure log data. His...
2024-01-03 (first published: 2023-12-26)
322 reads
SQLKitty
Extended Events in Azure Data Studio
I know I can use extended events (xevents) in Azure SQL DB when in SSMS, but I wanted to learn how to use them in Azure Data Studio (ADS)....
2023-12-20 (first published: 2023-11-30)
326 reads
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)
326 reads
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)
586 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)
607 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)
189 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)
508 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)
607 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)
14 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
138 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Bagaimana cara koreksi tanggal lahir di Tiket.com
Koreksi tanggal lahir Anda cukup menghubungi CS Tiket.com di nomor resmi (0821)62909071 atau melalui...
Bagaimana Cara koreksi nama di Tiket.com
Koreksi nama Anda cukup menghubungi CS Tiket.com di nomor resmi (0821)62909071 atau melalui whatsapp...
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers