Inspector V1.2 now available
It has been long overdue but finally V1.2 is now available on GitHub.
V1.2 brings a lot of changes, We put...
2018-10-10
364 reads
It has been long overdue but finally V1.2 is now available on GitHub.
V1.2 brings a lot of changes, We put...
2018-10-10
364 reads
Pre-requisites:
SQL 2012 or higher
SQL Server Agent
A database to store the the data collected by the agent jobs (this can be...
2018-10-10
293 reads
In my recent post, Installing External Modules into SQL Server’s Python I had a look at just how simple it is to...
2018-09-18
550 reads
It’s the second Tuesday of the month which must mean only one thing…
We’re all skint and payday feels like a...
2018-09-11
269 reads
For those of you who don’t have time to watch the videos, the audio stream of our webcasts are now...
2018-09-05
296 reads
So Microsoft have integrated Python into SQL Server, from the moment I heard that I thought to myself, “wow, this...
2018-09-03
345 reads
The latest webcast from SQLUndercover.com. In this episode David and Adrian take a look at a few blog posts that have caught...
2018-08-29
374 reads
Easily Keep Track of All Your SQL Servers
We know what it’s like when you’ve got 101 SQL Servers to manage,...
2018-08-28
271 reads
I’m sure that we all know that SQL Server includes all sorts of interesting functionality to allow us to encrypt...
2018-08-27 (first published: 2018-08-09)
1,837 reads
I was having a cleanup of some old scripts the other day when I stumbled upon a script I wrote...
2018-08-08 (first published: 2018-07-25)
2,004 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