Level 5 of the Stairway to Synapse Analytics: create and use Delta Lake - Part 2

This next article in the Stairway to Synapse looks at Delta tables and processing streaming data.

Navigating Your Test Data Challenges: Insights and Solutions

Join Redgate on May 1st for an insightful webinar cohosted with analyst firm, Bloor Research, featuring independent Senior Analyst Daniel Howard and Redgate's Steve Jones. Discover the biggest test data challenges, the latest approaches like AI synthetic data generation, and how effective test data management can benefit your entire organization. Don't miss out on this opportunity to gain valuable insights and solutions.

Windows Clustered MSDTC and SQL Server 2019 mishap

Introduction As you may know, in the early days of SQL Server Clustering, Microsoft advised to provide each clustered SQL Server instance with its own Microsoft Distributed Transaction Coordinator (MSDTC) resource. Since SQL Server 2012 this advice has been withdrawn. Microsoft now recommends to provide your instance with its own MSDTC resource, once you notice the […]

Smile and Wave Boys

I won't even try to hide it. I got a huge kick out of the penguin characters in the animated movie, Madagascar. For those who don't know, they're trying to escape the zoo, but are trying to hide that from anyone discovering it. So, they put up a front, "Smile and wave boys. Smile and […]

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 […]