This is a quick guide to show you away of creating as many dynamic controls as is required on a web page. For some reason a lot of developers typically seem to struggle when dealing with dynamic controls. They really are not that difficult to understand so long as you follow a few basic rules and understand a few myths about dynamic controls. More...

This can be really useful if you have a run away workstation or application that is running on a specific client host which is hammering a data server. It will allow you to kick all the connections from that specific host very quickly. Before running the stored procedure you may want to make sure which hosts have the most logins if you don't already know. By running the following ... More...

The goal of this is simple. To resize an image to a certain maximum width or maximum height. For this i have created a couple of function's for dealing with image size. Of course the trick here is to maintain the aspect ratio of the image during the resize operation to make sure that the image will not appear squashed.

Here are the functions More...

So many people have written ms sql index rebuild script that there are already so many to find on the internet. However not many people have written a small simple application that simply solves the problem for most people. Allowing them to connect, view the status of the index's and rebuild them if required.

Main Features so far

Here is a quick guide to get the new value of NEWSEQUENTIALID() when inserting a row into a table in ms sql. If you have attempted to use NEWSEQUENTIALID() before you will know that it is only possible to use as a generated value in the table when the row is being inserted. This is a guide to get this value from c# when inserting the row. More...