Select Page

Tips to select the best Azure SQL deployment option

When it comes time to migrate your SQL workloads to Azure, you have a choice of two main deployment options: SQL Server on Azure Virtual Machines and Microsoft Azure SQL Database. Each offers its own benefits, so how do you ... continue reading

When to use Azure SQL Virtual Machines

Rearchitecting applications to run in the cloud can be a significant undertaking requiring time, money, and the appropriate skills. If you want to move existing on-premises apps to the cloud, but don't have the necessary resources to rearchitect your applications, ... continue reading
Big Data Clusters Reference Architecture

The ultimate performance for your big data with SQL Server 2019 Big Data Clusters

Microsoft SQL Server 2019 Big Data Cluster enables intelligence over all your data and helps remove data silos by combining both structured and unstructured data across the entire data estate. Big Data Clusters integrates Microsoft SQL Server and the best ... continue reading

Improvements to machine learning capabilities in SQL Server 2019

Many organizations seek to do more with their data than pump out dashboards and reports. Applying advanced analytical approaches such as machine learning is an essential arena of knowledge for any data professional. While database administrators (DBAs) don't necessarily have ... continue reading

Easier management of PolyBase and relational data through SQL Server 2019

The days when a database administrator (DBA) could specialize solely in a single database technology are rapidly ending. Today, we're much more likely than ever before to be asked to bring together many types of data from diverse sources. Although ... continue reading

How to configure persistent memory for SQL Server on Linux

With the release of SQL Server 2019 on Linux, Microsoft introduced persistent memory (PMEM) support on Linux. This is an exciting development, as previous versions of SQL Server on Linux didn't support PMEM. Let's look at how to configure the ... continue reading

How to deploy SQL Server 2019 Big Data Clusters

SQL Server 2019 Big Data Clusters is a scale-out, data virtualization platform built on top of the Kubernetes container platform. This ensures a predictable, fast, and elastically scalable deployment, regardless of where it's deployed. In this blog post, we'll explain ... continue reading
Introducing Batch Mode on Rowstore

Introducing Batch Mode on Rowstore

First published on MSDN on Sep 24, 2018 Last year SQL Server 2017 and Azure SQL Database introduced query processing improvements that adapt optimization strategies to your application workload’s run-time conditions. These improvements included: batch mode adaptive joins , batch ... continue reading
Advanced data security data flow chart for SQL Server on virtual machine.

Advanced data security for SQL Server is coming to Azure Virtual Machines

This post was written by Michael Makhlevich Our customers have asked for this and weve been listening advanced data security is now available for SQL Server onAzure Virtual Machines!Using just a few simple steps, you can nowprotectyour SQL ServerinstallationsonAzure VMswith ... continue reading

Three reasons to choose Microsoft for your hybrid data platform

Companies today are faced with the trade-off of the security of having an on-premises solution and the convenience of moving their data to the cloud. With Microsoft, companies no longer have to make the choice. SQL Server and Azure SQL ... continue reading