MCPmag

Introduction to SQL Server Management Objects with PowerShell

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...
Visual Studio Magazine

PowerShell vs. SQL Server Management Studio

When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 R2 evaluation to the free Express version, I ...
I Programmer

PowerShell for SQL Server Essentials

This book aims to introduce you to PowerShell and how it can be used with SQL Server. How well does it do it? PowerShell is Microsoft’s preferred scripting tool, useful for task automation and ...
Redmond

Creating Azure SQL Databases with PowerShell and Azure Resource Manager Templates

There are lots of ways to create MSSQL databases via PowerShell. We could invoke a T-SQL query using the CREATE DATABASE term, we could write some code to use the [Create() method with SMO] or, if ...
MCPmag

Creating an SSIS Catalog with PowerShell

When deploying SQL Servers and when you need to implement some of kind of business intelligence, chances are you're going to need a SQL Server Integration Services (SSIS) catalog. A SSIS catalog is a ...