In this post, we will show and explain a small TSQL Sql Server 2008 procedure that deletes all rows in a table that are older than some specified date. That is, say the table has 10,000,000 rows in it the accumulated over the past 2 years.
Say you want to delete all but the last 30 days of activity. If you just simply say DELETE FROM table WHERE id>10000, you will cause this to happen in one transaction and likely, you will get an error. That’s the best case. The worst case is your system tries to do this, eventually consumes all the resources in your computer and crashes your server.
(more…)
In this post, we’ll go briefly the process of how you would update all rows in a SQL Server 2008 table such that a particular date column will be moved back 1 hour in time. This is actually pretty simple, but being that I typically do my work in the ORM layer (that is LINQ2SQL or Entity Framework), I just don’t do much of this. The process I’m going to follow is first to use Microsoft SQL Server Management Studio to make sure I know what I’m doing with the Sql Server 2008 functions, then add it to an UPDATE statement.
(more…)
For the past couple years, I’ve used a product called FinalBuilder from VSoft Technologies to automate my build processes. Since I’ve been building web sites (about the past 5 years or so), one of the biggest hassles is maintaining them. That is, updating the databases, deploying the web site, automating backups, etc. I’ve used several products like FinalBuilder (including Cruise Control), and to be honest, none of them come close to the quality of FinalBuilder.
Basically, the way the product works is that you create a “project” file using the FinalBuilder IDE. That project file has “Actions” in it which do things like “ftp” files to servers, rename files, iterate over sql scripts, parse and update files, checkout from source control, as well as hundreds of other convenient functions. You then execute that “script” file and all the magic happens.
(more…)
Many of you know of ORCSWeb either by reputation, or by way of Scott Forsyth, one of my ASP.NET MVP brothers. In case you don’t, they are a managed hosting solutions company specializing in Microsoft technologies. I’ve used their basic services for quite a while and have always been very happy. It has always seemed that anytime I’ve called them (and it always seems like the middle of the night) one of their tech support staff is always available to help me, and go the extra mile if necessary.
The company I’m now working at is small and we don’t have a lot of resources to maintain hardware and do operating system type support. We do have a high load requirement so we need a very robust supported solution. Before this, I’d always been in the under $50 per month type plan with ORCSWeb, but I decided I needed more servers and a higher level of support. I really did not know what level of support to expect when signing up for the managed servers but decided to go for it anyway.
All can say is WOW!!! I am over the top impressed.
(more…)
We’ve been looking to find the best Cloud based host to put our soon to be virally growing web site up on. Our requirements are it must run IIS7 and use Sql Server 2008 as it’s database. We have lots of wants (like Service Broker, Replication, etc.) but primarily we want the web tier to scale easily. After doing research and testing, we got frustrated with our options at Amazon’s EC2. We emailed their support (with our paid support contract) and were basically told we should go do our own Windows research to find out what works best.
At any rate, I emailed Steve Evan’s who is a frequent speaker at conferences and also an expert consultant on all things Windows and IT related and asked for some advice. He told me that he had been asked that question often recently by others so he would do some research and get back to me. He did one step better. He wrote a blog post describing the ups and downs of the different cloud providers including Amazon’s EC2. I respect Steve’s opinion a lot and rather than try and paraphrase it, I’ll just link to his post.
Here it is: http://serktools.com/2009/04/20/load-balancing-iis-web-farm-on-amazon-ec2/
Good luck and feel free to post comments here if you’ve got opinions on Cloud Hosting of IIS and Sql Server 2008.
