æŽå²çã«ãWindows 8 EnterpriseãæèŒããã©ãããããã§ã¯ãVS2013ãã¬ãã¥ãŒããããŸããã ç¬ç«ããçç±ãããTFS 2013ãšSQL 2014ãã€ã³ã¹ããŒã«ããå¿ èŠããããŸãããTFSSQL Serverã¯äœããã®åœ¢ã§å¿ èŠãªã®ã§ããšã³ãã£ãã£ã®æ°ãå¢ãããªãããã«ããã®ç®çã§éäžã§14çªç®ã䜿çšãããšããã¢ã€ãã¢ãçãŸããŸããã åé¡ã¯ãVisual Studioãã2012幎ã13æ¥ããã®ä»ã«é¢ä¿ãªãã倧éã®SQL Serverã³ã³ããŒãã³ããæèŒããŠããããšã§ãã

å³1
ããšãã°ãT-SQL Language Serviceã¯ãSQL Server Data Toolsã®IntelliSenseãããŒã¿ããŒã¹ãããžã§ã¯ãã®çå€ãšå±éã®ããã®ããŒã¿å±€ã¢ããªã±ãŒã·ã§ã³ãã¬ãŒã ã¯ãŒã¯ã§äœ¿çšãããŸããSystemCLR Typesã¯ãäž»ã«SQL Serverãšã¯ç¡é¢ä¿ã«ã¢ããªã±ãŒã·ã§ã³ã§äœ¿çšã§ããå°ç空éæ¡åŒµã§ãããªã© ãããã£ãŠã2014 STR1ãããã«é 眮ããããšã¯èããããŸãããããã¯ãSQL Serverã®ä»¥åã®ããŒãžã§ã³ã«é¢é£ãããã¹ãŠã«everythingç¶ãšåå¿ããŸãã

å³2
ããã«ãã€ã³ã¹ããŒã«ãããŠãããã¹ãŠã®Visual Studio SQL Serverã³ã³ããŒãã³ãïŒå³1ïŒãçªç¶ç Žæ£ããããšã決å®ããå Žåã2014 CTP1ãã€ã³ã¹ããŒã«äžã«ãããã«ããããããé ä¿¡ãããšæåŸ ããŠã倱æããããšãã§ããŸã-å³2ã®çºçã«ã¯åœ±é¿ããŸããã ã©ããããVSã®ååšãã®ãã®ãéçã®èµ€ãåžã®ããã«åœŒã«äœçšããŠããããã§ãã
äœãã§ããŸãã-ä»®æ³ãã·ã³ãäžããŠãWindows 8.1 PreviewããŸã ç¡æã®ç¶æ ã§ã€ã³ã¹ããŒã«ããããã«ã¯ãªãŒã³ãªã·ã¹ãã -2014 CTP1ã«ã€ã³ã¹ããŒã«ããå¿ èŠããããŸããã äºçŽãå¿ èŠã§ãã 圌ã¯.NET Framework 3.5ãå¿ èŠãšããŠãããããã¯ãªãŒã³ãªã·ã¹ãã ã«ã¯ã¢ã¯ã»ã¹ããŸããã

å³3
ãŸãããŸãã¯èµ·ããŸãããæ²ãã£ãŠããŸãã ããšãã°ã次ã®ãããªã³ã³ããŒãã³ããã€ã³ã¹ããŒã«ããããã«æ³šæããŸããã

å³4
圌ãã¯.NET Frameworkãå¿ èŠãšããã®ã§ã圌ã¯ãããã®ååãæäŸããŸããã

