Improve scalability with system page latch concurrency enhancements in SQL Server 2022 

13 min read

Over the past several SQL Server releases, Microsoft has improved the concurrency and performance of the tempdb database. In SQL Server 2022 we are addressing one of the last areas of contention by introducing concurrent global allocation map (GAM) and shared global allocation map (SGAM) updates which will give SQL Server 2022 a big improvement Read more

Microsoft Azure at Data Platform Virtual Summit 2020 

1 min read

Data Platform Virtual Summit 2020 (DPS 2020) is just a couple of weeks away. A global learning event for data professionals, DPS 2020 features a keynote from Rohan Kumar, Microsoft Corporate Vice President of Azure Data, as well as 200 breakout sessions and 30 training classes delivered by Azure Data engineering, partner organizations, and community Read more

Microsoft Azure at PASS Virtual Summit 2020 

1 min read

It is almost time for PASS Virtual Summit 2020, the premier learning event for the data professional. Similar to the in-person event, this virtual conference will include the latest SQL Server and Azure Data innovations, practical training, and networking—to empower you to transform your career and your company. Read more

Migrate SQL workloads to the cloud with confidence 

2 min read

Wouldn’t it be great if you could see how a workload will perform in a new environment before migrating a database to the cloud? Then you could fix any queries that have compatibility errors or move forward with the migration with confidence. That type of crystal ball is essentially what Microsoft gives us in the Read more

Use hyperscale for your most demanding cloud-born workloads 

2 min read

Sometimes resource demands increase beyond your expectations. Azure SQL Database service continues to meet your needs regardless of your speed of growth. The hyperscale service tier for a single database enables you to scale to 100 TB with fast backup and restore capabilities. Learn about other options for running Microsoft SQL Server in Azure in Read more

Tips to select the best Azure SQL deployment option 

3 min read

When it comes time to migrate your SQL workloads to Azure, you have a choice of two main deployment options: SQL Server on Azure Virtual Machines and Microsoft Azure SQL Database. Each offers its own benefits, so how do you know which is right for your workload? If you’re ready to learn more about moving Read more

DBAs: It’s time to get up to speed with Azure 

2 min read

The summer solstice has passed, and DBAs are still asking how to get up to speed with Azure. I’m even speaking at events on how to take advantage of Azure to do migrations to the cloud! Many I’ve spoken to are wondering what skills they need to add to their already impressive arsenal of technology. Read more

SQL Server Management Studio (SSMS) 18.1 is now generally available 

1 min read

We’re excited to announce the release of SQL Server Management Studio (SSMS) 18.1. It’s been just over a month since we released SSMS 18.0. While we brought in many fantastic capabilities, we also regressed some functionality for some of our users. We are happy to share that we’ve fixed those and are also bringing in Read more

8 Comments

Advanced data security for SQL Server is coming to Azure Virtual Machines 

2 min read

This post was written by Michael Makhlevich Our customers have asked for this and we’ve been listening – advanced data security is now available for SQL Server on Azure Virtual Machines! Using just a few simple steps, you can now protect your SQL Server installations on Azure VMs with Microsoft’s advanced data security capabilities. Advanced data security for SQL Server on Azure VM currently includes Read more

A SQL Server tale of two cities 

4 min read

No one disputes that data is critical to the lifeblood of business, applications, and the computer industry. SQL Server sits at the forefront of any discussion about data these days. So it’s no coincidence that SQL Server is seen, heard, and felt at major industry events. As a leader in the Azure Data SQL Server Read more