Data (and Humans) At Rest
We talk a lot about data in the data world – imagine that! Sometimes, we talk about data at rest, but when do we all rest? Do we even...
2024-08-12 (first published: 2024-07-30)
184 reads
SQLKitty
Using Managed Identities with Azure SQL DB
We are trying to get apps and users off of using SQL accounts to access the Azure SQL DBs where I work. To make our lives easier, we are...
2024-08-05 (first published: 2024-07-25)
370 reads
Terraform Elastic Jobs
I did a couple of other posts on Elastic Jobs. But now I want to set them up with Terraform. This aligns with how we create infrastructure where I...
2024-07-31 (first published: 2024-07-19)
163 reads
Modifying sp_QuickieStore Returned Column Order
I love QuickieStore, but I wanted some columns to be at the front end of the results returned. Namely, I wanted top_waits, query_sql_text, and query_plan right after database name....
2024-07-15 (first published: 2024-07-03)
304 reads
Export Azure SQL DB to Storage
After a data migration, we needed to decommission the old Azure SQL DBs, but we wanted to keep a copy in case we needed anything later. Enter exporting an...
2024-07-03 (first published: 2024-07-02)
401 reads
Create a copy of an Azure SQL DB
Where I work, we will be migrating data from one set of databases into another. I will be making a copy of the destination databases to allow us to...
2024-07-10 (first published: 2024-06-25)
369 reads
Query deadlock info in Azure SQL DB
A couple of weeks ago, a developer came to me and wanted to know how to figure out what was causing a deadlock. I honestly didn’t know where to...
2024-07-03 (first published: 2024-06-14)
55 reads
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
70 reads
How to give developers access to Query Store
Let’s have devs look at their own query performance. Yes, please, sign me up for that! Sometimes, it’s hard for me to know the best course of action, especially...
2024-06-24 (first published: 2024-06-03)
620 reads
ERD Your Existing Databases
There are several tools out there to make your life easier by creating an ERD for your existing db. Everything works pretty well when you have a small number...
2024-06-12 (first published: 2024-05-23)
580 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers