Power Query Editor in Power BI for Formatting Text Columns
This article looks at ways to clean up text data used in Power BI reports and charts for a more meaningful and consistent message.
The Justification Database
Having a good process for managing security is important, but how many of us enforce that?
How We Ate Our Own Dog Food To Level-Up Internal Testing with Redgate Clone
Most applications have large and complex databases at the back end, making it hard for developers to adequately test their work before it goes out. Having a fast, repeatable process to deliver data on demand is an essential part of an effective software development lifecycle, ultimately leading to improved customer satisfaction. In this article, we’ll explore the journey our own engineering team went on to leverage our own tool, Redgate Clone, to spin up short-lived database instances in containers for automated testing.
Top 10 Methods to Improve ETL Performance Using SSIS
Extraction Transformation Load (ETL) is the backbone for any data warehouse. In the data warehouse world data is managed by the ETL process, which consists of three processes, Extraction-Pull/Acquire data from sources, Transformation-change data in the required format and Load-push data to the destination generally into a data warehouse or a data mart.
Bad Culture Bad Security
Another company has hard-coded credentials, which Steve feels are a sign of bad culture.
Transform your Winning team into a Champion Team
Businesses worldwide now operate on a team basis, and a high-performing team is crucial for high-performing organizations. Winning teams are more focused and better than regular teams. They focus on synergies and achieving significant results. They are an extension of regular teams with a higher sense of commitment to objectives and mutual purpose. Winning teams have a clear mission and achievable performance goals for each member, aiming for extraordinary goals. They are more committed to the vision and have a passion for achieving the mission. Winning teams work collaboratively to discover new work approaches, principles, and practices, focusing on decision-making, creative problem-solving, industry standards, and effective communication. They establish processes from beginning to end to complete tasks effectively. The difference between winning team and a regular team is very clear. However, what makes a winning team a champion team. This paper aims to provide valuable insights into the differentiating factors of a champion team from a winning one.
The promise – and the perils – of GitHub Copilot
There’s been a lot of talk about GitHub Copilot recently, loudly touted as Your AI pair programmer. According to GitHub, Copilot for Business brings the power of generative AI to engineering teams, accelerating the speed of software development and innovation.
Understanding Locking, Data Modification and Committing Data in SQL Server
Learn about how SQL Server uses locks when modifying data and how data is committed to a database after data changes.
Celebrate THEIR Accomplishments
I can't hide this in any way. I love it when I accomplish something. It's such a great feeling. Even more than that, I really do love getting some acknowledgement for it. Almost as good, is when I see others, especially friends and acquaintances, doing well. So many people I know, regularly just knock it […]
Declining Work for Mental Health
A busy year got a little too busy for Steve and he is taking steps to improve his work life balance.
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers