A client wanted to automate backups with a script instead of a GUI. Here is the PowerShell and SMO script I have used for years to backup every database.
The Tale of the Cunning Dev, Encrypted Procedures, DAC and God Mode = ON – Experts Opinion
My friend Syrovatchenko Sergey from Devart tells a detective story about a free tool, Encrypted Procedures, DAC and God Mode. A creative read you will enjoy.
SQL SERVER 2016 – Enhancements with AlwaysOn Availability Groups – Notes from the Field #121
In Notes from the Field #121, Mike Lawell covers the SQL Server 2016 enhancements to AlwaysOn Availability Groups and why this feature keeps getting better.
Refreshing a Test Database From Production Safely
Plan refreshing a test database with isolated restores, safe paths, user repairs, data replacement, disabled outbound actions, and a log.
MySQL – LEAST and GREATEST Comparison Operators
Comparing values across many columns is a common chore. Here is how the MySQL LEAST and GREATEST comparison operators find the smallest and largest value.
SQL SERVER – Unable to Open Maintenance Plan in Management Studio
SSMS refused to open a maintenance plan and showed an error instead. Here is what I did when I was unable to open Maintenance Plan in Management Studio.
SELECT One by Two – Why Does SELECT 1/2 Returns 0 – Interview Question of the Week #067
Why does SELECT 1/2 return 0 in SQL Server and not 0.5? Beginners often think it is a bug. Here is the SELECT One by Two answer, explained simply.