How I Achieved Scalability in a. Amazon RDS Shared DB Connection Environment
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
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
This guide will walk you through the process of deploy DACPAC to Azure SQL database directly from Visual Studio.
Understanding a Database
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
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”
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 […]
Tracking Table Sizes
Today Steve asks if you track the details of your table growth inside a database.
Exploring Scalar Solutions to Complex Data Math
There are many functions and tools available to database professionals that can solve data math challenges, regardless of complexity.
An Effective Approach for High Volume Data in Azure Synapse
Learn about how you can efficiently load data in Azure Synapse.
The Job Outlook for Database Professionals
The job outlook for database professionals is good, but it's not that easy to get a great job. Steve has some advice for you today.
Blogs
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Forums
taking the rcsi dive
Hi, we put together an extract that runs every 15 minutes against what i...
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers