What I Write About…
Databases
Helpful posts about SQL Server, Merge Replication and how to tune your databases for maximum performance.
Programming
Mostly focusing on C# and JavaScript but I enjoy exploring other languages such as F# and Python.
Scripting
Automation is the key to productivity, I cover innovative solutions to everyday problems using automated scripts.
Web Development
I cover all aspects of web development with a particular focus on application architecture and security.

InSQL
Query to list all indexes in a SQL Server database
Whenever I’m analysing the performance of a SQL Server database, I often find myself needing to retrieve a list of all indexes for review. Missing or unsuitable indexes are a leading cause of SQL Server slowdowns, so it can be very useful to view the existing indexes to get an idea of how heavily indexed…
SQL Server Replication: How to completely remove replication
SQL Server Replication provides a comprehensive set of features for synchronising data between SQL Server databases and can be configured to suit many different scenarios. As a business scales and its software requirements change, it’s not uncommon for the data architecture to also change. When this happens there may be a need to move data…
Working with SecureString in .NET applications
The SecureString class is a .NET type that provides an increased level of security for sensitive in-memory data. Having said that, the security benefits of SecureString have been widely debated. The general consensus is that SecureString can help to increase application security if used properly, however, the inherent advantages are somewhat limited in scope. Despite…
Overcoming dependency injection hurdles with TinyIoC: A lightweight Inversion of Control container
Sometimes when embarking on a software project you may find yourself wishing that you had a lightweight way of achieving Inversion of Control (IoC) via dependency injection. On the other hand, you might not be very familiar with the principle of IoC, but have heard it can be very beneficial and are looking for a…
InWeb
Chrome Developer Tools: Speed up changes to your web app front-end with Workspaces
Most front-end web developers are aware of the developer tools that are built into modern web browsers such as Google Chrome. Many of these developers also use some of the available features to help debug their applications. However, in my experience, not many developers have put in the effort required to learn the full extent…
How to obfuscate .NET assemblies with ConfuserEx
Software assemblies containing managed code, such as those used by .NET applications can be easily decompiled into readable source code using free decompilation tools. This can present a challenge to application vendors who have a desire to prevent their code from being viewed or changed due to copyright or potential security concerns. For any application…
InCareer
Believe, Empower, Inspire: Don’t Let Your Disability Deter You From Your Career Goals
Guest post by Linda Chase from Able Hire. If we want to (or feel a need to), we can find inspiration around us daily, whether it’s a friend emerging from bankruptcy to become a successful CEO, or simply finding hope in a gentle sunrise. Some of the most exciting inspirational sources are those that appear…
InWeb
Learning the Kusto Query Language (KQL) with Application Insights Logs
Application Insights is a powerful Azure feature for monitoring web applications. It collects a wide range of useful data that you can analyse either in real-time or by executing queries against logs at a later point in time. The logs that are stored by Application Insights enable you to see how your web requests are…
Preventing SQL injection in C# applications
SQL injection is a common attack vector that remains one of the most prevalent security risks for applications today. One of the reasons SQL injection attacks are so pervasive is the fact that injection vulnerabilities are very easy for attackers to discover and exploit, sometimes with devastating consequences. On the other hand, mitigating SQL injection…Categories
- APIs (7)
- Career (2)
- NoSQL (3)
- Programming (23)
- Scripting (10)
- Security (12)
- SQL (12)
- SQL Server Merge Replication (4)
- Web (9)
Recent Posts


