Select Page

Loading files from Azure Blob Storage into Azure SQL Database

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 ... continue reading

Parsing 4GB JSON with SQL Server

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 ... continue reading

Import and analyze IIS Log files using SQL Server

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 ... continue reading

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

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 ... continue reading