Even the most experienced programmers can be caught out unawares by software they've used for years without trouble. Dino Esposito explains why and how the JSON method in an ASP.NET MVC controller class suddenly started to cause an exception on a production server, and how he fixed the problem.
Join Justin Dearing and Elizabeth Ayer to hear about some of the key challenges of database version control, and why it's only a matter of time before it's as essential as good backups and high performance.
The move to limit disclosure of vulnerabilities continues, with potential issues for many of us.
As yet more personal details are spilled by preventable security lapses, what's
Cloud computing is on the move. Slowly but surely, businesses are transitioning more and more key pieces of infrastructure to the cloud in order to take advantage of cost, flexibility and agility benefits. And databases, the heart and soul of all applications, are the most critical component of this transition. Gerardo Dada explores the topic.
Greg Larson gives an in-depth look at ten of the new features you can expect from SQL Server 2016.
Interruptions are the enemy of productivity for creative people, like software developers. Steve Jones talks today about the need for quiet time.
What are the scripts that a working DBA uses so often that they become part of the 'muscle memory'? Grant Fritchey asked the question on the forums of SQL Server Central. From the large response, Grant was able to pick out the ten most popular T-SQL commands, scripts, or fragments. It seems as if, despite the range of tasks we do, there are some common tools we use.
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
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...
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
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