Skills SQL Server Development: Difference between revisions

Latest revision as of 21:53, 8 October 2024

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

@@ Line 1: / Line 1: @@
 == SQL Server ==
+<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
+   <div>''Used at:...''</div>
+   <div class="mw-collapsible-content">
+   ''Used at: ''
+   ''[[Role_MUFG_Securities|MUFG Securities]]''
+   ''[[Role_Allen_Overy|Allen & Overy]]''
+   ''[[Role_SSE_Energy_GDPR|SSE Energy GDPR]]''
+   ''[[Role_Autodata|Autodata]]''
+   </div>
+</div>
 SQL Server
 == SQL Server Management Studio ==
-SQL Server Management Studio (SSMS)Database design
+<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
+   <div>''Used at:...''</div>
+   <div class="mw-collapsible-content">
+   ''Used at: ''
+   ''[[Role_MUFG_Securities|MUFG Securities]]''
+   ''[[Role_Autotrader|Autotrader]]''
+   </div>
+</div>
+SQL Server Management Studio (SSMS)
+Database design
 == Medallion architecture ==
+<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
+   <div>''Used at:...''</div>
+   <div class="mw-collapsible-content">
+   ''Used at: ''
+   ''[[Role_MUFG_Securities#BIML|MUFG Securities]]''
+   </div>
+</div>
 Medallion architecture
@@ Line 12: / Line 39: @@
     <div>''Used at:...''</div>
     <div class="mw-collapsible-content">
-    ''Used at [[Role_MUFG_Securities|MUFG Securities]]''
+    ''Used at: ''
+   ''[[Role_MUFG_Securities|MUFG Securities]]''
+   ''[[Role_SSE_Energy_GDPR|SSE Energy GDPR]]''
+   ''[[Role_ING_Investment_Management|ING Investment Management]]''
     </div>
 </div>
@@ Line 21: / Line 51: @@
 .dtsx files
-I used SSIS at several of my roles, including [[Role MUFG Securities]]
+DTS to SSIS migration
 == BIML ==
+{{TemplateUsedAt|Role_MUFG_Securities|BIML|MUFG Securities}}
+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_MUFG_Securities#BIML|MUFG Securities]]''
+    ''Used at: ''
+   ''[[Role_Bluecrest_Capital|Bluecrest Capital]]''
     </div>
 </div>
-BIML is an add-in for Visual Studio that generates SSIS packages from a template.
+Partition functions, schemes
+Partition switching
 == Other ==
 <div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
-    <div>BIML (SSIS Visual Studio extension)...</div>
+    <div>''Used at:...''</div>
     <div class="mw-collapsible-content">
-    Used in my contract at [[Role_MUFG_Securities|MUFG Securities]]
+    ''Used at: ''
-    Link to other
+   ''[[Role_MUFG_Securities|MUFG Securities]]''
+    ''[[Role_Bluecrest_Capital|Bluecrest Capital]]''
     </div>
 </div>
+Linked Servers
+OSQL Command line utility