Skills SQL Server Development

SQL Server

Used at:...

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

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:...

  Used at: 
  MUFG Securities
  SSE Energy GDPR
  ING Investment Management

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