Finding SQL Server Client Ports
I saw a post recently asking if there was an easy way to find the port a client was using...
2010-06-17
1,557 reads
Blog Posts
Important: System Objects/Views/DMV/DMF
Important: System Objects/Views/DMV/DMF This is the some of the list of System Objects/Views/DMV/DMF. Catalog View: All system information is stored...
2010-06-17
1,009 reads
Notes from the June 2010 oPASS Meeting
We had adjusted our meeting date to work around previous commitments for both Jack Corbett and I, and that may...
2010-06-17
541 reads
PASS Update #33
It’s been almost a month since my last update, too long! I’ve put up separate posts on my unplanned and...
2010-06-17
700 reads
Strange but True: Reporting Off of Cubes with Parameters Creates Hidden Datasets
I know, it is strange, but it is true...When you create Reporting Services reports that run off of an Analysis...
2010-06-17
994 reads
What is the Ideal SQL Server Test Box?
I’m thinking about setting up a SQL Server test box in my home office for doing some extensive, real-world SQL...
2010-06-17
418 reads
24 HOP Available
Just a quick note. PASS has made the 24 Hours of PASS available via streaming video. You can check it...
2010-06-16
465 reads
24 Hours of PASS Recordings Now Available
Our most recent 24 Hours of PASS celebrated the SQL 2008 R2 launch. 24 great sessions, 23 of which were...
2010-06-16
584 reads
A Strange Twist in my life
As the plane was landing the other day for SQL Saturday in Pensacola, I was struck by how amazing my...
2010-06-16
796 reads
Daily SQL Server 2008 New Feature – Day 24
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-16
381 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