A Security Regression
Marriott has had another security breach. Does this mean they aren't taking security seriously? Steve has a few thoughts.
2020-04-30
107 reads
Security
2020-04-23
179 reads
BYOD Fingerprint Concerns
Fingerprints provide some security, but a research suggests not necessarily much. Steve has a few thoughts.
2020-04-15
80 reads
Don't Lose Data Without a Hacker
Data loss shouldn't come from simple misconfiguration. As Steve notes, if no hacking is involved, you shouldn't lose data.
2020-03-19
96 reads
2020-03-09
630 reads
Is 100% Security Possible?
A security breach at Microsoft is disconcerting, especially when they don't share details.
2020-03-05
286 reads
2020-01-21
662 reads
Let's Fix a Password Problem
Grant discusses the need for password managers to help prevent security issues between different accounts.
2020-01-15
263 reads
2020-01-14
629 reads
Quick Security Mistakes
Steve reminds you to be careful of taking shortcuts, as these can compromise security. Automation and DevOps might help you avoid mistakes.
2020-01-06
282 reads
Blogs
The Book of Redgate: We Value Teams
By Steve Jones
This value is something that I still hear today: our best work is done...
Troubleshooting TempDB Log Full Errors When SSMS Won’t Connect
By gbargsley
Have you ever received the dreaded error from SQL Server that the TempDB log...
Accelerating AI with Confidence: Why Microsoft Purview is Key to Responsible Innovation
By Chris Yates
Artificial intelligence is no longer a distant concept. It is here, embedded in the...
Forums
Planning for tomorrow, today - database migrations
Comments posted to this topic are about the item Planning for tomorrow, today -...
Bottlenecks on SQL Server performance
We have a BI-application that connects to input tables on a SQL Server 2022...
Is there some good routines for updating SQL Server database objects with GitHub
At work we've been getting better at writing what's known as GitHub Actions (workflows,...
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