While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and has the capability to recover from a disaster scenario. In this article, Samir Behara discusses the options available when designing the database architecture to achieve scalability.
Empower developers to refresh their own test systems with production backups.
The idea of serverless computing is interesting, and with Azure Stack, might be something more of us embrace.
SQL Server contains many built-in views and functions that can be used to understand what is going on “under the hood,” and security is no exception. In this article, Robert Sheldon explains the security related catalogue views, dynamic management views, and system functions
You’ve got one SQL Server hosting a bunch of databases, and performance is bad. Which database should you focus on first?
A data scientist needs some specialized skills. Today Steve Jones talks a bit about the requirements to be good at this job.
In this tip we look at how to create a SQL Server trigger on a SQL Server view.
SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Services reports, and other data visualization tools. When paired with ADO.NET data providers, you can create cubes from external data […]
In which Phil Factor toys with the thought of producing quality metrics for SQL code, before dismissing the idea as foolhardy.
Learn how to create default database compression for your SQL Server databases.
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
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...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WA:0821-8154-398 Istana Regency Sudirman, Jl. Raya Cijerah Raya No.2 Ruko No 19 & 20,...
Comments posted to this topic are about the item How We Handled a Vendor...
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