Jaa


SQL Server 2014的认证(MPR测试)中常见技术问题及指导(Guidance)

 

??ISV????SQL Server 2014???,????????,???????,?????,??????

??,??????????????,???????blog,???????:

??????(Microsoft Platform Ready Test Tool for SQL Server 2014),??SQL Server 2014 ??

?????????????????????????,????????????SQL Server 2014 Enterprise????,???2012(???????)????????,???????????

???(Gold)??????SQL Server 2014 AlwaysOn Failover Cluster,???????????

????:High Availability Solutions (SQL Server)

???,?????Azure????????????,???????????????Domain?????????,???????????????,?????

??SQL Server AlwaysOn?????,???????????blog,????,???????:

????,??????SQL Server Azure VM?AlwaysOn???(HA)???????(Status diagnostics)

????(Gold)??,???(Silver)??,???????????????????:

1??????compatibility level of ALL databases to 120,??? ?? ??2014?,??????,?????:

              ALTER DATABASE database_name

SET COMPATIBILITY_LEVEL = 120

???:https://technet.microsoft.com/en-us/library/bb510680(v=sql.110).aspx

2????system_health session in Extended Events ??????,???????SQL??:

              SELECT CAST(xet.target_data as xml) FROM sys.dm_xe_session_targets xet

JOIN sys.dm_xe_sessions xe

ON (xe.address = xet.event_session_address)

WHERE xe.name = 'system_health'

???:https://msdn.microsoft.com/en-us/library/ff877955.aspx

3????Microsoft SQL Server 2014 ??????? TLS 1.1 ????(??????)

?????:https://blogs.msdn.com/b/kaushal/archive/2011/10/02/10218922.aspx

4?SA?????(??????sysadmin??),????

ALTER LOGIN sa DISABLE

Or

ALTER LOGIN sa WITH NAME = name_you_define

5??????.Net Framework 4.5?ODBC 11??JDBC 4.1

6??SQL Server 2014???XP_cmdshell

?????:https://msdn.microsoft.com/en-us/library/ms175046.aspx

 

???(Gold)??????“5?2”,??????????????,???????

??:

1?In-Memory OLTP?SQL Server 2014 ???? In-memory OLTP ???????????????,?????????? 30 ??

?????,???:Performance Improvement of In-Memory OLTP

2?Partitioning,????????,????????????

?????,???:Create Partitioned Tables and Indexes

3?Clustered ColumnStore Index?SQL Server 2014 ??Columnstore ?Index?,???????????????? 100 ??

?????,???:Columnstore Indexes

4?Resource Governor,????IO???,????????????

?????,???:Resource Governor

5?Encrypted Backups,????????????

?????,???:Backup Encryption