Posts by Jes Schultz

Building a Report to View Memory Usage

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

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

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

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

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

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

Disabling vs. Dropping Indexes

In order to improve your applications and your databases, they will need to change over time. The structure of the database changes, the structure of the tables change, the data in the tables change, the application changes, the queries against the data change. Indexes that once helped performance now just bloat your database and cause extra work…
Read More

The Okapis of SQL Server Indexes

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!

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!

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
Menu
{"cart_token":"","hash":"","cart_data":""}