Wednesday, February 20, 2019

SQL Server DBA Interview Questions and Answers – SQL Server System Databases and Recovery...

System databases are very important part of the Database Management system. It plays a vital role in Database Administration as SQL Server functionality is based on the system database. This blog...

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

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

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

Lets have some more questions on Backup and Restore. You may visit my other backup and restore related blogs here Database Backup and Restore - 1 and Database Backup...

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

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

APLICATIONS

What are the Cloud computing career options available in the market

While the ascent of Cloud computing startles some in IT sector, However this innovation is a chance for many Professionals to pick up the...