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 into system behavior. By integrating PostgreSQL with Python, we can build a powerful and efficient logging system that sto …
JSON_CONTAINS Function in SQL Server 2025
The post JSON_CONTAINS Function in SQL Server 2025 appeared first on SQLServerCentral.
How to Query JSON Data Quickly in SQL Server, Part 1: Pre-2025
Before SQL Server 2025, if you want to store JSON data in Microsoft SQL Server or Azure SQL DB, and you want fast queries, the easiest way is to: Store the data in an NVARCHAR(MAX) column (because the native JSON datatype didn’t arrive until SQL Server …
Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples
The post Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples appeared first on SQLServerCentral.
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 data or help display a partial string. While it’s been a very useful function, there has been an annoying limitation for me in the past that is removed i …
[Video] Office Hours in Roatan, Honduras
My cruise ship took a detour to Honduras to avoid the hurricane. Let’s hang out on the beach and go through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:58 Dopinder: What is your opinion of the G …
Who’s Hiring Microsoft Data People? November 2025 Edition
Is your company hiring for a database position as of November 2025? Do you wanna work with the kinds of people who read this blog? Let’s make a love connection. I think YOU should apply. If your company is hiring, leave a comment. The rules: Your comme …
SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User Data
Security in cloud environments is both challenging and fascinating, particularly for Database-as-a-Service (DBaaS) offerings like Amazon RDS, GCP CloudSQL and Alibaba ApsaraDB RDS. The cloud vendor acts as the system administrator, managing the operati …
SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User Data
Security in cloud environments is both challenging and fascinating, particularly for Database-as-a-Service (DBaaS) offerings like Amazon RDS, GCP CloudSQL and Alibaba ApsaraDB RDS. The cloud vendor acts as the system administrator, managing the operati …
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 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 unauthenticated users are reading data, if the system is throwing errors, if there is wrong data somewhere, and the amount of time that sessions …
Next Week, Start My Mastering Classes for Free!
You’re a developer, database administrator, or DBRE who’s been working with SQL Server, Azure SQL DB, and Amazon RDS SQL Server for yeeears. You’re jaded. You’re confident. You’re pretty sure you know what you’re doing. You’ve never taken my Mastering …
Black Friday Doorbusters End Today: Get In Before the Prices Go Up
Welcome to my annual Black Friday sale, and I’m running special doorbuster deals to sweet talking you into taking the plunge quickly. On November 4, the Fundamentals bundle will go up to $295, and the Lifetime bundle will go up to $1,795 – still a deal …
Create an HTML Report on the Status of SQL Server Agent Jobs
SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set of tasks and commands at specified intervals, ensuring the database is up-to-date and performing optimally. As a database administrator, it is essential …