2020-07-21
87 reads
2020-07-21
87 reads
Let the data drive your decisions. This has been something of a mantra for many technical people, and even many business people, across the last twenty or so years. The allure of business intelligence is harnessing lots of data to make decisions that are rooted in some rational analysis of what has happened. Many companies […]
2020-06-06
83 reads
2020-04-16
129 reads
2020-03-31
65 reads
A request to rapidly gather data caused some friction recently. Is that something that organizations ought to be prepared to handle?
2020-03-26
148 reads
Amazon is providing automatic redaction of PII data in there transcription service.
2020-02-29
278 reads
Protecting data is not easy, but it is critical. In this article, David Poole discusses database security and the behaviors needed to build secure systems.
2020-01-22
This week Grant talks about the need for change and growth to adapt to the changing world.
2019-12-21
165 reads
There is a lot of data collected from web browsing. Steve doesn't think we need all that data, unlike Google.
2019-09-24
171 reads
There is a page where GDPR fines are tracked. None of us want to get on that page.
2019-08-22
427 reads
By Bert Wagner
I almost ordered parts for a circuit that would have destroyed itself the instant...
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
Comments posted to this topic are about the item Your AI Successes
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
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