Noah Witherspoon creator of the free iPhone app “Tris” is being sued by the Tetris company over his app. He announced today that he has to take it down due to him being a student with no resources for a court fight. Hands down the best free app in the appstore is now going away, but you can still get it. The bullies have won and he will take it down on wednesday. May I suggest a new name? “NotTetris”
Thanks Noah for your hard work and keeping it free!
If you work with MS SQL server and have databases that handle lots of transactions then you no doubt have encountered the .ldf file growing to insane sizes if left unchecked. A large LDF file will result in the web application running extremely slow or most likely just timing out, not to mention affecting the performance of other databases setup on that same server. We used to manually detach the database rename the .ldf, once you re-attach the .mdf file it would start up a new .ldf log file and things would run speedy once again. While that worked it resulted in downtime, wasted resources, and unhappy clients.
Here is a solution that works perfectly and is automated. (assuming sql server 2000 or 2005 standard here)
- Launch Enterprise Manager and open Management
- Right click on Database Maintenance Plans > New plan
- Pick all your options to backup your database with the schedule and save the plan
- Drop down SQL Server Agent
- Right click on Jobs > New Job
- Give it a name and click on the second tab “steps“
- Add a second step under the initial backup by clicking New
- Choose Type TSQL, pick the database, and paste in this command
BACKUP LOG dbnamehere WITH TRUNCATE_ONLY
DBCC SHRINKFILE(dbnamehere_Log, 1)
- Save it, click on step 1 hit adavanced and set “On success action:” to “Goto Step: 2” or it won’t run.
We have a log file that used to run to 18 to 30GB quickly and now it is 1MB on a daily basis, pretty sweet and with no real down time. We have tried backing up the log and tried the built in shriking options with no luck, never worked. Sure there are plenty of other methods you can use, hope this helps someone else out there facing the same problem.
We basically hit upon the next new trend in refreshments for business meetings that we are pretty positive is going to blow minds this summer — Otter Pops. No boring refreshments like colas, water, coffee or peanuts. We hope to have everyone sporting a day glow pop like some kind of radioactive glow stick protruding out of their mouths while we go over proposals — okay maybe it’s just a phase, but they’re quite refreshing. And thanks to Vince’s childhood reminiscing, we are now addicted to these (I’m partial to Alexander the Grape).
