Building a Database Dashboard with SSRS
Learn how to create a dynamic database dashboard that tracks key metrics using SQL Server Reporting Services. From setting up to deploying your report.
2025-08-18 (first published: 2023-07-17)
2,279 reads
Articles
Split strings by Regular Expressions in SQL Server 2025
SQL Server users have been asking for native regular expression support for over two decades. There are third-party Common Language Runtime (CLR) modules that offer this functionality, but these can be complicated to install and simply aren’t possible in some environments. I want to split a string using a regular expression instead of a static string. Will that be possible in SQL Server 2025, without CLR?
2025-08-18
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, […]
2025-08-15 (first published: 2025-08-11)
3,102 reads
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)
36 reads
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
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 […]
2025-08-08
75 reads
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.
2025-08-07
2,399 reads
Working with Indexes on SSMS
Overview: In SQL Server, indexing is a technique used to improve the performance of queries by reducing the amount of data that SQL Server needs to scan. You can think of it like a table of contents in a book—it helps SQL Server find data more quickly. In this article, we will cover the following […]
2025-08-07
3,161 reads
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.
2025-08-06
1,590 reads
Blogs
Cosmos DB vs Traditional SQL: When to Choose What
By Chris Yates
From where I stand, the decision between Cosmos DB and a traditional SQL database...
Monday Monitor Tips: Searching Procedures
By Steve Jones
A customer was asking about how to track all the stored procedures that execute...
Forums
SQL Connectivity
Hi everyone, I'm currently working on building an MCP integration for SQL Server. Most...
The Next Great Thing
Comments posted to this topic are about the item The Next Great Thing
Building a Database Dashboard with SSRS
Comments posted to this topic are about the item Building a Database Dashboard with...
Question of the Day
Enabling Change Tracking
If I want to set up Change Tracking in a database, what should I do first in SQL Server 2022?
See possible answers