drs Paul van Oordt MCITP‑dba

Freelance SQL Server specialist and troubleshooter

info@vanoordt.nl - +31 627400408
LinkedIn - curriculum vitae
vanoordt.nl - Nederlands

In-house SQL Server crash course

T-SQL for non-native speakers; T-SQL als Fremdsprache

Usually developers that work with SQL Server primairily have other specialisations, for instance ASP.NET or C#. The database just comes with it. As a result there is often insufficient knowledge to choose from the many possibilities that SQL Server offers, and insufficient understanding to solve structural problems. During an in-house SQL Server crash course I am available for a whole day to tell about the features and internals of SQL Server and to answer a whole lot of questions.

For the participants this means that many things fall in place. Finally it is understood why all these recommendation on the internet are made (and for some of these, why they are wrong). A day long in-house training is a very efficient way to aquire knowledge. The subjects covered are exactly tuned to the needs of the participants. To cover these same subjects in open trainings would probably take two whole weeks. It is an intensive experience for the participants (and for me) and an excellent investment for the customer.

A course can be conducted in Dutch or English. References are available.

Some of the subjects that may be covered.

database design and programming

  • normalisation and denormalisation
  • primary and foreign keys
  • data types
  • nullability
  • computed columns
  • check constraints
  • schemas
  • triggers
  • xml
  • geografic data
  • partitioning
  • views
  • common table expressions
  • temporary tables and table variables
  • set based thinking and programming
  • stored procedures and functions
  • CLR integration
  • error handling
  • transactions and isolation levels
  • full text search

SQL Server internals and performance

  • files, extents, pages, heaps, clustered indexes
  • disks, I/O, file sizing and placement
  • memory
  • query processing
  • procedure cache, (re)compilation
  • query plans
  • nonclustered, covering, missing, and filtered indexes
  • index usage
  • index fragmentation
  • statistics
  • waits
  • DMV's
  • expensive queries
  • tracing, extended events
  • tempdb

database administration

  • server and database settings
  • error logs
  • transaction logs
  • backup, restore, and recovery
  • high availability
  • integrity checks
  • maintenance plans
  • SQL Server Agent, jobs, alerts, notifications
  • database mail
  • replication
  • linked servers
  • logins, users, permissions, server and database roles
  • high availability
  • auditing

Often heard: "Let's plan another day..." ☺

Interested? Call or mail: +31627400408, info@vanoordt.nl

 

 

 

 

 
 
 
 
 
 

www.vanoordt.nl Last modified: 1 November 2018