Why Aren’t People Going to Local and Regional In-Person Events ...
Steve Jones recently posted an update about SQL Saturday’s status, and it includes some news we need to […]
Archives du mois : août 2025
PostgreSQL High Availability Options
The post PostgreSQL High Availability Options appeared first on SQLServerCentral.
SQL Server 2025 RC0 Is Out with New Preview Features ...
The release of SQL Server 2025 keeps inching closer. Release Candidate 0 is out now, and here are […]
Unlocking the Power of FULL OUTER JOIN in SQL: Performance, ...
The JOIN statement is one of the most common operations SQL developers perform. Yet in a world […]
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 […]
Accelerating SQL Server 2025 momentum: Announcing the first release candidate
The first release candidate (RC0) of SQL Server 2025 is now available. As we move toward general availability, […]
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 […]
SQLBits 2026 is Going Back to Newport, Wales.
SQLBits 2026 will be back at the International Convention Center Wales in Newport on April 22-25, and I’ll […]
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 […]
Save $150 on the Summit with Discount Code BRENT25
The PASS Data Community Summit is the biggest conference in the Microsoft database industry, and over the last […]
MySQL Shell Basic Configuration Management (Part 6 – Backups and ...
In this final part of the MySQL Shell Configuration Management series, we explore how to automate performance […]
Split strings by Regular Expressions in SQL Server 2025
The post Split strings by Regular Expressions in SQL Server 2025 appeared first on SQLServerCentral.
[Video] Office Hours: Docked in Miami Beach
On the last day of my Caribbean cruise, as we pull into port in Miami, let’s go through […]
Make the Comment Section Look Like a Junior DBA’s Search ...
Tomorrow’s scheduled webcast for Mastering Parameter Sniffing is off due to a scheduling issue, so in the meantime, […]
Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices
PostgreSQL is an open-source relational database management system valued for its power, standards-compliance, and extensibility. Whether you’re […]
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.
AI is Like Outsourcing. #TSQL2sday
When you ask data people how they feel about AI, you get pretty rabid, extreme reactions. People either […]
Power BI TMDL View: Benefits, Security Risks & Best Practices
The Tabular Model Definition Language (TMDL) provides a simpler way of defining Power BI Semantic Models. Unlike […]
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 […]
MySQL Shell Basic Configuration Management (Part 5a – Optimizing MySQL ...
Welcome back to our comprehensive guide on optimizing MySQL performance using MySQL Shell. So far in this […]
[Video] Office Hours: 15 Answers in 30 Minutes
The first few questions from this week’s crop at https://pollgab.com/room/brento are very much about what-problem-are-you-trying-to-solve, but they get […]
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 […]
How to Make Leading Wildcard Searches Fast
99.9% of you are never gonna need this. But let’s say you need to run queries with leading […]
Who’s Hiring in the Microsoft Database Community? August 2025 Edition
Is your company hiring for a database position as of August 2025? Do you wanna work with the […]
Mastering SQL VIEWs: Syntax, Use Cases, and Best Practices
VIEWs are an undervalued and underused feature in SQL. They basically consist of a query that has […]
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 […]
How to Use the psql Command-Line Tool with Azure Database for PostgreSQL ...
A number of client tools are available for working with Azure Database for PostgreSQL flexible server. With […]
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 […]