Tag: PowerShell

Your mission: Gather a list of servers in a specific collection on System Center Configuration Manager (SCCM) so you or your client can verify the servers in the collection. How will you do it? First, a disclaimer. I’m a data…

An interesting issue came across my desk this week. One of our clients has a number of PowerShell tasks running on SQL Server Agent job. One day, the jobs suddenly stopped working due to the error below: Message Executed as…

Problem There’s no doubt that storage is one of the key components to SQL Server performance and availability for both large and small SQL Server instances. With today’s increases in server and virtual server processing power and large-scale memory support,…

While working with a client recently, we came across a problem while testing data for completeness or errors after running an ETL process to import & manipulate the data. The main issue we ran across was that the overall client…

What is Azure’s Cloud Shell? Azure Cloud Shell is a browser-based, interactive shell that comes in two flavors: PowerShell and Bash. Microsoft has had this in public preview for some time now. It offers you the ability to pretty much…

The mission: Tell every DBA around the world about a secret formula that will give them powers. What power do you think that is? Freedom! Freedom to go work on projects that you want to do versus constantly putting out…

In my work as a Database Consultant, I enjoy technical challenges, but it’s always a painful process when I need to transfer my technical knowledge into a report. Writing the report isn’t really the difficult part; the real challenge is…

Introduction Visual Studio Code (aka VSCode or just Code) has been around for a few years now. The 1.0 release came out in April of 2016 and from there we have seen feature after feature added with every release. VSCode…

Learn what to consider when changing editors, and things to look at when testing a new one.

Sandeep Arora, SQL Server Database Consultant, provides a script for automating SQL Server Version and Database Compatibility Report by using PowerShell.