JSON Data Extract from SQL Server 2025
The post JSON Data Extract from SQL Server 2025 appeared first on SQLServerCentral.
sqlservercentral.com
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 […]
Parameter Sensitive Plan Optimization in SQL Server 2022
SQL Server 2022 has lot of improved and advanced features compared to its predecessor versions. This includes new […]
Configure SQL Server Alerts for Azure SQL Managed Instance
The post Configure SQL Server Alerts for Azure SQL Managed Instance appeared first on SQLServerCentral.
Revisiting SQL Server Window Functions- A Practical Walkthrough
Introduction Sometimes we just want SQL to be a bit smarter. Maybe we need to figure out who’s […]
A Rolling Filtered Index in SQL Server
The post A Rolling Filtered Index in SQL Server appeared first on SQLServerCentral.
Using the FP-Growth Algorithm to Mine Useful Patterns in Data
Introduction In this example, we will show patterns between items stored in SQL Server using Python. We will […]
SQL Server Triggers for Business Rules Automation
The post SQL Server Triggers for Business Rules Automation appeared first on SQLServerCentral.
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.