Want to get started with Azure Data Studio but don't know where to begin? In this video, Anna Hoffman shows you how to get connected to Azure SQL Database for the first time using Azure Data Studio ... continue reading

We’ve released our newest Azure blueprint that maps to another key industry-standard, the Center for Internet Security (CIS) Microsoft Azure Foundations Benchmark. This follows the recent announcement of our Azure blueprint for FedRAMP moderate and adds to the growing list ... continue reading

Today, January 14, 2020, marks the end of support for Windows Server 2008 and Windows Server 2008 R2. Customers loved these releases, which introduced advancements such as the shift from 32-bit to 64-bit computing and server virtualization. While support for ... continue reading

Executive summary M-series provides close to 30 GB of memory per core and up to 128 cores, enabling significant scale-up capability in Azure SQL Database. For the same IoT workload, we achieved 3 times higher throughput on M-series compared to ... continue reading

Azure SQL Database provides a number of options to optimize your deployment to best fit your needs. In this video we explain the different options and their aspects. More information: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-paas-vs-sql-server-iaas ... continue reading

You're probably familiar with Collations in SQL Server, but how do Collations change in Azure SQL Database Managed Instance? In this video, Anna Thomas and Colin Murphy cover a brief overview of collations (https://docs.microsoft.com/en-us/sql/t-sql/statements/collations) and how they're different in Azure ... continue reading

When you migrate your SQL Server data estate to Azure SQL Database managed instance, what you get is not just a good old SQL Server, secured and enriched with the newest features, and without a burden of managing backups, patching, ... continue reading

As 2020 is upon us, it's natural to take time and reflect back on the current year’s achievements (and challenges) and begin planning for the next year. One of our New Year’s resolutions was to continue live streaming software development ... continue reading

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

Introduction The document outlines the steps required to install SCCM CB 1902 with SQL 2017 using PowerShell. These steps can be used on a disconnected network. The scripts included in this document can also be added to MDT to automate ... continue reading