Azure Sphere
The Azure Sphere project is a great piece of research at Microsoft that might help us data professionals with security.
2019-11-25
209 reads
Security
Losing The Security Game
Losing the security game is no fun when data is involved. Steve points out some things you should be doing.
2019-10-21
261 reads
More Network Restrictions
The rise of attacks is something Steve thinks will trigger more network protection, something data professionals will need to work with.
2019-10-17
190 reads
6 steps to a more secure SQL database
Security is often something people think about only after they have had a problem. Given that the average cost of a data breach is $3.92 million (SecurityIntelligence 2019) and ransomware attacks have increased 97% over the past 2 years (PhishMe 2019), the "if it's not broke, don't fix it" approach can clearly be catastrophic. Here […]
2019-10-07
9,364 reads
Beware, More Ransomware is Coming
Ransomware has become a large problem in the last few years, and Steve thinks this will continue to increase because of insurance payouts.
2019-09-18
245 reads
2019-09-02
608 reads
Protecting Code
We not only need to protect our systems, but the source code as well. Not for IP reasons, but for security.
2019-08-28
240 reads
Don't Get On This Page
There is a page where GDPR fines are tracked. None of us want to get on that page.
2019-08-22
428 reads
2019-08-20
432 reads
2019-08-20
683 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
Comments posted to this topic are about the item Faster Data Engineering with Python...
Which Result II
Comments posted to this topic are about the item Which Result II
JSON Has a Cost
Comments posted to this topic are about the item JSON Has a Cost, which...
Question of the Day
Which Result II
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
exec('SELECT ProductName FROM product;')
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers