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...

How to create Drop and Recreate Script of all Indexes in a database?

It’s a general requirement in the DBA job to scripts out the database objects and deployment the scripts in the new environment. Microsoft SQL Server provides us an option to script...

SQL Server DBA Interview Questions and Answers – SQL Server Cluster 2

If you have enjoyed reading my First post about Questions about Cluster. Here is another post on SQL Server Cluster services and on its components and features. 1. What new functionality does...

SQL Server DBA Interview Questions and Answers – SQL Server Cluster 1

Today I am writing a Blog Series on one of my Favorite topic – SQL Server Cluster.  This will include all the possible Questionnaire which are asked in the Interviews related to...

SQL DBA Interview Questions and Answers – Security Permissions

1) What is Authentication and Authorization? What is the difference between both? Authentication is the process of verifying who you are. Logging on to a PC with a username and password is...

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

In this blog I am discussing the SQL Server Interview Questions answers on Database Mirroring. This is very interesting topic and consists of very wide range of terminologies and scope. I will...

Windows Powershell

Introduction to PowerShell Windows PowerShell is a Windows commandline shell scriptining mechanism particularly designed for System Admins. Windows PowerShell providex an inteactive command prompt and a scripting tool that can be utilized...

SQL Server DBA Interview Questions and Answers – Log Shipping

This blog is about one of the High Availability feature supported by Microsoft SQL Server- Log Shipping. What is High Availability in SQL Server? A high availability solution masks the effects of...

SQL Server DBA Interview Questions and Answers – Database Backups and Restore-2

Continuing my Blog series on the SQL Server DBA Interview Questions on Database Backup Restores, I am posting another set of 31 questions which will help you to understand the SQL...

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...

APLICATIONS

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

Continuing my Blog series on the SQL Server DBA Interview Questions on Database Backup Restores, I am posting another set of 31 questions which...
Skip to toolbar