Data Bits – Episode 6 – Peter Shore
SQL DBA Peter Shore (t) and I had a great time recording this. Quotables: “Vehemently OK”, “Intentional Accidental DBA”, “Professional Nerd”, “Senior DBA as defined by AARP” I cut...
2020-04-13
14 reads
SQL DBA Peter Shore (t) and I had a great time recording this. Quotables: “Vehemently OK”, “Intentional Accidental DBA”, “Professional Nerd”, “Senior DBA as defined by AARP” I cut...
2020-04-13
14 reads
We are all going through some tough times. It’s tougher for some more than others. Now is the time when you have to work on being resilient, and it...
2020-04-13
7 reads
I had the opportunity of working on a project converting a postgres database to a sql server based one at work. I used this opportunity to learn more of...
2020-04-13 (first published: 2020-04-06)
316 reads
Recently I partnered up with Kevin Kline (SentryOne blog | twitter) and SentryOne to record a webinar on learning from data breaches. We start by talking about Mitre’s ATT&CK...
2020-04-13
21 reads
Here is some short description of GoF design patterns. It is just to remind the explanations. so first you have to understand each design pattern separately.Adapter Pattern: Convert the interface...
2020-04-11
80 reads
Here is some short description of GoF design patterns. It is just to remind the explanations. so first you have to understand each design pattern separately.Adapter Pattern: Convert the interface...
2020-04-11
15 reads
The March 2020 release of Azure Data Studio (ADS) includes a charting feature for SQL queries. This is a quick look at the feature, which I think will have...
2020-04-10 (first published: 2020-03-30)
548 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-10
12 reads
This article is about my own experiences in making my user group and community events more inclusive for people from diverse backgrounds. I am going to use growing my...
2020-04-10 (first published: 2020-03-31)
855 reads
I started this on Facebook, privately with friends. I heard about it from one of them and liked it. I didn’t get many guesses, so I took a chance...
2020-04-10
256 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