In the first two articles in this series on creating DAX formulae, Andy Brown of Wise Owl Training showed how to create calculated columns and measures. In this third article, he turns his attention to two of the most important DAX functions (CALCULATE and VALUES), showing how and when to use them. If DAX knowledge can be compared to a heavily fortified castle, the CALCULATE function is the drawbridge giving access to it.
Using R with Power BI, SSRS or RTVS for easier data visualization
Kendra Little explains why Redgate would like to hear your stories of how the database has been left behind.
Google was recently fined for GDPR violations. Steve wonders if their confusing documentation and tools are the problem.
Years ago, my first go-to tool for performance tuning was Performance Monitor: it was available everywhere, worked in all versions, and gave me a lot of useful information without paying for a monitoring tool. Since then, I’ve moved on – wait stats are a much better starting point – but there are still 3 good Perfmon counters that I rely on.
Backblaze releases their new hard drive stats and there are some interesting items in the report.
Although computed columns are from the beginning of SQL Server, not everyone knows how to use them. This article will help you better understand how it works.
In this tip we look at some things you should think about when planning for a SQL Server data warehouse.
By Steve Jones
If you aren’t watching the Ignite keynotes today, then you might have missed the...
Short version You want to get this running as fast as possible. Do these...
By Steve Jones
Last week I asked you to write about SQL Server 2025 and what things...
Comments posted to this topic are about the item SQL Server 2025 has arrived!
Comments posted to this topic are about the item Don't Create Workslop
Comments posted to this topic are about the item What is the original database...
What is returned when this code is run?
SELECT ORIGINAL_DB_NAME()See possible answers