SQL Server Hardware Choices Made Easy
Redgate has released a free eBook that I wrote called SQL Server Hardware Choices Made Easy. This is basically a...
2011-08-29
1,965 reads
Glenn Berry
New Dell Precision M4600 Mobile Workstation
After a very long wait, I finally received my new company laptop this past week, which is a very fast...
2011-08-28
1,859 reads
A Couple of Data Compression Tricks in SQL Server 2008
As I have said several times before, I am a big fan of data compression in SQL Server 2008 and...
2011-08-23
1,922 reads
SQL Server 2008 R2 RTM Cumulative Update 9
Microsoft has released Cumulative Update 9 for SQL Server 2008 R2 RTM, which is Build 10.50.1804.0. I count 26 fixes...
2011-08-19
2,097 reads
SQL Server 2008 R2 SP1 Cumulative Update 2
Microsoft has released SQL Server 2008 R2 SP1 Cumulative Update 2, which is Build 10.50.2772.0. I count 14 fixes in...
2011-08-16
1,511 reads
Gradually Deleting Data in SQL Server
If you have a situation where you have a very large table in SQL Server, where you need to periodically...
2011-08-13
1,614 reads
Configuring, Benchmarking and Validating an I/O Subsystem for SQL Server, Part 1
One of the main projects I have been working on lately is designing and implementing a completely new data and...
2011-08-12
1,848 reads
Microsoft SQL Server Denali CTP 3 Product Guide
Microsoft has released a Product Guide for SQL Server Denali CTP3, which has datasheets, white papers, technical presentations, demonstrations, and...
2011-08-12
1,258 reads
Corsair 16GB Flash Voyager GT USB 3.0 Review
I bought a little Corsair Flash Voyager USB 3.0 16GB USB Flash Drive at Micro Center yesterday, since most of...
2011-08-11
2,205 reads
Two New TPC-E Submissions
Two new TPC-E OLTP Benchmark Submissions have shown up in the last month or so since I last recapped three...
2011-08-05
970 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