How to create your custom GPT SQL Expert

Introduction ChatGPT includes custom GPTs. You can create your own custom GPT. In this article, we will demonstrate how to create a custom GPT expert in SQL Server. Requirements To create your own GPT, you need to use the paid version of ChatGPT. First, go to ChatGPT. Secondly, if you don’t have the paid version, […]

MongoDB and NodeJS in action

Overview MongoDB is a popular NoSQL database used for building modern, scalable applications. In this article, we’ll cover how to set up MongoDB on Windows and connect to it using Node.js. We will also perform some basic Create, Read, Update, and Delete (CRUD) operations to ensure we understand fully on how Node.js can be made […]

Data recovery from an Index

SQL Server Threats

Is your SQL Server truly secure? Here are the top cyber threats targeting it. Learn how you can stop them before it strikes.

Deprecated but Forgotten: Why SQL Server’s Text, NText, and Image Data Types Still Haunt Your Systems

TEXT, NTEXT, and IMAGE columns have been deprecated for nearly two decades, yet they still silently haunt many SQL Server environments. This article explains their hidden limitations with practical demos and shows why migrating to VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX) is critical for modern performance, maintainability, and future upgrades.

Why CQRS and Event Sourcing Are Gaining Ground in High-Concurrency Web Systems

In web app development company boardrooms, architects and engineers are debating old assumptions. Scaling up isn’t just about faster servers or better caching anymore. It’s about reshaping how systems think. CQRS (Command Query Responsibility Segregation) and Event Sourcing are no longer fringe ideas. They’re becoming default choices in high-concurrency systems where consistency, auditability, and performance […]

Page Compression, Unique Identifiers and Speed

The Double-Edged Sword of AI and Data Democratization

Agentic AI is often hailed as a game-changer by organizations, bringing autonomous decision-making, intelligent automation, and powerful predictive capabilities. However, as organizations rush to leverage these technologies, those dealing with critical data in relational databases, documents and datasets, especially personally identifiable information (PII) face a harsh reality: moving AI projects from proof-of-concept to production is […]

Yet another Date Dimension

Evolution of code The thing with any bit of code that has been around for a while, is that when change comes along, the tendency is to cater for the change by adding new stuff, while nothing gets taken away.  Some stuff has  definitely been taken away from this Date Dimension, but some historical artefacts […]

Always On Availability Groups and Capabilities