My SQL Server on VMware Accelerator boot camp video series is now live on Youtube! There’s no strings attached and no price of entry, so now there’s no reason...
2023-07-17 (first published: 2023-07-07)
382 reads
exulansis – n. the tendency to give up trying to talk about an experience because people are unable to relate to it – whether through envy or pity or...
2023-07-14
91 reads
As part of my effort to inform people on how to use tools with their disabilities and continue working, I created a series of videos that demonstrate how I...
2023-07-14 (first published: 2023-07-05)
126 reads
Some of you may know that I went to work for BlueGranite a little over four years ago. It was humbling to be part of such a talented team...
2023-07-14
45 reads
As I have mentioned in a prior blog post, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering...
2023-07-14 (first published: 2023-06-28)
685 reads
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
74 reads
A Barebone Script To Generate SQL Script to Create Synonyms
This stored procedure can be used to generate a SQL script to create synonyms for all tables in...
2023-07-12 (first published: 2023-07-10)
100 reads
I had a requirement to temporarily prevent access, read or write, to a particular database for all users except 2 users. There were hundreds of SQL Logins with access...
2023-07-12 (first published: 2023-07-11)
124 reads
Heraflux is returning to deliver a new webinar with Rubrik and ActualTech Media titled “How to Secure Your Azure SQL Data.” With Azure SQL Server offerings continuing to grow...
2023-07-12 (first published: 2023-06-27)
77 reads
Restoring a SQL Server backup in a Docker container is quite easy. To begin with, you will need persistent storage on your Docker container to follow this blog post....
2023-07-12 (first published: 2023-06-29)
558 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
This is a generic question. To the moderators, I wasn't sure where to place...
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers