Running MySQL on a VSTS build agent
I had a requirement to run MySQL on a VSTS hosted build agent and then to be able to run commands from outside of the container and this gave...
2018-05-08
9 reads
Ed Elliott
Running MySQL on a VSTS build agent
I had a requirement to run MySQL on a VSTS hosted build agent and then to be able to run...
2018-05-08
219 reads
Database testing and ETL processes
Unit testing using tSQLt is really great, you call FakeTable on any tables your code touches and then insert the columns and rows your test actually need, nothing more,...
2018-05-01
13 reads
Making Deployments Simpler with Re-runnable Scripts
Make sure your SQL Server database release scripts to make life easier.
2018-04-20 (first published: 2015-11-17)
10,069 reads
Why didn't my Azure ARM deploy work?
I have been using Octopus to deploy ARM templates for a while now and the default task that comes with...
2018-04-09 (first published: 2018-04-04)
1,653 reads
Interesting Azure ARM "Make it So" behaviour
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{ "comments": "Managed Disk.", "type": "Microsoft.Compute/disks", "name": "[variables('diskName')]", "apiVersion": "2016-04-30-preview", "location":...
2018-04-05
9 reads
Interesting Azure ARM "Make it So" behaviour
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{
"comments":...
2018-04-05
324 reads
Interesting Azure ARM "Make it So" behaviour
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{ "comments":...
2018-04-05
188 reads
Interesting Azure ARM "Make it So" behaviour
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{ "comments":...
2018-04-05
127 reads
Why didnt my Azure ARM deploy work?
I have been using Octopus to deploy ARM templates for a while now and the default task that comes with Octopus to deploy doesn't have any debugging information enabled...
2018-04-04
15 reads
Blogs
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
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...
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