Create a Table in Microsoft SQL Server
Learn how to create a table in SQL Server using T-SQL along with several different examples that build upon each other to create the final table.
DBA to Data Engineer
A title change can come with a salary bump in some cases, but you might need to work to achieve both of those. Steve has a few ideas today.
Getting More Information From the String or Binary Data Truncated Error
Get more information from the string or binary data truncated message to help troubleshoot data problems on SQL Server 2016, 2017, and 2019.
Introduction to Testing a Flyway Development
How to use Flyway Teams to run basic tests whenever it successfully executes a migration, checking that all the business processes supported by our database always produce the expected results.
Power BI Dynamic X and Y Axis Using Groupings in Field Parameters
In this step-by-step article, learn how to dynamically select what displays on the X or Y axis of a Power BI chart.
How to Visualize Python Charts in Power BI
This article will show how you can code in Python and produce a chart for Power BI.
Reducing Debt and Increasing Security
DevOps is often thought of as bringing more features to customers, but it can also help security.
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.
Re-baselining a Database using Flyway Desktop
Over time, Flyway projects can accumulate a lot of migration scripts, with many database objects being created, altered, and dropped across many files. Tonie Huizer explains why you might want to create a new baseline migration file to create the latest version of a Flyway-managed database in a single leap, and how to persuade Flyway Desktop to do it.
SQL Standard Confusion
The whole universe, the well-guarded people—may they all query databases together in a single language!
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
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