Archives for Software Dev - Page 49
Windows (AD) Authentication and the Authorize Attribute–Login Popup
The attribute kept throwing a 'login' popup even though the user was logged in via windows problem is that the attribute uses the following line to determine if a user…
Linqer–Convert SQL statements to LINQ
LINQPad, the most popular LINQ tool out there , does not convert SQL statements into their equivalent LINQ syntax. However, a free tool called Linqer does just that. Linqer takes…
Disabling comments for wordpress posts
For each page, on the 'edit page' page in the dashboard, click the 'screen options' near the top right. Check the 'discussion' box there; scroll down to below the page…
SQL Server Database CPU Utilization and Memory Usage
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 instance. These…
ROLES for a typical web application
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 users cannot.…
Upload entire solution into TFS–first time
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 not 'checked…
The quickest way to compare two lists (for matching entries–i.e. duplicates)
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 second Go…
Filesystem notes from the real world–C#
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 StreamReader) if…
Custom authentication filter in ASP.NET MVC
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, as I…
Overall Strategy for Monitoring SQL Server Performance
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 : Memory…