AdventureWorks2012 Bug on Azure

While I have production databases in Azure, I can’t exactly experiment with them at will. Further, while they mostly have...

It’s Election Season

It’s that time of the year again – time to make your voice heard as a PASS member.  The PASS board...

I’m Voting for Allen Kinsel

As you can see from the title of this post, I’ve decided on one of the three votes I’ll be...

Microsoft + Oracle = New opportunity…Windows Azure is a happening place !

Couple of months back(To be specific in June) Microsoft and Oracle announced their partnership to help enterprise customers embrace the...

List all mapping users of SQL login account

Find a useful system store procedure to list all mapping user of SQL login account.

sp_msloginmappings @Loginname , @Flags
@loginname: the login account name, If...

PASS BoD Election Questions – Summit location

As you may have seen in my post yesterday “PASS Board of Directors Election: Candidates announced” I am running for...

Can You Compress a Temp Table?

 Hello Dear Reader!  We are finishing up the final day of the Performance Tuning Workshop here in Atlanta and I...

SQL Server Diagnostic Information Queries for September 2013

I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...

PASS BoD Election Questions – Global Vs Local

As you may have seen in my post yesterday “PASS Board of Directors Election: Candidates announced” I am running for...

Data Warehouse vs Master Data Managment

Sometimes I see confusion on the difference between a data warehouse (DW) and master data management (MDM).  Below is a...