Viewing 15 posts - 1 through 15 (of 497 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....
Gerald Britton, Pluralsight courses
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?
Gerald Britton, Pluralsight courses
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.
Gerald Britton, Pluralsight courses
January 31, 2022 at 2:12 pm
@jeff-moden No worries!
Gerald Britton, Pluralsight courses
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...
Gerald Britton, Pluralsight courses
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)
Gerald Britton, Pluralsight courses
March 29, 2021 at 7:49 pm
Forget this one. turns out it cleaned itself up after a while.
Gerald Britton, Pluralsight courses
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 ...
Gerald Britton, Pluralsight courses
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...
Gerald Britton, Pluralsight courses
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...
Gerald Britton, Pluralsight courses
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...
Gerald Britton, Pluralsight courses
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...
Gerald Britton, Pluralsight courses
December 24, 2020 at 3:33 pm
super easy if you put the steps in an SSIS package and run that from Agent
Gerald Britton, Pluralsight courses
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...
Gerald Britton, Pluralsight courses
December 21, 2020 at 2:56 pm
Have previous version of SSMS had support for in memory tables in diagrams?
it never came up before, this is our first deployment of mem-opt tables
Gerald Britton, Pluralsight courses
December 17, 2019 at 3:30 pm
Viewing 15 posts - 1 through 15 (of 497 total)