A client with 86 databases struggled to find one in Object Explorer. A newer SSMS Enhancement lets you filter the Databases node. Here is how it works.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Find Week of the Year Using DatePart Function
The DATEPART function returns a week number according to its week definition. I choose that convention before using calendar logic.
Finding Orphaned Child Rows Before Adding a Foreign Key
Find orphaned child rows before adding a foreign key, review their business meaning, validate relationships, and confirm constraint trust.
Writing a Disaster Recovery Runbook: RPO, RTO and a Restore Test
Build a disaster recovery runbook around agreed RPO and RTO, usable backup chains, instance dependencies, clear roles, and restore tests.
FOR JSON Data Types: How bit, Dates and Money Come Out
Your API returns 1 and the client wanted true. Here is how FOR JSON picks a JSON type for bit, dates, decimal, money, binary and NULL, and how to fix it.
SQL SERVER – GetRegKeyAccessMask : Could Not Get Registry Access Mask For Registry Key – SQL Server Cluster
In a two-node SQL Server Cluster, SQL would not come online on one node and wrote no ERRORLOG. The cluster log showed GetRegKeyAccessMask. Here is the fix.
How to Get Started with SQL Server 2016? – Interview Question of the Week #086
A candidate asked me in an interview: how do I get started with SQL Server 2016? Here is my answer for anyone who has not tried it yet.
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.