å³5
Analysis Servicesã確ç«ãããçç±ïŒå€æ¬¡å ïŒã¯æããã§ã¯ãããŸããã ããã§ãCLRããã·ãŒãžã£/é¢æ°ãäœæããããšãã§ããŸãã ãšã«ããã æããã«ãSQL Serverãã€ã³ã¹ããŒã«ããåã«.NET Frameworkãã€ã³ã¹ããŒã«ããå¿ èŠããããŸãã NET Framework 3.5ãã€ã³ã¹ããŒã«ããå¿ èŠããããŸãã Windows 8.1ã«ã¯æ¢ã«.NET Framework 4.5.1ïŒ2014 STR1ãåãä»ããªãïŒãä»å±ããŠãããããããŒãžã§ã³4.xãã€ã³ã¹ããŒã«ããŠã圹ã«ç«ã¡ãŸããããããã£ãŠã4.xãã¬ãŒã ã¯ãŒã¯ã¯åã«ã€ã³ã¹ããŒã«ãããŸããã

å³6
.NET Framework 3.5ã¯ãWindows 8.xãã€ã³ã¹ããŒã«ãããã¡ãã£ã¢ããã€ã³ã¹ããŒã«ããã®ãæãç°¡åã§ãã 管çè ç¹æš©ã§ã³ãã³ãããã³ãããéããŸãã

å³7
ãããŠã³ãã³ããæžããŸãïŒ
Dism /online /enable-feature /featurename:NetFx3 /All /Source:D:\sources\sxs /LimitAccess

å³8
ããã§ã[ã³ã³ãããŒã«ããã«]-> [ããã°ã©ã ãšæ©èœ]-> [Windowsã®æ©èœã®æå¹åãŸãã¯ç¡å¹å]ã«ç§»åãããšã8.1ã®.NET Framework 3.5ãã€ã³ã¹ããŒã«ãããŠããããšãããããŸãã

å³9
ãã®åŸãSQL Server 2014 CTP1ã®ã€ã³ã¹ããŒã«ã¯æåããŸãã
TFSã§ã¬ããŒãæ©èœã䜿çšããå ŽåãSQL Serverã®äžéšãšããŠAnalysis ServicesãšReporting Servicesãå¿ èŠã«ãªããŸãã ããã§ã¯ãã®ãããªã¿ã¹ã¯ãèšå®ããŸããããããã«æ³šæããå¿ èŠããããŸãã

å³10
ASãTFSçšã«å€æ¬¡å ããã³ããŒã¿ãã€ãã³ã°ã¢ãŒãã§ã€ã³ã¹ããŒã«ããŸãã ããã¯ããŒãžã§ã³7.0ïŒ1998ïŒä»¥éã«ååšããæŽå²çã«TFSã¯ãããšé£æºããŠç¬èªã®ã³ãŒããã£ãŒã³ãã¥ãŒããçŸåšã®äœæ¥é ç®ãäœæ¥é ç®å±¥æŽããã«ãããã¹ãçµæãã³ãŒãã«ãã¬ããžãªã©ãäœæããŠããŸããã Tfs_Datawarehouseãªã¬ãŒã·ã§ãã«ã¹ãã¬ãŒãžã«åºã¥ãå€æ¬¡å Tfs_AnalysisããŒã¿ããŒã¹å ã 衚圢åŒã¢ãŒãã¯ãçŸåšã®ããŒãžã§ã³-2012ïŒããã³2008 R2ã®æç¹ã§ã¯Excelã®å人çšããŒã«ããã³SharePoint PowerPivotã®éåããŒã«ãšããŠååšããŠããŸããïŒã®ä»£æ¿ãã¥ãŒ/ã¹ãã¬ãŒãžãšããŠå ¬åŒã«ç»å ŽããŸããããTFSã¯ãŸã åäœããŸããã è©Šã¿ã ãªãããŠããŸããã ããçšåºŠãŸã§ã¯ãExcelã®ã€ã³ã¿ã©ã¯ãã£ããªã¬ããŒãäœæããŒã«ã§ããPower Viewã¯ãåŸæ¥ã®Reporting Services / ReportViewer Controlsãšæ¯èŒããŠéåžžã«çŸãããã€ãããã¯ã§ããã衚圢åŒã®ã¢ãã«ã§ããæ©èœããªãã£ããšããäºå®ãåå ã§ããã ãããã5æ31æ¥ã«ãã®äžæ£ã¯ä¿®æ£ãããä»ã§ã¯éé£ã§ãã åãçŸããã§ãè¡šã¢ãã«ãšå€æ¬¡å ã¢ãã«ã®äž¡æ¹ã§ã¬ããŒããäœæã§ããŸãã 12æ¥ç®ã®å Žåã<a href= gain support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2833645&kbln=en-us> SP1 CU4ãããæ£ç¢ºã«ã¯2012_SP1_PPExcel_CU4_2833645_11_0_3368_x64ãã€ã³ã¹ããŒã«ããããšãå¿ããªãã§ãã ãã ã
çç±ã«ãããä»®æ³ãã·ã³ã§ã¯ãªããã¹ãã«TFSãé 眮ããŸã

