2. March 2011 19:18
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...
1. March 2011 22:18
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...
1. March 2011 22:06
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...
Tags: c#, image, resize
24. February 2011 21:05
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
- Provide list of index's with fragmentation percentage
- Take recommended action on fragmented index's
- Rebuild selected index's
- Rebuild all index's in a database
You can read more about it here
23. February 2011 18:22
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...