Softpedia Editor's Review for Microsoft SQL Server
A comprehensive data platform that is more secure, reliable, manageable and scalable
Written by Andreea Matei on May 2nd, 2013
Microsoft SQL Server is a relational database management suite aiming to facilitate and ease data warehousing and application development. It is a cloud-ready platform, which means organizations can benefit from protection while deploying and synchronizing data across desktops and modern devices.
SQL Server’s high rate of success is mostly due to its power to store and then retrieve data for third-party software that rely on it to successfully manage information inside databases. Another advantage is brought by the advanced security features that protect critical workloads from unauthorized access.
Built to satisfy a wide array of audiences, Microsoft SQL Server is available in multiple editions, each targeting a different purpose. The most popular are SQL Server Enterprise, which aside from the core engine, includes a rich list of add-ons and extensive processor support, followed by SQL Server Standard, which features support for fewer instances and is addressed to medium level businesses. The most recent of the editions is Business Intelligence, which includes memory analytics and focuses on Self Service.
Perhaps one of the most important features is provided by the server to cloud technology, which is a quick and trustworthy architecture for flexible application deployment. Furthermore, data synchronization is facilitated through scenarios that involve Windows Azure SQL Database Data Sync, which accomplishes bi-directional communication between the datacenter and the cloud.
Microsoft SQL Server delivers amazing uptimes and undeniable performance, virtues confirmed by the various industries that use it as a basis for developing highly reliable platforms. Downtimes are minimized and application availability is enhanced with the aid of the integrated disaster recovery solution, which prevents companies from wasting money on third-party backup solutions.
Developers, as well as end users gain in-depth insight through the data exploration and visualization capabilities, which are delivered via a browser-based approach. Collaboration and sharing, as well as reporting are facilitated through a collection of tools that integrate inside Excel and SharePoint.
In conclusion, Microsoft SQL Server is one of the most reliable database technologies that delivers blazing fast performance and scalability, making itself available in a variety of editions for all types of audiences.
Microsoft SQL Server description
Here are some key features of "Microsoft SQL Server":
- Deliver required uptime and data protection with AlwaysOn
- Gain breakthrough & predictable performance with ColumnStore Index
- Help enable security and compliance with new User-defined Roles and Default Schema for Groups
- Enable rapid data discovery for deeper insights across the organization with ColumnStore Index
- Ensure more credible, consistent data with SSIS improvements, a Master Data Services add-in for Excel, and new Data Quality Services
- Optimize IT and developer productivity across server and cloud with Data-tier Application Component (DAC) parity with SQL Azure and SQL Server Data Tools for a unified dev experience across database, BI, and cloud functions
- This fully functional trial software will automatically expire after six months
- Cross-Cluster Migration of AlwaysOn Availability Groups for OS Upgrade:
- SQL Server 2012 SP1 introduces support for cross-cluster migration of AlwaysOn Availability Groups deployments to a new Windows Server Failover Clustering (WSFC) cluster. A cross-cluster migration moves one AlwaysOn availability group or a batch of availability groups to the new, destination WSFC cluster with minimal downtime. The cross-cluster migration process enables you to maintain your service level agreements (SLAs) when upgrading to a Windows Server 2012 cluster. SQL Server 2012 SP1 must be installed and enabled for AlwaysOn on the destination WSFC cluster. The success of cross-cluster migration depends on thorough planning and preparation of the destination WSFC cluster.
- Selective XML Index:
- SQL Server 2012 SP1 introduces a new type of XML index known as a Selective XML Index. This new index can improve querying performance over data stored as XML in SQL Server, allow for much faster indexing of large X...