Datacenter’s and companies everywhere generally rely on a core piece of software to store their data and metrics, SQL Server. It’s nice to keep it up to date, but sometimes, and a lot of the time, if it’s not broken, don’t fix it. SQL Server has been around for quite a while, there are many databases hosted by SQL Server. Microsoft has released many upgrade advisors over the years, but recently the SQL Server team has overhauled their traditional SQL Server Upgrade Advisor and have created a new product – SQL Server Data Migration Assistant (DMA), which is different than SQL Server Migration Assistant (SSMA). To pull off a successful migration or upgrade, you need to do your detective work.
Well I’ve been buried lately under a lot of LUNs. Spring is over and a customer I’m at has forgotten to do their spring cleaning! Needless to say, the LUN presentation and maintenance to their VMware clusters is a mess! In order to audit the system and ensure things were going in my favor, I wrote quite a few PowerShell code blocks/1 liners.Read More
A pretty simple request came across my desk today. I was requested to send a report of users that were created after a specific date. Do you remember the Windows Server 2003 and prior? Before PowerShell? We had to use what I’ll term loosely as “wonderful” LDAP queries. Also the query result was pure text, we couldn’t do anything easily with it short of magical text parsing! Well here is my PowerShell script I quickly whipped up!Read More
This is one of those management tasks that comes up at any location you’re at, especially...Read More