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.
2012-02-14
2,677 reads
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.
2012-02-14 (first published: 2012-01-20)
3,219 reads
A look at the memory architecture of SQL Server and Oracle, for those of you that may need to provide support for Oracle databases.
2012-02-13
4,415 reads
Learn how to create a SQL Server 2012 Active/Active cluster in Hyper-V using an iSCSI SAN
2012-02-13
7,993 reads
There are around seventy SQL Server instance settings, and a DBA needs to be aware of the effect that many of them have. Brad McGehee explains them in enough detail to help with most common configuration problems, and suggests some best practices.
2012-02-13
4,300 reads
At the last PASS summit, we cornered SQL Server MVP Glenn Berry, and found out his views on the impact of virtualization, solid state disks and SAN administrators on the life of a DBA, and what led him to write a book all about SQL Server Hardware.
2012-02-10
1,803 reads
The relational model was devised long before computer hardware was able to deliver an RDBMS that could deliver a fully normalized database with no performance deficit. Now, with reliable SSDs falling in price, we can reap the benefits, instead of getting distracted by NOSQL with its doubtful compromise of 'eventual consistency'.
2012-02-10
3,356 reads
This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.
2012-02-09
6,872 reads
2012-02-09 (first published: 2010-09-15)
10,193 reads
Come see Brad McGehee, Grant Fritchey, Steve Jones, and more SQL Server speakers at the SQL Server Connections conference in Las Vegas this spring. Get away from the cold on Mar 26, 2011 and learn about the new version of SQL Server.
2012-02-09 (first published: 2012-01-25)
4,069 reads
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
By way of background, a while back I did video called “My New Favourite...
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
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