While you’re stuck inside wondering if you’ll ever be able to attend a user group meeting again, I’m giving you free access to training materials that your boss probably wouldn’t have been nice enough to buy you anyway. So far this week, we’ve covered DBCC CHECKDB, how to set up Ola Hallengren’s maintenance scripts, and restoring for oops deletes. Today, let’s talk about two common configuration issues. Don’t dilly-dally on these though: these blog posts will be online during May only, and they’ll disappear on June 1.
How to Configure TempDB (9m)
We joke that it’s like SQL Server’s public toilet, and just like a public toilet, you can make it a much nicer place if you … okay, you can’t make it much nicer. A little nicer, maybe.
Configuring and Using the Dedicated Admin Connection (DAC) (7m)
When you’re really desperate – no seriously, this isn’t a public toilet joke – and you need to get access to the SQL Server, and it’s not responding to connection requests, the Dedicated Admin Connection is like a…whoa, it’s like a public toilet, isn’t it? This is deep.
Configuring Lock Pages in Memory (6m)
This one’s shorter and sweeter – although isn’t everything sweeter than a public toilet – because maybe you shouldn’t actually configure this one. Erik talks about the pros and cons:
If you enjoy these, check out Erik Darling’s new performance tuning training classes and sign up for his newsletter.
Tomorrow, we’ll cover one of my favorite topics: patching SQL Server.