http://blog.exo-brain.com Thu, 21 Feb 2008 00:38:08 +0000 http://backend.userland.com/rss092 en Performance tuning in SQL Server is unendingly complex. At the basic end of the scale are indexes, query plans, disc-based I/O distribution, and the like; more complex issue demand a lot more investigation and care. Because the query optimizer's job is most heavily centered in disc access ... http://blog.exo-brain.com/how-to-generate-test-data-in-bulk/2008-02-21/ Anybody who's ever had to work with a SQL Server object without being told which database it lives in, or worked in a huge schema - like Great Plains or SAP - should find this post interesting. There are several ways to search for a database object by its ... http://blog.exo-brain.com/sql-server-object-search-advanced-t-sql/2008-01-30/ Most of us have an interest in protecting our content from digital thieves, which, sadly, the internet is full of. There are any number of ways a person can steal content from your site; in this article we'll look into frames. They generally fell out of favor ... http://blog.exo-brain.com/breaking-out-of-frames-except-google-images/2007-10-16/ "Rewriting" means intercepting a request from the web, and responding with the document behind a different URL. If this sounds like a redirect, it should; the main difference is that we'll be doing this internally, without the client's knowledge. ( The "client" is Internet Explorer, FireFox, Safari, ... http://blog.exo-brain.com/url-rewriting-in-asp/2007-10-07/ There are any number of reasons to want to programmatically interact with resources on the web. Some of the more well known are browsers, like Internet Explorer, FireFox, and Safari; search engine spiders like GoogleBot; and RSS readers. Less famous are automated testing tools checking for 404 (Page ... http://blog.exo-brain.com/requesting-web-url-status-from-net-code/2007-09-22/ For better or worse, exceptions are a part of life. Any non-trivial application is going to generate them, at least occasionally, when something exceptional happens. One shouldn't rely on exceptions for control of flow; return values are much better at this in many ways. And a ... http://blog.exo-brain.com/displaying-graceful-exception-info/2007-08-06/