Three tested ways to install the NorthWind and Pubs sample databases on SQL Server 2005, starting from SQL2000SampleDb.msi, with screenshots for each.
SQL SERVER – Easy Sequence of SELECT FROM JOIN WHERE GROUP BY HAVING ORDER BY
The sequence of SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING and ORDER BY that I gave my new hires. Since then they ask me far fewer questions.
SQL SERVER – Explanation SQL SERVER Hash Join
How a Hash Join works in two phases, build and probe, why it suits large data sets without indexes, and why it needs an equijoin predicate.
SQL SERVER – Fix : Error 8629 The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time.
Error 8629 appears when one UPDATE changes a text or image column and a clustering key together. Here is why SQL Server blocks it and a fix.
How to Read a SQL Server Error Message
Read a SQL Server error message by separating its number, severity, state, procedure, and line, then preserve the context needed to investigate.
SQL SERVER – Recovery Models and Selection
SQL Server offers three recovery models: full, simple and bulk-logged. Here is when to select each one, based on how much data loss you can accept.
Normalization Jokes and the Normal Forms They Make Fun Of
Normalization jokes are funny because they are true. Here are the classics in my own words, and the first three normal forms they poke fun at.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.