Presenting SSMS results to a big room? Zoom does not work on the results grid, but Tools, Options, Fonts and Colors lets you raise the grid Font Size.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQLAuthority News – New SQL in Sixty Seconds Video
Today I am going to discuss the new SQL in Sixty Seconds Videos which I have released. Let us learn about them together. Do not forget to subscribe.
SQL SERVER – FIX Error 18456, Severity: 14, State: 5. Login failed for user
A customer moving from Oracle kept getting Error 18456, Severity: 14, State: 5 from Java and from SSMS. Here is how we found the real cause.
Automated Restore Tests: Proving Backups Work Every Week
Schedule restore tests that select current backups, move files to an isolated server, run CHECKDB, record failures, and rotate databases.
Consultant’s Life – 30 Minutes Pre Call With Customer for SQL Server Performance Tuning
A Pre Call gives a performance-tuning engagement a clear starting point. I want to understand the symptom and what the customer needs.
SQL SERVER – Understanding How to Play With Row Constructor
A code review surprised me with an unusual use of the Row Constructor. Here is what the code did and how you can play with row constructors yourself.
How to Find Recent Executed Queries in SQL Server? – Interview Question of the Week #087
An interview question that stumped candidates: how do you find recent executed queries in SQL Server? A DMV script using sys.dm_exec_query_stats answers it.
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.