Detaching a database

In my general quest to figure out the T-SQL to do common GUI tasks I did some browsing through BOL...

Monday Night Networking at the 2013 PASS Summit

For the fourth year Steve Jones and I are hosting an informal networking dinner on Monday night at the PASS...

Houston Tech Fest 2013

I am traveling (driving) with the family to Houston to present on SSIS 2012 at Houston Tech Fest 2013 at...

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