Category: PowerShell

PowerShell Notebooks are Available in Azure Data Studio

PowerShell Notebooks are now available in the November release of Azure Data Studio. Back in March I requested this feature be added to Azure Data

2019.11.05

Make Sure Your SQL Servers are Running the Latest CU with the New SQL Assessment cmdlets

Make Sure Your SQL Servers are Running the Latest Cumulative Update (CU) with the New SQL Assessment cmdlets available in the SqlServer module.

2019.07.30

Invoke-Sqlcmd is Now Available Cross-Platform in the SqlServer module

Invoke-Sqlcmd is Now Available for MacOS & Linux in the SqlServer module. The module has been posted as v21.1.18095-preview which means to download the module

2019.03.04

Scripts for SQL PowerShell Session at Microsoft Ignite 2017

This is just a quick blog post to share the scripts I used during my sessions at the Ignite conference this year. You can download

2017.09.28

#TSQL2sDay Long Story Short: Avoid -Scope User

For T-SQL Tuesday #94 the topic is databases and PowerShell. Rob Sewell asks us: What are you going to automate today? I’m going to automate

2017.09.11

DevOps or DataOps Either Way It’s Coming to SQL Server

For T-SQL Tuesday #91 the topic is databases and devops. Grant Fritchey asks us: How do we approach DevOps as developers, DBAs, report writers, analysts

2017.06.13