Videos

Home
Videos

Why Index Fragmentation Doesn’t Matter [Video]

September 23, 2013

Are you still rebuilding all of your indexes every week – or heaven forbid, every night – and still having performance problems? Odds are, you’re not actually making things better – you’re making them worse! I explain why in this video: For more, read my post: Stop Worrying About Index Fragmentation.

How to Get Your Manager to Pay for Training

September 3, 2013

Brent Ozar

SQL Server, Videos

When us geeks want something, we just point at it, look at our manager and say, “I want this. Buy it for me.” Oddly, it doesn’t seem to work. To get what we want, we have to think like a manager. Step 1. Define a user’s Pain Point. You need someone else on your side…

An Introduction to SQL Server IO for Developers (video)

March 22, 2013

Kendra Little

SQL Server, Videos

Developers frequently make a big mistake: they tune out on discussions of storage performance and IO. Don’t fall into this trap! Understanding how storage impacts SQL Server performance helps you tune the right parts of your code and focus on what really matters. In this 30 minute video, Microsoft Certified Master Kendra Little demonstrates why…

Developers: Check Your SQL Server’s Health

March 6, 2013

Brent Ozar Unlimited Team

SQL Server, Videos

Before you join us in Atlanta for our 2-day training class (or if you’re just thinking about it), let’s talk about your environment. In this 30-minute session, we’ll give you some vital statistics to check in your SQL Server before you leave work, and we’ll explain how our upcoming training class will help you improve…

SQL Server Table Partitioning Tutorial: Videos and Scripts

January 28, 2013

Kendra Little

Partitioning, SQL Server, Videos

partition switching, sql server, table partitioning

There’s a secret to learning about SQL Server’s table partitioning feature: you need to get your hands on some code and really play with it in a test environment. In this tutorial, Kendra will walk you through test scripts that set up a sample table partitioning environment. These scripts demonstrate gotchas to look out for…

Video: Documentation – It Doesn’t Suck!

January 16, 2013

Jes Schultz

SQL Server, Videos

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…

Does Your SQL Server Need Critical Care®?

January 9, 2013

Brent Ozar

SQL Server, Videos

No Comments

Overwhelmed with problems on your SQL Servers? Maybe it’s time you stopped playing around with bandages and got some Critical Care®. In this 30-minute video, we’ll introduce our Critical Care® process, explain what we look for, and show you how to explain it to your manager. Let’s make your SQL Server faster and more reliable…

Instant Index Insight: How to Use sp_BlitzIndex® (video)

December 14, 2012

Kendra Little

First Responder Kit, Videos

sp_blitzindex

You probably don’t have enough time to dig through DMVs trying to figure out which indexes you should add or drop. Whether you’re a DBA or developer, junior or senior, you’re probably too busy doing your real job to master all the index best practices – and now you don’t have to. In this 30…

Bob Dylan Explains TempDB (Video)

December 5, 2012

Brent Ozar

Humor, TempDB, Videos

bob dylan, tempdb

How many files must a TempDB have before it’s allowed to be fast? How many table variables must a server walk down before it’s considered a table? The answer, my friend, is blowin’ in the wind, and Bob Dylan will share it with you in this 25-minute video – hopefully you can understand him.

Introducing the SQL Server Plan Cache (and a Better sp_Blitz®)

November 19, 2012

Brent Ozar

Execution Plans, SQL Server, Videos

performance tuning, plan cache, procedure cache, sp_blitz

When you send your beautifully hand-crafted organic T-SQL statement to SQL Server, the database engine takes a moment to appreciate the poetry of your work. Before it turns your request into results, it has to build an execution plan. SQL Server considers: Which tables it needs to join together What subqueries it needs to execute…

SQL Server Installation Best Practices Video

October 17, 2012

Brent Ozar

SQL Server, Videos

installation, setup

Wait! You only get one chance to do this right. Before you run setup.exe, there are some basic configuration steps that will make all the difference in performance and troubleshooting. Brent Ozar will explain his SQL Server Setup Checklist covering the page file, service accounts, memory settings, and hardware stress testing. We won’t cover scripted…