How to Keep Data, Devices Secure When Mobile Is the Norm
When "work" can happen in any place, security breaches can happen any time and any way.
2019-05-14
Security
2019-05-13
1,041 reads
Cryptanalyzing a Pair of Russian Encryption Algorithms
A pair of Russia-designed cryptographic algorithms -- the Kuznyechik block cipher and the Streebog hash function -- have the same flawed S-box that is almost certainly an intentional backdoor....
2019-05-10
Where do data breaches come from?
I recently did some research on the source of data breaches and in this article, I’m going to talk a bit about my current favorite source for breach information,...
2019-05-09
Unless you want your payment card data skimmed, avoid these commerce sites
A skimming campaign continues to infect sites with malicious JavaScript.
2019-05-08
“RobbinHood” ransomware takes down Baltimore city government networks
A year after 911 system hit, most of city's networks are down.
2019-05-08
Verizon 2019 Data Breach Investigations Report: Make It Harder for Hackers
The new Verizon 2019 Data Breach Investigations Report finds good and bad news on the security front.
2019-05-08
Introduction to SQL Server Security — Part 4
The sa account is the most powerful account in a SQL Server instance, and most DBAs disable it. There are several other built-in accounts that you may not think about that often. Robert Sheldon continues his SQL Server security series with an article about built-in accounts.
2019-05-08
A Double Failure
A company has both a server without a password and live data in test environments. Not a good situation.
2019-05-07
364 reads
Protecting Yourself from Identity Theft
I don't have a lot of good news for you. The truth is there's nothing we can do to protect our data from being stolen by cybercriminals and others....
2019-05-06
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