Microsoft sql server 2012ºº»¯°æÊÇÒ»¿î˽ÓÐÔƵÄÊý¾Ý¿â¹ÜÀí£¬ÓÈÆäÊÇ´ÓÒµÍøÂçƽ̨µÄ¹«Ë¾Õë¶ÔÊý¾ÝÐÅÏ¢µÄ´æ·ÅºÍ¹ÜÀí·½·¨ÊÇÊ®·Ö¹Ø¼üµÄ£¬¸ù¾ÝSQL ServerÊÇ¿ÉÒÔºÏÀíµÄ¿ªÕ¹¼à¹ÜµÄ£¬ÈÈÁÒ»¶Ó­ÓÐÐëÒªµÄÓû§À´¶àÌØÈí¼þÕ¾ÔÚÏßÏÂÔØ

ʹÓ÷½·¨

1¡¢ÔÚÈÎÎñ¹ÜÀíÆ÷ÖÐË«»÷Êó±êSQL Server 2012µÄ°²Ñb¹âµú£¬Õâʱ»á¾­³£³öÏÖÒ»¸ö°²Ñb¶Ô»°¿ò£¬ÔÚ×ó±ßµÄÒ³ÃæÖеã»÷¡°°²Ñb¡±²Ëµ¥À¸£¬ÈçÏÂͼËùʾ¡£Ëæºóµã»÷ÓÒ²àµÄµÚÒ»Ïî¡°È«ÐÂÉý¼¶SQL Server µ¥¶À°²Ñb...¡±Ñ¡ÔñÏî¡£

2¡¢µã»÷¡°ÏÂÒ»²½¡±°´Å¥ÔÙ´ÎÏÂÒ»²½°²Ñb¡£ÄÍÐĵȴýÒ»»á¶ù£¬½ÏÂý¡£¼ìÑéÈ¡µÃ³É¹¦ºóµã»÷¡°ÏÂÒ»²½¡±°´Å¥

3¡¢±£´æĬÈÏÉèÖ㬵ã»÷¡°ÏÂÒ»²½¡±°´Å¥£¬¼üÈë²úÆ·Ãܳף¬µã»÷¡°ÏÂÒ»²½¡±°´Å¥¡£ÆôÓÃÊÚȨÎļþ£¬µã»÷¡°ÏÂÒ»²½¡±°´Å¥¡£

4¡¢É趨ÈËÎï½ÇÉ«µÄ¹ý³ÌÖпÉÒÔÌôѡĬÈÏ£¬µã»÷¡°ÏÂÒ»²½¡±°´Å¥¡£µã»÷¡°Ñ¡ÖС±°´Å¥£¬µã»÷¡°ÏÂÒ»²½¡±°´Å¥¡£ÌôÑ¡°¸Àý°²×°Îļþ£¨È¡Ãû°¸ÀýÌôÑ¡¡°Ä¬ÈÏÉèÖ᱾ͿÉÒÔ£©£¬µã»÷¡°ÏÂÒ»²½¡±°´Å¥¡£

5¡¢²éÑé´¢´æ¿Õ¼ä£¬µã»÷¡°ÏÂÒ»²½¡±°´Å¥¡£ÔÚ¡°Êý¾Ý¿âÒýÇæÅ䱸¡±Ò³Ã棬µã»÷¡°¼ÓÉϵ±½ñÓû§¡±°´Å¥£¬µã»÷¡°ÏÂÒ»²½¡±°´Å¥¡£

6¡¢Ôٴεã»÷¡°¼ÓÉϵ±½ñÓû§¡±°´Å¥£¬µã»÷¡°ÏÂÒ»²½¡±°´Å¥£¬Ôٴεã»÷¡°ÏÂÒ»²½¡±°´Å¥¡£È«²¿µÄ¶¼Å䱸ºÃÀ²£¬µã»÷¡°°²Ñb¡±°´Å¥Öð½¥°²ÑbSQL Server 2012¡£

