I was talking with a good friend that has an environment with terabytes of information and to create a homolog or dev environment to him is a pain. He comes to me with a solution : A PowerShell script that gets only the first 1000 lines of each table, creates the inserts and schema files … Read more
Have you ever been in a situation that you want to call a cmdlet or a function with a parameter that depends on a conditional criteria that is available as a list? In this article I will show a technique where you can use PowerShell Dynamic Parameters to assist the user with parameter values. In … Read more
Agile development has grown in popularity in recent years due to its success in delivering software on time and on budget. If you’re looking for a way to make your software development process more flexible and responsive, Agile might be a good option for you. There are many different Agile methodologies, but some of the … Read more
There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to get PowerShell to do more of the work.… Read more
PowerShell is a basic skill any administrator working in Windows or Azure should know. After writing his first article about PowerShell parameters, Greg Moore realized that there is even more to talk about. This article covers using pipelined parameters and more. … Read more
PowerShell scripts are the tool of choice for many admins, but how do you make them easy for others to use? In this article, Greg Moore shows how to add professional looking help to your scripts that work just like the help in cmdlets. … Read more
Smart DBAs automate tasks whenever possible. In this article, Greg Moore shows the need to use caution when using undocumented procedures for automating tasks, and that PowerShell may have what you need instead. … Read more
Comments are helpful when programming in any language, and PowerShell is no exception. In this article, Greg Moore demonstrates how to use comments to document code and to add prerequisites in PowerShell with #Requires.… Read more
PowerShell is a widely used tool for administrators. In this article, Allen White shows how to export objects using CLIXML and work with those objects without being connected to the original servers.… Read more
Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that can create a window for a countdown timer.… Read more
PowerShell is the preferred tool for many DBAs when automating SQL Server administration. In this article, Greg Moore demonstrates how to use a server list to control which tasks are performed on which servers.… Read more
When most of us think of robotics used in enterprises, automating manufacturing processes comes to mind. Robotics Process Automation (RPA), however, deals with automating mundane office tasks. In this article, Arvind Kumar explains the benefits of RPA and presents a case study.… Read more
It’s easy to use invoke-sqlcmd to send T-SQL statements to SQL Server from PowerShell. There is, however, a rich PowerShell library, sqlps, that can be used instead. In this article, Greg Moore shows how to use sqlps to treat a SQL Server instance as an object.… Read more
SQLPSX is a useful library you can add to PowerShell to automate many DBA tasks. In this article, Laerte Junior demonstrates several useful commands and shows you how to create a SQL Agent job using this library to run daily DBA checks.… Read more
In the third article of this series on testing PowerShell code with Pester, Robert Cain demonstrates how to test the functions in a PowerShell module. … Read more