Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500.
An Overview of SQL Server 2014
- SQL Server 2014 Architecture
- Available Features and Tools
- New Capabilities
- SQL Services
- Product Licensing
- Product Editions
Installing SQL Server 2014
- Preparing for Installation
- Creating Users for Service Accounts
- Choosing Appropriate File Locations
- Choosing Instance Names
- Installing SQL Server 2014
- Choosing Appropriate Features
- Specifying Service User Accounts
- Choosing Licensing Mode
- Choosing Appropriate Collation
- Installing Multiple Instances
- Upgrading to SQL Server 2014
Configuring SQL Server 2014
- Registering Servers
- Using Metadata Views to Obtain Object Properties
- Using Object Explorer
- Configuring a SQL Server Instance
- Configuring Object Properties
- Using the Query Window
- Creating Transact SQL Projects
- Managing Services
- Configuring Server Network Connections
- Configuring Client Connections and Aliases
- Configuring the Surface Area of SQL Server
- Configuring Policy-Based Management
- Creating a Central Management Server
- Using the Dedicated Administrator Connection
- Configuring Data Replication
- Creation and Maintenance of Full-Text Catalogs
- Describing Full-Text Search
Using SQL Server 2014 Management Tools
- SQL Server Management Studio
- SQL Server Configuration Manager
- SQL Server Books Online
- SQLCMD
Monitoring Data Structures
- Creating DDL Triggers
- Creating Event Notifications
- Configuring SQL Server Audit
Creating and Configuring a Database
- Creating Databases
- Creating a Contained Database
- Creating Tables
- Memory Optimized Tables
- Specifying Data Types
- Creating Indexes
- Describing Data File Structure
- Describing Log File Structure and Function
- Creating Filegroups
- Configuring Filestream Storage
- Configuring FileTables
- Creating and Using Database Snapshots
- Moving a Database to Another SQL Server
Monitoring SQL Server Performance
Securing SQL Server
- SQL Server Security Architecture
- Defining Principals and Securables
- Using the Security Hierarchy
- Creating Logins and Users
- Applying Password Policies to SQL Logins
- Creating Server and Database Roles
- Granting Permissions
- Using SQLCMD to Test Permissions
- Creating and Using Certificates
- Setting Execution Context
- Encrypting Data
- Encrypting Databases
Maintaining High Availability of Data
- Windows Clustering
- AlwaysOn Availability Groups
- Implementing Database Mirroring
- Implementing Log Shipping
Maintaining High Availability of Data
- Windows Clustering
- AlwaysOn Availability Groups
- Implementing Database Mirroring
- Implementing Log Shipping
Backing Up and Restoring Databases
- Choosing Appropriate Database Recovery Model Option
- Describing Automatic Recovery
- Choosing an Appropriate Backup Strategy
- Determining Backup File Contents
- Designing a Database Recovery Plan
- Using Backup Compression
- Use of Filegroups in a Backup Strategy
- Restoring the Master Database
- Rebuilding System Databases
- Encrypting Backup Files
- Using Backup to URL to Backup or Restore from Windows Azure BLO
