SVN on steroids using beanstalk and integrating basecamp
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
Source Code: Credit card number validation (Israeli Visa)
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 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.
Execute a T-Sql statement on all Databases – Sql Server
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.
Shrink all databases on server (sql)
It all started with a client call (as 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.
Pages
Me
RSS
Categories
- actionscript
- asp.net
- Concept
- Flash media server
- Flex
- General
- JavaScript
- jQuery
- Product management
- Ruby on rails
- Sql server
Archives
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
Recent Posts
- gitignore template for flex projects
- jQuery colorbox plugin no opacity (overlay) – IE7
- flash media server security hardening
- set button width to text width in flex
- jQuery, wait for animation to end then do something
- Copy object properties to another object – Flex
- YUI Calendar page to the selected date (multi calendar)
- Empty dialogs in flex builder 3 + Flash builder 4
- Git export (like SVN export)
- Access flex application through the SWFLoader component
- Flash builder 4 – sharing a project with your team using SVN Screencast
- Change WebOrb default port from 2037 to what you want
- Dynamic streaming (Adaptive bitrate) using Flash media Server
- Enumeration on a property – Flex 3
- Backup all databases (SQL Express) with a single T-Sql
Tags
Resent Comments
- forex robot on set button width to text width in flex
- Avi Tzurel on jQuery and UpdatePanels (Asp.Net)
- Corrado on jQuery and UpdatePanels (Asp.Net)
- acne treatment on Solo standalone mp3 player to embed in a page
- Avi Tzurel on RTMP being blocked by firewalls – Flash media server
- Max on RTMP being blocked by firewalls – Flash media server
- Graciela Gonzalez on Backup all databases (SQL Express) with a single T-Sql
- Avi Tzurel on Dynamic streaming (Adaptive bitrate) using Flash media Server
- Nikola Dachev on Dynamic streaming (Adaptive bitrate) using Flash media Server
- Wordpress Themes on Copy object properties to another object – Flex
