Identify log write limits on Azure SQL Managed Instance using QPI library
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
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
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
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
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
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
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
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 …
We are moving!
This blog is in the process of being migrated to one of the new consolidated SQL Server and Azure SQL Database blogs on the Microsoft TechCommunity website. Once the migration is complete, we will post the new URL along with instructions for how to nav …
Three reasons to choose Microsoft for your hybrid data platform
Companies today are faced with the trade-off of the security of having an on-premises solution and the convenience of moving their data to the cloud. With Microsoft, companies no longer have to make the choice. SQL Server and Azure SQL Database provide …
SQL Server Management Studio 18.0 Public Preview 7 Released
After a brief gap since releasing SQL Server Public Preview 6, and having survived through the February 2019 Snowcalypse in Seattle, Im happy to share that everyone in the SQL Tools team has made it out alive. I am also very excited to announce the Pub …
SQL Server 2019 community technology preview 2.3 is now available
At the SQL bits keynote today, we announced the release of SQL Server 2019 community technology preview 2.3, the fourth in a monthly cadency of preview releases. Previewed in September 2018, SQL Server 2019 is the first release of SQL Server to closely …
Join us at SQL Bits 2019 February 27-March 2 in Manchester, UK!
Data never rests, nor does the data platform. It keeps evolving as more organizations turn to data driven insights to stay ahead and prepare for the future. Be a part of the largest SQL Server professional gathering in Europe at SQL Bits 2019. At SQL B …
Cumulative Update #2 for SQL Server 2014 SP3
The 2nd cumulative update release for SQL Server 2014 SP3 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 …