The Secret Password
The secret passwords we store in systems might be secure from discovery, but are they secure from use?
2017-05-02
80 reads
Editorial
2017-05-01
72 reads
Why deadlines stink, and are so necessary
I hate deadlines. Really. I truly hate them. The problem is: they are usually unrealistic, often not much more than a wild guess. They restrict the amount of time that I can spend in preparation and research so that I can do things right; they squeeze the artistic quality out of my work as a […]
2017-05-01
52 reads
Starting to Use SQL Server 2017
Today Steve Jones looks forward to the next version of SQL Server, with his curiosity to see if you feel the same way.
2017-04-28
139 reads
SQL Server on Linux is Just SQL Server
Steve Jones looks at SQL Server on Linux and how this may differ from what most of us have worked with in the past.
2017-04-27
99 reads
Becoming a Data Scientist
The path to becoming a data scientist isn't simple or easy, but it might be for you.
2017-04-26
183 reads
2017-04-25
254 reads
It's all about Customer Service
Grant Fritchey on the lessons all DBAs can learn from the recent Public Relations disaster for United Airlines.
2017-04-24
76 reads
Have you ever given up on your brainchild
Have you ever given up on your brainchild? If yes, how did you deal with it?
2017-04-24
109 reads
How do you come up with creative ideas?
It takes a creative mind to come up with new ideas. So how do you do it?
2017-04-21
105 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