Book Image

SQL Server 2014 with PowerShell v5 Cookbook

By : Donabel Santos
Book Image

SQL Server 2014 with PowerShell v5 Cookbook

By: Donabel Santos

Overview of this book

Table of Contents (21 chapters)
SQL Server 2014 with PowerShell v5 Cookbook
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

Introduction


SQL Server has seen immense enhancements and support to different components that were traditionally not supported natively in databases, such as XML and Common Language Runtime (CLR) assemblies. This chapter explores how you can use PowerShell to simplify and automate some of the tasks you need to do with these items.

To do the exercises in this chapter, perform the following steps:

  1. Create a sample database named SampleDB and use it for the tasks in this chapter:

    CREATE DATABASE SampleDB
  2. Download the files for this chapter from the Packt website and save them to your local drive. You will find the following folders in your downloaded package:

    • Text files

    • BLOB files

    • CLR files

    • XML files