Designing Solutions for SQL Server: (05) Troubleshooting and Maintaining a Database
[MP4] [0:53:19] [2015/02/02]Learn about key maintenance tasks to keep performance optimal and how to automate them. Plus, look into techniques and tools you can use to monitor a database, along with the kinds of information each…
Designing Solutions for SQL Server: (04) Designing a High-Availability Solution
[MP4] [1:12:52] [2015/02/02]Find out about the high-availability solutions supported by SQL Server (Log Shipping, AlwaysOn Availability Groups, AlwaysOn Failover Clustering, and P2P Replication). Look at key considerations for…
Designing Solutions for SQL Server: (03) Designing a Backup and Recovery Solution
[MP4] [0:50:18] [2015/02/02]Hear strategies for backup and recovery, including full, log, and differential backups, partial backups, and backing up to Azure blob storage, and get best practices for backing up system databases.…
Designing Solutions for SQL Server: (02) Designing Database Security
[MP4] [0:58:33] [2015/02/02]Learn about the security architecture of SQL Server, along with how to set permissions on objects. Find out how ownership chains work and how to manage cross-database ownership chains, and get details…
Designing Solutions for SQL Server: (01) Managing a SQL Server Environment
[MP4] [0:47:37] [2015/02/02]Explore considerations and tools available for managing a SQL Server environment, including SQL Server Agent, Resource Governor, SQL Server Audit, and Policy-based Management.