SQL Server Express Remote Connections

I’ve been doing some work with SQL Server replication over the last few days, and in order to acheive this I was replicating between one of our DB servers and a SQL Server Express instance on my desktop. To my surprise, setting up remote connections to Express is actually a... [Read More]
Tags: sqlserver

Protecting .NET Code with Dotfuscator

Although .NET compiles into binary .dlls, these assemblies are extremely easy to reverse-engineer using Reflector, or any other decent Reflection tool. Although it’s not completely secure, the simplest way to protect your code is to run it through the free obfuscation tool that comes with Visual Studio: Dotfuscator Community Edition.... [Read More]

Using Microsoft's Performance Monitor Tool

Knowing how to use PerfMon can be absolutely critical when faced with unknown performance problems on large information systems. When you’re faced with a performance bottleneck in a large server farm, it can be very difficult to track down issues as minor hiccups can have knock-on effects that are far... [Read More]
Tags: perfmon

Encrypting cookies with ASP.NET

I hadn’t noticed it before, but ASP.NET provides a really simple way to encrypt your cookies. Cryptography is a field best left to the experts, but for simple encryption purposes this method is perfectly adequate. [Read More]
Tags: asp.net

SQL Server Query Plans

The caching of query plans in SQL Server is extremely important when it comes to application performance. The way this works is not very well understood - I still don’t get all the intricacies of it but as a general rule of thumb, it’s a good move to either: [Read More]
Tags: sqlserver