Strategizing your Index Maintenance in SQL Server

Index maintenance is part of the DBA’s life. Surely you have a maintenance task for this somewhere running daily or...

Azure Offerings Continue to Expand

We just received word of a bunch of new functionality over at Scott Guthrie’s blog. Not a lot of stuff...

Interviews with Great SQL People – Authors, MVPs, many more

I’m trying really hard to write a blog that goes over all the great #sqlpass interviews we’ve done, but work...

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

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

Reblog: September 20 to September 26

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...

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

I Just Voted in the PASS 2013 Election

I feel like it’s been a good election cycle. Good set of candidates, good discussions, lots of good blog posts...

Images, charts, indicators and sparklines in a tablix stretch and degrade report performance

This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...

Images, charts, indicators and sparklines in a tablix stretch and degrade report performance

This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...