2020-10-28
161 reads
Editorials
The Next Evolution of Big Blue
IBM is breaking up and Steve thinks back about the evolution of the company and where they might go from here.
2020-10-27
113 reads
SQL Server Phone Home
SQL Server shares some data with Microsoft, but the use is documented. Steve sees this as a model for how companies might share information.
2020-10-26
249 reads
What's Causing the Pushback with DevOps?
The term DevOps gets horribly abused. Don’t get me started on all the weird additions to it like DevSecOps. No, I just mean the term itself gets beaten up quite a lot. It’s to the point where people are starting to shy away from talking about it. I’ve even changed my approach when discussing DevOps […]
2020-10-24
164 reads
Your Technology Budget
How much do you love technology? Is this reflected in a budget? Let us know this week.
2020-10-23 (first published: 2016-10-21)
146 reads
Conflict in Functional Teams
Today we have a guest editorial from Alice Smith as Steve is away. Conflict can be good in a highly functional team, as noted today from the manager of the publishing group at Redgate Software.
2020-10-22 (first published: 2016-10-13)
191 reads
The New Data Warehouse Choice
Steve Jones looks a little more closely at the Azure SQL Data Warehouse, perhaps a viable choice for many of us.
2020-10-21 (first published: 2016-07-14)
277 reads
Clownpocalypse and DR
Today we have a guest editorial as Steve is out of town at the PASS Summit. Grant looks at disasters and being prepared.
2020-10-20 (first published: 2016-10-24)
236 reads
Responding to the Call of the Wild
Phil Factor's manual for taming machines, applications, and other wild beasts.
2020-10-17
131 reads
Career Goals and Inspiration
Steve asks what you might want to achieve or accomplish in your career.
2020-10-16
238 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