Get the latest IDENTITY value for all tables in the current database
An interesting scenario, which prompted me to write the script being shared.
[Read More]
Domestic Appliance and Database Locking Troubles
A couple of weeks ago, a domestic appliances purchased recently started flashing a light on the display panel, indicating that something was wrong. I checked the manual that came with it, followed the troubleshooting steps, yet the issue persisted. So I called the Customer Care number and, after a couple...
[Read More]
Automate AG Failover on Standard Edition
Availability Groups (AGs) on Enterprise Edition can be used to group databases and have them failover together to Secondary nodes for example - the key words here are “Enterprise Edition” and “together”.
[Read More]
Creating a SQL Firewall
The idea of a SQL Firewall came to me a number of years ago, probably sometime around 2008, however I have not given it much thought since. It has come up a number of times in discussions with colleagues, managers, and clients however the discussions did not move further.
[Read More]
SQL Linter - Code Analysis
During the course of our development (yes, DBAs do develop code) we use and sometimes write our own tools, scripts, and so forth. Some I use regularly to format code for readability (such as PoorSQL), and others not that often. One of the latter is a SQL linter.
[Read More]