Dedicated Administrator Connection

Recently you may have read my article about some hidden functions in SQL Server.  In that article you learned that those functions were in some DMOs and that you...

Dedicated Administrator Connection

Recently you may have read my article about some hidden functions in SQL Server.  In that article you learned that...

SQL Server – Powershell Excel to HTML

SQL Server, Powershell and Excel are a good mix . But saving to Powershell output to HTML is versatile – if requiring...

Master Data Services 2012

As I mentioned in a pervious post Master Data Services for SQL 2012 is a huge improvement over the SQL...

Update Statistics and the new TraceFlag 2371

What comes first, the chicken or the egg? What happens first – update statistics or re-compilations?

The Statistics life cycle
As a regular...

Blackout

What more can I say.  I disagree with the kind of legislation that is being presented via SOPA and PIPA. In support of the community, my site will be...

Blackout

What more can I say.  I disagree with the kind of legislation that is being presented via SOPA and PIPA.
In...

Why It’s Called a User Group…

On Tuesday night was the first meeting for PASSMN, the SQL Server User Group in Minneapolis/St. Paul this year.  As...

SQLInspire NYC 2011 Videos available

There are some FANTASTIC videos of the sessions from SQLInspire New York 2011.  I highly recommend that you check out...

Blackout

It’s anti-SOPA/PIPA day, and a number of sites have shut down for the day. O’Reilly closed their page, and of...