Performance Counters Data collection using TypePerf utility

SQL Server performance tuning and Optimizing SQL Server is part of the day to day job of a Database administrator. One of the key aspects of Performance tuning is to gather...

SQL Server Database backups: Third party backup tools

While discussing about the roles and responsibilities of DBAs, backup and restore is counted as on the important activity of a Database Administrator as a day to day task. Though most...

SQL Server DBA Interview Questions and Answers – SQL Server Agent and Its Components

This blog contains Question answers about the most frequently used tool by a Database Administrator i.e. SQL Server Agent. I tried to cover all the questions related to each and every...

SQL Server Database mail common issue

Problem: SQL Server Database Mail common issue We always use SQL Server Database mail feature to create email notification for our mission critical jobs but what if they stop sending us status...

How to use Microsoft Virtual Labs for Practical implementation

One of the important questions often asked by my fellow mates is how we can implement practical scenarios without configuring anything on Desktop or Laptop. This is a common problem for...

SQL Server 2016 dynamic data masking – a preface

Dynamic data masking is one of best security attribute introduced in SQL Server 2016 Community Technology Preview 3. This is a security mechanism which covers the sensitive piece of information in...

How to move Indexes (Cluster and Non Cluster) from Primary File group to New...

As a DBA, many times there are requirements to segregate data in a Database into multiple file groups. There can be many reasons like below: Performance issues (Disk IO) Disk space...
SQL Server Encryption

How to use SQL Server Encryption to Secure data?

SQL Server Encryption Implementation What is Data Sensitivity? Data protection and security is one of the most important aspects of a database design nowadays. Virtually no database today can run without having...

SQL Server 2016 SP1 Release – A bold move by Microsoft

A bold move by Microsoft, Is not it? With the emergence of cloud technology, there is a huge competition in the market and everyday software Companies are coming up with lucrative deals...

How to create a virtual machine in Azure Cloud?

How to create a virtual machine in Azure Cloud I am writing this blog on creation of virtual machine in Microsoft Azure. How can we create a VM in Azure, what are...

APLICATIONS

SQL Server DBA Interview Questions and Answers – Database Mirroring –...

Continuing with my previous post of Interview Questions series on Database Mirroring, this is the second blog on Database Mirroring. 1) What is Database Snapshot? A...