Parameterization Part 6: Simple vs. Forced Parameterization
This is the sixth post in the “Parameterization” series. In the previous posts I explained what parameterization is, how plan...
2014-11-27
7,506 reads
Blog Posts
Use -eq in Powershell
I was writing a quick script to work with files and I only wanted to process one file for each...
2014-11-27 (first published: 2014-11-17)
6,039 reads
Audit Database File Size Changes
Recently I shared an article on how to track the growths and shrinks that occur within database files. I shared...
2014-11-26
2,576 reads
Audit Database File Size Changes
If you just so happen to be running on SQL Server 2012 or later, you will need to change your event sessions that were tracking file changes. It is...
2014-11-26
14 reads
Exam Prep 70-463: More about Dimensions
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-11-26 (first published: 2014-11-20)
7,023 reads
How to burn down your house while frying a turkey
It’s an odd query, yes, but in preparation to write this post I actually typed the above phrase into my...
2014-11-26
1,252 reads
SQL Saturday Parma – English Slide decks available to download
My SQL Saturday Parma slide decks are available to download on SlideShare.
The main topic of those presentations is database lifecycle management (DLM)...
2014-11-26
12 reads
Vital Statistics and Health Checks
This post has nothing, absolutely nothing, to do with SQL Server. It does, however, relate to your career as a...
2014-11-26 (first published: 2014-11-17)
6,231 reads
What is Azure Data Factory?
The Azure Data Factory is a service designed to allow developers to integrate disparate data sources. It is a platform...
2014-11-26
2,066 reads
When the Problem is Not Them. It’s You.
Hello Dear Reader! I’ve been the Data Platform Management Lead at Pragmatic Works for almost two years now. It’s been...
2014-11-26
1,251 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