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

Backup Database

Restore Database

How to Restore / Rebuild / Recover System Databases

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

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

 

Linked 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

Configure Database Mail

SQL Server Profiler

Maintenance Plan

  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. 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?

28 comments:

  1. I feel satisfied to read your blog, you have been delivering a useful & unique information to our vision.keep blogging.
    Regards,
    ccna Training in Chennai
    ccna course in Chennai
    PHP Training in Chennai
    ReactJS Training in Chennai
    ccna course in chennai
    ccna training in chennai

    ReplyDelete
  2. I appreciate your blog and thanks for sharing this information. I am a data analyst and providing analytics courses delhi

    ReplyDelete
  3. HI, Could you please help me in one doubt.
    How to set notification, when job gets retry. We can set a notification on any job failure. But how can we set a notification, when any job is retrying on step.
    Suppose there is one job "ABC" of 8 step. But always this job is retrying on the 7th step due to heavy load on the server. If it is retry on 7th step, then job will delay almost 2 hours. So to avoid this thing, i want to set a notification for any retry attempt.

    ReplyDelete
  4. Just stumbled across your blog and was instantly amazed with all the useful information that is on it. Great post, just what i was looking for and i am looking forward to reading your other posts soon!

    ReactJS Online Training

    ReplyDelete
    Replies
    1. I am a subscriber to their Youtube Channel, but their blog is a jewel.

      Delete
  5. Hi, Good afternoon, I have create cluster. but not connecting to sqlserver with clusterip in client system. please help him (all system in same network and cluster ip is pinging in client system)

    ReplyDelete
  6. Here at Shivam Polychem we are providing you best quality black masterbatches
    We are leading supplier and manufacturer of black masterbatch

    ReplyDelete

  7. Nuvigil smart drug is the trade name for Armodafinil smart drug and is the enantiopure compound of Modafinil. There are a number of health benefits that the use of Nuvigil smart drug has to offer to its users. So, you can buy Nuvigil online. The use of the smart drug is safe and has no health issues attached to its usage. In the year 2006, the FDA approved the use of generic Nuvigil smart drug to be used to treat a number of mental issues. Buy Nuvigil online as the use of Nuvigil smart drug has long effect when compared to other smart drugs. This is mainly because Armodafinil smart drug has a longer half-life than the other smart drugs. Therefore more and more people are depending on Nuvigil smart drug to carry on their daily routine smoothly.
    Buy Nuvigil online

    ReplyDelete
  8. Wonderful blog post, thank you so much for the great information which you provided.
    https://rokucomlinks.org/

    ReplyDelete
  9. We are providing you best quality calcium carbonate based filler compounds used in plastic industry
    We are leading supplier and manufacturer of filler masterbatches in bawana

    ReplyDelete
  10. Here at Shivam Polychem we are providing you best quality masterbatches in delhi
    We are the leading supplier and manufacturer of masterbatches

    ReplyDelete
  11. Here at Shivam Polychem we are providing you best and high quality masterbatches
    We are the leading supplier and manufacturer of masterbatches in delhi

    ReplyDelete

  12. very nice collection of blog post you have posted here thank you very much for posting such blog post.


    Party Hall Booking || Banquet Halls in Delhi || Party Halls in West Delhi

    ReplyDelete
  13. Here at Shivam Polychem we are providing you best quality calcium carbonate masterbatches
    We are the leading supplier and manufacturer of masterbatches

    ReplyDelete
  14. Here at Shivam Polychem we are providing you best and high quality calcium carbonate masterbatches
    We are the leading supplier and manufacturer of masterbatches

    ReplyDelete