SSIS doesn't do a great job of logging by default.

These might help:

• https://stackoverflow.com/questions/23962767/ssis-script-component-or-script-task-write-to-job-history-log
• https://www.sqlservercentral.com/forums/topic/job-history-logging-for-ssis-pkg-jobs

I haven't ever used registered servers much, but I can see how I might use this in a larger environment, especially the grouping. In today's cloud world, this could be...

I'm not a system administrator, so forgive me for not understanding the nuances of why some servers would be down days after the fact.

According the Microsoft: https://support.microsoft.com/en-us/topic/kb5042421-crowdstrike-issue-impacting-windows-endpoints-causing-an-0x50-or-0x7e-error-message-on-a-blue-screen-b1c700e0-7317-4e95-aeee-5d67dd35b92f

If fixing...

I assume SQL 2019 for David, but I do think it's hard to regression test. I don't know how many of us have a decent set of things to test...

Sorry, typo. Meant to include the proc name in the question. Points awarded back

As I understand it, this...

IT often gets compared negatively with physical engineering, but we should remember that people have had centuries more practice at buildings, bridges, etc. yet we still have tragedies like...

...

As a bonus for the 'quick turnaround', one of the co-owners/vice president of the company gave me two weeks paid time off and round-trip tickets for my wife and...

Not well tested and not deployed in rings. Basic failures of software development.

Daniel, send a PM to SQLDCH with your Yahoo ID so he can invite you

Daniel, send a PM to SQLDCH with your Yahoo ID so he can invite you

Does this help?

https://www.sqlservercentral.com/forums/topic/how-to-find-dts-package-name-from-job-step#:~:text=extract%20your%20DTSRUNDESC.exe%20file,the%20Package%20name%2C%20server%20Name.

Congrats, Paul. I'll reach out to see if anyone is interested.

I had 65 minutes yesterday in Houston. A 35 minute delay in Denver had me running through the airport to make a flight in another terminal before the doors closed....

Serverless is great, because it can autoscale, so you can say 4-8 CPUs rather than provisioning 4 or 8. However, if it turns off, you need good retry logic. The...