Skip to main content

Posts

Showing posts with the label MSSQL

What is SQL Azure?

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...

What is Amazon RDS? Define the Cost of Relational Database Service with it's features

Amazon RDS (Relational Database Service) is a fully-managed SQL database cloud service that allows to create and operate relational databases. Using RDS you can access your files and database anywhere in a cost-effective and highly scalable way. Features of Amazon RDS Scalable: Amazon RDS allows to scale the relational database by using AWS Management Console or RDS-specific API. We can increase or decrease your RDS requirements within minutes. Host replacement: Sometimes these situations occur when the hardware of Amazon RDS fails. There is no need to worry, it will be automatically replaced by Amazon. Inexpensive: Using Amazon RDS, we pay only for the resources we consume. There is no up-front and long-term commitment. Secure: Amazon RDS provides complete control over the network to access their database and their associated services. Automatic backups: Amazon RDS backs up everything in the database including transaction logs up to l...