Looking Back
Today Steve talks about retrospectives and how we learn and grow as software professionals.
Capturing SQL Server Deadlocks using Extended Events
In this tip we look at how to capture deadlocks that occur in SQL Server and the associated information to help troubleshoot. We look at how to do this using the GUI and T-SQL code.
Running Unit and Integration Tests during Flyway Migrations
In this article I'll give a practical example of developing a database, with Flyway, in such a way that it is automatically tested with whatever unit tests and integration tests you specify whenever you migrate the branch you're working on to the next version. If a test fails, you can work out why, undo the migration and then try again.
Tips to improve Power BI report appeal
This article will show you how to use a Powerpoint theme to modify and beautify a Power BI report.
When Is Technology Good Enough?
Technology advances, sometimes beyond what we need sometimes. Steve asks when things are good enough.
Database DevOps: Standardize, Automate, Monitor & Protect
See how our end-to-end framework for extending DevOps to your database enables your organization to balance the demand to deliver software fast with the need to protect and preserve business critical data.
Metrics that matter for IT organizations on an agile journey
Measuring the wrong things is worse than not measuring anything. In this article, Mallika Gunturu explains the right things to measure for agile.
The Case for Patching
Recently I was testing a feature in SQL Server on 2017 and 2019. There was supposed to be an improvement across versions, but I didn't see it. Then I realized that I was on SQL Server 2019 CU 2 on my laptop, and the current CU is 17. I took a few minutes to download […]
How Hard is Kubernetes?
Mercedes has taken advantage of containers and Kubernetes to build knowledge in their staff. This investment helps them adapt and change their technology to meet the needs of the business.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
Question of the Day
Displaying Money
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