Does the Role of the DBA Need to Evolve?
With the amount of data being stored expanding exponentially, does the role of the DBA need to change from caretaker to interpreter?
2011-12-12
261 reads
With the amount of data being stored expanding exponentially, does the role of the DBA need to change from caretaker to interpreter?
2011-12-12
261 reads
Part 1 of Question 14—The question.Part 2 of Question 14—The follow up to the question.This is a continuation of my...
2011-12-08
713 reads
DBAs (Database Administrators) perform many different tasks, and one way to explain what a DBA is, is to describe the...
2011-12-08
2,107 reads
By Grant Fritchey
http://www.scarydba.com/
A DBA (Database Administrator) is a Data Professional tasked with managing an organization’s data using some sort of...
2011-12-07
2,260 reads
Part 1 of Question 13: The Question.Part 2 of Question 13: The follow up to the question.This is a continuation...
2011-12-07
619 reads
This is a continuation of my DBA in Space journal.
As this scene starts on Lunar Exhibition set, Miss Friday is...
2011-12-06
473 reads
Judging any contest is difficult, as you want to be as fair as possible. So coming up with the final...
2011-12-06
645 reads
Today, the final 15 competitors were announced at the DBA in Space website. To get into the final 15, the...
2011-12-06
937 reads
The voting for Red Gate Software’sDBA in Space Contest is to begin on Tuesday, December 6, after the final 15...
2011-12-06
691 reads
Part 1 of Question 11—The Question.Part 2 of Question 11:The follow up to the question.This is a continuation of my...
2011-12-05
691 reads
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
In all recent versions of the database you can call DBMS_UTILITY.EXPAND_SQL_TEXT to get the...
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item How We Handled a Vendor...
Comments posted to this topic are about the item Cognitive Coverage
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