ISJSON() restriction in SQL Server 2016 and not in SQL Server 2017

You should have a database on SQL Server 2016 instance with an In-Memory file group so that you can create...

ISJSON() restriction in T-SQL 2016

Have a database on SQL Server 2016 instance with an In-Memory file group so that you can create tables with...

SQL Server Admin Best Practices with DMV's at SQLSaturday Pensacola 2016

Great attendance and awesome questions from my 1130AM session on "SQL Server Admin Best Practices with DMV's". As promised, all...

How To Get A Free SQL Server Indexing Book – Week 1

Free indexing books, awesome! Before I tell you how, lets start with what we are talking about here. If you weren’t aware, last summer I worked with Grant Fritchey...

How To Get A Free SQL Server Indexing Book – Week 1

Free indexing books, awesome!
Before I tell you how, lets start with what we are talking about here. If you weren’t...

Speaking on Consolidated Essential Performance Health Check using PowerShell - SQL User Group

Speaking on Consolidated Essential Performance Health Check using PowerShell - SQL User Group

Speaking on Consolidated Essential Performance Health Check using PowerShell - SQL User Group

Speaking on Consolidated Essential Performance Health Check using PowerShell - SQL User Group

Speaking on Consolidated Essential Performance Health Check using PowerShell – SQL User Group

Prakash will walk you through a centralized process using PowerShell where the key information collected, organized and sent via HTML formatted email, provides consolidated view of SQL server along...