Business Intelligence Roles and Team Composition
On Business Intelligence projects of all sizes, the composition of the team is a crucial element for success. What is...
2014-06-17
464 reads
On Business Intelligence projects of all sizes, the composition of the team is a crucial element for success. What is...
2014-06-17
464 reads
I’ve created a simple query performance logging tool for Analysis Services, called the SSAS Performance Logger. The tool allows you...
2014-06-03
476 reads
Someone recently asked me through LinkedIn how much it would cost to implement a BI project with Microsoft tools. This...
2014-05-17
983 reads
Watch below for live updates during the conference Stay tuned and you’ll find out what’s going on during this week...
2014-05-07
445 reads
As I continue to explore the many facets of DAX functions, I’m finding more creative ways to add business value...
2014-04-20
882 reads
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
733 reads
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
366 reads
What I’m going to show you is not rocket science. This one gets filed under the category of “well, duh. ...
2013-08-01
792 reads
A client came to me with a challenge this week that, although simple in concept, posed an interesting challenge that...
2013-07-13
743 reads
Power BI: a new suite of Business Intelligence tools Over the past few months, teams at Microsoft have made several...
2013-07-09
719 reads
Do you know if your SQL Server is really running at its best? To...
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
Hi everyone I am writing an SP where there is logic inside the SP...
Comments posted to this topic are about the item Planning for tomorrow, today -...
We have a BI-application that connects to input tables on a SQL Server 2022...
I try to run this code on SQL Server 2022. All the objects exist in the database.
CREATE OR ALTER VIEW OrderShipping AS SELECT cl.CityNameID, cl.CityName, o.OrderID, o.Customer, o.OrderDate, o.CustomerID, o.cityId FROM dbo.CityList AS cl INNER JOIN dbo.[Order] AS o ON o.cityId = cl.CityNameID GO CREATE OR ALTER FUNCTION GetShipCityForOrder ( @OrderID INT ) RETURNS VARCHAR(50) WITH SCHEMABINDING AS BEGIN DECLARE @city VARCHAR(50); SELECT @city = os.CityName FROM dbo.OrderShipping AS os WHERE os.OrderID = @OrderID; RETURN @city; END; goWhat is the result? See possible answers