Posts by Brent Ozar

  1. Home
  2. Brent Ozar
  3. (Page 99)

My rudimentary approach to software testing

0
I’m testing the new builds of LiteSpeed and Toad.  I’m not to the point where I’m using my L337 SQL skillz yet because I take a very basic ground-level approach to testing. I go through an entire program and click on every menu item. Everywhere that it lets me add something, I add it, and…
Read More

Great SQL Server newsletter

3 Comments
When DBAs ask where to go for simple, straightforward SQL Server tips, I usually point them to SQL-Server-Performance.com.  That site puts out a fantastic daily newsletter with SQL notes, questions & answers, and general tips. I’m not wild about daily email newsletters, but this one’s a gem.  It’s gotten even better since Peter Wardy started…
Read More

Bought a Wii – and then gave it away

1 Comment
On my trip to DC this week, I ran across a couple of Nintendo Wiis in stock at Target.  For those of you who don’t follow video games, the Nintendo Wii is a notoriously hard-to-find game system.  It’s been out for months, but you still can’t walk into a store and just buy one.  Prospective…
Read More

Back from vacation, heading to my new job

2 Comments
My blog has been quiet the last few days because I’ve been in Washington DC visiting my Mom and my sister Emily.  I wanted to sneak in a quick visit between jobs.  I took the opportunity to redo both of their wireless networks and achieved a 0% success rate – I had to get two…
Read More

Meet Quest Software’s new database guy

5 Comments
I have a new job, and lemme just tell you, it feels like my whole career has prepared me for this one. I spent several years at UniFocus, a hospitality software company that relied on SQL Server. I honed my SQL skills, but probably more importantly, I managed a small team of programmers. I worked…
Read More

Coworking Comes to Houston

1 Comment
The new Caroline Collective space is bringing coworking to Houston, and if my job hunt works out the way I hope this week, I’ll be one of the anchor tenants. People who telecommute can feel isolated without the fun personal interaction with creative, dynamic people.  Coworking aims to solve that by offering desks and offices…
Read More

Writing Better Queries by Joe Webb

0
Joe Webb gave a presentation on “Tips & tricks for writing better queries” for the Nashville PASS chapter, and it’s a great read.  Developers and DBAs should all read this for a clear, concise refresher. A video of the presentation would be even better, but for the most part, the slide deck speaks for itself. …
Read More

SQL Server Consolidation: Plan for SQL Server 2008

0
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…
Read More

DBA 101: It Takes Confidence

Professional Development
8 Comments
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…
Read More

Submitted my abstracts for PASS 2008

#SQLPass
0
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…
Read More

DBA Job Transitioning: Disable Logins In Advance

1 Comment
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…
Read More

SQL Server Magazine post about the Quest SQL community

0
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…
Read More

Changing Companies

2 Comments
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,…
Read More

Don’t specify IP’s in your SQL connection string

2 Comments
In today’s SQL newsletter from SQL-Server-Performance.com I was horrified to find the following tip: When you specify a server in an ADO.NET connection string, use the server’s IP address, not the server’s DNS name. By using an IP address instead of a DNS name, name resolution does not have to occur, reducing the amount of…
Read More