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.
SQL Server 2014 with PowerShell v5 Cookbook
By :
SQL Server 2014 with PowerShell v5 Cookbook
By:
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
Free Chapter
Getting Started with SQL Server and PowerShell
SQL Server and PowerShell Basic Tasks
Basic Administration
Security
Backup and Restore
Advanced Administration
Audit and Policies
High Availability with AlwaysOn
SQL Server Development
Business Intelligence
Helpful PowerShell Snippets
PowerShell Primer
Creating a SQL Server VM
Index
Customer Reviews