Unlike an on premises SQL Server, Integration Services (SSIS) works very differently on Azure. If there are requirements to run our existing SSIS packages on Azure, then we need to understand our options. In this article we will talk about our options for migrating SSIS to Azure and what components are required to migrate SSIS packages. […]
Describing the two main use cases for occasional "cherry picking" of Flyway database migration scripts: back-filling emergency production hotfixes to version control and managing parallel development streams.
In this article we look at how you can user the Kusto Query Language (KQL) for querying Azure SQL Database audit data.
Git has proved to be a better fit to the needs and workflow of a database development team than anything that came before. Git is valuable because it encourages branching and merging, giving more choice in the way that your team can work. Due to the ease with which you can adapt Git, there is […]
Steve Jones wonders how many of us have had to send, or will have to send this email.
One common request often seen in T-SQL is working with queues of information. In this piece, J. Drew Allen will show to use windowing functions and the OVER clause to process a FIFO queue.
During development you need a fast, automated way to build multiple copies of a database on any development or test server, with each database at the right version. This article provides a PowerShell automation script for Flyway that will do the job.
In this article we explore four simple time series forecasting methods using R: the Mean Method, the Naive Method, the Seasonal Naive method and the Simple Moving Average Method.
Steve is excited that SQL Server is moving to a new platform.
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