Accessing Applications via Service (2)
Accessing Cluster Applications via NodePort Service
When internal access to a application isn't sufficiant and external access is required, a NodePort Service can be used. This service type exposes the application using a static port on each node’s IP. From outside the cluster, the service can be accessed via <NodeIP>:<NodePort>.
He ...
Posted on Wed, 23 Sep 2026 16:11:00 +0000 by bloodgoat
Optimizing Bulk Data Ingestion into SQL Server
When loading large volumes of data—such as 1 million+ rows—into SQL Server, naive row-by-row INSERT statements quickly become a performance bottleneck. This article demonstrates efficient alternatives using BULK INSERT, parameterized batch operations, and file-based staging strategies.
Database Setup
The test environment uses a dedicated databa ...
Posted on Mon, 21 Sep 2026 16:10:54 +0000 by msaz87
Deleting Rows from jExcel and Synchronizing with SQL Server
if (confirm("Are you sure you want to delete this record?")) {
$.ajax({
url: "DataHandler.ashx",
type: "POST",
data: {
action: "removeRecord",
id: recordId
},
dataType: "json",
success: function(response) {
/ ...
Posted on Fri, 14 Aug 2026 16:19:48 +0000 by nariman
Deadlock in High-Concurrency Scenario: Missing Index on Lookup Column
A stored procedure designed to generate sequential identifiers encountered deadlocks under concurrent load.
CREATE PROCEDURE [dbo].[GetNextSequence]
@sequenceKey varchar(50),
@result int OUTPUT
AS
BEGIN
BEGIN TRY
BEGIN TRANSACTION
SELECT @result = CurrentVal
FROM sequence_table WITH (XLOCK, ROWLOCK) ...
Posted on Thu, 06 Aug 2026 16:29:09 +0000 by Kyrst
Managing SQL Server Databases and Tables
Data Types
Various data types serve specific purposes within SQL Server. Each type has defined ranges and applications for optimal use.
Server Configuration
Server Properties via SERVERPROPERTY
Retrieve server information using the SERVERPROPERTY function:
SELECT CONVERT(sysname, SERVERPROPERTY('servername'));
System Views for Server Details
Q ...
Posted on Mon, 18 May 2026 11:42:14 +0000 by ManicMax