Knowing Your Technologies
When faced with choices, it's important to understand the capabilities and limitations of your options.
2023-01-18
287 reads
Editorials
2023-01-16 (first published: 2015-06-26)
435 reads
The Programming Languages We Use
Steve comments on some programming languages and how we approach those we choose to use.
2023-01-13
201 reads
2023-01-11
151 reads
Forgoing Tech Investments
SouthWest Airlines had some issues, possibly because of their technical debt and lack of investment.
2023-01-09
193 reads
2023-01-06
156 reads
2023-01-04 (first published: 2022-12-19)
280 reads
The Tech That is Gone
As we start a new year, Steve looks back at old technology that doesn't exist anymore.
2023-01-04
157 reads
No Time for Testing
Testing software is important, but we always seem to find reasons not to. Steve Jones has a few thoughts about testing.
2023-01-02 (first published: 2015-09-28)
248 reads
A New Year, New Efforts
Happy New Year! You're going to be seeing a lot of summaries for 2022 and predictions for 2023 around this time of year. I'm not writing one of those. You'll also see people calling for new years resolutions and the like. I'm not going for that either. Nope, let's keep it simple. It is a […]
2022-12-31
59 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
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
JSON Has a Cost
Comments posted to this topic are about the item JSON Has a Cost, which...
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
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