So You Want to Write a Book?
What the heck is wrong with you?
Still interested? Fine. I’ll tell you my take on this whole business. I’m only...
2010-02-19
705 reads
Blog Posts
Speaking at the PASS DBA Virtual Chapter
Next week, I’ll be “in the cloud” as I give a presentation for the PASS DBA Virtual Chapter. The topic...
2010-02-19
350 reads
SQL Azure Database Service Update 1 Released on February 17
Microsoft’s David Robinson has announced on the SQL Azure Team Blog that they have released Service Update 1 for SQL...
2010-02-19
523 reads
SQL Server 2005/2008, Service Packs - announcement
This is a good news from the Microsoft about SQL Server Release Services for both versions SQL Server 2008 & 2005.
SQL...
2010-02-19
659 reads
Testing New Features in SQL Azure Service Update 1
It seems to be SQL Azure night for me tonight… I thought I would try out some of the new...
2010-02-19
713 reads
BugMeNot
Warning: Rant coming
Every once in awhile I get a note from someone, usually a somewhat nasty one, that complaints about...
2010-02-18
1,096 reads
Chicago Next Week
I’m in Chicago for a couple days next week, flying in on Sunday. Anyone in the area available for dinner...
2010-02-18
541 reads
Cumulative Update Package 8 for SQL Server 2005 Service Pack 3
Microsoft has released CU8 for SQL Server 2005 SP3, which you can get here. This is Build 4285. This CU...
2010-02-18
677 reads
Free MSDN Azure Event in Orlando
Joe Healy is doing a four hour Azure training event on March 6, 2010 in Orlando, details and free registration...
2010-02-18
665 reads
Getting over to ASK
I haven’t been great about spending time at ask.sqlservercentral.com. It wasn’t my idea to set it up, and while I...
2010-02-18
755 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