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: TiborCommonSqlScripts.zip.
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):
TiborCommonSqlScripts.zip

T1987, Performance Tuning and Optimizing SQL Databases
T1987_TiborDemo.zip

T2761, Querying Data with Transact-SQL - Continuation Course
T2761_TiborDemo.zip

T2762-1, Developing SQL Databases, Part 1
T2762-1_TiborDemo.zip

T2762-2, Developing SQL Databases, Part 2
T2762-2_TiborDemo.zip

T2764, Administering a SQL Database Infrastructure
T2764_TiborDemo.zip

T2765, Provisioning SQL Databases
T2765_TiborDemo.zip

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

DP-080, Querying Data with Microsoft Transact-SQL
DP-080_TiborDemo.zip

DP-300, Administering Relational Databases on Microsoft Azure
DP-300_TiborDemo.zip


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