A Double Day
I’m traveling back from Australia today. A few weeks ago I lost a day when I flew West across the Pacific. Today I get it back, with a different...
2019-06-16
15 reads
The Voice of the DBA
Simulating Load
I needed to generate some load for a demo and wasn’t looking forward to doing it. I was in a hurry, and didn’t want to deal with a lot...
2019-06-27 (first published: 2019-06-12)
475 reads
The Data Platform is Important
I didn’t attend the //build/ conference this year and am slightly disappointed. Only slightly, since I was in these cities in May already and didn’t need another trip: London,...
2019-06-21 (first published: 2019-06-05)
423 reads
Keynoting at SQL Saturday #831–Christchurch
After our SQL in the City Summit in Brisbane last week, Hamish Watson () asked me if I’d do a short version of my keynote talk at the upcoming...
2019-06-02
12 reads
High Security Prices–Always Encrypted 2019 needs Datacenter Edition
I was recently doing some work on Always Encrypted in SQL Server 2019 and needed to set up an HGS server. I went through most of the setup, and...
2019-06-14 (first published: 2019-05-30)
328 reads
A Lost Day
I’m writing this in advance, as I usually recommend for all bloggers, because this is a lost day for me. I’m not going to experience May 27th, 2019 on...
2019-05-27
39 reads
The SQL Change Automation in SSMS Beta
Give it a try, as the beta is out. I’ve been watching this product and getting updates for the last six months or so and lately I’ve been pushing...
2019-05-23
140 reads
High Security Prices–Always Encrypted 2019 needs Datacenter Edition
I was recently doing some work on Always Encrypted in SQL Server 2019 and needed to set up an HGS server. I went through most of the setup, and...
2019-05-22
47 reads
Strategies for Compliant Development Down Under
I’m doing a tour of Australia and New Zealand with our SQL in the City crew. We’re going to be in Brisbane, Christchurch, and Melbourne on three consecutive weeks....
2019-05-21
4 reads
Happy Hour at SQL in the City Austin
Tomorrow is SQL in the City 2019 – Austin. If you’ve registered, you’re going to want to come. From Kendra’s great opening keynote to Brian’s demo to a couple...
2019-05-21
13 reads
Blogs
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Forums
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Another Model, More Data Loss
Comments posted to this topic are about the item Another Model, More Data Loss
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers