A DBA installing SQL Server 2012 on a virtual machine got ‘Setup was not able to access domain’. Here is what the message means and how to get past it.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
How to Insert Multiple Rows in a Single SQL Query – Interview Question of the Week #069
Interview question: write one script that inserts multiple rows in a single SQL query and runs unchanged in SQL Server, MySQL and PostgreSQL. Here is my answer.
SELECT One by Two – Interview Question Extended – Part II
After my SELECT One by Two puzzle, I played with a small extension: three queries mixing 1. and 1/2. Can you guess what each one returns and why?
Understanding Database Scalability – Vertical and Horizontal
One server with 64 cores or two with 32 cores? A customer asked me to help decide. Here is a simple look at Database Scalability, vertical and horizontal.
Hey DBAs – What Are You Assuming/Missing Today? – Notes from the Field #122
Hey DBAs, what are you assuming or missing today? Mike Walsh on why a good DBA watches every instance and is not afraid to say I do not know.
SQL SERVER – Computed Column and Conditions with Case Statement
How to write conditions with CASE statement in a computed column, using a simple AdventureWorks script you can adapt for any complicated logic.
SQL SERVER – Identify Table Where Clustered Index is Not a Primary Key – DMV
Let us first see script which will return us tablename with schema where clustered index is not a primary key.
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.