Search Results for &#8220;log shipping&#8221;

This week, Brent, Tara, and Richie discuss what they think about having no more service packs for SQL Server 2017 and newer versions, shrinking log files, how many servers can one DBA manage, log backups, mirroring vs Availability Groups vs log shipping, and their next company retreat location. Here’s the video on YouTube: You can…

[Video] Office Hours 2017/09/13 (With Transcriptions)

Last Updated October 7, 2017

Note: this is coming to you from the past due to technical difficulties. This week, Brent and Erik discuss Availability Group issues, database diagram tools, AWS vs Azure, diagnosing async io waits, troubleshooting deadlocks, extended events, using same login credentials for everyone in the company, adjusting and more. Here’s the video on YouTube: You can…

[Video] Office Hours 2017/09/27 (With Transcriptions)

Last Updated October 1, 2017

Backup and Recovery, Breaking News

This week, Richie and Erik discuss altering database columns, separating log files, encryption, NOLOCK issues, developing new skills and experience, troubleshooting deadlocks, Oracle, calling C# method from a stored procedure and the type of headset Erik uses. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to…

Breaking News: Using TDE on 2016? Doing Backups? Time to Patch.

Last Updated September 21, 2017

Brent Ozar

Normally, when you use Transparent Data Encryption (TDE) to secure your database at rest, you can’t get backup compression. Encrypted data basically looks like random data, and random data doesn’t compress well. SQL Server 2016 introduced the ability to compress your TDE databases. Yay! Unfortunately, it has bugs that can leave you unable to restore…

Should You Enforce Foreign Key Relationships in the Database?

Last Updated December 29, 2021

Brent Ozar

Foreign Keys

It’s one of those fierce religious wars that divides families and tears loved ones apart. First, if two tables are related, should we tell SQL Server about it? If SQL Server knows that there’s a relationship, then it can make better decisions when building execution plans. The problem is that SQL Server has to be…

An Expensive Reason To Avoid AGs In Azure

Last Updated August 27, 2017

Always On Availability Groups, Backup and Recovery, CHECKDB and Corruption, Cloud Computing, High Availability, Microsoft Azure, SQL Server

Cash Rules Most people, when they get through paying for Azure, and SQL Server Enterprise Licensing, are left with a hole in their wallet that could only be filled with something that says “Bugatti”, and has a speedometer with an infinity sign at the end. Recently, while working with a client, I found out that…

What If Week: What Would You Add?

Last Updated August 4, 2017

SQL Server

For this week’s What If series, we’re exploring what would happen if you had access to SQL Server’s source code – like if you got a job at Microsoft, signed a partner NDA, if the code leaked, or if it went open source. Today’s question is, “What would you fix or add?” Erik says: Skipping…

Five Mistakes Performance Tuners Make

Last Updated July 27, 2017

Development, Execution Plans, Indexing, SQL Server

There’s no Top in the title And that’s because a TOP without an ORDER BY is non-deterministic, and you’ll get yelled at on the internet for doing that. This is just a short collection of things that I’ve done in the past, and still find people doing today when troubleshooting performance. Sure, this list could…

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

Last Updated August 6, 2017

This week, Brent, Erik, and Richie discuss unit testing, tSQLt, availability groups, duplicate indexes, reporting services 2016 on availability groups, troubleshooting Entity Framework queries, joining views in tables, SQL Server caching issues, and why procedures have plans inside the cache. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or…

What is the biggest mistake you made in production?

Last Updated August 1, 2017

Tara Kizer

SQL Server

This has been blogged before by several people. One thing I’ve learned from Brent is to not let the fact that the topic has been blogged before stop you from blogging about it. With that out of the way… When you have sysadmin access, you are bound to make a big mistake in production at…

Backups: Reading from Databases During Restores

Last Updated March 11, 2021

Store and Restore walk into a Store. Store walks out. Who’s left? Twinkies. They’ll outlive us all. In this video, you’ll learn how to use the Restore command with Standby. It’s fun, I promise. Full Transcript: Hey there, is this thing on? I think it’s on. Better be on, otherwise, I’m just talking to myself…

[Video] Office Hours 2017/07/12 (With Transcriptions)

Last Updated July 17, 2017

This week, Brent, Richie, Erik, and Tara discuss partitioning tables, native backups vs 3rd party agent backups, page life expectancy, query tuning, deadlocks, drawbacks of RCSI, triggers, replication, Always On Availability Groups, and forest fires. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on…

[Video] Office Hours 2017/06/28 (With Transcriptions)

Last Updated July 2, 2017

This week, Erik, Tara, and Richie discuss performance and load testing tools, sysadmin update SQL server restart, defragmenting column store indexes, Amazon Redshift, installing Microsoft updates, Always On Availability Groups, Redgate SQL Clone, as well as their thoughts on the current DBA job market. Here’s the video on YouTube: You can register to attend next week’s Office…

First Responder Kit Release: Weather Is Here, Wish You Were Wonderful

Last Updated July 5, 2017

First Responder Kit

ONE TWO THREE FOUR FIVE SIX SEVEN WHO DO WE APPRECIATE? No one. Appreciate doesn’t rhyme with seven. Special thanks to @JohnKNess, @jsetliffe, @rabryst, @gdoddsy and @SOlsonFAC for various levels of contribution. I’ve made a $10,000 donation in each of your names to the Erik Darling Home For Little Wanderers. Very thoughtful of me. You…

[Video] Office Hours 2017/06/14 (With Transcriptions)

Last Updated June 19, 2017

This week, Brent, Erik, Tara, and Richie discuss setting up an archive process, CTEs vs temp tables, deadlocks, alternatives to replication, Erik and Brent’s pre-con for this year’s PASS Summit, 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 on the go. Enjoy…

[Video] Office Hours 2017/06/07 (With Transcriptions)

Last Updated June 11, 2017

This week, Brent, Erik, and Richie discuss running SQL Server 2017 CTP on Linux, receive side scaling on servers and VMware, query tuning, nested roles vs. assigning roles to users, hierarchical data type, apps and scripts for automating restores, and learning Azure and AWS. The audio’s kinda rough this week because Brent & Erik were…

[Video] Office Hours 2017/05/31 (With Transcriptions)

Last Updated June 3, 2017

This week, Brent and Richie discuss sp_Blitz Backups, change history tracking, exams and certifications, using Azure for DR-only, which version of SQL server to use for a new DB, adding additional data files, load balancing, trace flag 2371, dealing with reporting services, and much more. Here’s the video on YouTube: You can register to attend next week’s…

[Video] Office Hours 2017/05/10 (With Transcriptions)

Last Updated May 13, 2017

This week, Tara and Richie discuss increasing the size of tempdb, splitting database across several files, tracking DML changes to a table, upgrading different versions of service packs, recommendations for improving T-SQL skills, trace flags, replication, Always On Availability Groups, compatibility level of databases, and more… Here’s the video on YouTube: You can register to…

[Video] Office Hours 2017/04/26 (With Transcriptions)

Last Updated April 30, 2017