Month: March 2008

SQL Server Consolidation: Plan for SQL Server 2008

Last Updated March 31, 2008

When you’re building a consolidation plan, stop to think about when each database will be migrated to a newer version of SQL Server. With SQL Server 2008 coming fast, some content owners will want to move their databases to 2008 as soon as it comes out in order to take advantage of things like the…

DBA 101: It Takes Confidence

Last Updated February 12, 2017

Brent Ozar

Professional Development

A good database administrator projects confidence – without being a jerk. This positive yet firm attitude helps the DBA accomplish their job in tough situations: A programmer insists their code is fine, and it’s a database problem that the DBA needs to fix A manager asks the DBA how much to budget for server hardware…

Submitted my abstracts for PASS 2008

Last Updated February 9, 2017

Brent Ozar

#SQLPass

The Professional Association for SQL Server (PASS) group holds an annual summit for their members. I attended last year, and blogged about some of my experiences: PASS Summit 2007 Day One Notes PASS Summit 2007 Day Two Notes PASS Summit 2007 Day Three Notes While I was there, I remember thinking, “Man, I wish they…

SQL Server 2005 Setup Checklist Part 2: After The Install

Last Updated June 27, 2017

Brent Ozar

SQL Server

I’ve covered what needs to happen before you install SQL Server – now, let’s talk about what to do immediately after the setup finishes. Install not just the service packs, but also the cumulative updates. Starting with SQL Server 2005’s Service Pack 2, Microsoft releases hotfixes in cumulative packs. These updates do more than just…

SQL Server 2005/2008/2012/2014 Setup Checklist

Last Updated May 16, 2018

Brent Ozar Unlimited Team

SQL Server

Ever wonder if you’re missing a step when you set up your SQL Server? Get a checklist to install and configure your SQL Server the right way! We’ve built an easy-to-follow SQL Server Setup Guide for systems administrators, DBAs, and developers that helps you prevent the most common issues we see out in the field. The guide…

DBA Job Transitioning: Disable Logins In Advance

Last Updated March 17, 2008

Brent Ozar

Database administrators touch a lot of servers in their day-to-day duties. We do a lot of troubleshooting, security testing, and run a lot of utilities for everything from performance monitoring to development servers. In a perfect world, the database admin changes their domain password frequently. When the password changes, the DBA knows pretty quickly if…

SQL Server Magazine post about the Quest SQL community

Last Updated March 12, 2008

Brent Ozar

SQL Server Magazine just posted an interview with Billy Bosworth about the Quest Association for SQL Server Experts. One of the quotes that stood out for me was: “We want real people who do real jobs . . . that can interact with us very early in the process of building a product. That helps…

Interviewing DBAs: Check their Business Decisionmaking

Last Updated February 12, 2017

Brent Ozar

Professional Development

When interviewing a database administrator, it’s not enough to check their knowledge of technical skills: we have to check their ability to make sound business decisions. DBAs are in a position to make a lot of architectural decisions with long-term ramifications, and in smaller shops with just one or two DBAs, these decisions won’t come…

Changing Companies

Last Updated March 24, 2008

Brent Ozar

When we moved from Miami to Houston for Erika’s new job as an air traffic controller, my employer wasn’t too sure whether or not telecommuting would work out. Southern Wine currently doesn’t have a pro-telecommuting policy by any means: one company exec stood up at a company meeting and said they would “never” allow it,…