Using the FP-Growth Algorithm to Mine Useful Patterns in Data
Introduction In this example, we will show patterns between items stored in SQL Server using Python. We will use the FP-Growth algorithm to find common elements in the data that appear together in the transactions. For example, if we go to the supermar …
SQL Server Triggers for Business Rules Automation
The post SQL Server Triggers for Business Rules Automation appeared first on SQLServerCentral.
Workspace Identity Authentication for your Power BI Semantic Models in Microsoft Fabric
When you create a semantic model in Power BI desktop, you typically connect to one or more data sources (regardless of which mode you use, Import or DirectQuery). And naturally, you need to authenticate against those sources. In Power BI Desktop, you c …
[Video] Office Hours Back at Home in Vegas
I’m back in Vegas, at least for the moment, so let’s hang out in my home office and talk through your top-voted questions from https://pollgab.com/room/brento. There’s a lot of good questions this week! Here’s what we covered: 00:00 Start 02:26 Eric M: …
Who’s Hiring in the Microsoft Database Community? September 2025 Edition
Is your company hiring for a database position as of September 2025? Do you wanna work with the kinds of people who read this blog? Let’s make a love connection. If your company is hiring, leave a comment. The rules: Your comment must include the job t …
Free Live SQL Server Classes This Month!
This month, I’m teaching two of my classes live, online, completely free! These are the two fundamentals classes that I think everybody should start with, regardless of their experience with SQL Server or Azure SQL DB. I’ll teach you the most important …
Picking the ON or WHERE Clause for the SQL Predicate
The post Picking the ON or WHERE Clause for the SQL Predicate appeared first on SQLServerCentral.
What is Delayed Durability in SQL Server — And Should You Turn It On?
Introduction When SQL Server commits a transaction, it doesn’t just update data in memory. It also writes a record to the transaction log on disk. Only after this log is flushed does SQL Server confirm the commit to the client. This extra step ensures …
DevOps vs. SRE: Bridging the Gap, Not Building Walls
The post DevOps vs. SRE: Bridging the Gap, Not Building Walls appeared first on SQLServerCentral.
[Video] Office Hours in Icy Strait Point, Alaska
For the last couple of months, I’ve been trying to get my on-location Office Hours episodes filmed with an Insta360 so you can pan the camera around to see the sights. Folks, I’ve finally pulled it off! You can move the camera around with your clicker: …
Why Aren’t People Going to Local and Regional In-Person Events Anymore?
Steve Jones recently posted an update about SQL Saturday’s status, and it includes some news we need to talk about: However, this year the number may stagnate or even decline slightly. Running events has become challenging for many communities. Organiz …
PostgreSQL High Availability Options
The post PostgreSQL High Availability Options appeared first on SQLServerCentral.
SQL Server 2025 RC0 Is Out with New Preview Features Settings
The release of SQL Server 2025 keeps inching closer. Release Candidate 0 is out now, and here are the release notes. If you’re planning on replacing your SQL Server 2016 instances (which go out of support next July) with 2025, now would be a good time …
Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples
The JOIN statement is one of the most common operations SQL developers perform. Yet in a world ruled by Inner and Left Joins, the poor Full Outer Join is like Cinderella before the ball – allowed out on only the rarest of occasions. In an (unscientific …
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 popular PostgreSQL adapter for Python. Whether you’re building backend services, data pipelines, or automation scripts, psycopg2 is your …