LearnNowOnline_SQL_Admin_2014_Automating_Management_And_Config

در این آموزش تصویری با مدیریت و کانفیگ SQL Server 2014 آشنا می شوید.

این دوره آموزشی محصول موسسه LearnNowOnline است.

سرفصل های دوره:

  • پایگاه داده ایمیل
  • امنیت
  • پیکربندی پایگاه داده ایمیل
  • پیکربندی با استفاده از اسکریپت
  • اپراتورها و هشدارها
  • ایجاد یک اپراتور
  • دستورات DBCC
  • DBCC CHECKDB خودکار
  • پشتیبان گیری خودکار
  • استفاده از گروه های فایل
  • شاخص گروه فایل
  • پایگاه داده های موجود
  • بازیابی پایگاه داده
  • گزینه های پیکربندی SQL
  • Enum ها در نمایش ها
  • محدودیت مسیر
  • ASP.Identity و OWIN
  • فریم ورک OWIN
  • فیلترهای احراز هویت
  • داشبورد
  • کنترل کننده کد
  • اجرای برنامه
  • و…

عنوان دوره:  LearnNowOnline SQL Admin 2014: Automating, Management, & Config
مدت زمان: 1 ساعت و 32 دقیقه
نویسنده:  Chris Bell

 توضیحات:

LearnNowOnline SQL Admin 2014: Automating, Management, & Config

Chris Bell
1h 32m


Course description
For this course you see various methods to automate processes in SQL Server. You will go through configuring Database Mail so that you, as the DBA, can receive automated alerts from the server when something goes wrong. You will see how to set up Operators to receive general alerts, custom alerts and then create, based on performance conditions, queries that run for long periods of time. You'll review the DBCC commands that are critical to ensuring database integrity and providing valuable insight into what's going on inside the SQL Server system. Then you will see how to take advantage of the AlwaysOn Availability Group ability to offload some maintenance tasks from our primary servers to secondary servers. Next you are going to see File Groups and show how you can use them to manage our data files and potentially improve the performance of queries and requests to SQL databases. Next you will see how to create a new SQL Contained database and move it to a new server showing you just how easy it is to relocate databases using this feature. You will finish up by going over a large number of configuration options available to us in SQL Server. You will see general and advanced settings and detail how each affects SQL Server.
Prerequisites
This course assumes that students have working experience with SQL Server; basic relational database concepts e.g., tables, queries, and indexing; general knowledge of XML, Transact-SQL, and a fundamental understanding of networking and security concepts.

Database Mail
11:02
Introduction
00:27
Database Mail
00:41
Database Mail - Reliability
01:15
Database Mail - Security
01:15
Demo: Database Mail Config
05:17
Demo: Config Using Scripts
01:51
Summary
00:13
Operators and Alerts
14:00
Introduction
00:24
Database Operators
01:02
Demo: Creating an Operator
01:47
Alerts - Types
01:40
Demo: Alerts
04:08
Demo: Longest Transaction Alert
04:39
Summary
00:17
DBCC Commands
06:19
Introduction
00:24
Automating DBCC CHECKDB
03:55
Demo: Automating CHECKDB
01:43
Summary
00:15
Availability Group Backups
23:37
Introduction
00:30
Automating Backups
01:06
Backups - Always On
01:20
Demo: Automating Backups
05:33
Demo: Transaction Logs
05:14
Demo: Testing Backups
04:32
Demo: Transaction Testing
05:09
Summary
00:09
Using File Groups
10:19
Introduction
00:32
File Groups
01:23
Demo: File Groups
05:56
Demo: File Group Index
02:14
Summary
00:12
Contained Databases
16:17
Introduction
00:38
Contained Databases
01:24
Contained Databases - Pros
01:24
Contained Databases - Cons
00:30
Demo: Contained Databases
05:26
Demo: Logging In
05:02
Demo: Restoring a Database
01:37
Summary
00:13
Configuration Options
11:17
Introduction
00:22
SQL 2014 Configuration Options
05:21
Demo: Advanced Options
02:13
SQL 2014 Configuration Options 2
03:04
Summary
00:16