Part 2 on Proper Case in SQL Server: a quick script that makes only the first letter of a sentence upper case, and how to do it for a table column.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log
Why does an LDF file keep growing even with hourly log backups? Imran Mohammed explains what goes on behind the scene of the Transaction Log and shrinking.
Spotting Agent Jobs That Run Longer Than Usual
Spot Agent jobs that run longer than usual by decoding msdb duration, comparing recent runs, and checking jobs still active now.
Finding the Client IP Address of a Connection
Find the client IP address of a SQL Server connection with DMVs and CONNECTIONPROPERTY, and understand proxy and local transport limits.
SQL SERVER – Disable All the Trigger of Current Database
Another way to disable all the trigger objects in the current database: a stored procedure by Manish Kaushik that loops over each table and disables them.
SQL SERVER – Detailed Explanation of Transaction Lock, Lock Type, Avoid Locks
How do you find which table has a transaction lock and what lock type it is? Imran Mohammed explains it for SQL Server 2000 and 2005, and how to avoid locks.
Stable Weekday Numbers Without Changing DATEFIRST
Stable weekday numbers use a fixed Monday anchor and negative-safe modulo. Map Monday to one without changing DATEFIRST or session language.
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.