SQL Server 2012 – Articles (Denali)

–> SQL Server 2012 Certification Path

Exam 70-461: Querying Microsoft SQL Server 2012

Exam 70-462: Administering MS SQL Server 2012 Databases

Exam 70-463: Implementing a Data Warehouse with MS SQL Server 2012

–> New Features in SQL Server 2012 (aka Denali)

The Fantastic 12 of SQL Server 2012

New ColumnStore Index

New Built-in Functions

Use new TRY_PARSE() instead of ISNUMERIC()

CONCAT() & FORMAT() functions


OFFSET-FETCH Clause and Pagination

SSMS, Surround With


Enhanced OVER() Clause – Part 1, Part 2

Temp Tables are created with negative Object IDs

Using FileTables to store your files and docs

Using FullText search with FileTables in SQL Server 2012

New THROW statement in SQL Server 2012 (vs RAISERROR)

Another reason to use THROW clause instead of RAISERROR

–> Behavior Changes:

With IDENTITY property in SQL Server 2012

Temp tables are created with negative object IDs

–> Depricated Features:

SQL Server 2012 does not support Linked Server to SQL Server 2000

SET FMTONLY ON/OFF | New SPs and DMFs introduced in replacement

–> SQL Server 2012 Upgrade:

Use Upgrade Advisor

Technical Guide and Why Upgrade

–> My YouTube videos on SQL Server 2012:

  1. 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.

  2. 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

  3. 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.

  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. 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/


  6. 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,

  7. 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.

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

Leave a Reply to karthick 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: