Azure DWH part 12: Permissions, roles, logins and users
In this article we will show some common roles and queries related to Azure SQL Data Warehouse.
2017-07-25
5,101 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
Azure DWH part 11: Data Warehouse Migration Utility
There is a new utility to import data from SQL Server on premises or Azure SQL to Azure SQL Data Warehouse (ASDW)
2017-07-17
1,714 reads
Azure DWH part 10: WPF and Azure SQL Data Warehouse
In this article, we will show how to create a WPF application and show how to insert data to ASDW.
2017-07-10
835 reads
Comparing and Synchronizing Two Folders with Azure
In this article, we will compare two folders using PowerShell, the command prompt and other tools.
2017-05-30
2,332 reads
Azure DWH part 9: Azure PHP and ASDW
In this new Azure Data Warehouse article, we will show how to insert data and retrieve it using PHP.
2017-05-22
627 reads
Azure DWH Part 8: Accessing Azure SQL Data Warehouse with C#
In this new article, we will learn how to access to our Azure DWH tables using C#.
2017-05-15
2,334 reads
Azure Machine Learning - Your first experiment
In this chapter, we will show how to create a Machine Learning experiment from our Azure SQL Warehouse.
2017-05-05 (first published: 2016-06-14)
5,746 reads
Azure Data Warehouse 7: Create reports in Azure SQL DWH using SSRSS
In this article, we will show how to create reports in ASDW using SSRS
2017-03-27
1,563 reads
Backups in Azure SQL Data Warehouse
This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.
2017-03-20
3,657 reads
Azure DWH Part 5: How to work with the command line in Azure SQL DW
This time we will work with the sqlcmd to handle our Azure SQL Data Warehouse
2017-03-09
1,192 reads
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
WITH clause gets a 26ai boost!
By way of background, a while back I did video called “My New Favourite...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers