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 (https://blog.sqlauthority.com)
14 Comments. Leave new
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
How is it possible to bound a part without creating the Common Tabular Expression? already
Dave, I encourage you to learn English. Your grammar and spelling are truly awful
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!
May i check with you.
Does it mean sql report server 2012 no longer use iis? does it replace with other thing?
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
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
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… ;)
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…..
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.?
There’s a couple options. One would be using the over clause to produce the count, another would be using a sub select as another column. See example of over clause here grabbing total records:
There is another option introduced in SQL server 2012 with Offset option. Then specifying fetch statement with no of rows to return.
https://docs.microsoft.com/en-us/previous-versions/sql/compact/sql-server-compact-4.0/gg699618(v=sql.110)