Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.
Culture is important at our workplace. Steve Jones notes this can be important when trying to get the most performance from your employees.
Phil Factor reflects on how hard it really is to develop a really effective database that meets the SQL Standards, and how as a result we are only beginning to realize fully the vision of relational orthogonality in databases.
In this third article of the exploring SQL Server 2016 Always Encrypted series, Greg Larsen looks at the differences between an Always Encrypted column that uses an encryption type of Deterministic and those that use encryption type of Randomized.
Automatically capture replication conflicts and generate an automated email notification.
This week Steve Jones wonders about the age of your instances and whether you are planning on upgrades or aware of how many out of support instances you might have.
Read this tip to learn how to import data from multiple Excel worksheets into SQL Server using SSIS.
An evaluation of the SQL Azure Database Performance Levels recommended by the DTU Calculator service, and a comparison with on premise SQL Server performance.
We have an operating system for how our organizations are run. Steve Jones talks about a new one that might be important for the world rules by software.
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item How We Handled a Vendor...
Comments posted to this topic are about the item Cognitive Coverage
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