INDEX
SQL Server Interview Questions
Engine Enhancements
1: List out the major engine enhancements in SQL Server 2005 database engine
2: List three major Programmability Enhancements in SQL Server 2005 database engine.
3: List four major Manageability Enhancements in SQL Server 2005 database engine.
4: List the major Security Enhancements in SQL Server 2005 database engine.
5: SQL Server offers a fully integrated hybrid solution. Explain.
6: What are the features of SQL Server?
7: List the new availability enhancements supported in SQL Server 2012.
8: What are the features of SQL Server supported in Enterprise Edition?
9: What are the features of SQL Server supported in Business Intelligence Edition?
10: How do availability enhancements support for Windows server core?
11: What is the benefit of Recovery Advisor?
12: What are the scalability and performance enhancements available in SQL Server?
13: What are the Manageability Enhancements of SQL Server 2012?
14: What are the security enhancements of SQL Server?
15: What are the programmability enhancements of SQL Server?
16: Explain DAC enhancements.
17: Explain how SQL Server supports tight integration with SQL Azure.
18: Explain Resource Governor Enhancements.
19: Explain Columnstore Index.
20: Explain the partition support enhancements in SQL Server.
21: How can SQL Server achieve maximum scalability?
22: What are the additional features included in SQL Server Management Studio?
23: What is the use of Contained Databases?
24: What is the use of FileTable?
25: Explain Full Text search enhancement.
26: What are the editions of SQL Server 2012?
27: What is an in-place upgrade?
28: What are the benefits of side-by-side migration over an in-place upgrade?
29: What are the high level steps performed for Step-by-Step migration?
30: What are the advantages of In-Place upgrade in SQL Server?
Availability and Disaster Recovery Enhancements
31: Explain the Availability modes supported by SQL Server.
32: What do you know about the Always On Availability Groups in SQL Server?
33: Explain Failover in AlwaysOn.
34: How do you design a backup and recovery solution to the SQL Server database?
35: What is the strategy used for high availability and disaster recovery with SQL server versions prior to 2012?
36: What is the issue with Database mirroring?
37: What is the issue with Log shipping?
38: What are the new features for high availability and disaster recovery introduced in SQL Server 2012?
39: What are the high level benefits of AlwaysOn Availability Groups?
40: What are the high level benefits of AlwaysOn Failover Cluster Instances?
41: What is the benefit of synchronous and asynchronous data movement in AlwaysOn Availability Groups?
42: What steps should be followed while deploying AlwaysOn Availability Groups?
43: What are the features in AlwaysOn Availability Groups?
44: What are Active Secondaries?
45: What are the benefits of secondaries in AlwaysOn Availability Groups?
46: What are the connection modes available in secondaries?
47: What are the failover modes in Availability Groups?
48: What is the availability group listener?
49: How will you configure availability group listener?
50: What are the deployment configuration steps for HA and DR requirements?
51: What are the deployment alternatives for Disaster Recovery?
52: How are availability groups monitored in SQL Server 2012?
53: What is monitored with the availability groupsā dashboard?
54: What are the features of AlwaysOn Failover Cluster Instances?
55: Name all operating systems that sup...