Great article, thank you!

I think this sentence has a typo: "Now we have a Seek Predicate on DateAdded and a Predicate filter on DelFlag with a much-improved query cost (and...

I don't have a good reason for not having environment folders. I think it was just on oversight on our part.

Phil, thank you very much for taking the time to write these queries and I apologize for the delay in replying (works gets in the way of my fun :)...

• This reply was modified 4 years, 4 months ago by  Misha_SQL.

Thank you! We do all of our deployments via SSISB catalog (that's why I asked the question). I thought this was now the Microsoft-recommended way of doing things....

Thank you! We do all of our deployments via SSISB catalog (that's why I asked the question). I thought this was now the Microsoft-recommended way of doing things. We do...

Thank you for the article and sharing your code and research. While working on it, have you encountered solutions, which do similar things for the packages stored in SSISDB?  It...

Thank you for the article. I found it useful.

Listings 6 and 9 (it's the same code) are missing BEGIN TRANSACTION statement.

Can somebody comment on how this compares to using the T-SQL-t framework.  I have only a general idea about, but haven't used it in the real world.

We also ran into issues with SSISDB clean-up job once we had a large number of packages and executions. The built-in mechanism didn't work no matter how much we played...

Hello Pamela!  Thank you for the article.  I do have one question.  In the query, which collects the table row counts, you have this in the SELECT clause: SUM(ps.row_count) AS...

• This reply was modified 5 years, 3 months ago by  Misha_SQL.

This brought back some not-so-fond memories of working with Excel/Access and all their limitations. I guess I've been fortunate to be working with "real" databases over the last decade or...

I get a red squiggly line under this statement:
using System.Data.SqlClient;
the hint says "the type or namespace SqlClient does not exist in the namespace System.Data
Tried adding references to...

Great article.  Thank you for sharing your approach.
Can you explain the acrobatics done here.  I don't understand the reason for using tempList variable

foreach (string...

Great article, thank you!
P.S. If somebody would proofread it before publishing it would be even better :satisfied: