An important query to remember
This is based on a post with respect to where our focus and efforts should be that I wrote at...
2012-08-30
1,861 reads
This is based on a post with respect to where our focus and efforts should be that I wrote at...
2012-08-30
1,861 reads
It's been a while since I was in the day-to-day business of security patches. However, I still keep up with...
2012-08-24 (first published: 2012-08-21)
2,575 reads
This falls in line with a previous post about common sense in IT.
I was having lunch with a co-worker,...
2012-08-23
1,746 reads
I was watching a training video last night and the instructor made the statement we hear all the time:
"Test this...
2012-08-23 (first published: 2012-08-17)
4,600 reads
Auto-deploying AV definitions has become common place throughout the industry. However, this post from the SANS Internet Storm Center raises the...
2012-08-21
1,276 reads
If you are in or around the Charlotte, NC area, there is a PowerShell Saturday coming your way on September...
2012-08-15
1,350 reads
As I blogged about previously, tomorrow (Wednesday) I will be speaking for the PASS Professional Development virtual chapter. My talk will...
2012-08-14
1,133 reads
Around April this year, my men's accountability group was talking about a shared pain: income taxes. We were all worried...
2012-08-13
1,706 reads
This coming Wednesday I will be speaking for the PASS Professional Development virtual chapter. My talk will be on my...
2012-08-10
2,116 reads
A Facebook thread by one of my friends brought this one to mind. He was asking about what the current...
2012-08-09
1,948 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.
Pench National Park is one of the best places to visit for the first...
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...
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