Adding Extended Properties to a Table

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

FOR JSON Clause With INCLUDE_NULL_VALUES Option In SQL Server 2016

Hi folks, Today we learn how to format query using FOR JSON clause with INCLUDE_NULL_VALUES option in SQL Server 2016....

How to drop a Temporal Table

No no, I didn’t say temporary, but temporal! SQL Server 2016 introduces a great new feature called Temporal Tables. Or...

Making Changes to Many Forms In Access

Although generally I prefer to create custom interfaces for my databases using fully developed programming languages like Python or C#....

Run SQL Server In A Container Today July 2015

Containers are one of the big things at the moment, Microsoft has recently announced that they will be bringing official...

Speaker of the Month: June 2015

With my travel schedule, I don’t always get out to events where I can see a community speaker. Sometimes, I...

Speaking engagements for August and September

August and September are going to be some busy weeks!

In those two months I will be speaking on three SQLSaturday...

Zero to Speaker pt 2

A few months ago I wrote a post about the fact that I had actually submitted a session to PASS...

Backup Compression - Native vs Redgate

Many of the companies are using third party backup software for SQL server in order to help to reduce their...

FOR JSON Clause With PATH Mode In SQL Server 2016

In previous blog we learnt about changing query format using JSON clause with AUTO mode option. In this blog we...