Investing in Another's Career
Would you invest in someone else's career? An actual investment? Would you sell shares in yourself? Steve talks about this today.
2022-12-23 (first published: 2022-11-28)
111 reads
Career Growth
The Challenge of New Platforms
As our organizations grow, they may add new data stores. That might not be the best decision for staff as the amount of knowledge they need grows. Steve notes that you might seek to limit the number of technologies you support.
2022-11-21
210 reads
Challenging Yourself
Steve is challenging himself to do better, which means he might not hit his goals.
2022-11-18
106 reads
Losing Skills Because of Automation
When I was younger, it seemed that everyone I worked with in technology knew how to build a computer. Most knew how to work with a BIOS, were comfortable with command lines, and could assemble complex compiler directives into a Make file. Over time, it seems many people, especially Windows and MacOS users, became focused […]
2022-11-11
209 reads
Life Organization
For years, those of us in technology have often worked outside of the core working hours for the rest of our organization. Whether this is being on-call, staying late, or coming in when asked. It's not uncommon for many developers and Ops staff to work 60, 70, or more hours to get things built/deployed/supported for […]
2022-11-04
175 reads
2022-10-31
229 reads
2022-10-28
170 reads
2022-10-14
167 reads
The Value of Seniority
Some people might seem like they are from the future, but their experience is just shining through.
2022-10-05
171 reads
Paying It Forward on the Internet
Helping others has been good for Steve's career and he encourages you to do it as well.
2022-09-16
126 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