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.

SQL SERVER - Four Tutorial for SQL Server 2012 New Features tutorial

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.

Solarwinds

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 (https://blog.sqlauthority.com)

Solarwinds
,
Previous Post
SQL SERVER – Migrate a SQL Server Reports from one server to another server
Next Post
SQL SERVER – Quiz and Video – Introduction to SQL Server Security

Related Posts

14 Comments. Leave new

  • Leonardo João
    May 16, 2012 12:24 am

    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

    Reply
  • How is it possible to bound a part without creating the Common Tabular Expression? already

    Reply
  • Dave, I encourage you to learn English. Your grammar and spelling are truly awful

    Reply
    • Tukuy Rikuy I totally agree with you and learning it every day.

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

    • 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!

      Reply
  • May i check with you.
    Does it mean sql report server 2012 no longer use iis? does it replace with other thing?

    Reply
  • 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

    Reply
  • 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

    Reply
  • 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… ;)

    Reply
  • 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…..

    Reply
  • 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.?

    Reply

Leave a Reply

Menu