SQL Server

  1. Home
  2. SQL Server
  3. (Page 50)

GTD for my coworkers

SQL Server
10 Comments
Dear Coworker, Hi.  I work differently than other people you may have worked with.  I wanna take a minute to bring you up to speed on how I do it, and what this might mean for you. I use the Getting Things Done methodology from David Allen, and here’s how I work. When You Email…
Read More
Param.txt

SQLIO Tutorial: How to Test Disk Performance

SQL Server, Storage
Storage is a black box, right?  The SAN admins ask how much storage space you need, you tell them, and then they give it to you.  They don’t tell you how fast (or slow) it is, they don’t know whether it meets your needs, and they probably don’t know where the bottlenecks are. It’s time…
Read More

Steel Cage Blogmatch: How to Configure a SAN

SQL Server, Storage
13 Comments
Jason Massie and Brent Ozar work with SQL Server for a living and write blogs for fun, but that’s where the similarities end.  Jason’s a fan of shared storage SANs: putting SQL Server data and logs on the same set of physical hard drives.  Brent’s a cheerleader for dedicated configurations where the arrays are separated…
Read More

Recommended Books for SQL Server DBAs and Developers

Book Reviews, SQL Server
93 Comments
Here’s my favorite SQL Server books for 2016-2014: T-SQL Fundamentals – (updated for SQL 2016) – don’t be fooled by this “fundamentals” title, because everybody who writes T-SQL queries needs this book. It’s the manual we should have been given when we started, and everyone’s going to learn something about concurrency, performance, and updates here. T-SQL Querying…
Read More

SQL Server 2005/2008/2012/2014 Setup Checklist

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

What’s the Largest Database You’ve Worked With?

When hiring a production DBA, I start by asking them, “In terms of file size, what’s the largest database you’ve worked with?” In a perfect world, we’d only hire very experienced candidates, people who’ve worked with larger databases than we’re dealing with. In reality, though, we can’t always afford those candidates – if they’re even…
Read More

Goodbye MovableType, hello WordPress

SQL Server
0
The more sober among you will notice a small change in the look & feel of this here site. I’ve been toying around with WordPress on some of my other sites for a while, and it’s time I took the plunge and changed over BrentOzar.com. For the next couple of weeks, this site will be…
Read More

Macbook in the driver’s seat

SQL Server
0
Macbook in the driver’s seat, originally uploaded by BrentOzar. My coworkers were a little surprised yesterday when I alreay had my Macbook Pro as my primary machine, and my Dell had already been relegated to riding shotgun. The only reason I even still have it on my desk is because I have to get our…
Read More

I’m getting a Macbook Pro!

SQL Server
0
YES! YES! YES! Or as they say in the World Cup, GOOOOOOOOOOOOOOOAL! My boss knows about my lust after the grooviness known as the Apple Macbook Pro, and he just scored me the coolest project. I get to be the pilot guy for supporting Macs internally. I’m way psyched. Now for the wild part –…
Read More

End ofa long, hard day

SQL Server
0
End ofa long, hard day, originally uploaded by BrentOzar. I spent the second half of the day building and installing a couple of pizza boxes from IBM. We’re cleaning up our network test lab, mounting flat panels on the walls for easier builds, and just generally making it a nicer place to spend time.
Read More

Made the local news

SQL Server
2 Comments
Sleepy Houstonian Well, whaddya know. The coffee shop interview I did with the TV reporter ended up making it to the local news that night. I got a laugh out of the subtitle they showed during the interview. I’ve got an agent, and I’m planning a new TV show called “The Sleepy Houstonian.” I figure…
Read More

Coffee and pills

SQL Server
0
I had a really crummy day yesterday. Things just weren’t going my way, and I had all kinds of stupid small programming problems at work. Just one unrelated thing after another. Sometime in the afternoon, I stumbled downstairs for yet another pot of coffee and some ibuprofen, but I wasn’t really paying attention. I was…
Read More