PASS Summit 2018 Pre-con: Digital Storytelling with Power BI
Mitchell Pearson, Brian Knight and myself will be presenting a full day pre-con as PASS Summit on Digital Storytelling with...
2018-05-10
741 reads
Blog Posts
PASS Summit Session – On-Prem SQL Servers, Interstellar Performance
I’m very pleased to announce that one of my sessions submitted for this year’s PASS Summit in Seattle, held from...
2018-05-10
253 reads
Reviewing the SQL Server ERROR log
The SQL Server ERROR log is the best source to understand what’s wrong with your SQL Server instance, think this...
2018-05-10
108 reads
SQL Server Partition Swapping
When working with large amounts of data in ETL jobs it can often can sink a lot of time inserting...
2018-05-10
787 reads
Using CAST() function with User-Defined Data Types…Did you know…
I’m converting some Firebird database code to T-SQL and I’m seeing a lot of code that doesn’t work in the...
2018-05-10 (first published: 2018-05-02)
2,905 reads
A big thank you
Thank you! Thank you for reading my blog. Thank you for buying my book. Thank you for attending my sessions...
2018-05-09
247 reads
Changing the location of docker named volumes
A few weeks ago I was presenting at SQL Saturday Raleigh and was asked a question that I didn’t know...
2018-05-09 (first published: 2018-05-02)
1,801 reads
Day 9 Variables
In earlier days we have discussed about providing options with environmental variable and command line, today we will be discussing...
2018-05-09
187 reads
First Wave of Sessions for PASSSummit Now Available
The first wave of sessions for the #PASSSummit have been released. You can see the list at: http://www.pass.org/summit/2018/Learn/ConferenceSessions.aspx
I am honored...
2018-05-09
927 reads
Relaxing on the Tab Management Terraces with #SQLPrompt
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-05-09
1,249 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