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?.