Select Page
SuperServer 2028U-TRT+

Ultimate Performance for Database Storage with Windows Server 2016 and Hyper-converged Infrastructure

High-performing all flash array storage solution using Storage Spaces Direct on Windows Server 2016continue reading

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. WITH (DATA_SOURCE = 'MyAzureBlobStorageAccount'); BULK INSERT is existing command in T-SQL language that enables you to load files from file system into a table.continue reading

SQL Server 2016 Developer Edition in Windows Containers

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

OMS in CSP

A lot of CSP partners ask about OMS availability in CSP. In this article I'll show what OMS components are available in CSP and how to use them. Microsoft Operations Management Suite (OMS) includes several management solutions for hybrid cloud ... continue reading
clip_image002

SQL Server on Linux: Mission-critical HADR with Always On Availability Groups

This post was authored by Mihaela Blendea, Senior Program Manager, SQL Server In keeping with our goal to enable the same High Availability and Disaster Recovery solutions on all platforms supported by SQL Server, today Microsoft is excited to announce ... continue reading
guestclustering

Deploying IaaS VM Guest Clusters in Microsoft Azure

Authors: Rob Hindman and Subhasish Bhattacharya, Program Manager, Windows Server In this blog I am going to discuss deployment considerations and scenarios for IaaS VM Guest Clusters in Microsoft Azure. IaaS VM Guest Clustering in Microsoft Azure A guest cluster ... 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

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

Improve Speed and Reduce Overhead with Containers in Windows Server 2016

Learn about how containers work in Windows Server 2016 and how they can be used to increase speed, workload density and decrease server overhead to create a more efficient server environment. Workload candidate and security options are also discussed to ... continue reading