I have a copy of SQL server at home which I want to install so that I can start learning it. What is the best setup to have in terms of boxes and OS installed? My main PC is fairly well specced (4gb fast ram 2tb of storage) and is currently running Vista, but given the disk space I could dual boot it if required. The book I bought suggested using a virtual PC - I have virtual server 2005 also plus various copies of windows server OS.
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Learning SQL Server
Collapse
X
-
Learning SQL Server
Rule Number 1 - Assuming that you have a valid contract in place always try to get your poo onto your timesheet, provided that the timesheet is valid for your current contract and covers the period of time that you are billing for.
I preferred version 1! -
no need for the Virtual PC - adds an extra layer of complexity and unless you're planning to go into DBA roles then unnesseccary IMHO.
Install it straight onto the OS, you can install more than one instance if you want multiple database environments.Coffee's for closers -
One good thing about using Virtual PC is you can close it down and abandon all changes to the virtual disk. Pretty handy when you're experimenting with something and screw it up completely.
Never tried with SQL server though.Will work inside IR35. Or for food.Comment
-
What are you trying to "learn". It's not relevant to the spec as it's fine.
Development, DBA or Reporting?Comment
-
Originally posted by Spacecadet View Postno need for the Virtual PC - adds an extra layer of complexity and unless you're planning to go into DBA roles then unnesseccary IMHO.
Install it straight onto the OS, you can install more than one instance if you want multiple database environments.
Windows Server is free to download and use for (I think) 90 days. I recommend CBT Nuggets CD-ROM courses. I trained myself in SQL Server for about £50 using their stuff & a couple of books.Comment
-
I did a similar thing a couple of years ago and my PC's still got various bits of SQL Server on it that I couldn't get rid of - so maybe VPC for that reason.Comment
-
Another vote for using a VPC here - if you end up trashing things as you learn then you can just start over again.
You can grab a pre-configured SQL Server 2005 VPC image from Microsoft that'll work for 30 days.Where are we going? And what’s with this hand basket?Comment
-
Nice link. And if it's a proper self-contained image you'll be able to run another one once the 30 days are up. So as long as you can learn enough to do a full db export in 30 days, you're sorted!Comment
-
Originally posted by thunderlizard View PostNice link. And if it's a proper self-contained image you'll be able to run another one once the 30 days are up. So as long as you can learn enough to do a full db export in 30 days, you're sorted!Where are we going? And what’s with this hand basket?Comment
-
VMWare ESXi is free, although you need a spare box to run it:
https://www.vmware.com/tryvmware/log...FQ-mQwodSzC9XQ
I'm impressed with it, you can build yourself a whole domain if you want to so that you can simulate all sorts of real world situations. Well worth a punt at the priceComment
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Comment