InfoQ

InfoQ

Topic/Tag specific view

SQL Server Content on InfoQ


Latest featured content about SQL Server

Using MongoDB on Mono

Topics
MongoDB,
SQL Server,
Big Data,
Distributed Document Oriented Database,
Postgres,
SQL,
Mono,
Graph Database,
Relational Databases,
Database Management,
NoSQL,
Microsoft,
Database Design,
.NET,
Database,
Programming,
LINQ,
Companies

Justin Dearing presents a brief introduction to MongoDB, and focuses on interacting with it in Mono via the official 10gen driver. Techniques for handling business logic in application code, such as LINQ are discussed. This is a very code centric talk.

News about SQL Server

AWS Beanstalk For .NET, RDS For SQL Server

Topics
Amazon Web Services,
Amazon,
SQL Server,
IaaS,
.NET,
Relational Databases,
Microsoft,
SQL Server 2008 R2,
Database,
Companies,
Cloud Computing,
Amazon RDS,
Programming,
Amazon Elastic Beanstalk

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

Topics
SQL Server,
Microsoft,
Relational Databases,
.NET,
Programming,
Database,
Companies,
Hadoop,
PowerPivot

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

Topics
SQL Server 2012,
SQL Server,
Microsoft,
Relational Databases,
In-Memory Databases,
Database,
Companies

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

Topics
SQL Server 2012,
SQL Server,
C++,
Relational Databases,
Languages,
Microsoft,
Compilers,
Linux,
Operating Systems,
Database,
Companies,
Programming,
C

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

Topics
SQL Server 2012,
SQL Server,
Relational Databases,
Microsoft,
Companies,
Database,
PHP

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

Topics
SQL Server 2012,
SQL Server 2008,
SQL Server 2005,
SQL Server,
Relational Databases,
Unit Testing,
Microsoft,
Companies,
Database,
Testing,
TDD,
T-SQL,
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

Topics
SQL Server,
Relational Databases,
Microsoft,
Unit Testing,
Testing,
Agile,
Database,
Companies,
TDD,
T-SQL,
tSQLt

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.

Articles about SQL Server

Using Entity Framework to Successfully Target Multiple Databases

Topics
ADO.NET Entity Framework,
SQL Server 2011,
SQL Server,
SQL Server 2012,
ADO.NET,
MySQL,
Microsoft,
.NET,
Oracle,
Data Access,
Relational Databases,
Programming,
Database,
Companies,
SQLite,
ORM

Yevhen Shchyholyev discusses some of the problems that the user may face in the process of developing an application with Entity Framework that interacts with Oracle, MySQL, PostgreSQL or SQLite as well as SQL Server. It is intended to be useful to both developers using one of these databases for the first time as well as for those who regularly interaction with multiple databases.

SQL Server Reporting Services and Working with Overlay Data

Topics
SQL Server,
.NET,
Operations,
Relational Databases,
Microsoft,
Infrastructure,
Companies,
Programming,
SQL Server Reporting Services (SSRS),
Database

In this article, Grzegorz Gogolowicz and Trent Swanson tackle the problem of generating reports in SQL Server Reporting Services when the source is scanned images and other supplied formats yet a fixed layout report or pixel perfect report is the desired outcome.

Interviews about SQL Server

Bart De Smet on Reactive Extensions (Rx) for .NET and Javascript

Topics
Javascript,
Ruby,
CEP,
SQL Server,
Dynamic Languages,
Java,
QCon London 2011,
Web Development,
.NET Framework,
Business Process Management,
.NET,
Event Driven Architecture,
Functional Programming,
Languages,
Microsoft,
Relational Databases,
QCon,
SOA,
Business,
Enterprise Architecture,
Architecture,
Asynchronous Architecture,
Database,
Programming,
Companies,
Events,
Reactive Extensions,
Conferences,
Asynchronous Programming,
LINQ

Bart De Smet explains Reactive Extensions (Rx), a library for composing computations over asynchronous event streams of data for .NET and Javascript, the concepts and implementation of Rx and more.