About me


Manoj Pandey | manub22@gmail.com | +91 888 699 1882

  • Overall 8+ years of work experience in IT, Software services, Web based projects and developing software solutions for Insurance (Risk), financial, publishing & health-care domain.
  • Currently working with Microsoft India, HYD-AP, India as Dev Lead.
  • Recognized with the Microsoft Community Contributor Award (MCCA) 2011 for my contributions to Microsoft online technical communities in MSDN’s T-SQL forum.
  • Strong in MS SQL Server (SQL Server 2005/2008/R2/2012, TSQL, writing complex SQL queries & scripts, Stored Procedures, Functions, Triggers), database designing, data migration and query optimization.
  • Data migration from Onyx CRM to SFDC (Salesforce.com) CRM for Janus Capital Group (Denver-CO), client of Sapient Corp.
  • Having exposure to ETL tools like MS BI – SSIS, Apatar, etc. and evaluated other tools in the market like Cast-Iron, Pentaho, Talend, etc.
  • Good experience in CRM support, integrations and managing various workflows.
  • Exposure to MS.net (2.0) & Java technologies.

Facebook Page: http://www.facebook.com/sqlwithmanoj

Linkedin: http://in.linkedin.com/in/manub22
facebook: http://www.facebook.com/home.php#!/manub22
twitter: http://twitter.com/#!/manub22

gmail: manub22
Yahoo: manoj_apeejay

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

    It’s very useful.Thanks.

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

    VERY GOOD WORK
    A fan from Manchester

  3. September 11, 2011 at 8:01 pm

    Manoj,

    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

    Manoj,

    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..
    ALL THE BEST AGAIN

    Anamika

  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

    PAD_INDEX = OFF,
    STATISTICS_NORECOMPUTE = OFF,
    ALLOW_ROW_LOCKS = ON,
    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.

  1. No trackbacks yet.

Leave a 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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 388 other followers

%d bloggers like this: