Microsoft SQL Server 2012ÊÇÏֽ׶Î΢Èí¹«Ë¾¸øÖÚ¶àµÄÐÂÀÏÓû§Ó¦ÓõĹØÁªÐÍÊý¾Ý¿â¡£ËüµÄ·¢Éú±ãÊDz»½ö¸ø´ó»ï¶ù´øÀ´ÁËȫеÄÔƼÆËã¼¼Êõ·þÎñƽ̨¡£Äܹ»ÈôóÁ¿µÄ¹«Ë¾¶Ô»ú¹¹¿ªÕ¹±È½ÏÉî²ã´ÎµÄÕÆÎÕ£¬½Ï´ó³Ì¶ÈÉϵÄÍê³É˽ÓÐÔÆ´æ´¢ÓëÔƼÆËãƽ̨ÖмäÐÅÏ¢µÄÍØÕ¹ÓëʹÓõÄתÒÆ¡£
Microsoft SQL Server 2012¹Ø¼ü·þÎñÏîÄ¿
1.¸ù¾Ý AlwaysOn ¸øÓèËùÐèÔË×÷•r¼äºÍ¸öÈËÐÅÏ¢±£»¤£»
2.¸ù¾ÝÁд¢´æÊý¾Ý¿âË÷ÒýµÃµ½¿ª´´ÐԺͿÉÔ¤¹ÀµÄÌØÐÔ£»
3.¸ù¾ÝÓÃÒÔ×éµÄÐÂÓû§½ç¶¨ÈËÎï½ÇÉ«ºÍĬÈÏÉèÖù¹¼Ü£¬ÐÖúÍê³É°²È«ÏµÊýºÍ×ñÑÐÔ£»
4.¸ù¾ÝÁд¢´æÊý¾Ý¿âË÷ÒýÍê³ÉѸËÙÊý¾ÝÐÞ¸´£¬±ãÓÚ¸ü½øÒ»²½µØÀí½â»ú¹¹£»
5.¸ù¾ÝSSIS¸ÄÉÆ.ÓÃÒÔExcelµÄ Master Data ServicesÍâ½Ó³ÌÐòÁ÷³ÌºÍÐÂData Quality Services£¬±£Ö¤¸üΪ¿¿Æ×.Ò»ÖµÄÊý¾ÝÐÅÏ¢£»
6.¸ù¾ÝÓ¦Óà SQL Azure ºÍ SQL Server Êý¾ÝÐÅϢרÓù¤¾ßµÄÊý¾ÝÐÅÏ¢²ãÓ¦ÓÃÈí¼þ²¿¼þ (DAC) ÆæżУÑ飬ÌáÉýÍøÂç·þÎñÆ÷ºÍÇåÏþµÄITºÍ¿ª·¢Õß¹¤×÷ЧÄÜ£¬½ø¶øÔÚÊý¾Ý¿â.BIºÍÔƹ¦ÄܼäÍê³ÉͳһµÄÑз¢¸ÐÊÜ¡£
sql 2012רҵ°æÔõôʹÓÃ
1.ÔË×÷³ÌÐò°²×°£¬µã»÷°²Ñb£¬ÌôÑ¡µÚÒ»Ï
2.³ÌÐò°²×°ÊÊÓñê×¼£¬Êµ¼Ê²Ù×÷½øÐУ¬µã»÷Ã÷È·£»
3.¼üÈëÃܳףºYFC4R-BRRWB-TVP9Y-6WJQ9-MCJQ7
4.µã»÷½ÓÄÉÊÚȨÎļþ£»
5.ÕâÒ»²½Á¢¼´µã»÷ÏÂÒ»²½¾Í¿ÉÒÔ£¬²»Ó°Ï쵽ʺó°²ÑbºÍÓ¦Óᣲ»ÕýÈ·Ôµ¹Ê¿ÉÄÜÊǹصôÁËwindowsµÄ×Ô¶¯Éý¼¶¡£
6.³ÌÐò°²×°ÊÊÓñê×¼£¬µã»÷ÏÂÒ»²½£»
7.ÆôÓÃSQL Server¹¦ÄÜ°²Ñb£»
8.µã»÷¶¼Ñ¡£¬µã»÷ÏÂÒ»²½£»
9.°²Ñb±ê×¼¼ìÑ飬ʵ¼Ê²Ù×÷½øÐУ¬µã»÷ÏÂÒ»²½£»
10.ÌôѡĬÈÏÉèÖð¸Àý£¬µã»÷ÏÂÒ»²½£»
11.¼ìÑéÓ²ÅÌ×´¿ö£¬µã»÷ÏÂÒ»²½£»
12.·þÎñÆ÷µÄÅäÖã¬Ä¬ÈÏÉèÖþͿÉÒÔ£¬µã»÷ÏÂÒ»²½£»
13.ÌôÑ¡windowsÉí·ÝÈÏÖ¤·½Ê½£¬µã»÷¼ÓÉϵ±½ñ¿Í»§£»
14.µã»÷¼ÓÉϵ±½ñ¿Í»§£»
15.ά³ÖĬÈÏÉèÖÃÅ䱸£¬µã»÷ÏÂÒ»²½£»
16.µã»÷¼ÓÉϵ±½ñ¿Í»§£¬µã»÷ÏÂÒ»²½£»
17.É趨¿ØÖÆ°åÃû×Ö£»
18.µã»÷ÏÂÒ»²½£»
19.°²ÑbÅ䱸±ê×¼¼ìÑ飬ʵ¼Ê²Ù×÷½øÐУ¬µã»÷ÏÂÒ»²½£»
20.µã»÷°²Ñb£»
21.°²Ñb½øÐУ¬ÌáÐѱØÐëÖØÐÂÆô¶¯µç×Ó¼ÆËã»ú£¡²»ÖØÐÂÆô¶¯·Â·ðҲûʲôÎÊÌ⣡
22.¿ªÆôSQL Server Management Studio£¬ÏÖÔÚ¿ÉÒÔÁª½ÓÊý¾Ý¿âÁË£¡
1. AlwaysOn Availability Groups
´ËÏîй¦Äܽ«Êý¾Ý¿â¾µÏñϵͳ³£¼û¹ÊÕÏǨÒÆÌá¸ßµ½È«ÐÂÉý¼¶µÄÏà¶Ô¸ß¶È£¬ÔËÓÃAlwaysOn£¬¿Í»§Äܹ»½«ºÃ¼¸¸ö×鿪չ³£¼û¹ÊÕÏǨÒÆ£¬¶ø²»ÊǹýÈ¥µÄ½ö½ö¶ÔÓÚ¶ÀÁ¢µÄÊý¾Ý¿â¡£³ý´ËÖ®Í⣬Íű¾ÊÇ¿ÉдµÄ£¬²¢¿ÉÓÃÒÔÊý¾Ý¿â±¸·ÝÊý¾Ý¡£¸ü¸ßµÄ¾ºÕùÓÅÊÆÊÇSQL Server 2012¼òµ¥»¯HAºÍDRµÄÒªÇó¡£
2. Windows Server Core Support
ÔÚWindows ServerÉÌÆ·ÖÐÄãÄÜÏòUbuntu ServerÒ»ÑùÖ»°²Ñb¹Ø¼ü£¨´ú±í×ÅÄãµÄϵͳÈí¼þ²»¾ßÓÐGUI£©¡£ÄÇô×öËù²úÉúµÄ¾ºÕùÓÅÊÆÊǽµµÍÓ²¼þÅäÖõÄÌØÐÔ»¨Ïú£¨×îÉÙ50%µÄÔËÐÐÄÚ´æºÍµçÄÔÓ²ÅÌÀûÓÃÂÊ£©¡£Óë´Ëͬʱ°²È«ÏµÊýÒ²»ñµÃÌá¸ß£¨±È°²ÑbͼÐÍ°æ¸üÉÙµÄϵͳ©¶´£©¡£´ÓSQL Server 2012Öð½¥½«¶ÔÖ»°²Ñb¹Ø¼üµÄWindows ServerϵͳÈí¼þ¸øÓèÊÊÓá£
3. Columnstore Indexes
ÕâÊÇÒ»¸ö·Ç³£¿áµÄ¹¦ÄÜ£¬ÊÇSQL ServerÒÔÇ°°æ±¾Ò²²»¾ßÓеġ£¶ÀÌØÖÖÀàµÄд±£»¤Êý¾Ý¿âË÷ÒýרΪÊý¾Ý¿â¹ÜÀí²é¿´Éè¼Æ·½°¸¡£Êý¾ÝÐÅÏ¢¿ªÕ¹ÅÅÐò²¢´æ·ÅÔÚ±âƽµÄËõСµÄÁÐÊý¾Ý¿âË÷Òý¡£ÔÚ¹æÄ£ÐԵIJ鿴״¿öÏ¿ɾ޴óµÄ½µµÍI/OºÍÔËÐÐÄÚ´æʹÓÃÂÊ¡£
4. User-Defined Server Roles
DBAÔçÒѾßÓÐÁ˽¨Á¢×Ô¶¨Êý¾Ý¿âÈËÎï½ÇÉ«µÄ¹¤×÷ÄÜÁ¦£¬µ«ÔÚÍøÂç·þÎñÆ÷ÖÐÈ´²»¿ÉÒÔ¡£±ÈÈçDBAÏëÔÚ¹²Ïí×ÊÔ´ÍøÂç·þÎñÆ÷ÉÏΪ¿ª·¢Éè¼Æ¾«Ó¢ÍŶӽ¨Á¢Ã¿Ò»¸öÊý¾Ý¿âµÄ¶ÁдÄÜÁ¦¹ÜÀíȨÏÞä¯ÀÀ£¬´«Í³Ê½µÄ·½Ê½ÊÖ¶¯Ê½Å䱸»òÓ¦ÓÛ]ÓÐͨ¹ýÑéÖ¤µÄ³ÌÐòÁ÷³Ì¡£ÏÔ¶øÒ×¼ûÕâ²»ÊÇÓÅÁ¼µÄ½â¾ö·½·¨¡£¶øÔÚSQL Server 2012ÖУ¬DBAÄܹ»½¨Á¢ÔÚÍøÂç·þÎñÆ÷ÉϾßÓÐÈ«²¿Êý¾Ý¿â¶ÁдÄÜÁ¦¹ÜÀíȨÏÞ¼°ÆäÒ»ÇÐ×Ô¶¨·¶³ëÈËÎï½ÇÉ«µÄ¹¤×÷ÄÜÁ¦¡£
5. Enhanced Auditing Features
ÏÖÈç½ñÈ«²¿µÄSQL Server°æ±¾¶¼¾ßÓвÆÎñÉó¼Æ¹¦ÄÜ£¬¿Í»§»¹Äܹ»×Ô¶¨²ÆÎñÉó¼Æ¶Ô²ß£¬¼°ÆäÏò²ÆÎñÉó¼ÆÈÕÖ¾ÖÐÔØÈë×Ô¶¨ÊÂÇé¡£¶øÔÚSQL Server 2012ÖиøÓè¹ýÂǹ¦ÄÜ£¬Óë´Ëͬʱ´ó·ù¶ÈÌá¸ßе÷ÄÜÁ¦¡£
6£®BI Semantic Model
BI Semantic ModelÌæ´úÁËASUDM£¨Analysis Services Unified Dimensional Model £©¡£BI Semantic ModelÕâÀà»ìºÍµÄ·½Ê½ÈÝÐíÊý¾Ý¿âϵͳÊÊÓÃÈ«²¿SQL Server BIʵ¼ù»î¶¯£¬³ý´ËÖ®Í⻹¿ÉÈÝÐíһЩ¸É¾»Õû½àµÄÎÄ×ÖÐÅϢͼ±íÊý¾Ýͼ±í¡£
7. Sequence Objects
Õë¶ÔÓ¦ÓÃOracleµÄÈË˵£¬ÕâÒ²ÊÇËýÃdz¤ÆÚÐÔÆÚ´ýÓÐ×ŵŦÄÜ¡£±àÂëÐòÁÐÖ»ÊÇÊǵç×Ó¼ÆÊýÆ÷µÄÄ¿±ê£¬Ò»¸öºÃµÄ¼Æ»®·½°¸ÊÇÔÚ¸ù¾Ý´¥·¢Æ÷ÔÀí±íÓ¦ÓÃÔö¼ÓÁ¿Öµ¡£SQLÒ»Ö±¾ß±¸Ïà½ü¹¦ÄÜ£¬µ«Èç½ñÏÔ¶øÒ×¼ûÓë¹ýÈ¥²»Ò»Ñù¡£
8. Enhanced PowerShell Support
WindowsºÍSQL Server¹ÜÀíÈËÔ±Èç½ñ¾ÍÐèÒªÖð½¥ÌáÉýËýÃÇPowerShellµÄ½Å±¾ÖÆ×÷רҵ¼¼ÄÜÁË¡£MicrosoftΪÁ˸üºÃµØ´Ù½øÆäÍøÂç·þÎñÆ÷ÉÌÆ·ÉÏPowerShellµÄ½ø²½½øÐÐÁ˷dz£´óµÄÇÚ·Ü¡£ÔÚSQL Server 2008ÖÐDBA¼°ÆäÓÐÒ»¶¨µÄ¸ÐÊÜ£¬ÔÚSQL Server 2012ÖÐÌáÉýÁË´óÁ¿µÄcmdlet¡£
9. Distributed Replay
OracleÔçÒÑÓÐ×ÅÏà½üµÄ¹¦ÄÜ£¨Real Application Testing£©£¬µ«Ö±½ÓÑ¡¹º»áÊ®·Ö¼Û¸ñ°º¹ó£¬¶øSQL Server 2012Ôò°üº¬ÁËDistributed Replay¡£
Distributed replay¹¦ÄÜ¿ÉÈùÜÀíÈËÔ±¼Í¼ÍøÂç·þÎñÆ÷ÉϵŤ×÷ÖиººÉ£¬²¢ÔÚ±ðµÄµÄÍøÂç·þÎñÆ÷ÉÏÔÙÏÖ¡£ÕâÀàÔÚʯ½á¹¹ÉϵÄת±äÊÊÓðü¼°ÆäÔÚÉú²úÖÆÔì½Ó¿Ú²âÊÔ϶ÔÓ²¼þÅäÖñä¸ü¡£
10. PowerView
Äã¿ÉÄÜÔøÌýÎŹýÕâÒ»Ãû½ÐCrescentµÄÐÂÏîÄ¿£¬ÕâÒ²ÊǷdz£×¨ÒµµÄ×Ô·þÎñÏîÄ¿BI¹¤¾ßÏ䣬ÈÝÐí¿Í»§½¨Á¢¹«Ë¾¼¶µÄBI»ã±¨¡£
11. SQL Azure Enhancements
¾¡¹ÜÕâÓëMicrosoftÊͷųöÀ´µÄSQL Server 2012²¢ÎÞÁ¢¼´ÁªÂ磬µ«MicrosoftÒѾSQL Azure×öÖØÒªµÄ¸ÄÉÆ¡£AzureÒѾ¾ßÓÐReporting Services¼°Æ䱸·ÝÊý¾ÝAzureÊý¾Ý´¢´æµÄ¹¤×÷ÄÜÁ¦£¬ÕâÒ²ÊǸöºÜ´óµÄ·¢Õ¹¡£AzureÈç½ñÈÝÐí½Ï´ó150GBµÄÊý¾Ý¿â¡£Óë´ËͬʱAzureÊý¾Ý¿âͬ²½¿É¸üÇ¿ÈÚÈë»ìºÍʵÌåÄ£ÐͺÍÔƼ䲼ÊðµÄ½â¾ö·½·¨¡£
12. Big Data Support
ÔÚ2019µÄPASS (Professional Association for SQL Server)¸ß·å»áÉÏ£¬Microsoft¹«²¼ÓëHadoop¾ÏúÉÌHortonworksÐ×÷£¬²¢×¼±¸¹«²¼Linux°æ±¾µÄMicrosoft SQL Server ODBCÇý¶¯Èí¼þ¡£
sql server 2012ϵͳҪÇó
ÊÊÓõĵçÄÔ²Ù×÷ϵͳ£ºWindows 7.Windows Server 2008 R2.Windows Server 2008 SP2.Windows Vista SP2 32λϵͳÈí¼þ£º¾ß±¸Intel 1GHz£¨»òͬÑùÌØÐԵļæÈÝCPU£©»òËÙÂÊѸËÙµÄCPU£¨ÌáÒéÓ¦ÓÃ2GHz»òËÙÂÊѸËÙµÄCPU£©µÄµç×Ó¼ÆËã»ú
64λϵͳÈí¼þ£º1.4 GHz»òËÙÂÊѸËÙµÄCPU
×îÉÙ1GB RAM£¨ÌáÒéÓ¦ÓÃ2GB»ò¸ü¸ßµÄRAM£©
2.2 GB¿ÉÒÔÓôÅÅÌ¿Õ¼ä
µã»÷ÓÎÏ·£¬¹ËÃû˼Ò壬ÔÊÐíÍæ¼Òµã»÷Êó±êµÄÐÎʽÀ´Íê³ÉÓÎÏ·£¬ÕâÊǸüÖøÃûµÄµã»÷Ó¢ÐÛ¡£µã»÷ÓÎÏ·¿ÉÒÔʹÍæ¼ÒÖ»ÐèʹÓÃÊó±ê¾Í¿ÉÒÔÇáËɵØÍæÓÎÏ·¡£ÓÎÏ·ÀàÐÍ»ù±¾ÉÏÊÇ»ùÓÚ½âÃÕ¡¢ÅàÑøµÈ¡£ÕâÊÇÒ»¸öµã»÷ÓÎÏ·ÁбíºÍÏàÓ¦µÄµã»÷ÓÎÏ·ÏÂÔØ¡£¶àÌØÈí¼þרÌâΪÄúÌṩµã»÷ÀàÓÎÏ·,°²×¿µã»÷ÀàÓÎÏ·,¿ÉÒÔתÉúµÄµã»÷ÀàÓÎÏ·¡£¶àÌØÈí¼þÕ¾Ö»ÌṩÂÌÉ«¡¢ÎÞ¶¾¡¢ÎÞ²å¼þ¡¢ÎÞľÂíµÄ´¿ÂÌÉ«Èí¼þÏÂÔØ¡£
¶àÌØÈí¼þרÌâΪÄúÌṩµã»÷Èí¼þ,ÆÁÄ»µã»÷Èí¼þ,ÊÖ»úÆÁÄ»×Ô¶¯µã»÷Èí¼þ£¬°²×¿Æ»¹û°æÈí¼þappÒ»Ó¦¾ãÈ«¡£
¶àÌØÈí¼þרÌâΪÄúÌṩseoµã»÷¹¤¾ß,seo¹¤¾ß,seoÍâÁ´¹¤¾ß;°²×¿Æ»¹û°æÈí¼þappÒ»Ó¦¾ãÈ«¡£¶àÌØÈí¼þÕ¾Ö»ÌṩÂÌÉ«¡¢ÎÞ¶¾¡¢ÎÞ²å¼þ¡¢ÎÞľÂíµÄ´¿ÂÌÉ«¹¤¾ßÏÂÔØ
×Ô¶¯µã»÷Æ÷¿ÉÔÚûÓÐROOTȨÏÞµÄÇé¿öÏÂ×Ô¶¯µã»÷ÆÁÄ»¡£Äú¿ÉÒÔÇáËÉÌí¼Óµã»÷λÖò¢ÉèÖõã»÷Ëٶȣ¬Óë°´¼üÏòµ¼¹¦ÄÜÏàËÆ¡£ÆäÖеÄËùÓй¦Äܶ¼ºÜÖØÒª£¬²¢ÓÐÏêϸµÄ²Ù×÷˵Ã÷£¬Ê¹ÓÃÇ°ÔĶÁÆðÀ´¸ü·½±ã¡£ÃâROOTÐí¿É£¬Ê¹ÓÃÆðÀ´¸ü¼Ó·½±ã£¬»á°ïÄú×Ô¶¯×¥×¡ºìÉ«Ðŷ⣬»ñÈ¡¶©µ¥£¬»ñÈ¡»ð³µÆ±²¢×Ô¶¯µÇ¼·Ç³£¼òµ¥ÊµÓã¬Í¬Ê±Ö§³Ö×Ô¶¯×¥µãºÍÑÕÉ«¡£
°²×¿´úÀí·þÎñÆ÷Èí¼þ£¬°²×¿´úÀí·þÎñÆ÷Èí¼þ¼òµ¥¹¦ÄÜÇ¿´óµÄÔƶ˷þÎñÆ÷´úÀíÈí¼þ£¬Èí¼þÄܹ»ÔÚwindowsϵͳÈí¼þÈí¼þÉÏÔËÐУ¬¸ÃÈí¼þ²»µ«ÈÝÁ¿Ê®·ÖµÄ¾«Ð¡£¬¶øÇÒÆä²Ù×÷²½ÖèҲʮ·ÖµÄ¼òµ¥£¬ÊÊÓÃÓû§ÎªÎÞÏß¾ÖÓòÍøÖÐÆäËûµçÄÔÌṩ´úÀíÍâÍøµØÖ··þÎñ£¬¸ÃÈí¼þÄܹ»ºÍWFilterÈí¼þ½áºÏÔËÓ㬶ÔÓû§µÄÉÏÍøÐÐΪ¹ÜÀí¹ÜÀí·½·¨½øÐÐÈ«³ÌµÄ¼à¿Ø¹ÜÀí·½°¸£¬¿ÉÒÔÊÊÓÃÓû§½øÐÐHTTP´úÀí¡¢SOCK5¡¢SMTP´úÀíÒÔ¼°POP3´úÀíµÈ£¬Èí¼þ·¶Î§¹ã£¬ÌØÐÔÇ¿¾¢¶øÓÖÎȶ¨ÊÇÆäµÃµ½ÆÕ±éÓ¦ÓõÄÖØÒªÔÒò