SQL Server DBA Tutorial

Below are the links that provide video learning on You Tube our channel " Tech Brothers" - These videos walk you through step by step of SQL Server 2014 DBA Tutorial/Training. Video Tutorials  provide beginner to advance level Training on SQL Server 2014 DBA Topics.

Installation

1. How to find installed Features in windows 8.1
2.  How to install SQL Server 2014 step by step
3. How to Install SQL Server 2016 Step by Step
4. How to Install Data Quality Services (DQS) in SQL Server
5. How to Install and configure Master Data Services in SQL Server
6. How to Install Data Quality Services Client
7. How to Install SSIS in SQL Server 2014
8. How to Create Integration Services Catalog
9. How to install and configure Reporting services in SQL Server 2014
10. How to Install SQL Server Data Tools ( SSDT )

SQL Server /Windows Cluster

1. How to Install SQL Server 2014 in Cluster mode
2. How to Add a Disk to Existing Cluster?
3. Cluster Pre-requisites Checklist
4. Setting Up Service Accounts for Cluster Nodes
5. How to Install Clustering Services on the First Node
6. How to Install Clustering Services on the second Node
7. How to add a new Node to Cluster
8. How to verify Cluster Installation
9. Configure Distributed Transaction Coordinator(DTC) in SQL Server Cluster
10. Active Active and Active Passive Cluster Configuration Overview
11. How to Install SQL Server in Active Passive Cluster
12. How to Configure Active Active Cluster
13. Checklist before we start SQL Server Installation for Cluster
14. How to Configure Static IP Address for SQL Server Instance/s in Cluster
15. Fail over the Main Node Resource to Another Node
16. How to Set Preferred Node Order for Failover
17. Cluster Configuration Manager Demo: Manage SQL Server 2012 Failover Cluster
18. How to Install Service Packs, Hot Fixed and Patches in Cluster
19. Verify/Validate Cluster configuration
20. How to Evict a Node from Cluster
21. How to Remove SQL Server Cluster instance from a Node
22. How to configure and use Windows Cluster Aware Updating Role - Part 1
23. How to configure and use Windows Cluster Aware Updating Role - Part 2
24. How to Rename Windows Cluster

Databases

1. SQL Server Create Database Best Practices
2. How to Create Database in SQL Server
3. How to Attach and Detach Databases 
4. How to Shrink Database And Database Files
5. How to Take Database Offline and Bring it Online
6. How to create Database Snapshot
7. How to Script out an Entire Database in SQL Server
8. How to change Compatibility level of a database and why do we do that?
9. How to get Database out of Single User Mode in SQL Server?
10. How to shrink MDF File of Database in SQL Server?
11. How to Rename a Database in SQL Server?
12. How to change database collation from Case Insensitive to Case Sensitive?
13. How to Retrieve the suspect database ? 
14. How to find out Owner of Any Database in SQL Server?
15. How do I change the ownership of a database?
16. How to avoid using C drive for Database Create in SQL Server?
17. How to disable Auto growth of Database in SQL Server?
18. How we can reduce Temp DB size with out restart Server?
19. How to release unused space of the Tempdb to Operating System(OS)?
20. How to update stats on all the databases on SQL Server or on Single Database in SQL Server?

Security

1. What is Login, User, Role and Principals in SQL Server?
2. How to create Windows Authenticated Login?
3. How to create SQL Authenticated Login?
4. How to create Windows Authenticated group login?
5. How to check Login Status in SQL Server?
6. How to disable/enable Login in sql server?
7. How to create a Database user?
8. How to map a user to an existing Login?
9. How to create User define Schema in a database?
10. How to create database role?
11. How to create an application Role?
12. How to provide explicit permission to specific tables to a user in a database?
13. How to provide execute permissions to a specific store procedure?
14. How to provide View definition permission of database objects to a user?
15. How to create server Role in SQL Server?
16. How to create Credentials in SQL Server?
17. How to see the SQL Server user password in SSMS, Can we script out SQL Server user password?
18. How to assign default Schema to AD Group in SQL Server?

Contained Database

1. What is Contained Database and how to Create Contained Database
2. How to Migrate or Move Contained Database to Different SQL Server and connect to Contained Database
3. How to Create Contained Database User in SQL Server

Backup Database

1. What is Database Backup and How Many Types of Backups available in SQL Server
2. How to manually (Adhoc) take Full backup of database in SQLServer?
3. How to manually take Differential Backup of a database in SQL Server?
4. How to manually take Transactional Log Backup of a database in SQL Server?
5. How to manually Take Tail Log Transactional Log Backup of a database in SQL Server?
6. How to create backup Maintenance Plan in SQL Server?
7. How to Schedule databases backup in SQL Server?
8. How to cleanup Old Backups in SQL Server?

Restore Database

1. How to restore a database from Full Backup in SQL Server?
2. How to restore a database from Differential Backup in SQL Server?
3. How to restore a database to specific time (Point in Time) in SQL Server?
4. Cannot open backup device 'F:\foldername'. Operating system error 5(Access is denied.)
5. How to turn a database status from "in recovery" to "online"?

How to Restore / Rebuild / Recover System Databases

1. How to Restore MSDB Database in SQL Server
2. How to Restore Master DataBase in SQL Server
3. How to Rebuild MSDB in SQL Server
4. How to Rebuild Master Database in SQL Server Method1
5. How to Rebuild Master and Other System Databases in SQL Server 
6. How to Move TempDB Data and Log Files in SQL Server
7. Overview of Model Database in SQL Server

Server Level Auditing

1. How to Create Server Audit Specifications in SQL Server?
2. How to create server level Audit in SQL Server?
3. How to create server level Trigger in SQL Server?
4. How to create Policies in SQL Server?
5. How to create Policy Conditions in SQL Server?
6. How to create and use Facets in SQL Server?

Data Collection and Management Data Warehouse

1. How to configure Data collection in SQL Server?
2. How to configure Management Data Warehouse in SQL Server?

Introduction to Extended Events 

1. What is Extended Events in SQL Server?
2. How to create an Extended event in SQL Server?
3. How to Enable and Disable Extended Events in SQL Server?

SQL Server Configuration Manager

1. Detailed overview of SQL Server Configuration Manager

Replication

1. What is replication, Types of replication and when to use each type
2. Why do we use Replication, Provide couple scenarios
3.  How to Configure Distribution in SQL Server Replication
4. How to Create Snapshot Replication?
5. How to Create Transactional Replication?
6. How to create Merge Replication?
7. When do we use snapshot replication
8. What is re initializing means in replication
9. What is Orphan replication And how would you cleanup replication
10. Under what circumstances will you re initialize replication
11. How the schema changes are handled in SQL Server Replication
12. How would you add new tables in existing replication
13. How would drop replicated database
14. How will you truncate the replicated table
15. Replication Error, can't connect to actual server, @@servername returns Null
16. How to find out if Replicaiton is failed or broken
17. How to setup Peer-to-Peer Transactional Replication?
18. How to add Article in Peer-to-Peer Transactional Replication?
19. How to create Merge Replication with Multiple Subscribers and Perform Diff Scenarios
20. How to Change Sync Time for 60 Seconds to 0 Seconds in Merge Replication

Resource Governor

1. What is Resouce Governor in SQL Server?
2. How to Create Resource Pool in Resource Governor of SQL Server?
3. How to Create WorkLoad  Group in Resource Governor of SQL Server?
4. How to create Classifier Function in Resource Governor?
5. How to Enable and Disable Resource Governor in SQL Server?

Mirroring

1. How to setup Database Mirroring in SQL Server? 
2. How to Stop and Start Database Mirroring Endpoints in SQL Server?
3. How to Remove Database Mirroring in SQL Server

Database Log Shipping

