Subscribe to this blog
Archives: January 2009
All the Aggregate Data you Crave with Grouping Sets in SQL Server 2008
As reporting requirements increase, it seems that aggregate functions have thankfully risen to the occasion concurrently. To maintain its competitive edge as Staples' best Canadian vendor, BaldGorilla, where I’m consulting actually, has been able to fulfill the most demanding deadlines thanks to the query results produced from Grouping Sets. … Read more
2 comments, 800 reads
Posted in The Database Hive for SQL Server DBAs on 28 January 2009
It's Minus Twenty-Five Outside and I'm Writing about Transaction Log Files
(1linerForward) I originally wrote this in French while working at LaCaisse.com - http://dbhive.blogspot.com/2008/07/fichiers-journaux-de-transactions.html
Why do you care, as a DBA, or a Developer for that matter, about what is happening in the Transaction Log? Lets rollback a little and see... The raison d’être of a transaction log file is to… Read more
6 comments, 1,712 reads
Posted in The Database Hive for SQL Server DBAs on 17 January 2009
SQL 2008 Row and Page compression – or SQL 2005 (post SP2) vardecimal conversion
3 comments, 424 reads
Posted in The Database Hive for SQL Server DBAs on 2 January 2009
How Certification Can Help You Stay Current with Technology, as well as Continuing Your Education
If you'd like to keep up with your profession as a SQL DBA, I thoroughly recommend certification. It has certainly given me an edge with respect to several mandates over the past seven years, and even at the least, a decent boost of confidence with respect to being able to… Read more
0 comments, 484 reads
Posted in The Database Hive for SQL Server DBAs on 1 January 2009