Visual Studio Magazine

Working with JSON in SQL Queries

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of. SQL Server 2016 provides ...
Visual Studio Magazine

Generating .NET POCO Classes for SQL Query Results

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...
Redmond Magazine

Exploiting SQL Server 2008 Through Code

SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code. SQL Server 2008 is mostly in the domain of system and database administrators ...
TechRepublic

Determine when to use stored procedures vs. SQL in the code

Determine when to use stored procedures vs. SQL in the code Your email has been sent Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one ...