By Thomas Hundley on 7/12/2008 9:19 PM

A security update from MS broke the production server for the first time in who knows how long.  The automatic installation of the hotfix for KB948109 failed and messed the SQL services up.  I rebooted and tried to reinstall it and the same thing happened, although this time simply restarting SQL worked to fix it.

I'm going to look into this a bit later and get it fixed on but wanted to throw this up on the blog.  It also brought to light that I need to get a monitoring system put back on this server.  I used Alert Site in the past and they were great and were reasonably priced, so I'll probably go with them again.

Read More »

By Tom Hundley on 7/8/2008 3:55 PM

The Telerik RadGrid automatically goes to the last page of the grid when inserting records, which is fine you don't care about seeing the newly inserted item.  This code will show you how to select the page and row which was just created.  The commented code at the bottom will also show you how to open the record in edit mode in cases where you need the page opened in such a manner. 

Simply subscribe to the PreRender event of the grid, enumerate the datasource directly to get the new records row index so that you can determine the page index and there you go.  Note that the Items collections on all of the grid objects only have the total number of items in that page, which is why you need to enumerate the datasource.

  ... Read More »

By Tom Hundley on 6/15/2008 12:26 AM

Remote testing of web services via HTTP was diabled by default after .Net 1.0, so now you can only invoke test methods with your browser on the server. 

Should you ever find the need to enable it again, add the following to the system.Web section of your web.config:

<webServices>
  <protocols< ... Read More »

By Thomas Hundley on 6/14/2008 8:48 PM

 

I only need to do this every so often, but I always forget how to and end up looking it up.  Thus, I'm posting it here for reference.

 

 

Read More »

By Thomas Hundley on 6/14/2008 8:39 PM

Here is a script to rebuild all of your indexes on your database.  I find that indexes are often ignored once an application moves to production.  It's a good idea to evaluate your usage patterns and setup automated maintenance jobs to proactively rebuild indexes before fragmentation has a chance to adversely effect performance.  This is especialy important if you are using guids as primary keys and don't move the clustered index to a more logically sequential column. 

 

 -- Show fragmentation for all tables
EXECRead More »

By Tom Hundley on 4/8/2008 10:46 AM

I changed the IIS SSL bindings to bind the cert to one specific IP address
instead of the default "all unassigned". I changed this back and everything
works great. I can't imagine this is by design- this has to be a bug!  MS?

Read More »

By Tom Hundley on 3/14/2008 1:21 PM

 Problem: IIS 6.0 / Server 2003 Event Log Entry: "Unable to get the private bytes memory limit for the W3WP process. The ASP.NET cache will be unable to limit its memory use, which may lead to a process restart. Error 0x80070005". 

Read More »

By Tom Hundley on 3/4/2008 3:15 PM

This is just bad bad bad ju ju! 

Read More »

By Tom Hundley on 2/10/2008 11:59 AM

Seven servers, one network inlcuding firewall / vpn, dns, dhcp, active directory, sql, iis: four hours.

Read More »

By Tom Hundley on 2/10/2008 11:39 AM

 Initial Reviews:  Two Thumbs Up for Windows Server 2008!!!

Read More »