Apart from Query Performance analysis and Schema Objects analysis (indices, statistics etc.), there are two important metrics that are usually sought out for a poorly performing SQL Server…
Read more →
Roles help define WHICH USERS can do WHAT. So – an ADMIN is a super ROLE – wherein all users belonging this ROLE, can do things that regular…
Read more →
Right click solution – Add Solution to Source Control Now, all the files will show up in TFS with a + sign – they have been ‘added’ but…
Read more →
In Excel (2007 and above), place each list of values in its own column. Now, Select cells in first list, then hold CTRL key and then select the…
Read more →
These are just some quick tidbits about file processing in C#. Reading in files, reading in LARGE files, Reading and Processing Large Files. Reading a file (use a…
Read more →
First, I approached this by trying to implement the IAuthorizationFilter interface. THis provides an OnAuthorization method that can be implemented for your custom authentication (see example below). However,…
Read more →
These may not be things you think of before a round of golf. I’ve found that these have a profound effect on how well and freely I swing. …
Read more →
This is just a quick cliff’s notes on what to look for in terms of the Physical Design of the database. The four main categories of concern are…
Read more →
A Cartesian join is an (incorrect) join between two tables. Incorrect because the tables have not been joined in any relational format. Select street_address from authors a, location…
Read more →
Several quirks may pop up – the project may not work seamlessly in your local environment. Entity Framework generates a slew of files – most notably its mapping…
Read more →