Write For Us

Designing Database Solutions For SQL Server

E-Commerce Solutions SEO Solutions Marketing Solutions
273 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

ava
Published
Course/Tutorial: Designing Database Solutions for Microsoft SQL Server

Zero to Hero with SQL Server 2014: http://goo.gl/NaHkPa

This course offers the help you need. A team of experts walks you through key design considerations and recommendations for SQL Server data solutions.

Take a look at managing a SQL Server environment, along with helpful tools. Explore database security, backup and recovery solutions, and high availability. Plus, explore database troubleshooting and maintenance.

Managing a SQL Server Environment
Explore considerations and tools available for managing a SQL Server environment, including SQL Server Agent, Resource Governor, SQL Server Audit, and Policy-based Management.

Designing Database Security
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 on encryption methods and scenarios.

Designing a Backup and Recovery Solution
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. Learn how to restore a database, including a tail-log backup.

Designing a High-Availability Solution
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 Availability Groups and Failover Clusters.

Troubleshooting and Maintaining a Database
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 tool or technique provides.

If you feel useful for you and for everyone, please share it!

Source via: Channel9 - MVA

--
Zero to Hero with MongoDb
http://goo.gl/JD3b7E

Dynamic Data Masking in Azure SQL Database
http://goo.gl/u0noLY

Open Source Database on Microsoft Azure
http://goo.gl/L9Ysbm

------
Subscribe: http://goo.gl/gA1NLZ
Facebook: http://goo.gl/oEk624
Group: http://goo.gl/xPdeEX
Google+: http://goo.gl/iGZzZX
Twitter: http://goo.gl/PNRtC8
About & Contact: http://goo.gl/JAolqj
Category
Tech
Sign in or sign up to post comments.
Be the first to comment