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:
Create a sample database named
SampleDB
and use it for the tasks in this chapter:CREATE DATABASE SampleDB
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