Monthly Archives: October 2012

  1. Looping through multiple servers in SSIS

    12

    October 31, 2012 by Kenneth Fisher

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

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

    3

    October 26, 2012 by Kenneth Fisher

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

  3. I can connect to my instance locally but not remotely

    2

    October 23, 2012 by Kenneth Fisher

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

  4. fn_OBJECT_TYPE

    4

    October 19, 2012 by Kenneth Fisher

    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 …
    Continue reading

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

    1

    October 15, 2012 by Kenneth Fisher

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

  6. Multiple CTEs

    9

    October 9, 2012 by Kenneth Fisher

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

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

    1

    October 5, 2012 by Kenneth Fisher

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

  8. When I get stumped I ….

    2

    October 2, 2012 by Kenneth Fisher

    I work with a reasonably large team of DBAs.  There are 9 of us and we support not only 70+ …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,597 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013