Did you miss the excellent presentations from DevOps experts Pramod Sadalage, Kellyn Pot’Vin Gorman, Samir Behara, and Kendra Little? Good news – all Redgate Summit sessions are available on-demand now. Choose from ‘the future of database DevOps’ keynote, latest DevOps trends, Q&A discussion, and demos.
Power BI has a new feature which is the Power BI Small Multiples visual. In this article we cover how to enable this feature and also walk through an example of how to use this in a Power BI report.
There are many amazing candidates in IT, but how many can give an amazing interview. I feel I can't, can you?
In this article our objective is to showcase how to leverage Azure Data Factory (ADF) and a custom script to upload data in Azure MySQL database when we have CSV files with different schemas. As there is no straightforward way to upload data directly using ADF for this given scenario, it will actually help to […]
Since its initial release in 1989, SQL Server has come a long way from its base functionality as an enterprise level database platform. While the core of SQL Server is still it's database engine, it is now so much more than just a relational database plat
Following on from our introduction to U-SQL, we take a look at how a typical U-SQL statement is constructed.
Today we have a guest editorial as Steve is traveling. Ben Kubicek notes that sometimes it is hard for technical people to communicate well.
Learn how to create a customizable calendar date table that can be used for Power BI reports using Power Query.
There is no shortage of PowerShell editors and environments for developing and running scripts. Greg Moore explains some of his favorites.
Today Steve notes that Dynamic SQL can be helpful, but it's a technique you should understand well before you start using it.
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Comments posted to this topic are about the item Creating JSON III
Comments posted to this topic are about the item Testing is Becoming More Important
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers