SQL Server Triggers for Business Rules Automation
The post SQL Server Triggers for Business Rules Automation appeared first on SQLServerCentral.
sqlservercentral.com
Workspace Identity Authentication for your Power BI Semantic Models in ...
When you create a semantic model in Power BI desktop, you typically connect to one or more data […]
Picking the ON or WHERE Clause for the SQL Predicate
The post Picking the ON or WHERE Clause for the SQL Predicate appeared first on SQLServerCentral.
What is Delayed Durability in SQL Server — And Should ...
Introduction When SQL Server commits a transaction, it doesn’t just update data in memory. It also writes a […]
DevOps vs. SRE: Bridging the Gap, Not Building Walls
The post DevOps vs. SRE: Bridging the Gap, Not Building Walls appeared first on SQLServerCentral.
PostgreSQL High Availability Options
The post PostgreSQL High Availability Options appeared first on SQLServerCentral.
Using psycopg2 to Connect Python to PostgreSQL
Overview The psycopg2 library makes working with PostgreSQL databases in Python much easier. This has been the most […]
Long Short-Term Memory Network for Machine Learning
The post Long Short-Term Memory Network for Machine Learning appeared first on SQLServerCentral.
From Rows to Pages: The Hidden Chaos Behind SQL Server’s ...
Introduction Sampling data is a common requirement in many real-world SQL Server workloads. Whether you are trying to […]
Contained Availability Groups in SQL Server 2022
SQL Server 2022 introduced a new feature called Contained Availability Groups. It allows the Database Administrators to effectively […]
Split strings by Regular Expressions in SQL Server 2025
The post Split strings by Regular Expressions in SQL Server 2025 appeared first on SQLServerCentral.
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 […]