Track Your Consultants
It's possible to perform a man-in-the-middle attack against SQL Server. Steve Jones notes you should be aware these attacks could take place inside of your network.
2016-03-29
92 reads
Editorials
Dexterity Matters
The individual's dexterity can impact how we use software. Perhaps we need ways to undo mistakes in various systems.
2016-03-28
72 reads
2016-03-28
185 reads
Protecting sa
Today Steve Jones talks about the issues with the sa account, and how you might protect this on all your instances.
2016-03-25
113 reads
Do Less
One way to make code run faster is to have less of it. Or ensure the code you have does less work.
2016-03-24
118 reads
2016-03-22
161 reads
On-Time, or Not
Today we have a guest editorial from Andy Warren that looks at the respect, understanding and compromise we might make with each other.
2016-03-21
113 reads
The New Men of IT
According to the New Men of IT, the industry changes so frequently that experience and qualifications quickly become obsolete and irrelevant. The argument won't wash with Phil Factor.
2016-03-21
155 reads
BYOD
In the future we may be required to bring our own devices to work. Does that make sense? Would you want to get an allowance and purchase your own laptop?
2016-03-18 (first published: 2012-01-18)
257 reads
2016-03-17
126 reads
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
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...
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