2016-10-14
452 reads
Editorials
Developer Deployment Frustrations
SQL Server should work to make it easy for developers to work with it, and include versions like Express in their applications.
2016-10-11 (first published: 2010-09-08)
371 reads
Bingle is my Senior DBA
When working with SQL Server, many people don't need the search engine to be their junior DBA, they need it to be their senior DBA.
2016-10-10
156 reads
DBA Support
This Friday Steve Jones talks about your support load. Let us know how many databases you support and what the load is like.
2016-10-07 (first published: 2012-10-26)
249 reads
A Software Warranty
Steve Jones says that developers should take responsibility for the code they deploy, perhaps with a warranty of sorts inside their company.
2016-10-06 (first published: 2012-10-22)
161 reads
Do you have DBA syndrome?
Sometimes DBAs become resistant to change. When they lose focus on their full purpose they may have DBA syndrome.
2016-10-05
152 reads
Questioning the Interviewer
Asking questions in an interview is important, but there can be issues. Steve Jones talks a little about how to approach this.
2016-10-04 (first published: 2012-10-15)
565 reads
Coming Attacks
What happens if we can't access the Internet? We should be prepared, at home and work. Steve Jones has a few comments.
2016-10-03
103 reads
Intelligence from Data
This week Steve Jones looks at the idea of using AI and machine learning with your data to develop amazing new insight.
2016-10-03
56 reads
The Exciting World of Data
Steve Jones gave a keynote, and has a little fun this week with the topic of his talk.
2016-09-30
81 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