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]
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]
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]
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]