1. How to Configure database Log Shipping in SQL Server?
2. How to Remove Database Log Shipping in SQL Server?

 

Linked Server

1. How to Create Linked server in SQL Server

SQL Server Agent

1. Overview of SQL Server Agent Configuration?
2. How to create Job using SQL Server Agent?
3. Job Categories Overview in SQL Server Agent?
4. How to create an alert in sql server?
5. How to create an Operator in SQL SERVER?
6. How to run SQL Server Agent jobs in Batch file?
7. How to Run SQL Server Agent Job from Local or Remote SQL Server Agent Job
8. How to Enable/Disable SQL Server Agent Job, How to Enable Job after some days automatically?
9. How To Delete ERROR LOGS IN SQL SERVER?
10. How to get the detail for the cause of the SQL Server Agent job failure?
11. How to send email to multiple email accounts from SQL Server Agent Job if fails?
12. How to find out which SQL Server Agent Jobs are running at the moment on SQL Server?

Sql Server Proxies

1. What is Proxy in SQL Server (Overview)
2. How to create Operating System (cmdExec) proxy in SQL Server
3. How to create SSIS Package Execution in SQL Server?
4. How to create ActiveX Script Proxy in SQL Server?

Configure Database Mail

1. How to Setup Database Mail in SQL Server?
2. How to setup the Email notification if any job got failed?

SQL Server Profiler

1. How to start SQL Profiler automatically after a SQL Server Service Restart

Maintenance Plan

1. How do I temporarily disable my maintenance plan?
2. How to create Maintenance plan for Backups and delete old backup files in SQL Server?

Built-in Tools

1. How to connect to SQL Server from another computer?
2. How to find out what configuration changed on sql server last hour?
3. How can I connect the database from SQLCMD Tool?
4. How to find if Database is in use?
5. What is Dedicated Administration Connection ( DAC ) and What is use of DAC?
6. How to Change Port and IP Address for SQL Server?
7. How to save query results to text file from SSMS in SQL Server?

Blocking Locking

1. How to find blocking and deadlock in SQL Server?
2. How to send Alter when a process is blocked in SQL Server

Server Level Settings

1. How can I reset Maximum number of concurrent connections in Sql server 2014?
2. How much memory is allocated to SQL Server instance?
3. How to rename SQL Server Instance Name?
4. How to check CPU % Usage by SQL Server?
5. How to check Port SQL Server is using?

Migration

1. Migration strategy for SQL Server 2008 to SQL Server 2012/ SQL Server 2014
2. What is Difference between In place and Parallel Migration in SQL Server?
3. Explain all the Steps or documents Or a checklist for Migration in SQL Server?
4. Demo: In Place Migration of SQL Server 2012 to SQL Server 2014

           a) In-Place Upgrade of SQL Server 2012 to SQL Server 2014 Part 1
                    - Installation of Upgrade Advisor 2014 and Upgrade Advisor Overview

           b) In-Place Upgrade of SQL Server 2012 to SQL Server 2014 Part 2 
                   - Upgrading SQL Server 2012 Engine
                   - Upgrading SQL Server 2012 Management components

     5. Demo: Migration for SQL Server 2008 to SQL Server 2012 by using ( Backup/Restore) Method

          a)  Upgrade of SQL Server 2008 R2 to SQL Server 2012 Part 1
                   - Upgrade checklist overview
          b)  Upgrade of SQL Server 2008 R2 to SQL Server 2012 Part 2
                   - Identifying database
                   - Backing up all source databases
                   - Scripting out login
                   - Scripting out Server Roles
                   - Scripting out Backup devices
                   - Scripting out Server Level Triggers
                   - Scripting out Data Collection
                   - Script out Linked Servers
          c)  Upgrade of SQL Server 2008 R2 to SQL Server 2012 Part 3
                   - Mirroring Information from the database
                   - Script out All SQL Server Agent Jobs
                   - Viewing DBMail information on the source
                   - Scripting out Proxy and credentials
                   - Scripting out Operator and Alerts
                   - Scripting out SQL Server Configuration
          d)  Upgrade of SQL Server 2008 R2 to SQL Server 2012 Part 4
                   - Overview of Destination Checklist
                   - Restoring Databases on Destination
                   - Changing compatibility to SQL Server 2014
          e)  Upgrade of SQL Server 2008 R2 to SQL Server 2012 Part 5
                   - Transferring Logins (Executing Scripted Logins on destination server
                   - Transferring Replication (Executing Source Replication on destination)
                   - Transferring Linked servers (Executing Scripted Linked server)
                   - Transferring Server Level Triggers (Executing Scripted Triggers on destination server)
                   - Scripting out Operator and Alerts
                   - Server Audit and Audit Specification script execution
          f)  Upgrade of SQL Server 2008 R2 to SQL Server 2012 Part 6
                   - Creating databases backup Maintenance plan

     6. How do Migrate Logins from SQL Server 2008 to SQL Server 2014?

     7. How to Migrate SQL Server Agent Jobs from SQL Server 2008 to SQL Server 2014?

