Category: Powershell

Configure static or dynamic IP and DNS with Powershell

Post author By Jen McCown
Post date March 3, 2014
Categories In Powershell, sqlserverpedia-syndication, SSC, Tech and Learning
6 Comments on Configure static or dynamic IP and DNS with Powershell

I work in a lot of different offices and conference venues, in addition to my home office. At home, I need a static DNS server address; everywhere else, it has to be dynamic. Tired of the click-click-clickety-click it takes to set, unset, and reset my network adapter settings, I went looking for a Powershell solution. This is the […]

What’s the CPU usage on the server? Use #Powershell!!

Post author By Jen McCown
Post date February 10, 2014
Categories In Admin, Powershell, sqlserverpedia-syndication, SSC, Tech and Learning

We have here an easy, handy-dandy way to find out how much CPU is in use on your server. Of course you can find out by opening up task manager, or by running perfmon, but that’s not really the point. We want something quick and easy. We want something we could potentially use for monitoring, […]

Use Powershell to find and punish – er, delete – rogue files

Post author By Jen McCown
Post date May 13, 2013
Categories In Powershell, sql server, sqlserverpedia-syndication, SSC, Tech and Learning

I like to know what’s on the drives that are supposed to be dedicated to data and log files. So I run a quick check of sys.master_files: SELECT LEFT(physical_name, 1) as Drive, SUM(size)*8/1024 as SizeMb FROM sys.master_files GROUP BY LEFT(physical_name, 1) ORDER BY Drive; And then I compare the numbers I got back against what Windows says. […]