Be a Social SQL DBA Superhero - #SQLHelp

Following up on my previous blog
on introducing the “Social DBA”, I spoke about the concept of leveraging
social networking to excel
in...

How we can convert Comma Separated Value to Rows and Vice Versa?

How we can convert Comma Separated Value to Rows and Vice Versa?
Basic fundamental

While we are working on reporting some circumstances...

A Long Trip Ahead

This is my last day at home for a long time. At least long by my standards. I head to...

A Long Trip Ahead

This is my last day at home for a long time. At least long by my standards. I head to...

SQL Server Contracting – The first 14 months (or so)

Crikey, where did that time go! I have been so busy adjusting to my new work life style I have...

TDE and Availability Groups

Caution must be exercised when mixing Transparent Data Encryption (TDE) and Availability Groups to ensure databases don't end up in...

Speaking at SQL Saturday #445 - Raleigh, NC - October 10

I will be speaking this weekend at SQL Saturday #445 - Raleigh, NC. If you are in the area, please come...

HOW WE CAN GET WHO IS CONNECTED TO DATABASE?

Some time we need to know that who is using database as of now or who all are connected to...

You DO have outstanding, free backup and maintenance, right?

It’s entirely possible that you’ve heard us talk about our supercharged, free backup and index maintenance solutions on Twitter, or on...

Get Hyper-V Host To Talk To Guest VM’s With This Simple Trick - Syndication – WaterOx Consulting

The Assumption I assume you already have a Hyper-V basic configuration on your system, be it a laptop, server or...