Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL Server database and just left the default settings alone, you’re not alone. Microsoft provides a...
2025-07-09
89 reads
Understanding the Limits Before You Hit Them If you’re responsible for a SQL Server instance but don’t live and breathe licensing, you’re not alone. Many IT managers and sysadmins...
2025-07-09 (first published: 2025-06-25)
407 reads
The PASS Summit goes on tour this year, with a September stop in Dallas. This is the first event in the series, and I’m excited to go back to...
2025-07-09
51 reads
In my YouTube subscriptions feed, a new video for the Azure Cloud Chronicles with Microsoft MVPs channel popped up and when I went to it, I noticed that the...
2025-07-08
14 reads
This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has been a great help in multiple communities over the years, and he has quite an...
2025-07-08
95 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, John Sterrett
(blog) asks us:
What are you doing, or what can we do...
2025-07-08
10 reads
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that has evolved over decades. It is known for its reliability, feature richness, and strong community...
2025-07-08
69 reads
Logging is a necessity in the database world, well, the entire tech world. You need to know what is happening in and around your databases. It’s easy to setup...
2025-07-07
140 reads
☁️ Cloud vs. On-Premises Database Security: A Strategic Transformation The approach to securing databases has evolved significantly with the rise of cloud computing. In a traditional on-premises setup, organizations...
2025-07-07
6 reads
🎥 Columnstore Indexes in SQL Server – A Practical Guide with Real-World Examples 🔍 What Are Columnstore Indexes? Unlike traditional row-based indexes, Columnstore Indexes organize and store data by...
2025-07-07 (first published: 2025-06-18)
699 reads
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
By alevyinroc
In the blink of an eye, summer has passed. I don’t know about you,...
By Chris Yates
In today’s digital landscape, data is both a strategic asset and a potential liability....
Comments posted to this topic are about the item Change Tracking Data Retention Options
Comments posted to this topic are about the item Requiring Technical Debt Payments
Comments posted to this topic are about the item Using the FP-Growth Algorithm to...
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers