How to visualize Python charts in Power BI part 3
In Part 3, we look at how to use Python to create more charts for Power BI.
Guide to Build Graph Node and Edge Tables with Azure Data Studio
Learn how to build graph node and edge tables using Azure Data Studio in this step-by-step guide.
The Lock Escalation Threshold – Part 1
This article isn’t about the act of lock escalation itself, which is already well documented and generally well understood. Some myths (like row locks escalating to page locks) persist, but challenging those yet again probably wouldn’t change much.
Who Are You?
I was sitting here thinking about the editorial when Kathi Kellenberger came to mind. She would frequently write about her favorite show, Star Trek. I too have been a fan of Star Trek since I was very young. However, my favorite show is a little more obscure and not as many people have seen it, […]
How to Use PowerShell to Set Secure SA Passwords in Bulk
Learn how you can bulk set passwords using PowerShell for all your instances.
Paying It Forward on the Internet
Helping others has been good for Steve's career and he encourages you to do it as well.
Managing Static Data in Flyway Database Development
If your database application requires 'static data' to function, then the best way to manage that data is using a view based on a derived table. This article demonstrates ways to create these views, depending on your RDBMS's capabilities, and how to build and manage them in development work, using Flyway and PowerShell.
SQL WHERE Tutorial
In this article, we look at several different examples of how to use the SQL WHERE clause to narrow down searches for data in a SQL Server table.
To Which Experts Should You Listen?
Many experts that speak to at events are working for vendors. Steve notes that this might mean they are making sales pitches, not not always.
How to Create a SQL Server Database, Tables, Foreign Keys and Data for an Application
Learn how to create SQL Server database tables, foreign keys, and create data to begin building a database to support application development.
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers