MySQL has no ISNUMERIC function like SQL Server, so here is a simple user defined function that uses a regular expression to validate integer values.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – SSMS: Transaction Log Shipping Status Report
Like timber floating downstream, log shipping moves logs from one server to another. Here is how to read the Transaction Log Shipping Status report in SSMS.
Scalar UDF Inlining: When Old Functions Suddenly Get Fast
Check scalar UDF inlining eligibility, database settings, function options, and execution plans before claiming a performance improvement.
SQL SERVER – Andy Defines Basic RDBMS: Isolation in Processes – Notes from the Field #038
Andy explains isolation in processes, a basic RDBMS idea, with fresh eggs from his family’s chickens. A fun way to learn the fundamentals.
Top Resource Consumers in Query Store
Top resource consumers in Query Store show CPU, duration, and reads by query and plan, so tuning starts with workload impact.
Object Dependencies in SSMS: SQL in Sixty Seconds #071
Object Dependencies in SSMS shows the references recorded in SQL Server metadata. This post adds T-SQL queries for both directions, tested on SQL Server 2025, and shows what the dialog cannot see: dynamic SQL, other databases and a table dropped under a view.
Getting Your Employer to Pay for Training
Ask your employer to pay for training with a short proposal that ties the course to work, shows cost, and shares the result with the team.
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.