Applied SQL: Find and replace using regular expressions in SSMS

Regular expressions are searches on steroids, the wildcats of the wildcard world*.  Even if you  never ever write CLR, regex...

T-SQL – Monitoring DiskSpace of Multiple Servers

This post talks about step by step approach to capture the disk space using T-SQL. This is a request from...

The DBA That Practices Database Restores

We are often told that we need to practice our restores. And it might not be obvious, but the reason...

Reblog: January 3 to January 9

Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...

The SQLSaturday Wiki–Revisited

I saw a discussion on Twitter yesterday where Kendal Van Dyke referenced the SQLSaturday wiki as a resource, I thought...

Schedule Time To Review Your Passwords & Using a Password Manager

I use a password manager and it currently has more than 150 accounts in it, ranging from my checking account...

SSRS – Identify a scheduled SSRS Report

Initiating subscription is a tedious task in SQL Server Reporting Services. Each subscription in Reporting Services is setup as a...

How To Campaign For the PASS Board

Let’s say you’ve decided to run, good! What do you do next? I’m not going to give you a blueprint...

Friday Followup For January 10, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

Answer -Question of the Week - 2/1/2014 - Question 1

Question :-

Suppose we have to design a database in which employees can work on multiple projects.There are many designation defined...