Some questions are very open ended. Here is one question I was asked in recent User Group Meeting about user without login.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Draw Pictures with T-SQL: The SSMS Spatial Results Tab
The SSMS Spatial results tab draws every geometry value a query returns. This post draws a house and a tree with STGeomFromText and STBuffer, explains labels and the 5,000 object limit, and checks store service areas for overlaps and gaps.
SQL SERVER – Not Possible – Delete From Multiple Table – Update Multiple Table in Single Statement
Can you delete from multiple table or update multiple tables in a single statement? No, and you should not try. Here is why, and what a reader pointed out.
Copy Column Headers From SSMS Results to Excel
To copy column headers from SSMS results, use Copy with Headers or press Ctrl+Shift+C. This post also shows the Options setting that includes headers every time, why a change can seem to do nothing, and how to stop Excel from dropping leading zeros.
Order of Operations in SQL Server: How PEMDAS Works in T-SQL
The order of operations in SQL Server follows PEMDAS, so 6/2*(1+2) returns 9. This post walks through the precedence rules with tested queries. It also covers integer division, the negative number trap and AND before OR.
SQL SERVER – Excel Losing Decimal Values When Value Pasted from SSMS ResultSet
I often get questions that how to fix the issue where excel loses decimal values when values are pasted from SSMS Resultset.
Keeping a Patch Test Environment Honest
A Patch Test Environment must match production data, settings, jobs, and versions closely enough to reveal real patch risks.
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.