SQL Server

Video: Documentation – It Doesn’t Suck!

SQL Server, Videos
1 Comment
Without documentation, you could probably do your taxes, build a new piece of “some assembly required” furniture, or manage a database instance – but you’d probably end up living in prison, living with broken furniture, or living in fear of your servers. Writing documentation might not seem as important or exciting as developing or tuning…
Read More

Documentation: It Doesn’t Suck!

SQL Server
11 Comments
Some parts of our jobs are not glamorous, but necessary. For example, I have to brush Brent’s Bob Dylan wig weekly, to make sure it’s shiny and perfect. Documentation is a task many people roll their eyes at, procrastinate about starting, have a hard time keeping up-to-date, and in general avoid. Stop avoiding it, and…
Read More

Developers: Help Us Pick Cities for 2013 Training

SQL Server
2 Comments
You’re a developer stuck managing a database server that you don’t feel comfortable with.  You’ve got no formal database training, but over a couple years of work, you’ve taught yourself how to design databases and write queries.  You want to improve the performance and reliability of your SQL Server, diagnose problems with your T-SQL and…
Read More

Does Your SQL Server Need Critical Care®?

SQL Server, Videos
0
Overwhelmed with problems on your SQL Servers? Maybe it’s time you stopped playing around with bandages and got some Critical Care®.  In this 30-minute video, we’ll introduce our Critical Care® process, explain what we look for, and show you how to explain it to your manager. Let’s make your SQL Server faster and more reliable…
Read More

Implementing Snapshot or Read Committed Snapshot Isolation in SQL Server: A Guide

How to change isolation levels without losing your marbles. A client said the coolest thing to me the other day. He said, “We talked before about why we would want to start using optimistic locking in our code. How do we get there?” If you’re not a SQL Server geek, that comment probably doesn’t even…
Read More

Here’s to the Ones Working Today

SQL Server
3 Comments
Happy New Year’s Eve!  And no, I’m not looking for a kiss. Are you working today?  I usually did.  I’ve been in IT for over a decade, and I worked most holidays (not to mention most weekends).  It was the best time to get outage windows to do a lot of things that would help…
Read More
What a good lookin' crowd.

PASS Summit Feedback: Top Ten AGAIN!

#SQLPass, SQL Server
5 Comments
Wow. Just wow. I’m totally humbled to say that my sp_Blitz® session and my AlwaysOn Availability Groups session were both voted among the best ten sessions at the PASS Summit 2012 conference. The sp_Blitz® session felt like the best session I’d ever presented in my life. The room was jam packed full of people with…
Read More

What DBAs Need to Know About Hardware

SQL Server
7 Comments
If you became a database administrator by rising through the ranks of software developers, you probably haven’t built your own servers from the ground up. That’s totally okay – but you’re missing some important information that will make you a better database administrator. In this 20-minute session, Brent Ozar will help you get started exploring…
Read More
PASS Summit Keynote Stage

#SQLPASS Summit Keynote Liveblog Day 2

#SQLPass, SQL Server
3 Comments
Good morning ladies and gentlemen! The conference hall is filling up in Seattle, and it’s time to crank up another blow-by-blow commentary.  I’ll be updating this blog every few minutes with what’s happening here at the PASS Summit.  For a refresher, check out the liveblog of yesterday’s keynote. PASS Summit Keynote Stage 8:20AM – People…
Read More
PASS Summit Keynote Day 1

#SQLPASS Summit Keynote Liveblog – Day 1

#SQLPass, SQL Server
1 Comment
PASS Summit Keynote Day 1 Good morning, folks! Lights, camera, action – it’s time for the first keynote presentation at the Professional Association for SQL Server Summit.  It’s the annual international conference for Microsoft database folks.  This year it’s in Seattle, Washington again. Over the next two hours, I’ll be expanding this post with minute-by-minute…
Read More