SQL Saturday Tampa
I’m sitting in the Tampa airport waiting for a flight back home from SQL Saturday 10 in Tampa. There was...
2009-01-25
1,673 reads
Blog Posts
Attending TechEd 2009? Consider Hosting a Birds of a Feather Session
Anyone attending TechEd 2009 can submit a Birds of a Feather (BOF) session proposal. These sessions are open discussion topics...
2009-01-23
1,439 reads
Book Review: Big Brown
The book is actually Big Brown: The Untold Story of UPS and it was written by a retired UPSer that...
2009-01-23
976 reads
The Wickedness of the mass 'REPLACE()'
I have been admonished in the past for the use of this code which makes as many
substitutions as you like...
2009-01-23
1,150 reads
Influence
I saw Paul Kenny of Ocean Learningspeak about sales least year at the Business of Software Conference. I thought he...
2009-01-22
898 reads
Read-Only Access to SQL Server Jobs
This question comes up a lot: how do I give read-only access to job status to a group of people?...
2009-01-22
4,016 reads
The Story of Pumpkin Man
Another story from a previous job. I joined the company in August, in October they started prepping for Halloween - it...
2009-01-22
926 reads
What Do You Want Auditors to Know About Auditing SQL Server?
Right now it looks like I'll be putting a training session on for my local ISACA chapter on SQL Server...
2009-01-22
1,097 reads
Mastering SQL Server Profiler E-Book Available for Free
After a lot of delays, my book on how to use SQL Server Profiler has been published by Simple-Talk Publishing,...
2009-01-21
4,388 reads
Notes from the January 2009 oPASS Meeting
We had our first oPASS meeting of the year last week with about 18 attending. Jonathan Kehayias was our featured...
2009-01-21
680 reads
Blogs
Scaling PowerShell – Lessons from a Technical Interview
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
Installing Old Versions of PowerShell Modules with Their Dependencies
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
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...
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