Posts by Jes Schultz

Jes Schultz

48 posts

Books, the Dewey Decimal System, and…SQL Server?

Last Updated May 13, 2014

I have been in love with books and libraries most of my life. I remember some of my earliest favorites: Little House on the Prairie, Anne of Green Gables, Bridge to Terebithia, The Chronicles of Narnia. I remember feeling grown up when my sixth grade teacher handed me Gone With the Wind. I would read…

Our PASS Summit 2012 Schedule

Last Updated February 12, 2017

Jes Schultz

#SQLPass, Writing and Presenting

Next week, the Brent Ozar Unlimited® crew will be attending PASS Summit in Seattle, WA. It’s a busy week, full of networking, learning, and teaching. Here are a few of our highlights. Want to add our sessions to your schedule, and view more information at your fingertips? PASS Summit has gone mobile with Guidebook! It’s…

Who’s testing your restores? No, really – who’s testing your restores?

Last Updated April 7, 2021

Jes Schultz

CHECKDB and Corruption, SQL Server

I recently posed the question, “Who’s taking your backups?” This is of utmost importance, because your business’s data is the business. Protecting it and backing it up need to be priorities for DBAs. Now, for my next question: who is responsible for restoring those backups? The saying goes that your data is only as good…

You Can Give A Technical Presentation (Video)

Last Updated October 5, 2012

Jes Schultz

Writing and Presenting

In your dream, you’re standing in front of a room full of dozens of people, presentation mouse in hand, about to present to them on (insert SQL Server feature here). You wake up in a cold sweat. You’re either terrified, or excited and terrified. Are you ready to start presenting? Join Jes as she shares…

Who’s taking your backups? No, really – who’s taking your backups?

Last Updated February 13, 2017

Jes Schultz

Backup and Recovery, SQL Server

Who in your company is responsible for database backups? It’s Me Fantastic! Check your backup job. Did it run successfully the last time it was supposed to? Are the files where they are supposed to be? Have you checked the integrity of the backup files by restoring them to a secondary server? If you are…

No Substitute for Time, Experience, and Training

Last Updated March 26, 2014

Jes Schultz

SQL Server

I’m a runner. I wasn’t always a runner. Three years ago, I couldn’t run a mile. I wanted to, but I wasn’t physically capable. So I started training with the Couch to 5K plan. Eventually, I ran a 5K – I did it! – even though I was a mess. I didn’t wear the best…

SQL Server Index Terms

Last Updated February 13, 2017

Jes Schultz

Indexing

Let’s have a chat about your indexes in SQL Server. Indexes can be confusing. They are the easiest way to boost performance of queries, but there are so many options and terms around indexes that it can be hard to keep track of them. Let’s chat about the differences between clustered and nonclustered indexes, key…

The SQL Server Performance Checkup from a Consultant’s Perspective

Last Updated March 26, 2014

Jes Schultz

SQL Server

Here at Brent Ozar Unlimited®, we offer a server performance checkup to clients. As the newest member of the team, I wasn’t sure what to expect when running one. I found out that it’s pretty cool. I pretend we’re Special Forces operatives, strapped into our parachutes, doing a HALO opening over client servers. (This homemade parachute…