The Traveling Data Professional
This week Steve Jones talks about the need to get away and asks if you have plans.
2017-06-23
77 reads
Editorial
Backup Plans for Data Loss
Today Steve Jones discusses data loss, always a scary topic for the data professional.
2017-06-22
95 reads
Migrating Schema Between Platforms
The decision to change platforms isn't one Steve Jones takes lightly.
2017-06-20
78 reads
DevOps Can Help
DevOps can help, not just development, but also infrastructure, if you spend time adapting the practices to your environment.
2017-06-19
40 reads
2017-06-19
198 reads
Your Job Description
This Friday Steve Jones talks about job posting and descriptions. This is the chance to think about what you do and how you might describe this to your replacement.
2017-06-16
103 reads
Securing the Things
The Internet of Things is coming, and bringing lots of data, but security needs to be included as well.
2017-06-15
48 reads
2017-06-14
1,383 reads
2017-06-13
67 reads
The Value of Surveys
Phil Factor on the perils of trying to squeeze good insights out of bad surveys.
2017-06-12
64 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
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
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