InfoQ Homepage SQL Server Content on InfoQ
-
AWS Beanstalk For .NET, RDS For SQL Server
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
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.
-
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 Test Brings tSQLt Unit Testing to SQL Server Management Studio
SQL Test is the user interface for tSQLt, the open source unit testing framework for SQL Server. From the SQL Test window, users can create test classes, view existing unit tests, execute them, and view the results within a dockable panel 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.
-
What’s New in SQL Server 2012 RC0
Microsoft has released SQL Server 2012 Release Candidate 0. There are many new features, including: AlwaysOn, better performance management, more reporting and visualization tools, Columnstore index, and FileTables. The product will come in 3 main editions: Standard, Business Intelligence and Enterprise.
-
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.
-
Accelerate SQL Server Performance With SafePeak’s Dynamic Database Caching
SafePeak is a plug-and-play Dynamic Database Caching Solution, designed to improve data access performance for Applications built on SQL Server. It offloads the read queries and stored procedures which perform “Select” by dynamically caching in-memory result sets, thereby reducing read response time and overall database load.
-
.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.
-
Sync Framework Breaks Platform Barriers
Sync Framework Toolkit builds on the Sync Framework 2.1 and uses OData to sync with any platform or client, including Windows Phone 7, Silverlight, Windows Mobile, iPhone, iPad, Blackberry, Android devices, and any browser using HTML5.
-
SQL Server Bids Farewell to OLE DB After Denali
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.
-
31 Days of SQL Server Interview Questions and Answers
Pinal Dave has posted a 31-part series titled SQL Server – Interview Questions and Answers. It starts with general topics such as “What is Normalization?” and works its way to obscure topics such as “What is Difference between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE?”. Data warehousing is covered and there are even guest posts on SQL Azure.