Microsoft continues to blur the line between low-code visual tools and code-first development for Power BI, recently launching a set of official Fabric AI Skills and the Power BI Desktop Bridge preview feature. Together, they allow AI agents to install command-line tools, inspect a running Power BI Desktop process, update a report or model in the Power BI project format (PBIP), and reload the report so that changes appear immediately.

Admin Rights for Everyone

by Steve Jones

SQLServerCentral

Steve thinks administrator rights for too many people is a bad idea, but even when it's a limited group, he recommends some sort of governance.

Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles

by Arvind Toorpu

SQLServerCentral

Learn how you can enable map your security roles in Aurora PostgreSQL to AD groups using Kerberos.

Stairway to DAX and Power BI Level 19: Dates Functions: STARTOFMONTH(), STARTOFQUARTER(), STARTOFYEAR()

by Bill Pearson

SQLServerCentral

Uncategorized

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three DAX Time Intelligence functions related to the Start of Periods: STARTOFMONTH(), STARTOFQUARTER(), and STARTOFYEAR(). He discusses the syntax, uses and operation of each, and then provides hands-on exposure to the function in Power BI.

sp_TexasHoldEm: Multi-Player Poker in T-SQL

by Additional Articles

Brent Ozar Blog

T-SQL

Wanna play some Texas Hold ‘Em style poker and make a pile of Query Bucks? Wanna watch other database people playing?

A Challenge of Our Knowledge

by Steve Jones

SQLServerCentral

AI LLM Assistance

AI is changing the world, but it's changing us as well, challenging the things we have been confident in and depended on in our career.

The memory toll of VARCHAR(MAX) in SQL Server

by sabyda

SQLServerCentral

T-SQL

Introduction When designing the tables or writing the stored procedures in SQL Server, we get easily tempted to choose the path of least resistance. When deciding how much space to allocate for a text column in a database table which may contain the description of a product, a product name, or an additional comment/remarks, it […]

How a SQL Server backup can execute attacker code during restore

by Additional Articles

SimpleTalk

CVE-2026-47295 is a SQL Server vulnerability that lets a maliciously crafted database backup execute attacker-controlled code with sysadmin privileges during a routine RESTORE DATABASE operation.

The New World Of AI Robots

by Steve Jones

SQLServerCentral

AI is making robots more capable, which is a scary thought.

An Eventual Consistency Scam

by Steve Jones

SQLServerCentral

Steve uncovers a scam that relies on data not being consistent between two systems.

How to use the Power BI Desktop Bridge to automate tasks in Power BI Desktop and GitHub Copilot

Admin Rights for Everyone

Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles

Stairway to DAX and Power BI Level 19: Dates Functions: STARTOFMONTH(), STARTOFQUARTER(), STARTOFYEAR()

sp_TexasHoldEm: Multi-Player Poker in T-SQL

A Challenge of Our Knowledge

The memory toll of VARCHAR(MAX) in SQL Server

How a SQL Server backup can execute attacker code during restore

The New World Of AI Robots

An Eventual Consistency Scam

Blogs

Don’t Fear the Technology

Creating a Custom SQL Server Security Checklist Using the DoD STIG

Creating a Local Model Chatbot on Windows

Forums

RegEx Functions III

Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix

Finely Tuned Models

Question of the Day

RegEx Functions III