Sites Microsoft


Released: Microsoft Kerberos Configuration Manager for SQL Server 4.0

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

We are pleased to announce the latest generally-available (GA) of Microsoft Kerberos Configuration Manager for SQL Server. Get it here: Download Microsoft Kerberos Configuration Manager for SQL Server Why Kerberos? Kerberos authentication provides a hi …

SQL Server 2017: A proven leader in database performance

Publié le 16 novembre 2017 sur sql server team blog
 

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 …

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 …


Pages :