Install AdventureWorks and WideWorldImporters once, the right way. Which file to download for your SQL Server, where to put it so the service account can read it, the RESTORE FILELISTONLY step, restore scripts for T-SQL, SSMS, Docker and Linux, and the five errors people email me about. Every command was run on SQL Server 2025.
SQL SERVER – Absolute Beginners 10 Queries
I thought it was a very good exercise for everyone. Here, I will be sharing the same. Let us see Absolute Beginners 10 Queries.
Where to Download SQL Server 2019 for FREE? – Interview Question of the Week #276
Question: Where to Download SQL Server 2019 for FREE?
Answer: This is one of the most popular questions, I keep on receiving from blog readers.
MySQL – Download Sample Database – Sakila, World, Employee
Where can you download a MySQL sample database? Here are the popular ones, Sakila, World, Employee and more, for testing new features and your scripts.
How to Use a CASE Statement in the WHERE Clause? – Interview Question of the Week #239
Question: How to Use a CASE statement in the WHERE Clause? Answer: First of all – CASE is not a statement but rather an expression.
SQL SERVER – Download and Install SQL Server Sample Databases (Updated Post for 2019)
My primary task is to do consultation for SQL Server Performance Tuning. I always use Microsoft provided sample databases for my demonstrations.
SQL SERVER – How to Install New Sample Database WideWorldImportersDW.bak
A client noticed I had no post on the data warehouse sample. Here are the steps to download and restore WideWorldImportersDW, with a note for Standard Edition.