While SQL Server introduced support for JSON data in SQL Server 2016, it relied on using the non-optimized NVARCHAR (MAX) data type.

PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...

Melissa has a variety of tools available to clean, validate and enhance the Contact dimension in your SQL Server data warehouse. Specifically, Melissa's suite of SSIS Data Quality Components can be ...

Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types.