BT

Facilitating the Spread of Knowledge and Innovation in Professional Software Development

Write for InfoQ

Topics

Choose your language

InfoQ Homepage SQL Server 2014 Content on InfoQ

News

RSS Feed
  • Atlassian Bamboo 5.11 Delivers Continuous Integration At Scale

    Atlassian, makers of development tools such as JIRA and Confluence, have just released version 5.11 of their continuous delivery tool Bamboo with a host of new features to help teams scale and collaborate. The key feature in this new release is the ability to scale from 100 to 250 elastic build agents.

  • Potential for Data Loss in SQL Server 2012 SP 2

    The second service pack for SQL Server 2012 was recently released with over 30 bug fixes since the last cumulative update. But according to Aaron Bertrand of SQL Sentry, one important hotfix for Enterprise customers didn’t make the cut.

  • Data Warehousing in SQL Server 2014 RTM

    SQL Server has been released to manufacturing with general availability set for April 1st. Through this week we’ll be covering various aspects of the new release starting with data warehousing.

  • Migration Analyzer for SQL Server’s In-Memory OLTP

    One of the biggest challenges when researching a new technology is determining where to start. A typical SQL Server installation could easily have hundreds of tables. Examining each one by hand to determine which would benefit from conversion, is a daunting challenge. This is where the AMR Tool comes into play.

  • Transactions and SQL Server 2014’s In-Memory OLTP

    In this report we look at the internals of SQL Server’s In-Memory OLTP to see how it uses timestamp-like transaction ids in lieu of locks.

  • Natively Compiled Tables in SQL Server 2014

    Originally this report was titled “Natively Compiled Queries”, but that doesn’t do justice to how deep this runs. When a memory optimized table is created, SQL Server will create a DLL specifically for that table. All data access for the table, including indexes, occurs through this DLL.

BT