InfoQ Homepage SQL Server Content on InfoQ
-
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.
-
Windows Azure Management Portal with Localization, Database and VM Enhancements
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
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
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
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
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.
-
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 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.
-
Code First Migrations Updates Data Structure From Code
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.
-
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.