DAX calculations with hierarchies: Set the order straight.
[2017-Apr-30] If you have ever tried to create calculated measures in SSAS Tabular/ Power BI models where different levels of...
2017-05-10 (first published: 2017-04-30)
4,784 reads
[2017-Apr-30] If you have ever tried to create calculated measures in SSAS Tabular/ Power BI models where different levels of...
2017-05-10 (first published: 2017-04-30)
4,784 reads
[2017-May-08] Listening to a car radio with many different talk shows available, it comes more often to my mind, that...
2017-05-08
668 reads
[2017-Mar-31] You can call one of your web service methods in SSIS package using a .NET script task or you can just...
2017-03-31
3,514 reads
[2017-Feb-21] I'm creating this particular blog post more for myself to remember and use it as a reference to related discussions...
2017-02-23 (first published: 2017-02-21)
3,292 reads
[2017-Jan-29] It came as a request from one of my customers where I had worked as a consultant to quickly compare...
2017-01-29
2,758 reads
[2016-Nov-04] Open data is like a soup, some people like it hot (or made with all the latest updates); some people...
2016-11-04
611 reads
[2016-Oct-18] I read a book one time about the importance of using visual aids in teaching. They also used a well...
2016-10-28 (first published: 2016-10-18)
1,752 reads
[2016-Sep-30] Working with reports based on historical data is like driving a car while looking in the rear view mirror. I heard...
2016-09-30
1,566 reads
[2016-Aug-31] Someone said a picture is worth a thousand words and this is true that in most cases a visual representation...
2016-08-31
1,165 reads
[2016-July-31] Last week was my 2nd time participating at the local Toronto Open Data meetup (https://www.meetup.com/opentoronto/). The audience of this meetup...
2016-08-02 (first published: 2016-07-31)
2,621 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