The one and only – Dr. SQL – Louis Davidson (b|t|t|t) stopped by for a chat! Relational Algebra, Disney, Dollywood and a SQL Dump Truck ??
The post Data Bits...
2020-04-17 (first published: 2020-04-08)
271 reads
Auto-generated statistics names can seem like they are entirely random, but there is a method to the madness. With a little effort and a bit of TSQL trickery, we...
2020-04-17
3 reads
I am super excited, and humbled, to have been selected to speak at the very first PASS virtual SQL Saturday, SQL Saturday Richmond, on Saturday, April 25, 2020. I...
2020-04-17
12 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-16
19 reads
Recently I ran into an error when trying to copy a small database bacpac into an Azure Managed Instance. It’s said that SSMS is able to do this task....
2020-04-16 (first published: 2020-04-03)
284 reads
We are living in some very interesting times and the technical conference community is facing some challenges like it never has before. So many in-person events have been postponed...
2020-04-16
11 reads
Hi All, While I haven’t been writing here, I have been writing. I have a new article that has just been published on Simple Talk, and I am developing...
2020-04-16
44 reads
It’s a few days into April, but not too late I hope to mention that Pluralsight is offering their entire library, free to new accounts, for the month of...
2020-04-16 (first published: 2020-04-07)
494 reads
I’m thrilled to be presenting along side of some industry greats at the upcoming Global Azure Virtual Day on April 25th as part of the Omaha users group. The...
2020-04-16
7 reads
I figured it would be nice to start up a weekly chat while everyone is on lock down. If it goes well I’m up to make this a regular...
2020-04-16
26 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