Azure Data Architecture Guide (ADAG)
The Azure Data Architecture Guide has just been released! Check it out: http://aka.ms/ADAG
Think of it as a menu or syllabus for...
2018-02-15
121 reads
Blog Posts
Backups of backups or How long is my backup really available?
I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important,...
2018-02-15 (first published: 2018-02-07)
1,811 reads
Enabling Guest in a Database–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-02-15
1,402 reads
Getting Your SET Options
Have you ever used @@options? I haven’t typically needed this, but there are times that you might wonder what options...
2018-02-15 (first published: 2018-02-06)
2,185 reads
Bloggers Should Have Reach
One of my goals for 2018 is to expand the reach of my blog.
As a blogger starting out I had...
2018-02-14
317 reads
Join me for Masking, Privacy, Protection, and Clones at SQL in the City Feb 28
Registration is open for SQL in the City 2018. Our first event is Feb 28 and I’ll be heading back...
2018-02-14
358 reads
Migrating or Recovering a TDE protected Database
When encrypting a database with Transparent Data Encryption(TDE), a vital consideration is to make sure we are prepared for the...
2018-02-14
524 reads
Performance Basics: Key lookup operator and query optimization
One of the most basic things to improve performance in our queries is using indexes, but this doesn't mean that...
2018-02-14
545 reads
Wait Statistics on a Query
Wait statistics are a vital part of understanding what is causing your system to run slowly. Capturing them can be...
2018-02-14 (first published: 2018-02-05)
2,709 reads
Waiting Tasks Reveal Pain Points
Waiting tasks quickly shows you where to look for the bottlenecks. This is only one of the many times that I...
2018-02-14 (first published: 2018-02-06)
2,780 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