Category: SQL Server 2014

SQL Server 2014

SQL Server 2014: Hybrid Scenarios

June 9, 2014 – SQL Server 2014 makes it easier than ever to unlock new hybrid scenarios between your on-premises SQL Server instances and Microsoft Azure. Here are three key hybrid scenarios that you can easily deploy with SQL Server 2014 and Azure to help reduce operational costs while improving business continuity:

    • Quickly develop and test SQL Server applications. You can spin up a SQL Server 2014 image in minutes on Azure Virtual Machines (VMs) for your next SQL Server development and test project. And with full SQL Server compatibility and many VM sizes to choose from, you can easily deploy the application into production on Azure or back on-premises. The best part is that you pay only for what you use, so you can reduceyour capital-expenditure investment to set up a dev/test environment for SQL Server. You can also now easily connect to and manage your SQL Server VMs in Azure through SQL Server Management Studio (SSMS).
    • Cost-effectively back up your on-premises SQL Server instances. SQL Server 2014 makes full SQL Server-level backup to Azure storage even easier with a new UI built directly into SSMS.  SQL Server 2014 also offers the ability to encrypt the backup, where you have the option to hold the encryption keys. In addition, a new complimentary backup tool lets you also back up previous versions of SQL Server to Azure.
    • Enable low RTO disaster recovery while improving BI reporting for your global offices. You can enable a low Recovery Time Objective (RTO) disaster recovery solution with SQL Server 2014 that not only improves business continuity but also gives you the ability to enhance business intelligence (BI) reporting for your global offices. The solution takes advantage of up to eight readable secondaries with the AlwaysOn feature in SQL Server 2014 and places them strategically across the many Azure global datacenters. You can use the readable secondaries to offload BI reporting or run backups, and they are much easier to deploy on-premises or on Azure with new the UI in SSMS.

These hybrid scenarios can benefit your on-premises SQL Server instances and help you innovate faster by providing flexible, cost-effective, and efficient ways of developing and testing new database applications. If you haven’t already, download the evaluation copy of SQL Server 2014 and try these new hybrid scenarios with Azure for yourself.  


SQL Server 2014 In-Memory

April 1, 2014 – SQL Server 2014 with built-in in-memory technology can accelerate your business and enable new scenarios that make you more competitive. Here are some key things you should know about in-memory technology in SQL Server 2014 and how it can benefit your organization.

    • It’s built-in.
      • If you know SQL, you know how to use our in-memory technology.
      • It’s not a separate database product, and there are no new APIs to learn.
      • You can take advantage of other powerful SQL Server features such as AlwaysOn as well as in-memory capabilities.
      • You don’t need to buy multiple product SKUs – the SQL Server 2014 Enterprise SKU gives you in-memory capabilities across OLTP, DW, and analytics.
    • It’s flexible – run in-memory tables alongside traditional tables on disk.
      • We don’t believe having to load the entire database into memory is an optimal architecture, as putting cold data into memory doesn’t help. SQL Server 2014 allows you to select the most utilized tables and have them reside in memory.  This means you can significantly improve your transactional performance without having to refresh hardware.
      • We even provide tools built right into SSMS that let you know the optimal tables and stored procedures to migrate to memory.
      • You can query both traditional on-disk tables and in-memory tables through a single query.
    • It’s pervasive across all SQL Server workloads.
      • SQL Server 2014 is the third release of our in-memory technology, which started back in SQL Server 2008 R2 with in-memory analytics. Then in SQL Server 2012, we added in-memory capabilities for data warehousing with an in-memory ColumnStore. Now with SQL Server 2014, you also have in-memory OLTP and an enhanced in-memory ColumnStore that is now updatable and offers much higher data compression.
      • This means we can uniquely speed your transactions, queries, and analytics.
    • It lets you remove database contention and utilize CPU and Core capacity.
      • SQL Server 2014 has a unique in-memory OLTP design point of removing contention in the database by removing locks and latches and still ensuring 100% durability. You can learn more about this unique architecture by watching David DeWitt’s PASS Summit 2013 keynote.
      • This means much higher throughput and speed of transactions as well as much lower latency. You can now harness the full power of your CPUs.


SQL Server 2014 provides breakthrough performance for all your mission-critical workloads. If you haven’t already, please download the evaluation copy of SQL Server 2014 and see for yourself the performance gains that in-memory technology provides for your applications. If you want to dev/test SQL Server 2014 quickly and efficiently, you can spin up an image of SQL Server 2014 in minutes in a Microsoft Azure Virtual Machine.

SQL Server 2014 Mission Critical

March 18, 2014 – Running SQL Server 2014 – with built-in in-memory technology to speed up transactions, queries, and analytics – on Windows Server 2012 R2 can provide key capabilities for your mission-critical applications.

    • Breakthrough performance with in-memory built in.
      • SQL Server 2014 has in-memory technology built in to the data platform that can significantly speed transactions, queries, and analytics.
      • Windows Server 2012 R2 can provide massive compute and memory in both physical and virtual environments so you can take full advantage of SQL Server in-memory technology. Windows Server 2012 R2 provides 640LPs with up to 4TB of memory in a physical environment and 64vCPUs and up to 1TB of memory per VM in a virtual environment.
    • SQL Server 2014 provides the 9’s of availability you need with AlwaysOn.
      • SQL Server 2014 AlwaysOn technology can provide synchronous replication for zero transaction loss and asynchronous replication for disaster recovery solutions. You can now have up to eight readable secondaries and the option to place the secondaries in Azure Virtual Machines for fast and cost-effective cloud disaster recovery.
      • For SQL Server instances running in a physical environment, you can use Windows Server 2012 R2 Failover Clustering to provide server-level high availability and disaster recovery. If you are running SQL Server instances in a virtual environment, you can use Windows Server 2012 R2 Failover Clustering and Windows Azure Hyper-V Recovery Manager to provide both local and geographical business continuity and disaster recovery.
    • SQL Server is the least vulnerable database the last 5 years in a row*.
      • Least vulnerable means the least number of security patches you have to implement, which means less downtime.
    • SQL Server offers Premier Mission Critical support for your most critical database applications.
      • Get solution validation, architectural reviews, on-site engineering, and fastest response times available from Microsoft with Premier Mission Critical support.

Download this datasheet to learn more about SQL Server 2014’s mission-critical features.

*  National Institute of Standards and Technology Comprehensive Vulnerability Test Database, 4/17/2013.