Power BI Hands-On Workshop at PASS Global Summit
Please join me at the PASS Global Summit in Seattle for a half-day, 3-hour hands-on Power BI mini workshop. Bring...
2015-07-02
254 reads
Please join me at the PASS Global Summit in Seattle for a half-day, 3-hour hands-on Power BI mini workshop. Bring...
2015-07-02
254 reads
In an amazing application of visualization techniques, this production is a depiction of the casualties and affects of war. Starting...
2015-06-07
407 reads
In an amazing application of visualization techniques, this production is a depiction of the casualties and affects of war. Starting...
2015-06-07
199 reads
This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty...
2015-05-27
476 reads
This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty...
2015-05-27
272 reads
I’m pleased to share the first two articles in a series for SQL Server Pro Magazine. Here’s a short excerpt...
2015-05-26
425 reads
I’m pleased to share the first two articles in a series for SQL Server Pro Magazine. Here’s a short excerpt...
2015-05-26
218 reads
Last month Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise...
2015-05-05
832 reads
Last month Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise...
2015-05-05
208 reads
I’ve spend a good three days on and off working with the new “Microsoft” DataZen dashboard tool and I think...
2015-04-29
1,400 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