å³11
Windows 8ã§ã¯ãåé¡ãªãèµ·åããŸãã æ¡åŒµæ§æã¢ãŒããéžæããŸãã

å³12
SQL Serverã¯ãªã¢ãŒããã·ã³äžã«ããããã§ãã

å³13
ãŸããTFSãã€ã³ã¹ããŒã«ãããŠãããã·ã³ããTFSçšã®SQL Serverã«å°éã§ããããšã確èªããŸãã ãããè¡ãã«ã¯ã ããã¥ã¡ã³ãã§èª¬æãããŠããããã«ããã¡ã€ã¢ãŠã©ãŒã«ã§çä¿¡æ¥ç¶çšã®ããŒããéããããŒã¿ããŒã¹ãæäœã§ãããã¹ãäžã§ã¢ããªã±ãŒã·ã§ã³ïŒPowerShellãExcelãªã©ïŒãå®è¡ããããããæ¥ç¶ãè©Šã¿ãŸãã ããšãã°ãExcelã®ã¡ãã¥ãŒã®[ããŒã¿]-> [ä»ã®ãœãŒã¹ãã]-> [SQL Serverãã]ã§ã¯ãæ¢å®ã®ã€ã³ã¹ã¿ã³ã¹ã§ã€ã³ã¹ããŒã«ãããŠããã³ã³ãã¥ãŒã¿ãŒã瀺ããŸãã

å³14
æ¥ç¶ãæ£åžžã«ç¢ºç«ãããŠããããšã確èªããŠãã ãã-ããŒã¿ããŒã¹ã®ãªã¹ãã衚瀺ãããŸãïŒ

