Tag: sql server

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 […]

SQL Server: Consolidation Tactics and Best Practices

My very first course has been published on Pluralsight – SQL Server: Consolidation Tactics and Best Practices. In this course I spend just over two hours sharing my experiences and knowledge of consolidating numerous clients over the years. I had a lot of fun working on this course and owe so much to Paul Randal […]

Know Backups and Know Restores – SQL Server Restores

A couple of years ago I put together a training session to demonstrate various types of backups and restores. The driving factor behind me building this session was the response I got from talking to a dozen or so DBA’s about disaster recovery. I asked how many have ever performed a restore where you had to […]