Where’d the Data Go?
The Reported Problem
A few weeks ago I was contacted by a former employer because an SSRS report I had written...
2009-12-17
403 reads
Blog Posts
Machine SID Doesn’t Matter
Ran across this post from Mark Russinovich titled The Machine SID Duplication Myth that seems to debunk the idea that...
2009-12-16
780 reads
My Greatest Weakness
I was tagged by Mike Walsh in the latest meme to circle the SQL Server community, which is what is...
2009-12-16
1,631 reads
Netbook – Finding a GB
I turned on my netbook for the first time in a few weeks recently. My laptop had died, and I...
2009-12-16
729 reads
Remove Replication:
Its quite some time that I blog… but good news is I have some good stuff to blog on… so...
2009-12-16
12,461 reads
Someone Needs an Order BY
I was checking on the status of my laptop the other day. It died and I shipped it back to...
2009-12-16
960 reads
SQL Saturdays and other events in 2010
It seems that the SQL community is really growing. There are now quite a few events that you can attend...
2009-12-16
989 reads
SQLSaturday #37 in Philadelphia Announced
SQLSaturday #37 will be held March 13, 2010 at Mandeville Hall, St. Joseph's University, 5600 City Line Ave, Philadelphia, PA....
2009-12-16
556 reads
Updated SQL Server 2008 Diagnostic Queries
Here is the mid-December version of my diagnostic queries for SQL Server 2008. The idea here is to be able...
2009-12-16
979 reads
Forging a Strong Team
Each year I attend an annual Christmas party that’s essentially a JD Edwards Operations department party. JD Edwards hasn’t existed...
2009-12-15
712 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
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
The Side Job
Comments posted to this topic are about the item The Side Job
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