Why Would I Want to Use JSON in SQL Server?

SQL Server 2016 offers built-in support for JSON, in a similar way to the support offered for XML since SQL...

DAX Date Dimension and Fun with Date Math

I was working on a SSAS Tabular 2016 solution for a project for which I had no data (an empty...

How to Resume Suspended Database Mirroring in SQL Server ?

Overview
Database mirroring is a feature in SQL Server which is creating and maintaining the redundant copies of the database. The purpose behind database mirroring is continuous data availability and...

How I Got Here: Microsoft

Here we are, 7 years working with SQL Server and Microsoft BI tools. Sure in the grand scheme of things...

SQLMonitor Adds Graphical Query Plans!

The SQLMonitor team at Redgate has been releasing updates at a much more rapid rate…what’s this mean to you? More fixes and more features. In this latest release, they...

SQLMonitor Adds Graphical Query Plans!

The SQLMonitor team at Redgate has been releasing updates at a much more rapid rate…what’s this mean to you? More...

TGI SQL Friday - Weekly Roundup 2nd September 2016

Weekly Summary
Last week I was holiday in Cyprus. The weather was plus 30 degrees celsius all week. The pool was...

CHECKDB is slow!

Running the usual consistency checks on a database (with a new release code applied from an ISV) I noticed slower...

Default Sessions – Back to Basics

With the evolution of SQL Server, there is an evolution in Extended Events. New features in SQL Server also means there may be some additional default sessions.
Related Posts:

Changing Default...

Importance of Database Backup In SQL Server

Overview To save any organisation from any big future loss, one needs make a proper strategy or disaster plan that...