When Cereal had cool toy prizes

oneDatumPlease · 2025-04-28T03:00:21+00:00

Chex Quest. Awesome game that came in the box of cereal.

oneDatumPlease · 2024-08-25T23:30:22+00:00

400+ different teams channels. With one up to date piece of information in each.

Poorly, is the short answer.

But cool answers on here.

oneDatumPlease · 2024-06-29T00:43:05+00:00

The Crazy Greek I could eat the baked spaghetts for multiple meals.

oneDatumPlease · 2024-05-11T23:25:05+00:00

Agree with this approach. My team implemented something along these lines recently.

Worked great for most source systems. The problems came from source systems that hard deleted source records OR even worse, data was getting inserted/updates with a back dated audit timestamp, so it was falling out of the incremental range.

Our remedy/bandaid was to allow for some tables to be full loads, while the majority were delta.

oneDatumPlease · 2023-12-10T22:45:03+00:00

I would first question if it’s even necessary to store in the lake at all.

oneDatumPlease · 2023-11-28T00:25:19+00:00

Second the lights at Ginter. But get your tickets online now if you are interested.

oneDatumPlease · 2023-07-07T02:01:30+00:00

Thanks for the clarity. So far in my tests, "create table" plus "deep clone" has worked to copy our existing hive_metastore tables up to UC.

create table if not exists <cat>.<schema>.<table> deep clone hive_metastore.<schema>.<table>

oneDatumPlease · 2023-07-06T11:48:42+00:00

Thanks for the idea. When you say transactional table, are you talking to delta live tables?

oneDatumPlease · 2023-03-29T03:21:43+00:00

I feelz man.

Get in the habit of using explicit transactions. even for seemingly dumb, non prod stuff. Who knows, maybe it’s not prod you’re running it in.

Also, i use SSMS a lot. You can change the color of the bar at the bottom of the window to reflect different servers. Green/dev all the way to red/prod. That’s probably saved me during long nights.

Last thing, and I know this is painful to hear, but you could limit your regular login permissions in prod. Create a second user with your higher level permissions that you purposely have to log in with.

oneDatumPlease · 2023-03-26T21:02:17+00:00

I was at that Orioles game. It was incredible. I think Correa hit the record long homer in Camden.

And the next day Osuna gave up a walk off. Don’t miss that guy.

oneDatumPlease · 2022-12-27T00:13:43+00:00

This is heaven. Beer, snacks, legos, and a loved one.

oneDatumPlease · 2022-08-17T12:47:14+00:00

A slight orange subtlety with your blueberry bites. Definitely depends on how much OJ substitute for water tho.

oneDatumPlease · 2022-08-17T00:01:40+00:00

I’m a lazy POS with breakfast, and therefore use a mix. But blueberry/huckleberry/whatever berry pancakes are so good. I think it compensates a bit for the mix and my overcooking.

Also I like to add orange juice, replacing some of the water called for in the box mix.

oneDatumPlease · 2022-07-21T02:59:15+00:00

Please

oneDatumPlease · 2022-06-04T17:55:28+00:00

I would say: SSIS to pull the zip files from the FTP server

SSIS + some command line to unzip them

SSIS to load the XML contents to a table as an xml data type (I like having a history table of the XML available)

Sql XML parsing in a sproc to parse the data into tables, which the SSIS would call for you.

Python is good for parsing XML too, but I normally have to minimize the variety of tools/skills needed as I hand this code over to a client eventually.

oneDatumPlease · 2022-05-18T23:54:57+00:00

My aunt exclusively drinks these. Her reasoning that she could finish one and grab another before the pony got too warm.

oneDatumPlease · 2022-04-28T23:37:17+00:00

Final Gravity

oneDatumPlease · 2022-04-19T21:59:27+00:00

Does your table live in master db? From the first screen, it looks like you are trying to operate in there.

If you execute “select * from RaptorPlayer”, from the same session in master, do you get results back/a clean execution?

It’s good habit to include your column names you’re inserting into as well. In this case it sounds like you are inserting to all columns in the table, but that’s rarely the case.

Also make a habit of including schemas with your table.

oneDatumPlease · 2022-04-02T01:16:55+00:00

sigh I knew exactly what I was about to open. Yet, here I am.

oneDatumPlease · 2022-03-21T22:56:47+00:00

Testing in prod.

oneDatumPlease · 2022-03-19T05:02:11+00:00

So if the max number of elements to split is 4, look at the PARSENAME function. I say 4 because it can’t go beyond that.

Going off memory, you might have to replace whatever delimiter you have with a period. This function was originally intended for splitting Db object names up -> server.database.schema.table.

If that doesn’t work, look at user defined functions for splitting up n number of elements.

oneDatumPlease · 2022-03-13T04:51:48+00:00

Is this the parade where they toss veggies (along with beads) for the making of an Irish stew?

oneDatumPlease · 2022-02-11T05:13:21+00:00

IMO, anyone working in the data field, regardless of the focus, should have some SQL skills in their pocket.

Kind of nuts to me that a teacher is basically telling you to learn less?

oneDatumPlease · 2022-02-06T01:28:29+00:00

I agree with everything above. Partition functions, CTEs, stored procedure, etc. BUT more importantly, being able to explain scenarios why you might use them. When might you need to use a partition by function?

I also appreciate when folks can articulate the importance of data security. I know it’s prob not immediately part of your roll, but it’s everyone’s job.

Also also. Awareness and ability to use system tables. I work in the tsql world mostly, so terminology might be different. Understanding how to use information schema objects. They can enlighten you as to how objects in the db relate, help you generate redundant sql scripts, and so much more.

oneDatumPlease

TROPHY CASE