The Weather Outside Is Frightful

Yeah, I know, holidays are over. It snowed about four inches overnight here and it's still coming down a little. You'll forgive me for having that song running through my head. Yesterday morning, before the storm started, we did a check through the house to make sure we were ready for a couple of days […]

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.