SQL 2008 Row and Page compression – or SQL 2005 (post SP2) vardecimal conversion
One of the great new features in SQL 2008 is Row and/or Page Compression. Plus, still good news for those...
2009-01-02
1,766 reads
Blog Posts
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...
2009-01-01
1,989 reads
Meeting Goals
I'm not a big goals person. I think it's a good idea to set goals, and they can help you,...
2009-01-01
446 reads
MVP 2009
I was re-awarded MVP status from Microsoft for 2009. Since I didn’t hear anything to the contrary in the last...
2009-01-01
454 reads
MVP Award
Received my notification via email this morning that I've been recognized as a Microsoft MVP for SQL Server. It's been...
2009-01-01
736 reads
PASS Update #1
As many of you know I'm joining the PASS Board of Directors for a two year term beginning yesterday. I'm...
2009-01-01
381 reads
Thoughts for 2009
Only a few changes planned for this coming year to the blog (so far), none of them huge:
I plan to...
2008-12-31
1,411 reads
Another Use of XML
XBRL is yet another use of XML, this time for financial reporting. It is supposed to be in place for...
2008-12-30
1,723 reads
End of 2008 Wrap Up Post
Something new for the end of the year - a recap of everything I posted for 2008. 303 posts if the...
2008-12-30
1,542 reads
SQL Server 2005 SP3 - Released! - quick Info
Till know everyone has the information for the SQL Server 2005 SP3 for all versions!
Download info here
What's new in SP3!...
2008-12-30
1,428 reads
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers