Skills SQL Server Development: Difference between revisions

From MillerSql.com
NeilM (talk | contribs)
NeilM (talk | contribs)
 
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>

Latest revision as of 21:53, 8 October 2024

SQL Server

SQL Server

SQL Server Management Studio

Used at:...

SQL Server Management Studio (SSMS)

Database design

Medallion architecture

Used at:...
  Used at: 
  MUFG Securities

Medallion architecture

SSIS

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

Partition functions, schemes

Partition switching

Other

Used at:...

Linked Servers

OSQL Command line utility