Who’s Hiring in the Microsoft Database Community? June 2025 Edition
Is your company hiring for a database position as of June 2025? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must include the …
MySQL vs. PostgreSQL: Date and Time Data Types
Date and time data types are important because they help track and manage time-based information in databases. This includes things like recording when orders are placed, scheduling events, or calculating the time between two activities. In this articl …
DMV Comparison for SQL Server 2019 vs Azure SQL Database
The post DMV Comparison for SQL Server 2019 vs Azure SQL Database appeared first on SQLServerCentral.
Parameterize Connections in Microsoft Fabric Data Factory using Variable Libraries
When you create a data pipeline in Microsoft Fabric, you typically use one or more connections. A connection points to a certain data source (such as Azure Blob Storage, a relational database, a Cosmos DB instance etc.) or to a destination in Fabric (O …
Moving from SQL to MongoDB’s MQL
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. People new to MongoDB often come to the platform with a background in relational database management systems (RDBMSs) such as MyS …
Power BI Mistakes to Avoid – Part 2
The post Power BI Mistakes to Avoid – Part 2 appeared first on SQLServerCentral.
Sentiment Analysis & Key Phrase Detection
Recently I worked on a neat little POC with Patrick Leblanc for a customer in Education who wished to perform sentiment analysis and key phrase extraction on surveys completed by students regarding classes and instructors, which brings me to this blog …
Using Parameters with DAX in Report Builder
This is something we expect to be simple, but it has a lot of secrets. Using parameters in DAX queries is essential, as any other query: The parameter transfers the filtering to the server side instead of the report side and optimize the report perform …
Running a MySQL database in a Docker Container
Relational databases provide a structured approach for storing and organizing large volumes of data into tables consisting of rows for records, and columns for attributes. They use primary keys which are unique identifiers for records and foreign keys, …
[Video] Office Hours: Recovering from a Cold Edition
While recovering from a nasty cold, I took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 03:13 Haruki Tanaka: Hi Brent, The stored procedure has 12 parameters, and users pass various combinations of …
Review: SSMS Copilot vs Other AI Tools
I use AI tools constantly in my work, so when the new SSMS v21 came out with Copilot support, I was excited to try it. The short story is that the user interface is fine, and it doesn’t feel buggy, but the advice is simply terrible compared to other LL …
Our Anniversary Sale Ends This Week!
Back in May 2001 when I first registered BrentOzar.com, I never would have dreamed how things would go. I couldn’t have imagined that decades later, the site would be home to: Over 3,500 blog posts with over 10,000 comments About 1,000 pages of content …
DISTINCT and UNION: What happens when you use them together?
When I was perusing my LinkedIn feed the other day, I came across this thread about using SELECT *. In one of the replies, Aaron Cutshall noted that: “Another real performance killer is SELECT DISTINCT especially when combined with UNION. I have a whol …
Free Webcast Tomorrow: Mastering Server Tuning
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching 60-90 minutes of my most popular classes for free this spring, and now it’s time for the Mastering classes. Tomorrow I’m covering Mastering Server Tuning …
Top 5 Power BI Common Pitfalls
The post Top 5 Power BI Common Pitfalls appeared first on SQLServerCentral.