There are a wide variety of database technologies available in Azure, each with its own advantages and disadvantages. Among them, Azure SQL stands out as a powerful and versatile option. While there are new, specialized solutions on the market, Azure SQL offers unique benefits that may be ideal for your next project.
By choosing Azure SQL, you can benefit from advanced security, scalability and performance features, as well as a wide range of complementary tools and services available within the Azure ecosystem. In addition, Azure SQL is highly compatible with other database solutions, making it easy to migrate your data to the platform. In short, when you choose Azure SQL, you will have access to a robust, proven solution that can help propel your database projects to the next level.
According to David - "after I joined the Azure SQL PM team, I discovered that there are many, in fact, many features that developers don't know exist ..." as a result, Azure SQL is still used as if its development and evolution stopped 20 years ago ... when Azure SQL wasn't there yet, and only its on-premises sibling, SQL Server, existed. Well, many improvements have been made, really making Azure SQL definitely a post-relational cloud-native database. Let me show you why, using just 10 simple points. I will go over each point in detail in upcoming blog posts.
Batteries Included in Azure SQL
Azure SQL is a relational and post-relational database with "batteries included," as Python developers say. This expression is appropriate, because Azure SQL offers a comprehensive set of built-in features that can help developers work more efficiently. This is one of the many reasons why Azure SQL is a popular database among developers. Azure SQL's ease of use and efficiency make it a great choice for software development projects.
Many features that you would normally find in different, more specialized products are integrated into just one. Using different specialized products can have great advantages, but it also presents a big challenge: data must be moved around all these products, and the responsibility for maintaining consistency falls on the developer's shoulders.
This is a big problem that will increase the complexity of the application by an order or magnitude. And as a developer, I prefer to follow the KISS principle. Azure SQL allows me to focus only on what is unique to my company and application, delegating all data-related responsibilities to something that specializes in that. This is a big win for everyone.
Post-relational capabilities for modern applications
JSON is what developers love and breathe, so native support for JSON is essential for a modern database. Azure SQL provides very good support for generating, consuming, manipulating, and querying JSON. But this is not enough.
Graphical support, via node and edge types, transitive closure, and the ability to arbitrarily navigate deep relationships using a very concise (similar to the familiar "Cypher") is available in Azure SQL immediately.
This makes it easy to store geospatial data and query data for nearby locations, find all locations within a given perimeter (perfect for geofencing) or, more generally, perform complex geospatial manipulations.
Complete storage control and abstraction with Columnstore and Rowstore
With Azure SQL, you can decide if a table should be saved using a line by line or column by column. Or a mixture of the two. And this is really a killer feature, because it allows you to create solutions that can quickly access a single row or can easily read, aggregate, and analyze hundreds of millions of rows.
Ultra-high concurrency with tables optimized for memory free locking
The memory-optimized tables use a sophisticated non-blocking mechanism known as Multiversion Concurrency Control (MVCC), to guarantee extremely high concurrency and still provide full transactional support. Extremely high means hundreds of thousands of transactions per second and much more.
Time Travel with "As-Of" Queries
Azure SQL provides the ability to automatically trace and execute queries "from" by enabling the time tables. Changes to a table will be transparently tracked and made available via the "History" table. Again, completely transparent to the applications and very useful for auditing, reporting and business analysis
There are a number of exciting new features in Microsoft Azure SQL that many developers are not yet aware of. Learn ten reasons why Azure SQL is a post-relational cloud database, including complete storage control, easy monitoring, and comprehensive insights. These advanced features can help developers work more efficiently and enhance their database projects.