Posts by Jes Schultz

Building a Report to View Memory Usage

SQL Server
8 Comments
Memory is one of the most-used resources in SQL Server. Generally, the more you have, the better query performance you’ll get. This blog isn’t about the magic of the buffer pool or the plan cache, but you should understand how important they are to your server’s performance.  Since memory is such an important resource, you…
Read More

Get a Report of Your Server’s Top 10 Worst Queries

SQL Server
5 Comments
Problem: your database server’s performance stinks like Limburger cheese. Photo courtesy of http://en.wikipedia.org/wiki/File:Wisconsin_Limburger_Cheese.JPG Solution: find the queries that are making that smell. Hiding in Plain Sight Your database server knows exactly which queries are performing the worst. When queries are executed, the execution plans – and associated execution statistics – are stored in memory (with…
Read More

Making Tables Look Good

SQL Server
5 Comments
I could be talking about the tables in my database – I do make them skinny by using the right data types – but in this case I’m talking about SQL Server Reporting Services tables. You’ve seen them before. The average table is bland and boring, with nothing to distinguish it from the next, and…
Read More

My Five Favorite That Conference Memories

SQL Server
3 Comments
Last week, I went to summer camp for geeks, and I had a great time! That Conference is a three-day, developer-focused, family-friendly technology conference. Camp was held for the first time in 2012. I heard such great things about it from last year’s campers that I decided to go this year! The sessions focused on…
Read More

You Need This One Skill to Succeed in IT

Consulting
18 Comments
The ability to program in five languages, including one machine-level? Not it. Project management skills, up to and including a PMP certification? Not that either. Excellent oral and written communication skills, as noted on every job description ever? That doesn’t hurt, but can be learned. All of the best IT professionals I have worked with…
Read More

3 Things You Need to Start Doing to Your Database Server

Taking care of your health is incredibly important (says the marathon runner). Eating right, exercising, and getting plenty of rest help you stay healthy and perform optimally. Does “an apple a day keep the doctor away” apply to cupcake apples? Your database server’s health is important to your company’s health. You need to take regular…
Read More

Log Shipping FAQ

I’ve been working with and talking about SQL Server Log Shipping a lot lately! One way to ship logs… I’ve gotten a lot of great questions about log shipping, so I’ve put together an FAQ. What editions of SQL Server is log shipping available in? 2012 – Enterprise, Business Intelligence, Standard, and Web 2008R2 –…
Read More

The Okapis of SQL Server Indexes

SQL Server
11 Comments
They are elusive and hard to spot in the wild, but they exist: rare index options that can enhance the performance of your queries. If you have a solid knowledge of index basics and want to add to your collection, this is the session for you! In this 30-minute video, Jes will show you how…
Read More

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