I’m Speaking at SQL Saturday Oregon
I am honored to have been selected to speak at SQL Saturday Oregon this year. They always have so many sessions submitted with only 40 slots available. I was...
2019-10-29
12 reads
I am honored to have been selected to speak at SQL Saturday Oregon this year. They always have so many sessions submitted with only 40 slots available. I was...
2019-10-29
12 reads
In this month’s (October 2019) release of Power BI Desktop, they have added a ton of cool stuff, you can read all about it via the Power BI Blog. ...
2019-10-22 (first published: 2019-10-15)
417 reads
I am so excited for the next three weeks. This is a trip that has been in the planning for nearly 2 years. I have always loved travelling and...
2019-09-01
20 reads
I am so excited and honored to have been awarded my second Data Platform MVP from Microsoft on Monday. It’s been a crazy busy 18 months and the next...
2019-07-03
9 reads
I am happy to announce that I will be speaking at SQL Saturday Raleigh this Saturday, April 27, 2019. I have been part of the organizing team for this...
2019-04-22
9 reads
I recently delivered my very first SQL Saturday pre-con for SQL Saturday Richmond on Friday, March 29, 2019. You can read about that adventure here. As part of the...
2019-04-08
26 reads
I didn’t announce this before it happened because I didn’t want to “jinx” myself, but I am happy to say that it’s finally happened. I have delivered my very...
2019-04-06
44 reads
As a MS MVP one of the things you have to do is keep track of all the “things” you...
2019-02-20
186 reads
As a MS MVP one of the things you have to do is keep track of all the “things” you do for community, whether it be volunteering, organizing, speaking,...
2019-02-20
7 reads
I am so excited and honored to announce that I have been selected to speak at SQL Saturday Chicago on...
2019-02-15
99 reads
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item 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