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.
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.
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.
We explore the TST framework and a few ideas for writing and maintaining good tests for database code. 2
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.
Grzegorz Gogolowicz and Trent Swanson discuss how to work SQL Server Reporting Services and overlay data on report forms. 3
InfoQ has reviewed William Vaughn's Hitchhiker's Guide to Visual Studio and SQL Server. Also included is a sample chapter.