Planning for a Bad Day
If you found out you were being laid off, would you be ready? Steve thinks you should be lightly planning for this to happen.
2023-06-30
156 reads
Career Growth
[Video] Office Hours: Professional Development & Training Questions
A lot of today’s questions from https://pollgab.com/room/brento have a common theme, but it’s just a coincidence. Listen to the answers.
2023-06-26
2023-06-24
163 reads
Highly Skilled
The highly skilled people are changing and getting jobs. A recent report notes this is of concern to executives and hiring practices may be changing. Steve has a few hints for how you can grow your own career and find new opportunities.
2023-06-19
230 reads
2023-06-09
156 reads
2023-05-05
117 reads
The Survivors
There have been a lot of layoffs in the last year. Steve has some empathy for both those let go and those that remain. He also reminds us to manage our own careers.
2023-04-28
161 reads
AI Concerns
With the ChatGPT and AI crazy sweeping through the media, Steve has a few thoughts on what this might mean for data professionals.
2023-04-22
197 reads
A Third Break
Steve talks about a sabbatical as an amazing corporate benefit and is planning his third.
2023-04-21
126 reads
The Loss of Knowledge
The loss of developer knowledge can be impactful for an organization. Steve notes that they should do more to retain their staff.
2023-04-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