Azure Feature Pack for SSIS 2017 installation

Azure feature pack for SSIS 2017.
Below video demonstrates How to install Azure feature pack for SSIS 2017.

How to use Count(*) twice in one sql statement

Using SQL Count() function twice in a Select statement, we can achieve below ways

Consider in general ways we need to find the product names and corresponding Male or Female subscriber to that product. 

We can use better example also, I have used here the functionality of usage.

select 
dm.EnglishProductName,
count(dm.EnglishProductName) over (Partition by dm.EnglishProductName) CntProduct ,
dc.Gender,count(dc.Gender) over (Partition by dc.Gender,dm.EnglishProductName) CntProduct
from [dbo].[FactInternetSales] FI
join DimProduct DM on DM.ProductKey=Fi.ProductKey
join DimCustomer DC on dc.CustomerKey=fi.CustomerKey
where dm.EnglishProductName in('Long-Sleeve Logo Jersey, S','All-Purpose Bike Stand')

output :

Above scipt will display count of both Product as well Gender

If it required to display count of distinct Gender for the product details, we do below way

SELECT dm.EnglishProductName 

, SUM(CASE WHEN dc.Gender='M' THEN 1 ELSE 0 END) AS 'Male'

, SUM(CASE WHEN dc.Gender='F' THEN 1 ELSE 0 END) AS 'Female'

from [dbo].[FactInternetSales] FI

join DimProduct DM on DM.ProductKey=Fi.ProductKey

join DimCustomer DC on dc.CustomerKey=fi.CustomerKey

where dm.EnglishProductName in('Long-Sleeve Logo Jersey, S','All-Purpose Bike Stand') 

GROUP BY dm.EnglishProductName

Output: