[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 …
Deprecated but Forgotten: Why SQL Server’s Text, NText, and Image Data Types Still Haunt Your Systems
Introduction These data types – TEXT, NTEXT, and IMAGE – have been part of SQL Server since its earliest versions, designed to store large objects like documents, HTML, and binary data when there was no better alternative. However, starting from SQL Se …
Why CQRS and Event Sourcing Are Gaining Ground in High-Concurrency Web Systems
In web app development company boardrooms, architects and engineers are debating old assumptions. Scaling up isn’t just about faster servers or better caching anymore. It’s about reshaping how systems think. CQRS (Command Query Responsibility Segregati …
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 (not trailing) wildcards, like this search for all the different national versions of the Encabulator, each of which has different prefixes depending on which go …