Presenting Hardware 301 at 24 Hours of PASS on September 7
PASS just announced today the next occurrence of 24 Hours of PASS (24HOP), which is called the Summit Preview version....
2011-08-03
769 reads
Glenn Berry
August 2011 SQL Server 2008 Instance Level Diagnostic Queries
Since it is August 1, 2011 (which is also my birthday), I thought it would be a good time to...
2011-08-01
1,026 reads
SQL Server Hardware Book News and Reviews
Today was an exciting day, since I discovered that fellow SQL Server MVP Brent Ozar (Blog|Twitter) had posted a very...
2011-07-29
1,483 reads
Some Common Disk Drives Compared
Since I talked about how wonderful the newer Western Digital Black 6Gbps SATA III hard drives are a couple of...
2011-07-27
1,116 reads
Leaked Information About AMD Opteron 6200 Series Processors
CPU World has a post about some leaked info regarding the upcoming Opteron 6200 series “Bulldozer” processor line. Here are...
2011-07-26
1,031 reads
Building or Buying a High Performance, Low Cost Desktop Machine for SQL Server Development and Testing
There was a lengthy discussion on Twitter this morning, where one of my friends, Grant Fritchey (Twitter) was asking the...
2011-07-24
1,730 reads
Microsoft SQL Server 2008 SP2 Cumulative Update 5 Released
Microsoft has released Cumulative Update 5 for SQL Server 2008 Service Pack 2. This CU has ten fixes listed in...
2011-07-18
1,576 reads
SQL Server 2008 R2 Service Pack 1 Released
Microsoft has finally (after releasing the CTP version way back in April) released the final, gold build of SQL Server...
2011-07-12
2,642 reads
Teaching Transact-SQL at University of Denver, University College
Starting this week on Wednesday night, I will be teaching a special five-week condensed version of ICT 4462, Transact-SQL Programming...
2011-07-12
613 reads
July 2011 Version of SQL Server 2008 Diagnostic Queries
Since July is only one day away, its time for the updated version of my SQL Server 2008 Diagnostic Information...
2011-06-30
1,635 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