[B! SQL Server] tyamamotoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

tyamamoto id:tyamamoto

SQL Serverã«é–¢ã™ã‚‹tyamamotoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (36)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Entity Framework Core 7 ã§ ã€Œä¿¡é ¼ã•ã‚Œã¦ã„ãªã„æ©Ÿé–¢ã«ã‚ˆã£ã¦è¨¼æ˜Žæ›¸ãƒã‚§ãƒ¼ãƒ³ãŒç™ºè¡Œã•ã‚Œã¾ã—ãŸã€‚ã€ - nakamurakkoâ€™s blog
ç’°å¢ƒ Visual Studio 2022 SQL Server 2019 .NET 7 Entity Framework Core 7 (EF Core) Entity Framework Core 7 ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã®ã§ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«é©ç”¨ã—ãŸã¨ã“ã‚ã€ Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - ä¿¡é ¼ã•ã‚Œã¦ã„ãªã„æ©Ÿé–¢ã«ã‚ˆã£ã¦è¨¼æ˜Žæ›¸ãƒã‚§ãƒ¼ãƒ³ãŒç™ºè¡Œã•ã‚Œã¾ã—ãŸã€‚) ã¨ã€ä¾‹å¤–ãŒç™ºç”Ÿã—ãŸã€‚ èª¿ã¹ãŸã¨ã“ã‚ã€EF Core 7.0 (EF7) ã§ã®ç ´
tyamamoto 2023/08/14
.net

SQLServer

SQL Server
ãƒªãƒ³ã‚¯
Microsoft.Data.SqlClient 4.0 ä»¥é™ã§ SQL Server ã«æŽ¥ç¶šã™ã‚‹éš›ã®æš—å·åŒ–ã‚ªãƒ—ã‚·ãƒ§ãƒ³ at SE ã®é›‘è¨˜
å…ˆæ—¥ã€Microsoft.Data.SqlClient 5.0 ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ Released: General Availability of Microsoft.Data.SqlClient 5.0 æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ã¯ã€æ¬¡ã®æƒ…å ±ã‹ã‚‰ã‚‚ç¢ºèªã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ Microsoft.Data.SqlClient 5.0.0 released 5 August 2022 Microsoft.Data.SqlClient åå‰ç©ºé–“ã®æ¦‚è¦ 4.0 ã®ç ´å£Šçš„å¤‰æ›´ã«å«ã¾ã‚Œã‚‹ã®ã§ã™ãŒã€4.0 ä»¥é™ã¯æŽ¥ç¶šæ–‡å—åˆ—ã®ã€ŒEncryptã€ãŒã€Œtrueã€ã«è¨å®šã•ã‚Œã‚‹ã“ã¨ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¨ãªã‚Šã¾ã—ãŸã€‚ Encrypt æŽ¥ç¶šæ–‡å—åˆ—ãƒ—ãƒãƒ‘ãƒ†ã‚£ãŒæ—¢å®šã§ true ã«ãªã‚‹ã‚ˆã†ã«å¤‰æ›´ã—ã¾ã—ãŸã€‚ #1210è©³ç´°ã‚’èªã‚€ ã“ã‚Œã«ã‚ˆã‚Šã€ã‚ªãƒ³ãƒ—ãƒ¬ãƒŸã‚¹ã® SQL Server ã®ã‚ˆã†ãªç’°å¢ƒã§ã¯ã€4.0 ã‚ˆã‚Šå‰ã¨åŒä¸€ã®æŽ¥ç¶šæ–‡å—åˆ—ã§æŽ¥ç¶š
tyamamoto 2023/08/14
.net

SQL Server

SQLServer
ãƒªãƒ³ã‚¯
SQL Serverã®CDCã‚’ç”¨ã„ãŸåŠ ç†±å•†å“ã®è²©å£²ã‚¤ãƒ™ãƒ³ãƒˆã«ãŠã‘ã‚‹è² è·è»½æ¸›ã®å–ã‚Šçµ„ã¿ - ZOZO TECH BLOG
ã“ã‚“ã«ã¡ã¯ã€SREéƒ¨ã®å»£ç€¬ã§ã™ã€‚ æœ¬è¨˜äº‹ã§ã¯ã€ZOZOTOWNã§ã‚«ãƒ¼ãƒˆã«å•†å“ã‚’å…¥ã‚Œã‚‹éš›ã«ä½¿ã‚ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç¾¤ã®å†…ã€SQL Serverï¼ˆä»¥é™ã€ã‚«ãƒ¼ãƒˆDBã¨å‘¼ã¶ï¼‰ã«ãƒ•ã‚©ãƒ¼ã‚«ã‚¹ã—ã¾ã™ã€‚ZOZOTOWNã§ã¯æ•°å¹´å‰ã‹ã‚‰ã€äººæ°—ã®å•†å“ï¼ˆä»¥é™ã€åŠ ç†±å•†å“ã¨å‘¼ã¶ï¼‰ãŒç™ºå£²ã•ã‚ŒãŸéš›ã€ã‚«ãƒ¼ãƒˆDBãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã‚‹å•é¡Œã‚’æŠ±ãˆã¦ã„ã¾ã™ã€‚æ§˜ã€…ãªè² è·è»½æ¸›ã®å–ã‚Šçµ„ã¿ã‚’é€šã˜ã¦çŠ¶æ³ã¯åŠ‡çš„ã«æ”¹å–„ã•ã‚Œã¦ã„ã¾ã™ãŒã€æœªã ã«å®Œç’§ãªèª²é¡Œè§£æ±ºã«ã¯è‡³ã£ã¦ã„ã¾ã›ã‚“ã€‚ ãã“ã§ä»Šå›žã¯ã€åŠ ç†±å•†å“ã®ç™ºå£²ã‚¤ãƒ™ãƒ³ãƒˆã«ãŠã‘ã‚‹è² è·è»½æ¸›ã®å–ã‚Šçµ„ã¿ã‚’æŒ¯ã‚Šè¿”ã‚Šã¾ã™ã€‚ã¾ãŸã€ç›´è¿‘ã®å–ã‚Šçµ„ã¿ã¨ã—ã¦ã€SQL Serverã®CDCã‚’ç”¨ã„ãŸæ–°ãŸãªè² è·è»½æ¸›ã®æ¤œè¨¼å†…å®¹ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ èƒŒæ™¯ - ã‚«ãƒ¼ãƒˆDBã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ã¤ã„ã¦ åŠ ç†±å•†å“ã®ç™ºå£²ã‚¤ãƒ™ãƒ³ãƒˆã«é–¢ã™ã‚‹å¯¾ç–ã«ã¤ã„ã¦ã€æœ€åˆã«è¨€åŠã—ãŸè¨˜äº‹ã¨ã—ã¦ã¯ä»¥ä¸‹ãŒæŒ™ã’ã‚‰ã‚Œã¾ã™ã€‚ã“ã®è¨˜äº‹ã§ã¯äººæ°—ã®ç¦è¢‹å•†å“ã‚’åŠ ç†±å•†å“ã¨ã—ã¦ç´¹ä»‹ã—ã¦ã„ã¾ã™ãŒ
tyamamoto 2022/09/02
SQL Server
ãƒªãƒ³ã‚¯
SQL Server2016ã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã‚’è§£èª¬ã—ã¾ã™
SQLServerã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã‚’ã‚¶ãƒƒã‚¯ãƒªã¨è¨ˆç®—è¨ˆç®—ã—ã¦ã¿ã¾ã™ã€‚ 2ã‚³ã‚¢ãƒ»1ãƒ—ãƒã‚»ãƒƒã‚µãƒ¼ã®å ´åˆ 8ã‚³ã‚¢ï¼ˆ2â†’8ã¨ãªã‚‹ï¼‰ Ã— 1ãƒ—ãƒã‚»ãƒƒã‚µãƒ¼ = 8ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ 16ä»¥ä¸‹ã®ãŸã‚ã€8ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§ã¯ãªã16ã‚³ã‚¢ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¨ãªã‚‹ 10ã‚³ã‚¢ãƒ»1ãƒ—ãƒã‚»ãƒƒã‚µãƒ¼ã®å ´åˆ 10ã‚³ã‚¢ Ã— 1ãƒ—ãƒã‚»ãƒƒã‚µãƒ¼ = 10ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ 16ä»¥ä¸‹ã®ãŸã‚ã€10ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§ã¯ãªã16ã‚³ã‚¢ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¨ãªã‚‹ 2ã‚³ã‚¢ãƒ»4ãƒ—ãƒã‚»ãƒƒã‚µãƒ¼ã®å ´åˆ 8ã‚³ã‚¢ï¼ˆ2â†’8ã¨ãªã‚‹ï¼‰ Ã— 4ãƒ—ãƒã‚»ãƒƒã‚µãƒ¼ = 32ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ 10ã‚³ã‚¢ãƒ»4ãƒ—ãƒã‚»ãƒƒã‚µãƒ¼ã®å ´åˆ 10ã‚³ã‚¢ Ã— 4ãƒ—ãƒã‚»ãƒƒã‚µãƒ¼ = 40ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ SQLServerã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹æ•°ã€ã€Œæœ€ä½Žã—ã°ã‚Šã€ãŒã‚ã‚‹ã®ãŒã¡ã‚‡ã£ã¨é¢å€’ã§ã™ãã€‚ æ³¨æ„ç‚¹ã¨ã—ã¦ã€è²©å£²æ•°ã¯ï¼’ã‚³ã‚¢ã§1ãƒ‘ãƒƒã‚¯ã¨ãªã‚Šã¾ã™ã€‚ã‚ˆã£ã¦ã€ãƒ©ã‚¤ã‚»ãƒ³ã‚¹æ•°ã€Œï¼‘ï¼–ã€ã®å ´åˆã€è³¼å…¥ã™ã‚‹æ•°ã¯ï¼‘ï¼–Ã·ï¼’ï¼ï¼˜ãƒ‘ãƒƒã‚¯ã§ã™ã€‚ã‚„ã‚„ã“ã—ã„ã§ã™ãã€‚ ã‚³ã‚¢ãƒ™ãƒ¼ã‚¹ã®è©³ç´°ã¯ã“ã¡ã‚‰ã‚’å‚ç…§ã—ã¦ãã
tyamamoto 2017/08/21
SQL Server
ãƒªãƒ³ã‚¯
æš—å·åŒ–ã•ã‚ŒãŸæ–‡å—åˆ—ã‚’ã‚ã„ã¾ã„æ¤œç´¢ã™ã‚‹æ–¹æ³• | SQL Server
ä»Šå›žã¯SQL Server ã«ã¦æš—å·åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦ã‚ã„ã¾ã„æ¤œç´¢ã™ã‚‹æ–¹æ³•ã‚’ã”ç´¹ä»‹ã„ãŸã—ã¾ã™ã€‚æš—å·åŒ–ã¨ã„ã£ã¦ã‚‚DBä¸¸ã”ã¨æš—å·åŒ–ã™ã‚‹æ©Ÿèƒ½ã®äº‹ã§ã¯ãªãã€ä»Šå›žã¯ãƒ‡ãƒ¼ã‚¿å˜ä½ã§æš—å·åŒ–ã—ã¦ã‚ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ã«å¯¾ã—ã¦ã‚ã„ã¾ã„æ¤œç´¢ã™ã‚‹æ–¹æ³•ã§ã™ã€‚ ã“ã‚ŒãŒã¾ãŸåŽ„ä»‹ãªã®ã§ã™ã€‚ å‰ææ¡ä»¶ ãƒ»Windows 7 professional ä»¥é™ / Windows Server 2008 R2 ä»¥é™ ãƒ»SQL Server 2008 Developer / Standard / Enterprise ä»¥é™ ä¾‹ãˆã°ã€€å±±ç”°å¤ªéƒŽã€€ã¨ã„ã†å€‹äººæƒ…å ±ã‚’æš—å·åŒ–ã—ãŸå ´åˆã€ T_Customerãƒ†ãƒ¼ãƒ–ãƒ« ID,Â NAME ------------------------------- 1,Â 0x8E52936391BE9859 Â â†ã€Œå±±ç”°å¤ªéƒŽã€ã‚’æš—å·åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ ä¸Šè¨˜ã®ã‚ˆã†ã«DBã«ç™»éŒ²ã•ã‚Œã¦ã„ã‚‹ã¨ã—ã¾ã™ã€‚ ã“ã‚Œã«å¯¾ã—ã¦ã€ SELE
tyamamoto 2017/06/29
SQL Server
ãƒªãƒ³ã‚¯
sql-server-samples/samples at master Â· microsoft/sql-server-samples
tyamamoto 2017/06/05
SQL Server
ãƒªãƒ³ã‚¯
SQL Server 2016 ãƒ‡ãƒ¼ã‚¿æš—å·åŒ– - ã¾ã•ã‚ã‚“å•†åº—ã€‚ï½žè±šè‚‰å¸å£²å•å±‹ç›´å–¶åº—ï½ž
tyamamoto 2017/06/05
SQL Server
ãƒªãƒ³ã‚¯
SQL Server 2016 CTP 2.0 ã® Always Encrypted ã‚’ä½¿ã£ã¦ã¿ã‚‹ at SE ã®é›‘è¨˜
SQL Server 2016 ã§ã¯ã€å¸¸ã«æš—å·åŒ–ã—ãŸçŠ¶æ…‹ã§ãƒ‡ãƒ¼ã‚¿ã‚’ã‚’æ‰±ã† Always Encrypted ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã®æ©Ÿèƒ½ã‚’å°‘ã—è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ è©³ç´°ã«ã¤ã„ã¦ã¯ã€Always Encrypted (Database Engine) ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ åŸºæœ¬çš„ãªè€ƒãˆã¨ã—ã¦ã¯ã€è¨¼æ˜Žæ›¸ã‚’ä½¿ç”¨ã—ãŸæš—å·åŒ–ã¨ãªã‚‹ã‹ãªã¨æ€ã„ã¾ã™ã€‚ CREATE COLUMN MASTER KEY DEFINITION (Transact-SQL) ã‚’å®Ÿè¡Œã—ã¦ã€æš—å·åŒ–ã«ä½¿ç”¨ã™ã‚‹ãƒžã‚¹ã‚¿ãƒ¼ã‚ãƒ¼ãŒã©ã“ã«ã‚ã‚‹ã‹ã‚’å®šç¾©ã™ã‚‹ CREATE COLUMN ENCRYPTION KEY (Transact-SQL) ã‚’å®Ÿè¡Œã—ã¦ã€åˆ—ã®æš—å·åŒ–ã«ä½¿ç”¨ã™ã‚‹ã‚ãƒ¼ã‚’å®šç¾©ã™ã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã®åˆ—ã«å¯¾ã—ã¦ã€æš—å·åŒ–ã®å±žæ€§ã‚’ä»˜ä¸Žã™ã‚‹ ã® 3 æ®µéšŽã§è¨å®šã‚’ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ å†’é ã§ç´¹ä»‹ã—ãŸæŠ€è¡“æƒ…å ±ã¯ã‚¯ã‚¨ãƒªãƒ™ãƒ¼ã‚¹ã§è¨å®šã‚’ã—ã¦ã„ã‚‹ã®ã§ã™ãŒã€ã“
tyamamoto 2017/06/05
SQL Server
ãƒªãƒ³ã‚¯
Windows Serverã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã®ä»•çµ„ã¿ã‚’ç†è§£ã—ã¦ã¿ã‚‹ - PG WORKS
ã‚·ã‚¹ãƒ†ãƒ ã®å‹•ä½œé–¢ä¿‚ä¸Šã€WindowsServerãŒãªã„ã¨å‹•ã‹ãªã„ã¨ã€æ„šç—´ã‚’è¨€ã‚ã‚Œã¦ä»•æ–¹ãªãèª¿ã¹ã¦ã„ãŸã®ã§ã™ãŒã€Linuxã«ã¯å˜åœ¨ã—ãªã„ã€CALã¨ã„ã†ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ãŒã‚ã‚Šã€çŸ¥ã‚‰ãªã„ã¨ãƒˆãƒ©ãƒ–ãƒ«ã«ãªã‚‹å¯èƒ½æ€§ãŒã‚ã£ãŸã®ã§èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ Windows Server OSã®ç¨®é¡ž ç¾æ®µéšŽ(2016å¹´2æœˆ)ã§ã®æœ€æ–°ã¯ã€Windows Server 2012 R2ã«ãªã‚Šã¾ã™ã€‚ 4ã¤ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ãŒã‚ã‚Šã¾ã™ãŒã€ä¸å°ä¼æ¥ã§ã‚ˆãä½¿ã‚ã‚Œã‚‹ã®ã¯ã€ä¸‹è¨˜ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ Standard Essentials Standardã¨Essentialsã©ã¡ã‚‰ã‹ã‚’é¸ã¶ãƒã‚¤ãƒ³ãƒˆ ç„¡é›£ã«Standardã‚’é¸ã‚“ã§ãŠã‘ã°ã€å…¨ã¦ã®æ©Ÿèƒ½ãŒä½¿ãˆã‚‹ãŸã‚ä¸€è¦‹å•é¡Œãªã„ã‚ˆã†ã«è¦‹ãˆã¾ã™ãŒã€WindowsServerã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãŸã‚ã«å¿…è¦ãªCALãŒçµ¡ã‚“ã§ãã¾ã™ã€‚ â€»åŽ³å¯†ã«ã¯ã€WindowsServerã«å…¥ã£ã¦ã„ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹
tyamamoto 2017/05/22
Windows Server

