Will You Vote?
Voting is one of the many privileges that I have as an American citizen. It’s a privilege that most Americans...
2013-09-23
566 reads
Voting is one of the many privileges that I have as an American citizen. It’s a privilege that most Americans...
2013-09-23
566 reads
According to Merriam-Webster the definition of grace is:
1a : unmerited divine assistance given humans for their regeneration or sanctification; b : a...
2013-05-30
1,235 reads
I have recently begun to contemplate pursuing the MCSA Certification. I have been working with SQL Server for almost 20...
2013-05-17
616 reads
“The Long and Winding Road” is one of my favorite Beatles songs, it reminds me of my dad, he was...
2013-05-14
567 reads
I presented on this topic at the TriadSQL User’s Group meeting on 3/26/13. I promised I would post my code/solutions,...
2013-03-29
2,148 reads
What a whirlwind last week was. There were so many sessions to attend and only one of me. I needed...
2012-11-12
725 reads
I have just recently changed employers and in doing so, I’ve changed my role from Data Architect to DBA/BI Developer. ...
2012-10-24
1,914 reads
Did you know that it’s election season for PASS? Did you know that you can pose questions to the potential...
2012-08-27
606 reads
I’m putting my money where my mouth is, with respect to my last blog post. I am officially a mentor...
2012-08-24
637 reads
My company has recently put forth an effort to hire fresh college graduates and interns. I think this is a...
2012-08-24 (first published: 2012-08-22)
1,728 reads
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
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
Comments posted to this topic are about the item JSON Has a Cost, which...
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
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