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,844 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
567 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
682 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
755 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,003 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,945 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
823 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
688 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
Creating JSON I
Comments posted to this topic are about the item Creating JSON I
Expensive CPUs
Comments posted to this topic are about the item Expensive CPUs
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers