Changing Replication Passwords
A how-to guide for configuring replication agents after a password change
Moving Fast at Redgate
It's possible to change a software development team and dramatically improve things. Steve Jones highlights an example from Redgate Software.
Strengthening the Foundations of Software Architecture
The term 'Architecture' seems to imply a plan that you can't easily subsequently deviate from. It's true that, if you abandon software architecture, you end up with a big ball of mud, but maybe the art of software is to make change much easier by planning how to implement each feature, tackling dependency issues, splitting functionality into small discrete components and considering how they should interact with each other.
How to Run Scheduled Jobs in Azure SQL Databases
This article will help you to schedule jobs in Azure SQL.
Passwords Under Pressure
Passwords are a problem, especially when we're in a hurry. What should we do?
Introduction to Azure SQL Database Temporal Tables
As announced on June 1, 2016, SQL Server 2016 has reached its general availability. This means that you finally have the option to implement some of its new features in the production environment. While we still have to wait for their full support in Azure SQL Database V12, it is likely that their preview stage will be concluded soon. In this article, we will focus on Temporal tables, which is one example of these new features.
How Far Have You Traveled for a SQL Saturday?
This Friday Steve Jones talks SQL Saturdays and asks how far you've traveled to attend one.
Execute SQL Server DBCC SHRINKFILE Without Causing Index Fragmentation
Simon Liew shows how to execute SQL Server DBCC SHRINKFILE without causing index fragmentation and example conditions that cause fragmentation.
Data Quality - Addressing non-stated requirements
Producing a crib sheet for data quality drives a shared understanding of the data used to power the business.
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