Use modify_date to find recent SQL Server object changes, compare databases, and understand which audit questions need event capture.
JSON_OBJECT and JSON_ARRAY: Building JSON in SQL Server 2022
Build JSON_OBJECT and JSON_ARRAY values in SQL Server 2022, control null handling, nest arrays, and compare rowset and aggregate output.
A Shrink That Stops Blocking Others: SHRINKFILE WAIT_AT_LOW_PRIORITY
A shrink at 4 PM on Friday can block your whole app. See what the low-priority option does, and why shrinking is still a rare tool.
MySQL – Generate Script for a Table Using SQL
SQL Server needs SSMS to build a CREATE TABLE script, but MySQL can do it in SQL. Here is how SHOW CREATE TABLE returns the script for a table.
Rarely Run Queries in SQL Server: What the First Run Pays
Rarely run queries start with a plan that has left the cache. This test compiles a five table report procedure and measures the compile CPU on the first run, the second run, and a run after the cache was cleared. It also shows how to check whether a plan is still cached.
SQL SERVER – SSIS Execution Control Using Precedence Constraints – Notes from the Field #021
Tasks running in the wrong order in your SSIS package? Tim Mitchell reviews the essentials of precedence constraints for SSIS execution control.
Connect to MySQL From the Command Prompt: Host, Port, User
To connect to MySQL from the command prompt, you pass a host, a port, a user and a password to the mysql client. This post runs every switch, then shows the exact error that a wrong port, user, password or database produces.