Database Online training offers – Udemy $14.99 sale

In today's unpredictable IT world, learning is not only a straightforward thing to do — it is key to the survival in the competition. Particularly in the recession time, it is...

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

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 – Always ON – 2

I hope you enjoyed my last post on Always On. Here goes the final post on Always On feature. What is availability group wizard? Availability Group Wizard is a GUI using SQL...

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 DBA Interview Questions and Answers – Database Backups and Restore-4

Here I am posting fourth and last series of Backup/Restore interview questions. I am trying to cover most of the known errors and some concepts too. You may take a look...

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

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 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 – 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...
Skip to toolbar