question

newbie 2 avatar image
newbie 2 asked

free site for sql server practices ?

I need to pratice dba stuff or run t-sql stuff on any online sql server site for free. any suggestion please ...
sql-server
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

6 Answers

·
Fatherjack avatar image
Fatherjack answered
best way is to download the latest SQLExpress installer and do it all locally. You will get better performance, greater control and learn faster. You will be able to control all aspects of the server, not just the data. From here [ http://www.microsoft.com/express/Database/][1] [1]: http://www.microsoft.com/express/Database/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
If you need to practice using SQL Server, I'd suggest starting with SQL Server Express Edition, which is available for download, for free: [ http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx][1] A 180 day trial of SQL Server 2008 R2 is available at the same place. If you really need online SQL Server, look at SQL Azure, which is a SQL Server cloud service. It's not free, but Microsoft offer a trial: [ http://www.microsoft.com/en-us/sqlazure/][2] [1]: http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx [2]: http://www.microsoft.com/en-us/sqlazure/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaniSQL avatar image
DaniSQL answered
I also suggest downloading SQL Express edition for free or getting the [developer edition for under $50][1]. However if you dont want to install anything you can go here, register and test sql server for free: [SQL Server 2008 R2 Hosted Trial][2] [1]: http://www.amazon.com/Developer-Edtn-2008-32-bit-English/dp/B003KWQBQ2/ref=sr_1_1?ie=UTF8&s=software&qid=1292966186&sr=8-1 [2]: http://www.previewsqlserver.com/index.htm
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaniSQL avatar image DaniSQL commented ·
I agree. But sometimes you want to try features and you dont have the necessary previlages on your machine to install or it takes few days to get your order...then the free hosted version comes handy until you get things in order :-)
1 Like 1 ·
Oleg avatar image Oleg commented ·
Developer edition for under $50 is a great deal. This is the single best option to use if you want to learn about all available features of the SQL Server.
0 Likes 0 ·
TimothyAWiseman avatar image TimothyAWiseman commented ·
The developer edition is worth it for practicing. It gives you things like the SQL Server Agent and Indexed Views that are not available in Express Edition.
0 Likes 0 ·
Cyborg avatar image
Cyborg answered
Adding to the above answers... IF you are looking for T-SQL so the right place would be [here][1] then [here][2], it covers most of the basics of sql and it have its on SQL Interpreter also. [1]: http://www.sqlcourse.com/index.html [2]: http://www.sqlcourse2.com/index.html
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
While it's not free, just to step outside the bounds a bit, I'd recommend getting a copy of SQL Server Developer's Edition. It's going to give you a very complete tool set, and [it only costs $47 plus delivery][1]. You will then have everything you need to learn all there is to know about SQL Server. Microsoft also offers an [evaluation period][2]. I'm not sure of all the terms, but it could be useful. [1]: http://www.amazon.com/Developer-Edtn-2008-32-bit-English/dp/B003KWQBQ2/ref=sr_1_1?ie=UTF8&qid=1293022109&sr=8-1 [2]: http://technet.microsoft.com/en-us/bb851664.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image
KenJ answered
Sometimes it's nice to have something a little more task oriented than just running some T-SQL. You might try the SQL Server Virtual Labs hosted by Microsoft. [ http://www.microsoft.com/sqlserver/2008/en/us/virtual-labs.aspx][1] [1]: http://www.microsoft.com/sqlserver/2008/en/us/virtual-labs.aspx
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
I was trying to find the labs. I wasn't sure if they were still up or not.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.