x Take the InfoQ Survey !
  • Big Data Solutions with MS SQL ColumnStore Index

    by Aleksandr Shavlyuga on  Oct 11, 2015

    Columnar data storage can offer significant performance improvements over the way database tables are traditionally stored, but they aren’t always faster. Aleksandr Shavlyuga explores the power, and limitations of SQL Server’s ColumnStore Indexes.

  • SQL Server Source Control and Deployment with Visual Studio

    by Jonathan Allen on  Nov 04, 2014

    The holy grail of database development is the ability to treat database objects (tables, views, stored procedures, etc.) as if they were just like any other form of source code. While SQL Server Data Tools doesn’t quite that level, it gets very close.

  • Introduction to Red Gate’s SQL Source Control

    by David Atkinson on  Oct 01, 2014

    It’s unthinkable for modern application developers to work without source control. The benefits it brings to software development are so well and so long understood that even lone hobbyist developers will tend to employ a source control system. Yet somehow, databases are often left out. David Atkinson shows how this doesn’t have to be the case with Red Gate’s SQL Source Control.

Testing SQL Server Code with TST

Posted by Roopesh Shenoy on  Jun 18, 2012

We explore the TST framework and a few ideas for writing and maintaining good tests for database code. 2

Using Entity Framework to Successfully Target Multiple Databases

Posted by Yevhen Shchyholyev on  Jul 25, 2011

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 and SQLite.

SQL Server Reporting Services and Working with Overlay Data

Posted by Grzegorz Gogolowicz and Trent Swanson on  Jun 11, 2009

Grzegorz Gogolowicz and Trent Swanson discuss how to work SQL Server Reporting Services and overlay data on report forms. 1

Book Excerpt and Review: Hitchhiker's Guide to Visual Studio and SQL Server

Posted by Jonathan Allen on  Aug 27, 2007

InfoQ has reviewed William Vaughn's Hitchhiker's Guide to Visual Studio and SQL Server. Also included is a sample chapter.

General Feedback
Marketing and all content copyright © 2006-2015 C4Media Inc. hosted at Contegix, the best ISP we've ever worked with.
Privacy policy