Sites Microsoft


Auditing in Azure SQL Database

Publié le 23 mars 2019 sur Azure SQL Database
 

First published on MSDN on Aug 05, 2014 I’m very excited to share the hard work some of my peers have been doing – Auditing in Azure SQL Database. After focusing on a bunch of behind the scenes security improvements, it’s good to get something customer …

Azure Trust Services

Publié le 23 mars 2019 sur Azure SQL Database
 

First published on MSDN on Feb 17, 2012 Microsoft is working on a new Windows Azure service through SQL Azure Labs , called Trust Services. It is an application-level encryption framework that can be used to protect sensitive data stored on the Windows …

Cumulative Update #6 for SQL Server 2016 SP2

Publié le 20 mars 2019 sur microsoft sql server release services
 

The 6th cumulative update release for SQL Server 2016 SP2 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing mo …

Cumulative Update #14 for SQL Server 2016 SP1

Publié le 20 mars 2019 sur microsoft sql server release services
 

The 14th cumulative update release for SQL Server 2016 SP1 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing m …

The March release of Azure Data Studio is now available

Publié le 18 mars 2019 sur sql server team blog
 

Were excited to announce the March release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studioand review the Release notes to get started. Please note: If youre currently using the preview version …

Enterprise-scale Backup for SQL Server Databases

Publié le 18 mars 2019 sur sql server team blog
 

More and more organizations are moving to the cloud to leverage the key benefits of agility and reduce overall cost. Its likely that at some point in time, your SQL Server will manifest as either of the three implementations in Azure: SQL Azure Databas …

Identify log write limits on Azure SQL Managed Instance using QPI library

Publié le 11 mars 2019 sur Microsoft SQL Server database engine blog
 

Azure SQL Managed Instance is fully managed SQL Server instance hosted in Azure cloud. Managed Instance introduces some limits such as max log write throughput that can slow down your workload. In this post you will see how to identify write log throug …

Running Azure CosmosDB queries from SQL Server using ODBC driver

Publié le 11 mars 2019 sur Microsoft SQL Server database engine blog
 

Azure CosmosDB provides ODBC driver that enables you to query CosmosDB collections like classic databases. In this post you will see how to query CosmosDB collections from Sql Server using Transact-Sql. Why querying CosmosDB from SQL Server? Cosmos DB …

Monitor local storage usage on General Purpose Azure SQL Managed Instance

Publié le 8 mars 2019 sur Microsoft SQL Server database engine blog
 

Azure SQL Managed Instance has predefined storage space that depends on the values of reserved storage and vCores that you choose when you provision the instance. In this post you will see how to monitor storage space on the Managed Instance. In Manage …

Free cloud data services training roundup

Publié le 7 mars 2019 sur sql server team blog
 

To help you stay up to date on online training opportunities, were releasing a monthly list of the latest free data and artificial intelligence (AI) trainings in one convenient post. SQL Server and Windows Server 2008 end of support End of support is c …

Sending resource alerts on Managed Instance using db_mail

Publié le 6 mars 2019 sur Microsoft SQL Server database engine blog
 

One of the biggest issue that you might experience in Managed Instance is reaching storage limit or finding out that you don’t have enough CPU. In this case you would need to get the bigger instance; however, this is not instant operation. In thi …

Analyzing wait statistics on Managed Instance

Publié le 5 mars 2019 sur Microsoft SQL Server database engine blog
 

Wait statistics are information that might help you understand why the query duration is long and identify the queries that are waiting for something in database engine. In this post, I will show to you how to identify why the workload is waiting and w …

Reduced recompilations for workloads using temporary tables across multiple scopes

Publié le 4 mars 2019 sur Microsoft SQL Server database engine blog
 

SQL Server 2019 introduces several performance optimizations which will improve performance with minimal changes required to your application code.   In this blog post we’ll discuss one such improvement available in CTP 2.3: reduced rec …

Measuring file io performance on Managed Instance using QPI

Publié le 4 mars 2019 sur Microsoft SQL Server database engine blog
 

Checking file performance and comparing performance characteristics between SQL Server database engines in Azure cloud and your on-premises environment might be tricky and require some better knowledge of DM objects. In this post, you will see how to u …


Pages :