question

maltova avatar image
maltova asked

how to learn sql server

Hi all, I recently migrated from mysql to mssql. Please suggest how can i learn mssql efficiently. Thanks in advance, Ramu
sql-server-2005sql
10 |1200

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

Fatherjack avatar image
Fatherjack answered
2 comments
10 |1200

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

BOL! Answers at your fingertips - interpretations are at http://ask.sqlservercentral.com
1 Like 1 ·
+1 for practice.
0 Likes 0 ·
Cyborg avatar image
Cyborg answered
Check out this link from SQL Server Guru Brent Ozar [books for DBA][1] for Devloper see [books for Devolper][2] [1]: http://www.brentozar.com/best-sql-server-dba-books/books-for-sql-server-dbas/ [2]: http://www.brentozar.com/best-sql-server-dba-books/books-for-sql-server-developers/ Read Blogs, Participate in SQL Server communities
10 |1200

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

ramesh 1 avatar image
ramesh 1 answered
http://www.sqlhacks.com gives you a good collection of queries to be used while looking into performance of mssql server you can also learn efficiently on sqlserverperformance.com this stuff really works, gr8 work done by mssql legend pinal dave. he expalins every thing with real time examples this will be really great RAMU http://www.freeebooksblog.com/free-ebook-how-to-become-an-exceptional-dba/ RAMESH
1 comment
10 |1200

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

@ramesh - If you think of more points to add to your first answer can you please use the Edit link under your first answer and then you can add extra information there. Thanks.
0 Likes 0 ·
Matt Whitfield avatar image
Matt Whitfield answered
Get involved in the community, and try to give back. I have been posting/ranting/larking about here for about a year now (side point - is it time for a first birthday bash??) and I have learnt more in that year through trying to help people with their problems than I have done in the past 12 years of using SQL Server. As a result of my participation here, I was invited to speak at a conference in Sweden, and then registered and was accepted to speak at SqlBits - and doing that furthered my understanding of the CLR in SQL Server because of the research required. Then I attended the training day @ SqlBits and learnt more in 8 hours with a guy called Maciej Pilecki than I have in any other day, ever, period. So yeah, get involved.
10 comments
10 |1200

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

+1 for getting involved.
1 Like 1 ·
@Hakan - Johan Ahlen has asked me to present at his conference which I think will be early next year - so hopefully that will happen... :) I must say, the more people from here that I meet, the more people from here I want to meet!
1 Like 1 ·
@WilliamD - awesome - let me know and I'll submit something in the vague hope that someone gives a s**t!
1 Like 1 ·
-1 to myself for missing the conference in Sweden. :( It would have been fun to meet you in real life.
0 Likes 0 ·
@Matt - have you considered offering up a presentation for the PASS European Conference? It is around April time and I would have to make sure that I came along to meet/see you.
0 Likes 0 ·
Show more comments
Håkan Winther avatar image
Håkan Winther answered
Great answers from everyone. I have learned a lot at this site (not just the ask section, but also the QotD section) and most of my performance knowledge is from real life and from [ www.sql-server-performance.com][1] (sorry for reffering to another site, but I feel that I need to give some credits to them also) Thanks to everyone that is contributing to this site! [1]: http://www.sql-server-performance.com
1 comment
10 |1200

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

Thanks to you, your efforts here are awesome... +1
2 Likes 2 ·
Grant Fritchey avatar image
Grant Fritchey answered
I strongly recommend getting a copy of Brad McGehee's book "How to Become an Exceptional DBA." It's not so much a "how to use SQL Server" as it is a list of things you should study, habits you should develop, things to watch for, things to avoid... basically an excellent selection of advice.
3 comments
10 |1200

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

@Grant, it was good to see your Powershell post on SSC. Has your blog been syndicated there long or is that a new development?
0 Likes 0 ·
Thanks. I've been syndicated there for well over a year now.
0 Likes 0 ·
If I would recommend any books I would recommend Grant Fritcheys books, and books from Itzik Ben-gan. :)
0 Likes 0 ·
philnolan avatar image
philnolan answered
Some great advice here. I've found subscribing to a couple of newsletters (only a couple as any more can be overwhelming) can be helpful as they can throw up all sorts of info that trigger different avenues of learning. I currently have a daily from [SSC][1] and [MSSQLTips][2]. I also subscribe to a number of RSS feeds and set myself the personal challenge of reading a blog a day with a soft rule of once a week picking a blog in an area out of my comfort zone so to speak. Hope this helps. [1]: http://www.sqlservercentral.com/ [2]: http://www.mssqltips.com/
1 comment
10 |1200

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

+1 - valid point about being ruthless with only a few newsletter/feeds/blogs - I currently have 466 unread blogs in Google Reader. They will all get missed as I dont have time to go over them... Find a couple of good sources and stick to what they provide. Its surprising how pretty much everything gets 'broadcast' sooner or later from most of them. Also, Twitter. Follow #sql or #sqlhelp and then pick up a few of the regular contributors. If their profile says MVP then its generally good stuff, in between the insane banter!
0 Likes 0 ·
TimothyAWiseman avatar image
TimothyAWiseman answered
There are lots of great suggestions here. Let me offer two that may be a touch controversial (so take with a grain of salt): 1. Study for the certifications. First, they are good way to learn in a structured, organized fashion, and they specifically target SQL Server which might be even more significant for someone transitioning then someone starting fresh. Also, if your ultimate goal is to get a job then at least for certain employers having that certification can make a difference. This is especially true if you have little to no other SQL Server experience on your resume. 2. Write. Matt alluded to this, but for me writing about something I learned helps me crystalize it in my mind. Anything I think is decent I try to post somewhere like SQLServerCentral.com but even if its not worth posting the act of writing it and thinking through it helps to really consolodate the information for me. Alsot, when I do post the feedback is also helpful. In your particular case, I think there would be some interest in the community in what you see as the major differences between MySQL and SQL Server after you get to know SQL Server a bit.
2 comments
10 |1200

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

I knew some would disagree with the first, and I thought you might be one of them. I know there are a vareity of opinions about the certifications, and there are many *valid* criticisms of them. As someone getting one or an employer evaluating them you should certainly have realistic expectations about them for one. What I can say is that when I was transitioning jobs and new to SQL, the certification study gave me a structured order to my study regimen, a goal to work towards, and a way to test my progress. When I was applying for my first job with SQL more than one interviewer commented on them approvingly, including two that made offers. They are not for everyone. Not everyone wants or needs them. But for some people in some situations I think they can be very useful.
2 Likes 2 ·
I disagree with the 1st one, but the 2nd is absolutely spot-on. Nothing clarifies understanding like writing it down to try to commmunicate it to others. Excellent point.
1 Like 1 ·

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.