-
SQL Server VSS Writer Service
Microsoft built the capability into windows allowing files to be backed up to disk while other programs are using those files. The VSS Servicer interacts…
//
-
SQL Server Architecture Diagram
Hey guys, In this blog I am going to explain you about SQL Server Architecture Diagram In almost every SQL DBA interview, this is the…
//
-
Phases of Recovery in Database
At the time of SQL instance reboot or start, database goes in the three phases of recovery… 1. Analysis Phase of recovery 2. Redo Phase…
//
-
Data Page and Transaction Log Page
Hey guys, In this blog I am going to explain you about Data Page and Transaction Log Page. Data page- In SQL Server, the page…
//
-
SQL Server Memory Architecture
There are four major components of SQL memory architecture… 1. Memory Broker2. Memory Object3. Memory Clerk4. Memory Node In short, BOCN. (For remember it “Boy…
//
-
Mirroring Witness getting disappear from Mirroring Setup…
Recently we have faced one issue where DB mirroring witness getting disappear from mirroring setup. This is happening once Principal get down or SQL services…
//
-
Essential SQL Server Topics for Database Administrator
Below are SQL Server topics which are essential for Database Administrator… Server, DB Architecture ○ Server Architecture & Protocols ○ Query Processor & Storage Engine…
//
-
Contained Database
First introduced in SQL 2012 and its supported now. What it is Contained databases have no dependencies on server-level metadata and settings. User can access…
//
-
Dive into Buffer pool extension
The Buffer pool extension feature started from SQL server 2014. This is a nice addon to SQL server to extend the memory paging to SSD.…
//
-
Let’s talk about In memory OLTP
In-memory OLTP frequently referred to by its code name “Hekaton”, was introduced in SQL Server 2014 but it got more popular from SQL Server 2016.…
//
-
SQL Server Info (Inventory)
— SQL Server Info (Inventory) SELECT SERVERPROPERTY(‘ServerName’) AS ServerName, SERVERPROPERTY(‘MachineName’) AS MachineName, CASE WHEN SERVERPROPERTY(‘InstanceName’) IS NULL THEN @@SERVICENAME ELSE SERVERPROPERTY(‘InstanceName’) END AS InstanceName, SUBSTRING ( (SELECT @@VERSION),1, CHARINDEX(‘-‘,(SELECT @@VERSION))-1 ) as ProductName, SERVERPROPERTY(‘ProductVersion’) AS ProductVersion, SERVERPROPERTY(‘ProductLevel’) AS ProductLevel, SERVERPROPERTY(‘ProductMajorVersion’) AS ProductMajorVersion, SERVERPROPERTY(‘ProductMinorVersion’) AS ProductMinorVersion, SERVERPROPERTY(‘ProductBuild’) AS ProductBuild, SERVERPROPERTY(‘Edition’) AS Edition, CASE SERVERPROPERTY(‘EngineEdition’) WHEN 1 THEN ‘PERSONAL’ WHEN 2 THEN ‘STANDARD’ WHEN 3 THEN ‘ENTERPRISE’ WHEN 4 THEN ‘EXPRESS’ WHEN 5 THEN ‘SQL…
//
-
Auditing: Change Data Capture(CDC)
Overview: Change Data Capture, also known as CDC, introduced the first time in SQL Server 2008 version. Change data capture records insert, update, and delete activity…
//