On Thursday February 16th at 12PM noon Central, Steve Simon will discuss “No Matter how well planned and executed, data structures sometime resembles something out of a Dr. Seuss book."
It's easy to get stuck in a rut and not learn to use the new features and capabilities of your tools are they evolve. Steve Jones reminds you it's worth a little time investment to learn about your tools.
The arrival of the (MAX) data types in SQL Server 2005 were one of the most popular feature for the database developer. At the time, there was a lot of discussion as to whether this freedom from having to specify string length came at a cost. Rob attempts to give a final answer as to any down-side.
This document shows how to install a Microsoft SQL Server 2008 R2 Reporting Services instance.
This Valentine's Day Steve Jones wants to thank everyone in the community for their efforts.
We asked Buck Woody to come up with his favourite 'Cloud' Howlers. After 'Howler' monkeys, we are faced with Howler letters. Buck dreams of sending Howler letters to the folks who dreamed up the marketing hype around 'cloud' services, who misunderstand services, who don't prepares applications for distributed environments and so on.
If you will be in London on Mar 29th, come to the official UK launch of SQL Server 2012 at SQL Bits X. Saturday is sold out, so if you registered and cannot come, please cancel. There are still a few spots for Thur and Fri.
A look at the memory architecture of SQL Server and Oracle, for those of you that may need to provide support for Oracle databases.
Anonymizing data is hard, and Steve Jones talks about some of the problems with trying. Is this something we should be more concerned about this with our corporate data?
Learn how to create a SQL Server 2012 Active/Active cluster in Hyper-V using an iSCSI SAN
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item How We Handled a Vendor...
Comments posted to this topic are about the item Cognitive Coverage
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