SSIS – CHECKSUM Transformation
CHECKSUM is a TSQL function that computes a hash value over a list of arguments. The great thing about creating...
2009-01-05
20,731 reads
Blog Posts
The Story of The Aquarium Stand
Last year we acquired a small aquarium for my daughter, and then upgraded to a whopping 10 gallon tank. Turned...
2009-01-05
4,018 reads
DBA Mission and Vision Statement
There is a saying that "The important is often not
urgent and the urgent not important". I could not agree more...
2009-01-03
18,311 reads
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,765 reads
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,409 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
The Large Encoded Value
Comments posted to this topic are about the item The Large Encoded Value
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers