SQL Server DBA Archives - CodingCompiler

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

SQL Getting Started Guide

by Coding Compiler

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!

SQL Server Migration Tutorial – Part 7

by Coding Compiler

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

SQL Server DBA Tutorial – 6

by Coding Compiler

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

SQL Server Security Tutorial – Part 5

by Coding Compiler

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

SQL Server DBA Tutorial – Part 4

by Coding Compiler

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

SQL Server DBA Tutorial – Part 3

by Coding Compiler

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

SQL Server DBA Tutorial – Part 2

by Coding Compiler

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

SQL Server DBA Tutorial

by Coding Compiler

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.