Is Your Database Overweight?

The obesity epidemic is much in the news these days. The list of health issues related to being overweight is...

The Value of Consistent Design

Yesterday I wrote about best practices, illustrating that what may be an assumed technical design standard doesn’t fit every scenario....

Understanding Keys and Certificates with Transparent Data Encryption (TDE)

I’ve been taking a bit of a deep dive into understanding Transparent Data Encryption (TDE). As part of that I’ve...

Power BI Custom Visuals Class (Module 81 – Social Network Graph)

In this module you will learn how to use the Social Network Graph Custom Visual. The Social Network Graph allows...

BK’s Professional Learning Plans for 2018 #tsql2sday

With 2018 coming, I’ve thought about the question, “What do I want to be when I grow up?” I ask...

T-SQL Tuesday #098–2018 Goals

A great topic for T-SQL Tuesday this time from @sqlmal. It’s Setting Learning Goals for 2018, and it’s a topic...

SQL Server Failed to Open Loopback Connection – What?

I could not read my error log on one of my local SQL Servers, when I executed the following code:

EXEC...

T-SQL Tuesday #97 – Setting learning goals for 2018

T-SQL Tuesday. Each month a different blogger hosts Adam Machanic’s (b/t) blog party. The host comes up with a topic...

When Best Practices Aren’t Best

Most everyone is familiar with the term best practices. This phrase describes an industry-specific design or methodology that can be...

The Eleven Days of Festivus 2017

Last year, I celebrated the holiday season by blogging daily during the 11 days leading up to Festivus, writing about...