SQL Server Team articles

Avatar photo
SQL Server Team
Published 
1 min read

New In-Memory OLTP Sample for SQL Server 2014 CTP2 

To help you get started with the new In-Memory OLTP feature, we created a sample around sales order processing based on the AdventureWorks sample database. The sample, along with installation and usage instructions, are available on Codeplex: https://msftdbprodsamples.codeplex.
Published 
5 min read

IO Resource Governance in SQL Server 2014 

Resource Governor was introduced in SQL Server 2008 to achieve predictable performance in a multi-tenant environment, to support mixed workload patterns, to provide mechanisms and tools to deal with runaway queries, and to enforce resource limits for CPU and memory. It enables customers to implement database consolidation or to configure their own database as a service.
Published 
1 min read

Revolutionizing City Planning in the 21st Century with Windows Azure, HDInsight, and SQL Server 

If you’ve ever played a video game where you manage a virtual city, you understand how real-time insight into services including emergency response teams and transportation is needed for effective city planning. Until recently, the technologies just weren’t available to support this kind of detailed “big picture” view enjoyed by gamers.
Published 
1 min read

Customers get Faster and Better Insight into More Data from More Sources with Windows Azure HDInsight Service 

Collecting Big Data is significant only if you can make use of it. With Windows Azure HDInsight Service, organizations can use Apache Hadoop clusters in Windows Azure. Combining the Microsoft platform with open-source tools like Hadoop equates to unprecedented insight into more data, from more sources, in any format—structured and unstructured. Here are a few examples: Chr.
Published 
1 min read

Windows Azure HDInsight Released for GA 

Today, Microsoft announced the general availability of Windows Azure HDInsight, its cloud-based distribution of Hadoop. Further expanding on Microsoft’s big data strategy, Microsoft CVP Quentin Clark will deliver a keynote at O’Reilly Strata + Hadoop World tomorrow, where he will discuss Microsoft’s vision to democratize big data by providing easy to use tools and a unified data platform.
Published 
1 min read

A Look Back at PASS Summit 2013 

PASS Summit 2013 has been over for a little more than a week and we are already looking forward to what’s next in 2014. PASS Summit is the world’s largest and most-intensive conference for Microsoft SQL Server and BI professionals and it just keeps growing!
Published 
6 min read

Backup and Restore Enhancements in SQL Server 2014 CTP2 

SQL Server 2014 CTP2 includes three SQL Server Backup and Restore enhancements.  These enhancements enable using Windows Azure for backups, providing options to ease and automate backup management, and improved security for backups through encryption.  In addition, to enable backup to Windows Azure from previous versions of SQL Server, a stand-alone tool is now available.
Published 
2 min read

Smart, Secure, Cost-Effective: SQL Server Back Up to Windows Azure 

Microsoft recently announced several new ways to back up and recover SQL Server databases with Windows Azure.  These features, now available in SQL Server 2014 CTP2 and as a standalone tool for prior versions, provide an easy path to cloud backup and disaster recovery for on-premises SQL Server databases.
Published 
2 min read

Customers Gain Roadmap for the Future with Microsoft, SQL Server 2014 and In-Memory OLTP 

There’s a lot of excitement around the In-Memory OLTP database engine in SQL Server 2014—and for good reason. Many companies are already realizing impressive performance gains by using it. Here are just a few examples: Edgenet manages data for Fortune 500 firms, and its success depends on updating clients’ databases so that they accurately reflect transactions, especially for databases supporting online shopping carts.