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

SQL Server Maintenance Plans

By

If you’re a DBA, sysadmin, IT manager, or Accidental DBA, you’ve probably seen SQL...

SQL Server 2025: Not Just a Database; A Data Engine Reimagined

By

Let us be honest; most database upgrades feel like a patchwork of performance tweaks...

From AI to JSON: What’s New in SQL Server 2025 Data Types (With Scripts)

By

🚀 Introduction SQL Server 2025 is a landmark release that redefines how developers and...

Read the latest Blogs

Forums

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...

MongoDB and Python in action

By sabyda

Comments posted to this topic are about the item MongoDB and Python in action

A Little Appreciation

By Grant Fritchey

Comments posted to this topic are about the item A Little Appreciation

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