Monitoring performance of natively compiled stored procedures – database-scoped configuration options
We just added new database-scoped configuration options that will help with monitoring performance of natively compiled stored procedures. The new options XTP_PROCEDURE_EXECUTION_STATISTICS and XTP_QUERY_EXECUTION_STATISTICS are available now in Azure SQL Database, and will be available in the next major release ... continue reading
Modernize index maintenance with Resumable Online Index Rebuild
As we know, the index is one of the most powerful tools for optimizing database performance. As you insert, update, and delete rows, indexes become more fragmented and less effective. Because of this, DBAs regularly do index rebuild operations. With ... continue reading
Last week in Azure: Living the serverless life, Kubernetes, and more
Several of the items highlighted below focus on serverless solutions where you don’t need to provision and manage any servers so that you can take your mind off implementing infrastructure. Building a serverless application on Azure using services like Azure ... continue reading

SQL Server 2017 on Linux webcast series
The world’s leading database is now available on Linux by bringing Microsoft SQL Server to Linux, Microsoft continues to embrace open source solutions. SQL Server 2017 brings the best features of the Microsoft relational database engine to the enterprise Linux ... continue reading

ASP.NET Session State with SQL Server In-Memory OLTP
ASP.NET session state enables you to store and retrieve values for a user as the user navigates the different ASP.NET pages that make up a Web application. Currently, ASP.NET ships with three session state providers that provide the interface between ... continue reading
SQL Server 2017: A proven leader in database performance
This post was authored by Bob Ward, Principal Architect, and Jamie Reding, Senior Program Manager and Performance Architect, Microsoft Database Systems Group. SQL Server continues to be a proven leader in database performance for both analytic and OLTP workloads. SQL ... continue reading

In-Memory OLTP Indexes – Part 2: Performance Troubleshooting Guide.
Introduction In the previous blog post In-Memory OLTP Indexes – Part 1: Recommendations, we gave you an update on the latest features of In-Memory OLTP technology. We also summarized the key characteristics of memory-optimized indexes and shared some guidelines and ... continue reading

Azure SQL Database: Ingesting 1.4 million sustained rows per second with In-Memory OLTP & Columnstore Index
As Internet of Things (IoT) devices and sensors are becoming more ubiquitous in consumer, business and industrial landscapes, they introduce a unique challenge in terms of the volume of data they produce, and the velocity with which they produce it ... continue reading

In-Memory OLTP Indexes – Part 1: Recommendations.
In-Memory OLTP Indexes In-Memory OLTP technology, available in Azure SQL Database and SQL Server, can significantly help you in improving the performance of applications that require high throughput and low latency online transaction processing, high volume concurrent data ingestion (Internet ... continue reading
- Configuring Ansible to Manage Windows Servers – Step by Step
- Monitor Storage Spaces Direct Pool Capacity with PowerShell
- Configure Storage Spaces Direct on a Virtual Lab – Step by Step
- How to Build Windows Storage Spaces Direct on a Virtual Lab
- Ultimate Performance for Database Storage with Windows Server 2016 and Hyper-converged Infrastructure
Highly Scalable Storage

Easily integrate enterprise class storage into your datacenter within minutes.
View Solution