Top 10 SQL Server Backup and Restore Interview Questions

Posted on December 12, 2016 by uday arumilli

Top 10 SQL Server Backup and Restore Interview Questions

SQL THE ONE

Top 10 SQL Server Backup and Restore Interview Questions

There are total 57 questions are answered under SQL Server Backup and Restore category in the book “SQL THE ONE”. In this chapter we can see questions and answers on Backup and Restore and scenarios. Below are the Top 10 SQL Server Backup and Restore Interview Questions:

1. What are some common reasons why database restores fail?

2. How to rebuild the system databases?

3. What are the new features added for Backup and Restore on SQL Server 2014 / 2016?

4. Is there any performance impact if we enable the backup encryption?

5. Why don’t we just backup SQL Server Database Files (MDF, LDF and NDF) using Windows backup tool instead of SQL Server native backup?

Continue reading →

Posted in High Availability, Interview Q&A, SQL Server DBA | Tagged , , , , , , , , , , , | 1 Comment

Top 20 SQL Server Security Interview Questions

Posted on December 12, 2016 by uday arumilli

Top 20 SQL Server Security Interview Questions

SQL THE ONE

Top 20 SQL Server Security Interview Questions

There are total 79 questions are answered under SQL Server Security category in the book “SQL THE ONE”. In this chapter we can see questions and answers on Password Policy, Server / Database / Application roles, Contained Database, New Security Features, SQL Injection, Audit, Impersonation, Proxy Accounts, TDE, and Password Policy Management. Below are the Top 20 SQL Server Security Interview Questions:

1. If password policy is enforced; can you tell me the new password rules and policies to make sure the password is strong?

2. Have you ever implemented Application Roles in your environment?

3. What are the advantages and disadvantages of a contained database feature?

4. What is the new security features added in SQL Server 2012 / 2014 /2016?

5. What are the most common symbols/operators used for SQL Injection?

Continue reading →

Posted in Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , , , | Leave a comment

Top 20 SQL Server Installations and Upgrades Interview Questions

Posted on December 12, 2016 by uday arumilli

Top 20 SQL Server Installations and Upgrades Interview Questions

SQL THE ONE

Top 20 SQL Server Installations and Upgrades Interview Questions

There are total 102 questions are answered under SQL Server Installation and Upgrade category in the book “SQL THE ONE”. In this chapter we’ll find questions and answers on SQL Server Licensing, Service Accounts, Network Protocols, Installations, Upgrades, Troubleshooting Scenarios, SQL Server components and capacity specifications. Below are the Top 20 SQL Server Installation and Upgrades Interview Questions:

1. Starting from SQL Server 7 to 2016, from which edition the licensing model has been changed?

2. Your customer sent you a request to suggest a service account for production SQL Server installation. How do you suggest the correct service account for SQL Server?

3. What are the different releases of SQL Server? We usually talk about RTM, RC, SP, CU etc. right, what are the different releases of a SQL Server product and what do you know about them?

4. How to get the port number where the SQL Server instance is listening?

5. What are the log files generated while Installing\Upgrading\Applying (packages) SQL Server on Windows machine?

Continue reading →

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , | 2 Comments