T-SQL in SQL Server 2025: The UNISTR Function
I am not much for working in languages other than English. That’s my native language and I know […]
sqlservercentral.com
SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User ...
The post SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User Data appeared first on SQLServerCentral.
Random Number Generator in SQL using Marsaglia Polar
The post Random Number Generator in SQL using Marsaglia Polar appeared first on SQLServerCentral.
Troubleshooting Common SQL Server Errors: 823, and 824
SQL Server is designed to provide high reliability and data integrity. However, like any software, it can also […]
T-SQL in SQL Server 2025: The PRODUCT Function
Earlier this year at SQL Saturday Austin 2025, Conor Cunningham gave a keynote that discussed the engineering efforts […]
Configuring the On-Premises Data Gateway: The Fabric Modern Data Platform
This article continues the discussion of a meta data driven pipeline that move data from SQL Server into a Fabric […]
SQL Declare Variable Code Examples
The post SQL Declare Variable Code Examples appeared first on SQLServerCentral.
Steps for Installing AlwaysOn Availability Groups – SQL 2019
With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements […]
SQL Server 2025 Build List
This is a list of the builds for SQL Server 2025. There are other build lists available here. […]
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
When we talk about performance tuning in SQL Server, the first thing that comes to mind is indexes. […]
JSON Data Extract from SQL Server 2025
The post JSON Data Extract from SQL Server 2025 appeared first on SQLServerCentral.
UNLOGGED Tables in PostgreSQL: When Speed Matters More Than Durability
Introduction Every relational database lives and dies by its transaction log. In SQL Server, that’s the transaction log […]
How to Build an AI-Powered T-SQL Assistant with Python & ...
The post How to Build an AI-Powered T-SQL Assistant with Python & SQL Server appeared first on SQLServerCentral.
SQL Server 2025 has arrived!
The wait is over. Today we announced the General Availability of SQL Server 2025, the AI-ready enterprise database. […]
The DBScan algorithm tutorial
Introduction to the DBScan algorithm In this example, we are going to learn how to use DBScan. DBScan […]
T-SQL in SQL Server 2025: Concatenating Strings
Like many of you, I have often put strings together (concatenation) with a simple arithmetical operator: +. We […]
Implementing PostgreSQL with Python for Real-Time Logging and Monitoring
Overview Real-time logging and monitoring are essential for modern applications to track events, detect issues, and gain insights […]
JSON_CONTAINS Function in SQL Server 2025
The post JSON_CONTAINS Function in SQL Server 2025 appeared first on SQLServerCentral.
Unlocking the Power of FULL OUTER JOIN in SQL: Performance, ...
The post Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples appeared first […]
SQL Server CROSS APPLY and OUTER APPLY Helpful Examples
The post SQL Server CROSS APPLY and OUTER APPLY Helpful Examples appeared first on SQLServerCentral.
T-SQL in SQL Server 2025: Substring Changes
The SUBSTRING() function has been one of my most often used tools over the years, often to massage […]
Create and Read the Analysis Services Flight Recorder
One of the most important things in database administration is monitoring. For example, you want to know if […]
Power BI TMDL View: Benefits, Security Risks & Best Practices
The post Power BI TMDL View: Benefits, Security Risks & Best Practices appeared first on SQLServerCentral.
Create an HTML Report on the Status of SQL Server ...
SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set […]
Static Versus Dynamic Bulk Insert Imports of Multi-File Datasets
The post Static Versus Dynamic Bulk Insert Imports of Multi-File Datasets appeared first on SQLServerCentral.
Regular Expressions in SQL Server 2025
Microsoft is introducing Regular Expression(regex) functions in its upcoming SQL Server 2025 to enable pattern-based searching and manipulation. […]
Docker Advice for SQL Server in Production
Introduction Nowadays, with the widespread adoption of microservices across major companies, using Windows Server to host SQL Server […]
Managing Underused Indexes in SQL Server Availability Groups – Part ...
The post Managing Underused Indexes in SQL Server Availability Groups – Part 2 appeared first on SQLServerCentral.
How Implicit Transactions Hurt SQL Server Performance Without You Knowing
Introduction In the world of SQL Server performance troubleshooting, developers and DBAs often chase the usual suspects: bad […]
SQL EXISTS Use Cases and Examples
The post SQL EXISTS Use Cases and Examples appeared first on SQLServerCentral.
Database Ledger in SQL Server 2022
Protecting data from unauthorized access is a major challenge for organizations today. SQL Server 2022 introduces Database Ledger, […]
T‑SQL BULK INSERT vs OPENROWSET: CSV Imports, File Access Gotchas, ...
The post T‑SQL BULK INSERT vs OPENROWSET: CSV Imports, File Access Gotchas, and A PowerShell Script appeared first […]
Schema Design Basics for Power BI
The post Schema Design Basics for Power BI appeared first on SQLServerCentral.
Migrate SSRS Reports to a New Server in Just a ...
Managing SSRS report migrations can be a time-consuming and error-prone process, especially when dealing with large enterprise report […]
Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices
The post Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices appeared first on SQLServerCentral.
Distributed Availability Group Health: T-SQL and Zabbix
After creating a distributed availability group using the steps described in my article, SQL Server 2022 Clusterless Distributed […]
Use SQL to Find a String in Database Tables, Stored ...
The post Use SQL to Find a String in Database Tables, Stored Procedures, and User Defined Functions appeared […]
Find Invalid Objects in SQL Server
One of the most important responsibilities of any database administrator is to maintain the integrity of the database, […]
Natural Language Query for SQL Server
The post Natural Language Query for SQL Server appeared first on SQLServerCentral.
Oracle Performance Tuning: Practical Techniques Every DBA Should Master
As database professionals, we’ve all been there – that dreaded moment when users start complaining about slow queries, […]
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Introduction High-concurrency systems always look impressive on paper. You throw in dozens of CPU cores, crank up memory, […]
Unlocking the Power of FULL OUTER JOIN in SQL: Performance, ...
The post Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples appeared first […]
Building a Dynamic Countdown Timer in Power BI
The post Building a Dynamic Countdown Timer in Power BI appeared first on SQLServerCentral.
How to Use SQL Server Features to Cut Web App ...
A customer taps “Buy Now” on your web app. Half a second passes. The screen hesitates before the […]
Power BI TMDL View: Benefits, Security Risks & Best Practices
The post Power BI TMDL View: Benefits, Security Risks & Best Practices appeared first on SQLServerCentral.
Building a Simple SQL/AI Environment
Al is everywhere….almost. In my day-to-day role as a DBA, I don’t really have the opportunity or need […]
Side by Side Upgrade to SQL Server 2022
The post Side by Side Upgrade to SQL Server 2022 appeared first on SQLServerCentral.
How Well Does the MSSQL Extension in VSCode Work?
With the retirement of ADS, I decided to take a look at the MSSQL extension for VSCode. This […]
Getting Started with Bayesian Modeling
The post Getting Started with Bayesian Modeling appeared first on SQLServerCentral.
Build a Test Lab of SQL Server 2025 on Windows ...
Problem Now that public preview of SQL Server 2025 CTP 2.1 is out (Community Technical Preview), you have […]