SQL Server Team articles

Avatar photo
SQL Server Team
Published 
3 min read

SQL Server AlwaysOn Offering in Microsoft Azure Portal Gallery 

We are excited to announce the release of a SQL Server AlwaysOn template in the Microsoft Azure Portal Gallery. This offering was announced in Scott Guthrie’s blog post along with several other exciting new features. This template fully automates the configuration of a highly available SQL Server deployment on Azure Infrastructure Services using AlwaysOn Availability Groups.
Published 
3 min read

Azure previews fully-managed NoSQL database and search services 

I am pleased to announce previews of new NoSQL database and search services and the evolution of our Hadoop-based service. Available as previews today are Azure DocumentDB, a fully-managed transactional NoSQL document database-as-a-service, and Azure Search, which enables developers to easily add search capabilities to mobile and cloud applications. Generally available today, Azure HDInsight, our Hadoop-based solution for the cloud, now supports Apache HBase clusters.
Published 
3 min read

New: ASP.NET Session State Provider for SQL Server In-Memory OLTP 

Microsoft SQL Server 2014 brings new performance and scalability gains by introducing In-Memory OLTP.  In-Memory OLTP contains tables and indexes optimized for in memory. Transactions execute under lock-free algorithms to provide linear scalability and Transact-SQL stored procedures can be compiled in native machine code for maximum efficiency in processing.
Published 
4 min read

Driving Ground Breaking BI with APS 

This blog post will detail how APS gives users the ability to: Leverage Power Query, Power Pivot, and Power Map at massive scale Iteratively query APS, adding BI on the fly Combine data seamlessly from PDW, HDI, and Azure using PolyBase The Microsoft Analytics Platform System (APS) is a powerful scale out data warehouse solution for aggregating data across a variety of platforms.
Published 
1 min read

Webcast: Database cloud backup and DR – a strategic imperative 

The cloud is creating radical changes in how information technology is architected.  And its next big target just might be business continuity. Explosive data growth and new application types are causing enterprises to consider cloud as a strategic alternative to growing on-premises storage for backup and disaster recovery.