Sites Microsoft


New GitHub location for AdventureWorks

Publié le 16 novembre 2017 sur microsoft sql server release services
 

AdventureWorks has long been one of the most used database samples to run demos. Its downloads and scripts are now available in the SQL Server Samples repository in GitHub. If you have the download links in any of your scripts or automations, please up …

Announcing SQL Operations Studio for preview

Publié le 15 novembre 2017 sur sql server team blog
 

We are excited to announce that SQL Operations Studio is now available in preview. SQL Operations Studio is a free, light-weight tool for modern database development and operations for SQL Server on Windows, Linux and Docker, Azure SQL Database and Azu …

SQL Server 2017 Features Bring ‘Choice’ to Developers

Publié le 15 novembre 2017 sur sql server team blog
 

Data is everywhere today: in the cloud, on premises, and everywhere in between, tied up in systems of nearly endless complexity. Microsoft solutions allow developers to innovate while also scaling and growing their data infrastructure. In SQL Server 20 …

Released: SQL Server 2017+ and Replication Management Packs (7.0.0.0)

Publié le 15 novembre 2017 sur microsoft sql server release services
 

We are happy to announce the final release of SQL Server 2017+ and Replication Management Packs! These MPs can be used to monitor SQL Server 2017 on both Windows and Linux and SQL Server 2017 Replication on Windows. Below, let’s look at some …

JSON vs CLR UDT – performance comparison

Publié le 15 novembre 2017 sur Microsoft SQL Server database engine blog
 

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 …

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

Publié le 14 novembre 2017 sur Microsoft SQL Server database engine blog
 

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 …

Released: System Center Management Pack for SQL Server (7.0.0.0)

Publié le 14 novembre 2017 sur microsoft sql server release services
 

We are happy to announce that updates to SQL Server Management Packs have been released! Downloads available: Microsoft System Center Management Pack for SQL Server 2016 Microsoft System Center Management Pack for SQL Server 2014 Microsoft System …

JSON parsing is faster than Spatial equivalent

Publié le 14 novembre 2017 sur Microsoft SQL Server database engine blog
 

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 parsing 10x faster than XML parsing

Publié le 13 novembre 2017 sur Microsoft SQL Server database engine blog
 

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 a …

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

Publié le 9 novembre 2017 sur Microsoft SQL Server database engine blog
 

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. Th …

Changes to hashing algorithm for self-signed certificate in SQL Server 2017

Publié le 8 novembre 2017 sur css sql server engineers
 

Starting with SQL Server 2005, a self-signed certificate is created automatically during the startup to be used for channel encryption. By default, credentials in the login packet that are transmitted when a client application connects to SQL Server ar …

Three years in a row – Microsoft is a leader in the ODBMS Magic Quadrant

Publié le 3 novembre 2017 sur sql server team blog
 

We’re happy to report that Gartner has positioned Microsoft in the Leaders Quadrant in the 2017 Magic Quadrant for Operational Database Management Systems again this year. This is the third year that Microsoft has been positioned farthest in …

In-Memory OLTP Indexes – Part 1: Recommendations.

Publié le 2 novembre 2017 sur Microsoft SQL Server database engine blog
 

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 v …

In-Memory OLTP Updated Overview and Case Studies

Publié le 2 novembre 2017 sur Microsoft SQL Server database engine blog
 

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 …


Pages :