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.
2022-09-16
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.
2022-09-16
Learn how to create SQL Server database tables, foreign keys, and create data to begin building a database to support application development.
2022-09-14
There and pros and cons to building a monitoring system versus purchasing one: in other words, the ROI of build vs. buy. In this blog post, Grant Fritchey discusses when you should build, and when you should buy.
2022-09-14
This article continues looking at python code in Power BI to produce charts.
2022-09-12
6,040 reads
Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
2022-09-09
4,256 reads
This article covers how to create multi-chart visualizations in Excel using data from SQL Server.
2022-09-09
Rollback scripts are designed to allow us to recover safely from a failed deployment that leaves the database in an indeterminate state. They must check exactly what needs to be reverted before doing so. If you work with an RDBMS that cannot support transaction DDL rollback they are vital. This article proposes a strategy where you create and test a rollback file, at the same time as the forward migration, and reuse it as a Flyway undo script.
2022-09-09
Learn how you can set up and use Ledger tables in an Azure SQL Database to verify the integrity of your database changes.
2022-09-07
9,322 reads
In this tip, we cover how to use the GENERATE_SERIES function to expand a range of dates into rows
2022-09-07
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers