More Denali Execution Plan Warning Goodies

In my last blog, I showed how the execution plan in denali has been enhanced by 2 new warnings ,conversion...

Microsoft and HP’s Database Consolidation Appliance

Microsoft and HP have announced another appliance, called the Database Consolidation Appliance (see my blog about the other two appliances). ...

3D Printing for Under $1000

I saw this about the iModela 3d printer, it’s priced under $1000, making it approachable if not quite cheap. 3d...

Moving to House of Brick

Starting Halloween Monday I will be a Technical Consultant for House of Brick Technologies.

To everyone out there saying "Didn't you...

Culture Posters

I work with a client now that had a poster made of the top 10 values for the IT department....

Announcing the fifth certification study session

The Denver SQL Server User Group is starting another round for the certification study group. Last year we ran three...

SQL Server – Moving table with LOB data to different file group

Last week, i posted about moving tables to different file groups by recreating indexes. However, this method does not *work*...

Next PASS Summit is Nov 6-9, 2012

After enjoying the entirely reasonable weather in Seattle in October this year we’ll return to our more traditional time frame...

JOIN IN SQL FAQ

1) What types of JOINS exist?
Inner Joins
Outer Joins (LEFT JOIN, LEFT OUTER JOIN, RIGHT JOIN, RIGHT OUTER JOIN, FULL...

Using sys.dm_exec_requests to find a blocking chain

A query that calls sys.dm_exec_requests and pulls the statement text out of the request is a handy script for any DBA's...