Skills SQL Server Development: Difference between revisions
| (5 intermediate revisions by the same user not shown) | |||
| Line 18: | Line 18: | ||
''Used at: '' | ''Used at: '' | ||
''[[Role_MUFG_Securities|MUFG Securities]]'' | ''[[Role_MUFG_Securities|MUFG Securities]]'' | ||
''[[Role_Autotrader|Autotrader]]'' | |||
</div> | </div> | ||
</div> | </div> | ||
| Line 41: | Line 42: | ||
''[[Role_MUFG_Securities|MUFG Securities]]'' | ''[[Role_MUFG_Securities|MUFG Securities]]'' | ||
''[[Role_SSE_Energy_GDPR|SSE Energy GDPR]]'' | ''[[Role_SSE_Energy_GDPR|SSE Energy GDPR]]'' | ||
''[[Role_ING_Investment_Management|ING Investment Management]]'' | |||
</div> | </div> | ||
</div> | </div> | ||
| Line 49: | Line 51: | ||
.dtsx files | .dtsx files | ||
DTS to SSIS migration | |||
== BIML == | == BIML == | ||
{{TemplateUsedAt|Role_MUFG_Securities|BIML|MUFG Securities}} | {{TemplateUsedAt|Role_MUFG_Securities|BIML|MUFG Securities}} | ||
BIML is an add-in for Visual Studio that generates SSIS packages from a template. | BIML is an add-in for Visual Studio that generates SSIS packages from a template. | ||
== Partitions == | |||
<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;"> | |||
<div>''Used at:...''</div> | |||
<div class="mw-collapsible-content"> | |||
''Used at: '' | |||
''[[Role_Bluecrest_Capital|Bluecrest Capital]]'' | |||
</div> | |||
</div> | |||
Partition functions, schemes | |||
Partition switching | |||
== Other == | == Other == | ||
| Line 61: | Line 75: | ||
''Used at: '' | ''Used at: '' | ||
''[[Role_MUFG_Securities|MUFG Securities]]'' | ''[[Role_MUFG_Securities|MUFG Securities]]'' | ||
''[[Role_Bluecrest_Capital|Bluecrest Capital]]'' | |||
</div> | </div> | ||
</div> | </div> | ||
Linked Servers | |||
OSQL Command line utility | |||
Latest revision as of 21:53, 8 October 2024
SQL Server
Used at:...
SQL Server
SQL Server Management Studio
Used at:...
Used at: MUFG Securities Autotrader
SQL Server Management Studio (SSMS)
Database design
Medallion architecture
Used at:...
Used at: MUFG Securities
Medallion architecture
SSIS
Used at:...
SQL Server Integration Services
SSIS with parameters
.dtsx files
DTS to SSIS migration
BIML
Used at:...
Used at MUFG Securities
BIML is an add-in for Visual Studio that generates SSIS packages from a template.
Partitions
Used at:...
Used at: Bluecrest Capital
Partition functions, schemes
Partition switching
Other
Used at:...
Used at: MUFG Securities Bluecrest Capital
Linked Servers
OSQL Command line utility