Month: July 2012

We’re an Amazon Consulting Partner

Last Updated March 26, 2014

I’m really excited to share the news that Brent Ozar Unlimited® is now an Amazon Consulting Partner. The Amazon Consulting Partner program is a way for Amazon Web Services to identify consulting firms specializing in helping customers design, build, and deploy solutions in Amazon Web Services. Cloud computing is some seriously cool stuff and we’re…

Before You Fail Over a SQL Server Always On Availability Group

Last Updated February 9, 2017

Brent Ozar

Always On Availability Groups

Think fast! When it’s time to do a manual failover with SQL Server 2012 AlwaysOn Availability Groups, we need to make a few decisions and perform a few tasks as quickly as possible to get the business back up and running. Here’s what you need to consider ahead of time so you can stay calm,…

How to Pick a SQL Server Conference

Last Updated February 12, 2017

Brent Ozar

#SQLPass, Writing and Presenting

As a consultant and speaker, I’m lucky enough to go to a crazy number of SQL Server conferences. Here’s what I think of each mainstream conference out there – who they’re for, and who they’re not for. PASS Summit Length: 3 days Pre-Cons Available: Yes, many Videos Available Online: Yes, but only for paid attendees…

The Presenter’s Bill of Rights

Last Updated December 1, 2012

Brent Ozar

Writing and Presenting

Bad news: you don’t have any. You THINK you have the right to all of this stuff: A working screen for a projector (as opposed to one that’s hung up in the ceiling and won’t come down) A working projector A functioning bulb in the projector A stand for the projector within cord’s reach of…

Architecting with AWS – Course Overview

Last Updated February 13, 2017

Jeremiah Peschka

Amazon Web Services (AWS)

The Friday before class started I received an email from people running the Architecting with AWS training class about how to get to the class, what time class got started, a schedule of topics, and a link to prerequisites that I should go through before arriving at class on Monday morning. Most training classes I’ve…

Architecting with AWS – Before You Go

Last Updated February 13, 2017

Jeremiah Peschka

Amazon Web Services (AWS)

Architecting with AWS is a three day training session held at the AWS offices in Seattle (classes are available in other locations). Both outsiders and AWS employees come together to learn about building scalable solutions on the AWS platform. This is a practical training program – there’s no certification behind it. The Architecting with AWS…

Your First Good Job Isn’t In the Newspaper

Last Updated February 12, 2017

Brent Ozar

Professional Development

Right now is an incredible time to do what you love. Bear with me for a second and watch this one-minute video from Red Bull: It’s full of people doing what they love. These people are at the top of their game, but more importantly, they’re sharing their game with others, inspiring and entertaining them.…

SQL Server Index Terms

Last Updated February 13, 2017

Jes Schultz

Indexing

Let’s have a chat about your indexes in SQL Server. Indexes can be confusing. They are the easiest way to boost performance of queries, but there are so many options and terms around indexes that it can be hard to keep track of them. Let’s chat about the differences between clustered and nonclustered indexes, key…

AlwaysOn Availability Groups in AWS Revisited

Last Updated February 13, 2017

Jeremiah Peschka

Always On Availability Groups, Amazon Web Services (AWS)

If you’ve ever wanted to use the cloud for a DR site, there’s good news: as of this week you can use AlwaysOn Availability Groups and set up an asynchronous replica of your data into Amazon Web Services (AWS). If you’re already in the cloud, or if you were holding off, this means that you…

A Developer’s Guide to Dangerous Queries (Video)

Last Updated July 5, 2012

Jeremiah Peschka

Want to help us shape our training? Take 30 seconds and answer 5 questions. Are you looking for sample code from the presentation? Download the samples from A Developers Guide to Dangerous Queries. Transact-SQL /************************ * Correlated Subqueries ***********************/ USE ContosoRetailDW; GO SELECT DISTINCT dd.DateDescription , SUM(fs.SalesAmount) AS Sales , SUM(COALESCE(fs.DiscountAmount, 0)) AS Discount FROM…

What’s a DBA’s Defining Moment?

Last Updated July 3, 2012

Brent Ozar

Database administration is very much an “accidental” career. So many of us start out as programmers, network administrators, or desktop support, and one day we just get handed a database server. It’s a Windows app – how hard can it be, right? Somewhere along the way, we start managing more and more servers, or we…