New and Improved DMVs in SQL Server 2008 R2 SP1
With relatively little fanfare, Microsoft added a few new DMVs into the SQL Server 2008 R2 SP1 release, which came...
2011-10-10
1,338 reads
Glenn Berry
Microsoft Releases SQL Server 2008 SP3 RTM
Microsoft has released the final, RTM version of SQL Server 2008 Service Pack 3. This is build 10.00.5500. It includes...
2011-10-07
1,639 reads
September 2011 SQL Server 2008 Instance Level Diagnostic Queries
Since it is late September, I thought it would be a good time to release an updated set of Diagnostic...
2011-09-27
1,240 reads
SQL Server MVP Deep Dives, Volume 2 Available at PASS 2011 Summit
Volume 2 of the SQL Server MVP Deep Dives book is now available for pre-order from Amazon and from Manning....
2011-09-24
1,923 reads
September 2011 SQL Server 2008 Diagnostic Queries
Its been a couple of months since I have released an updated version of my SQL Server 2008 Diagnostic Information...
2011-09-21
791 reads
Microsoft Releases Two Cumulative Updates for SQL Server 2008
Sticking to their eight week release cycle, Microsoft has released two different Cumulative Updates (CU) for SQL Server 2008. The...
2011-09-20
1,786 reads
Slides For My 24 Hours of PASS Session
The slide deck for my session Hardware 301: Diving Deeper into Database Hardware is available here. There are still twelve...
2011-09-07
574 reads
24 Hours of PASS on September 7
Just in case you forgot, I wanted to remind everyone that the free, 24 Hours of PASS online event starts...
2011-09-06
639 reads
OT: Rant About Mail-in Rebates For Computer Hardware
As you may know from reading my blog, I buy quite a bit of computer hardware components from places like...
2011-09-04
727 reads
Geekbench 2.2 Released
Primate Labs has released Geekbench 2.2.0, which is a free upgrade for Geekbench 2.1.x users. The release notes are here.
Here...
2011-09-01
931 reads
Blogs
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Forums
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Change Tracking Data Retention Options
Comments posted to this topic are about the item Change Tracking Data Retention Options
Requiring Technical Debt Payments
Comments posted to this topic are about the item Requiring Technical Debt Payments
Question of the Day
Change Tracking Data Retention Options
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