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,340 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,641 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,241 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,929 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,790 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
575 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
642 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
728 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
936 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers