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,???????????
???,?????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'
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 ??
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