An interview practical: fix a SQL Server installation failure when the rule Setup account privileges failed. Here is the answer.
SQL SERVER – Script: Finding Cumulative IO Per Database File
A simple script to find cumulative IO per database file in SQL Server, and the real scenarios where this number helps you.
MySQL – Date and Time Related System Functions
MySQL has several date and time related system functions, like curdate(), curtime(), now(), current_timestamp() and UTC versions such as utc_timestamp().
SQL SERVER 2016 – Comparing Execution Plans
A query runs fine in test but slow in production? SQL Server 2016 tools add a way of comparing execution plans so you can find what changed.
MySQL – Get Latest Identity Value by Inserts
In MySQL, use the LAST_INSERT_ID() function to get the latest identity value after an insert, like @@IDENTITY or SCOPE_IDENTITY() in SQL Server.
MySQL – Different Methods to Know MySQL Version
Three simple ways to find your MySQL version with SQL: @@version, the version() function and SHOW VARIABLES, plus why the server version matters.
SQL SERVER – Trick – Running SSMS With Different Windows Account
Many admins have a regular and an admin login. Instead of logging off, here is a trick for running SSMS with a different Windows account on the same desktop.