Note: co-authored with Christine Assaf, originally published in the now-defunct PASS Blog.
Historical data analysis that is naïve to past discrimination is doomed to parrot bias. How do we combat bias in our...
2020-09-23
11 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-23
10 reads
The merry-go-round scan or advanced scan is something that I’ve seen mentioned a few times recently and it’s a lovely little feature of Enterprise Edition that not all that...
2020-09-23 (first published: 2020-09-16)
227 reads
The public preview version of Azure Synapse Analytics has three compute options and four types of storage that it can access (mentioned in my blog at SQL on-demand in...
2020-09-23 (first published: 2020-09-16)
276 reads
Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview of my session at VMworld 2020 called Hybrid Cloud Architecture for SQL Server Workloads: Deep...
2020-09-23
83 reads
Recently someone asked a good question about SQL Data Compare. How can they add applicationintent to the connection? If you are using Data Compare, and you are reading from...
2020-09-22 (first published: 2020-09-14)
204 reads
Sometime having the right command in place opens up new doors to test things, like a failover for example. In this post we will take a look at a...
2020-09-22
2 reads
Sometime having the right command in place opens up new doors to test things, like a failover for example. In this post we will take a look at a...
2020-09-22
3 reads
Sometime having the right command in place opens up new doors to test things, like a failover for example. In this post we will take a look at a...
2020-09-22
Sometime having the right command in place opens up new doors to test things, like a failover for example. In this post we will take a look at a...
2020-09-22
5 reads
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Comments posted to this topic are about the item Minimum Change Tracking Retention
Comments posted to this topic are about the item AI Steals Joy
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers