Only for Tibor's students

This page is only intended for students of mine.

Restauranger Cornerstone

Tibor's demo files

Please read this first:

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:
Most files are .sql files which 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 most 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 corresponding page-compressed table and you can create this using SELECT INTO and then create a clustered row index on the (SalesOrderNumber, SalesOrderLineNumber) column kombination.

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

T1987, Performance Tuning and Optimizing SQL Databases

T2761, Querying Data with Transact-SQL - Continuation Course

T2762-1, Developing SQL Databases, Part 1

T2762-2, Developing SQL Databases, Part 2

T2764, Administering a SQL Database Infrastructure

T2765, Provisioning SQL Databases

A525, SQL Server – upgrade and sharpen your DBA and developer skills

DP-080, Querying Data with Microsoft Transact-SQL

DP-300, Administering Relational Databases on Microsoft Azure

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

Old courses

10987, Performance Tuning and Optimizing SQL Databases

20761, Querying Data with Transact-SQL


20762, Developing SQL Databases


20764, Administering a SQL Database Infrastructure


20765, Provisioning SQL Databases