Convert currency strings into decimal amounts using known symbols, explicit parsing cultures, conversion checks, and rejection evidence.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Capturing Stored Procedure Executions with Extended Events in SQL Server
Capturing stored procedure executions with Extended Events: set up a session with module_end, run a sample procedure, and query the captured data.
A Walkthrough – DATETRUNC Function in SQL Server
One such tool is the DATETRUNC function, introduced in SQL Server 2022. Let’s take a journey to understand how this function can simplify date handling.
Functions and Missing Indexes – SQL in Sixty Seconds 204
In this blog post, we will discuss the relationship between Functions and Missing Indexes Hints in SQL Server. Functions can reduce query performance.
3 ChatGPT Tricks to Tune SQL Server – SQL in Sixty Seconds 203
Here are 3 ChatGPT tricks to tune SQL Server: quick, practical methods to optimize your queries, with a SQL in Sixty Seconds video.
Majoring in the Minors in SQL Server Performance Tuning
We’ll explore how to avoid this common pitfall & Focus the areas that matter for performance improvements. Avoid majoring in the minors.
EXISTS vs IN vs JOIN: Writing Semi-Joins
Compare EXISTS, IN, and JOIN for semi-joins, prevent duplicate customer rows, and handle NULL safely in exclusion queries.
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.