Containers are just around the corner for the Windows community, and this article takes a closer look at using SQL Server containers. The author discusses the value, use cases, and means for taking advantage of SQL Server containers today.
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, yet somehow, databases are often left out. But it doesn’t have to be that way.
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.