Jonathan Crozier

Hi, I'm Jonathan Crozier, I write this blog, mentor other programmers and I'm the Head of Software Development at a successful local business.

Jonathan Crozier

Jonathan Crozier

Software Engineer

What I Write About…

Databases

Helpful posts about SQL Server, Merge Replication and how to tune your databases for maximum performance.

Read More

Programming

Mostly focusing on C# and JavaScript but I enjoy exploring other languages such as F# and Python.

Read More

Scripting

Automation is the key to productivity, I cover innovative solutions to everyday problems using automated scripts.

Read More

Web Development

I cover all aspects of web development with a particular focus on application architecture and security.

Read More
InSQL Server Merge Replication

SQL Server Merge Replication Error: The schema script could not be propagated to the subscriber

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

Working with processes using C#

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

Connecting to SQL Server from PowerShell

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…
Load More (10)