Cloud SOLID Part I: Cloud Architecture and the Single Responsibility Principle

Authored by Casey Watson. Edited by RoAnn Corbisier. Reviewed by Rick Rainey and Kirk Evans. What is SOLID? First introduced in 2003 by Robert “Uncle Bob” Martin, SOLID principles are a set of prescriptive guidelines that, when followed, can help developers write code that is easy to comprehend, maintain, and test. SOLID is a mnemonic device used…

Azure SQL databases in logical servers, elastic pools, and managed instances

Azure SQL Database is a Database as a Platform service designed for applications that will use database as self-contained service. Databases can be grouped together to simplify management options or share the resources. There are different options that can be used to bound databases in the groups, which will be explained in this post.

Now Available: Guide for enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform

Data privacy and data security have become one of the most prominent topics in organizations in almost every industry across the globe. New regulations are emerging that formalize requirements around these topics, and compel organizations to comply. The upcoming EU Global Data Protection Regulation (GDPR) is one of the most noteworthy of these new regulations….

Does Azure SQL DB support automatic indexed views?

Are indexed views used automatically in SQL Azure without “WITH (NOEXPAND)“?How does it work?and How the query optimizer decides to use it or not ? The query optimizer uses indexed views to speed up the query execution. Which means SQL Server’s query optimizer realizes the precomputed sums of all the Quantity values for each value are…