Adding a VLDB database to an SQL Server Availability Group
Recently, I was tasked with making an 60TB database highly available by adding it to an availability group. The following,...
2015-08-26 (first published: 2015-08-18)
2,083 reads
John Sterrett
Converting identifiers into SQL Server table variables in Management Studio
If I had a nickel for every time someone gave me a list of identifiers and asked me to pull...
2015-04-20 (first published: 2015-04-09)
5,792 reads
Free Video for Accidental DBA’s
Recently, Mike Walsh and John Sterrett teamed up with Embarcadero to give a 60 minute presentation focusing on the skills...
2015-02-18
1,843 reads
Building Your First Windows Azure Machine
Recently, I had the pleasure of writing another article that was included the Notes From the Field series that is hosted...
2014-12-17
566 reads
Get A Free SQL Server 2014 Book!
I have some great news to share. One of my bucket list items is to be a published author. I...
2014-10-02
681 reads
Unplanned Availability Group Failover
Whenever a disaster occurs it will be a stressful scenario regardless of how small or big the disaster is. This gets multiplied...
2014-06-09
754 reads
Learn High Availability and Disaster Recovery with SQL Server in a Day!
If you are near Pittsburgh, PA on May 22, 2014 catch the following all-day training session from 8:30 AM to 4:00...
2014-04-23
1,002 reads
Where is my Availability Group?
In SQL Server 2012 we got this great new high availability feature called availability groups. With readable secondaries under the...
2014-03-21 (first published: 2014-03-18)
2,940 reads
T-SQL Tuesday #50: Automation for LazyDBAs!
T-SQL Tuesday is a monthly blog party hosted by a different blogger each month.
T-SQL Tuesday 50 – Automation
This blog party was...
2014-01-14
822 reads
Throwback Thursday #3: SQL Server & Disks
I hope everyone is having a good time gearing up for the holidays. Throwback Thursday is a bi-weekly blog series where...
2013-12-12
687 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