A Better Way To Script Database Objects
Happy New Year! My New Year's resolution for 2018 is to help you become a better SQL developer.
I want to start off with that today by showing you a...
2018-01-02
12 reads
Bert Wagner
SQL and NOT SQL: Best of 2017
With only a few days left in 2017, I thought it would be fun to do a year in review post. Below you'll find some of my top 5...
2017-12-26
5 reads
SQL and NOT SQL: Best of 2017
Photo by Rick Meyers on UnsplashWith only a few days left in 2017, I thought it would be fun to do a year...
2017-12-26
427 reads
How To Create Multi-Object JSON Arrays in SQL Server
Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like this:
And output them so that the Cars and Toys...
2017-12-19
114 reads
How To Create Multi-Object JSON Arrays in SQL Server
Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like...
2017-12-19
8,238 reads
Learning Through Blogging and Speaking
This post is a response to this month's T-SQL Tuesday prompt created by Mala Mahadevan. T-SQL Tuesday was created by Adam Machanic and is a way for SQL users...
2017-12-12
8 reads
Learning Through Blogging and Speaking
This post is a response to this month’s T-SQL Tuesday prompt created by Mala Mahadevan. T-SQL Tuesday was created by...
2017-12-12
165 reads
Reducing the Number of Reads in Your Queries
In last week's post, we went over how one of best ways to improve query performance was to reduce the number of reads that your query has to do.
Less reads...
2017-12-12
9 reads
Reducing the Number of Reads in Your Queries
“A-Bridged” – reducing reads – get it? I’m sorry you’re reading this. Photo by Jamie Street on UnsplashIn last week’s post, we went over how...
2017-12-12
216 reads
How to use Statistics IO to Improve Your Query Performance
SQL Server's STATISTICS IO reporting is a great tool to help you performance tune queries.
Usually the goal of performance tuning is to make your query run faster. One of...
2017-12-05
64 reads
Blogs
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
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...
Forums
AI Observability Challenges in FinOps as a DBA
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
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...
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