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

Stop PIPA & SOPA

I’m not going to black out my blog, because, let’s face it, who’s going to notice? But for all six...