Installing SQL Server: Video Tutorial

In this video I talk you through installing SQL Server 2017 RC1 on Windows Server 2016 virtual machine. It’s a...

Monday Coffee: SQL Services in Containers

I had an interesting question on twitter last week when I published my post on Running Linux Container on Windows:...

Point Counterpoint: Why Virtualize a SQL Server?

I get asked all the time – “why virtualize SQL Server if I’m content with my physical servers today?” The normal...

RegEx in SQL Server for searching text

As a database developer or DBA, or even software developer, you must have met up with the difficulties of finding...

RegEx in SQL Server for searching text

As a database developer or DBA, or even software developer, you must have met up with the difficulties of finding some strings/sub-strings in the text columns. In such situations,...

RegEx in SQL Server for searching text

As a database developer or DBA, or even software developer, you must have met up with the difficulties of finding some strings/sub-strings in the text columns. In such situations,...

SQL Summer Vacation–SentryOne

We are having an extra Louisville SQL Server and Power BI User Group meeting this month due to the SQL...

Sudden Differential Backup Failures after an Availability Group Failover

As so many stories do, this story starts with a failover - in this case an Availability Group (AG) failover.
https://cdn.meme.am/cache/instances/folder984/400x/59300984.jpg
There were...

Think twice before using table variables

T-SQL Tuesday

For T-SQL Tuesday this month Raul Gonzalez has asked us all to blog about lessons learnt the hard way:
http://www.sqldoubleg.com/2017/07/03/tsql2sday-92-lessons-learned-the-hard-way/
My...

Upcoming Content

This is the reality of learning newer tech somewhat in depth and working with it. What this series of posts...