As I was setting up my VPS to host this site, I came across the need to set up an automated backup of my databases. After a little research I found out that SQL Server Express editions did not have such a feature, at which point i was very disappointed.
After some more research I found a few tutorials across the web suggesting to do such a thing with batch scripting, by issuing a BACKUP DATABASE query, sadly this could not work for me.
If I was to set up more databases i would have to add them manually to the batch file each time, which is quite inconvenient and if I were to want a different backup type such as full other than differential or I would like to change the location of the backup, I would have to edit this batch file, once again.
So I have stepped up to the job and created a small console application using .NET 3.5 that would do this for me.
The application has a few features and allows me to change the configuration by using parameters which are run along with the application.
I have shared this application on Google code, you can see the project page here: SQLBackup Utility.
You can also view the source here: SQLBackup Utility Source.
Update: Now added Dropbox upload functionality have both local and remote copies.
Feel free to use it by the terms of the GNU General Public License v3.
Windows Live Writer is a great editor, i cannot possibly express the value of a good editor used for adding and editing content on the fly.
It is already implemented in many great existing blog systems out there, and it isn’t hard implementing on your own website. It is a great editor and i think you would be crazy not to use it.
Other than that, Windows Live Writer has a large amount of plug-ins that you could download from the Live Gallery over at Live Gallery. An example of that would be the PreCode Snippet, If you ever used Syntax Highlighter you know how important it is for a technical blog, and the benefits of such a tool.
the PreCode Snippet allows you to link to code straight in your editor in a convenient way, no more messing around with tags or escaping ‘<’ characters by yourself.
Here is an example of what PreCode could do, and what it looks like on a real site.
|1 2 3 4 5 6 7 8 9 10 11 12 13 14 15||
I Highly recommend implementing this great editor for use with your website or check if your current blog system supports it.
When i was working on my site, i was looking for a good authentication system solution, apparently that solution was right under my nose.
ASP.NET MVC 2 Built in authentication system.
This is a complete authentication system including User registration, logging in, Managing users and editing roles. I thought this will be a great solution as i did not need much from the authentication system.
Also this system can be easily transferable from project to project, and will run on any ASP.NET Server which is great!
I thought I’d share this experience, I have also edited the authentication system to comply better with IoC and MVC Concepts
There is a solution file at the end of this post for those wishing to just poke around.
I always thought those kind of comments are pretty silly, yet they are so common.
What could possibly benefit you from being the first commenter on some article of some sorts?
Thats beyond me, anyway back on topic.
I will also test out the comment system provided by Disqus, I have seen a great increase in this commenting system being used, including high traffic websites so i thought i’d give it a try, and i must say it feels great so far.