Summary: An example of how we can create a function in .NET and then use them in SQL Server. This example runs an aspx page (useful for people wanting to call aspx pages from asp) How do we implement this functionality? In order to use CLR we have to: 1) Write a .NET class with [...]

The underlying connection was closed: Could not establish a secure channel for SSL/TLS. What an error! It took me some time to resolve this but basically it went like this. We have a number of web sites that access web services via an https url. The site and the web services reside on the same [...]

I just thought Id post this to hopefully assist others with this problem. I have seen and read numerous posts on IIS permission errors. A number of articles correctly point out that the impersonate user or if not impersonating then the NETWORK_SERVICE account and the ASPNET account, need modify access to the folder you want [...]

In .NET having one site with another underneath in a sub folder will not work if each site requires a seperate web.config, even if the sub folder is a virtual directory as the top most web.config will be used for all sites. So we have really only a few choices; create a subdomain for each [...]

Hot Skills, Cold Skills According to a Computer World Survey, the most sought-after corporate IT workers in 2010 may be those with no deep-seated technical skills at all. The nuts-and-bolts programming and easy-to-document support jobs will have all gone to third-party providers in the U.S. or abroad. Instead, IT departments will be populated with “versatilists” [...]

We recently had the need to remove more chars than less to tidy filenames, so passing the chars I want was too hard, and having a huge list of characters to remove was also too difficult, not to mention you might miss one. I only want to keep [a-Z] and remove all other characters, so [...]