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

ishisaka id:ishisaka

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

${{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}}

Techniques for improving text-to-SQL | Google Cloud Blog
ishisaka 2025/05/18
AIã‚’ä½¿ã£ã¦SQLã‚’ç”Ÿæˆã•ã›ã‚‹ãŸã‚ã®ãƒ™ã‚¿ãƒ¼ãªæ–¹æ³•

ai

SQL Server

sql
ãƒªãƒ³ã‚¯
Introducing the enhanced MSSQL Extension for Visual Studio Code - Azure SQL Devsâ€™ Corner
The MSSQL extension for Visual Studio Code is designed to support developers in building applications that use Azure SQL (including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs), SQL Database in Fabric (Preview) or SQL Server as backend databases. With a comprehensive suite of features for connecting to databases, designing and managing database schemas, exploring da
ishisaka 2024/11/21
SQL Server
ãƒªãƒ³ã‚¯
Announcing EAP for Vector Support in Azure SQL Database - Azure SQL Devsâ€™ Corner
ishisaka 2024/09/13
AI

ai

SQL Server
ãƒªãƒ³ã‚¯
Connect Azure SQL Server via User Assigned Managed Identity under Django | Microsoft Community Hub
ishisaka 2024/07/24
python

SQL Server
ãƒªãƒ³ã‚¯
Migrating SQL Server workloads FAQ
ishisaka 2022/09/15
SQL Server
ãƒªãƒ³ã‚¯
SQL Server ã®å‹‰å¼·ã®ä»•æ–¹ã¨ã„ã†ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®è³‡æ–™ã‚’å…¬é–‹ã—ã¾ã—ãŸ at SE ã®é›‘è¨˜
å…ˆæ—¥ã€How to learn SQL Server ã¨ã„ã† SQL Server ã®å‹‰å¼·ã®ä»•æ–¹ã«ã¤ã„ã¦ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’æ‹…å½“ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ ãã®éš›ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³è³‡æ–™ã‚’ How to learn SQL Server ã¨ã—ã¦ PDF ã‚’å…¬é–‹ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ SQL Server ã®å‹‰å¼·ã‚’ã™ã‚‹éš›ã®å‚è€ƒã«ãªã‚Œã°å¹¸ã„ã§ã™ã€‚
ishisaka 2022/01/23
SQL Server
ãƒªãƒ³ã‚¯
Windows 11 / Windows Server 2022 ã§ NVMe ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸ OS ã®ã‚·ã‚¹ãƒ†ãƒ ãƒ‰ãƒ©ã‚¤ãƒ–ã« SQL Server ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ä»¶ã«ã¤ã„ã¦ at SE ã®é›‘è¨˜
å…ˆæ—¥å…¬é–‹ã•ã‚ŒãŸ 4 KB ã‚’è¶…ãˆã‚‹ã‚·ã‚¹ãƒ†ãƒ ãƒ‡ã‚£ã‚¹ã‚¯ ã‚»ã‚¯ã‚¿ãƒ¼ ã‚µã‚¤ã‚ºã«é–¢é€£ã™ã‚‹ã‚¨ãƒ©ãƒ¼ã®ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚° ã§è§£èª¬ãŒè¡Œã‚ã‚Œã¦ã„ã¾ã™ãŒã€Windows 11 / Windows Server 2022 ã«å¯¾ã—ã¦ SQL Server ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ã¨ã„ã†äº‹è±¡ãŒå ±å‘Šã•ã‚Œã¦ã„ã¾ã™ã€‚ SQL Serverã§ã®Windows ã§ Windows 11 / Windows Server 2022 ã§ã‚µãƒãƒ¼ãƒˆã•ã‚Œã‚‹ SQL Server ã«ã¤ã„ã¦ã¯è¨˜è¼‰ã•ã‚Œã¦ã„ã¾ã™ãŒã€å„ OS ãŒã‚µãƒãƒ¼ãƒˆã™ã‚‹ SQL Server ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã‚ˆã†ã¨ã—ãŸå ´åˆã«ã€ã‚µãƒãƒ¼ãƒˆã•ã‚Œã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®çµ„ã¿åˆã‚ã›ã§ã‚‚ç’°å¢ƒã«ã‚ˆã£ã¦ã¯ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ã‚±ãƒ¼ã‚¹ãŒã‚ã‚‹ã¨ã„ã†ã®ãŒã€ç¾åœ¨ç™ºç”Ÿã—ã¦ã„ã‚‹å•é¡Œã¨ãªã‚Šã¾ã™ã€‚ ã“ã‚Œã«ã¤ã„ã¦ã¯ Answers ã® SQL Server 2019 â€“ Wind
ishisaka 2021/12/27
SQL Server
ãƒªãƒ³ã‚¯
SQL Server ã§ Seek ã«ã‚ˆã‚ŠREAD COMMITTED ã§ 1 è¡Œå–å¾—ã™ã‚‹éš›ã«ã¯è¡Œãƒãƒƒã‚¯ãŒå¿…ãšå–å¾—ã•ã‚Œã‚‹ã¨ã„ã†ã“ã¨ã§ã¯ãªã„ã¨ã„ã†ãŠè©± at SE ã®é›‘è¨˜
SQL Server ã§ C1 ã‚’ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼åŒ–ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã—ã¦è¨å®šã•ã‚Œã¦ã„ã‚‹æ¬¡ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã‚‹ã¨ã—ã¾ã™ã€‚ SQL Server ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã® READ COMMITTED åˆ†é›¢ãƒ¬ãƒ™ãƒ«ãŒè¨å®šã•ã‚Œã¦ã„ã‚‹çŠ¶æ…‹ã«å¯¾ã—ã¦ã€æ¬¡ã®ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ãŸå ´åˆã«ã©ã®ã‚ˆã†ãªãƒãƒƒã‚¯ãŒå–å¾—ã•ã‚Œã‚‹ã®ã‹ã¨ã„ã†ã®ãŒæœ¬æŠ•ç¨¿ã®å†…å®¹ã§ã™ã€‚(SQL Server ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®å‹•ä½œã§ã‚ã‚‹ãŸã‚ã€READ COMMITTED SNAPSHOT ISOLATION (RCSI) ã¯ç„¡åŠ¹ã®çŠ¶æ…‹ã§ã™) C1 ã«å¯¾ã—ã¦ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼åŒ–ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒè¨å®šã•ã‚Œã¦ã„ã¾ã™ã®ã§ã€ã€ŒC1 = 100001ã€ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã«å¯¾ã—ã¦ã€Key Lock (è¡Œãƒãƒƒã‚¯) ãŒå–å¾—ã•ã‚Œã‚‹ã¨æ€ã†ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ã€Œå–å¾—ã•ã‚Œã¦ã„ã‚‹ãƒãƒƒã‚¯ã®çŠ¶æ…‹ã§å¤‰ã‚ã‚Šã€Key Lock ãŒå–å¾—ã•ã‚Œãªã„ã“ã¨ã‚‚ã‚ã‚‹ã€ãŒç”ãˆã¨ãªã‚Šã¾ã™ã€‚ å–å¾—ã•ã‚Œã¦ã„ã‚‹ãƒãƒƒã‚¯ã®çŠ¶æ…‹ã«ã‚ˆã£ã¦ã¯ã€ä¸Šè¨˜ã® SELECT
ishisaka 2021/09/26
SQL Server
ãƒªãƒ³ã‚¯
SQL Server 2019 on Windows ã® Language Extension ã§ .NET 5 C# ãŒå‹•ä½œã™ã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸ at SE ã®é›‘è¨˜
Open sourcing the .NET 5 C# Language Extension for SQL Server ã§ç™ºè¡¨ãŒã‚ã‚Šã¾ã—ãŸãŒã€SQL Server 2019 ã‹ã‚‰ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸ Language Extension ã§ .NET 5 C# ãŒä½¿ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ä»Šå›žã®ã‚¢ãƒŠã‚¦ãƒ³ã‚¹ã¯ã€æ¬¡ã®ã‚¢ãƒŠã‚¦ãƒ³ã‚¹ã®ç¶šãã«ã‚ãŸã‚‹ã‚‚ã®ã«ãªã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ Open sourcing the Java language extension for SQL Server Open sourcing the R and Python language extensions for SQL Server SQL Server ã§ã¯ã€ã“ã®ã‚ˆã†ãªæ©Ÿèƒ½ã‚’ä½¿ç”¨ã—ãŸãƒ‡ãƒ¼ã‚¿åˆ†æžã‚’ Advanced Analytics ã¨å‘¼ã¶ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ãŒã€æ©Ÿèƒ½ã‚’æ´»ç”¨ã™ã‚‹ã“ã¨ã§ã€æ¨™æº–ã® T-
ishisaka 2021/09/13
.NET

