SQL Azureは、 SQL Serverをベースに開発されました。しかし、 バックアップ周りはSQL Serverと異なる点が多く、 SQL Serverのバックアップ設計ノウハウを活用することができません。 SQL Serverでは、 フルバックアップ、 差分バックアップ、 トランザクションログ ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

On August 30, Microsoft announced the public preview of the Azure Database Migration Service (DMS) to support online migrations of various databases to Azure. What’s an “online migration”? Online ...

Microsoft Azure SQL Database is an excellent Database-as-a-Service (DBaaS) solution for developers, business analysts, and database administrators given its ease of use and exemplary controls.

In the second part of this series, Joey describes the methods that Microsoft uses to manage code rollouts, and how it detects hardware and software problems on Azure SQL. In Part 1 of this series, you ...

Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works. Database ...

SQL Server 2022: Here’s what you need to know Your email has been sent Three decades on, SQL Server is still a database workhorse that powers both an internal line ...