Posts by Jes Schultz

Signing off

Company News
18 Comments
Dear Brent Ozar Unlimited readers: thanks for following me for three great years. I’m off on a new adventure, but I hope to see you at a user group, a SQL Saturday, or a conference in the future! I’m leaving with a lot of great memories – and here are a few of my favorites…
Read More

What Problems can Extended Events Solve? (Video)

SQL Server
7 Comments
Extended Events have been available since SQL Server 2008, but they are still a black box to most database administrators. Rather than focusing on the technicalities of sessions and targets, Jes will show the value of Extended Events by showing you what problems can be solved. Metrics can be gathered, performance problems can be targeted,…
Read More

“It’s Slow” Is Not A Metric

Wait Stats
7 Comments
When I start a SQL Server Critical Care with a client, the first thing I ask is, “What is your #1 pain point? Where does it hurt?” The answer I hear most often is, “The server is too slow”. I’m a runner. If I was able to run a 5K race at an 8:30 per…
Read More

Three reasons to use Extended Events

SQL Server
19 Comments
I have a new mission: to convince you, the long-time Profiler user, to switch to Extended Events. I realize I have a long, difficult task ahead of me. Profiler has been around for a long time. You’re comfortable with it. You know it’s not perfect, but you have learned to live with its imperfections. Now I want…
Read More
I ran headfirst into a brick wall.

How to Query Extended Events Target XML

SQL Server
22 Comments
When Extended Events (XE) were released with SQL Server 2008, I was excited – something new to learn! I read Microsoft articles about them, read blog posts about them, and tried to use them. At that time, there was no GUI for XE. I had to create the sessions with T-SQL. That wasn’t awful – I…
Read More

Backups, Restores, Corruption, and You: How Strong are You?

You and your databases have a strong relationship. You back them up, and check them for corruption. They provide the business with information day after day. Don’t let your relationship come to this! Then, one day, your relationship is rocked. The backups are too slow. The restores are too slow. There is…gasp…corruption. Are you prepared…
Read More

Advice to an IT newcomer

SQL Server
4 Comments
Women in Technology (yes, Clippy is a woman, too) We recently got the following question for Kendra and Jes in the Brent Ozar Unlimited® mailbox: Six months ago I stumbled into the IT world. Do you have any advice for someone (a woman) starting off in the IT industry, specially someone without a computer science…
Read More

Why Are You Still Using SQL Server 2005?

SQL Server
15 Comments
The year: 2005. What was happening with the Brent Ozar Unlimited® crew? I was working on the help desk for a small company while attending Fox Valley Tech College to earn my associate degree. I think I still wanted to go into programming at that point in time! I’d never been to a user group…
Read More
Menu