Compression
SQL Server 2008 brings with is a new set of features involving compression. At first I was assuming this was...
2008-03-03
1,834 reads
Blog Posts
The Fun of Blogs
If you look at my blog roll Jeff Dunntemann is one of the ones recommend. Nothing about SQL Server there, but he...
2008-03-03
365 reads
SQL 2008 Schedule Slippage and SQL 2005 SP3
I've read with interest some of Steve's editorials about SQL 2005 SP3 and in large part agree with him that...
2008-03-02
596 reads
Documentation Value Formula (Part I)
As a DBA, documentation work is unavoidable, we need to do documentation about things we have done, for example, what...
2008-03-01
1,066 reads
New DBA type: Test DBA
In DBA world, usually two types of DBA are defined depending on what a DBA is focusing on, i.e. development DBA...
2008-02-29
1,887 reads
New Benchmarks
There are new TPC-E benchmarks available for SQL Server 2008. And it's not even out!!!!
The 3rd place, the IBM entry,...
2008-02-28
1,479 reads
Notes From My Visit with the Charlotte SQL Group
I'm headed back to Orlando after a quick trip to Charlotte. Flew in yesterday and spent some time with my...
2008-02-28
1,295 reads
Snapshots Part 1 Published on SSC
Snapshots Part 1 covers the basics of doing a snapshot regardless of what type of replication is being used. In...
2008-02-26
1,249 reads
The Launch
The launch event is tomorrow in LA and I'm not going, and find myself a little disappointed. There will be...
2008-02-26
1,392 reads
Using TripIt for Travel Plans
Not a SQL related topic today.
I first noticed Tripit on Joels Blog and so far it solves a problem I've...
2008-02-26
1,288 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers