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.

Working with MySQL Stored Procedures

by Additional Articles

SimpleTalk

MySQL

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.

Creating Tables in Power BI

by Daniel Calbimonte

SQLServerCentral

Power BI

This article shows how we can create tables in Power BI using code and DAX functions.

Testing or Learning

by Steve Jones

SQLServerCentral

Career Growth

How do you approach challenges in life? As a test or a learning opportunity?

Clustering data for insights

by Additional Articles

SimpleTalk

Data Science

Clustering data gives quick insights into large unstructured data. In this article, Naveed Janvekar explains clustering and provides a quick demo.

Creating Flyway Migration Files using Redgate Schema Comparison Tools

by Additional Articles

Redgate

Vendors/3rd-party Products

How to use Redgate's schema comparison engines to generate object-level scripts for every database version that Flyway creates, and then use them to create ad-hoc, Flyway-compatible migration files.

What will convince you to upgrade?

by Kathi Kellenberger

SQLServerCentral

Database Weekly

You’ve probably heard that SQL Server 2022 is on the way, and, assuming the name doesn’t change, it will be later this year. That is great news for folks in the data platform community as features and improvements they’ve been hoping for are added. I’m not currently supporting any production SQL Servers, but I’m still […]

Azure Data Studio and Version Control

by Steve Jones

SQLServerCentral

This article examines how you can use Azure Data Studio with your git Version Control System.

Gathering Data Through Life

by Steve Jones

SQLServerCentral

data
Misc

Every once in a while, I find a list of places posted on the Internet with a "how many have you visited?" question attached. This might be US states, countries, cities, or even attractions. I love traveling with my wife and having new experiences, and as we've gotten older, we value the experiences more than […]

Finding deeper insights with Topic Modeling

by Additional Articles

SimpleTalk

Topic modeling can be used to find more detailed insights into text than a word cloud can provide. Sanil Mhatre walks you through an example using Python.

What is the Flyway Teamwork Framework?

Working with MySQL Stored Procedures

Creating Tables in Power BI

Testing or Learning

Clustering data for insights

Creating Flyway Migration Files using Redgate Schema Comparison Tools

What will convince you to upgrade?

Azure Data Studio and Version Control

Gathering Data Through Life

Finding deeper insights with Topic Modeling

Blogs

A New Word: Gnossienne

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

Learning Tool – Deepstash

Forums

When the Token Meter is Zero

Understanding Temp Tables and Table Variables in SQL Server

The Data API Builder MCP Server Tools

Question of the Day

The Data API Builder MCP Server Tools