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,963 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,853 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,918 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,096 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,509 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
Blogs
App-Consistent MongoDB Snapshots Across Multiple Pure Storage FlashArrays
Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage...
PASS: Quantum Computing Slides
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
A New Word: Dead Reckoning
By Steve Jones
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...
Forums
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Is Data Modeling Common?
Comments posted to this topic are about the item Is Data Modeling Common?
Getting The Database Name
Comments posted to this topic are about the item Getting The Database Name
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers