Daily Coping 1 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-01
21 reads
Blog Posts
Data BIts – Episode 3 – Ginger Grant
Trainer and Consultant extraordinaire Ginger Grant stops by to talk Machine Learning, Data Bricks, Certifications, Norwegian pastries and proper chocolate frosting Find Ginger at Desert Isle SQL or on Twitter
The post Data BIts...
2020-04-01 (first published: 2020-03-26)
212 reads
Picking up the pieces after the DBA has left: taking ownership of a SQL Server instance
WARNING: This post contains information that can get you fired if you use it without express written permission. In some jurisdictions it might get you jail time as well....
2020-04-01
60 reads
SQL Homework – April 2020 – Continuity planning.
Normally for April 1st I’d try to post something a bit more lighthearted but with the state of the world ... Continue reading
2020-04-01
8 reads
SQLpassion Online Training in April
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-04-01
2 reads
SQLpassion Online Training in April
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-04-01
24 reads
Transforming JSON to CSV with the help of Flatten task in Azure Data Factory - Part 2 (Wrangling data flows)
(2020-Mar-26) There are two ways to create data flows in Azure Data Factory (ADF): regular data flows also known as "Mapping Data Flows" and Power Query based data flows also...
2020-04-01 (first published: 2020-03-26)
1,316 reads
Be Safe, Be Strong and Be Kind…. surviving COVID Lockdown in New Zealand
Currently we have have the COVID-19 pandemic sweeping the world. Here in New Zealand we are currently in lockdown – what this means is that we Kiwis are required...
2020-03-31
96 reads
Daily Coping 31 Mar 2010
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-31
20 reads
DB Automation with Azure DevOps
I sincerely believe the key to your future as a DBA is your ability to automate everything you do. However, the single hardest thing that you have to do...
2020-03-31 (first published: 2020-03-25)
451 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