Build monthly counts with zero-filled gaps, generate a complete month range, and retain empty categories through a reporting scaffold.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Ranking Items by Rating Fairly With a Bayesian Average
Use Bayesian average in SQL Server with practical examples, clear checks, and the limits you need before changing your database.
SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution
Paging in MySQL and SQL Server: use LIMIT and OFFSET to skip some rows and return only the next few, with examples for both databases.
SQL SERVER – MySQL – PostgreSQL – How to Concat Strings?
How to concat strings the same way in SQL Server, MySQL and PostgreSQL? I switched from the plus operator to the CONCAT function, and here is why.
Developer – 10 Phrases Developer Use Too Often
I am a developer and so are most of my friends. Here are 10 phrases every developer says too often, from ‘I can fix that’ to ‘That’s not my code’.
MySQL – How to Change Delimiter in MySQL – Supporting GO Keyword of SQL Server in MySQL
Copied a SQL Server script with GO into MySQL and got an error? Here is how to change delimiter in MySQL so it accepts GO as a statement terminator.
SQL SERVER – Roundup Post – Notes from the Field – Year 2013 – Performance Tuning and Database Health
How did Notes from the Field start? Here is the story behind the series and a roundup of the 2013 episodes on performance tuning and database health.
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.