Training

This page is intended for students of mine.

Restauranger Cornerstone

Tips om kursmaterial på Skillpipe

Course files

Demo-filer shared among several courses (see explanation below):
TiborCommonSqlScripts.zip

Missing bat and sql files to restore demo-databases
RestoreLabDatabases.zip

T1987, Performance Tuning and Optimizing SQL Databases
Kursmaterial
Grant Fritcheys "SQL Server Execution Plans" från Redgate
Labbinstruktioner V1
Labbinstruktioner V2
Labbfiler V2
Demo-filer

T2761, Querying Data with Transact-SQL - Continuation Course
Kursmaterial
Labbinstruktioner V1
Labbinstruktioner V2
Labbfiler V2
Demo-filer

T2762-1, Developing SQL Databases, Part 1
Kursmaterial
Labbinstruktioner
Demo-filer

T2762-2, Developing SQL Databases, Part 2
Kursmaterial
Labbinstruktioner
Demo-filer

T2764, Administering a SQL Database Infrastructure
Kursmaterial
Labbinstruktioner V1 
Labbinstruktioner V2
Labbfiler V2
Demo-filer

T2765, Provisioning SQL Databases
Kursmaterial
Labbinstruktioner V1
Labbinstruktioner V2
Demo-filer

A525, SQL Server – upgrade and sharpen your DBA and developer skills
Labbfiler
Demo-filer
PDF filer
DP-080, Querying Data with Microsoft Transact-SQL
Labbinstruktioner
Demo-filer
MSL-länk

DP-300, Administering Relational Databases on Microsoft Azure
Labinstructions
Demofiles
MSL-link to course material


Azure pass

Some courses involves Azure and for them you'll get an Azure pass. Tips:
  • Don't leave things that aren't used, they might consumed credits. If the lab instruction tell you do remove some resource at end of the lab, please do so. Delete things at end of course and you might have credits left to lab after end of course.
  • Activate the pass at https://www.microsoftazurepass.com. Preferably use an In-Private session in your web browser. Create a new email account solely for this purpose, this should be available when you sign in to above. You'll find a good description at microsoftazurepass.com.
  • The pass is valid for 30 days, or when the credits are used up, which comes first.
  • You can check your balance here.

Svenskt tangentbord i Windows

  • Titta längst ner till höger (i Windows taskbar), om det står ENG så väljer du svenska.
  • Om du inte har det valet:
    • Högerklicka Taskbar
    • Aktivera "Show touch Keyboard button"
    • Öppna det virtuella/touch tangentbordet
    • Längst ner till höger kan du nu välja språk

My demo-files

Ytou'll find my demo-files at the Course files section above. These are the files I show when delivering a course.

Please read this

I have a folder per course with my demo files,  and also one folder for files that are shared between more than one courses, the "common course" folder: TiborCommonSqlScripts.zip.
Most files are .sql files wich you can use as-is.
You will find SSMS project and solution files, and if you want to use the solution folder you need to unpack the common files to this folder:  C:\Kursfiler\Kurser\TiborCommonSqlScripts. When you open a file, SSMS will try to connect to my SQL Server name, a tip is to delete the connection in each project.

The demo-databases that I use are in mast cases any of the Adventureworks databases. I use the 2014 versionernas so I don't have to deal with memory-optimized tables. You find the demo-databases here. I sometimes use a table names FactResellerSalesXL in the DW database, which is a copy of the correspåonding page-compressed table and you can create this using SELECT INTO and then create a clustered row index on the (SalesOrderNumber, SalesOrderLineNumber) column kombination.

If you have problems accessing the file:
  1. Right-click and copy the link
  2. Open an "incognito window", "in-private session" or whatever your web-browser calls it.
  3. Paste the link that you copied in step 1

Hi and welcome

After course

Gamla kurser

10987, Performance Tuning and Optimizing SQL Databases
Demo-filer

20761, Querying Data with Transact-SQL

Demo-filer

20762, Developing SQL Databases

Demo-filer

20764, Administering a SQL Database Infrastructure

Demo-filer

20765, Provisioning SQL Databases
Demo-filer