Everyone, who deal with SQL server, know sample database AdventureWorks, which has been with us since the days of SQL Server 2005. Most of official SQL Serve...

The @@SERVERNAME Global Variable The system global variable @@SERVERNAME can be used to return the name of the machine the SQL Server is hosted on. This var...

In this video, I show how to enable live query statistics in SQL Server 2016 in order to see execution flow for running queries, and how to watch the live ex...

Last week I presented my session, SQL Server 2016 for Performance Tuning Lovers at the GroupBy conference. That was tons of fun and actually felt more like a...

On November 9th I presented a session in the PASS Database Administration Virtual Chapter. The title of the session was “SQL Server DBA Tips that Can Save Yo...

Yesterday I presented my session From XML to JSON as part of the 24 Hours of PASS online event. There were around 200 attendees in my session. If you are one...

SQL Server 2016 offers built-in support for JSON, in a similar way to the support offered for XML since SQL Server 2000. Both XML and JSON are semi-structure...

This post is for T-SQL Tuesday, hosted by Michael Swart (blog | twitter). This month’s topic is all about SQL Server 2016 I’ve been working with SQL Server f...