Viewing 15 posts - 16 through 30 (of 1,978 total)
Yes you would still need to have your directory create logic in there, that was just to handle adding the date stamp.
July 25, 2023 at 2:57 pm
Well your file copy could look something like,
$file | Copy-Item -Destination ($destination + ($file.BaseName + "_" + (Get-Date -Format "MMyyyy") + $file.Extension ))
July 25, 2023 at 2:33 pm
Unfortunately that is a super generic java error from the sql driver, we've had a lot of issues with that and it's hard to point to a root cause. An...
July 19, 2023 at 6:38 pm
I think there shouldn't be time zones, let alone DST. The entire globe should be Noon, as an example. Pick a time zone, and the whole world can follow...
July 18, 2023 at 8:13 pm
What about the hybrid approach where HIPPO demands data be manipulated to match?
July 14, 2023 at 8:31 pm
Just be careful if there's more than 1 completed subtask for the same task 🙂
May 25, 2023 at 4:39 pm
Surrogate keys are only better in terms of being easier to join. But if the source data has a natural key there almost always value in enforcing that even if...
May 22, 2023 at 4:06 pm
Thanks. Question is do you really have room for improvement, when you your table is large as 176M rows and your view on top of that table returns everything...
May 12, 2023 at 6:31 pm
Jeffrey,
RCIS is set to 0. There are no additional query hints or anything being used within the two queries.
Transactions are designed to maintain consistency across multiple transactions(and allow the...
May 11, 2023 at 9:08 pm
Unless you're actually storing the result in a database field is there any performance difference between varchar or char? If you are just for example returning the result...
May 2, 2023 at 8:46 pm
Corrected to varchar(30), and the target system always depends, but there is a format designed to convert cleanly to XML. Not all formats do this.
I find it interesting...
May 1, 2023 at 5:41 pm
Another option if you don't want to be moving data between your local and the prod server, creating temp tables, CTE's etc... would be to use SSIS and just do...
May 1, 2023 at 4:03 pm
Keep it simple: Simple designs are often the best designs. By keeping things simple, you can reduce complexity and make your software easier to use.
On this note, the over all solution...
May 1, 2023 at 3:06 pm
This entirely depends on what the system consuming the XML is expecting.
May 1, 2023 at 2:35 pm
Why is it acceptable that a test environment is less secure than a production environment?
April 11, 2023 at 3:56 pm
Viewing 15 posts - 16 through 30 (of 1,978 total)