Azure SQL – Microsoft’s Cloud Database Platform
Azure SQL is the powerful database solution in the Microsoft Azure Cloud. In this category, we explore everything related to Azure SQL databases. Learn how to efficiently manage and optimize databases in the cloud. We dive deep into best practices and methods to ensure your Azure SQL instances are performing at their best. Discover how to maximize scalability, security, and performance for your cloud databases. Whether you’re new to the world of Azure SQL or an experienced pro, you’ll find valuable insights and resources here.
Today the time had come – I was finally able to speak at Data Saturday (formerly SQLSaturday) in Oslo … that was finally not due to the organizers but rather to me or the pandemic, since I hadn’t dared to give lectures until 2020 Keeping English, I hadn’t submitted any sessions for Oslo either. I…
Exploring the Data Geeks Community in South Florida On a warm and inviting Saturday, I delivered another presentation, this time in beautiful South Florida, to the Data Geeks community. This event marked the eleventh year of their “SQL Saturday,” drawing around 700 in-person participants passionate about all things related to the Microsoft Data Platform. These…
I see the other contributions as a personal refresh of my knowledge of the Azure SQL Database and all its numerous features. After a long time, it was necessary to deal with it in detail again and show my own experience with learning that “writing down” helps remember the content and essential points. So I’ll just…
A customer had asked me the last few days to help him optimize a SQL server on an Azure VM. The customer always had slight performance problems with this SQL server, so he first asked the application manufacturer or supervisor, but they didn’t want to or could help. The only answer they received was that…
Many services in Azure allow certain cost savings through automation, this can also be achieved with the Platform-as-a-Service “Azure SQL Database”, this is what this blog post is all about. Quite as simple as e.g. with the Azure Analysis Service it is not because actually there is no pause-resume functionality – here comes the backup…
In the first part of my Azure SQL Database Powershell Automation series I showed how to create the resource group, the logical SQL Server and the corresponding database, I would like to show you how to implement a resize of the performance level of this database. Why should I want to resize a database? Upwards…