.NET Core

SQL Server
ãƒªãƒ³ã‚¯
SQL Database ã§ CDC ãŒãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ã§ä½¿ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã®ã§æ¤œè¨¼ã—ã¦ã¿ã¾ã—ãŸ at SE ã®é›‘è¨˜
Introducing Change Data Capture for Azure SQL Databases (Public Preview) ã§ã‚¢ãƒŠã‚¦ãƒ³ã‚¹ãŒã‚ã‚Šã¾ã—ãŸãŒã€S3 ä»¥ä¸Šã® SQL Database ã§ã¯ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼æ©Ÿèƒ½ã¨ã—ã¦ CDC (Change Data Capture : å¤‰æ›´ãƒ‡ãƒ¼ã‚¿ã‚ãƒ£ãƒ—ãƒãƒ£) ãŒä½¿ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ CDC ã«ã¤ã„ã¦çµæ§‹å¿˜ã‚Œã¦ã„ãŸã®ã§ã€ã“ã®æ©Ÿä¼šã«ã¾ã¨ã‚ã¦ãŠããŸã„ã¨æ€ã„ã¾ã™ã€‚ ã€Œå¤‰æ›´ã®è¿½è·¡ã€ã¨ã€Œå¤‰æ›´ãƒ‡ãƒ¼ã‚¿ã‚ãƒ£ãƒ—ãƒãƒ£ã€ã®é•ã„ SQL Server ã«ã¯ãƒ‡ãƒ¼ã‚¿ã®å¤‰æ›´ã¨ã‚’ãƒˆãƒ©ãƒƒã‚ãƒ³ã‚°ã™ã‚‹æ©Ÿèƒ½ã¨ã—ã¦ã€Œå¤‰æ›´ã®è¿½è·¡ã€(Change Tracking) ã¨ã€Œå¤‰æ›´ãƒ‡ãƒ¼ã‚¿ã‚ãƒ£ãƒ—ãƒãƒ£ã€(CDC)ã¨ã„ã† 2 ç¨®é¡žã®æ©Ÿèƒ½ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ å¤‰æ›´ã®è¿½è·¡ã«ã¤ã„ã¦ (SQL Server) å¤‰æ›´ãƒ‡ãƒ¼ã‚¿ ã‚ãƒ£ãƒ—ãƒãƒ£ã«ã¤ã„ã¦ (SQL Server) ã©ã¡ã‚‰ã‚‚ã€Œãƒ†ãƒ¼ãƒ–ãƒ«
ishisaka 2021/06/17
SQL Server
ãƒªãƒ³ã‚¯
å¾Œã§ç¢ºèªã™ã‚‹ç”¨ã®ç›´è¿‘ã® SQL Database å‘¨ã‚Šã®æ›´æ–° (2021/6/10 ç‰ˆ) at SE ã®é›‘è¨˜
Build 2021 å¾Œã«ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã®ç™ºè¡¨ãŒç¶šã„ã¦ã„ã‚‹ã®ã§ã€Build å‰å¾Œã§ç™ºè¡¨ã•ã‚ŒãŸå†…å®¹ã‚’å¾Œã§è¦‹ã‚‹ã‚ˆã†ã«ãƒ¡ãƒ¢ã€‚ Introducing the GREATEST and LEAST T-SQL functions ãã†ã„ãˆã°å®Ÿè¡Œãƒ—ãƒ©ãƒ³ã‚’è¦‹ã¦ã„ãªã‹ã£ãŸãªã¨ã€‚ã€‚ã€‚ Improve performance of Parquet external tables using new native techno logy in dedicated SQL pools ç¾åœ¨ã€é™å®šçš„ãª Public Preview ã§ã®æ©Ÿèƒ½å…¬é–‹ Dedicated SQL Pool ã® Parquet ã®å‘¼ã³å‡ºã—ã§ã€Serverless SQL Pool ã®ã‚ˆã†ã«ã€Hadoop (Java) ã§ã¯ãªãã€ãƒã‚¤ãƒ†ã‚£ãƒ– (C++) ã®å‘¼ã³å‡ºã—ãŒå¯èƒ½ã¨ãªã‚Šã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å‘ä¸Šã«æœŸå¾…ã§ãã¾ã™ Azure Active Dir
ishisaka 2021/06/10
SQL Server
ãƒªãƒ³ã‚¯
Build 2021 ã§ç™ºè¡¨ã•ã‚ŒãŸ Synapse Analytics ã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆ at SE ã®é›‘è¨˜
Build 2021 ã® SQL Server ãƒ™ãƒ¼ã‚¹ã®ç’°å¢ƒã®ç™ºè¡¨ã«ã¤ã„ã¦ã¯ã€Build 2021 ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§ç™ºè¡¨ã•ã‚ŒãŸ SQL Server / SQL Database ã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆ ã« Synapse ã‚‚å«ã‚ã¦æ›¸ã„ã¦ã¿ã¾ã—ãŸãŒã€Synapse å˜ä½“ã§ã‚‚ã„ãã¤ã‹ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®æ›´æ–°ãŒè¡Œã‚ã‚Œã¦ã„ã¾ã™ã®ã§ã€Synapse Analytics ã®ã¿ã§ã€ä¸€åº¦ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã®å†…å®¹ã‚’æŠŠæ¡ã—ã¦ãŠããŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã®å†…å®¹ Synapse ã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã«ã¤ã„ã¦ã¯ã€æ¬¡ã®ã‚ˆã†ãªå†…å®¹ãŒç™ºè¡¨ã•ã‚Œã¾ã—ãŸã€‚ Spark 3.0 ã®ã‚µãƒãƒ¼ãƒˆ ã‚¢ãƒŠã‚¦ãƒ³ã‚¹ Apache Spark 3.0 support in Azure Synapse Analytics Synapse ã® Spark Pool ã§ Spark 3.0 ã®ãƒ©ãƒ³ã‚¿ã‚¤ãƒ ãŒãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ã¨ã—ã¦åˆ©ç”¨å¯èƒ½ã«ãªã‚Šã¾ã—ãŸã€‚ æœ€çµ‚çš„ãª GA ã®ã‚¿ã‚¤ãƒŸ
ishisaka 2021/05/31
SQL Server
ãƒªãƒ³ã‚¯
SQL Database ã«è¿½åŠ ã•ã‚ŒãŸ Ledger ã‚’å¦ç¿’ã™ã‚‹ â€“ æ¦‚è¦ â€“ at SE ã®é›‘è¨˜
Build 2021 ã§ SQL Database ã®æ–°æ©Ÿèƒ½ã¨ã—ã¦ Ledger (å°å¸³) ãŒãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼æ©Ÿèƒ½ã¨ã—ã¦ç™ºè¡¨ã•ã‚Œã¾ã—ãŸã€‚ Announcing Azure SQL Database ledger Ledger ã®åˆå‡ºã¯ PASS Summit 2020 ã® Day2 Keynote ã«ãªã‚‹ã®ã§ã¯ã¨æ€ã„ã¾ã™ãŒã€å®Ÿæ©Ÿã§ã“ã®æ©Ÿèƒ½ã‚’æ¤œè¨¼ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã®ã§ã€è©¦ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ å…¬å¼ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯æ¬¡ã®å†…å®¹ã¨ãªã‚‹ã‹ã¨ã€‚ Azure SQL Database ledger documentation Quickstart: Create an Azure SQL Database with ledger enabled æœ€çµ‚çš„ã«ã¯ã™ã¹ã¦ã®åœ°åŸŸã§ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼æ©Ÿèƒ½ãŒåˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã§ã™ãŒã€æŠ•ç¨¿ã‚’æ›¸ã„ã¦ã„ã‚‹æ™‚ç‚¹ã§ã¯ã€Œç±³å›½ä¸è¥¿éƒ¨ã€ã®è«–ç†ã‚µãƒ¼ãƒãƒ¼ã§ã®ã¿åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚(SLO
ishisaka 2021/05/26
SQL Server

SQL Azure
ãƒªãƒ³ã‚¯
2021/4 ã® SQL Server / SQL Database é–¢é€£ã®æ›´æ–°æƒ…å ± at SE ã®é›‘è¨˜
2021/4/6 Public preview: Azure Monitor container insights support for Azure Arc enabled Kubernetes extension model Azure Monitor Container Insights for Azure Arc enabled Kubernetes clusters Azure Monitor ã®ã‚³ãƒ³ãƒ†ãƒŠãƒ¼ã‚¤ãƒ³ã‚µã‚¤ãƒˆãŒã€Azure Arc enabled Kubernetes ã«ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ã§å¯¾å¿œã—ã¾ã—ãŸã€‚ Azure Arc enabled data servies ã‚’å‹•ä½œã•ã›ã‚‹ç‚ºã«ã¯ k8s ãŒå¿…è¦ã¨ãªã‚Šã¾ã™ã®ã§ã€å®Ÿè¡ŒåŸºç›¤ã® k8s ã®ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ã«ã¤ã„ã¦ã‚‚é–¢é€£æƒ…å ±ã¨ã—ã¦æ„è˜ã—ã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã™ã‚ˆãã€‚ 2021/4/7 Azure SQL News Update: April
ishisaka 2021/04/30
SQL Server
ãƒªãƒ³ã‚¯
Database Migration Assistant (DMA) ã§ SQL Server ã‹ã‚‰ SQL Database ã¸ã®ãƒ‡ãƒ¼ã‚¿ç§»è¡Œæ–¹æ³•ã«ã¤ã„ã¦ at SE ã®é›‘è¨˜
SQL Server ã‹ã‚‰ SQL Server ãƒ™ãƒ¼ã‚¹ã®ç’°å¢ƒã¸ã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã«ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ãƒ„ãƒ¼ãƒ«ã¨ã—ã¦ã€Database Migration Assistant (DMA) ã¨ã„ã†ç„¡å„Ÿã®ãƒ„ãƒ¼ãƒ«ãŒæä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®ãƒ„ãƒ¼ãƒ«ã§ã¯ã€SQL Server ã‹ã‚‰ SQL Database ã¸ã®ã‚¹ã‚ãƒ¼ãƒžç§»è¡Œ / ãƒ‡ãƒ¼ã‚¿ç§»è¡Œã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ãŠã‚Šã€SQL Server ã®ç’°å¢ƒã‚’ SQL Database ã«ç§»è¡Œã™ã‚‹éš›ã«åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã®ãƒ„ãƒ¼ãƒ«ã®ä¸ã§ã€SQL Database ã«ãƒ‡ãƒ¼ã‚¿ã‚’ç§»è¡Œã™ã‚‹éš›ã«ã¯ã€ã©ã®ã‚ˆã†ãªæ–¹æ³•ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã®ã‹ãŒç†è§£ã§ãã‚‹ã¨ã€SQL Server ãƒ™ãƒ¼ã‚¹ã®ç’°å¢ƒã®ç§»è¡Œã«æ´»ç”¨ã§ãã‚‹ã®ã§ã¯ã¨æ€ã„ã€ãƒ‡ãƒ¼ã‚¿ç§»è¡Œæ–¹æ³•ã‚’èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ SQL Server ã‹ã‚‰ SQL Database ã¸ã®ãƒ‡ãƒ¼ã‚¿ç§»è¡Œ ãƒ„ãƒ¼ãƒ«ã®åˆ©ç”¨æ–¹æ³•è‡ªä½“ã¯ã€ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«è¨˜è¼‰ã•ã‚Œã¦ã„ã¾ã™ã®ã§å‰²æ„›ã—
ishisaka 2021/04/20
SQL Server
ãƒªãƒ³ã‚¯
Azure ã§ SQL Server ãƒ™ãƒ¼ã‚¹ã®ç’°å¢ƒã®æ´»ç”¨æ–¹æ³•ã‚’å¦ã¶ãŸã‚ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ at SE ã®é›‘è¨˜
Azure ã®å„æ©Ÿèƒ½ã‚’å¦ç¿’ã™ã‚‹å ´åˆã¯ã€å„æ©Ÿèƒ½ (ã‚µãƒ¼ãƒ“ã‚¹) ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ç¢ºèªã™ã‚‹ã“ã¨ã§å¦ç¿’ãŒã§ãã¾ã™ã€‚ Azure ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ : å„ã‚µãƒ¼ãƒ“ã‚¹ / æ©Ÿèƒ½ æœ€è¿‘ã§ã™ã¨ Microsoft Learn ã‚’æ´»ç”¨ã—ã¦æ©Ÿèƒ½ã‚’å¦ç¿’ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ãã€‚ Microsoft Learn ä¸Šã§ã¯ã€SQL Server ã«ã¤ã„ã¦ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ ã‚‚å…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã—ã‹ã—ã€æ©Ÿèƒ½ã‚’æ´»ç”¨ã™ã‚‹ãŸã‚ã®ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã—ã¦å¦ç¿’ã‚’è¡Œã†å ´åˆã«ã¯ã€å„æ©Ÿèƒ½ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ / Microsoft Learn ã®æƒ…å ±ã§ã¯è¶³ã‚Šãªããªã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã‹ã¨ã€‚ ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã—ã¦å¦ç¿’ã™ã‚‹éš›ã«ã¯ã€ã©ã®ã‚ˆã†ãªãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ç¢ºèªã™ã‚Œã°ã‚ˆã„ã‹ã‚’ã¾ã¨ã‚ã¦ãŠããŸã„ã¨æ€ã„ã¾ã™ã€‚ SQL Server ãƒ™ãƒ¼ã‚¹ã®ç’°å¢ƒã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ SQL Server ãƒ™ãƒ¼ã‚¹ã®ç’°å¢ƒã®æ©Ÿèƒ½ã®æœ€æ–°æƒ…å ±ã«ã¤ã„ã¦ã¯ã€ã©ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’è¦‹ã‚‹ã¨è‰¯ã„ã®ã‹ã«ã¤ã„ã¦ã‚‚ã¾ã¨ã‚ã¦ãŠã“ã†ã‹
ishisaka 2021/04/13
SQL Server
ãƒªãƒ³ã‚¯
SQL Database ã§åŒ…æ‹¬çš„ãªãƒ‘ãƒ¼ãƒŸãƒƒã‚·ãƒ§ãƒ³ã«ã‚ˆã‚‹å‹•çš„ãƒ‡ãƒ¼ã‚¿ãƒžã‚¹ã‚ãƒ³ã‚°ãŒå¯èƒ½ã¨ãªã‚Šã¾ã—ãŸ at SE ã®é›‘è¨˜
æ¬¡ã®ã‚¢ãƒŠã‚¦ãƒ³ã‚¹ã§æƒ…å ±ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ãŒã€SQL Database ã¨ Synapse Analytics ã§åŒ…æ‹¬çš„ãªãƒ‘ãƒ¼ãƒŸãƒƒã‚·ãƒ§ãƒ³ã«ã‚ˆã‚‹å‹•çš„ãƒ‡ãƒ¼ã‚¿ãƒžã‚¹ã‚ãƒ³ã‚° (Genular Permissions for Dynamid Data Masking) ãŒå¯èƒ½ã¨ãªã‚Šã¾ã—ãŸã€‚ General availability: Dynamic data masking granular permissions for Azure SQL and Azure Synapse Analytics Granular Permissions for Azure SQL Dynamic Data Masking å‹•çš„ãƒ‡ãƒ¼ã‚¿ãƒžã‚¹ã‚ãƒ³ã‚° (å‹•çš„ãƒ‡ãƒ¼ã‚¿ãƒžã‚¹ã‚¯) ã®åŸºæœ¬çš„ãªä½¿ç”¨ã«ã¤ã„ã¦ã¯æ¬¡ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‹ã‚‰ç¢ºèªã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ å‹•çš„ãªãƒ‡ãƒ¼ã‚¿ ãƒžã‚¹ã‚ãƒ³ã‚° (SQL Server å‘ã‘ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ) å‹•çš„ãƒ‡ãƒ¼ã‚¿ ãƒžã‚¹
ishisaka 2021/04/07
SQL Server
ãƒªãƒ³ã‚¯
SQL Server ã§ PLEASE ã‚’å®Ÿè£…ã—ã¦ã¿ã‚‹ at SE ã®é›‘è¨˜
æ™‚ä»£ã«å³ã—ãŸMySQï¾šã®æ–°æ©Ÿèƒ½ï¼šPLEASEå¥ ãŒé¢ç™½ãã†ã ã£ãŸã®ã§ã€SQL Server ã§å®Ÿè£…ã—ã¦ã¿ã¾ã—ãŸã€‚ æ§‹æˆã¨ã—ã¦ã¯æ¬¡ã®ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ SQL Server å´ã«é€šå¸¸ã®æ–¹æ³•ã§å®Ÿè¡Œã•ã‚ŒãŸã‚¯ã‚¨ãƒªã‚’è‡ªå‹•çš„ã«æ›¸ãæ›ãˆã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’å…¥ã‚Œè¾¼ã‚€æ–¹æ³•ãŒã±ã£ã¨æ€ã„ã¤ã‹ãªã‹ã£ãŸã®ã§ã€ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¨ã€SQL Server ã®é–“ã« TDS (Tabular Data Stream) ã® Proxy ã‚’æŒŸã‚“ã§ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰å®Ÿè¡Œã•ã‚ŒãŸã‚¯ã‚¨ãƒªã‚’å¼·åˆ¶çš„ã«æ›¸ãæ›ãˆã¦ã€SQL Server ã«æµã™ã¨ã„ã†æ–¹å¼ã«ã—ã¦ã¿ã¾ã—ãŸã€‚ TDS Proxy ã«å¯¾ã—ã¦æ¬¡ã®ã‚ˆã†ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã¦ã¿ã¾ã™ã€‚ $con = New-Object System.Data.SqlClient.SqlConnection($env:CONSTRING) $con.Open() $sw = [System.D
ishisaka 2021/04/02
SQL Server
ãƒªãƒ³ã‚¯
SQL Server / SQL Database ã®è¡Œã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã®åŸºæœ¬å‹•ä½œ at SE ã®é›‘è¨˜
SQL Server / Azure SQL Database ã§ã¯ã€è¡Œã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç† (RLV : Row Level Versioning) ã¨å‘¼ã°ã‚Œã‚‹æ©Ÿèƒ½ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ é€šå¸¸ã€ãƒ‡ãƒ¼ã‚¿ã®ã‚¢ã‚¯ã‚»ã‚¹æ™‚ã«ã¯ãƒãƒƒã‚¯ãŒå–å¾—ã•ã‚Œã€ç‰¹å®šã®ã‚¢ã‚¯ã‚»ã‚¹ãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã¯ã€æ¤œç´¢ã«ã¤ã„ã¦ã‚‚åŒæ™‚å®Ÿè¡Œæ€§ã®ä½Žä¸‹ã«ã¤ãªãŒã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ SQL Server ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®è¨å®šã§ã¯ã€æ¤œç´¢æ™‚ã«ã‚‚ãƒãƒƒã‚¯ãŒå–å¾—ã•ã‚Œã€æ›´æ–°ç³»ã®å‡¦ç†ãŒå®Ÿè¡Œã•ã‚Œã¦ã„ã‚‹å ´åˆã¯ã€ãƒãƒƒã‚¯ç«¶åˆã«ã‚ˆã‚Šã€æ¤œç´¢ãŒãƒ–ãƒãƒƒã‚¯ã•ã‚Œã‚‹å‹•ä½œãŒè¡Œã‚ã‚Œã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®ã‚ˆã†ãªæ¤œç´¢æ™‚ã®åŒæ™‚å®Ÿè¡Œæ€§ã®ä½Žä¸‹ã‚’æŠ‘ãˆã‚‹ãŸã‚ã€SQL Server ã§ã¯è¡Œã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã¨ã„ã†æ©Ÿèƒ½ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã‚Œã¯ã€MVCC (MultiVersion Concurrency Control) ã«ã‚ˆã‚Šã€èªã¿å–ã‚Šæ™‚ã«ã¯ãƒãƒƒã‚¯ã‚’å–å¾—ã—ãªã„ã‚ˆã†ã«ã™ã‚‹ã“ã¨ã§ã€èªã¿è¾¼ã¿ã¨æ›¸ãè¾¼ã¿ãŒåŒ
ishisaka 2021/03/24
SQL Server
ãƒªãƒ³ã‚¯
2021/3 ã® SQL Server / SQL Database é–¢é€£ã®æ›´æ–°æƒ…å ± at SE ã®é›‘è¨˜
2021/3 ã®æ›´æ–°ã§ã™ã€‚ Ignite 2021 é–¢é€£ã®ç™ºè¡¨ãŒå¤šã„ã§ã™ãã€‚ æƒ…å ±ã‚’æŠŠæ¡ã™ã‚‹ãŸã‚ã«æœ¬æ—¥ã€ä¸€åº¦æŠ•ç¨¿ã—ã¾ã—ãŸãŒã€æœˆæœ«ã«ã‚‚å†åº¦æ›´æ–°ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ 2021/3/2 (Ignite 2021 é–¢é€£) ã“ã¡ã‚‰ã¯ã€Ignite 2021 ã§ç™ºè¡¨ãŒã‚ã£ãŸå†…å®¹ã¨ãªã‚Šã€Ignite 2021 ã®å†…å®¹ã«ã¤ã„ã¦ã¯ã€Ignite 2021 ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§ç™ºè¡¨ã•ã‚ŒãŸ SQL Server / SQL Database ã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆ ã§è¨˜è¼‰ã—ã¦ã„ãŸã®ã§ã€æœ¬æŠ•ç¨¿ã§ã¯é–¢é€£ã™ã‚‹ URL ã®ã¿ã‚’è¨˜è¼‰ã—ã¦ãŠãã¾ã™ã€‚ Azure Disk On-demand disk bursting for Premium SSDs now in public preview ãƒžãƒãƒ¼ã‚¸ãƒ‰ ãƒ‡ã‚£ã‚¹ã‚¯ã®ãƒãƒ¼ã‚¹ãƒˆ Public preview: Automatic key rotation of customer-manage
ishisaka 2021/03/24
SQL Server
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 8 9 10 æ¬¡ã®ãƒšãƒ¼ã‚¸