SQL SERVER – Error: 17300 – The Error is Printed in Terse Mode Because There was Error During Formatting

One of my clients contacted me in a situation where their business was down! Their production SQL Server instance used by their Human Resource team was unable to start in a clustered environment. In this blog, we would learn about how to fix the error: 17300 – The error is printed in terse mode because there was an error during formatting received during SQL startup. (To save my client privacy, I have changed the name and location)

Read More

SQL SERVER – Script – Turn off Firewall Remotely (PowerShell, NetSh, PsExec)

I was working with a client to deploy an automated solution to install SQL Server. Since this involved scripting and running PowerShell remotely, we wanted to disable the firewall. Due to automation, we were not supposed to log in to the server and use UI. So, I search on the internet and found a few ways to do that. In this blog, I am going to share scripts which can turn off the firewall remotely.

Read More

PowerShell – Get Maximum Memory of Server with dbatools

Yesterday I blogged about the very famous Powershell free community tool dbatools. After writing this blog post, I received some interesting emails. I think lots of people confused this with native PowerShell. Well, actually dbatools is build using PowerShell scripts and runs under the hood script of PowerShell. The biggest advantage of the PowerShell is that it helps us to do multiple operations like finding the maximum memory of the server.

Read More