Is Data the Future of the Vibrant Web?
There is a lot of data collected from web browsing. Steve doesn't think we need all that data, unlike Google.
2019-09-24
171 reads
Editorials
Working in Smaller Teams
Steve likes working in smaller teams and has some thoughts on why this is important to him.
2019-09-23
208 reads
Using Big Data to Improve Health
With the help of a database that provides fully representative data, we can do a great deal more to advance medical and pharmaceutical science. Phil Factor explains what stands in our way.
2019-09-21
286 reads
A Good Reason to use a VCS
Steve has a good reason to use a version control system. It's a different kind of backup that you might need.
2019-09-19
382 reads
Beware, More Ransomware is Coming
Ransomware has become a large problem in the last few years, and Steve thinks this will continue to increase because of insurance payouts.
2019-09-18
245 reads
What You Should Know About Coding
Today Steve thinks about the skills and approach we ought to be taught before we start building software as a career.
2019-09-17
374 reads
The Crazy Times of Year
Do you have busy times of the year that recur regularly? In some positions I've held, we had certain events or processes that always caused additional stress and headaches for employees. As a bartender, certain holidays (New Years, Halloween) were extra crazy. In one company, every quarter was an adventure involving a late, or a […]
2019-09-16
182 reads
2019-09-14
297 reads
Staying Focused
Finding the zone, working in the flow, these are the most efficient times for us, but they can be hard to find.
2019-09-13
252 reads
The State of DevOps Report for 2019
It seems like just a few weeks ago that I went over the 2018 results with Gene Kim. That was an exciting few weeks for me, running over the report in prep and then having the opportunity to host a webinar with Gene Kim. Exciting times, but it's been almost a year and the 2019 […]
2019-09-12
132 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