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

T-SQL Tuesday #121: Gifts Received This Year

Closing out 2019’s T-SQL Tuesday, Mala (blog | twitter) is asking us to reflect on the past twelve months:
This is a time for material gift giving, for many of...

How Serverless is Working in Azure SQL Database

When Azure SQL Database introduced the serverless option, I decided to try it. I moved one of my databases to the tier, though I had to move to a...

Install ALL Things SQL Server… What?

Does your server look like this? Many of us have inherited a SQL Server instance that has all SQL Services installed. Someone, maybe even you, went through the SQL...

Online, Resumable, and WAIT_AT_LOW_PRIORITY operations in SQL Server

ONLINE operations in SQL Server were simple to understand for years — we got ONLINE index rebuilds in SQL Server 2005. That was it for a while. Then, things...