This is Why You Use Git for Scripts
Git is a good tool for DBAs and other Operations staff. Today Steve gives you a few reasons why.
Scientific Calculations in Power BI - Cube, Square, Logarithms, Powers, Inverse and more
Microsoft Power BI Desktop provides users with multiple ways to help shape and transform their data. One of the options users have is scientific calculations, which support operations like cube, square, logarithms, etc. Power BI has this option in the Power Query Editor mode, where the user can easily apply one of these transformations for any number-based columns. In this tip, we will overview this utility in Power BI and how to benefit from it.
Un-Stable Teams
At Redgate, the teams change every year and Steve has a few reasons why this is good.
Writing SQL Server code with AI using GitHub Copilot
Introduction In this article, we will see how to work with GitHub Copilot. GitHub copilot is an interesting plug-in that generates code using AI. The technology is from Microsoft and OpenAI. We will show how to install Copilot, and how to generate SQL Server code (T-SQL) using Copilot. First, we will answer some FAQs about Copilot […]
Planning a Database Testing Strategy for Flyway
With Flyway, you can adopt a test-driven development strategy that will allow you to test and evaluate databases, and database objects, at every phase of the database development lifecycle. The further down the delivery pipeline that bugs appear, the more costly in time and resources they are to fix. This approach will allow you to catch many of them before the database change even gets committed to version control, making a continuous delivery process much easier to adopt and sustain.
The Birth of Computing Was the Birth of Testing
Last year I had the most wonderful opportunity. I took part in Data Relay, an event in the UK which tours several cities. Wonderful time, but not the focus here. The very first one was held at the National Museum of Computing at Bletchley Park. Without a doubt, you've heard of Alan Turing, Enigma, and […]
Do You Have a Jeff?
Today Steve wonders if you have a go-to person at work or maybe if you are that person. Or if that is even a good thing in a company. It might be better if there were more tools available to help others.
Leveraging AI Tools for SQL Queries
This article covers the basics of how different AI tools can be used to write SQL.
Use a Table Variable for Logging Entries that Need to Survive Rollbacks.
This article shows how a table variable can be used to capture error information and log it when your code doesn't work as expected.
Fun with Powershell
Have you ever been in a situation that you want to call a cmdlet or a function with a parameter that depends on a conditional criteria that is available as a list? In this article I will show a technique where you can use PowerShell Dynamic Parameters to assist the user with parameter values.
Blogs
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Forums
When trying to use a LocalDB, I get an error
I tried to find an appropriate forum to post the question. This one seems...
Resolving Access Denied Errors During SQL Server Database Attachment
Comments posted to this topic are about the item Resolving Access Denied Errors During...
The Lesser Used Functions
Comments posted to this topic are about the item The Lesser Used Functions
Question of the Day
SQL in an Azure VM Backup
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