Recently PASS Data Community Summit sessions were selected and the wounds were opened on Twitter around speaker diversity in the community. I heard from several people via my DMs...
2022-07-15 (first published: 2022-06-30)
215 reads
Deb Melkin (b | t) is hosting T-SQL Tuesday this month and is letting us rant. Who doesn’t like to rant about databases and the famous “it depends”. She...
2022-07-13 (first published: 2022-07-12)
26 reads
Over the last four years, ok it seems longer than that, I’ve started four jobs. A couple just weren’t good fits. One I was at for three years. I...
2022-07-11 (first published: 2022-06-27)
674 reads
In my previous post, I expounded on my first 30 days I had at four jobs in the last four years. and how to setup your jobs box. I...
2022-07-05
49 reads
Now that your CFS has been setup it’s time to get the word out first. There are many ways to this. I start with using the Cfs secret page...
2022-07-01
48 reads
Having recently taken a new job and introducing a number of new tools to my new coworker I thought I’d share how I setup my jump box to and...
2022-06-28
25 reads
SQL Server can run in any Virtual Machine that has the appropriate operating system (yes, I said that because I have some hope, that we will one day learn...
2022-06-20 (first published: 2022-06-03)
453 reads
It’s that time of the month again, the blog party, woohoo! This time Mala Mahadevan (b | t) has invited us to blog about our T-SQL coding standards. I...
2022-06-14
47 reads
I had a problem at work recently where a record was getting updated, and no one knew where or what was updating the record. Our team discussed the best...
2022-06-14
165 reads
I jumped on the bandwagon early so to speak to use the user group feature of Sessionize and since then I’ve walked at least five user groups through setting...
2022-05-31
33 reads
By Bert Wagner
I almost ordered parts for a circuit that would have destroyed itself the instant...
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
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...
Comments posted to this topic are about the item Your AI Successes
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