Sunday, March 26, 2017
Updates from Storage Engine Team @ Microsoft
Facebook Twitter LinkedIn Google+ Addthis

Get Aggregated RSS

SQL Server Replication enhancement in SQL Server 2016

Wednesday, March 22, 2017

Replication is a widely-adopted feature in SQL Server to copy and distribute data and database objects from one database to another and then synchronizing between databases to maintain consistency. In SQL Server 2016, we did some enhancement in replication features and made it easier to use and work better with other SQL Server features and... Read more

Comparing performance of data access libraries using StackExchange/Dapper benchmark

Tuesday, March 14, 2017

One of the most important questions that you need to answer in your projects is what data access library you should use to access your data in SQL Server database. One of the benchmarks that you can use is StackExchange Dapper benchmark that checks how fast could different data access libraries fetch a single row from... Read more

Loading files from Azure Blob Storage into Azure SQL Database

Thursday, February 23, 2017

Azure SQL Database enables you to directly load files stored on Azure Blob Storage using the BULK INSERT T-SQL command and OPENROWSET function. Loading content of files form Azure Blob Storage account into a table in SQL Database is now single command: BULK INSERT Product FROM 'data/product.dat' WITH ( DATA_SOURCE = 'MyAzureBlobStorageAccount');   BULK INSERT is... Read more

SQL Server 2016 Developer Edition in Windows Containers

Tuesday, February 21, 2017

We are excited to announce the public availability of SQL Server 2016 SP1 Developer Edition in Windows Containers! The image is now available on Docker Hub and the build scripts are hosted on our GitHub repository. This image can be used in both Windows Server Containers as well as Hyper-V Containers. SQL Server 2016 Developer... Read more

Parsing 4GB JSON with SQL Server

Tuesday, February 14, 2017

SQL Server 2016 and Azure SQL Database enable you to parse JSON text and transform it into tabular format. In this post, you might see that JSON functions can handle very large JSON text – up to 4GB. First, I would need very large JSON document. I’m using TPCH database so I will export the... Read more

Import and analyze IIS Log files using SQL Server

Friday, February 10, 2017

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 expressions, or some log analysis tools; however, this might be tedious job. SQL Server... Read more

Extreme 25x compression of JSON data using CLUSTERED COLUMNSTORE INDEXES

Thursday, February 09, 2017

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 in tables with CCI. In this post, I will show you how you can get... Read more

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

Thursday, February 09, 2017

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 all JSON objects are stored in single line delimited with new-line characters, e.g.: {"ProductID":15,"Name":"Adjustable Race","Price":75.9900,"Quantity":50} {"ProductID":16,"Name":"Bearing... Read more

JSON data in clustered column store indexes

Thursday, February 09, 2017

Clustered column store indexes (CCI) in SQL Server vNext and Azure SQL Database support LOB types like NVARCHAR(MAX), which allows you to store string with any size, including JSON documents with any size. With CCI you can get 3x compression and query speedup compared to regular tables without any application or query rewrites. In this... Read more

Columnstore Index Performance: SQL Server 2016 – Multiple Aggregates

Wednesday, January 11, 2017

SQL product team has made significant improvements in columnstore index functionality, supportability and performance during SQL Server 2016 based on the feedback from customers. This blog series focuses on the performance improvements done as part of SQL Server 2016. Customers will get these benefits automatically with no changes to the application when they upgrade the application... Read more

Copyright [2014] by SQLCOMMUNITY.COM