7¡¢ÕýÔÚ°²×°£¬µÈºòSQL Server 2012°²Ñb½øÐоͿÉÒÔ

SQLserverÖØÒªÀúÊ·°æ±¾

1¡¢SQLserver 97

2¡¢SQLserver 2000

3¡¢SQLserver 2005

4¡¢SQLserver 2008

5¡¢SQLserver 2012

sql2012ºº»¯°æ Ôö¼Ó¹¦ÄÜ

1. AlwaysOn -ÕâÒ»¹¦Äܽ«Êý¾Ý¿â²éѯµÄ¾µÏñÎļþÌá¼°ÁËÒ»¸öеÄÏà¶Ô¸ß¶È¡£Óû§¿ÉÒÔ¶ÔÓÚÒ»×éÊý¾Ý¿â²éѯ×öÔÖ»öÐÞ¸´¶ø²»ÊÇÒ»¸öÖ±½ÓµÄÊý¾Ý¿â²éѯ¡£

2.Windows Server Core ÊÊÓÃ-Windows Server Core ÊÇÃüÁîÐнçÃæµÄ Windows£¬Ó¦Óà DOS ºÍ PowerShell À´×öÓû§»¥¶¯¡£ËüµÄÍøÂç×ÊÔ´Õ¼ÓиüÉÙ£¬¸ü°²È«ÐÔ£¬ÊÊÓà SQL Server 2012¡£

3.Columnstore Êý¾Ý¿âË÷Òý- ÕâÒ²ÊÇ SQL Server ÌØÓеŦÄÜ¡£ËûÃÇÊÇΪÊý¾Ý¿â¹ÜÀí²é¿´Éè¼Æ·½°¸µÄд±£»¤Êý¾Ý¿âË÷Òý¡£Êý¾ÝÐÅÏ¢±»»ú¹¹³É±âƽ»¯Éè¼ÆµÄËõС·½Ê½´¢´æ£¬¾Þ´óµÄ½µµÍÁË I/O ºÍÔËÐÐÄÚ´æÓ¦Óá£

4.×Ô¶¨ÍøÂç·þÎñÆ÷¹ÜÀíȨÏÞ- DBA ¿ÉÒÔ½¨Á¢Êý¾Ý¿âµÄ¹ÜÀíȨÏÞ£¬µ«²»¿ÉÒÔ½¨Á¢ÍøÂç·þÎñÆ÷µÄ¹ÜÀíȨÏÞ¡£ÀýÈ磬DBAÒªÏëÒ»¸ö¿ª·¢Éè¼Æ×éÓÐ×Åij̨ÍøÂç·þÎñÆ÷ÉÏÈ«²¿Êý¾ÝµÄ¶ÁдÄÜÁ¦¹ÜÀíȨÏÞ£¬ËûÎñ±ØÊÖ¶¯Ê½µÄ½øÐдËʵ¼Ê²Ù×÷¡£¿ÉÊÇ SQL Server 2012 ÊÊÓöÔÓÚÍøÂç·þÎñÆ÷µÄȨÏÞ¹ÜÀí¡£

5.Ìá¸ßµÄ²ÆÎñÉó¼Æ¹¦ÄÜ- È«²¿µÄ SQL Server °æ±¾ºÅ¶¼ÊÊÓòÆÎñÉó¼Æ¡£Óû§¿ÉÒÔ×Ô¶¨²ÆÎñÉó¼Æ±ê×¼£¬¼Í¼һЩ×Ô¶¨µÄʱ³¤ºÍÈÕÖ¾¡£

6.BI´ÊÒåʵÌåÄ£ÐÍ- ÕâÒ»¹¦ÄÜÊÇÓÃÓÚÈ¡´ú¡°Analysis Services Unified Dimentional Model¡±µÄ¡£ÕâÒ²ÊÇÒ»ÖÖÊÊÓà SQL Server È«²¿ BI ¸ÐÊܵĻìºÍÊý¾Ý¿âϵͳ¡£

