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.
Tag: Config
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”
sp_HelpIndex Shortcut
There’s a nifty keyboard shortcut to help you with things like sp_helpindex. It works with many SPs so have fun.
Using ServerProperty
Here I show you the benefit of using ServerProperty() instead of @@Version to find the version of SQL Server you’re on.