Quickstart: Connect SQL Server machines to Azure Arc
Get started with Azure Arc-enabled SQL Server to manage and govern your Windows and Linux SQL Server instances hosted across on-premises, edge, and multicloud environments.
2023-09-06
Additional Articles
How To Use Flyway for Database Migration in Spring Boot
In this article, we're going to look at how we can use Flyway to manage our SQL database schema in a Spring Boot application.
2023-09-04
479 reads
Running Queries Across Many SQL Server Databases
A challenge that reappears periodically in the world of databases (especially database management) is the need to run code on a subset of databases and to do so in a nuanced manner.
2023-09-04
Setting up Drill Through in the New Power BI Report User Interface
In this article, learn how to implement drill-through in Power BI reports using the new user interface.
2023-09-01
Working around schema drift in SQL Server
At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical schema. (By “schema,” I mostly mean the set of tables within a database.) I sometimes need to retrieve or update data across a large number of sites. Let’s say, pulling or removing information from the Users table, and related tables, across all of our databases.
2023-09-01
Let’s talk about Artificial Intelligence, ChatGPT and Gobbledegook
I use Chat-GPT occasionally, instead of Google, to get answers to technical questions. However, I regard Chat-GPT as an indiscriminate conveyor of existing information, not artificial intelligence.
2023-08-30
10 reasons to choose Flyway
Thousands of organizations use DevOps practices every day to deliver application changes. But what about the database? Excluding the database from your DevOps pipeline and processes risks application performance, data security and integrity. With Flyway, Redgate solves this challenge in one complete solution that sits inside your existing DevOps platform and processes. Find out the 10 reasons why organizations worldwide choose Flyway.
2023-08-28
Different Ways to Format Currency Output in SQL
In this tutorial, we will show different ways to output different currency formats with the T-SQL language.
2023-08-28
Managing the challenge of migrating to the cloud
Migrating to the cloud has many advantages … until you’re the one tasked with making it happen. For many data professionals, this will be a first step from the traditional, predictable challenges of managing on-premises servers to the many and varied databases and platforms in the cloud.
2023-08-25
Screen Scraping with Python and BeautifulSoup Code Examples
BeautifulSoup (sometimes referred to as Beautiful Soup library) is one of several widely used screen scraping packages for a web page. It is highly regarded for its ease of use and power.
Screen scraping enables developers to create solutions that permit comparative analyses from all over the internet, such as web applications that look for the best price on an item from many different online stores.
2023-08-25
Blogs
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers