25幎ã®ãã£ãªã¢ãã€ã¯ããœããèªå®è¬åž«ã«èã MS SQL Serverã®éå¶ç©èªïŒ â
SQL Serverã®éçšãåå¿è
ã§ãç°¡åã§æ¥œããïŒ ð
SQL Server 2022ã®ããŒãžã§ã³ã«åºã¥ããŠãSQL Serverã®ã€ã³ã¹ããŒã«ããå§ããŠãããŒã¿ããŒã¹ç®¡çãããã¯ã¢ãããšåŸ©å
ãæš©é管çãããŒã¿è»¢éãããã³æ¥åèªååæè¡ãäœç³»çã«åŠç¿ããŸãã
1ïžâ£ 次ã®ãããªããŸããŸãªãããã¯ãäœç³»çã«åŠç¿ããSQL Server ã®éçšæè¡ãç¿åŸããŸãã SQL Serverã®ã€ã³ã¹ããŒã«ãšãµãŒãã¹ã®ç®¡çææ°ã®SQL Server 2022ããŒãžã§ã³ã®ããŠã³ããŒããšã€ã³ã¹ããŒã« Management Studioã®ããŠã³ããŒããšã€ã³ã¹ããŒã« Configuration Managerã䜿çšãããµãŒãã¹ãšTCP / IPæ¥ç¶ã®ç®¡ç ããŒã¿ããŒã¹ãäœæããŠã¡ã³ããã³ã¹ããŒã¿ããŒã¹ã®å Žæãçè§£ãã ããŸããŸãªåœ¢åŒã®ããŒã¿ããŒã¹ã®äœæ ãã¡ã€ã«ã°ã«ãŒãã®çè§£ãšæŽ»çš ããŸããŸãªããŒã¿ããŒã¹ãªãã·ã§ã³ã®çè§£ ããŒã¿ããŒã¹ã®ãµã€ãºã倧ããããŠå°ãããã ããŒã¿ããŒã¹ãã¡ã€ã«ãå¥ã®å Žæã«ç§»åãã ããŒã¿ããŒã¹ã®ããã¯ã¢ãããšåŸ©å
ããŸããŸãªããã¯ã¢ããæ¹æ³ãšããã¯ã¢ããæŠç¥ãçè§£ãã å®å
šãå·®åããã©ã³ã¶ã¯ã·ã§ã³ãã°ã®ããã¯ã¢ãããå®è¡ãã ããŒã¿ããŒã¹ããã¯ã¢ããå§çž®ã®èšå® ããã¯ã¢ããæŠç¥ã«ãã埩å
æ¹æ³ã®çè§£ ããŸããŸãªç¶æ³ã§ããŒã¿ããŒã¹ã埩å
ãã ãã©ã³ã¶ã¯ã·ã§ã³ããã¯ã¢ããã䜿çšããç¹å®æç¹ã®åŸ©å
ã¢ã«ãŠã³ãã®äœæãšæš©éã®ç®¡çãã°ã€ã³ã¢ã«ãŠã³ããäœæããŠæš©éã管çãã ããŒã¿ããŒã¹ãŠãŒã¶ãŒã¢ã«ãŠã³ããäœæããŠæš©éã管çãã ãªããžã§ã¯ããžã®ã¢ã¯ã»ã¹æš©ã®å¶åŸ¡ ããŒã¿è»¢é SQL Serveréã®ããŒã¿è»¢é ExcelãšSQL Serveréã®ããŒã¿è»¢é Excelã§ãªã¢ã«ã¿ã€ã ã«SQL ServerããŒã¿ãæ€çŽ¢ãã SQL Serveréã®æ¥ç¶ãµãŒããŒã®æ§æ æ¥åæ¥åã®èªåå SQL ServerãšãŒãžã§ã³ããµãŒãã¹ã®æ§æ æ¥åãæŽ»çšããæ¥åæ¥åã®èªåå ä¿å®èšç»ãŠã£ã¶ãŒãã䜿çšããããã¯ã¢ããèªååã®æ§æ ããŒãã¹ãå°ãé«çŽãªæäœæè¡ããŒã¿ããŒã¹ã¡ãŒã«ã«ããèªååç£èŠ ããŒã¿ããŒã¹ã¹ãããã·ã§ããã«èª€ã£ãŠå
ã«æ»ã ããŒã¿ããŒã¹æå·åã«ãããã¡ã€ã«æ¥ç¶ãšåŸ©å
ã®ããã㯠2ïžâ£ å®éã®éçšç°å¢ã®ããã«æ§æãã宿ã®ããå®ç¿ç°å¢ã䜿çšããŸãã
ç°¡åïŒãè¶ïŒåžïŒ ð ãã£ããç
®ã SQL Server ãªãã¬ãŒãã£ã³ã°æè¡ é·æéãªãã©ã€ã³ã®ã¹ã¿ãã£éå¶ãè¬çŸ©ãã»ãããŒãªã©ãéããŠå§ãã人ã®å¿ã誰ãããããç¥ãã®ã§ãåå¿è
ã®èгç¹ããç°¡åã«+ãã£ãã+ãã£ããææ¥ãé²ããŸãã
1ïžâ£ã»ã¯ã·ã§ã³çŽ¹ä» åã®ã»ã¯ã·ã§ã³ã§åãäžããå
容ãååã«åŠç¿ããããšã確èªããŠãã ãããå¿æŽã®ã¡ãã»ãŒãžãšãšãã«æ°ããã»ã¯ã·ã§ã³ã§åãäžããããå
容ãå
šäœçã«èª¬æããè¬çŸ©ãèãåã«ååã«æºåã§ããæéãæäŸããŸãã
2ïžâ£ çè«ææ¥ äœç³»çã«æŽçãããPPTè³æãéããŠãå
šäœçãªå
容ãåªå
åŠç¿ããŸãããã®ã¹ãã«ããªãåŠã¶ã¹ãããã©ã®ããã«æŽ»çšããããåŠç¿ããããšã§ãåŠç¿ã«å¯Ÿããæ¬²æ±ãé«ããããšã«ãªããŸãã
3ïžâ£ éå¶å®ç¿ ãã£ãŒã«ãã·ã«ããŒãšåã圢åŒã§æ§æãããWindows Server 2016 + SQL Server 2022ç°å¢ã掻çšããŠãå®éã®ãã¹ãŠã®éçšã¹ãã«ãèŠãªããåŠç¿ããŸããé·æéã®çŸå Žçµéšãããšã«ãæ¬åœã«å¿
èŠãªéšåã«ã€ããŠèª¬æããŸãã®ã§ãçŸå Žã§ããã«äœ¿ããéå¶æè¡ãç¿åŸããããšã«ãªããŸãã
ð§20幎éã®è¬çŸ©ãšå®åãã³ã³ãµã«ãã£ã³ã°ã®ãã£ãªã¢ 10幎以äžã«ããã£ãŠé²è¡ããŠããç ç©¶éå¶çµéšããå§ãŸã人ã®å¿ãååã«çè§£ããŠããŸãã 20幎以äžã«ãããæè²ã»ã³ã¿ãŒãšäŒæ¥åºè¬ã§ç©ã¿éããããŠããŠã§ãç°¡åã§é¢çœãè¬çŸ©ãé²ããŠããŸãã SQL Server ãåããŠãå©çšã®æ¹ã«æé©ãªåŠç¿æ©äŒãæäŸããŸãã æ°å€ãã®ã³ã³ãµã«ãã£ã³ã°çµéšã«åºã¥ããŠãç¹å®ãããçŸå Žã§æ¬åœã«å¿
èŠãªéçšæè¡ãã«ããŒããŠããŸãã ãã®è¬çŸ©ãäœã£ã人ðšâðа
èæž
ããã£ãã§å³ããç¹å¥ãªäžçSQL Serveréçºç·šãå·çãã«ããŒããŒã㌠ããã£ãã§å³ããç¹å¥ãªäžçSQL Serveréå¶ç·šãå·çãã«ããŒããŒã㌠ãä»åŸã®SQL Server 2012éå¶ãšéçºãå·çããã€ããã©ãŒã©ã ãå人æ
å ±ä¿è·ã®ããã®SQL Serverã»ãã¥ãªãã£ã¬ã€ããå·çããã€ã¯ããœãã è¬çŸ©ãšæè²çµéš SKTæè¡è·è»æ°å
¥(JT)察象è·åæè² KTãšã€ãã«ïŒAIVLEïŒã¹ã¯ãŒã«1ïœ3æããŒã¿å°éå®¶é€æèª²çš GS EPSããŒã¿åæã®æ·±åéçš ã»ããã©ãã¯ã¢ã€ããŒã¿ããŒã¹ç®¡çã³ãŒã¹ CJ倧éééSQL Serverã®ç£èŠãšæé©åããã»ã¹ SK C&CããŒã¿ååŠçãåæå®åãæ©æ¢°åŠç¿ããã»ã¹ 倧é±éè¡ããŒã¿å°éå®¶é€æèª²çš KTæªæ¥äººæè²æãããžã§ã¯ãããŒã¿ååŠçãæ©æ¢°åŠç¿ã³ãŒã¹ åœçšåºïŒãœãŠã«ã倧é±ïŒãã©ã¬ã³ãžãã¯èª¿æ»ã®ããã®SQLã³ãŒã¹ SKãããã¯ãŒã¯ã¹DAïŒData ArchitectïŒé€æéçš Hyosung TNSéçºè
ã®ããã®SQLã³ãŒã¹ ãã³ã©ã°ã«ãŒãPythonããŒã¿åæå¯èŠåããã»ã¹ ãã¹ã³å»ºèšããŒã¿åæå¯èŠåããã»ã¹ ãã¹ã³ICTããŒã¿åæããã»ã¹ SKãããã¯ãŒã¯ããŒã¿ãããã§ãã·ã§ãã«é€æã³ãŒã¹ CJãªãªãŒããããã¯ãŒã¯ã¹æ°å
¥ç€Ÿå¡æè²èª²çšãªã©å€æ° Q&Að Q. SQLæãç¥ãå¿
èŠããããŸããïŒ
ãã®ããã»ã¹ã¯SQL Serverã®æäœããã»ã¹ã§ããã»ãšãã©ã®ãªãã¬ãŒãã£ã³ã°æè¡ã¯SQL Server Management Studioã®ãŠãŒã¶ãŒã€ã³ã¿ãŒãã§ã€ã¹ã䜿çšããŸãããããã£ãŠãSQLæãç¥ããªããŠãããŸã£ããé¢ä¿ããããŸãã ãè¬çŸ©ã®äžã§éåžžã«å°ãã®SQLæã䜿çšããŸãããã¡ãã£ãšèŠãŠããããéåžžã«ç°¡åãªæ§æã®ããã€ãã§ããããŒããŒããšããŠã¹ã ããå©çšå¯èœã§ããã°ã ãã®ããã»ã¹ã«è§Šããã®ã«åé¡ã¯ãããŸããã
Q. ã©ã®ããŒãžã§ã³ã® SQL Server ã察象ãšããŠããŸããïŒ
çŸåšãææ°ããŒãžã§ã³ã®SQL Serverã¯2022 ããŒãžã§ã³ã§ãã Windows Server 2016ã«SQL Server 2022 Developer Editionãã€ã³ã¹ããŒã«ããç°å¢ã«é²ã¿ãŸãããã ããSQL Serverã®éçšã«ã¯æ¬åœã«å¿
èŠãªã¹ãã«ãåŠã³ããããã®éçšã¹ãã«ã¯SQL Serverã®ãã¹ãŠã®ããŒãžã§ã³ã§å
±éã§ãããã®ãããSQL Server 2008以éã䜿çšããŠããæ¹ã«åœ¹ç«ã€è¬çŸ© ã§ãã
Q. é¢é£ããææã賌å
¥ããå¿
èŠããããŸããïŒ
æ¬è¬çŸ©ã®æ åã¯ããã£ãã§å³ããç¹å¥ãªäžçã®SQL Serveréå¶ç·šãåºã«äœãããŠããŸãããå¿
ãããé¢é£ææã賌å
¥ããå¿
èŠã¯ãããŸãããååãªçè«ã®èª¬æãšå®éã®éçšæ¹æ³ã瀺ããè¬çŸ©ãé²ããŸããè¬çŸ©æ åãéããŠååã«çè§£ã§ããªãå Žå ããŸãã¯è¬çŸ©æ åã§æ±ã£ãŠããªãå
容ã«é¢å¿ãããå Žåã¯ã ææã賌å
¥ããŠã¿ããšããã§ãããã
Q. è¬çŸ©ãèãåã«æºåãã¹ãããšã¯ãããŸããïŒ
å®éã®SQL Serverãã€ã³ã¹ããŒã«ããã«è¬çŸ©æ åã ããèŠãªããåŠç¿ããŠãååãªå¹æ ããããŸããããããèªåã®PCã«SQL Serverãã€ã³ã¹ããŒã«ããçŽæ¥éçšæè¡ãå®ç¿ããªããåŠã¶ãšãåŠç¿å¹æã倧ããã§ããããè¬çŸ©ã¯å®éã®éçšç°å¢ãæ§æããŠé²ããŸãããå人ã䜿çšããPCã«SQL Serverãã€ã³ã¹ããŒã«ããŠäœ¿çšããŠãããŸããŸããããã®ãããWindows 10以äžã®ãªãã¬ãŒãã£ã³ã°ã·ã¹ãã ãã€ã³ã¹ããŒã«ãããPCã çšæãããŠããã°ãšæããŸãã