Leveraging the “STUFF” Function for Enhanced Data Representation and String Manipulation 

Learn the basics of the T-SQL STUFF command.

Superseded Indexes

Connecting Streamlit to Upload Data to Snowflake

How to create a connection for StreamLit and Snowflake to upload data for visualization

Do As I Say, Not As I Do

Yesterday morning I sat down to start a new project. Before I got started, I knew I needed to put this in source control. Now, the project was going to be in AWS, but, AWS has shut down their flavor of Git, CodeCommit. I decided to use GitHub instead, no big deal. Well, until I […]

3 Legit Signs It’s Time for Enterprise Edition

Your app is happily humming along on SQL Server Standard Edition. Things are quiet – too quiet. You’re wondering what you’re missing, and whether you should be on SQL Server Enterprise Edition. Here are 3 warning signs to watch out for.

It's The People

Last week the 2024 PASS Data Community Summit conference was held in Seattle. 1,700 of my closest friends got together for a week of learning (well, technically it's a three day conference, but there are two days of pre-conference seminars) and sharing. I'm still exhausted a week later (although, old age and an aggressive travel […]

Creating Views in MongoDB

Like many relational database systems, MongoDB supports the use of views. A view is a read-only object in a MongoDB

AUTO_DROP Statistics

When Companies Fail

The challenge of software pervading all aspects of our lives and inside many products is going to be create an interesting world when companies fail.

Are We Dinosaurs?

Let's talk about the elephant in the room right up front. Yes, I'm old. I remember when Buck Woody was a little tyke on the day the last of the Tyranosaurs died (I'm older than Buck). So, I'm not asking if I'm old. Yes. I'm old. No, I'm asking if that massive meteor strike over […]