å³15
ãã®å ŽåãTFSã¯Windows 8ã«ã€ã³ã¹ããŒã«ãããŠãããããã¬ããŒãæ©èœã¯å©çšã§ããŸãã- ããã¥ã¡ã³ããåç §ããŠãã ããïŒ ããã«ãWindows 7ãªã©ã®ã¯ã©ã€ã¢ã³ããªãã¬ãŒãã£ã³ã°ã·ã¹ãã ã«TFSãã€ã³ã¹ããŒã«ããå Žåãããã§èª¬æããããã«ã¬ããŒããè¿œå ããããšã¯ã§ããŸããã¯ã©ã€ã¢ã³ããªãã¬ãŒãã£ã³ã°ã·ã¹ãã ã§ã¯ãµããŒããããŠããŸãã ã ãµãŒããŒãªãã¬ãŒãã£ã³ã°ã·ã¹ãã ã§ãããã¬ããŒãæ©èœã®äœ¿çšãèšç»ããŠããå Žåã¯ãããŒã¿ããŒã¹ãšã³ãžã³ãžã®ã¢ã¯ã»ã¹ãšå ±ã«ãTFSããASããã³RSãžã®ã¢ã¯ã»ã¹ããã¹ããããšäŸ¿å©ã§ãã æ¢å®ã®ã€ã³ã¹ã¿ã³ã¹ã§ã€ã³ã¹ããŒã«ãããAnalysis Servicesã¯ãTCPããŒã2383ã§ãªãã¹ã³ããŸããååä»ãã€ã³ã¹ã¿ã³ã¹ã®å ŽåãããŒãã¯åçã«å²ãåœãŠãããŸãã ãã®å ŽåãããŒã2382ãéãå¿ èŠããããŸããããã¯ãããŒãã®åçå²ãåœãŠã管çããSQL BrowserãµãŒãã¹ããªãã¹ã³ããŸãã ã¬ããŒããµãŒãã¹ã®å ŽåãããŒããç¹ã«éãå¿ èŠã¯ãããŸããã å¯äžã®ããšã¯ãIISã¯å¿ èŠãªãããïŒå³9ãåç §ïŒãHTTPçµç±ã§å€éšããã¢ã¯ã»ã¹ã§ããããã«ã80çªç®ã®ããŒããéããŠããããšã確èªããå¿ èŠããããŸãã ããŒãžã§ã³2008以éãReporting Servicesã¯Http.sysã·ã¹ãã ãã©ã€ããŒãçŽæ¥äœ¿çšããŠãReporting Servicesçšã«æ§æããããšã³ããã€ã³ãïŒURLããã³ããŒãïŒå®ãŠã®èŠæ±ãåãå ¥ããŸãã æ§æã¯ãReporting Servicesæ§æãããŒãžã£ãŒãŠãŒãã£ãªãã£ã䜿çšããŠè¡ãããŸãã TFSããã¬ããŒããµãŒããŒã«ã¢ã¯ã»ã¹ã§ããããšã確èªããŸãã

å³16
TFSã®è¿œå ã€ã³ã¹ããŒã«ã¯ç°¡åã§ãã æºåãã§ãã¯æ®µéã§ãçµæã®èŠçŽãååŸãããŸããããã¯ããã¹ãŠãæ£åžžã§ãããšå ±åããæçµçã«ã€ã³ã¹ããŒã«ã§ããŸãã

å³17
ãŸãã¯ãã€ã³ã¹ããŒã«ãå®äºããããã«ä¿®æ£ããå¿ èŠãããã³ã¡ã³ãã®ãªã¹ãã äŸãã°

å³18
ãšã©ãŒTF255457ã¯ãããŒã«ã«ãŠãŒã¶ãŒãTFSãµãŒãã¹ã¢ã«ãŠã³ãã«æå®ããããšããäºå®ãåå ã§çºçããŸãã-å³13ã®åŸ

å³19
TFSãåããSQL Serverãå¥ã®ãã·ã³ã§ãã¹ããããŠããå Žåãå³å¯ãªãã¡ã€ã³ã¢ã«ãŠã³ããå¿ èŠã§ãã ãã®å¶éã¯ããã¢ããã³ãã¹ãç°å¢ã§ã®TFSã®å±éãä¿é²ãããæããã«å³11ãšåãå²åŠçã«ãŒããæã£ãŠããããVS13ãWindows 8.1ã«ã€ã³ã¹ããŒã«ãããŠããªãå Žåãæ°ããWindowsã¹ãã¢ãããžã§ã¯ããäœæã§ããŸããã
ãšã©ãŒTF255149ã¯ãSQL Serverã®ã€ã³ã¹ããŒã«äžã«ãTFSã«äžå¯æ¬ ãªã³ã³ããŒãã³ããããŒã¯ããã®ãå¿ããããã«çºçããŸãã å³4ã§å šææ€çŽ¢ãè¡ããŸãã ãã®å ŽåãSQL Serverã®ã€ã³ã¹ããŒã«ããã»ã¹ãåèµ·åããæ°ããã€ã³ã¹ã¿ã³ã¹ãèšãããæ¢åã®æ©èœãè¿œå ããŠãããè¿œå ãæ瀺çã«ç€ºããŸãã

å³20
éãããç»é¢ã®å³4ã§ã¯ãèŠéããæ©èœãæäŸããŠããŸãã