Securing the Data Layer: Why SQL Developers Should Care About App-Level Vulnerabilities
Meta Description: App-level vulnerabilities can co...
2025-08-15 (first published: 2025-06-12)
90 reads
Articles
Common SQL Server Problems: Network Related or Instance Specific Error Occurred
This is the first in a series of articles meant to provide practical solutions to common issues. In this post, we’ll talk about one of the most pervasive error messages out there:
2025-08-15
Enable TDE for Databases in a SQL Server AlwaysOn Availability Group
A customer has a database that is already set up in a SQL Server Availability Group. Since this database hosts sensitive data, there is a need to encrypt the primary and all secondary replicas of the data. In this article, we will walk through how this can be done.
2025-08-13
Best Way to Repair SQL Database: How to Restore SQL Server?
Summary: SQL Server administrators frequently enco...
2025-07-30
1,054 reads
2025-07-30
1,821 reads
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
When a SQL Server Express-based factory app started crawling, the culprit wasn’t hardware or network — it was a decades-old WHILE loop migrated from C/C++ to SQL. This real-world story breaks down how procedural habits, memory grants, and lack of window functions nearly derailed a production floor.
2025-07-28
14,502 reads
2025-07-28
11,433 reads
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 […]
2025-07-24
1,332 reads
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 […]
2025-07-24
1,485 reads
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 content platforms, the backend data architecture becomes critical for efficient moderation workflows. Database Design Challenges for Content Moderation Services Performance at […]
2025-07-23
567 reads
Blogs
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Forums
BCA KCU PURI INDAH | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blok 02, RT.3/RW.2,...
BCA KCU SOLO BARU | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Kawasan Terpadu The Park, Jl. Ir. Soekarno, Solo Baru, Madegondo, Kec. Grogol, Kabupaten...
Fuzzy String Matching in SQL Server 2025
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers