Author: Jonathan Crozier

InSQL Server Merge Replication
SQL Server Merge Replication is a powerful solution for synchronising data between SQL Server databases. It is useful for working offline, for site-to-site data synchronisation, and for backup system scenarios. However, when replication goes wrong, resolving the issue at hand can prove to be challenging. The number of moving parts means that every time you…
InProgramming
As software developers, working with processes is something that we frequently need to do. Whether it’s checking if a specific process is running, stopping a process, or creating a new process, it is useful to have a reference point for how to accomplish each of these tasks. In the sections below, I’m going to cover…
InScriptingSQL
PowerShell is an awesome scripting language with many powerful features. This includes integration with SQL Server; a fantastic database engine that is both reliable and battle-tested. If you need to automate repetitive and/or time-consuming DBA processes, connecting PowerShell to your SQL Server instance can be a massive help. In this article, we are going to…
InSecurity
Sometimes when you are developing a Windows app you’ll find the need to run the application as a different user, often as the administrator. Windows features a security mechanism called ‘User Account Control’ which prevents applications from launching with elevated privileges without the user’s consent. In this article, I explain how User Account Control works…