Category: Tech and Learning

Bad Ideas: Alert Storming

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

Fellow DBA: There are so many alerts! It takes me a long time to get through them all. How do you filter through them? Me: That’s called “alert storming”, and it’s bad for that exact reason. Alerts are like money: People always seem to have way too little, or way too much*. If you have […]

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

Expiration dates: SQL Server 2008 and 2008 R2

Post author By Jen McCown
Post date February 24, 2014
Categories In Admin, sqlserverpedia-syndication, SSC, Tech and Learning
1 Comment on Expiration dates: SQL Server 2008 and 2008 R2

SQL Server is a software product, right? And software has a history of having bugs, getting updates, and having support for when things go wrong. If you’re not already aware, now is a good time to become aware that: SQL Server has an expiration date Okay, officially it’s not an “expiration” date, but it might as […]