Consider All the Possibilities When Troubleshooting
When you are troubleshooting, the rule is if you've checked the obvious possibilities and still haven't solved the problem, it's...
2013-01-28
1,668 reads
When you are troubleshooting, the rule is if you've checked the obvious possibilities and still haven't solved the problem, it's...
2013-01-28
1,668 reads
What does cash over credit have to deal with security? An awful lot, as it turns out.
Personal Story: Mere days...
2013-01-17
1,210 reads
Cross-posted from The Goal Keeping DBA blog:
As a worker in information technology, I’ve always been a big proponent of studying systems...
2013-01-14 (first published: 2013-01-10)
2,150 reads
Jorge Segarra (blog | twitter) was giving a presentation and he remarked on how the SQL Server Management Studio shortcuts have...
2013-01-11
7,786 reads
On February 12th I'll be giving a SQL Server Security Refresher for Midlands PASS at Microstaff IT in Cayce/West Columbia,...
2013-01-10
962 reads
Yesterday (January 1) I received the email indicating I was re-awarded as a Microsoft MVP, once again in SQL Server....
2013-01-02
1,188 reads
Most folks make New Year's resolutions of things they want to do over the course of the next 364/365 days....
2013-01-01
1,307 reads
I was having a twitter coversation with @dataartisan about chess. He remarked that playing on-line with random folks didn't strike him...
2012-12-17
1,033 reads
Folks have cited the recent InformationWeek article on how South Carolina's Department of Revenue was hacked because the SC state government...
2012-11-27
3,160 reads
We'll discuss surface area later in the week. Today let's talk about if you're able to connect to SQL Server....
2012-11-09 (first published: 2012-11-06)
3,424 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