The world seems to be proceeding through some stuff at the moment. IT and our industry as a whole, equally seems to be going through some stuff. As such, allow this oldster to offer some advice: Take care of yourself. I know, I'm the same, you may have responsibilities for others. You need to take […]
2024-05-04
119 reads
Today Steve asks about on-call responsibility for you and how you view this as part of your job, or in your job search.
2024-05-03
147 reads
A big part of success is making an effort. Steve discusses the need to do things and not passively let life pass you by.
2024-05-01
198 reads
Today, Kendra Little talks about code reviews and why they should be done early.
2024-04-29 (first published: 2020-02-07)
336 reads
Since the title might be considered a bit vague, I don’t want you to wade through the article to figure it out. I will spare you the typical clickbait introduction, with me telling you what a foreign key constraint is, and why it and all the other constraint types provided by relational engines are useful. […]
2024-04-27
255 reads
Today, Grant talks about reasons that companies don't upgrade.
2024-04-26 (first published: 2020-02-11)
456 reads
Today, Grant Fritchey compares a disaster caused by a toilet to technical debt in IT.
2024-04-24 (first published: 2020-02-24)
441 reads
Management is important to ensuring the success of a team. Steve talks about an anti-pattern that is often used by poor managers.
2024-04-22
241 reads
I want to make this a participation topic. When you are working, do you listen to music or do you need quiet? And if it isn’t music, do you do something else? TV, movies? For me, it is almost always music. As I write my first Database Weekly newsletter editorial in a few months, I […]
2024-04-20
163 reads
2024-04-19 (first published: 2020-01-21)
484 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