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

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

T-SQL Tuesday #97 – We don’t need no Education! (or do we?)

TweetG’day,

 
Well, it’s T-SQL Tuesday time again  -the blog party started by Adam Machanic (blog | twitter) and this month hosted by Mala Mahadevan. This...

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

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

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

Creating a Knowledge Base Chat Bot w/ Azure Bot Service

A while back you may have caught my blog post introducing the Power BI Chat Bot 9000. Since posting that...

PaaS and the ever changing role of the DBA

I’ve never been a fan of a GUI for DBA work. Give me a hand crafted script or a list...

Microsoft to Decommission Connect on 12/31/2017

Microsoft will be decommissioning the Connect platform on 12/31/2017 due to privacy concerns and will be replacing it with a...

Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part B of 2: “Rabbit”)

(If you’re reading this on SQL Server Central, please click here to see the “Featured Image” which will help explain...