Containers are being used by more and more organizations to automate build pipelines in their CICD processes. In this article, Mahendran Purushothaman shows how to automate the creation of Docker containers and a Kubernetes cluster in Azure.
2020-09-29
Introduction to PostgreSQL PostgreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language. Though originally designed to run on UNIX platforms, PostgreSQL is eligible to run on various platforms such as Linux, macOS, Solaris, and Windows. PostgreSQL databases provide enterprise-class database solutions and are used by […]
2020-09-28
6,522 reads
In my last post, I talked about how you can get 43%-67% faster backups. This time, I’m using that same SQL Server setup to discuss how throwing more CPU cores might help you check for corruption faster if you’ve already got modern fast storage.
2020-09-28
When database development is described, the details often get vague when the data gets beyond spreadsheet-size. There is 'hand-waving' talk of providing databases for each developer, but little detail of how you would provision all the databases that would be needed, at the correct version and with the correct development data, and then keep them all in sync with the source code, as developers commit changes. This article explains the requirements, and how SQL Clone can meet them.
2020-09-28
Grouping Sets are an effective way to add subtotals to aggregated queries. T His article explains how.
2020-09-25 (first published: 2018-09-06)
11,190 reads
How can you use GitHub to do team-based database development? This article proposes a process that splits development work into task-based GitHub branches, incorporates daily database builds and integration testing, and using Redgate tools to automate tasks such as provisioning, database scripting, and testing.
2020-09-25
Sometimes there is a need to find if a string value exists in any column in your table. This script will help you find all occurrences in all columns in the table.
2020-09-25
Introduction In my last article, Loading data in Azure Synapse Analytics using Azure Data Factory, I discussed the step-by-step process for loading data from an Azure storage account to Azure Synapse SQL through Azure Data Factory (ADF). ADF basics are covered in that article. In this article I will go through the process for the incremental […]
2020-09-24
44,498 reads
All queries run fast against columnstore indexes, right? In this article, Edward Pollack demonstrates some query patterns that don’t perform well and how to get around the issues.
2020-09-24
With insights from a recent Gartner report, Redgate’s Jamie Wallis looks at the benefits of tracking, and acting on, key metrics early in the DevOps process and how they can apply equally to database monitoring. Read more.
2020-09-24
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
I tried to find an appropriate forum to post the question. This one seems...
Comments posted to this topic are about the item Resolving Access Denied Errors During...
Comments posted to this topic are about the item The Lesser Used Functions
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers