Choose the Right Azure SQL Database Deployment Options for Your Solution

Happy 10th birthday, Azure SQL Database! Yes, that’s right – Microsoft’s Platform as a Service (PaaS) SQL database is ten years old this year. As it’s grown from one limited offering to a set of services, choosing the best option for your application and database can be confusing. Single database or managed instance, DTU or vCore, serverless, hyperscale - how do you know which one is right for you? In this article, Jes Schultz explains the many options available and provides guidance on how to choose the best one for your project.

Introducing the Azure SQL Family

Flexibility to adapt your business is crucial during these uncertain times. When it comes to migrating your data, Azure SQL is a family of databases that meet you where you are. Azure SQL has options for any need and budget to help you stay agile.

PASS Marathon: Azure Data Services Spanish Edition

Back by popular demand, the second Spanish Edition of PASS Marathon will be taking place June 24 at 19:00 UTC.
This virtual event will span 8 consecutive sessions and will be delivered exclusively in Spanish. You will be joined by MVPs, PASS Community Leaders, and other experts on the Microsoft Data Platform, exposing various topics on new technologies and the latest trends in data analysis and management.

Brent Ozar Is Giving You Live Database Training!

Join Brent Ozar, Pinal Dave, Janis Griffin, and other top experts for this fun and educational webcast series. Save your place for Quest ® Database Training Days now!

Find Indexes Used In Query Store

How do you determine if a particular index is in use? While there is no perfect answer to this question, Grant Fritchey demonstrates how to get a sense of how and where an index is being used with Query Store.

SQL Server Runs Best on Azure

Learn the results of a recent GigaOm study that compared the performance of running SQL Server on virtual machines for online transactional processing (OLTP) workloads across Azure and AWS.

Quickly Blocking Inbound Connections to SQL Server

Sometimes the brilliance of a solution is lost in its simplicity. John Morehouse demonstrates a quick and effortless way to block all inbound connections to the SQL Server instance.

Why Do My SQL Server Backup Files Keep Getting Much Larger?

In this short post, Dr. Greg Low explains why your SQL Server backup files keep getting much larger.

Upcoming Virtual Events

Database Design Fundamentals - Louis Davidson

Wednesday, July 08. 18:00 UTC.

 


We are recruiting community contributors for all PASS Insights newsletter editions:

DBA, BI, Developer, and Analyst.
We’re looking for engaging, in-depth, and technically-focused ideas to feature each month. If you are interested, submit your ideas to insights@pass.org.
You just might see yourself featured in an upcoming edition!

Looking for more than just DBA educational and technical content?
Log in to your PASS account and subscribe to the new Analyst, BI, and Developer PASS Insights newsletters.