Crazy number of Parameters… and a challenge

The other day, my lovable coworker and frequent Simple Talk writer: Grant Fritchey, sent this post on X:

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.

Inserting Sequences

The State of the Database Landscape in 2025: Insights and trends

How are you navigating the database landscape? Our latest report sheds light on the current state of database management and offers valuable insights into how organizations can navigate and simplify the growing complexities of the database landscape.

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.

What is time?

There was a post on X I read today about valuing your time. The gist was that since this person had waited 9 minutes to save $4, they valued their time at $27 an hour. I get the point being made. Time is valuable and you need to set the value of your time. It […]

How to use the Azure Emulator to create blob containers, queues and tables

Learn how to emulate Azure storage for files, blogs, and queues.

Configuring Maintenance Plans in SQL Server

See a walkthrough of setting up a maintenance plan in SQL Server.

How to Resolve SQL Server Database Stuck in Recovery Pending State

Learn how to recover a database from a missing or corrupt transaction log file.

Limits, Not Goals

I just saw one of "those" questions. You know the ones: 'We're hitting an error with a stored procedure. What is the maximum number of parameters you can have?" <sigh> Look, I get it. Breaking the land speed record is cool. Getting the most people into a phone booth (look it up), also cool. Fastest, […]