Three Engine Improvements in SQL Server 2008 R2 (Updated)

The upcoming release (by May 2010) of SQL Server 2008 R2 has been primarily focused on enhancements in the BI...

Three Engine Improvements in SQL Server 2008 R2

The upcoming (by May 2010) of SQL Server 2008 R2 has been primarily focused on enhancements in the BI area...

Reflections on ‘Visibility, the Art of Being Noticed’ by Phil Factor

If you have not read the Master of Phrenetic Phoughts’ article, please do so here. I enjoyed very much the...

Key Discovery III

Recursively traverse system views to build a Hierarchical Perspective into the database.
Related Posts:

T-SQL Tuesday Participation Over the Years December 19, 2018

T-SQL Tuesday #104: Just Can't Cut That Cord...

Key Discovery III

In Part I and Part II of the series, I discussed documenting and discovering Primary Keys and Clustered Indexes.  In...

Providing Online Help for Powershell Modules

As a finishing touch for the SQL Server Powershell Extensions 2.0 Release I wanted to provide an online version of...

Identities and Transactions

I talked a little recently in a blog about gaps in identity values. They can occur when you delete rows,...

Some BI Related Official Microsoft SQL Server Blogs

My other Microsoft blog list was more focused on relational database administration and development, so here is my list of...

Some BI Related Official Microsoft Related SQL Server Blogs

My other Microsoft blog list was more focused on relational database administration and development, so here is my list of...

SQL Saturday #34 Wrap-up

Whew!
It’s over. New England Data Camp v2, aka, SQL Saturday #34, was completed on Saturday. Going in we had maxed...