Transactions: Creating a single restore point across multiple databases.

This is a disaster and recovery trick I’ve found to be useful for developers with batch processes that hit multiple...

Dating Tips Part 1

This is the first in a series of dating tips, so if you need you’ve come to the right place.

...

Master Data Services for the Beginner Part 05

 
Introduction
In yesterday’s discussion we looked at creating a current flag, creating views and looking at some of our data.  Today...

Some Great Big Data Sources

What kinds of data are exciting to you? Census and government data? Zombie Data? Marvel Comics? Time and time again...

Famous Move Quotes–Visualized

Ran across this poster of movie quotes – $20 will get you a copy. Why might you be interested? The visualizations...

Friday Followup For January 31, 2014

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

Honored to be added to SQLRockstar’s SQL Server blog rankings

Today I woke up to find that Thomas LaRock (blog | twitter | linkedin) has added me to his SQL Server Blogger...

Master Data Services (Second Edition) – Review

For the preparation of my upcoming talk about SQL Server 2012 Master Data Services on the Microsoft Business Analytics Day...

My Visual Studio crashed and I didn't know why!

Recently I had to develop a simple ETL task with the help of SSIS to transfer an Excel data file...

PowerShell – Memory Details GUI Tool

This Powershell Memory GUI tool is used to fetch memory information from a computer. In the screen that follows, enter...