Top 20 SQL Server Security Interview Questions

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

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 , , , , , , , , , , | 1 Comment

Top 10 SQL Server Architecture Interview Questions

Top 10 SQL Server Architecture Interview Questions

SQL THE ONE

Top 10 SQL Server Architecture Interview Questions

There are total 46 questions are answered under SQL Server Architecture category in the book “SQL THE ONE”. In this chapter we’ll find interview questions and answers on SQL Server Low & High level architecture, Transaction Log, Query Processing and memory architecture. Apart from we can also find the newly added features in SQL Server 2008, 2008 R2, 2012, 2014 and 2016. Below are the Top 10 SQL Server Architecture Interview Questions:

1. How SQL Server Relational Engine works in processing SQL queries?

2. When I say compile and execute a SQL Batch does it means compiler compiles each line of code?

3. What is Instant File Initialization and how it works?

4. Have you ever implemented Instant file Initialization in any environment? If yes did you observe any performance gain?

5. There is a big change happened in SQL Server Log architecture on SQL Server 2014. Do you have any idea on that?

Continue reading

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