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 matures and increases its already rich feature sets in each new version. You can now easily store unstructured data and binary large objects (BLOBs) in SQL Server using FileStream and FileTables. SQL Server also supports different levels of encryption, including column-level encryption and database-level encryption. In this chapter, we will explore how to connect and use LocalDB, set up FileStream and FileTables, configure full-text catalogs and indexes, and enable Transparent Database Encryption (TDE) in order to encrypt your whole database.