Checking and Updating Identity Seed in SQL Server#

If you want to check and update the identity on tables in SQL Server, you can use the following code:

select ident_current('tablename') as ident
dbcc checkident('tablename',RESEED,100)
select ident_current('tablename') as newident

 

Categories: Programming | Database | SQL Server | T-Sql
Thursday, January 29, 2009 9:13:29 AM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

Offsite backups with Windows Home Server and Crash Plan#

I have been slowly moving files onto my new WHS.  HP is due to release a new software version that allows for users to easily backup their shares to Amazon S3.

I have done a lot with Amazon's S3 service, but I don't feel good about using it for backups for a few reasons.  Primarly, if you want to backup large amounts of data, it IS very cheap, but it is sill kinda expensive.

In other words, it is very cheap compared with other managed storage options, but if you want to backup 500 GB you are still going to be paying a lot of money over the course of a year.

The solution I came across, which appears to be working fine on the WHS machines is Crash Plan (crashplan.com).  I installed it on my WHS and on the WHS I bought for my parents and have configured the 2 to backup to each other.

I won't get into all the details, but Crash Plan:

  • costs nothing for the basic version
  • encrypts your files before they leave your machine
  • sends you emails if a backup has not happened successfully in X days

I have found no problems with running it on WHS.  I even replicate the files crashplan backs up across multiple drives so if my house burns down AND a hard drive at my parents fails, my data will still be safe.

Categories: Misc
Monday, January 26, 2009 2:11:23 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

Performing a Baseless Merge in TFS#

If you create a branch in TFS, you can easily merge it back later, but if you have 2 branches or folders that you want to merge, but are not related (they weren't branched from one another) you need to do a baseless merge.

This article describes the process:

http://msdn.microsoft.com/en-us/library/bb668976.aspx

But the short end of it is that you run the following command at the VS command prompt:

tf merge /baseless c:\source c:\dest /recursive

It will launch the dialog box for you to manage the merge from there.

Categories: Programming | TFS
Tuesday, January 20, 2009 5:00:29 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

Has RJDJ been removed from iTunes?#

One iPhone app that I really like is RJDJ.

http://rjdj.me/

It is very hard to explain it, but it basically takes the sounds around you that it picks up through the mic, and does all kinds of weird stuff to it to make beats/sounds/music etc.

It's really fun, and every single person I have shown this too has loved it, except for 2 people, and they are brothers, and they know who they are.  But everyone else has totally loved this program.

Unfortunately, many users felt that, once they paid the giant price ($2.99) for the full version of RJDJ, called RJDJ Album, that they would get future songs/scenes for free.

Instead, mostly due to how Apple restricts developers in how they can charge for stuff like content/udpates, they released the 2nd "album" RJDJ Shake as another $2.99 app. 

Some users were pissed, and I think they logged enough complaints to have RJDJ removed from iTunes, which totally sucks because I wanted to buy Shake and now I can't!

I wanted to put this post out there so if anyone else was trying to figure out why they can't get RJDJ they might get some answers here.

I hope the folks at RJDJ get this resolved, b/c I think it's an awesome program.  When I get some free time I am going to program some scenes for it, but right now I am spending all my free time on work for my clients.

UPDATE: It's back.

Categories: Cool | Misc
Wednesday, January 14, 2009 9:58:09 AM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

Streaming Audio From WHS#

I have been looking into some of the options for streaming music from my WHS to devices in my house.

So far I don't seem to be finding many good options.  There are some that you point to a UNC share and then have to deal with a crappy UI to select the songs you want.

2 of the nicer options I have see are:

http://www.sonos.com/howitworks/

 

 

and

 

http://www.roku.com/products_soundbridge.php

 

 

 

http://www.roku.com/products_soundbridgeradio.php

 

 

I'm going to have to keep my eyes open for other options, but these seem like viable candidates.

 

Categories: Hardware | House | Misc | Music
Monday, January 05, 2009 10:29:56 AM (Central Standard Time, UTC-06:00) #    Comments [2]  | 

 

Learning Spanish In Cancun Mexico#

I recently had an opportunity to travel to Mexico for some spanish lessons.  I wanted to put up a little write up here so if someone else was searching google for some options they might come across my article.

I arranged for lessons with Francisco Romero of the Cancun Spanish Language Institute.

http://www.studyspanish-mexico.com/

We had a great experience with Francisco.  We opted for an immersion type experience, with Francisco speaking almost no english during our lessons, but unlike some of the other instructors we have had, he was clearly 100% fluent in english, and could help explain some of the nuances in english. 

I would really recommend him to anyone else considering taking language lessons while in Cancun.

Categories: Misc
Sunday, January 04, 2009 4:36:27 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

All content © 2010, Christopher May, Inc
Open Job Positions
On this page
Google Ads
This site
Calendar
<March 2010>
SunMonTueWedThuFriSat
28123456
78910111213
14151617181920
21222324252627
28293031123
45678910
Archives
Sitemap
Blogroll OPML
Disclaimer

Powered by: newtelligence dasBlog 2.3.9074.18820

The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

Send mail to the author(s) E-mail

Theme design by Jelle Druyts


Pick a theme: