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.
2021-04-05
In this article we look at how you can user the Kusto Query Language (KQL) for querying Azure SQL Database audit data.
2021-04-05
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.
2021-04-02
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.
2021-04-02
In this article we discuss deploying SQL Server containers / images using Azure Kubernetes Cluster.
2021-04-01
How to send Flyway logging and error output to JSON and consume it in PowerShell to produce ad-hoc database migrations reports, including any errors that occurred, the version of the database, runtimes for each migration script and more.
2021-04-01
In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before computers.
2021-03-31
You need a fast, general-purpose way to save the results of a query or batch or procedure into any sort of worktable, such as a temporary table or a table variable or table valued parameter. A simple SELECT…INTO isn't versatile enough for these requirements, and the alternative ways to handcraft the list of columns are slow and error prone. Phil Factor shows how to create a 'table-build generator' that will do all this, and save you a lot of time, especially if you use a lot of working tables in your code.
2021-03-30
Learn how to manage and troubleshoot Kerberos authentication for SQL Server using the Kerberos Configuration Manager.
2021-03-30
Learn how to configure and use SQL Server Management Studio to do run the same query against many different SQL Servers and consolidate the results.
2021-03-29
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
By Chris Yates
I get asked a lot about why or how I began working with databases...
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Comments posted to this topic are about the item Implementing PostgreSQL with Python for...
Comments posted to this topic are about the item Identify a Slipstream Installation
Comments posted to this topic are about the item Internal Staff Growth, which is...
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers