2017 | Our Tech Ideas

8 min read 1

Installation and Configuration
MSSQL

SQL Server installation

OTI
6 January 2017

Installation Whenever we want to start the installation of the…

3 min read 2

Architecture
MSSQL

SQL Server Transaction Log Architecture

OTI
5 January 2017

Transaction Log Architecture SQL Server uses LSN (Log Sequential Number)…

4 min read 10

MSSQL

SQL Server Database Architecture

OTI
4 January 2017

SQL Server data mainly in 2 types of files, Data…

3 min read 3

MSSQL

SQL Server Storage Architecture

OTI
3 January 2017

In an SQL server all the data will be stored…

5 min read 4

MSSQL

SQL Server Architecture

OTI
2 January 2017

Introduction If you’re curious about how SQL Server works behind…

2 min read 7

MSSQL

SQL Server Database Administration Introduction

OTI
1 January 2017

1. Database Administration A database administrator is a person responsible…

Year: 2017

SQL Server installation

SQL Server Transaction Log Architecture

SQL Server Database Architecture

SQL Server Storage Architecture

SQL Server Architecture

SQL Server Database Administration Introduction

In-Place Upgradation vs Side-by-Side Migration in SQL Server

Microsoft Entra ID Authentication in SQL Server

Everything was fine yesterday—now it’s super slow!

Detect and Fix Orphaned Users in SQL Server – The Complete Guide (All Possible Methods)

Detect and Fix Orphaned Users in SQL Server – The Complete Guide (All Possible Methods)

Exploring SQL Server Agent Jobs

Monitoring SQL Server Agent Jobs

Upgrading Windows Server Failover Cluster Functional Level

Ultimate Guide to SQL Performance Tuning Interview Questions

SSMS 21 Solves Major Blocking Issues

Database Auditing Best Practices: SQL Server Scripts for Security & Compliance

SQL Server Post-Installation Checklist