7.Sequence Objects- Óà oracle µÄÈËÒ»Ö±ÒªÏëÕâÒ»¹¦ÄÜ¡£Ò»¸ö±àÂëÐòÁУ¨sequence£©±ãÊÇÒÀ¾Ý´¥·¢Æ÷Ô­ÀíµÄ×ÔÉýÖµ¡£SQL Serve ÓÐÒ»¸öÏà½üµÄ¹¦ÄÜ£¬identity columns£¬¿ÉÊÇÓÃÄ¿±êÍê³ÉÁË¡£

8.Ìá¸ßµÄ PowerShell ÊÊÓÃ- È«²¿µÄ Windows ºÍ SQL Server ¹ÜÀíÈËÔ±¶¼Ó¦µ±ÓÃÐĵÄѧϰÅàѵ PowderShell µÄרҵ¼¼ÄÜ¡£Î¢Èí¹«Ë¾ÒѾ­´óÁ¦¿ª·¢Éè¼Æ·þÎñ¶ËÉÌÆ·¶Ô PowerShell µÄÊÊÓá£

9.·Ö²¼Ê½ÏµÍ³»Ø¿´£¨Distributed Replay£©- ÕâÒ»¹¦ÄÜÏà½ü Oracle µÄ Real Application Testing ¹¦ÄÜ¡£²»Ò»ÑùµÄÊÇ SQL Server ÉÌÒµ°æÄÚÖÃÁËÕâÒ»¹¦ÄÜ£¬¶øÓà Oracle µÃ»°£¬Ä㻹Êǵø½¼ÓÑ¡¹ºÕâÒ»¹¦ÄÜ¡£ÕâÒ»¹¦ÄÜ¿ÉÒÔʹÄã¼Í¼¹¤×÷»·¾³µÄÔËÐÐÇé¿ö£¬ËæºóÔÚ´ËÍâÒ»¸ö×ÔÈ»»·¾³ÔÙÏÖÕâÖÖ¹¤×÷ÖÐÇé¿ö¡£

10.PowerView- ÕâÊÇÒ»¸öÇ¿¾¢µÄ¶ÀÁ¢ BI רÓù¤¾ß£¬¿ÉÒÔÈÃÓû§½¨Á¢ BI »ã±¨¡£

11.SQL Azure Ìá¸ß- ÕâºÍ SQL Server 2012 ›]ÓÐÖ±½ÓµÄ¹ØÁª£¬¿ÉÊÇ΢Èí¹«Ë¾µÄÈ·¶Ô SQL Azure ¸ÉÁËÒ»¸öÖØÒª¸ÄÉÆ£¬±ÈÈç Reporint Service£¬±¸·ÝÊý¾Ýµ½ Windows Azure ¡£Azure Êý¾Ý¿â²éѯµÄÏÞÖÆÌáÉýµ½ÁË150G¡£

12.»¥ÁªÍø´óÊý¾ÝÊÊÓÃ- ÕâÒ²ÊÇ×îÖØÒªµÄÒ»µã£¬¾¡¹Ü·Åµ½ÁË×îÖÕ¡£ PASS£¨Professional Association for SQL Server£©´ó»á£¬Î¢Èí¹«Ë¾¹«²¼ÁËÓë Hadoop µÄ·þÎñÌṩÉÌ Cloudera µÄЭ×÷¡£Ò»ÊǸøÓè Linux °æ±¾ºÅµÄ SQL Server ODBC Íƶ¯¡£¹Ø¼üµÄЭ×÷ƒÈÈÝÊÇ΢Èí¹«Ë¾¿ª·¢Éè¼Æ Hadoop µÄÉäƵÁ¬½ÓÆ÷£¬Ò²¾ÍÊÇ SQL Server Ò²²½ÈëÁË NoSQL ÐÐÒµ¡£

SQLServer2012ÖÐÎİ湦ÄÜ

¼«¿ìµÄÌØÐÔ

