Living Up To Your Word
Steve feels it is not only important to keep your word, but communicate clearly what you mean to others.
2022-05-11
356 reads
Career Growth
Crazy Interview Questions
Interviews are always a challenge, but sometimes there are crazy questions. We can do better, especially in terms of how we evaluate the answer to a question.
2022-05-09
542 reads
Finding New Employment
You can find new employment with a little work and choose the best job for you.
2022-05-07
136 reads
2022-05-02
92 reads
Your User Manual
Many of us have spent time looking through manuals or the documentation for some software or product. I know I'm on the MS docs site regularly for work, and there is no shortage of times I've used various manuals to help me fix something around the house. We usually use a manual when we want […]
2022-04-15
126 reads
2022-03-18
142 reads
Is the Time of the DBA Ending?
The DBA role might be changing, but Steve thinks this creates opportunities.
2022-03-04
417 reads
Less is More
In some ways the world changes a lot; in others, it's very much the same. Steve notes that often change brings opportunities, if you can adapt.
2022-02-28
162 reads
An Active Job Search
Steve wants you to manage your career and actively find the job that is best for you.
2022-02-18
178 reads
The Battlefield of Your Career
If you want to actively manage your career and drive it forward, Steve has some advice.
2022-02-14
186 reads
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Forums
Azure SQL DBA certification
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
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
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
exec etl.GettheProduct
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