Play the T-SQL Alphabet Game
I recently had the opportunity to play the T-SQL Alphabet Game, which was introduced to me by SQL Server MVP,...
2009-01-21
1,247 reads
Blog Posts
Video: xp_cmdshell execution in SQL Server 2005/2008
The video I did for Jumpstart TV on xp_cmdshell execution has hit the front page. Registration on the site is...
2009-01-21
673 reads
Conficker / Downadup Worm One More Time
Hopefully by now everyone has seen this, but if not, here's a reminder to continue to spread the details. Denis Gobo...
2009-01-20
906 reads
Fake LinkedIn profiles with links to malware
This is a little old (five days based on the last update), but TrendMicro put on their blog about fake...
2009-01-20
914 reads
Getting Information Where We Want It
I’ve been running every day, over 100 days in a row now, and one of the things that has helped...
2009-01-20
847 reads
Netbooks & Alternatives
A while back I mentioned that Radio Shack had an interesting promotion on a netbook and debated at what price...
2009-01-20
1,298 reads
Networking - Part 3
Continuing the conversation I began in Part 1 & Part 2, today I want to ruminate some more on networking. I've...
2009-01-20
1,130 reads
Kindle Review – How I Read
In the last 4 months of having the Kindle, I’ve gone through a few different ways of reading on it...
2009-01-19
951 reads
We Are Microsoft charity challenge
I got the opportunity to participate in the We Are Microsoft Charity Challenge (under the umbrella of GiveCamp) in Dallas...
2009-01-19
693 reads
Book Reviews - Worthwhile?
Lately I've been thinking (again) about books and book reviews, mostly because I'm looking to see if it makes sense...
2009-01-18
910 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