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

Everyone wants faster database queries, and both SQL developers and DBAs can turn to many time-tested methods to achieve that goal. Unfortunately, no single method is foolproof or ironclad. But even ...

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...

Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the ...

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

Multiple Detail Records - 4 in this case. (linked to the header record) Multiple Inventory Records - again, 4 - (each detail record points to one specific inventory record, but the inventory may be ...

Why is the language developers and DBAs use to organize data such a mess? Here are 13 reasons we wish we could quit SQL, even ...

The indexes on a the tables of a large database make a huge difference in its performance and utility. Without an index, locating a single record in a large table can take several seconds; with the ...