Machine Learning + DevOps = ML DevOps (Together at Last)
[read this post on Mr. Fox SQL blog] For the longest time data science was often performed in silos, using large machines with copies of production data. This process...
2019-06-10
23 reads
Mr. Fox SQL
SQL Saturday 769 Melbourne & 771 Sydney
For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney…
SQL Saturday769 (Sat 30 Jun 2018)...
2018-05-31
379 reads
SQL Saturday 769 Melbourne & 771 Sydney
For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney… SQL Saturday 769 (Sat 30 Jun 2018) Melbourne. SQL Saturday 771 (Sat 07 Jul 2017)...
2018-05-31
14 reads
Using Elastic Query to Support SQL Spatial in Azure SQL DW
[read this post on Mr. Fox SQL blog]
Recently we had a requirement to perform SQL Spatial functions on data that...
2018-04-10
624 reads
Using Elastic Query to Support SQL Spatial in Azure SQL DW
[read this post on Mr. Fox SQL blog] Recently we had a requirement to perform SQL Spatial functions on data that was stored in Azure SQL DW. Seems simple...
2018-04-10
11 reads
Azure Cognitive Services API’s with SQL Integration Services Packages (SSIS)
[read this post on Mr. Fox SQL blog]
I had a recent requirement to integrate multi-language support into a SQL DW via...
2018-03-12
1,180 reads
Azure Cognitive Services API’s with SQL Integration Services Packages (SSIS)
[read this post on Mr. Fox SQL blog] I had a recent requirement to integrate multi-language support into a SQL DW via a SQL SSIS ETL solution. Specifically the SQL DW...
2018-03-12
49 reads
Database Backup Options for SQL on Azure IaaS
[read this post on Mr. Fox SQL blog]
Recently I had a requirement to collate and briefly compare some of the...
2018-01-28
1,079 reads
Database Backup Options for SQL on Azure IaaS
[read this post on Mr. Fox SQL blog] Recently I had a requirement to collate and briefly compare some of the various methods to perform SQL Server backup for...
2018-01-28
12 reads
Tuning Throughput from Azure Event Hub to Azure Stream Analytics
[read this post on Mr. Fox SQL blog]
Recently I had a requirement to load streaming JSON data to provide a...
2017-11-07
753 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
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