Skills SQL Server Development: Difference between revisions

Revision as of 11:42, 7 October 2024

Used at:...

  Used at: 
  MUFG Securities
  Allen & Overy
  SSE Energy GDPR
  Autodata

SQL Server

Used at:...

  Used at: 
  MUFG Securities

SQL Server Management Studio (SSMS)

Database design

Used at:...

  Used at: 
  MUFG Securities

Medallion architecture

Used at:...

  Used at: 
  MUFG Securities
  SSE Energy GDPR
  ING Investment Management

SQL Server Integration Services

SSIS with parameters

.dtsx files

DTS to SSIS migration

Used at:...

  Used at MUFG Securities

BIML is an add-in for Visual Studio that generates SSIS packages from a template.

Used at:...

  Used at: 
  Bluecrest Capital

Partition functions, schemes

Partition switching

Used at:...

  Used at: 
  MUFG Securities
  Bluecrest Capital

Linked Servers

OSQL Command line utility

@@ Line 41: / Line 41: @@
     ''[[Role_MUFG_Securities|MUFG Securities]]''
     ''[[Role_SSE_Energy_GDPR|SSE Energy GDPR]]''
+   ''[[Role_ING_Investment_Management|ING Investment Management]]''
     </div>
 </div>
@@ Line 49: / Line 50: @@
 .dtsx files
-I used SSIS at several of my roles, including [[Role MUFG Securities]]
+DTS to SSIS migration
 == BIML ==