Skills SQL Server Development: Difference between revisions

Revision as of 17:59, 6 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

SQL Server Integration Services

SSIS with parameters

.dtsx files

I used SSIS at several of my roles, including Role MUFG Securities

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

Revision as of 17:47, 6 October 2024 view source NeilM (talk \| contribs) 1,601 edits →‎Partitions ← Older edit		Revision as of 17:59, 6 October 2024 view source NeilM (talk \| contribs) 1,601 edits →‎Other Newer edit →
Line 78:		Line 78:

	Linked Servers		Linked Servers

			OSQL Command line utility