August Charlotte SQL Server User Group Meeting Announcement
The Charlotte SQL Server User Group meeting will be held online on August 20th at 12 Noon (EDT). They'll have...
2008-08-15
641 reads
Blog Posts
TechEd Online
I'm glad I'm not this slow, or maybe it's timed for the SQL Server release, but my TechEd Online panel,...
2008-08-15
810 reads
[OFF-TOPIC] "Geek" Comics I Follow
Like a lot of folks my age (in their 30s), I grew up on comics, both comic strips in the...
2008-08-14
769 reads
How Long Is Your Receipt?
Part of running a businness is deciding when and where to spend your hard earned cash. It's interesting to look...
2008-08-14
522 reads
2008-08-13
1,082 reads
How do I .... grant access permissions for SSIS to users?
SSIS access permissions are managed via Component Services. It is the DCOM object named MSDTSServer. Here are the steps to...
2008-08-13
45,816 reads
Microsoft Events in August for Columbia, SC
The following events are for August 21, 2008, in downtown Columbia, SC.
Morning - Momentum: IT ExecsMorning - TechNet: Vista, PowerShell, Group PolicyAfternoon...
2008-08-13
2,396 reads
Mnemonic Phone Numbers & Cell Phones
Recently I needed to make a call and the only number I had was a mnemonic one. I get why...
2008-08-13
1,895 reads
DBA's Need (and Deserve!) a Large Monitor, and Preferably Two of Them
With all the options we have for viewing query plans I still prefer the graphical view. Combined with tooltips and...
2008-08-12
523 reads
Installing RTM (SQL Server 2008)
I had to install the RTM version of SQL Server 2008 a few days ago since I'm tech reviewing a...
2008-08-12
735 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
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
AI Steals Joy
Comments posted to this topic are about the item AI Steals Joy
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