Archives for Software Dev - Page 48
LINQ–search for items in a list that are present in another list
Suppose you have a list of strings – a nursery rhyme may be a good ; And you need to find ALL the words that match from another list of…
Prevent URI (XSS) rewrites in asp.net
The method is well suited to check for any malformed URLs. It can be used to validate the address and the entire query newUrl = ; if (!(newUrl, )) {…
Update EDMX model with database changes
Open the EDMX file within Visual Studio – use an Open With command from the right click menu Open With -> Entity Data Model Designer Right click on the designer…
Data Security in SQL Server (and other databases)
If you have sensitive data ( HIPAA data), you need to consider both encryption as well as SALTING of your data at the database level. Encryption Prior to 2008, SQL…
IIS–websites versus app pools
A lot of people tend to use these interchangeably. From IIS’s perspective, a website is nothing more than a physical folder (and possibly virtual directories as well). That is -…
Top 20 worst performing SQL Server queries
Top 20 worst performing queries --------------------------------- and thus you would see "similar" query text in the proc cache each with its separate compiled plans */ DECLARE @SQLString nvarchar(500) DECLARE @cnt…
Adding a user to subversion, granting access to a subfolder
Let us say you added a new user (called newuser) - and want to grant her access to your subfolder myproject/sourceYou would modify the Authz file - by adding the…
The directory ‘/App_GlobalResources/’ is not allowed because the application is precompiled
Publishing an website gives the following error.: The directory '/App_GlobalResources/' is not allowed because the application is precompiled. All you need to do, if your site is Precompiled (which will…
Maintenance Plan for SQL Server 2014
These scripts are owned and developed by Ola Hallengren DatabaseBackup: SQL Server Backup DatabaseIntegrityCheck: SQL Server Integrity Check IndexOptimize: SQL Server Index and Statistics Maintenance Download Maintainance Script for…
TFS 2013 –show me all the conflicts only
To only view the conflicts (conflicting files) for pending checkins in TFS 2013, try the following: View TFS Conflicts Only Go to Team Explorer Select Pending changes In the Pending…