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 DBA Interview Questions and Answers-Database Architecture and Database Properties

This article comprises of SQL Server Questions and answers series on Database Architecture and various Database Properties. Intentionally I skipped Database Recovery Models, Backups, Restore, Data File and Transaction Log Architecture...

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

SQL Server DBA Interview Questions and Answers – SQL Server DBA Tools and Executables

Every DBA uses multiple tools to perform the day to day Database Administration tasks to make hisher life easy. In this blog I am writing all about the SQL Server related...
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 DBA Interview Questions and Answers – SQL Server Services

This blog is all about the SQL Server Services which are required for the functionality of SQL Server components. It also contains Questions answers about the important parameters and SQL Server...

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 – 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 DBA Interview Questions and Answers-SQL Server Architecture

I am writing this blog based upon the Experience and knowledge which I gained after reading lot of Articles, Blogs, and Microsoft Documentation on SQL Server Architecture. Though it takes lot...

All about SQL Server Error logs

SQL Server error logs are one of the important stuff to check whenever DBA face issues in the SQL Server instance. It contains lot of information about the Issues, Errors, Backup...

APLICATIONS

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