Are you sticking to your goals? Do you know what they are?
I've engaged a little in the discussion on Matt Morollo's interview on Brent Ozar's blog. It made me go back...
2009-10-15
1,186 reads
I've engaged a little in the discussion on Matt Morollo's interview on Brent Ozar's blog. It made me go back...
2009-10-15
1,186 reads
By now, hopefully everyone has heard of the security breach where accounts and passwords were found on a public site listed the account usernames and passwords of some 10,000 users. Initially it was just reported to be Hotmail/Live.com/MSN, but it turns
2009-10-13
3,534 reads
I should be writing a technical post in the next day or so. I've been focusing more on the community...
2009-10-12
1,328 reads
This past Saturday I was able to participate in the Carolina Code Camp, help just outside Charlotte, NC. I was...
2009-10-12
926 reads
By now, hopefully everyone has heard of the security breach where accounts and passwords were found on a public site...
2009-10-07
2,894 reads
I hate cold calls from vendors. Nothing gets my blood hotter than some vendor trying to call me when we...
2009-10-06
699 reads
I'll be doing three talks this week, starting tomorrow (Tuesday).
Tuesday, October 6th, Midlands PASS Chapter - Trigger Happy Database Security(PASS Summit...
2009-10-05
981 reads
Jorge Segarra (@SQLChicken) has put together an idea to have on-line basic lessons on SQL Server called SQL University. The idea...
2009-10-03
1,122 reads
I'm reading SQL Server MVP John Magnabosco's new e-book, Protecting SQL Server Data, and he includes a database schema to...
2009-10-03
3,035 reads
I've written about this before, but probably not as a specific subject or blog post. Trading some comments with a...
2009-10-02
804 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item 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
exec etl.GettheProduct
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