InfoQ Homepage SQL Server 2012 Content on InfoQ
News
RSS Feed-
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.
-
Hadoop + SQL Server + Excel = Big Data Analytics
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.
-
In-Memory Databases Reaching Tipping Point
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
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
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.
-
SQL Server Unit Testing with tSQLt
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.
-
SQL Server Integration Services 2012 to Include ODBC Support
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.
-
Amazon/Microsoft Deal Expanded to Include BizSpark and SQL Server 2012
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.
-
.NET Framework 4 Now Supports LocalDB
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.
-
'Denali' No More: SQL Server 2012 Announced, Focuses on BI and Big Data
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.