Finding, disabling and enabling foreign keys

Foreign keys are a classic method of enforcing RI (Referential Integrity). Unfortunately though, they can get in the way if...

Monday Morning SQL Break – July 11, 2016

It’s Monday and time for this week’s blog and twitter round-up for last week.  I spent the weekend with family...

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

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