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,986 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
445 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
453 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
735 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
380 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,410 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,722 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,541 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 Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers