Tips to Fix Database Consistency Errors – Reported By DBCC CHECKDB

Overview
While working on SQL Server, sometimes users get stuck in annoying situations when database become inaccessible. After executing DBCC CHECKDB...

Uninstalling SQL Server from the Command Line to Remove Unwanted Background Instances

I had a note (or ‘action item’) to make sure that people were informed regarding the ‘uninstall’ of SQL Server,...

Basic Statistics with SQL – Introduction

I was a student of statistics in school and college. I didn’t get to use much of anything I learned...

SQL Server – String_Escape function in SQL Server 2016

Hi friends, in SQL server 2016 another string function that introduced is String_Escape. This function can escape special characters within...

AlwaysOn Availability Group Database Level Health Detection – SQL Server 2016

SQL Server 2016 AlwaysOn AG got many improvements, and I’m pretty impressed with the log throughput improvements and redo improvements...

Converged virtual architectures and SQL Server licensing

Hyper-converged compute architectures, meaning clusters of physical servers with self-contained storage configured for a traditional SAN-less solution, are growing in...

Dallas, TX Fallen Officers Relief Fund

If you want to make a Donation to the Dallas, TX Fallen Officers Relief Fund, Please click this Link.
http://bluealert.us/

Influence Skills: Live from @LearningTree London Day 4

We've made it to the final day, day 4 of Learning Tree  course 294 Influence Skills: Getting Results without  Direct Authority.

Today...

Is Today Your Last Day Working With SQL?

Please entertain this thought for a moment – If today was your last day working with SQL how would you spend...

Join me for a free SQL Performance webcast on July 14th!

With less than we week away, I can say that I’m really excited to reach more people in the community...