SQLServerCentral Editorial

A Little Appreciation

I'd like to take a moment and simply voice my appreciation for Steve Jones. Steve's still on sabbatical, so I've been doing some of the work, along with my co-worker, Kellyn Gorman (who I also appreciate, very much). I'm sure you've noticed. Oh, not simply that the editorials are different. That's to be expected. Nah, […]

SQLServerCentral Editorial

When DBAs Should Consider Using SQL Server to Store Vector Data and If It Makes Sense

As we continue to build more applications using AI embedded solutions, database professionals are increasingly being asked to support workloads that would have seemed outside their charter just a few years ago. One of the most significant shifts has been the rise of vector data (i.e. high-dimensional numerical representations of content like text, images, and […]

SQLServerCentral Article

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. Prerequisites To start with this, we need the following conditions to be met: Windows machine (or any […]

SQLServerCentral Article

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 the entire database server. Performance bottlenecks, unexpected slowdowns, and user complaints become the norm, making your life as a DBA […]

Blogs

Accessing the Kubernetes API from SQL Server 2025

By

The sp_invoke_external_rest_endpoint stored procedure that’s available in 2025 allows for SQL Server to hit...

Empowering Technical Teams: Leading with Vision, Not Micromanagement

By

Let’s be honest; technical teams don’t thrive under a microscope. They thrive under a...

Azure DMS Tutorial: Migrate Databases to Azure with Minimal Downtime

By

Migrating databases to the cloud can be complex, but Azure Database Migration Service (DMS) simplifies the...

Read the latest Blogs

Forums

Trouble Sending Email from Scheduled Job

By homebrew01

I'm a little rusty with SQL, been away a while. I have SQL Mail...

Low Level design for Error Logging for Data Pipeline

By sqlgigs

Hello, May someone please help me how to design Error Logging for the Data...

Best Way to Repair SQL Database: How to Restore SQL Server?

By durrani

Comments posted to this topic are about the item Best Way to Repair SQL...

Visit the forum

Question of the Day

Capacity Planning for an Existing SQL Server Workload?

You're tasked with planning capacity for a new SQL Server database workload. Which of the following is the most accurate way to determine how much CPU, memory, and I/O throughput your workload requires?  What single or multiple tools would you use to answer the questions around resource needs?

See possible answers