Split strings by Regular Expressions in SQL Server 2025
The post Split strings by Regular Expressions in SQL Server 2025 appeared first on SQLServerCentral.
sqlservercentral.com
Enable TDE for Databases in a SQL Server AlwaysOn Availability ...
The post Enable TDE for Databases in a SQL Server AlwaysOn Availability Group appeared first on SQLServerCentral.
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 […]
MongoDB and NodeJS in action
Overview MongoDB is a popular NoSQL database used for building modern, scalable applications. In this article, we’ll cover […]
Working with Indexes on SSMS
Overview: In SQL Server, indexing is a technique used to improve the performance of queries by reducing the […]
SQL Server Threats
Microsoft SQL Server is a robust relational database management system. It stores and processes sensitive data for countless […]
Deprecated but Forgotten: Why SQL Server’s Text, NText, and Image ...
Introduction These data types – TEXT, NTEXT, and IMAGE – have been part of SQL Server since its […]
Why CQRS and Event Sourcing Are Gaining Ground in High-Concurrency ...
In web app development company boardrooms, architects and engineers are debating old assumptions. Scaling up isn’t just about […]
Yet another Date Dimension
Evolution of code The thing with any bit of code that has been around for a while, is […]
Advanced SQL Server Page Forensics: Detecting Page Splits and Allocations ...
Introduction Page splits are one of those silent performance killers in SQL Server that many DBAs have heard […]
How to Access and Use Azure Key Vault Secrets in ...
When you run a CI/CD pipeline, you often need confidential values like passwords, authentication tokens, service principal secrets […]
Connect Cloud Power BI to on prem SQL Server
Power BI has the versatility that you can publish your reports to the cloud (Power BI Service) and […]
Model Context Protocol (MCP): A Developer’s Guide to Long-Context LLM ...
Large Language Models (LLMs) like Anthropic’s Claude have unlocked massive context windows (up to 100k tokens in Claude […]
How to safely and surgically restore filegroups
In all my years working with SQL Server and navigating disaster recovery scenarios, I’ve come across surprisingly few […]
MongoDB and Python in action
Overview As a part of this article, we will learn basics of connecting to MongoDB using a python […]
Best Way to Repair SQL Database: How to Restore SQL ...
Summary: SQL Server administrators frequently encounter the critical challenge of unexpected MDF file corruption. Such corruption can result […]
How to optimize queries using AI (SQL Expert)
Introduction ChatGPT can help you with your queries. However, some customized GPTs inside ChatGPT can be useful for […]
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 […]
Taming Resource Hogs: Using SQL Server Resource Governor to Restrict ...
Taming Resource Hogs: Using SQL Server Resource Governor to Restrict User Group Consumption As a SQL Server professional, […]
Monitor SQL Server using Zabbix
Zabbix is an open-source monitoring software, like Paessler PRTG, which can monitor SQL Server performance statistics and status. […]
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 […]
Migrate from Linux to Windows with Availability Groups
We have an SQL Server 2019 server running on Linux Ubuntu, and we want to migrate to Windows […]
Unlocking Interoperability: A Guide to Foreign Data Wrappers in PostgreSQL ...
Unlocking Interoperability: A Guide to Foreign Data Wrappers in PostgreSQL and Aurora PostgreSQL AWS RDS As a database […]
An Introduction To Database Diagrams
A database diagram clearly details the structure, relationships, and data rules in a database. It makes storing, retrieving […]
When INCLUDE Columns Quietly Inflate Your Transaction Logs
Introduction As DBAs, we often think of INCLUDE columns as a harmless way to cover queries.They aren’t part […]
Automating SQL Server Access Review
Tracking and reviewing user access in a SQL Server is an important tasks for any DBA. Unauthorized access […]
Getting In: Running External Code in a Locked-Down PaaS
In Part 1, I explored how to bend SQL Server Agent to our will and peek under the […]
Dimensional Modeling Case Study, Part 4 – Dynamic Time Duration ...
Background In the first parts of this series (part 1, part 2, part 3), we explored dimension tables […]
SQL Server 2022 Clusterless Distributed Availability Group
One customer had a very specific scenario: They had an Always On Availability Group with Windows Server Failover […]
Revolutionizing Efficiency: The Power of Custom Automation Software Development
With the ever-increasing pace of the digital era, companies are continuously looking for opportunities to enhance efficiency, cut […]
SQL Server and AI: Integrating Machine Learning Services
Have you ever wished you could run your data science experiments right where your data lives, without the […]
PostgreSQL Aggregate Functions
Overview In this article we will go through the various in built aggregate functions available in PostgreSQL. Aggregate […]
Zero-Trust Architecture for Cloud-Based AI Systems
The post Zero-Trust Architecture for Cloud-Based AI Systems appeared first on SQLServerCentral.
Cloning Master Admin User Permissions in Amazon RDS for SQL ...
Introduction When you create a new Amazon RDS for SQL Server instance, the master user is provisioned with […]
Unmasking CXPACKET and CXCONSUMER in SQL Server: What Your Execution ...
Introduction When you see high CPU and the query plan says « parallelism, » one of the first suspects is […]
Automating SQL Server Inventory Collection with SQLInventory
Managing SQL Server inventory is crucial when your organization has many SQL Server Instances. A central database that […]
How to Work with RStudio and SQL Server
Introduction Sometimes, we need to connect to SQL Server using RStudio, the most common tool for programming in […]
Retrieving SQL Server Index Properties with INDEXPROPERTY
The post Retrieving SQL Server Index Properties with INDEXPROPERTY appeared first on SQLServerCentral.
Why Clone Fails: Discovering the Hardware Beneath Azure SQL MI
Microsoft describes Azure SQL Managed Instance (MI) as offering near-full SQL Server compatibility with more flexibility than typical […]
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and ...
Introduction In our TB-scale production system, a few queries had MAXDOP 4 hardcoded into them. The goal was […]
How to Choose the Right Tool for MS SQL to ...
This whitepaper serves as an in-depth guide for database administrators (DBAs), software engineers, data architects, and even semi-technical […]
Inside the Walls of Azure SQL MI
Welcome to the prologue article for a three-part series where I try to infiltrate the OS layer of […]
How to process images and analyze charts with AI
In this article, we will see how to handle images with AI. Sometimes we need to import the […]
Dimensional Modeling Case Study Part 3 – Dynamic Days Dimension
Background In this case study series, we’ve explored how to use age and tally tables to support various […]
Securing the Data Layer: Why SQL Developers Should Care About ...
Editor: This is AI generated, which is against our policy. The Hidden Risks Above the Database In today’s […]
Azure SQL Performance Tuning: Mastering Indexes, Partitioning, and Clustered Columnstore
Performance tuning in Azure SQL Database can feel like solving a puzzle—get it right, and your queries fly; […]
SQL Automate – A DBA’s Time-Saving Toolkit
Introduction Installing SQL Server can be a very boring and time consuming task, especially when you have to […]
Index Scans and Table Scans
The post Index Scans and Table Scans appeared first on SQLServerCentral.
Managing Fabric Lakehouse objects with the new CLI: Data Engineering ...
Microsoft Fabric has been evolving since its general availability in November 2023. Developers have asked for a command […]
DMV Comparison for SQL Server 2019 vs Azure SQL Database
The post DMV Comparison for SQL Server 2019 vs Azure SQL Database appeared first on SQLServerCentral.