Delete an Azure DevOps Project
Not something you’ll do too often, but you might find yourself doing this if you are setting up PoCs and removing them. A reminder for me, since I stumbled...
2019-09-16
76 reads
The Voice of the DBA
SQL in the City Sydney in Two Weeks
It’s two weeks to our next SQL in the City Summit, this time in Sydney. I’m excited to be going back, though it’s a quick trip for me. Likely...
2019-09-13
54 reads
Changing the SQL Data Masker Connection Target
This post will explain how to change the connection in your masking set when using SQL Data Masker from Redgate. I’m writing this more for myself than anyone else....
2019-09-11
44 reads
Finding the Visual Designer in Azure DevOps Builds
This post is really a reminder to me, since I don’t create pipelines all that often, and I’ve forgotten a few times how to do this. Plus, while YAML...
2019-09-09
903 reads
SQL in the City Streamed is Today
Today is SQL in the City Streamed!!! Only three of us, , as Kendra has other commitments. Still, it’s exciting for Kathi, Grant, and myself to be presenting the...
2019-09-04
19 reads
Restoring an Expired Certificate–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One common task that you might need to...
2019-09-11 (first published: 2019-09-02)
304 reads
SQL in the City Streamed Next Week
I’m off to the UK this weekend, for a few commitments next week. One of those is SQL in the City Streamed, which is taking place on Wednesday September...
2019-08-30
22 reads
Finding SQL Configuration Manager in Windows 10–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I went to check a network protocol setting...
2019-09-16 (first published: 2019-08-28)
464 reads
Local Database CI Builds with Jenkins in a Container
In two previous posts, I’ve showed how to configure Jenkins in a container as well as how to add the SQL Change Automation plugin. This post looks at an...
2019-09-12 (first published: 2019-08-26)
620 reads
VSCode Tips–Remove the Highlighted Line
VSCode was making me crazy as I was writing a script. I like a light theme, and every time I went to type, I saw this: The highlight was...
2019-09-05 (first published: 2019-08-23)
2,512 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