What is Azure SQL Database Hyperscale

Azure SQL Database has a new service tier called Hyperscale. Hyperscale is currently in public preview and offers the ability to scale past the 4TB limit for Azure SQL Database. Hyperscale is only available in the vCore-based purchasing model. Hyperscale offers customers a highly scalable storage and computer performance tier that is built on the […]

How to create a linked server to Azure SQL Database via SQL Server Management Studio

Often, I need to create a linked server to an Azure SQL Database to run queries against it or schedule maintenance. Creating a linked server to an Azure SQL Database is slightly different than how you’ve likely been creating linked servers to other SQL Servers in your environment. When expanding ‘Server Objects’ and right clicking […]

Azure SQL Managed Instance – Business Critical Tier

Microsoft has announced the GA date for the Business-Critical tier. Azure SQL Managed Instance Business Critical tier will be generally available on December 1st 2018. For those customers who are needing the ‘Super-Fast’ storage capabilities provided with local SSDs on the instance, you now have a release date. Business Critical also provides the ability to […]

Azure Training – 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 […]

Calling all user group leaders! I want to present on Managed Instances for you!

At SQLskills, we like presenting to user groups. It’s a great way to give back to our community and share things that we learn about. Paul Randal put out a call to user group leaders earlier this year, but I’ve recently been digging deep into Azure SQL Database Managed Instance and would like to show […]