SQL Ledger: Protecting Data in Azure SQL
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,708 reads
Uncategorized
Pick a Database, any Database…
All sorts of project and organizational analysis go into selecting the right database system for the requirements....or so you'd think.
2022-08-27
205 reads
2022-08-24
2,275 reads
When Is Technology Good Enough?
Technology advances, sometimes beyond what we need sometimes. Steve asks when things are good enough.
2022-08-22
131 reads
2022-08-17
641 reads
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.
2022-08-17
1,925 reads
Data Flow Formatters - Flatten, Parse and Stringify in Azure Data Factory
This article discusses the data flow formatters, Flatten, Parse, and Stringify, which can be useful when dealing with JSON data.
2022-08-12
17,018 reads
2022-08-10
524 reads
Business Analytics from Application Logs and SQL Server Database using Splunk
Learn how Splunk can be used to get information from application logs or a SQL Server database.
2022-08-08
1,553 reads
How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!)
Here's why you should NEVER use the FORMAT() function in SQL Server.
2022-08-05
21,605 reads
Blogs
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Session Materials for Techorama & DataGrillen 2026
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a...
Forums
Even When You Know What You're Doing, You Can Screw Up
Comments posted to this topic are about the item Even When You Know What...
The New Software Team
Comments posted to this topic are about the item The New Software Team
Database Mail in SQL Server 2022
Comments posted to this topic are about the item Database Mail in SQL Server...
Question of the Day
The string_agg function
We create the following table and then insert some records in it:
create table t1 ( id int primary key, category char(1) not null, product varchar(50) ); insert into t1 values (1, 'A', 'Product 1'), (2, 'A', 'Product 2'), (3, 'A', 'Product 3'), (4, 'B', 'Product 4'), (5, 'B', 'Product 5');What happens if we execute the following query in both Sql Server and PostgreSQL?
select id,
category,
string_agg(product, ';')
over (partition by category order by id
rows between unbounded preceding and unbounded following) as stragg
from t1; See possible answers