Chapter 6. Advanced Administration
In this chapter, we will cover the following topics:
- Connecting to LocalDB
- Creating a new LocalDB instance
- Listing database snapshots
- Creating a database snapshot
- Dropping a database snapshot
- Enabling FileStream
- Setting up a FileStream Filegroup
- Adding a FileTable
- Adding a full-text catalog
- Adding a full-text index
- Creating a memory-optimized table
- Creating a database master key
- Creating a certificate
- Creating symmetric and asymmetric keys
- Setting up Transparent Data Encryption
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 ...
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.
