C# Coding Standards and Naming Conventions

In this post I outline a number of coding standards and naming conventions I use. My company Magnifica is a Microsoft software development company, so I'll be concentrating on C# syntax. The standards you should choose are down to personal »

Create a random string with fixed characters using SQL

Recently I needed to recreate a large number of 8 character alpha-numeric access codes in a customers database as users where confusing certain characters i.e. 1/l and 0/O. I wanted to avoiding doing a code deployment to »

SQL Server Management Studio Keyboard Shortcuts

It can be a bit of a pain when writing long SQL statements when you want to check a table for data. Some people write the full 'Select' statement, some use the side bar, I use a keyboard shortcut to »