Having a bad boss is one that Steve tries to avoid.

How I Achieved Scalability in a. Amazon RDS Shared DB Connection Environment

by Shweta Venkatesh

SQLServerCentral

Uncategorized

This article shows a solution to the challenge of multiple databases on one RDS instance with different databases and the limitation of 5000 connections.

SQL Server 2022 CU Updates and Error Code 0x851A0043

by Additional Articles

SimpleTalk

The documentation cautions that cumulative updates (CU) could fail if a specific registry key isn’t updated after moving the master files, so I wanted to test this before I spent too much time configuring the server.

Deploy DACPAC to Azure SQL Database using Visual Studio

by Kunal Rathi

SQLServerCentral

This guide will walk you through the process of deploy DACPAC to Azure SQL database directly from Visual Studio.

Understanding a Database

by Steve Jones

SQLServerCentral.com

Editorial

The ways in which you might try and reverse engineer a database design are on Steve's mind today.

INFO.VIEW DAX Functions Usage and Examples

by Additional Articles

MSSQLTips.com

In the December 2023 Microsoft Power BI Desktop release, more than 50 new INFO DAX functions were added. They all start with “INFO.” and return the same result as corresponding data management views (DMVs) that were available before only using a SQL-like syntax. With these new DAX functions, you can use the recently added DAX query to get metadata about your semantic mode

Shadow AI Data Leak Risk or “From the Desk of I saw that Coming”

by dbakevlar@gmail.com

SQLServerCentral

Artificial Intelligence (AI)

CSO recently published an article based on a report from Harmonic about generative AI data leaks, and the findings were eye-opening. According to the report, over 8% of employee prompts to public large language models (LLMs) contained sensitive data, ranging from security and compliance issues to privacy and legal vulnerabilities. This wasn’t just a handful […]