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.