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.
Renaming Something Without Breaking Everything
Plan a rename database object change with dependency checks, updated callers, permission tests, and a temporary compatibility name when suitable.
MySQL – Locate the Configuration File – my.ini or my.cnf on Windows Platform
New MySQL users often ask where to find my.ini or my.cnf on Windows. I show a quick way to see which file is powering your MySQL Server configuration.
SQL SERVER – Start Services or Stop Services with PowerShell – Answer to Question
You can check out the original post here: SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?.
SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?
A reader asks why you need the -Force flag to stop services with PowerShell but not to start them. I do not know the answer, so I am asking you.










