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

Watch this recorded webinar where Microsoft MVP Steve Endow demonstrates some simple techniques that mere mortals can use to diagnose and optimize SQL Server queries. Topics include identifying ...

SQL Server Management Studio (SSMS) is the tool of choice for most developers when managing SQL Server and the relational data stored in it. Microsoft recently outlined plans for SSMS 22, currently in ...

Although there was significant fanfare surrounding SQL Server Query Store's initial release in SQL Server 2016, many companies have been hesitant about adopting the performance monitoring and ...

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...