SQL Server Upgradation Log Shipping Tutorial | SQL Server DBA Tutorial – Part 8

SQL Server Upgradation Log Shipping Tutorial from Coding compiler | SQL Server DBA Tutorial – Part 8, this blog is the eighth tutorial in the series, here you are going to learn about how SQL server upgradation works. Before going to learn this tutorial, we recommend you to go through the previous SQL Server Restoration DBA Tutorial – Part 7.

Topics Covered in this SQL Server DBA Tutorial

  • What is SQL Server Upgradation?
  • SQL Server Upgrade Advisor Tool
  • Steps Involved in Installing Upgrade Advisor
  • Types of Upgradation
  • Inplace Upgrade
  • Side by Side Upgrade
  • Post upgrade checks
  • What is Log Shipping
  • Log Shipping Architecture
  • Components of Log Shipping
  • Configuring Log Shipping
  • TUF File in Log Shipping

Read more

SQL Getting Started Guide

Welcome to the Coding compiler. We bring your attention to the article with the screaming title of “Getting Started SQL in 20 Minutes”, Of course, you will not master all SQL in 20 minutes, but you will get a good start.

SQL Fundamentals

Every self-respecting web developer should know SQL. Although it already exists since the 70s of the last century, it is still very widely used, and without it it will be difficult to create something serious. Most full-stack frameworks can work with SQL. Among them: ActiveRecord ,  Doctrine ,  Hibernate and many others. Despite this, sometimes you have to “mess your hands” and go into real SQL.

That’s why we have prepared a short introduction in which we will go through the fundamental things in SQL. We strongly recommend that you try all the examples below on your own, because, as you know, a theory is nothing without practice. Well, let’s get started!

Read more

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

Read more

SQL Server DBA Tutorial – 6

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

Topics Covered in this SQL Server DBA Tutorial

  • Automation Introduction
  • Ways of Performing Automation
  • Autonation Jobs
  • How to Create a Job
  • Post Job Steps
  • Troubleshooting the Job Failures
  • Automation Maintenance Plans

Read more

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

Read more

SQL Server DBA Tutorial – Part 4

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

Topics Covered in this SQL Server DBA Tutorial

  • SQL Server Restoration
  • Situations for Restoration
  • Restoring Backups using SSMS (GUI)
  • Restoring Enhancements in SQL Server 2012

Read more

SQL Server DBA Tutorial – Part 3

SQL Server Backup Tutorial from Coding compiler | SQL Server DBA Tutorial – Part 3, this blog is the third tutorial in the series, here we are going to learn about these below topics. Before going to learn this tutorial, we recommend you to go through the SQL Server DBA Tutorial – Part 1 and SQL Server DBA Tutorial – Part 2.

Topics Covered in this SQL Server DBA Tutorial

  • Introduction to Backups
  • Recovery Models
  • Backup Types
  • Advanced Backup Types
  • Situations of Tail Log Backup

Read more

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

Read more

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.

Read more