Config – MidnightDBA

Optimize For Adhoc Workloads

There’s a lovely sp_configure option that can help you keep the size of your plan cache under control. Let’s go have some fun.

Server Properties

Have you ever wanted to be able to view instance-level stats or change certain values without having to use the GUI? Here I’ll show Continue reading “Server Properties”

Server Configuration Settings in Powershell

I love making vids on the trickier stuff and this one is it. Here we’re talking about duplicating sp_configure in Powershell. It’s pretty Continue reading “Server Configuration Settings in Powershell”

Change Startup Params in Powershell

I heard someone today say that you can’t change startup parameters in Powershell. So I made this vid to set the record straight.

Cycle Error Log on all Servers using Powershell

Here I show you how to use the Carrier Method for using powershell to cycle all your error logs. This is an excellent way Continue reading “Cycle Error Log on all Servers using Powershell”

Fix AutoShrink in Powershell

Here I show you how to turn off AutoShrink on a DB and then how to make sure it’s turned off on all your DBs.

Uninstall a CU in SQL Server 2008 R2

Here I’ll show you how to uninstall a CU from SQL Server 2008 R2, CU5 to be specific, but it doesn’t matter. Here there’s Continue reading “Uninstall a CU in SQL Server 2008 R2”

Uninstalling SP1 in SQL2K8

SP1 is the first one that you can uninstall in SQL Server, so here I thought I’d take a look at the uninstall process and Continue reading “Uninstalling SP1 in SQL2K8”

Compression Basics

I’m going over the basics of how to implement data compression here. I’m not really touching on where and why you’d want to do Continue reading “Compression Basics”