2016-03-14
102 reads
Editorial
2016-03-11
125 reads
Building Better Software
Steve Jones discusses the idea of building software better, and why that's a challenge for many of us.
2016-03-10
106 reads
The Slack Integration
Slack has become a popular phenomenon in the technical world, especially for software developers. Should we join in?
2016-03-09
220 reads
The Data Driven Event
In a couple of days, Microsoft is holding Data Driven, an event that will highlight SQL Server 2016.
2016-03-08
102 reads
2016-03-07
276 reads
Testing times with SMO
SMO gives every appearance of being a great example of over-reliance on automated testing at the expense of manual exploratory testing.
2016-03-07
62 reads
Spousal Surcharges
Today we have a guest editorial from Andy Warren that examines the costs of family at work.
2016-03-04
170 reads
Open is Not Necessarily More Secure
Just because we can view the source code for software doesn't mean it is more secure.
2016-03-03
95 reads
Learning from Microsoft
Microsoft has changed their engineering to do amazing things in the cloud, especially with SQL Server. We could all learn from this.
2016-03-01
261 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