2022-06-27
172 reads
Editorials
Shared Work Spaces: Hell, Heaven, Both?
I've just finished working in my fourth shared work space. I am not a fan. The endless hallways with all these little glassed in rooms where I can see everyone, and everyone can see me, are not my favorite places. I can see white boards with content that maybe I shouldn't be seeing. There are […]
2022-06-25
160 reads
Long Term Storage
Long term data storage isn't something we always need for databases, but it is something the world needs. A new technology has promise for those use cases, both in durability and preserving the algorithms needed.
2022-06-24
379 reads
Onboarding Remote Employees
The pandemic has meant a lot of people started new jobs remotely. Steve has a few thoughts on this process.
2022-06-22
197 reads
Better Communication of Information
Learning to better display the information contained in our data is a skill. Steve has a few thoughts today on learning to improve this for himself.
2022-06-20
133 reads
A New SQL Server Vulnerability
A new vulnerability for SQL Server is covered by a number of patches this week.
2022-06-18
745 reads
2022-06-17
118 reads
Becoming a Better DBA
Steve has some advice on how to be a better DBA, or really better at whatever career you choose.
2022-06-15
262 reads
Flawed Data Integration
These days we often have multiple applications that need to exchange data in use by customers. Steve shares a few thoughts on his recent experiences.
2022-06-13
140 reads
Building a PC
Steve has a few thoughts on building your own PC to help you with work or your career.
2022-06-10
234 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