Sites Microsoft


Import and analyze IIS Log files using SQL Server

Publié le 10 février 2017 sur Microsoft SQL Server database engine blog
 

IIS generates logs where are recorded many information about HTTP requests such as what Url was called, when the request happened, what is the origin, etc. If you want to analyze information from log files you can use use text search, regular expr …

Extreme 25x compression of JSON data using CLUSTERED COLUMNSTORE INDEXES

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

CLUSTERED COLUMNSTORE INDEXES (CCI) provide extreme data compression. In Azure SQL Database and SQL Server vNext you can create CCI on tables with NVARCHAR(MAX) columns. Since JSON is stored as NVARCHAR type, now you can store huge volumes of JSON data …

Exporting tables from SQL Server in json line-delimited format using BCP.exe

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

Line-delimited JSON is one common format used to exchange data between systems and for streaming JSON data. SQL Server can be used to export content of tables into line-delimited JSON format. Line-delimited JSON is a variation of JSON format where …

ODBC Driver 13.1 for Linux Released

Publié le 8 février 2017 sur sql server team blog
 

This post is authored by Meet Bhagdev, Program Manager, Microsoft Hi all. We are delighted to share the Production Ready Release of the Microsoft ODBC Driver 13.1 for Linux (Ubuntu, RedHat and SUSE). The new driver enables access to SQL Server, Azure S …

January 2017 Leaderboard of Database Systems contributors on MSDN

Publié le 8 février 2017 sur sql server team blog
 

This post was authored by Rahul Venkatraj, Program Manager, Data Platform Group


Pages :