Browse by Tags

Tagged Content List
  • Blog Post: Visit Microsoft at the Gartner Business Intelligence and Analytics Summit 2014 in Las Vegas

    Microsoft will be at the Gartner Business Intelligence and Analytics summit being held in Las Vegas from March 30 th – April 2 nd as a premier sponsor . We’re looking forward to sharing our vision of how we’re making big data real through the familiar tools you already use – SharePoint...
  • Blog Post: In-Memory OLTP Index Troubleshooting, Part II

    With the In-Memory OLTP feature in SQL Server 2014 we introduce two new types of indexes for memory-optimized tables: the memory-optimized NONCLUSTERED indexes, and the memory-optimized HASH indexes. Memory-optimized NONCLUSTERED indexes behave similar to traditional NONCLUSTERED indexes from an application...
  • Blog Post: State Transition of Checkpoint Files in Databases with Memory-Optimized Tables

    In the previous blog Merge Operations , we described that how a CFP transitions across various stages in its life cycle. In this blog, we will walk through an actual example to show the state transition. Note, some of the states shown for CFPs are only visible in RTM bits (not in CTP2) but internally...
  • Blog Post: 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...
  • Blog Post: SQL Server 2014: Pushing the Boundaries of In-Memory Performance

    This morning, during my keynote at the Professional Association of SQL Server (PASS) Summit 2013, I discussed how customers are pushing the boundaries of what’s possible for businesses today using the advanced technologies in our data platform. It was my pleasure to announce the second Community...
  • Blog Post: Cloud Data Warehousing – The Fastest Time To Value

    In the past, deploying a data warehouse has been a costly affair. IT departments required expertise to procure and build state-of-the-art hardware servers (that are optimally balanced from a CPU, storage and I/O perspective) as well as install software that is tuned for optimal performance. Prior to...
  • Blog Post: SQL Server 2014 CTP 2 Now Available

    Microsoft SQL Server 2014 CTP2 was announced by Quentin Clark during the Microsoft SQL PASS 2013 keynote. This second public CTP is essentially feature complete and enables you to try and test all of the capabilities of the full SQL Server 2014 release. Below you will find an overview of SQL Server 2014...
  • Blog Post: 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...
  • Blog Post: 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! We are pleased to have had over 5,000...