Search Results for “mirroring”

[Video] Office Hours 2016 2016/05/04

Last Updated May 8, 2016

This week, Richie, Erik, Angie, and Tara discuss deadlocks, replication, SQL Server 2016 features, 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. Transcript: Does NVARCHAR(255) Cost More Than NVARCHAR(30)? Angie Walker: All right. So Steve has a nvarchar(255) column that…

[Video] Office Hours 2016 2016/04/27

Last Updated June 7, 2020

Brent Ozar Unlimited Team

SQL Server, Videos

This week, Brent, Erik, Jessica, Angie, and Tara discuss SQL service packs, partial restores, breaking replication, backups, as well as their favorite TV shows. 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. If you prefer to listen to the audio: Transcript:…

One weird trick for managing a bunch of servers

Last Updated April 28, 2016

Erik Darling

SQL Server

Let’s face it, most people don’t have just one SQL Server How many they tell Microsoft they have is another matter, but let the record show that I don’t condone licensing dishonesty. But going one step further, most places… Well, they’re ‘lucky’ if they have one DBA, never mind a team. Everyone else: Give me…

When Should You Hire a Consultant for Amazon RDS?

Last Updated February 9, 2017

Brent Ozar

Amazon Web Services (AWS), SQL Server

Powered By Somebody Else’s Database on Somebody Else’s Computer You’re hosting your SQL Server databases in Amazon RDS, and performance has been getting slower over time. You’re not sure if it’s storage IOPs, instance size, SQL Server configuration, queries, or indexes. What’s the easiest way to find out? Ask a few questions: Are you using…

[Video] Office Hours 2016/04/20 – Now With Transcriptions

Last Updated April 9, 2017

Brent Ozar

SQL Server, Videos

This week, Brent, Erik, Jessica, Richie, and Tara discuss database modeling tools, how to learn about database corruption, the new cardinality estimator, and the only question that will be on our certification exams. 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. What ERD Tool…

SQL Server 2005 support ends next week. Here’s my tribute to it.

Last Updated February 13, 2017

Brent Ozar

Humor, SQL Server

I remember the first time I used SQL Server 2005. Did you know SQL Server has an expiration date on the bottom of the box? Also, this one is curdled. I was a database administrator working on a new-build data warehouse project in Miami. Both our data warehouse and SQL Server 2005 were looking like…

Microsoft SQL Server is Coming to Linux.

Last Updated February 9, 2017

Brent Ozar

Licensing, SQL Server

Two things: SQL Server is coming to Linux, and no, this isn’t April 1st, although the meeting minutes kinda read that way. Let’s zoom back for a second: if you want to expand an existing business, you have two good options: Sell a new product to your existing customers Sell your existing product to new customers For years,…

My Favorite System Column: LOG_REUSE_WAIT_DESC

Last Updated February 9, 2017

Brent Ozar

Backup and Recovery, SQL Server

Hidden away in master.sys.databases is one of the coolest diagnostic tools you might ever need: Transact-SQL SELECT name, log_reuse_wait_desc FROM sys.databases; 1 SELECT name, log_reuse_wait_desc FROM sys.databases; This spiffy little snippet will tell you why each database’s log file isn’t clearing out. Possible reasons include: Log backup needs to be run (or if you could…

Moving Databases with ALTER DATABASE

Last Updated February 18, 2016

Erik Darling

SQL Server

True story A long time ago, I had to actually do stuff to databases. One thing I had to do was move data files around. Maybe some knucklehead had put system databases on the C: drive, or a LUN was filling up, or we got a new LUN. You know, whatever. Natural curiosity oft leads…

What Is a Staging Environment and How Do You Build One?

Last Updated December 9, 2018

Brent Ozar

Architecture, SQL Server

If you’re a full time production database administrator, you need a staging environment. This is where you test infrastructure tasks like failing over mirroring, doing a disaster recovery role swap, cluster quorum changes, log shipping configuration, and patching. You need to test this stuff repeatedly so that when you’re under pressure in the production environment, you…

What’s Covered in the Senior DBA Class of 2016?

Last Updated April 9, 2017

Brent Ozar

SQL Server

You’re a SQL Server DBA who is ready to advance to the next level in your career but aren’t sure how to fully master your environment and drive the right architectural changes. That’s about to change in one week of learning and adventure with me, Brent Ozar. Join me to learn how size, architect, maintain, and troubleshoot…

Trace Flag 2330: Who needs missing index requests?

Last Updated February 13, 2017

Erik Darling

Bad Idea Jeans, Indexing, SQL Server

Hey, remember 2005? What a great year for… not SQL Server. Mirroring was still a Service Pack away, and there was an issue with spinlock contention on OPT_IDX_STATS or SPL_OPT_IDX_STATS. The KB for it is over here, and it’s pretty explicit that the issue was fixed in 2008, and didn’t carry over to any later…

Why Nobody Ever Patches Their SQL Servers

Last Updated April 17, 2018

Brent Ozar

Always On Availability Groups, Processes and Practices, SQL Server

I saw a DBA.StackExchange.com question and had to laugh out loud: “Is there a cool way of performing CU updates for SQL Server on hundreds of machines?” Patching got me like No, and it has nothing to do with technology. Which servers are mission-critical 24/7 and can’t go down? Which servers can only be taken down…

I’m Presenting at kCura Relativity Fest 2015 in Chicago

Last Updated February 9, 2017

Brent Ozar

kCura Relativity, SQL Server

This sounds really cheesy, but I’m honestly excited to be presenting again this year at kCura Relativity Fest 2015. Here’s what I’ll be talking about: How to Check Your SQL Server’s Health The Abstract: You’re a system or database administrator responsible for the uptime and performance of Relativity’s SQL Servers, but you’ve never received professional…

The Easiest Way to Restore Transaction Logs to A Point In Time (Spoiler: Use AmazonRDS)

Last Updated February 13, 2017

Kendra Little

Amazon Web Services (AWS), SQL Server

… is to use a SQL Server where a robot does it for you! Let’s take a look at how you can do this in AmazonRDS’s hosted SQL Server these days. Normally, restoring transaction logs is super tedious. You’ve got to restore all the files in the right order, for every single database. Even if…

Why Zero Data Loss in SQL Server is Harder Than You Think

Last Updated April 9, 2017

Kendra Little

Architecture, High Availability

But Kendra, it can’t be that hard… after all, we have synchronous modes in Database Mirroring and Availability Groups, right? Synchronous Commit doesn’t mean “zero data loss” When we think about limiting data loss, the first thing we think of is a technology that lets us reduce points of failure. If every transaction must be…

How to Set Up Standard Edition Always On Availability Groups in SQL Server 2016

Last Updated March 5, 2017

Brent Ozar

Always On Availability Groups, SQL Server

191

SQL Server 2016 adds Availability Groups in Standard Edition. While the licensing details can obviously change right up to release date, here’s what was announced at the Ignite conference: Limited to two nodes only (a primary and a secondary) Like mirroring, you can’t read from the secondary, nor take backups of it But like database…

Moving Databases Made Easy – SQL Server on a File Share

Last Updated February 13, 2017

Jeremiah Peschka

Storage

We’ve all had to move a database. For databases above a small size, this is a painful process. While there are a number of ways that you can move a database without downtime, they all involve a lot of extra work. What if there were something easier? Every database is unique and precious. What’s the…

Always On Availability Groups FAQ

Last Updated August 23, 2021

Brent Ozar

Always On Availability Groups

Here are some of the Always On Availability Groups questions I get the most often: Q: How much network bandwidth will I need? For a really rough estimate, sum up the amount of uncompressed transaction log backups that you generate in a 24-hour period. You’ll need to push that amount of data per day across the…

The Hard Truth About Patching SQL Server Availability Groups (Hotfixes, Cumulative Updates, and Service Packs)

Last Updated September 21, 2017

Kendra Little

Always On Availability Groups, Breaking News

Whoa, be careful with that fix As a DBA, you’re responsible for identifying necessary updates to keep your SQL Servers healthy. Your business may have some mandates about the frequency of patches, but even if they don’t, you have a duty to look out for Cumulative Updates, Service Packs, and out of band hotfixes that can prevent…

Search Results for “mirroring”

Hi! I’m Brent Ozar.