DataOnWheels

Steve Hughes is the Director of Consulting at 3Cloud. In my current role, I manage the West and Central Data & AI consultant team at 3Cloud. I did a similar role at Pragmatic Works before our merger with 3Cloud. I focus on team development and company growth with this role. In my previous role as a Principal Consultant Lead at Pragmatic Works, I focused on designing solutions for customers on Microsoft technologies including SQL Server, Power Platform, and Azure.

Kristyna Hughes is the Team Lead for BI at GlobalTranz. I have played an instrumental role in moving our company from 3 different reporting platforms to hosting our reporting within Power BI. I provide advice on security structures within the platform, manage the gateways, create and implement design strategies, train, and build reports for both our internal operations committee and external customers. I will also be aiding in embedding Power BI within an unified TMS and ensuring various levels of security are maintained within the embedded reports.

All authors

All authors

Blogs

From Couch-Potato to Triathlete – and What This Means for Your SQL Server

By

Do you know if your SQL Server is really running at its best? To...

Retro Data 2025 – Slidedeck

By

You can find the slides of my session on the €100 DWH in Azure...

The Book of Redgate: We Value Teams

By

This value is something that I still hear today: our best work is done...

Read the latest Blogs

Forums

Is there a way for SP to know who called it?

By water490

Hi everyone I am writing an SP where there is logic inside the SP...

Planning for tomorrow, today - database migrations

By John Martin

Comments posted to this topic are about the item Planning for tomorrow, today -...

Bottlenecks on SQL Server performance

By runarlan

We have a BI-application that connects to input tables on a SQL Server 2022...

Visit the forum

Question of the Day

The Tightly Linked View

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;
go
What is the result?

See possible answers