Blog

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

InSQL Server Merge 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

InProgramming Security

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

InProgramming

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…

Chrome Developer Tools: Speed up changes to your web app front-end with Workspaces

InWeb

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

InProgramming Security

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…

Believe, Empower, Inspire: Don’t Let Your Disability Deter You From Your Career Goals

InCareer

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…

Learning the Kusto Query Language (KQL) with Application Insights Logs

InWeb

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

InProgramming Security SQL

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…

How to use tuples with named fields in C# by example