Three Times a Day
The latest work trend report from Microsoft shows people have peak work three times a day, and often out of normal working hours.
2025-06-28
115 reads
Editorials
2025-06-27
99 reads
The Technical Debt Anchor
Technical debt is something all of us deal with in our systems, and today Steve has a few thoughts on the impact of debt on database sysstems.
2025-06-25
164 reads
The Data Warehousing Choice
What is your choice for data warehousing? Is it a cloud platform? Which one is attractive to you?
2025-06-23
218 reads
Shades and Reflecting on SQLBits and the Bright Future of Data
There is something magical about SQLBits. Whether it is the technical sessions, the sense of community and fun, or the relentless commitment to learning about the latest innovation, this event continues to serve as a pulse check for where data is today and where it’s going tomorrow. This year’s SQLBits at the ExCel in London […]
2025-06-21
52 reads
Multiple Monitoring Tools
Steve wonders if it is worth it to use multiple monitoring systems for a database.
2025-06-20
137 reads
SQL Server 2025 Excitement
Today Steve wonders how many of you might be looking forward to SQL Server 2025 and consider it to be a major release.
2025-06-18
218 reads
Greener Grass
Before I start the whining (whinging if you prefer), let me just say I have the greatest job in the world. I'm exceedingly lucky to have it. I'm grateful as can be. And someone else (looking at you Tim) can get it when they pry it from my dead cold fingers. With that out of […]
2025-06-16 (first published: 2025-05-31)
159 reads
Patching the Patch
If you have had to fix the thing you just fixed with a fix, you might enjoy today's editorial.
2025-06-16
104 reads
Can You Ask for a Raise?
Steve talks a bit about the choice to ask for a raise in the current climate.
2025-06-14
80 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