BT

Your opinion matters! Please fill in the InfoQ Survey!

Followers

Potential for Data Loss in SQL Server 2012 SP 2

by Jonathan Allen Follow 244 Followers on  Jun 12, 2014 1

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.

Followers

Hadoop + SQL Server + Excel = Big Data Analytics

by Roopesh Shenoy  Followers on  Jan 24, 2013 5

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.

Followers

In-Memory Databases Reaching Tipping Point

by Roopesh Shenoy  Followers 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.

Followers

SQL Server Drivers for Red Hat Enterprise Linux

by Jonathan Allen Follow 244 Followers on  Mar 14, 2012 3

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.

Followers

PHP Support for SQL Server LocalDb and SQL Server AlwaysOn Clusters

by Jonathan Allen Follow 244 Followers on  Mar 11, 2012

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.

Followers

SQL Server Unit Testing with tSQLt

by Jenni Konrad  Followers on  Feb 10, 2012

tSQLt is a free, open-source framework for unit testing in SQL Server. By writing tSQLt test cases, developers can create fake tables and views based on production data, then compare expected versus actual results. Tests can be created directly in SQL Server Management Studio.

Followers

Code First Migrations Updates Data Structure From Code

by Jenni Konrad  Followers on  Dec 02, 2011

The Code First approach means that the object model is created in code, and then the database structure is generated from that model. Code First Migrations allows developers to make changes to the database via code, many of which can be done automatically.

Followers

SQL Server Integration Services 2012 to Include ODBC Support

by Jonathan Allen Follow 244 Followers on  Nov 25, 2011

With SQL Server abandoning OleDB in favor of ODBC, it is no surprise that SQL Server Integration Services is finally picking up ODBC support. Another important feature slated for SSIS 2012 is the much needed support for CSV files.

Followers

Amazon/Microsoft Deal Expanded to Include BizSpark and SQL Server 2012

by Jonathan Allen Follow 244 Followers on  Nov 08, 2011

Amazon has announced two licensing deals with Microsoft. The first eliminates the licensing fees for running Microsoft software on EC2 for BizSpark members. The second allows all developers to run the preview of SQL Server 2012 on EC2. It should be noted that normal EC2 service rates still apply for both.

Followers

.NET Framework 4 Now Supports LocalDB

by Abel Avram Follow 4 Followers on  Oct 29, 2011

Microsoft has added LocalDB support in .NET Framework 4. LocalDB is a free developer edition of SQL Server “Denali” meant to provide most of the server’s API but without management overhead.

Followers

'Denali' No More: SQL Server 2012 Announced, Focuses on BI and Big Data

by Jenni Konrad  Followers on  Oct 21, 2011 1

Microsoft announced that the next version of SQL Server, known by the codename "Denali", will be called SQL Server 2012. It will feature the big data capabilities of Apache Hadoop and Power View, a touch-based business intelligence tool.

Followers

ORM Profiler Analyzes Data Access Performance

by Jenni Konrad  Followers on  Oct 14, 2011

Solutions Design has released ORM Profiler, a tool meant to help improve data access layer performance. It tracks and logs ADO.NET calls so that developers can analyze their data access and discover potential problems.

Followers

SQL Server Bids Farewell to OLE DB After Denali

by Jenni Konrad  Followers on  Sep 01, 2011

Denali will be the final edition of SQL Server to support OLE DB, because Microsoft considers ODBC to be the industry standard for relational data access.

Followers

Visual Studio Gets Better SQL Server Tooling – ‘Juneau’

by Roopesh Shenoy  Followers on  Jul 30, 2011

SQL Server Development Tools (SSDT) - ‘Juneau’ - brings testing, debugging, version control, refactoring, dependency checking, and deployment to database development in Visual Studio. It was previewed recently along with SQL Server ‘Denali’ CTP.

Followers

SQL Server Denali’s FileTable: Turn SQL Tables into Folders

by Jenni Konrad  Followers on  Jul 28, 2011

SQL Server Denali includes a new type of table called FileTable, which builds on FileStream functionality. FileTable is meant for storing and managing unstructured data in SQL Server, while also making it accessible via the file system.

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT