Chapter 1. Getting Started with SQL Server and PowerShell
In this chapter, we will cover:
- Working with the sample code
- Installing SQL Server using PowerShell
- Installing SQL Server Management Objects
- Loading SMO assemblies
- Exploring the SQL Server PowerShell hierarchy
- Discovering SQL-related cmdlets and modules
- Creating a SQL Server Instance Object
- Exploring SMO Server Objects
Introduction
If you have been working with Microsoft products, or have been managing or developing on the Microsoft platform, you might be familiar with PowerShell. If not, I can predict that you are bound to encounter it sooner than later. Since you are holding this book, my prediction just came true.
PowerShell is Microsoft's automation platform, which includes both a shell (often ...
Get SQL Server 2014 with PowerShell v5 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
