Analyzing Baby Names using Power BI
Me and my wife are contemplating names for our first baby we’re expecting in a couple of months! We don’t...
2015-06-16
799 reads
Me and my wife are contemplating names for our first baby we’re expecting in a couple of months! We don’t...
2015-06-16
799 reads
Here are the slides and links to awesome resources for my presentation, “Team-based Database Development: Playing Nice With Others”
If you...
2014-04-29
2,648 reads
When working with SSIS, you’ll often find the need to read the contents of a flat file to a variable,...
2014-04-22 (first published: 2014-04-08)
7,575 reads
I’m excited to present two different sessions in April at DC SQL Server User Group and at Baltimore SQL Server User Group. I...
2014-04-03
546 reads
If you’re a data warehouse developer, chances are you use T-SQL Merge statement to process slowly changing dimensions. If you’ve...
2014-02-05
1,334 reads
We all have bad habits. Maybe we eat too many snacks, spend too much time on the couch watching TV,...
2014-01-21
587 reads
What's wrong with the following code?
tsqlLine number Off | Hide | Select allSELECT a.[BusinessEntityID] , b.[FirstName] , b.[LastName]FROM[HumanResources].[Employee] a INNER JOIN [Person].[Person] b ON...
2013-03-05
782 reads
What’s wrong with the following code?
SELECT
a.[BusinessEntityID]
, b.[FirstName]
, b.[LastName]
FROM [HumanResources].[Employee] a
INNER JOIN [Person].[Person] b
ON b.[BusinessEntityID] = a.[BusinessEntityID]Nothing – except for my...
2013-03-05
894 reads
When creating a SSRS report, you want to add lines that display trends. You want to show trends for more...
2013-02-26
855 reads
When creating a SSRS report, you want to add lines that display trends. You want to show trends for more...
2013-02-26
478 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