Connecting Streamlit to Upload Data to Snowflake
How to create a connection for StreamLit and Snowflake to upload data for visualization
2024-12-20
2,584 reads
Uncategorized
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 […]
2024-12-14
123 reads
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.
2024-12-09
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 […]
2024-11-16
129 reads
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
2024-11-04
2024-10-28
363 reads
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.
2024-10-23
123 reads
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 […]
2024-10-19
297 reads
2024-10-18
126 reads
The PASS Data Community Summit Session Schedule is LIVE!
Join over 170 global data experts offering more than 150 sessions designed for all skill levels. Explore the schedule to plan your days on-site, secure your ticket, and book your travel before prices increase.
2024-09-27
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers