SQL Server 2025 Backup Compression Algorithm
Learn about the new ZSTD compression algorithm in SQL Server 2025.
2025-12-29
1,993 reads
Articles
Making AI Talk to Your Database: AI-Powered Database Queries Made Simple
Beneath the surface though, AI is just a tool that learns certain patterns and draws conclusions from information on the Web to answer questions, make decisions, or craft a code sample or two. Those that have used AI in the past will know that just as it’s capable of providing valuable information, AI tools can also generate inaccurate responses, and that’s why it’s important to use it wisely.
2025-12-29
Controlling SQL Window Functions with Framing
I’ve used SQL window functions for years, but I’ve never fully understood framing. To truly master window functions, you need at least a basic grasp of framing and how to apply it to your queries. Framing is especially helpful when working with aggregate functions. How can you overcome this hesitation to try framing?
2025-12-26
SQL Art: I Made a Christmas Card In SSMS
A little Christmas fun for you using the spatial features in SQL Server and SSMS.
2025-12-24
4,079 reads
Steps for Installing AlwaysOn Availability Groups - SQL 2019
With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made. This article is an update to another article, and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Before implementing your AlwaysOn Availability Group (AG), make sure […]
2025-12-24 (first published: 2025-11-25)
912 reads
SQL Server Change Tracking to Optimize Data Refreshes for Reporting
You’re a developer responsible for maintaining a SQL Server database used to feed data to Power BI. You realize that some tables don’t have a modifiedDate column and some do. Also, you know the data is updated by the application as well as other processes which makes the modifiedDate unreliable. This is because it may not always be updated when data changes. You need a way to track data changes to ensure only changed rows are updated on reports in Power BI.
2025-12-24
2025-12-22
9,165 reads
Get ChatGPT’s Advice On Your Queries with sp_BlitzCache.
First off, I understand if you read the headline and you have a knee-jerk reaction. I totally understand that there are a lot of people out there who hate AI, and believe me, I hate most uses of it. Lots of its advice can be misleading at best, and absolute garbage at worst.
2025-12-22
T-SQL in SQL Server 2025: The || Operator
I have been working in various computer languages for a long time. When I saw that the || operator was coming, I was a bit confused as to why we needed this, and how it would work. After all, this is a part of other languages. I decided to dig in a bit. This is […]
2025-12-19
8,374 reads
SQL Server 2025 Product() Function Examples
SQL Server 2025 includes new features and enhancements. In the previous SQL Server 2025 tips, we have explored many new features. Have you explored the new Product() function? If not, this will walk you through the Product() function with several examples.
2025-12-19
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Innova Crysta Car Hire Delhi: A Smart Choice for Comfortable Group Travel
Traveling in a busy city like Delhi often requires a vehicle that is spacious,...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers