ExpressProfiler: Yet another "when and why" story.

Core of ExpressProfiler  was born about 8 years ago when I worked for a company whose mission was the migration...

Introduction to Latches in SQL Server

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...

Last Weeks Top “Reading” Links #89

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Plagiarism: A Community Destroyed

Personal Thoughts

Just to be clear, I don't expect everyone to have my same thoughts. I personally fully support SQLServerCentral and...

Reading, Writing, and Riskmetic-Question of the Day

Reading, Writing, and Riskmetic is another Question of the Day, this one about how to allow developers to understand performance...

sp_SrvPermissions & sp_DBPermissions V5.0

These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures...

SQL Server 2012 || Contained Database

Contained databases are the new feature in SQL Server 2012 and are defined on BOL (http://technet.microsoft.com/en-us/library/ff929071.aspx) as below :
A contained...

SSC Editorial: Bad Meetings or Meeting Badly

Bad Meetings or Meeting Badly is the editorial of the day today. Looking at it today, I wish I had...

The Curse of Relational Databases

Let’s face it, none of Information Technology is easy. Oh yeah, there are those few geniuses that have an absolute...

Using PowerShell to Build your Azure VM Environment

In a previous post I wrote about Using a Hyper-V VHD in an Azure VM. Today I’d like to show...