Viewing 15 posts - 1 through 15 (of 498 total)
SSIS integration Run time in Azure provides the infrastructure to run SSIS packages. I have moved my SSIS packages with third-party custom tasks, and it worked fine in Azure....
June 3, 2022 at 5:38 pm
Question: We want to use SSIS in PaaS but we have some custom tasks and components. How do we import those to SQL PaaS?
June 3, 2022 at 1:38 pm
I have a couple of courses over on Pluralsight that use ADS for Postgresql:
https://app.pluralsight.com/library/courses/posgresql-functions-playbook
https://app.pluralsight.com/library/courses/capturing-logic-custom-functions-postgresql
in case anyone wants to go a bit deeper into Postrgresql.
January 31, 2022 at 2:12 pm
@jeff-moden No worries!
May 1, 2021 at 12:38 am
Microsoft *did* look at the PR and we had some back and forth on it. Ultimately it was rejected since my sample query and others like it have a join...
April 30, 2021 at 5:41 pm
@jeff-moden LOL. I did get an email ack:
@gbritton1 : Thanks for your contribution! The author(s) have been notified to review your proposed change.
(It's Gerald btw)
March 29, 2021 at 7:49 pm
Forget this one. turns out it cleaned itself up after a while.
March 29, 2021 at 4:53 pm
Thanks for the confirmation! Now only if the documentation was clearer? e.g.
SYS.DESTINATION_DATA_SPACES (TRANSACT-SQL)
Column name Data typeDescription
partition_scheme_idint ...
March 29, 2021 at 12:58 pm
Zeker weten! I understand what the boundary value is and does. For the purpose of the post here, I'm looking for something else:
I'm looking for definitive documentation that can confirm...
March 26, 2021 at 3:17 pm
Bedankt Johan! (Ik neem aan dat je het nederlands verstaat). Your code is certainly helpful! I'm still stuck with the basic question, though. e.g. in your code you have a...
March 26, 2021 at 12:54 pm
If you like the object explorer view, just don't specify a db in the connection dialog.
Did I miss a mention of git integration? One of my fav features! Not to...
February 15, 2021 at 7:50 pm
@jeff how do you do parallelism in SQL driven by an Agent job? Note that I don't mean parallelism in execution plans; I mean actual parallel operations as...
December 24, 2020 at 3:33 pm
super easy if you put the steps in an SSIS package and run that from Agent
December 21, 2020 at 9:42 pm
I would simply write an SSIS package and run that using SQL Server Agent. After all, that is exactly what Maintenance Tasks for SQL Server do. Those are a little...
December 21, 2020 at 2:56 pm
Viewing 15 posts - 1 through 15 (of 498 total)