The SQL Server installer has gotten better: tempdb configuration, MAXDOP, and even max memory can now be configured during setup. But don’t be fooled: there’s still a post-install checklist...
2025-07-23
36 reads
In today’s enterprise landscape, agility and reliability go hand-in-hand. As organizations modernize legacy infrastructure and scale operations across borders, the challenge is no longer just about moving fast –...
2025-07-22
56 reads
I’m honored to be speaking at the PASS Data Community Summit in Seattle this fall. I’ll be delivering a Professional Development session (Blogging for the Tech Professional), which might...
2025-07-22
46 reads
herefore, from Northwind and pubs to WideWorldImporters, I've compiled where to get those databases and what you need to know in order to use them yourselves.
2025-07-21
94 reads
PostgreSQL 17 introduces a new era of innovation in open-source database technology. This release focuses on performance, scalability, developer productivity, and enterprise-grade reliability. Each feature in PostgreSQL 17 is...
2025-07-21
1,021 reads
The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling their jeans or people with bellbottoms or the 80’s music playing in grocery stores… It’s...
2025-07-18
111 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-17
56 reads
In today’s data-driven economy, organizations are no longer asking if they should invest in data, they are asking how fast they can turn data into decisions. The answer, increasingly,...
2025-07-17
137 reads
In today’s data-driven world, organizations rely on skilled professionals to design, build, and maintain scalable data solutions. The DP-203: Data Engineering on Microsoft Azure certification is your ticket to...
2025-07-16
92 reads
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve ever upgraded a SQL Server instance and something just broke in your application, chances are...
2025-07-16
405 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