netwyman

SQL Azure is Microsoft’s cloud database service. Based on SQL Server database technology and built on Microsoft’s Windows Azure cloud computing platform, SQL Azure enables organizations to store relational data in the cloud and quickly scale the size of their databases up or down as business needs change. Data is hosted, managed and provisioned in Microsoft data centers. Organizations can build applications on-premises and move them to SQL Azure or build them on Windows Azure and keep the data in the cloud. SQL Azure supports SQL Server’s Transact-SQL (T-SQL) query language, offers built-in support for high availability and fault tolerance and allows for data to be synchronized between on-premises SQL Server and cloud databases. Database analysts have pointed out a few important differences between SQL Azure and SQL Server. For example, SQL Azure doesn’t support all T-SQL commands, SQL Server data types like XML or functions such as cross-database joins, and the maximum data...

Microsoft aims to help you better manage your data with services like Azure Cosmos DB, a multi-model database service that transparently scales and replicates your data wherever your users are. Let’s take a closer look at this PaaS offering and how you can benefit from it. A Definition of Azure Cosmos DB Comos DB is a database service that is globally distributed. It allows you to manage your data even if you keep them in data centers that are scattered throughout the world. It provides the tools you need to scale both global distribution pattern and computational resources, and these tools are provided by Microsoft Azure. It can support multiple data models using one backend. This means that it can be used for document, key value, relational, and graph models. It is more or less a NoSQL database because it does not rely on any schemas. However, because it uses query language similar to SQL and can easily support ACID transactions, some people have been classifying it as ...