This happened to me recently after being busy with non-data modeling tasks for a few weeks. I went to add a relationship and was confused about the behavior. Read...
2026-05-18 (first published: 2026-05-04)
182 reads
Last week I was honored with a trip to Rome for the Redgate President’s Club. I was awarded this, along with our top people in Sales, for the work...
2026-05-18
75 reads
Every major model out there can summarise documents, write code and answer multi step questions – then if you decide to go with a specific vendor based on costs...
2026-05-18 (first published: 2026-05-04)
911 reads
“On the way to a grand goal, celebrate the smallest victories as if each one were the final goal. That way, no matter where it ends, you are victorious.”...
2026-05-15 (first published: 2026-05-01)
147 reads
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying the most expensive queries is crucial to optimize resource usage and improve overall system efficiency.
Step-by-Step...
2026-05-15 (first published: 2026-04-28)
95 reads
If you are considering any of the ISACA AI certs like the Advanced Artificial Intelligence Audit (AAIA) or the newly release Advanced Artificial Intelligence Risk (AAIR), ISACA will be...
2026-05-14
94 reads
In previous posts, we looked at the SQL Server engine. for us DBAs, the SSMS plays an important role for handling/Managing SQL Server. we have been using these tools...
2026-05-14 (first published: 2026-05-13)
25 reads
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion architecture declaratively, but once you have a pipeline of MLVs in production, you need visibility...
2026-05-13 (first published: 2026-04-30)
129 reads
If you’ve been here before, you know this blog is usually about SQL Server, PowerShell, and the day-to-day work of being a DBA. Execution plans, availability groups, dbatools scripts...
2026-05-13 (first published: 2026-04-28)
441 reads
This month we have a new host, Meagan Longoria, who graciously agreed to help me this month. I’ve known Meagan for a number of years and she’s been a...
2026-05-12
25 reads
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Comments posted to this topic are about the item Displaying Money
Comments posted to this topic are about the item The Slow Growing Problems
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers