Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text

I’ve been working on a way to test performance usage on a server by database. I started out using sys.dm_exec_query_stats...

A review of Knight’s 24-Hour Trainer Microsoft SQL Server 2008 Integration Services

About three years ago my manager came up to me and said “We need someone to learn SSIS, you’re it.” ...

Looping through multiple servers in SSIS

This is just a quickie post to answer a question on how to loop through multiple servers in SSIS.  There...

How do I find all stored procedures or views that use a specific table?

Many years ago when I was still working on SQL 2000 I occasionally needed to find all stored procedures and views...

I can connect to my instance locally but not remotely

Every now and again (today for example) I’ll get a call that one of our SQL Server instances is down. ...

Changing Identity Columns

fn_OBJECT_TYPE

I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist...

A review of SQL Interoperability / Joes 2 Pros Volume 5 by Rick A Morelan

I recently passed my MCTS 2008 Development (70-433).  Yay me!  That made my 3rd 2008 certification.  This one was probably the...

Multiple CTEs

Multiple CTEs
It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you can...

Active flag on the TCP/IP Properties page of SQL Server Configuration Manager

I’ve been unable to connect to a server via one of its aliases for about a week.  When I looked...