How to become a data scientist: A data-driven approach to careers in data science
Many devs and IT professionals looking for the next career wonder how to become a data scientist. Ashwin Thota matches up skills to job titles.
Disclosing the How
As we use more Artificial Intelligence and Machine Learning tools in our applications, we need to understand how they work.
SQL Server DBA Utility Dashboard
Create a quick application that stores your favorite queries that you can use to quickly connect to any server and return the results.
What is the state of Database DevOps in 2021?
The latest State of Database DevOps report has been published and it’s packed with data from over 3000 IT professionals. You’ll learn about the latest DevOps trends, industry insights, and tips from contributors such as Pramod Sadalage and Kendra Little. Get your free copy.
Stories to Engage Us
I've always been fascinated by history. For a long time growing up, my plan was to become a history teacher. While that didn't work out, I've continued to read quite a lot of history, both popular and scholarly works. One of the things about it that I find most fascinating are the stories. History is […]
Making Guesses
When working on a new database, Steve Jones hesitates to make too many guesses, or at least, too many exact guesses.
Catch-up on Redgate Summit
Did you miss the excellent presentations from DevOps experts Pramod Sadalage, Kellyn Pot’Vin Gorman, Samir Behara, and Kendra Little? Good news – all Redgate Summit sessions are available on-demand now. Choose from ‘the future of database DevOps’ keynote, latest DevOps trends, Q&A discussion, and demos.
Power BI Small Multiples Visual Example
Power BI has a new feature which is the Power BI Small Multiples visual. In this article we cover how to enable this feature and also walk through an example of how to use this in a Power BI report.
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