The Importance of SQL Server Performance Tuning in the Cloud
Make sure your cloud SQL Server databases are optimized and achieve significant cost savings.
2023-05-12
115 reads
Implementing Temporal Tables Where You Have Existing Data
An in-depth look at how you convert an existing table with data to a system versioned table that will maintain a history of changes.
2023-05-11
136 reads
New Stars of Data – SQL Bad Practices caught in the Wild
At the 12th of May 2023, a new edition of New Stars of Data takes place. If you’re not familiar with the concept, it’s a free virtual event focusing...
2023-05-12 (first published: 2023-05-11)
60 reads
What Backups Are In This File?–#SQLNewBlogger
I had a question on multiple backups in a file and had to check my syntax. This post shows how to see which backups are in a file. Note:...
2023-05-24 (first published: 2023-05-10)
151 reads
Impact of TDE on Performance
Microsoft states that enabling TDE usually has a performance overhead of 2–4%. That doesn’t sound like very much, and personally I wouldn’t let it bother me if I want...
2023-05-24 (first published: 2023-05-10)
969 reads
T-SQL Tuesday 162 : Data Science and ChatGPT
This month’s T-SQL Tuesday is hosted by Tomaz Kastrun – his call is to write about how we’ve used ChatGPT, and what are ethical issues, if any, that we...
2023-05-22 (first published: 2023-05-09)
428 reads
How to refresh Power BI desktop data
Recently we faced the issue on one project to refresh power BI desktop file to update structures.
There could be various reasons why you would like to automate PB desktop...
2023-05-22 (first published: 2023-05-09)
513 reads
Automating Database Maintenance on Azure SQL
Database maintenance is crucial for the health and performance of any database system, including those in Azure. Without regular maintenance, databases can become slow, unstable, and prone to crashes...
2023-06-07 (first published: 2023-05-08)
830 reads
Tales From The Field Weekly Wrap Up for the Week of 05-01-2023 A new house, a reunion, & 15 Years of SQL Saturday Jacksonville
Hello Dear Reader, what a week! On Thursday my wife and I closed on a new house. We are so incredibly excited! We owned a house for a very...
2023-05-08
48 reads
Why Put PostgreSQL in Azure
I’ve had people come up to me and say “PostgreSQL is open source and therefore license free. Why on earth would I put PostgreSQL in Azure?” Honestly, I think...
2023-05-17 (first published: 2023-05-08)
264 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers