Prevent SQL Injection
SQL Injection continues to be a problem and Steve has a few thoughts today on how to reduce your vulnerabilities.
2024-08-14
234 reads
Security
Planes, Trains, and Automobiles
I remember going to the theater over the Thanksgiving holiday in 1987 and seeing Planes, Trains, and Automobiles with Steve Martin and John Candy. My family didn’t often take in the holiday weekend movie releases, but Steve was a family favorite actor already, and friends had given it a good review. Having watched it just […]
2024-07-20
180 reads
Least Privilege
Steve wonders how well most organizations and their staff adhere to the principle of least privilege.
2024-07-15
188 reads
Protecting Schools
Schools often lack resources and struggle to protect themselves. An interview shows one district doing well, with some lessons for those of us in other organizations.
2024-07-06
70 reads
SQL Injection Is Not Acceptable
An alert from the US government says that SQL Injection isn't an acceptable problem.
2024-06-19
319 reads
2024-03-02
64 reads
Using AI for Security
Steve thinks AI might have a place in security, something Microsoft is investigating now.
2024-03-01
129 reads
Ransomware vs. AI
Microsoft is using AI to try and protect against ransomware, which is probably a good use of the technology.
2024-02-07
164 reads
2024-01-08
472 reads
Docker Security Principles Overview
Docker is an open-source platform that enables developers to automate the deployment and management of applications using containerization. It was created by Solomon Hykes and his team at Docker, Inc., and was first released in 2013.
2023-12-25
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
Azure SQL DBA certification
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
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
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