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