SQL Server
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...
All about Databases
SQL Server
Interview Questions
SQL Server DBA Interview Questions and Answers-Data File and Transaction...
This Blog illustrates about the most frequent questions which are asked about the Data file and Transaction Log file architecture....
Scripts
SQL Server
How to move Indexes (Cluster and Non Cluster) from Primary...
As a DBA, many times there are requirements to segregate data in a Database into multiple file groups. There can...
Scripts
SQL Server
How to create Drop and Recreate Script of all Indexes...
It’s a general requirement in the DBA job to scripts out the database objects and deployment the scripts in the...
SQL Server
Interview Question
Interview Questions
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...
SQL Server
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...
SQL Server
Interview Question
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,...
SQL Server
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...
Permission & Security
SQL Server
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...
SQL Server
Installations & Configuration
Interview Question
SQL Server DBA Interview Questions and Answers-Installation
I have been thinking since long time to pen down a comprehensive series on most commonly asked DBA Interview questions....