Browse by Tags

Tagged Content List
  • Blog Post: The data platform for a new era

    Earlier today, Microsoft hosted a customer event in San Francisco where I joined CEO Satya Nadella and COO Kevin Turner to share our perspective on the role of data in business. Satya outlined his vision of a platform built for an era of ambient intelligence. He also stressed the importance of a “data...
  • Blog Post: SQL Server 2014 brings on-premises and cloud database together to improve data availability and disaster recovery

    With the recently disclosed general availability of SQL Server 2014 , Microsoft brings to market new hybrid scenarios, enabling customers to take advantage of Microsoft Azure in conjunction with on-premises SQL Server. SQL Server 2014 helps customers to protect their data and make it more highly availably...
  • Blog Post: SQL Server 2014 Launch – A Community Affair

    Guest blog post by: PASS President Thomas LaRock – a SQL Server MVP, MCM, and Head Geek at Solarwinds – is a seasoned IT professional with over a decade of technical and management experience. Author of DBA Survivor: Become a Rock Star DBA , he holds an MS degree in Mathematics from Washington...
  • Blog Post: SQL Server 2014 now Generally Available

    Microsoft today released Microsoft SQL Server 2014 , the foundation of our cloud-first data platform. SQL Server 2014 delivers breakthrough performance with new and enhanced in-memory technologies to help customers accelerate their business and enable new, transformational scenarios. In addition, SQL...
  • Blog Post: Unlocking insights from Big Data can be simple with the right tools

    Data enthusiasts & Microsoft talk about Big Data in the enterprise at Gigaom Structure Data 2014 Last week in New York, our data solutions experts spent a few days with more than 900 big data practitioners, technologists and executives at Structure Data for a conversation how big data can drive...
  • Blog Post: Power BI for Office 365: Making It Real

    In my recent post, Simplifying Business Intelligence through Power BI for Office 365 , I described how the Power BI cloud service has changed the way I personally work. The ability to do “self-service BI” without any IT involvement—and to have the infrastructure transparently provisioned...
  • Blog Post: Amway sees 100 percent availability with hybrid data-recovery solution

    With the release to manufacturing announcement of SQL Server 2014 you will start to see more customer stories showcasing their use of hybrid features that span the cloud and on-premises. One such customer is global direct seller, Amway. Its data centers support about 34 terabytes of information spread...
  • Blog Post: “Modernizing” Your Data Warehouse with Microsoft

    Data warehousing technology began as a framework to better manage, understand, and capitalize on data generated by the business, and it worked extremely well for many years. This is a space that Microsoft knows well with warehousing capabilities since 1995 with SQL Server. However, there are several...
  • Blog Post: SQL Server 2014 releases April 1

    SQL Server 2014, Microsoft’s cloud first data platform, released to manufacturing today Today, Quentin Clark, corporate vice president of the Data Platform Group, announced that SQL Server 2014, the foundation of Microsoft’s cloud-first data platform, is released to manufacturing and will...
  • Blog Post: AMD Improves Operational Agility with SQL Server 2014 Business Intelligence Solution

    AMD, a leading designer and integrator of technology that powers millions of intelligent devices, needed better tools for monitoring manufacturing processes and other business operations. More than a terabyte of test information was loaded weekly into a data warehouse, which was used by business analysts...
  • Blog Post: Top 3 Features I’m Excited About in SQL Server 2014

    Guest blog post by : SQL Server MVP Adam Jorgensen – PASS Executive Vice President, Finance & Governance, and President of Pragmatic Works – has been leading innovative SQL Server and Business Intelligence organizations for over a decade. His passion is finding new and creative avenues...
  • Blog Post: Using Natively Compiled Stored Procedures in SQL Server 2014

    The new In-Memory OLTP feature in SQL Server 2014 greatly optimizes the performance of certain OLTP applications. By using the new memory-optimized tables you can speed up data access, in particular in concurrency situations, due to the lock- and latch-free architecture of the In-Memory OLTP Engine....
  • Blog Post: Differential Database Backup with Memory-Optimized Tables

    This blog describes how differential database backup is taken on database with one or more memory-optimized tables. For full database backups, please refer to Database Backup with Memory-Optimized Tables for the details and Creating and Managing Storage for Memory-Optimized Objects to get more in-depth...
  • Blog Post: Merge Operation in Memory-Optimized Tables

    In the Storage Allocation and Management for Memory-Optimized Tables , we had briefly touched upon the Merge operation. This blog describes Merge operation in detail. We also recommend you to refer to implementing durability for memory-optimized tables for a good understanding of data/delta files and...
  • Blog Post: Storage Allocation and Management for Memory-Optimized Tables

    As described in implementing durability for memory optimized tables , the storage requirements and its management for memory optimized tables is very different compared to the disk-based tables. If you are migrating a subset of your disk-based tables to memory-optimized tables or are just developing...
  • Blog Post: SQL Server 2014 In Memory OLTP: Memory-Optimized Table Types and Table Variables

    SQL Server 2014 In-Memory OLTP introduces two new widely advertised kinds of database objects: memory-optimized tables for efficient data access, and natively compiled stored procedures for efficient query processing and business logic execution. However, there is a third kind of object introduced by...
  • Blog Post: Improved Application Availability During Online Operations in SQL Server 2014

    SQL Server 2014 introduces enhancements to two common database maintenance operations namely Partition Switching and Online Index Rebuild which greatly increases enterprise application availability by reducing maintenance downtime impact. The following features are available in SQL Server 2014 CTP1...
  • Blog Post: Buffer Pool Extension to SSDs in SQL Server 2014

    How many of you have been looking into ways of cost effectively improving the performance of your OLTP workloads, without having to buy new more expensive hardware? Most of you know already that memory is one of the key assets available for the SQL Server and especially buffer pool memory, which plays...
  • Blog Post: ‘Wicked Fast’–Real World Experience with SQL Server 2014 In-Memory OLTP

    Recently Quentin Clark announced SQL Server 2014 during TechEd North America. One of the key features to be announced was the in-memory online transaction processing (OLTP) engine, which would complement the in-memory technologies which have been available in the data warehouse and analytics engines...
  • Blog Post: Hardware Considerations for In-Memory OLTP in SQL Server 2014

    In-Memory OLTP uses memory and disk in different ways than traditional disk-based tables. The performance improvement you will see with In-Memory OLTP depends the hardware you use. In this blog post we discuss a number of general hardware considerations, and provide generic guidelines for hardware to...
  • Blog Post: 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.com/releases/view...
  • Blog Post: SQL Server 2014 – Public CTP Now Available

    At TechEd North America we announced Microsoft SQL Server 2014 as part of a wave of updates to our key enterprise products. Today we are pleased to announce the availability of the first public Community Technology Preview (CTP) of SQL Server 2014 . This public CTP enables you to try and test many of...
  • Blog Post: SQL Server 2014 In-Memory OLTP: App Migration Scenario Leveraging the Integrated Approach

    As we emphasized in the previous blogs, with other in-memory technologies in the market today you have to migrate the entire database to memory or it's a separate database product that deals with in-memory, which means learning new APIs and dealing with application compatibility issues. Integrating in...
  • Blog Post: SQL Server 2014: Unlocking Real-Time Insights

    Today at TechEd North America we announced a wave of products and services that will help customers embrace the “enterprise cloud era.” The next version of our data platform – SQL Server 2014 – is a key part of the day’s news. Designed and developed with our cloud-first principles in mind, it delivers...
  • Blog Post: In-Memory OLTP: How Durability is Achieved for Memory-Optimized Tables

    In-memory OLTP provides full durability for memory-optimized tables. When a transaction that has made changes to memory-optimized table commits, SQL Server, just like it does for disk-based tables, guarantees that the changes are permanent and can survive the database restart provided the underlying...