SQL SERVER – Four Tutorial for SQL Server 2012 New Features

One of the very common question I receive on my facebook is that if there is any tutorial for SQL Server 2012 new enhanced features and solutions. I see this demand a bit increasing as the SQL Server 2012 is more and more being adopted. Here is the list of four tutorial which is specifically created for SQL Server 2012 by Microsoft.

Multidimensional Modeling (Adventure Works Tutorial)
This tutorial teaches you how to develop and deploy an Analysis Services project that enables the employees of Adventure Works Cycles to analyze various aspects of their business.

Tabular Modeling (Adventure Works Tutorial)
This tutorial teaches you how to create a SQL Server 2012 Analysis Services tabular model that enable sales and marketing teams to easily analyze internet sales data in the AdventureWorksDW2012 data warehouse. You will build the tabular model in SQL Server Data Tools.

Tutorials and Demos for Power View
Create Power View reports and explore Power View features. View demos, videos, and tutorials that help you get started quickly with Power View and successfully build reports with interactive filters and visualizations such as bubble charts, tiles, and cards.

Tutorial: Using the hierarchyid Data Type
This tutorial is intended for users who are experienced with Transact-SQL, but are new to the hierarchyid data type. In this tutorial, you convert an existing table to a hierarchical structure, and you also create a new table to store and manage hierarchical data efficiently.

Note: The description of the course is taken from the original course description. You will need to install SQL Server 2012 AdventureWorks for all this tutorial.

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

14 thoughts on “SQL SERVER – Four Tutorial for SQL Server 2012 New Features

  1. On running the bellow code from “Tutorial: Using the hierarchyid Data Type – Populating a Table with Existing Hierarchical Data”, I got an error: “The multi-part identifier “P.EmployeeID” could not be bound.” How can I fix it?

    CODE:
    WITH paths(path, EmployeeID)
    AS (
    — This section provides the value for the root of the hierarchy
    SELECT hierarchyid::GetRoot() AS OrgNode, EmployeeID
    FROM #Children AS C
    WHERE ManagerID IS NULL

    UNION ALL
    — This section provides values for all nodes except the root
    SELECT
    CAST(p.path.ToString() + CAST(C.Num AS varchar(30)) + ‘/’ AS hierarchyid),
    C.EmployeeID
    FROM #Children AS C
    JOIN paths AS p
    ON C.ManagerID = P.EmployeeID
    )
    INSERT NewOrg (OrgNode, O.EmployeeID, O.LoginID, O.ManagerID)
    SELECT P.path, O.EmployeeID, O.LoginID, O.ManagerID
    FROM EmployeeDemo AS O
    JOIN Paths AS P
    ON O.EmployeeID = P.EmployeeID
    GO

    Like

      • Dave, your English is pretty good considering you are usually pretty high ranking on my Google searches for complex SQL concepts. You do a good job at communicating complex concepts. Sometimes I put your name in my Google searches cause I want to see if your blog has information on a particular subject first.

        Like

    • Tukuy Your comments are not in good taste. You could have been more polished if English is your first language. Technical Informatin provided by Dave is really great. It helps and encourages so many. Thanks!

      Like

  2. Hi
    I am Facing a Problem In 2012 in a Program , In Early Version at Place Left Outer join we were using *= but Now this Gives Error to me .. We have Written Very Big Lines Of Coding & It seems Very Difficult to Replace all that *=
    so Kindly Provide Any Solution For this ??

    Hope For a Solution

    Like

  3. Concerning Leonardo João question, I was having the same problem until I realised I had used a Case Sensitive version of AdventureWorks database. Just make sure the case is correct for all the table and column names and it should work

    Like

  4. Hi Tukuy Rikuy,

    I don’t think being require a grammar…. :)…its tech stuff buddy….ne tech guy can understand…. i think we r not english literature guys here… ;)

    Like

  5. I don’t think we require grammar…..n we really don’t use it…..hope ur techy…. if not ur require it….. :)….get the grammar n come back with tech stuff..Tukuy Rikuy…..

    Like

  6. In Ad hoc query Paging:

    Any web site with pagination will display the number of pages (1,2,3…n) as a link so that the user can click on that to get to that page.

    Is there any way to get that value “n” (total number of records/pages that the query would have returned without the limit clause) with this query, other than running a separate query to find that.?

    Like

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