Tools for proactive DBAs: after many AlwaysOn Availability Group projects, John Sterrett hears the same two questions and answers both in this Notes from the Field episode.
SQL SERVER – Drop All the Foreign Key Constraint in Database – Create All the Foreign Key Constraint in Database
Need to drop all the foreign key constraints in a database and create them again? Here is a script by SQL expert Swastik Mishra that does both.
SQL SERVER – Last Full Differential and Log Backup Finish Times
I check backup time separately for full, differential and log backups. One latest timestamp cannot describe the entire recovery chain.
SQL SERVER – Say No to DB Data Roles – SQL Security – Notes from the Field #022
Brian Kelley explains why he avoids the fixed DB data roles db_datareader and db_datawriter, and how they can compromise your server security.
MySQL – List User Defined Tables – Two Methods
There are different methods to list out user defined tables in MySQL. We will see two methods in this post.
Let us create the following tables in the database named Test
MySQL – Generating Row Number for Each Row Using Variable
MySQL has no ROW_NUMBER() function like SQL Server. Here are two methods for generating row number values for each row with a variable in a SELECT statement.
Querying Nested JSON Arrays With OPENJSON
Query nested JSON arrays with OPENJSON, preserve element positions, pass inner arrays with AS JSON, and handle missing or strict paths.