The Best DBA Gifts
Today Steve asks if there is anything you'd want as a gift that would make your job better.
2019-12-27
291 reads
Today Steve asks if there is anything you'd want as a gift that would make your job better.
2019-12-27
291 reads
This week Grant talks about the need for change and growth to adapt to the changing world.
2019-12-21
165 reads
Steve thinks the DBA job is evolving and we will always need people to manage data.
2024-05-17 (first published: 2019-12-16)
523 reads
Learning to find the career that's important to you can be a challenge. Today Steve has some advice.
2023-05-15 (first published: 2019-12-11)
378 reads
Today Steve wonders if your company is understanding of your human frailty.
2019-12-06
262 reads
I'm a firm believer in keeping your tech skills up to date, as well as your social skills, What better way than attending or presenting at a conference or group meeting. The reason to attend an event I'm very fortunate that my company allows me training days and time for personal development, covering all expenses […]
2019-12-03
1,955 reads
Is there a good way to ensure employees get trained? Steve has a few thoughts today on an idea that could help.
2019-12-03
181 reads
2019-11-23
1,881 reads
The period after a conference is a good time to start driving yourself forward.
2019-11-20
119 reads
2019-11-18
228 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