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,080 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,791 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,839 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
564 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
680 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
752 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
999 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,934 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
821 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
686 reads
Blogs
Github Copilot in SSMS can include data in its memory, simple prompt injections ahead
By Ed Elliott
SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Logged in as a member of an Azure AD Group Error while Deploying DACPAC
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Forums
Don't Create Workslop
Comments posted to this topic are about the item Don't Create Workslop
What is the original database name?
Comments posted to this topic are about the item What is the original database...
The DBScan algorithm tutorial
Comments posted to this topic are about the item The DBScan algorithm tutorial
Question of the Day
What is the original database name?
What is returned when this code is run?
SELECT ORIGINAL_DB_NAME()See possible answers