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.
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 […]
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, […]
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 […]
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 […]
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 […]
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 […]
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 […]