Search Results for &#8220;direct seeding&#8221;

Always On Availability Groups, Backup and Recovery, SQL Server

I’ll get right to the point While you’re Direct Seeding, you have to be careful with any other full or differential backup jobs running on the server. This is an artifact of the Direct Seeding process, but it’s one you should be aware of up front. In the screencap below, courtesy of sp_whoisactive there’s a…

Availability Group Direct Seeding: TDE’s Frenemy

Last Updated February 9, 2017

Always On Availability Groups, SQL Server

From the Mailbag In another post I did on Direct Seeding, reader Bryan Aubuchon asked if it plays nicely with TDE. I’ll be honest with you, TDE is one of the last things I test interoperability with. It’s annoying that it breaks Instant File Initialization, and mucks up backup compression. But I totally get the…

Availability Group Direct Seeding: Extended Events and DMVs

Last Updated February 9, 2017

Always On Availability Groups, SQL Server

As of this writing, this is all undocumented I’m super interested in this feature, so that won’t deter me too much. There have been a number of questions since Availability Groups became a thing about how to automate adding new databases. All of the solutions were kind of awkward scripts to backup, restore, join, blah…

Availability Group Direct Seeding: How to fix a database that won’t sync

Last Updated February 9, 2017

Always On Availability Groups

This post covers two scenarios You either created a database, and the sync failed for some reason, or a database stopped syncing. Our setup focuses on one where sync breaks immediately, because whatever it’s my blog post. In order to do that, I set up a script to create a bunch of databases, hoping that…

SQL Server 2016: Availability Groups, Direct Seeding, and You.

Last Updated February 9, 2017

Always On Availability Groups, SQL Server

One of my least favorite things about Availability Groups Well, really, this goes for Mirroring and Log Shipping, too. Don’t think you’re special just because you don’t have a half dozen patches and bug fixes per CU. Hah. Showed you! Where was I? Oh yeah. I really didn’t like the backup and restore part. You…

[Video] Office Hours 2018/7/18 (With Transcriptions)

Last Updated July 22, 2018

Pavel Amelishko

Videos

This week, Brent, Erik, and Tara discuss their SQL server specialization, CPU-ready time, making SSIS changes globally rather than one at a time, creating an Always On AG farm, Azure managed instances, going from log shipping to Availability Groups, tracking folks that executed queries, moving databases into Availability Groups, an exciting update to SQL Server…

[Video] Office Hours 2018/4/18 (With Transcriptions) with Special Guest Drew Furgiuele

Last Updated April 21, 2018

Videos

This week Drew Furgiuele joins Brent and Richie to discuss patching, job interview suggestions, using PowerShell to solve various SQL Server issues, roles and responsibilities of a SQL or a database architect, enabling query store on production servers, SARGability, moving SSRS from the main production server, tempdb issues, Availability Groups troubleshooting, Drew’s upcoming Powershell class,…

Azure SQL Managed Instances Brain Dump on CPU, Memory, HA/DR, and Backups

Last Updated February 27, 2019

Managed Instances

Normally when we write blog posts, we try to explain something or tell a story. If you’re looking for a solid educational post, stop here, mark this one as read, and go on about your day. This post is just a brain dump of unorganized notes from our experimenting with Azure SQL DB Managed Instances…

[Video] Office Hours 2017/08/30 (With Transcriptions)

Last Updated September 5, 2017

SQL Server, Videos

This week, Brent, Erik, and Richie discuss Availability Groups, versions of sp_BlitzIndex™, SQL Server installation issue, backing up SSRS reports, SQL Server on Linux, failovers, detaching/attaching databases, extended events, career progression of a DBA, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen…

The Brighter Side of SQL Server’s future

Last Updated November 22, 2016

SQL Server

Believe it or not, I sometimes like things SP1 for 2016 has a bunch of cool new tricks: I’m pretty psyched on the Wait Stats stuff in actual execution plans. I hope it eventually comes in some form to cached plans, or at least Query Store plans, but this is a good start! Even if…

[Video] Office Hours 2016/08/10 (With Transcriptions)

Last Updated August 14, 2016

SQL Server, Videos

This week, Brent, Richie, Erik, and Tara get together in Round Rock, TX, for Dell DBA Days, to talk through your SQL questions and answers. They discuss what they are working on at Dell during the event, as well as Windows Kerberos and NTLM Authentication, Always On Availability Groups, Microsoft’s Document DB, automating restore databases…

[Video] Office Hours 2016/06/29 (With Transcriptions)

Last Updated July 2, 2016

SQL Server

This week, Erik, Richie, Doug, and Angie discuss a script for getting more information on a specific index, using partition tables, shrinking data and log files, stress testing SQL servers, as well as some entertaining things to ask Siri! Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to…

[Video] Office Hours 2016 2016/06/01 (With Transcriptions)

Last Updated June 10, 2016

SQL Server, Videos

This week, Brent, Angie, Erik, Tara, Jessica, and Richie discuss SSMS issues, security auditing, snapshot replication, SSIS Cache Connection Manager, AlwaysON Availability Groups, deadlocks, and Jessica’s trip to Mexico. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Office Hours Webcast – 2016-06-01…

Download the Current Stack Overflow Database for Free (2021-02)

Last Updated June 17, 2021

Stack Overflow

Stack Overflow, the place where most of your production code comes from, publicly exports their data every couple/few months. @TarynPivots (their DBA) tweets about it, and then I pull some levers and import the XML data dump into SQL Server format. Stack Overflow’s database makes for great blog post examples because it’s real-world data: real data…

How to Restore a SQL Server Database into Azure SQL DB Managed Instances

Last Updated March 16, 2018

Backup and Recovery, Managed Instances, Microsoft Azure

You’ve built your first Managed Instance, and now you wanna play around with real live data. You’re going to need a backup in the cloud to do it – SSMS doesn’t have a drag-and-drop option. Big picture, here’s what we’re going to do: Set up a container in the cloud to hold our backups In…

New Wait Stats and DMV Columns in SQL Server 2017

Last Updated October 2, 2017