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,096 reads
Glenn Berry
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,508 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,612 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,845 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,256 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,202 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
967 reads
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
766 reads
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,023 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,481 reads
Blogs
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
The Book of Redgate: Don’t be an a**hole
By Steve Jones
This was one of the original values: The facing page has this text: No...
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Line number in error message doesn't match up with line number in code
Hi everyone I have a 1000 plus line query and I am getting an...
Building a RESTful API with FastAPI and PostgreSQL
Comments posted to this topic are about the item Building a RESTful API with...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers