Search Results for “mirroring”

How to Rehearse a Presentation

Last Updated December 1, 2012

Buck Woody (Blog – @BuckWoody) and I did a presentation at the PASS Summit called, “You’re Not Attractive, But Your Presentations Can Be.” The audience asked a lot of good questions, and I wanted to recap some of ’em as blog posts. The first one – and one of the most frequent questions I get…

SQL Server 2012 AlwaysOn Availability Groups Rock

Last Updated February 9, 2017

Brent Ozar

Always On Availability Groups

105

SQL Server 2012 brings huge improvements for scaling out and high availability. To put these changes into perspective, let’s take a trip down memory road first and look at the history of database mirroring. SQL Server 2005 first introduced mirroring, although it wasn’t fully supported until a service pack. In many ways, mirroring beat the…

Telling Clients They’re Unusual

Last Updated February 12, 2017

Brent Ozar

Professional Development

Consultants need to get around. One of the key differences between consultants and contractors is that contractors tend to stay at the same company for weeks or months, while consultants jump around very quickly from project to project. Most of my engagements are just 3-4 days long: I parachute in, put out the burning fires,…

How to Buy Your First Mac

Last Updated February 13, 2017

Brent Ozar

Hardware

So you’re tired of craptastic plastic, and you’re noticing more and more Windows people toting around shiny metal computers? Here’s what you need to know. Update October 2013 – updated to include the current Apple laptop lineup. Running Windows On Your Mac If you’re reading this, you probably make a living working with Windows software,…

Sessions I Submitted for the PASS Summit

Last Updated February 12, 2017

Brent Ozar

#SQLPass

Every year, the Professional Association for SQL Server (PASS) holds an international Summit. This year it’s Monday, November 8th through Thursday, November 11th in Seattle, Washington. Anyone can submit sessions to present. If your session is accepted, you get a free registration, saving you around $2,000. Even if you’re not planning on going to the…

SQL Server 2008 R2 Release Date: April 21 2010

Last Updated November 7, 2021

Brent Ozar

SQL Server

The SQL Server 2008 R2 release date was April 21, 2010. You can download SQL Server free as an evaluation version. I’ve written a lot about the new features: SQL Server 2008 R2 Pricing and Feature Changes – the pricing is going up, but you get new features in Standard Edition. SQL Server 2008 R2:…

Fusion-IO ioDrive Review

Last Updated February 13, 2017

Brent Ozar

Storage

Solid state drives (SSDs) have gotten a lot of press because they can be dramatically faster than magnetic hard drives. They use flash memory instead of spinning magnetic platters. Since any bit of memory can be accessed at any time without moving a hard drive’s head around, SSD random access is insanely fast. Fusion-IO ioDrive…

Microsoft #MVP10 Summit Recap

Last Updated February 23, 2010

Brent Ozar

Every year, Microsoft hosts an MVP Summit event at Microsoft headquarters in Redmond, Washington. MVPs pay their own airfare to get to the event, but once you’re there, Microsoft picks up the tab for food & hotels. MVPs have to share a room, and I think that’s fine because it emphasizes the community portion of…

SQL Azure Frequently Asked Questions

Last Updated March 13, 2018

Brent Ozar

Microsoft Azure

On Monday 2/1, SQL Azure goes commercially live. Microsoft’s charging for service now, and that means it’s officially official. I talk to a lot of enterprise DBAs, project managers, and developers about SQL Server in the cloud. Here’s some of the questions I get asked most often. What is SQL Azure? SQL Azure is Microsoft’s…

Designing a Recovery Strategy for StackOverflow

Last Updated February 13, 2017

Brent Ozar

Backup and Recovery, Stack Overflow

When I design a backup & recovery strategy for a database, I don’t talk to the developers, database administrators, or systems administrators first. The first people I go to are the business managers, and I ask three questions: How much money would you lose if you lost the data altogether? How much money would you…

Microsoft SQL Azure: The Flat Pack Database

Last Updated February 13, 2017

Brent Ozar

Microsoft Azure

Erika’s friends call her “Fancy Feast” because she only likes the best things in life. She’s got champagne tastes, but we can’t afford to buy the best of everything. I recently picked up a coffee table from Ikea, and it got me thinking about SQL Azure.

In a perfect world, I’d have on-premise SQL Server for every database. I’d use cutting-edge storage and cluster everything. But this isn’t a perfect world…

Using SQL Server Without Monitoring Software is Like Overdriving Your Headlights

Last Updated July 28, 2021

Brent Ozar

Monitoring, Wait Stats

The strength of your car’s headlights, the speed of your reactions, and the power of your brakes determine how fast you can drive safely at night. Likewise, in SQL Server, we need to see down the road before disaster strikes, and react as quickly as possible.

How to BACKUP LOG WITH TRUNCATE_ONLY in SQL Server 2008, R2, 2012, 2014, 2016, 2017, 2019

Last Updated February 17, 2020

Brent Ozar Unlimited Team

Backup and Recovery

BACKUP LOG WITH TRUNCATE_ONLY is a dangerous command: it empties out the contents of your SQL Server’s transaction log without really backing it up. Database administrators sometimes run this command right before shrinking their log file with a DBCC SHRINKFILE command, thereby freeing up drive space. Why ‘truncate_only’ is not a recognized backup option. When…

Blog Quiz from Chris Shaw

Last Updated August 11, 2009

Brent Ozar

Today’s quiz from Chris Shaw is a two-parter, and for once in a web quiz, the second part really is a quiz. 1. Do you feel that you have a reliable SAN solution? If so, what’s the secret? Your SAN Admins The key to getting a reliable SAN solution that no human being can mess…

SQL Azure Pricing: $10 for 1GB, $100 for 10GB

Last Updated February 13, 2017

Brent Ozar

Microsoft Azure

Microsoft’s pricing for SQL Server in the cloud, SQL Azure, has been announced. It’s free for now, but around November it’ll be: $9.99 per month for 0-1GB $99.99 per month up to 10GB SQL Azure There’s currently a 10GB maximum size cap for SQL Azure. For larger data storage needs, you’ll need to break the…

I’m Going to Disn-errr, #SQLPASS!

Last Updated February 12, 2017

Brent Ozar

#SQLPass

Woohoo! I’m presenting three sessions at the PASS Summit in Seattle this year. I’m doing one with Jason Massie (Twitter – Blog) on Social Computing for the Database Professional (I don’t have the abstract handy for that one), and these two: Session: Yes, I’m Actually Using The Cloud Security in the Cloud There’s a lot…

SSWUG V-Conference Preview Videos

Last Updated April 7, 2009

Brent Ozar

The SSWUG Virtual Conference has posted free 10-minute samples of each speaker’s videos. You can get a 10-minute intro to several presentations to get a feel for the quality of the videos, the speakers and the material. The videos take 10-15 seconds to start, so hang in there. Log Shipping 101 SQL Server V-Conference Samples…

Adding Reliability to Your Infrastructure

Last Updated June 24, 2017

Brent Ozar

Architecture

I don’t wanna fly in a single-engine plane. Call me chicken, call me scaredy-cat, but I’m not excited to get into an airplane that will kill me if an engine fails. The next step up is a twin-engine plane – but I don’t get on all of those either. I like my engines to be…

Why Your Sysadmin Wants To Virtualize Your Servers

Last Updated February 13, 2017

Brent Ozar

Virtualization

DBAs and developers: right now, your Windows admin is talking to management about all the time, money and hardware he can save by virtualizing servers. He might not start with SQL Servers first, because frankly, he’s scared of database administrators. DBAs only have one answer: “No.” Your sysadmin knows how you roll. Thing is, though,…

PASS Summit 2009 Call to Speakers Open! #SQLPass

Last Updated February 12, 2017

Brent Ozar

#SQLPass

The Professional Association for SQL Server Summit is being held again this November in Seattle, and the Call to Speakers is now open. You can only submit 4 sessions, which seemed very small to me until I realized that I do entirely too many presentations. In Twitter, somebody mentioned that it’d be a good idea…

Search Results for “mirroring”

Hi! I’m Brent Ozar.