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,348 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,647 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,247 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,931 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
794 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,796 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
579 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
658 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
734 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
945 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers