Daily Coping 17 Nov 2020
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-11-17
20 reads
Blog Posts
Reflections on PASS Virtual Summit 2020
PASS Summit 2020 has wrapped up (or is in the process of wrapping up), and as with years past, I’m getting this written while the experience is still fresh...
2020-11-17
2 reads
T-SQL Tuesday #132 Pandemic Coping
This year, 2020, has been crazy. What started as a normal year for me, including a sabbatical, turned into a crazy, shutdown, lockdown, stuck at home pandemic around the...
2020-11-17 (first published: 2020-11-10)
222 reads
Daily Coping 16 Nov 2020
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-11-16
11 reads
Deploy SSRS Projects with Two New PowerShell Commands
I built two new PowerShell commands to deploy SSRS projects, and they have finally been merged into the ReportingServicesTools module. The commands are Get-RsDeploymentConfig & Publish-RsProject. While the Write-RsFolderContent...
2020-11-16 (first published: 2020-11-11)
759 reads
Export SQL Server Configurations for DR purposes
Is your SQL environment prepared for a disaster? There are big and small disasters and depending on your perspective big and small can mean different things. Preparing your environment...
2020-11-16 (first published: 2020-11-10)
640 reads
SQLpassion Black Friday Deal 2020
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-11-16
1 reads
Notes on the 2020 PASS Virtual Summit – Part 6
Mostly Friday notes here. This morning I was the moderator for Continuous Integration with Local Agents and Azure DevOps by Steve Jones. The way the Summit worked this year...
2020-11-14
19 reads
Daily Coping 13 Nov 2020
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-11-13
23 reads
I get by with a little help from my friends : T-SQL Tuesday #132
Taiob Ali (blog|twitter) is our host for TSQL Tuesday this month and he’d like us to talk about how our ... Continue reading
2020-11-13 (first published: 2020-11-10)
262 reads
Blogs
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Forums
taking the rcsi dive
Hi, we put together an extract that runs every 15 minutes against what i...
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
Question of the Day
Minimum Change Tracking Retention
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