ÔÚÒµÄÚÊ×ÇüÒ»Ö¸µÄ±ê×¼²âÊÔ´úÂëµÄ´óÁ¦Ö§³ÖÏ £¬Óû§¿ÉµÃµ½¿ª´´ÐԵġ¢¿ÉÔ¤²â·ÖÎöµÄÌØÐÔ

ѸËÙµÄÊý¾ÝÐÅÏ¢·¢¾õ

¸ù¾ÝѸËÙµÄÊý¾ÝÐÅϢ̽ѰºÍ´óÊý¾Ý¿ÉÊÓ»¯¶Ô´ó¶ÑµÄÐÅÏ¢¿ªÕ¹Ï¸ÄåÉî²ã´ÎµÄ¿ÆѧÑо¿£¬½ø¶øÄܹ»°ïÖú¹«Ë¾Ã÷È·Ìá³ö¸ü¼ÓÉîÈëµÄÐÐÒµ¶´Ï¤

°²È«ÏµÊýºÍ¿ÉÀ©Õ¹ÐÔ

ÌáÉýÍøÂç·þÎñÆ÷Ò»ÇÐÕý³£ÔËת•r¼ä²¢¼ÓÇ¿¸öÈËÐÅÏ¢±£»¤£¬²»ÓÃÀË·Ñʱ¼ä£¬´í¹ýÁ¼ºÃµÄ»ú»áŶ£¡ºÍÇ®²Æ¾Í¿ÉÒÔÍê³ÉÍøÂç·þÎñÆ÷µ½ÔÆ¿Õ¼äµÄÍØÕ¹

¹«Ë¾°²È«ÏµÊý¼°ºÏ¹æ

ÄÚǶµÄ°²È«ÏµÊý¹¦Äܼ°IT¹ÜÀí¹¦ÄÜ£¬¿ÉÒÔÔÚ¾Þ´óˮƽÉÏЭÖú¹«Ë¾ÌáÉý°²È«ÏµÊýµÈ¼¶²¢Íê³ÉºÏ¹æ

·ÅÐÄÓ¦ÓÃ

¹é¹¦ÓÚÁ¼ºÃµÄ·þ„պͷþÎñÖ§³Ö¡¢ºÜ¶à¿ÉÐÅÀµµÄºÏ×÷·½¡¢¼°Æä³ä×ãµÄÍêÈ«Ãâ·ÑרÓù¤¾ß£¬Óû§¿ÉÒÔ°²ÐÄʹÓÃ

SQL Server 2012 ϵÁкÅ(Ãܳ×)£º

MICROSOFT SQL SERVER 2012 ¹«Ë¾¹Ø¼ü°æ×¢²áÂëϵÁкÅ: FH666-Y346V-7XFQ3-V69JM-RHW28

MICROSOFT SQL SERVER 2012 ÉÌÎñÖÇÄÜ°æ×¢²áÂëϵÁкÅ: HRV7T-DVTM4-V6XG8-P36T4-MRYT6

MICROSOFT SQL SERVER 2012 ¿ª·¢°æ×¢²áÂëϵÁкÅ: YQWTX-G8T4R-QW4XX-BVH62-GP68Y

MICROSOFT SQL SERVER 2012 ¹«Ë¾·þÎñÆ÷°æ/CAL°æϵÁкÅ: 748RB-X4T6B-MRM7V-RTVFF-CHC8H

MICROSOFT SQL SERVER 2012 ±êÅä×¢²áÂëϵÁкÅ: YFC4R-BRRWB-TVP9Y-6WJQ9-MCJQ7

MICROSOFT SQL SERVER 2012 WEB°æ×¢²áÂëϵÁкÅ: FB3W8-YRXDP-G8F8F-C46KG-Q998F

Microsoft SQL Server 2012 ѸÀ×ÏÂÔصØÖ·

°æ±¾ºÅ£ºMicrosoft SQL Server 2012 32λ/64λ

ÏÂÔØÁ´½Ó£ºed2k://|file|cn_sql_server_2012_standard_edition_x86_x64_dvd_813404.iso|5054384128|4BA89C95A1A99FE3B6D0D152947FFC7E|/