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
2021-04-01
8,469 reads
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
A short look at temporal tables and how to deal with the system generated historical tables.
2021-03-29
3,454 reads
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 Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
Hi everyone I have a 1000 line SQL query that is too long to...
hi, now and then i want one connection in my ssis pkgs to use...
Comments posted to this topic are about the item AlwaysON health check alerts