Hiring Productive Employees – #TAPtips

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

How to Count the Total Number of Rows Across Multiple Tables

I have been working on SQL Server Consulting assignment,  a SQL Server 2014 migration for a new client over the...

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...

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...

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...

Pesky Percent File Growth

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

Power BI Custom Visuals Class (Module 35 – Box and Whiskers (Jan Pieter))

In this module you will learn how to use the Box and Whiskers (Jan Pieter) Power BI Custom Visual.  This...

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...

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...

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...