Using Logging with the Delete Activity in Azure Data Factory
This short piece shows how to add logging for the Delete activity and track which files or folders are deleted.
2022-02-04
1,367 reads
Articles
Data lakes take on big data
A data lake is a scalable data storage repository that can ingest large amounts of raw data and make it available on-demand. Robert Sheldon explains the benefits and challenges of data lakes.
2022-02-04
Google Cloud DB DevOps Report: Read Now
The 2021 report from the DevOps Research and Assessment (DORA) team at Google Cloud has now been published and provides highlights from seven years of research and data from more than 32,000 professionals worldwide.
2022-02-04
A Programmer’s Guide to Flyway Configuration
Phil Factor offers a programmer's guide to Flyway's configuration settings, explaining the different categories of parameters, the role of each of parameter within each category, and how to exploit Flyway's multi-level configuration file system.
2022-02-02
Deep SQL Query Optimization with SQL Grease
Learn how to conduct deep SQL Query optimization with SQL Grease with the Enterprise dashboard, historical data, troubleshooting SQL Server Wait Stats, capturing anomalies and intelligent notifications.
2022-02-02
PostgreSQL in Azure Data Studio
Learn how to install PostgreSQL and using Azure Data Studio to work with it.
2022-01-31
7,423 reads
7 Trends in DB DevOps & Monitoring: The infographic
Earlier this year, we surveyed 5,700 global IT professionals and found out what the most pressing issues in DevOps and monitoring were. Read the round up in our infographic.
2022-01-31
Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant
The syntax for creating databases and tables in PostgreSQL is similar to other RDBMS. In this article, Grant Fritchey shows how to create databases and tables.
2022-01-31
Debugging Flyway Callbacks and Migrations that Use Placeholders
Placeholders come in very handy in Flyway, but troubleshooting the SQL migration and callback scripts that use them can be tricky. This articles demonstrates how to develop, test and debug these scripts in a tool designed for these tasks, such as SSMS, leaving Flyway to do what it's designed for, which is running the scripts.
2022-01-28
276 reads
Is Your SSIS Catalog Migration Ready
In this article, we will see if the given SSIS catalog is ready for migration without any issues using SSIS Catalog Migration Wizard inspect feature.
2022-01-28
2,189 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers