July 25, 2011 at 7:26 am
I'm after a bit of advice regarding anyone using a test setup/environment at home.
I currently dabble with SQL Server (business systems analyst) every now and then at work to extract data, run multiple updates etc instead of doing it manually in the front end also restores and backups in our test environment but I'd really like to increase my skill set as much as possible. Any spare time i have at home (two young kids allowing) i spend swotting up on T-SQL but not sure how i can increase my knowledge when it comes to SQL Server itself.
I have a laptop and desktop (family use) and was considering building another machine to run as a server for home use to backup my backups of pictures, music etc but thought i could also stick SQL Server on there as well and start getting my hands dirty with log shipping etc.
Just seeing if anyone faced the same dilemma, if so how did you set up a test envrionment.
Any advice would be much appreciated
Thanks in advance
Karl
July 25, 2011 at 7:34 am
You could always install SQL Server development edition. You can set up VM ware on your laptop to play around with log shipping, replication etc.
-Roy
July 25, 2011 at 7:37 am
Thanks Roy, yep i've got a copy of Dev Edition suppose i'm just seeing the best way to get experience of log shipping, replication etc
July 25, 2011 at 7:37 am
Installing SQL Server at home is a start. A standalone will work just fine for a while but when you're ready, you could drop a few bills on a virtual technology and the developer edition of SQL Server. With those two things, you'll be able to do all your heart desires except for using it as a production instance. You'll be able to play with log shipping, mirroring, clustering, replication, and all that fun stuff with virtual machines.
July 25, 2011 at 1:38 pm
Developer is SUPER cheap... like $40-60. Definitely worth the investment if you want to learn SQL Server.
July 25, 2011 at 1:44 pm
ubeauty (7/25/2011)
Thanks Roy, yep i've got a copy of Dev Edition suppose i'm just seeing the best way to get experience of log shipping, replication etc
IMHO - create several VMs and logship/replicate/mirror between them. It's fairly inexpensive that way and you get a good handle on the setup (at least).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply