Automating BCP with PowerShell

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

Fun with Powershell

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.

Install SSMS using Powershell DSC

Learn how you can install SMSS automatically using PowerShell DSC as this series continues.

PowerShell Dynamic Parameters and SQL Server

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.

Using a SQL Tokenizer

Imagine this: you have several directories full of SQL script files, and you need to know where a certain table is used. You’d rather like the context too, so you can check the whole SQL Expression and work out why it is running so slowly.

The PowerShell Array Removal

PowerShell Commands to Administer Virtual Machines on Amazon AWS - Part 2

Learn about various PowerShell commands that can be used to administer virtual machines on Amazon AWS.

The PowerShell Copy

AutomatedLab - A Quickstart for Deploying SQL Server Labs on Windows

Learn how you can use AutomatedLab to quickly create new environments.

Database Sequence Objects with dbatools

This article delves into five new dbatools command that work with sequence objects.