I've been learning ASP.NET (http://www.asp.net/), and attempting to learn MS SQL to go along with it. I have the basic syntax, data types, etc, of MS SQL; it's not all that different to MySQL. However, there's obviously a lot I don't know about more advanced features, or even anything above the bare basics.

I've looked on Google but have been hard pressed to find anything of use.

So what are some resources for MS SQL 2005?

Thanks a lot for any help.

The MySQL.org Website. -_- That is, if MSSQL is not that different from MySQL.

The MySQL.org Website. -_- That is, if MSSQL is not that different from MySQL.

Why exactly would I want to go to the MySQL web site to learn about MS SQL?:confused: They are totally different.

Thanks for the reply, anyway, though.

I did find a reference for what is apparently called Transact-SQL (http://msdn2.microsoft.com/en-us/library/ms189826.aspx), which covers syntax but not much on practical usage. I think we need an SDK on MS SQL. :)

You might want to have a look at SQL Team.Com (http://www.sqlteam.com/)

They have plenty of articles and a great forum with lots of gurus. SQL 2005 is the next step after SQL 2000 and only came out 6 months ago.

So if you find good SQL 2000 resources learn them, than just check out the improvements in 2005 and you should be well on your way.

:peace:

Why exactly would I want to go to the MySQL web site to learn about MS SQL?:confused: They are totally different.

Thanks for the reply, anyway, though.

I did find a reference for what is apparently called Transact-SQL (http://msdn2.microsoft.com/en-us/library/ms189826.aspx), which covers syntax but not much on practical usage. I think we need an SDK on MS SQL. :)

Then why'd you put the below statement in your first post?

I have the basic syntax, data types, etc, of MS SQL; it's not all that different to MySQL.

iyeru42: Because the syntax is similar. But it's really absurd to think of going to the MySQL site to learn MS SQL, since I want to learn the specifics of MS SQL. No offense. :) I've been working with MySQL for nearly 6 years now, so am vary aware of the similarities. But MS SQL, from what I've seen, has a lot that MySQL has just recently delved into with MySQL 5.0, and some of the features MySQL doesn't even have support for.

JBelthoff: Thanks a lot for that link! I will surely take a look at that. Yeah, I know MS SQL 2005 is pretty new; I've been having some time trying to find a host with MS SQL 2005. :( I'm really liking it though.

Here:

http://msdn.microsoft.com/SQL/default.aspx

See also:

http://search.msn.com/results.aspx?q=site:www.microsoft.com+sql+server+2005&FORM=MSRE

I'd highly recommend grabbing an MSDN subscription to get access to the private forums as well.

KGIII

Grr... Missed this link:

http://www.microsoft.com/downloads/info.aspx?na=90&p=&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2f9%2f4%2fe%2f94ed5837-9582-4395-a36a-41e3cf6df9e9%2fSqlServer2K5_BOL_Apr2006_v2.msi

It's huge but should cover what you want to know.

KGIII

KGIII, thanks a lot. What's in that final link you gave?

Aren't msdn subscriptions a bit, erm, expensive? I was trying to look for pricing the other day but couldn't find much. MSDN is difficult to navigate at times.

I've been looking at the "books online" section of msdn for MS SQL, but again that seems like mostly syntax. I'm looking for a few tutorials on some of the intermediate features of ms sql.

Expensive? Nope... Grab that link (the last one) it's supposed to be a book... It's all you *should* need really?

Download the Updated SQL Server 2005 Books Online :
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

It comes from there... Is MSDN expensive? I don't think so but then again Microsoft has given it to me lately so it's not expensive to me at all? To be honest, well if I told you I was one of the early Microsoft MVPs who's still with the program would you hold it against me? I'm actually a *NIX convert? Really? Except I still host with and sell Linux hosting?

The question becomes if you want to develop then can you afford to NOT have an MSDN subscription. Often you can cheat and get your work-place to buy one though. ;)

I have been tempted to actually let people "work for me" so that they can have the access to it but they all need to clearly be used for non-commercial works. Tempting but there's some fine lines that'd have to be toed for me to do that.

KGIII

Well some things you can download without an MSDN subscription, but how much is the subscription itself?

Yeah, I'm getting to be fond of Windows myself lately. .NET is really an amazing platform/framework/whatever you want to call it. :D

http://msdn.microsoft.com/vstudio/howtobuy/default.aspx

It's a bit over 10k for a full version. For 1200 clams you get VS plus all the OSes and libraries. The license is different, you can't just expect to pay 1200 bucks, grab your Server 2k3 Web Edition and SQL server, load 'em onto a box, and send them into be a COLO system to start your own hosting company.

You can read a bit about the licensing here:

http://msdn.microsoft.com/subscriptions/licensing/

I'm actually a Microsoft Partner as well as a System Builder from days of yore but, thankfully, I'm in recovery. ;) Now I just chill in the newsgroups and do the whole MVP helpful thing. It's a good time really.

KGIII

Download SQL Server Express, install, press F1!

null,

I already have MS SQL 2005 Express, but I believe youa re refering to the books online documentation? I have already been reading this online, but this mostly discusses various functions, etc. i was more looking for a few introductory tutorials.

For instance, today I learned a bit about optimistic concurrency. My question is, when is it appropriate to use, and when is it not? Just an example.

You're likely familiar with Usenet?

news://msnews.microsoft.com

That should get you there for specific questions.

Much of what I'm finding online would be probably illegal from the looks of it? They appear to be "borrowed" CD contents from the books. You buy a tech book and the CD that also contains it all in CHM or PDF format? Yeah? Those are out there when I try looking for specifics.

For a question like the one you JUST posed I'd head to the newsgroups.

KGIII

OReilly has a Book called SQL (in a Nutshell). The synthax covers Oracle, MS SQL and Mysql. I'd look on Oreilly web site.

OReilly has a Book called SQL (in a Nutshell). The synthax covers Oracle, MS SQL and Mysql. I'd look on Oreilly web site.