How to Increase SQL Server Column Width Without IO (Input/Output) Overhead
One of the most hassle-prone changes that can be made in a SQL Server database is to widen an existing column. Depending on the column’s use and data type, this process may involve hundreds of schema changes, app downtime, and a mountain of risk-prone …
How to optimize queries using AI (SQL Expert)
Introduction ChatGPT can help you with your queries. However, some customized GPTs inside ChatGPT can be useful for your job. This time, we will teach the SQL Expert (QueryGPT). It is a specialized GPT created by a third-party developer within ChatGPT. …
How to Measure Replication Latency in SQL Server AlwaysOn Synchronous Availability Groups
Synchronous replicas in SQL Server Availability Groups promise no data loss, but they don’t promise zero delay; under heavy load they can still fall behind. This article shows how to measure and track that hidden replication delay using SQL Server perf …
[Video] Building a Brand By Sharing Your Work
You’ve got a good job, and some spare time. You’re thinking about giving back to the community by blogging, presenting, live streaming, or working on Github projects – and you’d like to make your next job search easier. Let’s talk about it. I apologize …
Connecting to PostgreSQL with Node.js
Overview In this article, we will understand how we can connect to PostgreSQL using Node.js application. We will start with setting up PostgreSQL in our local system and perform basic CRUD operations to interact with the PostgreSQL database. Prerequisi …
Taming Resource Hogs: Using SQL Server Resource Governor to Restrict User Group Consumption
Taming Resource Hogs: Using SQL Server Resource Governor to Restrict User Group Consumption As a SQL Server professional, I’ve often encountered situations where a single, poorly written query or a resource-intensive application threatened to cripple t …
Monitor SQL Server using Zabbix
Zabbix is an open-source monitoring software, like Paessler PRTG, which can monitor SQL Server performance statistics and status. Although it doesn’t replace DBA functions, it is useful to provide evidence when things start to fail. Among its features …
Poll: Can Your DBAs Read the Data?
It’s a simple question: can your database administrators read all of the data in all databases? Yes Yes, but we trust them not to – as in, we’ve got written policies in place, and they know they’re not supposed to go poking around in the payroll tables …
How to use pgAdmin with Azure Database for PostgreSQL flexible server
Multiple tools are available for working with Azure Database for PostgreSQL flexible server. One of these is the psql command-line utility, which I introduced you to in the previous article in this series. Another valuable tool is pgAdmin, a much more …
Database Architecture Considerations for Implementing Content Moderation Services
Fellow SQL Server professionals, I wanted to share some insights and start a discussion about the database design challenges we face when implementing Content Moderation Services in enterprise applications. As more organizations build user-generated co …
Migrate from Linux to Windows with Availability Groups
We have an SQL Server 2019 server running on Linux Ubuntu, and we want to migrate to Windows for its user-friendliness, software and hardware compatibility, and readily supportiveness. To do that, we’re going to use a read-scale cross-platform Availabi …
Want Me to Train You & Your Coworkers Privately?
Your company doesn’t want to send you off to conferences or training classes in other cities. You’ve looked around locally, but the local options seem to be irrelevant to your needs. It’s generic stuff like how to pass certification classes, or boot ca …
Unlocking Interoperability: A Guide to Foreign Data Wrappers in PostgreSQL and Aurora PostgreSQL AWS RDS
Unlocking Interoperability: A Guide to Foreign Data Wrappers in PostgreSQL and Aurora PostgreSQL AWS RDS As a database professional, I often encounter scenarios where data is fragmented across various systems. In today’s distributed IT landscape, it’s …
Microsoft Fabric Has a New Service Status Page.
I’ve been pretty vocal here on the blog and on social media about the reliability problems with Microsoft Fabric. Today, I’ve got good news: Microsoft released a new Fabric status page and a known issues page, something that really does take guts given …
How to Use the New PRODUCT() Function in SQL Server 2025
With each version of SQL Server, there are always a few new features introduced that we applaud as we finally have access to a useful function that is already available elsewhere. Introduced in SQL Server 2025 CTP 1.3, the PRODUCT() function acts simil …