Finding What depends on a table starts with sys.dm_sql_referencing_entities, then checks cross-database code and dynamic SQL.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Data Governance: Catalog, Lineage and Data Quality
Data Governance is how you know what data you have, where it came from, who can see it and whether it is right. This post covers the catalog, lineage, access and data quality, with T-SQL checks you can run.
TRUNCATE Permission: Letting a User Empty One Table
Your loader needs to empty a staging table, not redesign it. Here is a small procedure that gives it exactly that.
MySQL – Change the Limit of Row Retrieved in MySQL Workbench
Why does a query return every row in your app but only 1000 in MySQL Workbench? It limits rows by default, and here is how to change that limit.
Unique Constraint on Existing Table: How to Add One With ALTER TABLE
A unique constraint on existing table data takes one ALTER TABLE statement. Here is the script, the duplicate check to run first, and what to know about NULLs, indexes and names.
Query Store Capture Modes: ALL, AUTO and CUSTOM
Choose a Query Store capture mode for your workload, inspect ALL, AUTO, CUSTOM and NONE, and tune thresholds without losing useful history.
SQL SERVER – Auditors, Passwords and Exceptions – Notes from the Field #010
Weak passwords are like a key under the door mat. Brian Kelley explains what auditors look for around passwords and exceptions in database security.
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.