Sort by:

ASP.NET Session State with SQL Server In-Memory OLTP

by Perry Skountrianos - MSFT // 5 Comments

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 Microsoft ASP.NET’s session state module and session state data sources: InProcSessionStateStore, which stores session state… Read more

JSON vs CLR UDT – performance comparison

by Jovan Popovic (MSFT) // 0 Comments

Ability to create custom user defined types in CLR and use them in SQL Server is introduced in SQL Server 2005. In SQL Server 2016 is added JSON support that might be alternative for storing complex objects. Since JSON is stored as NVARCHAR and CLR is a type, it is questionable what would be better… Read more

In-Memory OLTP Indexes – Part 2: Performance Troubleshooting Guide.

by kunalkaroth // 2 Comments

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 recommendations on how to best choose and configure an index for your memory-optimized table. At… Read more

JSON parsing is faster than Spatial equivalent

by Jovan Popovic (MSFT) // 0 Comments

One of the most common assumption when people talk about JSON in SQL Server is that it is slow because it is placed in “plain text” and there is no native type. Instead of the assumption it is better to experiment and compare performance of JSON with some real native type. In this post, I… Read more

JSON parsing 10x faster than XML parsing

by Jovan Popovic (MSFT) // 6 Comments

Usually, when people talk about the performance of JSON in SQL Server, they are starting with “JSON is not actually a native type, it is just a plain text” and imply that it is probably too slow. It is true that JSON is stored as NVARCHAR and that there is no special type like for… Read more

Azure SQL Database: Ingesting 1.4 million sustained rows per second with In-Memory OLTP & Columnstore Index

by Perry Skountrianos - MSFT // 7 Comments

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. The challenge is to ingest and analyze this data at the speed at which it… Read more

In-Memory OLTP Indexes – Part 1: Recommendations.

by kunalkaroth // 5 Comments

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 of Things – IoT), high volume data load and transformation (Extract Transform Load – ETL)… Read more

In-Memory OLTP Updated Overview and Case Studies

by Jos de Bruijn [MSFT] // 0 Comments

We just published updated slide decks about In-Memory OLTP. In-Memory OLTP overview: this is an overview of the technology and details what’s new in SQL Server 2016/2017 and Azure SQL Database In-Memory OLTP case studies: this discusses when you and do not want to use In-Memory OLTP, as well as a number of application patterns… Read more

Sentiment analysis with Python in SQL Server Machine Learning Services

by Nellie Gustafsson // 2 Comments

One very popular machine learning scenario is text analysis. In this blog post, we will show you two different ways in which you can implement sentiment analysis in SQL Server using Python and Machine Learning Services. This means analyzing text to determine the sentiment of text as positive or negative. (If you don’t know what… Read more