The payback of DevOps is not simply in automation but in using that automation to increase the visibility of the development processes. This article demonstrates way to make Flyway developments more visible, regardless of your RDBMS, such as by providing a detailed migration history, and change reports that reveal detail of what is going on to all involved.
You can automate Power BI table refreshes using PowerShell, an Automation Account, and Runbook. Dennes Torres explains how in this article.
In this article, we will see 3 SSIS design patterns that we can use to set up SSIS configurations and deployments.
Project Zero from Google aims to study zero day vulnerabilities. Steve hopes it leads to better security.
Continuing with his look at Dynamic Data Masking, Steve Jones looks at the masking patterns available besides the default mask.
My FlywayTeamwork PowerShell framework is designed to help get you started quickly with developing databases, using Flyway versioned migrations. It introduces a PowerShell task library, and automation, to take care of repetitive chores. It will also help you get to grips with the practicalities of using Flyway in team-based development. This article explains the basics of its design and provides a demo how to use Flyway to migrate a PostgreSQL database, while generating a high-level narrative of the changes made between versions.
MySQL stored procedures are objects containing one or more SQL statements for reuse. They often contain business logic. Robert Sheldon demonstrates how to create and call stored procedures.
This article shows how we can create tables in Power BI using code and DAX functions.
Clustering data gives quick insights into large unstructured data. In this article, Naveed Janvekar explains clustering and provides a quick demo.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
CSTelpon : 0853-73737551 Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5, RT.11/RW.5, Ancol,...
CSTelpon : 0853-73737551 Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar., Kec. Cilincing,...
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers