Demystifying the use of CASE in an ORDER BY statement
Chuck Hoffman exposes the mysteries of getting CASE statements to work in dynamic ORDER BY statements.
System Stored Procedures for SQL Azure Linked Servers
Microsoft released the preview version of Azure SQL Database V12 in December of 2014. As a database administrator, you might wonder about the schema and security of these new data marts. Microsoft has supplied system stored procedures for the database developer to query the Linked Servers for this type of meta data, as John Miner explains.
Architecture for Auditing
The way in which auditing is build into our systems isn't the best way to implement the practice.
Data Mining Part 28: Programming with AMO and VB
In this article we will use VB.NET to connect to our Mining Models.
Data Mining Part 28: Programming with AMO and VB
In this article we will use VB.NET to connect to our Mining Models.
The Importance of Database Indexing
In this article, James Munro demonstrates an example of a simple query without an index and then that same query again with the index. A simple introduction to database indexing.
What Not To Say
Steve Jones has some advice for data professionals today. These are a few things that your boss doesn't want to hear, and you probably don't want to say.
Query Folding in Power Query to Improve Performance
In this tip Koen Verbeeck discusses query folding, how you can take advantage from it and how to make sure query folding takes place.
Finding Production Drift
The changes made to production can be problematic at times. Steve Jones notes we can't prevent them, but we can look for them.
Cybercrime - the Dark Edges of the Internet
Criminal activity is a growing menace on the internet: This inevitably means more diligence is required by legitimate users in the face of an increasingly sophisticated criminal threat. Robert Sheldon describes some of the emerging threats and risks.
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...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
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