BT
x Your opinion matters! Please fill in the InfoQ Survey about your reading habits!

Indexes in SQL Server 2014's Memory Optimized Tables

by Jonathan Allen on  Sep 24, 2013

SQL Server 2014’s Memory Optimized Tables handle indexes very differently than traditional tables. First and foremost, you must have at least one index and cannot have more than eight indexes. Only the primary key can be marked as unique and don’t even think about foreign keys or filtered indexes.

Lock-Free Writes in SQL Server 2014

by Jonathan Allen on  Sep 23, 2013

In SQL Server 2014 Microsoft will be unveiling its lock-free technology known as Memory Optimized Tables. Using a new storage and query subsystem, these represent a radical departure from traditional database design.

Database Lifecycle Management Guidance Updated by Microsoft

by Anand Narayanaswamy on  Apr 22, 2013

Microsoft recently updated database lifecycle management guidance page with SQL Server DLM diagram along with curated resources for SQL Server Data Tools, SQL Server Management Studio and Windows Azure SQL Database.

New Developer Tools for SQL Server, SharePoint, and Office

by Jeff Martin on  Mar 12, 2013

Microsoft updated several tools for developers targeting SQL Server, SharePoint, and Office. The Business Intelligence tools support analysis, integration, and reporting for SQL Server. The Office/SharePoint tools suite bring support for the 2013 versions of each and .NET Framework 4.5.

Brent Ozar on Improving Productivity with SQL Server

by Anand Narayanaswamy on  Feb 26, 2013

Brent Ozar, renowned SQL Server consultant recently shared few techniques for improving productivity with SQL Server.

Hadoop + SQL Server + Excel = Big Data Analytics

by Roopesh Shenoy on  Jan 24, 2013

Few months back, Microsoft announced HDInsight, Microsoft’s Hadoop distribution for managing, analysing and making sense out of large volumes of data. InfoQ connected with Val Fontama, Senior Product Marketing Manager for SQL Server, to know more about how the Enterprise Big Data @ Microsoft story is panning out.

Windows Azure Management Portal with Localization, Database and VM Enhancements

by Anand Narayanaswamy on  Nov 27, 2012

Microsoft recently released several enhancements to Windows Azure Management Portal with support for 6 additional languages, database improvements and enhancements for virtual machines and networking including support for operation logs.

Hekaton: In-Memory Transaction Processing Integrated with SQL Server

by Abel Avram on  Nov 09, 2012 2

During the PASS Summit 2012, a technical conference for SQL Server professionals, Microsoft announced Hekaton, an in-memory row-based data management system targeted at transaction processing (TP) workloads. Besides the advertised increase in TP speeds of up to 10x for old applications and up to 50x for new optimized ones, Microsoft touts Hekaton as being fully integrated into SQL Server.

Introducing SQL Server to MySQL Migration Tool from Oracle

by Anand Narayanaswamy on  Aug 21, 2012

Oracle recently announced a new migration tool, which provides an ability to quickly migrate data and applications from Microsoft SQL Server to MySQL with less time and effort. The migration tool which has been integrated into MySQL Workbench, allows visual design, development and administration of MySQL databases with an advanced logging and security mechanism.

Node.js Gets SQL Server Driver, Better Windows Tooling

by Roopesh Shenoy on  Jun 14, 2012

Microsoft continues to invest in Node.js, this time by introducing a new, open source SQL Server Driver and new Node-specific features in WebMatrix.

AWS Beanstalk For .NET, RDS For SQL Server

by Roopesh Shenoy on  May 11, 2012

Amazon has announced support for .NET on AWS Elastic Beanstalk and a new RDS service for SQL Server, bringing better manageability to .NET/SQL Server apps hosted on AWS.

Hadoop And Microsoft

by Roopesh Shenoy on  May 09, 2012

Want to try out Hadoop with the Microsoft Stack and figure out what capabilities this brings to you? We point to some resources that can help.

In-Memory Databases Reaching Tipping Point

by Roopesh Shenoy on  Apr 26, 2012 7

In-Memory Databases are very near to becoming widely adopted, says David Campbell of Microsoft in his article “The coming in-memory database tipping point”. He also explains Microsoft’s strategy around this space.

SQL Server Drivers for Red Hat Enterprise Linux

by Jonathan Allen on  Mar 14, 2012 7

Microsoft has released SQL Server ODBC drivers for the 64 bit version of Linux. These drivers are intended for C and C++ developers using Red Hat’s Enterprise Linux 5 and Enterprise Linux 6.

PHP Support for SQL Server LocalDb and SQL Server AlwaysOn Clusters

by Jonathan Allen on  Mar 11, 2012 5

2012 marks the fifth year since Microsoft started courting PHP developers. The popular language can be found in everything from their entry level IDE WebMatrix to the high-end cloud platform Windows Azure. SQL Server is a major part of the overall initiative and they are making sure the PHP drivers take advantage of SQL Server 2012’s new features.

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT