Only for Tibor's students

This page is only intended for students of mine.

Tibor's demo files

Please read this first:

You will download two zip files (folders).
One is specific for this course, see the list further down on this page.
The other contain the sql files that are used in more than one course. I.e., some demo-files are in this folder instead of the course specific folder.: TiborCommonSqlScripts.zip.

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. Also, when you open a file, SSMS will try to connect to my SQL Server name, so 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 version 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 above):
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