About me

– I’ve overall 11+ years of IT experience in Database Development, DW/BI Design/Development, Data Modelling, Analysis, Upgrade/Migration, ETL Design/Development, Performance tuning and Administration.

– Working mostly with SQL Server, Development and Perf-optimization.

– Hands on experience working with Azure SQL DB, Azure Data Factory, Informatica, Power BI, etc.

– Currently working with Microsoft India (MSIT) as Software Development Engineer.

Work with me !

For any Tech events, reviews, promotions, blogging assignments, etc. please feel free to get in touch with me via my email, phone, and social handles (listed below).

Contact me

Social Networks: LinkedIn | Facebook | Facebook Page | Twitter | YouTube

Email me: Gmail | Yahoo

Call me: +91 888 699 1882

  1. Hemalatha
    April 28, 2011 at 4:12 am

    It’s very useful.Thanks.

  2. ni
    July 17, 2011 at 4:41 pm

    A fan from Manchester

  3. September 11, 2011 at 8:01 pm


    Thank you for your website. You are helping me to prepare for a job interview tomorrow.

    Thank you.

  4. October 15, 2011 at 1:33 am


    Thank you for your page. I am taking a T-SQL class and this information is very helpful.

  5. Graham Spencer
    November 1, 2011 at 12:51 pm

    Very nice website, I’ve marked you as a Favorite.

    • December 30, 2011 at 4:11 am

      Thanks Graham.
      You can also subscribe me or add an RSS for automatic notifications.

  6. zaheerkhan5384
    November 26, 2011 at 7:16 pm

    Hello Manoj, i really like all of your post. its nice!

    • December 30, 2011 at 4:11 am

      Hi Zaheer,
      Thanks 🙂

  7. February 28, 2012 at 5:59 am

    KEEP IT UP..


  8. Taruna Makhija
    June 14, 2012 at 12:52 pm

    I really appreciate the way you are going and helping people.
    I thankyou for all your tips.

    Taruna Makhija

    • June 14, 2012 at 2:02 pm

      thanks for your comments @Taruna… enjoy reading!!!

  9. Taruni
    October 16, 2012 at 4:13 pm

    Hey, You did wonderful Job!!!!!!!!!!!!!!!! It’s too good to preparie the interviews

  10. Rajesh
    June 9, 2013 at 5:27 pm

    Good Job manjo

  11. vinoth
    November 6, 2013 at 2:21 pm

    Hi Manoj,
    Your Site is Good.Know i need SQLSERVER Certification path. I don’t no the flow of SQL Path.
    Which one first complete then second ple help me ,i am waiting for your response.

  12. vinoth
    November 15, 2013 at 5:09 pm

    Very very big thanks to you .

  13. vinoth
    November 22, 2013 at 3:11 pm

    Dear Manoj,

    I have one more doubt About Index Concept
    1. clustered index
    2. non_Clustered index
    3.unique Clustered Index
    4.Unique Non Clustered Index
    5.Filtered Index
    this is ok for me .Abort from this topic how many index are there in sql server i am waiting for your response.

    • December 5, 2013 at 3:09 pm

      @Vinoth, There are primarily 2 types of Indexes, that is Clustered & Non-Clustered. You can also make them unique or non-unique, as you’ve mentioned above, total 4. There is a plain Unique Index also, now 5. Filtered Index can be created on a Non-Clustered Index, so total 6. Other than these there other types, like: XML index, Spatial Index, ColumnStore Index & FullText Index. So totaling up to 9 indexes. Check this link for more info: http://technet.microsoft.com/en-us/library/ms175049.aspx

  14. vinoth
    December 4, 2013 at 11:58 am

    Can you Explain the System Database in SQL Server ?

    • December 5, 2013 at 3:16 pm

      There are 5 System Databases in SQL Server, namely:
      1. master – stores metadata information of an instance, like accounts, config settings, linked servers, etc.
      2. msdb – stores SQL Agent Jobs, Alerts, DB mail, Service Broker, etc.
      3. model – used as a template by SQL Server engine while creating new databases.
      4. resource (invisible) – stores information of sys.objects physically form all databases.
      5. tempdb – temporary work area for database objects to take load while processing big datasets, also stores temp-tables, work-tables & table-variables.

      Check here for more info: http://technet.microsoft.com/en-us/library/ms178028.aspx

  15. vinoth
    December 4, 2013 at 4:07 pm

    ALLOW_PAGE_LOCKS = ON Please explain??

    • December 5, 2013 at 3:21 pm

      PAD_INDEX: Specifies the space to leave open on each page (node) in the intermediate levels of the index. The PAD_INDEX option is useful only when FILLFACTOR is specified, because PAD_INDEX uses the percentage specified by FILLFACTOR.

      STATISTICS_NORECOMPUTE: Specifies that out-of-date index statistics are not automatically recomputed. To restore automatic statistics updating, execute UPDATE STATISTICS without the NORECOMPUTE clause.

      ALLOW_ROW_LOCKS: Specifies whether row locks are allowed. The default is ON, here Row locks are allowed when accessing the index. The Database Engine determines when row locks are used. When OFF, Row locks are not used.

      ALLOW_PAGE_LOCKS: Specifies whether page locks are allowed. The default is ON, here Page locks are allowed when you access the index. The Database Engine determines when page locks are used. When OFF, Page locks are not used.

      Source: MSDN

  16. vinoth
    December 5, 2013 at 3:53 pm

    Very Very Big Thank’s To You Mr.Manoj
    Know I am very clear for those concept.

  17. vinoth
    December 11, 2013 at 5:11 pm

    Dear Manoj,
    I have one more doubt About SQL INJECTION? I was Read Many article but does not able to understand So please Explain with clear Examples i am waiting for you Response.
    Thanks G.

  18. vinoth
    December 16, 2013 at 4:55 pm

    select * from employee;

    emp_id fname lname
    4 bala bala
    5 vasanth vasanth
    1 vinoth kumar
    2 ravi sankar

    select * from employee
    where fname=’bala’
    and fname=’anything’ OR ‘a’=’a’;

    emp_id fname lname
    4 bala bala
    5 vasanth vasanth
    1 vinoth kumar
    2 ravi sankar

    Both queries return the same values then how to prevent the SQL INJECTION in Sql server please give solution.

  19. Rashmi
    August 13, 2015 at 12:43 pm

    Hi Manoj,

    This website seems to be very useful for T-SQL developers . It has very useful information for learning concepts in detail.

    Thankyou for this !

    • August 13, 2015 at 3:46 pm

      Thanks @Rashmi, that you found the blog informative and helpful.


  20. Shilpa
    September 9, 2015 at 8:41 pm

    Hi Manoj

    Its amazing to see how you have progressed and awesome blogs..definitely very helpful 🙂


    • September 9, 2015 at 9:32 pm

      Thanks a lot @Shilpa for your recognition and support in my initial years.


  21. Hamza
    September 16, 2015 at 12:09 am

    Hi Manoj,

    I’m starting to prep for my 70-461 certification exam? I don’t have any experience with SQL and I come from a non-IT background.

    I saw your posts on https://goo.gl/KcGQlV and noticed that you passed this exam at the end of 2012.

    Is there anything that you’d like to add to your post from two years ago?

    I’m just starting out to any advice would be helpful.


  22. Rajat Dixit
    March 20, 2016 at 11:18 pm

    hello Manoj,

    here i am writing to know how to learn sql and pl/sql. as i am a fresher from EC background dnt have proper knowledge about it. now i am going through the book naming black book for sql and pl/sql . so can you please suggest me the best way to learn full course with practice and about the best free tool for sql and pl/sql practice.

  23. satyansh mishra
    July 12, 2016 at 7:48 pm

    hello sir I working in Gvt. BANK data center as production support eng . sir i want start my career in sql as DBA .sir i wanted to know deep about sql . can you suggest me some book & training institute in delhi…

  24. vijay
    July 16, 2016 at 2:58 pm

    hi monoj sir,
    These days i am learning SQL-DBA,so that i am searching for meaterials and unfortunatly i watched this website and i got so much of information.
    my kindly request is ,would you please xplain the topics of DBA through videos? so that i can learn and valuble things from you.so would u?its my kindly request.

  25. Senthilkumar Ganesan
    July 28, 2016 at 7:10 pm

    Hi Manoj,

    Can you please explain some database design strategy.

  26. Stephan Wirth
    October 3, 2016 at 11:05 am

    I found on your website a link to download the ISO-file for “SQL Server 2016”, but in english. I need it in german language (Evaluation). Is it possible to find her a link too?
    S. Wirth

  27. pankaj
    January 19, 2017 at 2:00 pm

    hi Manoj sir could you plz suggest me before going to learn ms sql dba is it mandatory to learn programming knowledge of tsql if it is required so which topics are essential for sql dba . and do you provide a online class of sql dba so plz informe to me, i expecting in depth subject so i could face to 5 to 6 plus exp. of dba interview.

  28. Krishna Kumar
    August 23, 2017 at 8:53 pm

    What is a good training center for a rural student of UP to come to Delhi and get SQL cert without having to pay thousands for oneday two programs. Any good places where they cover SQL2016 mcsa course? Want to help this rural student but dont know where to send him

  29. Asha
    February 8, 2018 at 4:52 pm

    really its very help-full thanks!!!!

  30. February 8, 2018 at 6:31 pm


    how can learn ETL in sql for beginners.

    September 25, 2018 at 9:44 am

    hi sir i really likes your post can you provide online Azure DB training.I would like to join or please suggest me good online institute

  32. Bharat
    March 30, 2020 at 6:50 pm

    Hi Manu,
    I have been following your blog and find it very much useful.

    I have emailed to your gmail for one of a requirement in sql.

    Your responses are highly appreciated.

    Thanks in advance.


  33. Mike livingstone
    August 12, 2021 at 10:56 am


    Hope you are doing well!

    I am far more interested in writing a sponsored article on your website sqlwithmanoj.com with 500+ words on it. In return, I expect a backlink to my website. The link will be related to the sports betting site. I expect positive consent towards the offer with a price for it.

    I look forward to hearing from you.


    • August 13, 2021 at 10:53 am

      Sorry Mike, I will not be able to take articles not related to my blog domain.

  1. No trackbacks yet.

Leave a Reply to vinoth Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: