Overview/Description Enterprises use databases to store their most critical data. To protect and ensure the data's availability, database administrators need to establish a solid backup and restoration plan. Such plans are used to protect data in the event of a disaster by allowing complete sets of duplicate data to be restored in a timely fashion. There are multiple types of backups that can be taken to ensure data can be recovered, including to the point of failure or a point-in-time recovery. This course demonstrates how to perform backup and recovery operations.This course is one of a...

Overview/Description To keep SQL Server 2012 databases running as efficiently as possible, there are a variety of performance tuning and monitoring tools. The SQL Server Profiler enables you to use trace files and logs to analyze a database's performance. You can also use the Windows System Monitor to monitor SQL Server 2012 using counters, which monitor specific aspects of the server for performance issues. SQL Server 2012 includes the Activity Monitor, which provides an overview of the system's performance in real-time. SQL Server 2012 provides a the Resource Governor, which allocates...

Overview/Description SQL Server 2012's core component is its Database Engine instance, which provides storage, processing, and security for enterprise data through its controlled access and rapid transaction processing. SQL Server 2012 also provides additional features and components to manage and view data, these include Analysis Services and Reporting Services.SQL Server 2012 provides tools to manage the features and components which includes Server Management Studio’s graphical user tool which allows administrators and developers to create and configure instances and databases on an...

Overview/Description Database maintenance is an ongoing task for SQL Server 2012 administrators. This requires the integrity of the database to be checked, the database size to be kept to a minimum by ensuring the files are the correct sizes, and maintenance tasks to be run regularly. SQL Server 2012 Transact-SQL provides DBCC, which is a command that provides statements to maintain the database and database files. An administrator can also create jobs using SQL Server Agent to automate administrative tasks in the SQL Server Database Engine and throughout the enterprise by having the jobs run...