PASS Summit 2013 – Day 3: Query Tuning, Memory Internals, SSIS and PowerShell
This is actually the first formal day of the PASS Summit, but it’s my third day here. I have already...
2013-10-17
389 reads
Guy Glantser
PASS Summit 2013 – Day 2: The PASS Spirit
This is my second day into the PASS Summit 2013, and the excitement is still rising. My first day was...
2013-10-16
390 reads
PASS Summit 2013 – My First Day and Paul White
This is my first time to attend the PASS Summit. I was very excited about it, and I planned to...
2013-10-15
316 reads
How Much Unallocated Space do I Have in My Database Files
In a previous post, I wrote about when and how to shrink your database files. The bottom line was that...
2013-08-13
2,342 reads
My Summary of 24 Hours of PASS
Once a year, just before the annual PASS Summit, there is a promotional event called 24 Hours of PASS. The...
2013-08-05
437 reads
When and How to Shrink Your Database
Most DBAs know that shrinking a database is a bad thing. But in many cases, there is no DBA around,...
2013-08-01
604 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