DATEPART quarter identifies a calendar component. I keep its year when reporting separate periods. A cross-year January case shows how quarter-only grouping combines events.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
A One Page Reference for Everyday SQL Server Work
Build a practical SQL Server reference around everyday questions, with compact queries for context, objects, requests, space, and transactions.
Finding Dynamic SQL Open to Injection
Find dynamic SQL open to injection by searching module definitions for concatenation, then replace data concatenation with parameters.
Reading SQL Server Release Notes Before You Patch
Reading SQL Server Release Notes before patching helps you find known issues, fixes, behavior changes, and workload risks.
SQL SERVER – Create Check Constraint on Column
A junior developer wrote a trigger to block invalid data. A Check Constraint is simpler. My example limits PostalCode length in AdventureWorks and tests it.
A Quarterly Permission Review
A quarterly permission review checks server and database roles, new grants, orphaned users, service accounts, and owner signoff.
SQL SERVER – Find Current Identity of Table
Many developers use MAX() to find the current identity of a table. I prefer DBCC CHECKIDENT, which reports the current identity value directly.
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.