During a demo of Redgate Monitor Enterprise to a customer, they asked about how to search for permission changes. This post examines how you can do that in Redgate...
2025-07-14 (first published: 2025-06-23)
276 reads
A friend was asking for help with some data analysis. This was in PowerBI, and the source data was PII. I asked them to mask the data for me...
2025-07-14
29 reads
The PASS Summit goes on tour this year, with a September stop in Dallas. This is the first event in the series, and I’m excited to go back to...
2025-07-09
52 reads
This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has been a great help in multiple communities over the years, and he has quite an...
2025-07-08
95 reads
I decided to update software on my laptop recently during a trip. I’m loathe to do this on most trips, as I don’t want any instability before a presentation....
2025-07-07 (first published: 2025-06-25)
304 reads
It’s been a week since I flew home from London and Redgate to begin my sabbatical. Actually, at this time last week I was just about to land in...
2025-07-05
12 reads
2025-07-04
378 reads
I’ve been very happy with Docker Desktop for years, running it on both laptop and desktop. However, a corporate decision was made to move to Rancher Desktop, so I...
2025-07-04 (first published: 2025-06-16)
302 reads
2025-07-02
372 reads
The PASS Summit goes on tour this year, with an August stop in New York City. This is the first event in the series, and I’m excited to go...
2025-07-02
6 reads
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...
By gbargsley
Have you ever received the dreaded error from SQL Server that the TempDB log...
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;
go
What is the result? See possible answers