Recruiting DBAs for DevOps
DBAs are in great demand, but what if you are recruiting a DBA for DevOps? Mike Cuppett explains how to hire and train the right DBA for the job.
PostgreSQL WHERE, ORDER BY, and GROUP BY Clauses
Overview A database clause is a conditional statement used to filter data from the database. There are various database clauses available in PostgreSQL, like Where, Order By, Group By, Having, Distinct, Limit, Fetch. In this first chapter of the tutorial we will cover Where, Order By, Group By clauses with suitable example. WHERE Clause The […]
Storage 101: RAID
RAID has been around since the 90s to ensure performance and reliability of storage. Robert Sheldon explains the history and theory behind RAID.
Stairway to SQLCLR Level 6: Development Tools Intro
This time we look at the commonly used tools for doing SQLCLR development: Visual Studio (VS), SQL Server Data Tools (SSDT), and SQL Server Express LocalDB (LocalDB).
The Ease of Containers
Containers have changed how to develop and deploy software. They haven't caught on with databases as much, but Steve thinks this will change.
Getting Data In and Out of SQL Server Flyway Builds
Phil Factor provides SQL routines to extract data from and load data into a SQL Server database, using BCP, and then a PowerShell automation script that uses Flyway to automatically build a database, from scratch and then fill it with data, ready for testing.
T-SQL Tips and Tricks
In this article learn some TSQL tips and tricks working with CTEs, UPDATES, Window Functions, Duplicate Rows, Tally Tables and Concatenating string values in SQL Server
Distributed SQL Databases
There are new platforms out there that promise a distributed SQL relational database. Steve talks about a few today.
Reading a Specific File from an S3 bucket Using Python
This article shows how you can read data from a file in S3 using Python to process the list of files and get the data.
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