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,968 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,874 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,928 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,107 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,513 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,622 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,854 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,272 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,211 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
982 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers