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

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”

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

Your responses are highly appreciated.

Thanks in advance.

Thanks,
Bharat

how can learn ETL in sql for beginners.

Sir,
how can analysis execution plan in sql. steps

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.

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.

Can you please explain some database design strategy.

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.

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.

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!

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

~Manoj

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

~Shilpa

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

Regards,
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 !

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.

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

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

@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

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.

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/

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

Taruna Makhija

Anamika

Hi Zaheer,
Thanks 🙂

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

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

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

Thank you.