Do I have a Database Master Key in a database? #SQLNewBlogger

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

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

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

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

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

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

Vote for @SQLBits Sessions (pick me, pick me)

The SQL Bits sessions are out and it’s time to vote for me. Well, vote for the sessions you’d like...

Why won’t my SQL Logins work?

I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a...

Using the PowerShell SQL Provider with SQL Authentication

Whilst having a conversation with Chrissy LeMaire last week about using the SQL Provider. She asked if it could use SQL...