Batch Processing using Flyway
How to create a batch file that executes any number of database migration tasks across a range of servers and databases, using Flyway.
How to create a batch file that executes any number of database migration tasks across a range of servers and databases, using Flyway.
In this article we walk through an example of using Power Query to transform source data that can be used in a Power BI report.
Introduction This article will help you install the Docker Desktop for Mac. Before we show that, let us start by understanding what the Docker Desktop software can do for you. To understand Docker, we need to understand what a container is. If you remember a few years ago, the only way of deploying application code […]
In this article we look at the steps to recover a deleted TDE key that is being used by Azure SQL Database for database encryption.
In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.
Using data scraped from the web might be convenient, but is it legal. Perhaps more importantly, is it moral? Steve has a few thoughts.
Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, such as finding its longest path, or diameter. Recall that a tree is an undirected graph where unique paths exist between any two nodes (i.e. vertices). Any node may be selected as its top node, with its […]
In this article we look at using Window Functions in SQL Server, Oracle and PostgreSQL to see the differences and similarities of the syntax.
The 2021 State of Database Monitoring survey is now open, and we want to know how you’re currently tackling your server, instance, and database monitoring. By taking part, you’ll contribute to the sole industry-wide report on database monitoring, and provide insights into how SQL Server professionals manage their estates and what challenges they face. Plus, you’ll receive an advanced copy of the report and entry to a prize draw to win a $500 Amazon voucher.
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers