Articles related to the SQL Server Administration

SQL Database Backup

We have multiple type of SQL database backups. Like, Full Backup, Differential Backup, Transaction Log Backup.

Keep reading
SQL Server AlwaysOn

Availability Group Listener in Always On

An Availability Group Listener is a Virtual Network Name (VNN), that clients can connect to in order to access the database in a primary or secondary replica of an Always on Availability Group

Keep reading
SQL Server Architecture

Page Life Expectancy, Buffer Cache Hit Ratio

Page Life Expectancy and Buffer Cache Hit Ratio are very important performance counter of SQL Server.

Keep reading
SQL Server Architecture

Page, Extent in SQL Server

Page is fundamental unit of data storage in SQL Server. Collection of eight pages is called as Extent.

Keep reading

Loading…

Something went wrong. Please refresh the page and/or try again.

Introduction

I have started this blog for users who are working as a SQL Server DBAs and users want to learn SQL Server. While performing our daily activities, we face many issues. I would like to share such issues with their solutions. I am sure, this will help many of you.

1 Comment »

Leave a Reply