SQL Server – Testing backups (part III)

Welcome to the final step of your future automatization 🙂 Quick reminder what we have done previously. This one forced me to learn new stuff – writing SQL queries and grabbing the results. It was fun to do 🙂 So the general idea was to create a script that will connect to the SQL server,…

Read More

SQL Server – Testing backups (part II)

Welcome back to a resolution of  Admins nightmare – Primary site is down and backup files are useless. Today we will go through the short procedure of getting the data from Blob storage to a local drive. The script is very similar to the previous one, with few specifics which are well commented 😉 Don’t…

Read More

SQL Server – Testing backups (part I)

Everyone who has ever installed a SQL Server has also set up a backup procedure (hopefully :)) But, besides backing up your valuable data, how many of you are actually testing what has been backed up? Do you have a disaster recovery procedure? If you do – how often do you do it? How much…

Read More

Azure custom reporting

My team had a few Azure projects in the past couple of weeks and as for every good project, we had to create a documentation. This gave me an opportunity to write a script (ended as a function) that we could use in the future. Let’s see what we get out-of-the-box. If we run “Get-AzureRMVM”…

Read More

AD heavy changes – Powershell 2 the rescue

Recently I have been assigned a task to populate/change AD users attribute called ProxyAddresses. Generally, that’s not so hard – a few clicks and a bit of writing. But this time, it had to be done for a couple of hundreds of users. It was time to spend some time and create a PowerShell script that…

Read More

Hyper-V and Powershell to save the day

If you are managing Virtualized infrastructure by using Hyper-V, this small script may come in handy (and save you from getting a headache). Few clients have a procedure to create VM Snapshot before making some big changes to the VM (I know, that’s not a backup solution but I can’t win all the battles). The problem…

Read More

How to disable Dir Sync in Office365

Hello all, Even though disabling Dir Sync is not daily task for Office 365 admins, you should know how to do that if you need to do that. In older versions of Office 365 Admin Center, disabling Dir Sync was one of option from UI, but option is removed a long time ago. Process is…

Read More

How to create custom name self signed certificate using PowerShell

Hello, Few days ago, one of my clients start with implementation of ASP.NET application in three different environment (Dev, QA and Prod). Their request was pretty same as usual, except one condition. They want self-signed SSL certificate on IIS server with custom name for each application. I said “OK”, but when I tried to create…

Read More

How to install PowerShell v4

Hello everyone, long time no see 🙂 Today, I’ll give quick tutorial how to install PowerShell version 4. By default PowerShell version 2 is available in 2008 R2 & Windows 7, and there are many reasons to upgrade PowerShell to version 4. The process is simple and shouldn’t take you a lot of time. But,…

Read More

Auto-confirm deleting files in Powershell

Have you ever tried to remove a bulk of files from Powershell with command Get-ChildItem “Path” -Recurse | Remove-Item, but you received message: Get-ChildItem E:\Test -Recurse | Remove-Item The item at Microsoft.PowerShell.Core\FileSystem::E:\Test\001 has children and the Recurse parameter was not specified If you continue, all children will be removed with the item. Are you sure you want…

Read More