SQLDay 2019 – Day 2
Tuesday is the day when SQLDay starts. The doors are opened from 8am but the show begins with a keynote at 9am. This year the keynote talk was done...
2019-05-15
13 reads
Tuesday is the day when SQLDay starts. The doors are opened from 8am but the show begins with a keynote at 9am. This year the keynote talk was done...
2019-05-15
13 reads
Today it was a workshop day at SQLDay. Five workshops (one unfortunately has been cancelled). I think at least 300-350 people have attended the conference during the first day....
2019-05-14
26 reads
This is the third interview we have done. This time our guest is Robert Farley who can be also recognized as the famous guitar player! Here you can find...
2019-05-10
48 reads
SQLDay starts in a week! Stay tuned during this week as it could be full of surprises! We are ready & prepared and speakers start to arrive next Saturday!...
2019-05-05
16 reads
It’s been long time ago I published the last article. I had exams at school and worked hard to pass and have a good grades. Now I have some...
2019-04-30
19 reads
#13, #13, #13 – that must be a good week! This firs week of May we call a “long weekend” as we have at least 2 days off! This...
2019-04-29
38 reads
This is my second interview! This time with Andre who is a cat lover and great speaker! Here you can find the interview!
2019-04-24
42 reads
It was an Easter Monday yesterday and I thought it was not a good time to prepare a blog post. It was a time to rest with the family...
2019-04-22
14 reads
Good day folks! Let’s make this week great (again)! It is spring already there so it is easy to get up at 6am and write the blog! Now looking...
2019-04-15
52 reads
The 2nd of April 2019 was a big day because of the two global IT events. The one was for developers as a new Visual Studio 2019 was born....
2019-04-13
40 reads
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...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
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