SQL Saturday Richmond (#610)
On Saturday, March 18, 2017, I spoke at my very first SQL Saturday. I have been an attendee, involved in...
2017-03-22
334 reads
On Saturday, March 18, 2017, I spoke at my very first SQL Saturday. I have been an attendee, involved in...
2017-03-22
334 reads
I can’t believe it’s almost time for SQL Saturday #610. I’ll be there presenting What is Power BI? If you...
2017-03-11
330 reads
I did it! I did my first “real world” presentation this morning at the Triad Developers Conference in Winston-Salem. What...
2017-03-10
334 reads
I am honored to have been recommended by a colleague and selected as a speaker for the Triad Developer’s Conference...
2017-02-09
362 reads
I am so honored and excited to have been selected to speak at SQL Saturday Richmond on March 18, 2017.
I...
2017-01-31
608 reads
As DBAs we all know setting your file growth to grow by percent is not optimal. It can cause all...
2017-01-31
728 reads
Right now I am so excited, and a little embarrassed. After using Visual Studio (VS) for database projects for the...
2017-01-23
6,108 reads
The Sound of Music is one of my all time favorite movies. It reminds me of some great times with...
2016-10-12
509 reads
That’s right, SQL Saturday Charlotte is coming September 17, 2016. Next to the annual PASS Summit, this is my favorite...
2016-09-01
390 reads
There were so many cheers when Microsoft announced that the .Net 3.5 Framework was no longer a pre-requisite for installing...
2016-06-30
3,159 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