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
Call me: +91 888 699 1882
Leave a Reply to manub22 Cancel reply
Current Visitors
StatCounter …since April 2012
Leisure blog: Creek & Trails
- An error has occurred; the feed is probably down. Try again later.
SQL with Manoj 
It’s very useful.Thanks.
VERY GOOD WORK
A fan from Manchester
Manoj,
Thank you for your website. You are helping me to prepare for a job interview tomorrow.
Thank you.
Manoj,
Thank you for your page. I am taking a T-SQL class and this information is very helpful.
Very nice website, I’ve marked you as a Favorite.
Thanks Graham.
You can also subscribe me or add an RSS for automatic notifications.
Hello Manoj, i really like all of your post. its nice!
Hi Zaheer,
Thanks š
KEEP IT UP..
ALL THE BEST AGAIN
Anamika
I really appreciate the way you are going and helping people.
I thankyou for all your tips.
Taruna Makhija
thanks for your comments @Taruna… enjoy reading!!!
Hey, You did wonderful Job!!!!!!!!!!!!!!!! It’s too good to preparie the interviews
Good Job manjo
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.
Hi @vinoth, you can check the new blog post I’ve put up regarding the Certification Path, link: https://sqlwithmanoj.wordpress.com/2013/11/06/sql-server-2012-certification-path/
Very very big thanks to you .
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.
@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
Can you Explain the System Database in SQL Server ?
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
PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON Please explain??
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
Very Very Big Thank’s To You Mr.Manoj
Know I am very clear for those concept.
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.
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.
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 !
Thanks @Rashmi, that you found the blog informative and helpful.
Regards,
Manoj
Hi Manoj
Its amazing to see how you have progressed and awesome blogs..definitely very helpful š
~Shilpa
Thanks a lot @Shilpa for your recognition and support in my initial years.
~Manoj
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.
Thanks!
Yes, you can check the same post in this blog also, here: https://sqlwithmanoj.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/
Just follow the books mentioned and the blog topics.
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.
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…
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.
Hi Manoj,
Can you please explain some database design strategy.
Hello,
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?
Thanks.
S. Wirth
Hi @Stephan, you can visit the “Register & Download” site here: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016
… download the EXE and select your language, and download ISO or CAB from there. It will download the SQLServer2016-x64-DEU.exe file for German language.
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.
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
For 2016 MCSA course you can check online content which is free like SQL blogs and YouTube videos. Check here for SQL 2016 stuff: https://sqlwithmanoj.com/sql-server-2016-articles/ and also do check my blog post on 70-461 certification.
really its very help-full thanks!!!!
Sir,
how can analysis execution plan in sql. steps
Sir,
how can learn ETL in sql for beginners.
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
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.
Thanks,
Bharat
“Hi,
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.
Thanks”
Sorry Mike, I will not be able to take articles not related to my blog domain.