Patching SQL Server and SSMS? Order matters.

If you’ve been living under a rock, you may not have noticed how frequently SSMS is getting updated. The SQL...

Two Ways to Restore Database from MDF File in SQL Server

Introduction
In todays decade Relational database Management system became the necessity of the organizations whether they are small level or large...

Using Merge–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Working with Very Large Tables

 
Recently I presented an online session with the title “Working with Very Large Tables Like a Pro in SQL Server 2016”....

PSDay.UK Tickets are on sale

Following a lot of hard work by the organising folks Gael Colas, Ebru Cucen, Daniel Krebs and Johnathan Medd, we...

Building Your Brand and Becoming a Thought Leader Session Materials

Thank you to everyone that attending my session today at SQL Saturday #649 in Jacksonville, Florida! It was a packed...

DevOps Basics–Git log

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Help! I'm stuck in Single User Mode and can't get out!

So, here’s a silly little take on a serious end-user issue where no-one could access the production database.

Got a call...

Just Say No to Social Engineering Memes

These memes, from a security and privacy perspective, are nothing but trouble. Here’s an example I just saw a friend...

Microsoft Azure – How to create a virtual machine (VM) with Reserved Public IP (VIP)

In my previous blog, we learnt that a Virtual IP (VIP) get lost or changed when we stop or deallocate...