Welcome to AspAdvice Sign in | Join | Help

September 2007 - Posts

Caching in ASP.NET Show on dnrTV

I'm on dnrTV this week with a show about Caching in ASP.NET, one of my favorite topics . I think the whole show is a bit under an hour and I go through a bunch of demos and show off some of the less-well-known features of caching, such as cache profiles,
Posted by ssmith | 6 Comments

Case Sensitive or Insensitive SQL Query

Suppose you need to perform a SQL query and you need for it to be case sensitive or case insensitive, and either your database is set up the opposite way or you're smart and you're trying to write your query so that it will work regardless of
Posted by ssmith | 18 Comments
Filed under:

Installing SQL 2005 Management Studio

I've installed SQL Server on a few dev boxes in my time, and one thing I've noted on several occasion is that even if you check the box during the install to say you want to install all of the client tools, usually they don't install. You think they installed,
Posted by ssmith | 53 Comments
Filed under: ,

AJAX Control Toolkit Update September 2007

The AJAX Control Toolkit just released a new version for September 2007. You can get version 10920 now from CodePlex. This release is meant to improve the stability and quality of the controls and includes a bunch of fixes both at the general and control-specific
Posted by ssmith | 4 Comments
Filed under: , ,

Using PowerShell to Automate a SQL Task

I have a very large table in a SQL database that I need to clean up some old data on. I've already copied all of the data to another table in another database with a different schema. I have a legacy application that still uses the old data, but the data
Posted by ssmith | 6 Comments
Filed under: , ,

Consolas Font in Vista

I've recently been experimenting with other fonts for Visual Studio on Vista after reading this article on new fonts in Vista . I think I like Consolas better than Courier New for coding, if only for its novelty. It also tends to be a little bit more
Posted by ssmith | 8 Comments

Managing XSD Files - if you must have them

For an admin application I've been working on, we're using a third party reporting tool to serve up reports to our users over the Internet. The reports have a nice designer that works with XSD files in Visual Studio. Not particularly fond of XSDs as a
Posted by ssmith | 1 Comments
Filed under: , ,

FIX Request format is unrecognized for URL unexpectedly ending in

Adding a new web service to an application today so that I can delay loading some web user controls and ran into this 500 Error when calling the web service: Request format is unrecognized for URL unexpectedly ending in /GetHtml Found this KB article
Posted by ssmith | 7 Comments
Filed under: ,