SQL and the other technologies

I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is...

JSON Support Is The Best New Developer Feature in SQL 2016 — Part 2: Creating JSON

This is the second article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON.

Part...

Disabling #sqlprompt Formatting

I love SQL Prompt, especially the new formatting engine. However, it’s not perfect, and there are times I don’t want...

Pesky Percent File Growth

As DBAs we all know setting your file growth to grow by percent is not optimal.  It can cause all...

Hiring Productive Employees – #TAPtips

Starting a business is easy. Have an idea, some skills, a customer or two, and you are in business. However,...

My First SQL Saturday – As A Speaker!

I am so honored and excited to have been selected to speak at SQL Saturday Richmond on March 18, 2017.
I...

A Letter To A Younger Yates

Hello much younger Yates. Hope you’ve been doing well. Why don’t you pull up a chair and stay for a...

Join webinar on SQL Server 2016 Always on

Click [HERE} to Join webinar.
SQL Server 2016 - AlwaysOn
An availability group supports a failover environment for a discrete set of user databases, known...

SQL Server 2008 RTM - Maintenance Plans need Integration Services installed

The tail end of last week was a bit of a throwback week for me. For reasons that I’ll not...

Speaking at Techorama 2017

I’m delighted to announce that I’m selected as a speaker for the Techorama event.

Techorama is a developer congress focusing (but...