Daily Coping 6 Mar 2023
Today’s coping tip is to make plans with a friend and catch up with them. I decided to reach out to a friend and make time to catch up....
2023-03-06
13 reads
Today’s coping tip is to make plans with a friend and catch up with them. I decided to reach out to a friend and make time to catch up....
2023-03-06
13 reads
In the last post I hadn’t found the breakdown of questions for the exam. The Open Group does publish the TOGAF 9 Certified Study Guide (link goes to the...
2023-03-06
50 reads
When I teach the ISACA Certified Information Systems Auditor (CISA) course, one of the things I walk candidates through is how the test is structured and how much each...
2023-03-06 (first published: 2023-02-28)
285 reads
Last week I posted the results from using Extended Events to snoop on what happens inside an AWS RDS database. This week, I’m taking a look at what happens...
2023-03-06 (first published: 2023-02-27)
415 reads
Well, for those who don’t know me, I’m just barely started on my PostgreSQL journey. So, what the heck can I contribute to this conversation? Not much, but I...
2023-03-03
21 reads
I’ll be at VS Live in Las Vegas this March to discuss zero downtime deployments. If you want to come and join me for this session, or any of...
2023-03-03 (first published: 2023-02-22)
165 reads
Today’s coping tip is to send an encouraging note to someone who needs a boost. I met someone at a conference years ago and kept in touch. For some...
2023-03-03
22 reads
The grade for February is also D. Details below, but just not making a lot of progress in these areas. So far I have: Jan – D Feb –...
2023-03-03
31 reads
Josh & myself at Antman & the Wasp Quantumania Hello Dear Reader! It's the Presidents Day holiday today in America. With it comes a 3 day weekend. To celebrate Josh...
2023-03-03 (first published: 2023-02-20)
108 reads
Today’s coping tip is to make plans with a friend or loved one. I don’t like making plans, preferring to somewhat flow with life and make decisions close to...
2023-03-02
10 reads
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
End-to-end NVMe vs SCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
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
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