Renewed as a Friend of Red Gate
I recently received the news that I’ve been renewed as a Friend of Red Gate. I’ve been a big fan of Red Gate since the days when SQL Compare...
2020-02-25
17 reads
Blog Posts
Why I Support Code Automation Tools Like ORMs
I know I’m a weirdo. I’ve always been a weirdo. When I was a DBA (now I only play one on TV), I was a weirdo too. Case in...
2020-02-25 (first published: 2020-02-17)
545 reads
Extended Events: Database Auditing
Extended Events can do things that simply are not possible with Profiler and another example comes from the stack of audit events that exist only in Extended Events. One...
2020-02-24
59 reads
Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)
I am very passionate about having a disaster recovery architecture, plan and strategy. This is very important for business continuity. I will be walking you through a journey on implementing High Availability (HA) (AlwaysOn Availability group) on MSSQL Server.
2020-02-24 (first published: 2020-02-14)
704 reads
Redgate Software Needs You!
I’ve been very blessed to be able to work for Redgate Software. We’ve done some amazing stuff over the years. We’re going to be doing even more amazing stuff...
2020-02-24
35 reads
SheLeadsTech Webinar: Braving the Wilderness of Cybersecurity
ISACA has a SheLeadsTech webinar for tomorrow, February 25, 2020 titled Braving the Wilderness of Cybersecurity. Registration Link: https://www.isaca.org/education/online-events/lms_w022520 If you can’t make the talk, ISACA archives all webinars...
2020-02-24
19 reads
Speaking for Omaha Azure User Group Wednesday
This Wednesday, February 26th, I will be presenting a new session entitled “All Things SQL in the Microsoft Cloud” for the Omaha Azure Users Group, starting at 6pm Central...
2020-02-24
9 reads
Top 3 Database Life Hacks
Three very powerful but simple hacks that can give you back dozens of minutes per day.
Related Posts:
Best New(ish) SSMS Feature December 26, 2017
Puzzles and Daily Trivia May 14,...
2020-02-24 (first published: 2020-02-12)
1,454 reads
Use Jupyter Notebooks to Help People on StackOverFlow
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing my previous blog post! I was talking with my...
2020-02-22
48 reads
Change Outlook sender mailbox with PowerShell – A workaround
The idea of this blog post, like many others I write, is to document a workaround solution to my problem. Hopefully I can also help someone that may be...
2020-02-21 (first published: 2020-02-12)
2,981 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 WISMA ASIA Telp:(0817)866887
??/WA:0817866887 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu Sel., Kec....
Alamat kantor BCA KCU PONDOK INDAH ??/WA:(0817)866887
WA:0817866887 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec....
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