Security Architecture: Knowing the Adversary

When I present or teach on a security topic, I take the time to cover the mindset of the adversary....

Take a walk

When I need to clear my head, I go for a walk. When I need to think about a problem,...

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

Learning Through Blogging and Speaking

This post is a response to this month's T-SQL Tuesday prompt created by Mala Mahadevan. T-SQL Tuesday was created by Adam Machanic and is a way for SQL users...

Learning Through Blogging and Speaking

This post is a response to this month’s T-SQL Tuesday prompt created by Mala Mahadevan. T-SQL Tuesday was created by...

Power BI Custom Visuals Class (Module 80 – TreeViz)

In this module you will learn how to use the TreeViz Custom Visual. The TreeViz is a breakdown tree that...

Reducing the Number of Reads in Your Queries

In last week's post, we went over how one of best ways to improve query performance was to reduce the number of reads that your query has to do.
Less reads...

Reducing the Number of Reads in Your Queries

“A-Bridged” – reducing reads – get it?  I’m sorry you’re reading this.  Photo by Jamie Street on UnsplashIn last week’s post, we went over how...

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

SQL Vulnerability Assessment

A very interesting feature was recently added to SQL Server Management Studio 17.4 (SSMS): The new SQL Vulnerability Assessment.

What is...