A detailed view into your Azure resources

I’ve been studying Azure recently and came across a really interesting Azure site.
resources.azure.com

To give you an idea why I find...

Checking Time Zones in SQL Server

I was building some basic queries around time zone manipulation and I am happy to say that I enjoyed myself...

Friday Reading 2017-01-13

Ahh, is it really Friday the 13th?!! So before Jason gets me, I’ll be reading…
A whole day of PowerShell & SQL

Join...

Installing the SQL Clone Agent and the VC++ Runtime

I was trying to get SQL Clone working recently and had an issue with the Agent. If you haven’t looked...

My Epic Life Quest

I have always maintained a private bucket list. I have not had the courage to actually put it down in...

New Pluralsight Course – LFCE: Advanced Network and System Administration

My new course “LFCE: Advanced Network and System Administration” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to...

New Pluralsight Course – LFCE: Advanced Network and System Administration

My new course “LFCE: Advanced Network and System Administration” in now available on Pluralsight here! If you want to learn about the course,...

New Video Cards

When I want to upgrade hardware, I usually turn to Glenn Berry for advice. He’s the person I know that...

Hold The Fort

Have you ever heard the phrase “Hold The Fort”? Long ago in battle supply routes were targeted by enemy regiments...

SQL Server: How to backup and replace text in all search string matching Stored Procedure(s)

Table of Contents
Problem Statement:-Solution:-Generate script for matching search string of all SP’s
Using sp_helptextUsing system view sys.proceduresGenerate modified SP’s scriptCreate Linked...