Do You Think About CheckDB?
Running checkdb is part of ensuring your database health and data integrity. Steve notes that you might want to review that you have the best strategy for your organization.
How to Download Stocks on Schedule Using R
Learn how you can use R to download stock data from Yahoo and schedule a script to run as often as you would like.
Help Redgate to build the next generation of Database DevOps solutions
Help Redgate to build the next generation of Database DevOps solutions so that we can help you to deliver the next generation of your software. To get involved please complete our short 2-page survey on current development practices.
How I Use Streamlabs OBS for Streaming and Training Classes
I’ve been working on my streaming setup for months now, and I’m just trying to save you some time if you really wanna take the streaming thing seriously.
What is the Machine Learning Server? Level 2 of the Stairway to ML Services
In Level 2, we look at the architecture and structure of the Machine Learning Services server process.
Automate Oracle database deployments with Redgate Change Automation
We’re excited to introduce a brand-new capability of the Deployment Suite for Oracle: Redgate Change Automation is a command line tool with built-in safety checks that lets you safely automate your Oracle database deployment. With four commands that help you build, test, prepare, and perform Oracle database releases, Redgate Change Automation can be used as part of a CI/CD pipeline.
SQL Server Business Continuity – Know Your Options
SQL Server database business continuity, including high availability and disaster recovery, is not an easy topic to engineer for. The business must work with the IT teams to define service-level agreements, statistically significant scenarios to plan for, and then decide on a budget.
Microsoft SQL Server Utilities and Tools
Useful free and paid utilities and tools for Microsoft SQL Server - complete list of 275 Utilities
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