You’re using SQL Server Management Studio (SSMS) and would like to use Dark Mode. You’ve looked at the configuration options and don’t see a way to configure it.

When the Token Meter is Zero

by dbakevlar@gmail.com

SQLServerCentral

Uncategorized

DBAKevlar disccusses the new product from Perplexity and Nvidia that just shipped on August 25th. If you haven’t been paying attention its goal is businesses whose entire generative AI solution has been what the AI bubble is betting on.

Collecting Data Is Hard

by Steve Jones

SQLServerCentral

Test Data

The growth of AI systems might have another victim: our data itself.

Understanding Temp Tables and Table Variables in SQL Server

by sabyda

SQLServerCentral

Introduction When building application backends or processing complex data sets in a SQL Server, we frequently need a temporary storage to hold the intermediate query results. For example: Store filtered rows before joining them to another table Hold calculation results inside a stored procedure Break a complex query into smaller readable steps Process a small […]

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

by Additional Articles

SimpleTalk

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.