Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
In this level we learn how to ensure our keys are backed up to the Azure Key Vault for safekeeping.
Every Database Has Problems
The magic way to get better performance from your system is to write better code from the start.
Find SQL Server Agent Jobs that Start Other Jobs
A SQL Server Agent job can start other jobs. Writing jobs this way makes it easy to compartmentalize jobs: start a “child” job only when the “parent” reaches a certain step. Finding these steps can be challenging. There is no field or property in sysjobs or its associated tables to help find child jobs.
The New OS Wars
A few countries are looking to reduce their reliance on US technology. While they might leave Windows, Steve thinks they will continue to run SQL Server.
What Power BI DirectQuery does to your SQL Server (and how to fix it)
Power BI DirectQuery can quietly overwhelm your SQL Server. Unlike Import mode, DirectQuery sends live T-SQL for every visual interaction, multiplying queries and placing heavy analytical load on the database. This article explains how to identify the worst offending DirectQuery queries, why the generated SQL is often inefficient, and what you can do from the database side, including indexing, Query Store, and reporting views, to improve performance. It also outlines practical changes on the Power BI side and when DirectQuery is simply the wrong architectural choice.
How to minimize downtime in a cloud migration
Pat Wright details how to plan cloud migration with minimal downtime. Learn key cutover strategies, testing methods, and critical questions to avoid data loss and system failure.
How User-Defined Types work in PostgreSQL: a complete guide
I’m sure I’m not alone when I say, sometimes I get sidetracked. In this particular instance, I hadn’t intended to start learning about User-Defined Types (UDT) in PostgreSQL – I just wanted to test a behavior that involved creating a UDT. But, once I started reading, I was hooked. I mean, four distinct UDTs with different behaviors? That’s pretty cool. Let’s get into it.
Configure Extensible Key Management Using Azure Key Vault - Level 3 of the Stairway to TDE
In this third level of the Stairway, we examine how to store your encryption certificate in the Azure Key Vault.
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers