Really Important Software
Software often controls hardware, which can make it the critical part of a system. That's something we should be learning from the Boeing 737-Max crashes.
Writing R Code in SQL Server - Level 3 of the Stairway to Machine Learning Services
In this level, learn about how to get the tools needing for coding in R and how to execute some code that connects to SQL Server.
Enable SQL Server Agent Mail Profile
Learn how to configure SQL Server Agent to allow emails to be sent for job notifications and alerts.
The BI Journey: The Expert’s Advice – Part 2
A BI project should return value to the company quickly, not only after months or even years of work. In this article by Gogula Aryalingam, Ruthie, the intern, determines which items from her manager's requirements she can complete before the big meeting. She continues working on her semantic model by including a Date table, the star schema, measures, formatting, and more.
The Blast Radius of a database
Phil Factor feels that the database gets the short shrift in any outage - it's time to stop saying "the database has gone down" and time to start thinking about the resilience of the entire system.
The Difference Between Rollup and Cube
Learn about the fundamental differences between the ROLLUP and CUBE operators.
Change Not For Replication Value for SQL Server Identity Columns
In this tip we look at how to change the SQL Server setting for a tables identity column to not for replication for existing tables.
Designing Highly Scalable Database Architectures
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.
A Self-Serve System that Allows Developers to Refresh Databases (Part 1)
Empower developers to refresh their own test systems with production backups.
Serverless
The idea of serverless computing is interesting, and with Azure Stack, might be something more of us embrace.
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
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...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
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