Balancing Security Concerns.

I have a presentation I do every now again on security basics that I’m actually quite proud of. One of...

SQL .NET Requirements

SQL Server Install Requirements

SQL Server Installation requirements indicate .NET 3.5, 4.0, or 4.6 depending on the version. This is not including SSMS. At this point you shouldn’t use SSMS...

Finding Inconsistent Key Values–#SQLNewBlogger

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

Performance as a feature, software developer edition

Relational database management systems (RDBMS) like SQL Server and Azure SQL Database are very good at managing normalized data. Efficient...

What the Microsoft MVP Award Means to Me in 2018

I recently received my seventh “Most Valuable Professional” award from Microsoft. Oddly, I don’t think I’ve ever written about what this award means to me until this point. In...

T-SQL Tuesday #104: Just Can’t Cut That Cord

We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. In this article, I share with you a poor mans...

T-SQL Tuesday #104: Just Can’t Cut That Cord

We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. Some...

T-SQL Tuesday 104 – Capture expensive queries with query store

For this month’s T-SQL Tuesday Bert Wagner invites us to share SQL scripts we’ve written that we’d hate to live...

MVP Status: Renewed

On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they feel have made a significant difference in their development...

MVP Status: Renewed

On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they feel have made a significant difference in their development...