SQL Server 2005 Modernization Checklist
As Bala Narasimhan from PernixData and I discussed in a webinar last week, SQL Server 2005 hit end of it’s...
2016-05-01
542 reads
As Bala Narasimhan from PernixData and I discussed in a webinar last week, SQL Server 2005 hit end of it’s...
2016-05-01
542 reads
Next week I am participating in two exciting webinars that I want to share with you!
Improve App Uptime: Tips from MVP...
2016-04-22
525 reads
A number of you sent me some excellent questions about this topic, and my favorite asked me for the query...
2016-04-08
714 reads
Not too many people know about the intricacies of virtualization CPU scheduling and its impact on the performance of the VMs,...
2016-03-09 (first published: 2016-03-03)
1,121 reads
This Friday I will be holding a precon training session at the next SQL Saturday in Chicago called ‘SQL Server Infrastructure...
2016-02-29
829 reads
I’m running a flash sale discount for my upcoming Chicago SQL Saturday Precon called ‘SQL Server Infrastructure Tuning for Availability...
2016-02-18
449 reads
A few weeks ago a number of us embarked on this year’s SQL Cruise, this time to the Caribbean. It was...
2016-02-16
617 reads
What an amazing week! VMware has announced the full list of VMware vExperts for the first half of the 2016 cycle, and I’m...
2016-02-09
453 reads
I recently received a great question through email. It was whether or not it is a good idea to have...
2016-01-18
955 reads
I’m pleased to announce that I’m launching a new all-day precon training session at the next SQL Saturday in Chicago...
2016-01-07
371 reads
Setting page visibility and the active page are often overlooked last steps when publishing...
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
I am trying to check out elastic query between two test instances we have...
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
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