•  
  • #SQLHelp

#SQLHelp

Comments: 9 Comments

#SQLHELP

This post will help folks, where to get SQL help quickly from knowledgeable people.       In other words, Where to get right books and website links, blogs and forums to improve their knowledge and to become an excellent DBA.

Recently I got an email from a developer and other folks too.  And its encouraging me to write this post.

“Is it possible to get into DBA with development experience”

“Help on SQL is needed ASAP”

 

1. Web sites

 

Twitter (http://twitter.com/)

Twitter #SQLHELP is a great place to get an answer as soon as possible. Most of the SQL gurus are there, to help you.  I know some of guys don’t know how to use twitter (Initially me too) here is the twitter book of Brent Ozar. http://www.brentozar.com/twitter/book/

SQLServerCentral (http://www.sqlservercentral.com/)

It’s a great website as well as a forum, where I have been learning and answering.

MSDN (http://social.msdn.microsoft.com/Forums/en/category/sqlserver/)

MSDN is Microsoft forum you can find great folks there.

For more SQL blogs visit my home page it has “Top SQL server blogs”  widget links from the worldwide DBAs.

 

2. Books

 

Here is list of best SQL server books and links. You can read and improve your knowledge yourself.

Microsoft SQL Server 2008 Internals

http://www.amazon.com/Microsoft%C2%AE-SQL-Server%C2%AE-2008-Internals/dp/0735626243

Professional SQL Server 2008 Internals and Troubleshooting

http://www.amazon.com/Professional-Server-2008-Internals-Troubleshooting/dp/0470484284

SQL Server MVP Deep Dives volume 1 & 2

http://www.amazon.com/SQL-Server-MVP-Deep-Dives/dp/1935182048

DBA Survivor: Become a Rock Star DBA

http://www.amazon.com/DBA-Survivor-Thomas-LaRock/dp/1430227877

SQL Server 2008 Query Performance Tuning Distilled

http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025

SQL Server Execution Plans by Grant Fritchey (Free)

http://www.sqlservercentral.com/articles/books/65831/

Troubleshooting SQL Server A Guide for the Accidental DBA (Free)

http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

3. User Group

Chennai guys, you can attend Microsoft Chennai SQL Server User group (CSSUG) sessions. It’s absolutely free http://sql-articles.com/category/cssug/  have conducted by my friends Vidhya Sagar and Deepak. I have attended three more sessions. See me here http://sql-articles.com/blogs/presenter-chennai-sql-server-user-group-september-meeting/

 

This post will update occasionally whenever I get new books and websites.

Muthukkumaran kaliyamoorthy

I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

More Posts - Website

Share this
9 Comments - Leave a comment
  1. Beardslee Hillike says:

    That is really fascinating, You’re a very skilled blogger. I have joined your feed and stay up for in quest of more of your magnificent post. Additionally, I have shared your site in my social networks

  2. Wilford says:

    Good day! This post couldn’t be written any better! Reading this post reminds me of my good old room mate! He always kept chatting about this. I will forward this write-up to him. Fairly certain he will have a good read. Many thanks for sharing it on http://www.sqlserverblogforum.com !

  3. Jack says:

    Aw, this was a really nice post. In idea I would like to put in writing like this additionally – taking time and actual effort to make a very good article… but what can I say… I procrastinate alot and by no means seem to get something done.

  4. ashish says:

    please Solve my query

    one of my silverlight application is running.
    this application has one central database(sql server 2008).
    and three others database at client side.
    our requirement is whithout changeing in silverlight application
    when we make change in central database(insert update and delete in multiple tables) these change
    automatically happened in all client database.
    and when any change made in any client database all client as wll as central database should be updated automatically.

    For this i read some about Sync Framwork and SQL Server 2008 Change Tracking.
    but i have no idea about how i will do this.
    Please help me. how can we acchive this.

  5. MARTIN says:

    hi

    (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server

    I restored a backup which i was not created to a new database and if i connect above said issue is coming , if i generate script from restored DB and running without data in another new database and connecting to the same is working .. can you plz tell what will be the exact problem and i found one database level user is there as below in the script.

    CREATE USER [appointment_bee] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]

    kindly let me know whats the problem ..

Leave a comment

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="">

Current ye@r *


Welcome , today is Friday, November 28, 2014