How to use Flyway configuration files to minimize typing during ad-hoc development from PowerShell or DOS; you just type in the Flyway commands you need and hit "go" and the config files take care of all the tiresome connection, authentication and project details.
2021-09-17
In this article we will walk through a clear end-to-end process of securely mounting an ADLS gen2 account in Databricks.
2021-09-17
Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in a table using Oracle Text.
2021-09-15
Over 2500 global database professionals answered questions on their experiences with database monitoring in our annual survey earlier this year. We’re creating four reports from the findings and in our first, The real-world challenges of growing server estates, you’ll discover both insights and trends along with advice for how to tackle the most common challenges.
2021-09-13
The SQL Server identity column is used to populate a column with incrementing numbers on insert. In this article, Greg Larsen explains how it works.
2021-09-13
Oracle added several enhancements to the sequence object in version 12c, including an “identity” column feature. Jonathan Lewis explains how to work with these new features.
2021-09-10
Registration is now open for our free and online data platform conference. Join 1000s of your data peers at PASS Data Community Summit and get access to up to 5 days of training, sessions, networking activities, and events. This year's program has been carefully designed to help you achieve your goals, wherever you are in your data career.
2021-09-10 (first published: 2021-09-03)
In this article we look at a PowerShell script that you can use to centrally enable and disable any SQL Server Agent Job on any instance of SQL Server.
2021-09-08
How to create a single set of SQL migration scripts for Flyway that we can use across multiple database systems, or for all regional variants of a database.
2021-09-08
Learn how to plot a financial time series using SQL Server data and Python to reveal the value of exponential moving averages and make decisions about time series values.
2021-09-06
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Comments posted to this topic are about the item Understanding Temp Tables and Table...
Comments posted to this topic are about the item The Data API Builder MCP...
Comments posted to this topic are about the item Collecting Data Is Hard
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers