Monthly Archives: January 2010

SVN on steroids using beanstalk and integrating basecamp

Posted on by
9

Well, if you consider yourself a professional and care about what you do in your day to day work you probably use some sort of version control system.

Whether you are using GIT or SVN, both self hosted or in the cloud.

Me, I’m a huge fan of cloud services and moving things and services into the cloud, managing my entire work (almost) in the cloud, from my email (GMail) to my backup service (Mozy) and now, SVN.

I will tell you about my solution in this post along with screenshots of what it looks like

Continue reading →

Source Code: Credit card number validation (Israeli Visa)

Posted on by
9

Sometimes, you need more then the simple straight forward validation of a credit card number.

Usually, it’s enough, yet sometimes a client demand or a product demand is to create a more sophisticated validation, using known credit card algorithm that the CreditCard company issues from time to time.

I had just that need a while back.

So, I created the validation and I decided to share it with you here.
Continue reading →

Execute a T-Sql statement on all Databases – Sql Server

Posted on by
1

Sometimes, you may want to execute a single statement (t-sql) on all of your databases.

I had this issue about a week ago, I needed to change my users table on all databases. Because all of my tables are named the same on all db’s (convention) I wanted to avoid the hassle of going through the databases manually with Management studio and just wanted to execute the code on all of the db’s.

Continue reading →

Shrink all databases on server (sql)

Posted on by
1

Database serverIt all started with a client call (like usual)…

About a month ago, I got a call from a client of mine saying he has 2 database servers, each holding about 150 databases.

The servers were both SQL Server 2008, he had 2 HD’s with 74GB each and there was absolutely no space on any of them.

After a short research I found that the backup files were absolutely huge and fill the disk up to a point that the server had no space to store any more data and the website connected to that database crashed.

Without going too much into details why these things happen (bad programming) I will give you a method to fix this.

It is recommended to backup your databases to an external HD before doing this, this way you will have the full backup at all times.
Continue reading →