Putting Corrections in Perspective using Power BI
My enthusiasm for analyzing stock market data using Power BI – even after publishing two posts recently (this and this) – is at...
2015-10-13
550 reads
My enthusiasm for analyzing stock market data using Power BI – even after publishing two posts recently (this and this) – is at...
2015-10-13
550 reads
What’s my share? Calculating percent share of the total is a common need. Let’s see how to calculate this in Power BI...
2015-10-06 (first published: 2015-09-29)
24,923 reads
My article “SSIS Design Pattern – Staging Fixed Width Flat Files” is published on SQLServerCentral.com. In the article, I provide a...
2015-10-06
651 reads
There’s a saying that birds of the same feather flock together. When you throw your data on a scatter chart,...
2015-09-25 (first published: 2015-09-14)
3,085 reads
Let’s say you have a table that records transactions along with the date of when the transaction took place. Wait,...
2015-09-22
5,146 reads
When you start working in ETL (Extract, Transform, and Load) or SSIS projects, you’ll be faced with two basic terms:...
2015-09-16 (first published: 2015-09-08)
33,839 reads
U.S. stock markets have taken a beating this past week fueled by China markets. Take a look at how China and...
2015-09-02 (first published: 2015-08-24)
3,530 reads
About 80% of the world’s population lives in about 13% of the countries. Okay, this statement is not as knee-jerking...
2015-09-01
7,110 reads
S&P 500 index is an American stock market index consisting of 500 large companies and is considered to be the...
2015-08-17
2,669 reads
Blank values are annoying, anywhere and everywhere. If your source system contains them, here’s how to convert blank values to NULL in...
2015-08-11
15,594 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