The SQLServerCentral.com Casino Party at the PASS Summit
It is just next week that the PASS 2005 Summit kicks off and we've got some information about our casino party for those attending.
2005-09-20
3,557 reads
SQL Server Central
Come To The PASS 2005 Summit
Less than two weeks away, sessions tried and tested at the PDC, the Microsoft SQL Server development team and gambling with SQLServerCentral.com! Register today!
2005-09-15
2,949 reads
Extreme SQL Server
Clustering, partitioning, database snapshots, database mirroring, SQL Server SAN storage design and more are all in the September issue of the SQL Server Standard.
2005-09-12
5,091 reads
Who Is Using SQL Server 2005?
The release of SQL Server 2005 is a few months away and there are many people that are excited and looking forward to moving the new release into production. But what percentage of people are really looking to adopt the new platform soon? Edgewood Solutions has put together a survey to see. Enter and you could win a prize.
2005-08-24
4,907 reads
SQL Server Stumper Sale
The amazing 4S sale! Our space constraints are your gains as we've put a bunch of books on sale. Check them out and save.
2005-08-23
4,286 reads
Jacksonville - 2005 Code Camp
If you are near the Jacksonville, FL area on Saturday, August 27th, check out this code camp with our own Brian Knight. Get the chance to learn some great development from Brian and a few other experts.
2005-08-17
2,962 reads
SQL Server Spotlight - Thierry D'Hers
Who builds SQL Server? It's an interesting collection of individuals and we're looking to bring you some profiles of them all. This time Steve Jones interviews Thierry D'Hers, leader of the BI group.
2005-08-11
8,220 reads
SSC Source Code for the PASS 2005 Summit
With a month left before the 2005 PASS Summit, there is yet another great reason to attend this SQL Server conference in 2005. Read about it and be sure that you register today with our source code "SSC".
2005-08-10
2,827 reads
Apologies to Ken Henderson
We are sorry to say that a case of plagiarism occurred recently and SQLServerCentral.com is issuing an apology to Ken Henderson.
2005-07-27
16,170 reads
SQLServerCentral.com Blogs
They're here, ready and waiting for the community to dig in and enjoy. Read a little about them and how you can get your own SQLServerCentral.com blog.
2005-07-14
3,253 reads
Blogs
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
WITH clause gets a 26ai boost!
By way of background, a while back I did video called “My New Favourite...
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