Goal Review Q1
As we close out the First Quarter of 2010 it is time to review progress made on the Goals I...
2010-04-01
507 reads
Blog Posts
New Trends In Storage Technology: AFD
I have a passing interest in storage technology and trends so you can probably guess I got really excited after...
2010-04-01
506 reads
Outtakes
Sometimes I think I’m quite the goober. Alternately I’ll laugh or put my head in my hands as I try...
2010-04-01
367 reads
PASS, Microsoft, and Certification
Steve Jones’ (@way0utwest) recent SQLServerCentral editorial, The Missing Certification, has spawned a vigorous debate about what the missing certification should...
2010-04-01
1,425 reads
Powershell – Useful Resources
One of my aims at the start of the year was to improve my Powershell and scripting skills. I run...
2010-04-01
1,142 reads
Renewed as an MVP
I received my renewal notice and, after checking the message header, it is April 1st, I got very happy. I’d...
2010-04-01
511 reads
Using SQL Agent Job Categories to Automate SQL Agent Job Enabling with Database Mirroring
Microsoft’s Kevin Cox (from SQLCAT) and I co-authored a blog post titled Using SQL Agent Job Categories to Automate SQL...
2010-04-01
929 reads
An Introduction to SQL Server 2008 Audit
Excerpted from Brad’s Sure Guide to SQL Server 2008, which is available as a free eBook.
Previous versions of SQL Server...
2010-03-31
2,880 reads
Growing the Pool of SQL Speakers – Part 3
Continuing on from Part 2, I want to continue this time with two points I left open last time:
How to...
2010-03-31
1,669 reads
How Many DBAs Use the Maintenance Plan Wizard/Designer?
When I wrote my most recent free eBook, Brad’s Sure Guide to SQL Server Maintenance Plans, some of the DBAs...
2010-03-31
2,299 reads
Blogs
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...
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
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 Kontak Resmi BCA KCP Kertajaya ??/Wa 08218154393
WA:08218154393 Jl. Kertajaya No.35, Airlangga, Kec. Gubeng, Surabaya, Jawa Timur 60281
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