SQL Server Database Deployment

1. What does "Deployment" means for SQL Server DBA?
2. What are the best practices for SQL Server Deployment?
3. How to Perform a SQL Server Deployment Step by Step
4. How to use Team Foundation Server (TFS) and DeploymentDocument for Database Deployment

AlwaysOn Availability Groups

1. How to Setup/Configure AlwaysOn Availability Group in SQL Server 2014 Step by Step
2. How to Resolve Availability Group Listner Errors
3. Setup AlwaysOn Availability group when SQL Server instances are installed in Cluster mode Part1 ( 2 Node Scenario)
4. Setup AlwaysOn Availability group when SQL Server instances are installed in Cluster mode Part2 ( 2 Node Scenario)
5. AlwaysOn Availability Group on SQL Server Failover Instances  Installed in Cluster Mode ( 4 Node Scenario)
6. How to provide Permissions to User on AlwaysOn Availability Group in SQL Server?
7. How to Plan Backups with Always On Availability Groups in SQL Server
8. AlwaysOn Availability Group Dashboard Introduction
9. Setup Alerts for AlwaysOn Availability Group Failover in SQL Server
10. How to Restore A database which is part of AlwaysOn Availability Group
11. Patching Or Updating AlwaysOn Availability group Replicas in SQL Server Best Practices
12. Patching or Updating Availability Group with SQL Server Failover Cluster Instance - Part 1
13. Patching or Updating Availability Group with SQL Server Failover Cluster Instance - Part 2
14. Patching or Updating Availability Group with SQL Server Failover Cluster Instance - Part 3
15. Patching Or Updating SQL Server with multiple AlwaysOn Availability Groups
16. Patching or Updating Availability Group with one Secondary
17. How to Apply Windows Updates to Failover Clusters Hosting SQL Server AlwaysOn Availability Groups
18. How to setup Replication on AlwaysOn Availability Groups in SQL Server Part1 Part2 

Miscellaneous

1. What are Synonyms and How to Create Synonyms in a Database of SQL Server - DBA Tutorial
2. How to compare these two databases and find what is the difference between these two databases?
3. How to Scripts Users with permissions from SQL Server Database?
4. How to find out who has deleted the Login in SQL Server?
5. How to find out who has modified or created object in SQL Server?
6. How to access SQL Server Instance from the network?
7. How to know the reason why sql server restarted.
8. How to find when and who dropped my database?
9. How to find if a server in a cluster is running on Primary node?
10. How to check the size of SQL Error Log in SQL Server?
11. How to automate Back up and Restore
12. How to migrate the integration services (SSIS)
13. How to send Alter When Storage Drives are 80% filles from SQL Server
14. How to Drop login with all users from multiple database in SQL Server?
15. How to Find Users and their AD Groups in SQL Server?
16. How to Find Port Number of SQL Server instance by using SQL Server Management Studio?