SQL Server Migration Tutorial – Part 7

SQL Server Migration Tutorial from Coding compiler | SQL Server DBA Tutorial – Part 7, this blog is the seventh tutorial in the series, here you are going to learn about how SQL server migration works. Before going to learn this tutorial, we recommend you to go through the previous SQL Server Restoration DBA Tutorial – Part 6

Topics Covered in this SQL Server DBA Tutorial

  • What is SQL Server Migration?
  • SQL Server Migration Scenarios
  • Development to Test and Test to Production Servers
  • Database Refreshing
  • Moving from Old Hardware to New Hardware
  • Migration between Data Centers
  • Consolidation
  • Steps involved in Migration
Continue reading “SQL Server Migration Tutorial – Part 7”

SQL Server Security Tutorial – Part 5

SQL Server Security Tutorial from Coding compiler | SQL Server DBA Tutorial – Part 5, this blog is the fifth tutorial in the series, here you are going to learn about how SQL server security works. Before going to learn this tutorial, we recommend you to go through the previous SQL Server Restoration DBA Tutorial – Part 4.

Topics Covered in this SQL Server DBA Tutorial

  • Security Basics
  • Levels of Security
    • Server level
    • Database level
    • Object level
  • Security Processes
    • Authentication
    • Authorization
    • Encryption
Continue reading “SQL Server Security Tutorial – Part 5”

SQL Server DBA Tutorial – Part 2

SQL Server DBA Tutorial – Part 2 from Coding compiler. This is the second tutorial in the series of SQL server dba tutorials. Here you are going to learn about service accounts, SQL server 2012 installation, SQL server databases and database properties. Before going to learn this tutorial, we recommend you to go through the SQL Server DBA Tutorial – Part 1

Topics Covered in this SQL Server DBA Tutorial

  • Service Accounts
  • Installing SQL Server 2012
  • Post Installation Steps
  • Introduction to SQL Server Database
  • How to create database in SQL server?
  • SQL Server Database Properties
Continue reading “SQL Server DBA Tutorial – Part 2”

SQL Server DBA Tutorial

SQL Server DBA Tutorial for beginners 2019 from Coding compiler. Database administrator is a person responsible for the database design, Implementation, maintenance and repair of the database. The main goal of DBA is to keep the database server always up and make it available to users. Incase of any failures DBA should minimize the Database by implementing powerful backup and restoring technique. Let’s start lean SQL server dba with step by step tutorials.

Continue reading “SQL Server DBA Tutorial”