SELECT getdate() AT TIME ZONE 'Eastern Standard Time';

If you are using the Integration Services Catalog - then you have access to the All Executions report which will show you how long each task takes when the package...

Even with a secondary setup in asynchronous mode - transactions need to be hardened on that secondary before they can be marked for reuse on the primary.  They can (and...

You can setup the agent job to send notification on completion - you don't have to add a job step and use sp_send_dbmail.  Database Mail does need to be setup...

Yes, you're correct. In fact, as a developer, I always aim to write code without using any UDFs in the statements. However, in my scenario, we had a lot...

Start here: https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftRdlcReportDesignerforVisualStudio-18001

This will at least get you the components to be able to design/develop the RDLC reports.  I am guessing that from here you can find tutorials and help.

I've been revisiting some older textbooks (especially the ones with updates) and one of my favorites is the old "psychology of computer programming" and although subjective, it really reinforces...

SQL log seems to think he's logging in with a SQL Server login. I gave him instructions on how to set up DataGrip for windows authentication, but he says...

As far as I can tell - that error is a file system error which seems to indicate that the agent cannot execute the SSIS package because it cannot access...

Is the user account in SQL Server set as Windows or SQL account?  If using Windows Authentication - have you confirmed that Kerberos is configured correctly and that the user's...

A basic outline for this:

1. File Connection Manager - set to a single column for the maximum width of the file.
2. Connect to a Script Component.  In the script component,...

Not sure I understand what you are trying to do - but it shouldn't be necessary.  If you are using Project Deployment to an Integration Services Catalog you can modify...

AFAIK, Scott's solution is the better one, because LIKE 'AAA%' is...

WHERE LEFT(AKey, 3) IN ('AAA', 'BBB', 'CCC', 'DDD', 'EEE', 'GGG', 'JJJ') AND LEN(AKey) = 9

This is a display/report issue - it can and should be done in the report and not in SQL Server.  Your example does not include all of the data elements...