Looping through multiple servers in SSIS Part 3

Over the last couple of weeks I’ve set up a SSIS package that will loop through a group of servers...

Defaults

Looping through multiple servers in SSIS part 2

Last week I posted a quick example of looping through multiple servers using SSIS and being in a bit of...

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