Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson kicks off a series to introduce the DAX financial functions. In this article, he exposes five functions that are popular in the calculation of loans and other annuities. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.
2020-10-22
Until now, organizations wanting to introduce database DevOps have had to rely on – and purchase – different tools and solutions for different databases. A new cross-platform database DevOps solution, Redgate Deploy, changes the rules. Find out why in this latest blog post.
2020-10-22
Take a look at some of Brent Ozars favourite public presentations, and hear the stories of how they came to be.
2020-10-21
SQL Server synonyms can be used to permanently alias database objects in the same or another database. In this article, Greg Larsen demonstrates how to use synonyms and the many reasons to consider using them.
2020-10-20
As business rules shift and data structures change, organizations need to be able to maintain and update their data catalog. Discover how you can implement an automated solution using PowerShell and Redgate’s SQL Change Automation.
2020-10-19
Learn how to orchestrate your Databricks notebooks through Azure Data Factory in this article with a step by step walkthrough.
2020-10-19
The SQL Server 2016 dynamic data masking feature may seem like a great way to obfuscate data for downstream systems like dev and QA. Joe Obbish shows us that the data can be “unmasked” with T-SQL statements, so it’s not secure against anyone who can write their own queries.
2020-10-16
As business rules shift and data structures change, organizations need to be able to maintain and update their data catalog. Discover how you can implement an automated solution using PowerShell and Redgate’s SQL Change Automation.
2020-10-15
In this article we look at how you can use SSMS to filter objects, debug, drag and drop object names, add custom reports and use of operators for emails.
2020-10-15
Kellyn Pot'Vin-Gorman explains Oracle Automatic Storage Management and why it’s impossible to do a comparison to Azure IaaS.
2020-10-14
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Comments posted to this topic are about the item The Microsoft SQL Year in...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Your Value from a Conference
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers