Ok, I’ll admit it. I like scripts that are handy and do things. Especially if the scripts make my life easier. Now, not every environment is the same. Instances get configured differently or things change just due to the nature of the business. In a previous life I would routinely […]
Azure VPN – Point to Site IP Addresses
Recently, I got to work with a client on something interesting. We implemented transactional replication to send data to an Azure virtual machine. This was being done to perform some testing for a project. Given that the two machines were NOT within the same Active Directory domain, we wanted to […]
How to Use SQL Server Startup Procedures
Startup procedures in Microsoft SQL Server allows for pre-determined stored procedures to automatically execute when SQL Server starts. However, it’s not all fun and games. Let’s take a look! After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up […]