2015-12-21
327 reads
Editorials
Running as SysAdmin
Today we have a guest editorial from Andy Warren. We still have many applications runnning under sysadmin accounts, often "sa". Why do people do this? Andy has a few thoughts on the subject.
2015-12-21 (first published: 2011-05-04)
531 reads
2015-12-17
227 reads
2015-12-15
216 reads
Security Decisions
This week Steve Jones looks at how we make secutiy decisions for our systems, and whether this is really the best way to do things.
2015-12-14
104 reads
2015-12-14
318 reads
How Much Eventual Consistency Do You Have?
This week Steve Jones wants to know if you have eventual consistency in your environment?
2015-12-11
249 reads
Are We Engineers?
Steve Jones continues the never ending argument of whether software developers deserve the moniker of engineer.
2015-12-10
182 reads
2015-12-09
124 reads
Building Better Communication Skills
Today Steve Jones reminds us that our communication skills are important. They are something that we use constantly at work and are worth developing.
2015-12-08 (first published: 2011-01-10)
439 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...
Alamat Kantor BCA KCU BANDUNG Telp/Wa 0817839777
Hubungi Cs: 0817844112 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat...
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...
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