SQL Server
ãƒªãƒ³ã‚¯
SQLServer Express 2014ã‚’ä½¿ã†ã“ã¨ã‚’è€ƒãˆã¦ã„ã‚‹ã®ã§ã™ãŒãƒ»ãƒ»ãƒ»
tyamamoto 2017/05/22
SQL Server
ãƒªãƒ³ã‚¯
SQLServer2012ã«ã¤ã„ã¦ - SQLServer2012ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ãªã‚“ã§ã™ãŒã€SQLServer2012Ent... - Yahoo!çŸ¥æµè¢‹
SQLServer2012ã«ã¤ã„ã¦ SQLServer2012ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ãªã‚“ã§ã™ãŒã€ SQL Server 2012 Enterprise Edition SQL Server 2012 Enterprise Core Edition ã“ã®äºŒã¤ã®é•ã„ã¯ãªã‚“ã§ã—ã‚‡ã†ã‹ã€‚ ã”å›žç”ã‚ˆã‚ã—ããŠé¡˜ã„ã—ã¾ã™
tyamamoto 2017/05/16
SQL Server
ãƒªãƒ³ã‚¯
Sql Server2008ä»¥é™ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é€éŽçš„æš—å·åŒ–(TDE)ã«ã¤ã„ã¦ã®å®Ÿé¨“ - è‡ªå®…ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã®ãƒ¡ãƒ¢éƒ¨å±‹ï¼šæ¥½å¤©ãƒ–ãƒã‚°
February 17, 2016 Sql Server2008ä»¥é™ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é€éŽçš„æš—å·åŒ–(TDE)ã«ã¤ã„ã¦ã®å®Ÿé¨“ ã‚«ãƒ†ã‚´ãƒªï¼šã‚«ãƒ†ã‚´ãƒªæœªåˆ†é¡ž é€éŽçš„æš—å·åŒ–ã«ã¤ã„ã¦ã€å®Ÿé¨“ã—ã¦ã¿ã¾ã—ãŸã€‚ å½“åˆã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨åˆ¥ï¼°ï¼£ã§ã®å¾©å…ƒã¾ã§ã‚’å®Ÿé¨“ã™ã‚‹ã¤ã‚‚ã‚Šã§ã—ãŸãŒã€ å¾©å…ƒå…ˆã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ç”¨æ„ã™ã‚‹ã®ãŒé¢å€’ã ã£ãŸã®ã§åŒã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹å†…ã§ã®æ“¬ä¼¼å®Ÿé¨“ã§ã™ã€‚ å‚è€ƒ:http://blogs.msdn.com/b/sqljapan/archive/2008/10/22/9010764.aspx --********************************************************************** --* Sql Server2008ä»¥é™ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é€éŽçš„æš—å·åŒ–(TDE)ã«ã¤ã„ã¦ã®å®Ÿé¨“ --* å‚è€ƒ:http://blogs.msdn.com/b/sqlja
tyamamoto 2017/05/12
SQL Server
ãƒªãƒ³ã‚¯
SQL Server 2008 Transparent Data Encryption - ãƒ—ãƒªãƒ³ãƒˆã‚¹ã‚¿ãƒƒã‚¯ TOKYO
Microsoft SQL Server 2008ï¼ˆKatm aiï¼‰ã® Transparent Data Encryption ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ SQL Server 2008 ã‹ã‚‰ TDE ï¼ˆé€éŽçš„ãƒ‡ãƒ¼ã‚¿æš—å·ï¼‰ã®æ©Ÿèƒ½ãŒå®Ÿè£…ã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã‚Œã¯ã€Oracle Database ã® TDE ã¨ç•°ãªã‚Šã€ãƒšãƒ¼ã‚¸å˜ä½ã§è¡Œã‚ã‚Œã¾ã™ã€‚ã‚µãƒãƒ¼ãƒˆã™ã‚‹æš—å·ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã¯ã€AES 128ãƒ“ãƒƒãƒˆ / AES 192 ãƒ“ãƒƒãƒˆ / AES 256 ãƒ“ãƒƒãƒˆ / 3DES 3KEYS ã¨ä»£è¡¨çš„ãªã‚‚ã®ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã™ã€‚ ç°¡å˜ãªãƒã‚¤ãƒ³ãƒˆã¯ä¸‹è¨˜ã®ã“ã¨ã§ã—ã‚‡ã†ã€‚ ãƒšãƒ¼ã‚¸å˜ä½ã®æš—å· AES 128ãƒ“ãƒƒãƒˆ / AES 192 ãƒ“ãƒƒãƒˆ / AES 256 ãƒ“ãƒƒãƒˆ / 3DES 3KEYS ã‚’ã‚µãƒãƒ¼ãƒˆ EKM/HSMã‚’ã‚µãƒãƒ¼ãƒˆ SQL Server 2008 ã® TDE ã‚’åˆ©ç”¨ã™ã‚‹ã«ã¯ä¸‹ã«è¨˜è¼‰ã—ãŸæ‰‹é †ã‚’å®Ÿæ–½ã™ã‚‹ã“ã¨ã§è¡Œãˆã¾ã™ã€‚ ãƒžã‚¹ã‚¿
tyamamoto 2017/05/12
SQL Server
ãƒªãƒ³ã‚¯
[è¨è¨ˆç·¨]DBMSã®æ©Ÿèƒ½ã§ãƒ‡ãƒ¼ã‚¿ã‚’æš—å·åŒ–ã—ã¦ã¯ã„ã‘ãªã„
ãƒ‡ãƒ¼ã‚¿ã‚’æš—å·åŒ–ã™ã‚‹ã¨ï¼Œãƒ‡ãƒ¼ã‚¿ãŒæ¼æ´©ã—ã¦ã‚‚æƒ…å ±ã‚’ä¿è·ã§ãã‚‹ã¨ã„ã†åŠ¹æžœãŒã‚ã‚‹ã€‚ä¸»è¦ãªDBMSï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼‰ã¯ï¼Œå†…éƒ¨ã«æ ¼ç´ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã®æš—å·åŒ–æ©Ÿèƒ½ã‚’å‚™ãˆã‚‹ã€‚DBã‚µãƒ¼ãƒãƒ¼ã«ä¸æ£ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸå ´åˆã«åŠ¹æžœã‚’ç™ºæ®ã™ã‚‹ãŒï¼Œãƒ‡ãƒ¡ãƒªãƒƒãƒˆãŒå¤§ãã™ãŽã¦ï¼Œå®Ÿè³ªçš„ã«ä½¿ã£ã¦ã¯ã„ã‘ãªã„æŠ€è¡“ã ã£ãŸã€‚ ä¸»ãªãƒ‡ãƒ¡ãƒªãƒƒãƒˆã¨ã—ã¦ï¼Œå‡¦ç†æ€§èƒ½ã®ä½Žä¸‹ï¼Œé–‹ç™ºã¨é‹ç”¨ã®è² æ‹…å¢—ãŒæŒ™ã’ã‚‰ã‚Œã‚‹ã€‚ãƒ‡ãƒ¼ã‚¿ã‚’æš—å·åŒ–ã™ã‚‹ã¨ï¼Œæ›´æ–°ç³»ã§ã¯æš—å·å‡¦ç†ï¼Œå‚ç…§ç³»ã§ã¯å¾©å·å‡¦ç†ãŒå¿…è¦ã«ãªã‚‹ã€‚ãã®ã†ãˆï¼Œæš—å·åŒ–ã—ãŸã‚«ãƒ©ãƒ ã«ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è¨å®šã§ããªã‹ã£ãŸã‚Šï¼Œè¨å®šã§ãã¦ã‚‚åŠ¹æžœçš„ã«åƒã‹ãªã‹ã£ãŸã‚Šã—ãŸã€‚çµæžœçš„ã«ï¼Œãƒ‡ãƒ¼ã‚¿ã‚’æš—å·åŒ–ã™ã‚‹ã¨ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆãŒæ•°åˆ†ã®1ï½žåæ•°åˆ†ã®1ã«ä½Žä¸‹ã—ã¦ã—ã¾ã†ã€‚ æš—å·æ©Ÿèƒ½ã‚’åˆ©ç”¨ã™ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™ºã¯ï¼Œåˆ©ç”¨ã—ãªã„å ´åˆã«æ¯”ã¹ã¦ç…©é›‘ã«ãªã‚‹ã€‚é‹ç”¨é¢ã§ã¯æš—å·éµã®ç®¡ç†ãŒé›£ã—ã„ã€‚ä¾‹ãˆã°Oracle Database 10gã‚„SQL Server 2005ã§
tyamamoto 2017/05/12
SQL Server
ãƒªãƒ³ã‚¯
ã‚¯ãƒ©ã‚¦ãƒ‰ã§ã®åˆ©ç”¨ã‚‚å®‰å¿ƒï¼ SQL Server ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿æš—å·åŒ–
EnterpriseZineï¼ˆã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¸ãƒ³ï¼‰ç·¨é›†éƒ¨ã§ã¯ã€æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ æ‹…å½“ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ‹…å½“ã®æ–¹ã€…å‘ã‘ã«ã€EnterpriseZine Dayã€Security Online Dayã€DataTechã¨ã„ã†ã€3ã¤ã®ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¦ãŠã‚Šã¾ã™ã€‚ãã‚Œãžã‚Œç·¨é›†éƒ¨ç‹¬è‡ªã®åˆ‡ã‚Šå£ã§ã€æ¥ç•Œãƒˆãƒ¬ãƒ³ãƒ‰ã‚„æœ€æ–°äº‹ä¾‹ã‚’ç¶²ç¾…ã€‚æœ€æ–°ã®å‹•å‘ã‚’çŸ¥ã‚‹ã“ã¨ãŒã§ãã‚‹å ´ã¨ã—ã¦ã€å¥½è©•ã‚’å¾—ã¦ã„ã¾ã™ã€‚
tyamamoto 2017/05/12
SQL Server
ãƒªãƒ³ã‚¯
ã‚ãƒ¼ãƒžãƒ³ã‚ºãƒãƒƒãƒˆ-ITç‰¹é›†
æƒ…ã‚·ã‚¹æ¥å‹™ã®ä¸ã§é¢å€’ãªä»•äº‹ã€æŒ‘æˆ¦ã—ã¦ã¿ãŸã„ä»•äº‹ã¯ä½•ã§ã™ã‹ï¼Ÿã€€ãŠå‹¤ã‚å…ˆã®æƒ…ã‚·ã‚¹ã®èª²é¡Œã‚„ã”è‡ªèº«ã®ã‚ãƒ£ãƒªã‚¢ã€ä»•äº‹ã®ã‚„ã‚ŠãŒã„ã«ã¤ã„ã¦ãŠèžã‹ã›ãã ã•ã„ã€‚ã‚¢ãƒ³ã‚±ãƒ¼ãƒˆã®ä¸ã§ã¯ã€Œæƒ…ã‚·ã‚¹å·æŸ³ã€ã‚‚å‹Ÿé›†ã—ã¦ã„ã¾ã™ã€‚çš†ã•ã¾ã®ã‚¢ã‚¤ãƒ‡ã‚¢ã‚’ãŠå¾…ã¡ã—ã¦ãŠã‚Šã¾ã™ï¼
tyamamoto 2017/05/12
SQL Server
ãƒªãƒ³ã‚¯
SQL Server 2008 é€éŽçš„ãªãƒ‡ãƒ¼ã‚¿æš—å·åŒ–ã‚’è¨å®šã—ãŸå ´åˆã«åˆ¥ãƒžã‚·ãƒ³ã§å¾©å…ƒã™ã‚‹ã«ã¯ - matu_takâ€™s blog
SQL Server 2008 ã®é€éŽçš„ãªãƒ‡ãƒ¼ã‚¿æš—å·åŒ–ï¼ˆTDEï¼‰ã‚’è¨å®šã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯ã€ç°¡å˜ã«ã¯ãƒªã‚¹ãƒˆã‚¢ã§ããªã„ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ã“ã‚Œã¯ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ãƒ•ã‚¡ã‚¤ãƒ«ã‚„ mdf ãƒ•ã‚¡ã‚¤ãƒ«ãŒæŒã¡å‡ºã•ã‚ŒãŸï¼ˆç›—ã¾ã‚ŒãŸï¼‰ã“ã¨ã‚’æƒ³å®šã—ã¦ã„ã‚‹ãŸã‚ã§ã™ï¼ˆä¸èº«ãŒç°¡å˜ã«å‚ç…§ã§ããªã„ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ï¼‰ã€‚ é–‹ç™ºæ©Ÿã‹ã‚‰æœ¬ç•ªæ©Ÿã¸ã€ã‚ã‚‹ã„ã¯ãã®é€†ã¸ãªã©ã€åˆ¥ãƒžã‚·ãƒ³ã¸ãƒ‡ãƒ¼ã‚¿ã‚’ç§»å‹•ã•ã›ãŸã„å ´åˆã«ã¯ã€ã‚µãƒ¼ãƒãƒ¼è¨¼æ˜Žæ›¸ï¼ˆã¨ç§˜å¯†ã‚ãƒ¼ï¼‰ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŠã‚ˆã³ãƒªã‚¹ãƒˆã‚¢ãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ã‚µãƒ¼ãƒãƒ¼è¨¼æ˜Žæ›¸ï¼ˆã¨ç§˜å¯†ã‚ãƒ¼ï¼‰ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã«ã¯ã€æ¬¡ã®ã‚ˆã†ã« BACKUP CERTIFICATE ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ BACKUP CERTIFICATE MyServerCert TO FILE = 'C:\MyServerCert' WITH PRIVATE KEY ( FILE = 'C:\MyPrivKey' , ENCR
tyamamoto 2017/05/12
SQL Server
ãƒªãƒ³ã‚¯
SQL Server 2012 è‡ªç¿’æ›¸ã‚·ãƒªãƒ¼ã‚º No.18 ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ - HTML ç‰ˆ - SQLQuality
SQL Server 2012 è‡ªç¿’æ›¸ ã€ŒNo.18 ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€ï¼ˆHTML ç‰ˆï¼‰ æ¾æœ¬ç¾Žç©‚ã¨æ¾æœ¬å´‡åšãŒåŸ·ç†ã—ãŸå®Œå…¨ã‚ªãƒªã‚¸ãƒŠãƒ« SQL Server 2012 è‡ªç¿’æ›¸ã‚·ãƒªãƒ¼ã‚ºã®ã€ŒNo.18 ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€ã® HTML ç‰ˆã§ã™ã€‚ æ—¥æœ¬ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã•ã‚“ã® Web ã‚µã‚¤ãƒˆã§ Word ã¾ãŸã¯ PDF å½¢å¼ã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ãŒã€ä»Šå›žã€HTML ç‰ˆã¨ã—ã¦å…¬é–‹ã™ã‚‹è¨±å¯ã‚’ã„ãŸã ãã¾ã—ãŸã®ã§ã€ã“ã“ã«æŽ²è¼‰ã„ãŸã—ã¾ã™ã€‚[2013å¹´12æœˆ29æ—¥] 5.1ã€€é€éŽçš„ãªãƒ‡ãƒ¼ã‚¿æš—å·åŒ–ï¼ˆTDE: Transparent Data Encryptionï¼‰ â—†Â é€éŽçš„ãªãƒ‡ãƒ¼ã‚¿æš—å·åŒ– é€éŽçš„ãªãƒ‡ãƒ¼ã‚¿æš—å·åŒ–ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ã™ã¹ã¦æš—å·åŒ–ã§ãã‚‹æ©Ÿèƒ½ã§ã™ã€‚SQL Server 2005 ã®ã¨ãã«ã¯ã€EncryptByKey ã¨ DecryptByKey ã‚’åˆ©ç”¨ã—ãŸæš—å·åŒ–æ©Ÿèƒ½ãŒæä¾›ã•ã‚Œã¦ã„ã¾ã—ãŸãŒã€ã“ã®æ©Ÿèƒ½ã‚’åˆ©
tyamamoto 2017/05/12
SQL Server
ãƒªãƒ³ã‚¯
é›‘è¨˜ : SQLServerã®æš—å·åŒ– - livedoor Blogï¼ˆãƒ–ãƒã‚°ï¼‰
tyamamoto 2017/05/12
SQL Server
ãƒªãƒ³ã‚¯
SQLSERVER LDFãƒ•ã‚¡ã‚¤ãƒ«ã®å‰Šé™¤ - DataBaseã‚¨ãƒ³ã‚¸ãƒ³ - ãƒ•ã‚©ãƒ¼ãƒ©ãƒ - HANI-WA Project.
tyamamoto 2017/02/20
SQL Server
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