Let’s first discuss the problem. We use Hijri calendar and SQL server uses Gregorian calendar. And SQL server has restriction on the Gregorian dates earlier than 1753. But SQL server saves dates internally in another format (It’s neutral and doesn...

Many of us encountered a lot of problems when installing Microsoft Enterprise Library on production servers, you may face or see error like " System.Security.SecurityException: Requested registry access is not allowed" Simply to deploy your web...

app.config and web.config are very powerfull techniques for managing application settings. For more information about using configuration file please check this article in MSDN But the manipulation of these files has 2 issues 1) There’s no class...

I was working in a small project in which I should deploy the database on the production server with Encrypted Stored Procedures . I had to open each and every stored procedure in the database to add WITH ENCRYPTION keyword to them to be encrypted. I...