Tag: Azure SQL Database

Getting Started With SQL Server Always Encrypted

Azure SQL Database and SQL Server 2016 introduced a new security feature for SQL Server databases called Always Encrypted. Always Encrypted is a feature designed to protect sensitive data, such as national/regional identification numbers (Social Security numbers for those in the USA), credit card numbers, and other highly sensitive types of data. Always Encrypted allows […]

What is Azure SQL

I get asked about Azure SQL very often. This is a topic that I’ve written about and taught many times. To be honest, this is a rather large topic that can go in many different directions. For this post, I want to cover what I consider the basics of Azure SQL. For me, that is […]

Updated Default Settings for Azure SQL Managed Instance Databases

A common saying about Azure is that it is always changing. This is a very accurate statement, want proof, just take a look at Microsoft Build 2020. Microsoft is always improving the environment by adding new features, tweaking interfaces, tweaking features, and much more. I’ve been working with Managed Instance since private preview and just […]

SQL Saturday Louisville

Are you coming to town for SQL Saturday 883 in Louisville KY, if you are going to be around the area on August 2nd, I’ll be presenting an all day session on Common SQL Server Mistakes and How to Correct Them. This session is gear for the junior to mid-level DBA that is responsible for […]

New vCore Compute Levels for Azure SQL Database and Elastic Pools

Additional vCore-based elastic pools and single databases have been expanded for the general purpose, business critical, and hyperscale service tiers. This provides customers with more flexibility and options when migrating DTU-based deployments and right-sizing workloads for the cloud. Azure SQL Database, Elastic Pools, and Hyperscale have two processor types to select from. Gen 4 offers […]

Azure Training in London

I am very excited about my upcoming IEAzure class being held in London, September 10th and 11th at the Marriott in Kensington (London). This is a content rich class covering SQL Server running on Azure Virtual Machines (Azure IaaS) as well as Azure SQL Database and Azure SQL Managed Instance (PaaS). You read that correctly, we’ve expanded the […]

Azure SQL Database Manage Instance

Azure SQL Database Managed Instance is bridging the gap between 0n-premises SQL Server and Azure SQL Database. Azure SQL Database Managed Instance gives you the benefits of Platform as a Service and the scoped configuration of a SQL Server instance. The overall goal of Azure SQL Database Managed Instance is to provide 100% surface configuration […]