Today we have launched Data Céilí (pronounced kay-lee) Dublin 2023, Ireland’s free, community led, Microsoft Data Platform event. We tried in 2020 but certain global events prevented us from...
2023-01-16 (first published: 2023-01-09)
223 reads
I had a request regarding how to identify unused indexes across all databases on a SQL Server instance (rather than just the current one). I’ve written this script before...
2023-01-16 (first published: 2023-01-05)
901 reads
Foreword
The other day I managed to confuse myself. I was looking up some information from an Extended Events (XE) session, but my eyes were playing a trick on me....
2023-01-16
11 reads
In my experiments with the Flyway CLI (fwcli), I’m finding some interesting behavior, some of which is catching my by surprise. This post looks at the baseline command and...
2023-01-16
22 reads
Today’s coping tip is to take five minutes to sit still and breathe. Sounds simple. I find this to be very challenging. If I’m just sitting here, why am...
2023-01-13
16 reads
As we’ve seen in previous posts, the process of turning TDE on for an empty database with no data is instantaneous. Most of the time though you’ll be applying...
2023-01-13
73 reads
When we consider how secure a form of encryption is there are two things we want to consider. Let’s discuss each of these in turn. What are We Protected...
2023-01-13 (first published: 2023-01-03)
384 reads
One of the things I’ve been trying to do is dig in more deeply to the Flyway command line (CLI) as part of my work with Redgate. While Flyway...
2023-01-13 (first published: 2023-01-04)
192 reads
We all would like to save money when operating in the cloud, Microsoft has released a stop / start concept for SQL Managed Instances – preview mode! At the...
2023-01-12
48 reads
Today’s coping tip is to write a list of things you feel grateful for and why. My wife – our relationship continues to grow, and I cherish this after...
2023-01-12
12 reads
I’m excited to announce the release of a new open-source project that fully automates...
I’m excited to announce the release of a new open-source project that fully automates...
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
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