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.
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:
Aktivera "Show touch Keyboard button"
Öppna det virtuella/touch tangentbordet
Längst ner till höger kan du nu välja språk
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:
Right-click and copy the link
Open an "incognito window", "in-private session" or whatever your web-browser calls it.