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.
Counting Objects by Type in Every Database With One Query
One loop and one pivot give you tables, views, procedures and functions for every database. A planted demo database proves the counts.
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
Get MySQL sample databases Sakila, World, and Employees. Follow Windows install steps, verify each import, and choose the right dataset.
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.
Recording Who Granted What With a Database Audit Specification
Current permissions never say who changed them. Set up a small audit, run a grant, a revoke and a failed attempt, and read the events back.