game-of-performance-tuning-preview

Free Poster: Game of Performance Tuning

Performance tuning is much easier when you have dragons. When I think about speeding up SQL Server, I think of three things: Index tuning Query tuning Server and application architecture Capture all three in one free poster. Want more posters? I’ve got download links for all my free posters right here.

Should-I-Automate-Windows-Update

Should I Automate my Windows Updates for SQL Server? (Dear SQL DBA Episode 10)

Your boss wants you to automate patching for your SQL Servers. Is that a good idea? How far should you take it? Find out a DBAs perspective. This is a “listen-able” 17 minute video. Prefer a podcast instead? Find it at littlekendra.com/dearsqldba. Show notes (transcript with links) are below the video. Dear SQL DBA… I’ve been […]

Here's a tiny preview. Click the link to the left for the whole poster.

Free Poster: Troubleshooting SQL Server After a Migration or Upgrade

I had so much fun doing the podcast episode last week on why an upgrade / migration can cause performance problems that I drew out the concepts for troubleshooting perf after an upgrade. Here’s the download: Production notes: This drawing was make with Autodesk Sketchbook, a really fun art program (with a decent free version, […]

Why-So-Tired-SQL-Server

Why an Upgrade can Cause Performance Regressions (Dear SQL DBA Episode 9)

You finally got approval to move to new hardware and a fresher version of SQL Server. After months of work,  you do the migration and then… performance gets worse. What can cause this, and what do you look for? This is a “listen-able” 27 minute video. Prefer a podcast instead? Find it at littlekendra.com/dearsqldba. Show notes […]

Cat DBA Preview

Free Poster: Cat DBA Says “Not Right Meow”

You’ve got 99 problems, and the request coming in ain’t one. Maybe you need to channel your inner Cat DBA, just for a moment. Print out this poster in full color. It will help you remember to grab your car keys and head out of the office at 4:59 PM each weekday, before another email can […]

The view at Rowena Crest, just outside of Portland

Coming to SQL Saturday Portland? Plan a Vacation, too!

SQL Saturday Oregon will be held on Oct 22, 2016 this year– the weekend before the SQL PASS Summit. As a Portlander, I love it when people come visit my town! Please consider taking a few extra days to enjoy checking out PDX before or after the event. Here’s my favorite things to see, do, and […]

Max-Degree-of-Confusion

MAXDOP of Confusion (Dear SQL DBA Episode 8)

Learn how to configure the Max Degree of Parallelism and Cost Threshold for Parallelism settings in SQL Server – and how SQL Server 2014 SP2 and SQL Server 2016 change the way that SQL Server automatically configures some SQL Servers with lots of cores. This is a “listen-able” 20 minute video. Prefer a podcast instead? Find it at […]

Abandon-Users-Square

Is User Acceptance Testing Covered Under Developer Edition?

Holy mackerel, it is! I tend to think of development environments as SQL Servers where customers are surely never allowed to enter, for fear that the licensing dollars will pile up like banks of snow around the gates to the instance. But there’s an exception. Check out this screenshot from Microsoft’s SQL Server 2016 Licensing Datasheet: Developer Edition allows for […]