There needs to be a win

A while back a company I worked for had two teams. One was a development team and the other was ... Continue reading

On the continuity of business

With entire countries shutting their borders, and people being forced to stay home and isolate themselves for as long as possible while health departments ramp up to handle this...

Telecommute Resources

This is a summary of potential resources for any tech person who is interested in working from home – temporarily or full time. It came about from a twitter...

T-SQL Tuesday #124 – Monitoring Query Store’s Impact on Your System

This month’s T-SQL Tuesday blogging party is brought to you well by me and I wanted to talk more about Query Store.  I did write a book on it...

"What did it take to become a MVP?"

@william_a_dba what did it take to become a MVP?— kennyb7322 (@kennyb7322) March 3, 2020

This tweet made me pause. I'll explain.Backstory (skip if you're not interested):On Sunday March 1,...

Modernizing Your T-SQL: Trimming Strings

This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server.
Last year, you finally retired the last of your SQL Server...

Modernizing Your T-SQL: Trimming Strings

This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. Last year, you finally retired the last of your SQL...

T-SQL Tuesday #124 – Query Store Summary

Happy St. Patrick’s Day (are you wearing something green)!  For March I asked everyone to blog something related to Query Store, here is a summary of in alphabetical order...

T-SQL Tuesday #124 Query Store and Spin Locks #tsql2sday

This month’s T-SQL Tuesday invitation comes from Tracy Boggiano  and she’s asking us to write about our experiences with Query Store. I thought about what I should write, I’m...

Azure SQL DB – An instance-specific error occurred while establishing a connection to SQL Server.

The full message when connecting to your Azure SQL Database is: Reason: An instance-specific error occurred while establishing a connection to SQL Server. The public data endpoint on this...