Modernizing Your T-SQL: The Sequence Object
This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server.
Last year, you finally retired the last of your SQL Server...
2020-03-10
15 reads
Blog Posts
Modernizing Your T-SQL: The Sequence Object
This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. Last year, you finally retired the last of your SQL...
2020-03-10
37 reads
SQL Database MI benefits
As I see a huge number of customers migrating their on-prem databases to the Azure cloud, the main question they ask is about whether they should go with an...
2020-03-10 (first published: 2020-03-02)
895 reads
T-SQL Tuesday #124 – Monitoring Query Store’s Impact on Your System
This month’s T-SQL Tuesday blogging party is brought to you well by me and I wanted to talk more about Query Store. I did write a book on it...
2020-03-10
180 reads
T-SQL Tuesday #124–Query Store in Action
Today is T-SQL Tuesday #124 and I’m dropping a quick post as I’ve had lots of other stuff to do since returning from my sabbatical. Tracy Boggiano is the...
2020-03-10
127 reads
Let’s Call It What It Is: Complexity Debt
Technical debt get deprioritized too often because business sees the word, “technical.” It doesn’t matter what the true meaning is. And it’s a big problem. It really needs proper...
2020-03-09 (first published: 2020-03-02)
596 reads
Query Store, Plan Forcing, and DROP/CREATE
I absolutely love Query Store and the ability it provides to force a plan is amazing. However, there are a lot of little gotchas in this functionality. I just...
2020-03-09 (first published: 2020-03-02)
416 reads
A trusty old friend – The BCP utility
One of the requirements that springs up around data stores – regardless of if they are relational, not relational, cloud based or some other variety is (unsurprisingly) the need...
2020-03-08
236 reads
Notes from SQLSaturday Tampa 2020
The notes! Attendance was the speaker dinner was great! Always nice to have a lot of people there. During the day logistics all went well, though it’s still a...
2020-03-08
28 reads
Thanks for joining us at SQLSaturday Baton Rouge 2020 Business Intelligence edition
Thanks for joining us at the first annual SQLSaturday Baton Rouge Business Intelligence yesterday, put on by the Baton Rouge Analytics and Intelligence Network (#GOBRAIN!), an official chapter of...
2020-03-08
23 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers