SQL Server 2012 – Articles (Denali)


27. Certification – Exam 70-463: Implementing a Data Warehouse with MS SQL Server 2012

26. Certification – Exam 70-462: Administering MS SQL Server 2012 Databases

25. Certification – Passed 70-461 Exam : Querying Microsoft SQL Server 2012

24. Certification – SQL Server 2012 Certification Path

23. SQL Server 2012 Upgrade – Use Upgrade Advisor

22. SQL Server 2012 Upgrade – Technical Guide and Why Upgrade

21. Issues – with the new SEQUENCE feature in SQL Server 2012 (not a bug)

20. Issues – with IDENTITY property in SQL Server 2012 (not a bug)

19. Deprecated – SQL Server 2012 does not support Linked Server to SQL Server 2000

18. Deprecated – SET FMTONLY ON/OFF | New SPs and DMFs introduced in replacement

17. New Features – Another reason to use THROW clause instead of RAISERROR

16. New Features – New THROW statement in SQL Server 2012 (vs RAISERROR)

15. New Features – Using FullText search with FileTables in SQL Server 2012

14. New Features – using FileTables to store your files and docs

13. New Features – Temp Tables are created with negative Object IDs

12. New Features – Enhanced OVER() Clause – Part 2

11. New Features – Enhanced OVER() Clause – Part 1

10. New Features – WITH RESULT SETS

09. New Features – SSMS, Surround With

08. New Features – OFFSET-FETCH Clause and Pagination

07. New Features – SEQUENCES

06. New Features – CONCAT() & FORMAT() functions

05. New Features – Use TRY_PARSE() instead of ISNUMERIC()

04. New Features – Built-in Functions

03. SQL Server 2012 – BPA

02. The Fantastic 12 of 2012

01. SQL Server 2012 – New Features

  1. Simon Mafany
    October 2, 2016 at 8:23 pm

    Hi, am simon.
    please i dearly need your help.
    i am very familiar working with RDBMS, have a very solid foundation on Relational Databases, SQL standard language and T-SQl. i have a solid background knowledge working MS SQL Server. i have great interests getting certified for the 70-463 exams.
    i have very few video tutorials to assist me.
    please can you email me a soft copy of your
    TRAINING KIT(EXAM: 70-463): Implementing a Data Warehouse with SQL Server 2012/2014.

  2. mangesh
    February 11, 2016 at 10:23 pm

    Hi manoj could you please suggest me solution for the error ” the given key was not present in the dictionary ” during installation of sql server 2012 Std edition.

    Thanks in Advance,

  3. Poonam
    February 7, 2014 at 9:58 pm

    Hi Manoj,

    I am writing to explore some volunteer opportunities in SQL Server. I have been unemployed for more than a year due to some visa issues. I am trying my best to get hands-on experience in T-SQL programming or Microsoft BI field while I am unemployed. Any inputs in finding online volunteer work related to SQL. I am also preparing for Exam 70-461 and would take the exam pretty soon.
    I would greatly appreciate your inputs in this regard.

    • February 10, 2014 at 12:33 pm

      @Poonam, thanks for writing to me and I really appreciate your dedication towards technology.

      As far as Volunteer work is concerned I’m not aware of any, but you can dedicate your time and knowledge on answering Questions on various forums like MSDN TSQL, SQLServerCentral, StackExchange, which will also let you learn new things and clear your doubts.

      Also you can start your own blog like this or volunteer by writing blog posts on beyondrelational, codeproject, etc. blogging forums.

      For preparing 70-461 you can check my blog post: https://sqlwithmanoj.wordpress.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/


  4. Nikki
    November 5, 2013 at 1:43 pm

    Hi Manoj,
    Ur website is having lot information.But i am new to work with sql server 2008 R2 and newly learning T-sql.. Could you please suggest me some books or some links where i can refer..


  5. Mayank
    December 26, 2012 at 7:57 am

    I am planning to prepare for SQL 2012 certification (Business Intelligence). Could you give me some idea how to setup the lab environment to cover 40-461, 462, 463, 466 & 467.I do not have access to server machines, so it would be good if you can provide me some info about simulating the environment using my desktop machine.

  6. karthick
    July 30, 2012 at 6:29 pm

    how to use vb function to sql query function

    function emp()

    str=”select * from employ”
    set rs=conn.execute(str)

    do while rs.eof=false

    for i= 1 to 6

    if sex=’m’ then

    update status=’male’ where empcode=’1000′


    update status=’female’ where empcode=’1000′



    end function

    • July 30, 2012 at 6:32 pm

      Check this:

      UPDATE employ
      SET status=’male’
      WHERE sex=’m’
      and where empcode=1000

      UPDATE employ
      SET status=’female’
      WHERE sex’m’
      and where empcode=1000

  7. Siva Manickam
    October 28, 2011 at 5:47 pm

    Hi Manoj,

    Could you please help me how to handle the the space in the sheet value ( Budget Administrative Code in the following example)

    SELECT *
    ‘Data Source= C:\testing Country.xlsx;
    Extended Properties=”Excel 12.0″‘)…[Budget Administrative Code$];

    • October 31, 2011 at 5:02 am

      What do mean by space in sheet value & how do you want to handle it?
      Can you please explain.

  1. June 23, 2015 at 11:53 am
  2. March 28, 2015 at 11:19 pm
  3. March 18, 2014 at 10:39 pm

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

%d bloggers like this: