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 few years, they’ve expanded to cover other databases as well. It’s in Seattle on November 17-21 this year. It costs $2195 for the Weds-Fri ge …
MySQL Shell Basic Configuration Management (Part 6 – Backups and Recovery Procedures)
In this final part of the MySQL Shell Configuration Management series, we explore how to automate performance tuning, backups and recovery using MySQL Shell. This guide introduces a complete system that captures not just data, but also configuration an …
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 your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:45 Sean: How would you approach a task to remove 90% of the da …
Make the Comment Section Look Like a Junior DBA’s Search History
Tomorrow’s scheduled webcast for Mastering Parameter Sniffing is off due to a scheduling issue, so in the meantime, here’s a homework challenge:
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 building a microservice, spinning up test environments, or maintaining a dev copy of production, it’s ofte …
Enable TDE for Databases in a SQL Server AlwaysOn Availability Group
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 love it or hate it. Set that aside for a second, and let’s zoom out and think about a bigger picture question. What’s it like to work with someone y …
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 the JSON-based Tabular Model Scripting Language (TMSL), TMDL uses a more accessible tab-based format for specifying DAX measures, relations …
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 …
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 Delet …
MySQL Shell Basic Configuration Management (Part 5a – Optimizing MySQL Performance)
Welcome back to our comprehensive guide on optimizing MySQL performance using MySQL Shell. So far in this series, we introduced you to MySQL Shell, focusing on its features and how it can be used to configure basic MySQL settings, before we dived into …
[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 more complex from there. Here’s what we covered: 00:00 Start 02:49 My Erik is Strong: Do you suggest …
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. …
SQL Server Threats
Microsoft SQL Server is a robust relational database management system. It stores and processes sensitive data for countless applications, which also makes it a high-value target for cybercriminals. Below are some security threats that SQL Server envir …