Select Page
Pearl Abyss: Massive Scale using Azure SQL Database

Pearl Abyss: Massive Scale using Azure SQL Database

Pearl Abyss is a Korea based game development studio established in 2009. Black Desert Online, a PC-massively multiplayer online role-playing game (MMORPG), is their main title in production published across the globe. On February 28, 2018, Pearl Abyss launched Black ... continue reading
April 2018 Leaderboard of Database Systems contributors on MSDN

April 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our April top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions. This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. The following continues to be the ... continue reading
March 2018 Leaderboard of Database Systems contributors on MSDN

March 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our March top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions. This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. The following continues to be the ... continue reading
February 2018 Leaderboard of Database Systems contributors on MSDN

February 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our February top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions. This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. The following continues to be the ... continue reading
Migrating to Azure SQL Database with Zero Downtime for Read-Only Workloads

Migrating to Azure SQL Database with Zero Downtime for Read-Only Workloads

Special thanks to MSAsset engineering team’s Peter Liu (Senior Software Engineer) and Shail Batra (Principal Software Engineering Manager) for sharing their migration story with the Azure SQL Database product team. Microsoft uses an internally written service called MSAsset to manage ... continue reading
January 2018 Leaderboard of Database Systems contributors on MSDN

January 2018 Leaderboard of Database Systems contributors on MSDN

Congratulations to our January 2018 top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions. This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. The following continues to be ... continue reading

Database scoped optimizing for ad hoc workloads

SQL Server provides the “optimize for ad hoc workloads” server-scoped option that is used to reduce the memory footprint of single use ad hoc batches and associated plans. When enabled at the SQL Server instance scope, the “optimize for ad ... continue reading

Default compatibility level 140 for Azure SQL databases

As of this writing, the default compatibility level for new databases created in Azure SQL Database is 130. Very soon, we’ll be changing the Azure SQL Database default compatibility level for newly created databases to 140. The alignment of SQL ... continue reading
ie_image_1

Introducing Interleaved Execution for Multi-Statement Table Valued Functions

For SQL Server vNext and Azure SQL Database, the Microsoft Query Processing team is introducing a new set of adaptive query processing improvements to help fix performance issues that are due to poor cardinality estimates. Improvements in the adaptive query ... continue reading
Loading...