Connecting to a SQL Server instance – Back to Basics
Back to the SQL Server Basics with Wayne
Connecting to a SQL Server instance is one of the first things that...
2018-02-19 (first published: 2018-02-07)
2,877 reads
Blog Posts
Dealing with stress
Anyone who knows me will know that I’m something of a stress head. I tend to worry about things and...
2018-02-19
381 reads
Getting started with the SQLUndercover Inspector
Here is a quick guide to getting started with the SQLUndercover Inspector.
Pre-requisites:
SQL 2012 or higherSQL Server AgentA database to store...
2018-02-19
367 reads
How to create System-versioned temporal tables? – New database feature of SQL Server 2016
Creating a System-Versioned Temporal Table – There are three ways to create a system-versioned temporal table with regards to how the...
2018-02-19
1,169 reads
Moving Lookup Data with ReadyRoll
I’ve been using ReadyRoll for a small project and wanted to move some lookup data. There are some tables where...
2018-02-19 (first published: 2018-02-08)
1,932 reads
SQL Saturday Chicago: I’m speaking
If you’re in Chicago on March 17 and have some free time, why not check out all the cool kids?...
2018-02-19
254 reads
Summary of my Partitioning Series
Partitioning Basics – Part 1 – Creating Partitions
Partitioning Basics – Part 2 – Splitting/Merging Partitions
Partitioning Basics – Part 3 – Switching Data
Partitioning and filegroup restores
Update to...
2018-02-19
447 reads
The default filegroup, and why you should care.
You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index...
2018-02-19
499 reads
Distributing SSH User Keys via PowerShell
Folks in the Linux world are used to moving SSH keys to and from systems enabling password-less authentication. Let’s take a minute to look at what it takes to...
2018-02-18
4 reads
CROSS JOIN for fun
My son, who wishes to be known as “Pigeon” for the duration of this blog, was mixing the names of Hogwarts...
2018-02-17
1,106 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