Videos

  1. Home
  2. Videos
  3. (Page 14)

Watch Brent Tune Servers [Video] #MSIgnite

SQL Server, Videos
11 Comments
Last week at Microsoft Ignite 2015 in Chicago, I demonstrated how to tune a few SQL Server workloads with my favorite process: Measure how fast the SQL Server is going Check its bottlenecks Apply some easy-to-tweak configuration settings and measure the difference There’s no camera in this hour-long video, just a screen capture, so you’ll have…
Read More

Watch Brent Tune Queries [Video]

SQL Server, Videos
4 Comments
Ever wonder how somebody else does it? Watch over my shoulder for this beautifully recorded one-hour session at SQLRally Nordic in Copenhagen from a couple weeks ago: The resources, scripts, and my Be Creepy process are all free too. Enjoy, and check out all of the session recordings for even more free learnin’.
Read More

Doug Broke It: Minimal Logging [Video]

Videos
8 Comments
In this 5-minute video, Doug explains how he kept filling SQL Server’s transaction log during ETL development, and how minimal logging could have prevented a lot of the log writes. You’ll learn about: What minimal logging is How to turn minimal logging on How to tell if minimal logging is working Using minimal logging for…
Read More

The Day the SQL Server Quit [Video]

Videos
13 Comments
In this 5-minute video, Doug tells a story about a DBA whose SQL Server got fed up with being misconfigured and decided to do something about it. Topics include CPU settings like MAXDOP and Cost Threshold for Parallelism, memory and disk configuration.
Read More

Refactoring T-SQL with Windowing Functions

SQL Server, T-SQL, Videos
6 Comments
You’ve been querying comparative numbers like Year To Date and Same Period Last Year by using tedious CTEs and subqueries. Beginning with SQL Server 2012, getting these numbers is easier than ever! Join Doug for a 30-minute T-SQL tune-up using window functions that will cut down dramatically on the amount of code you need to…
Read More

Watch Brent Tune Queries

SQL Server, Videos
17 Comments
Ever wonder how someone else does it? There’s no right way or wrong way, but in this 20-minute session, you can peer over Brent’s shoulder (virtually) while he takes a few Stack Overflow queries, tries various techniques to make them faster, and shows how he measures the before-and-after results. For the links and scripts, check…
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

Does Your SQL Server Need Critical Care®?

SQL Server, Videos
0
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…
Read More

Bob Dylan Explains TempDB (Video)

Humor, TempDB, Videos
8 Comments
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.
Read More