Deployment of Microsoft SQL database with Azure DevOps

Hello, data folks! I have published several articles about databases and their maintenance in SSDT project on the blog. One of the posts explained step by step how to...

Session Evaluations from “SQL Server Security from the Ground Up”

I was recently given the opportunity to speak at Pass Summit. As always (this is the second time) this was ... Continue reading

SSMS Tip: Beep When Query Completes

I’m old enough to remember when multitasking was considered a good thing. From the same mouths that brought you “work smarter, not harder” came the advice to always be...

The Eleven Days of Festivus 2019

The weather is turning cooler, there is holiday music everywhere, and the relatives are all excited to get together and talk about politics. That can only mean one thing:...

Who needs data access? Not You!

With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.
Related Posts:

When Too Much is Not a Good Thing December 13,...

A guide to acronyms, abbreviations, and other technical terms

Here’s a list of some technical terms, acronyms, and abbreviations you may have heard, and what they mean. Some of the definitions are taken from Wikipedia. This list is...

Error message: http://System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.

I love this error. Primarily because it demonstrates two very important things. Errors matter. Make sure when you ask someone ... Continue reading

Information Measurement with SQL Server Part 4.7: The Bhattacharyya and Hellinger Distances

By Steve Bolton …………Over the course of this segment of the series, we’ve slowly assembled a classification system for some distances measures that can be used for DIY data...

Reflection on Talking at SQLSaturday Charlotte About Mental Health

On December 7, I did a session on mental illness and mental health problems being more common in IT than you think. Before the event the PASS WIT Virtual...

Reflection on Talking at SQLSaturday Charlotte About Mental Health

On December 7, I did a session on mental illness and mental health problems being more common in IT than you think. Before the event the PASS WIT Virtual...