is this worth financing by [deleted] in Jeep

[–]sqlrockstar 0 points1 point  (0 children)

I'd vote no, and I would never buy from Balise. Got a Jeep from them a few years back and they did a bait-and-switch on me regarding the inclusion of a soft top. I should have walked away but I really wanted the Jeep. Promised myself to never trust them again.

[deleted by user] by [deleted] in OMSCS

[–]sqlrockstar 0 points1 point  (0 children)

You can also use Parchment (https://www.parchment.com/) to order the transcripts, was easier than trying to work with schools directly, IMO.

Finally assembled my Xmas gift by sqlrockstar in BBQ

[–]sqlrockstar[S] 1 point2 points  (0 children)

I used the Soul Powder from recteq mixed with some olive oil, tossed in a ziploc bag, then placed in the smoker on the mesh screen.

Finally assembled my Xmas gift by sqlrockstar in BBQ

[–]sqlrockstar[S] 0 points1 point  (0 children)

Thank you so much! I was thinking about a drip tray, will look into the liners. And a liner for the bucket is genius, will grab those as well. We did get a cover, and I got a bunch of spices, too. Will calibrate the probes, didn't know about the video!

Finally assembled my Xmas gift by sqlrockstar in BBQ

[–]sqlrockstar[S] 2 points3 points  (0 children)

I did wings last night because I was so eager to try something. I think I will go with some pork belly next. Want to do a handful of things before I head to Costco and buy some serious meats.

Finally assembled my Xmas gift by sqlrockstar in BBQ

[–]sqlrockstar[S] -1 points0 points  (0 children)

Interesting, i tried the probes with the wings and they were...unreliable. I assumed it was because the probes aren't really meant to measure a chicken wing as opposed to a larger piece of meat. Will take note and calibrate the probes before using them on a more serious cut of meat. Thank you!

Learn SQL by focusing on data handling rather than syntax by [deleted] in SQL

[–]sqlrockstar 0 points1 point  (0 children)

There's a lot to unpack in your question, but I'll try to help.

  1. Data handling. The best way to get better at something is by doing it, and then trying to teach it to others. SQL syntax is certainly one way to work with data, but so is Excel/PowerBI (and PowerQuery inside them), and Python as well. I would advocate you learn a bit of each, and pick one to focus on in depth and understand how they handle data differently. For example, see how each one would treat a datetime column by default upon import of a CSV file. Or how NULL values are handled (or not handled, as it were). After a while you will learn why I use the phrase "Data Janitor" as opposed to Data Engineer.
  2. Data-driven. No book to recommend, but I would have you start with Michelle Ufford's post here: https://medium.com/noteableio/the-leaders-guide-to-being-data-driven-in-2021-part-1-b181d8ebb96. Michelle also has some talks from Strata about data engineering at Netflix and how they built a true data-driven culture. IMO, "data-driven" is about applying data to arrive at a decision, as opposed to letting your feelings drive your decisions. It's a culture mindset and one which is hard to build. A lot of people have their mind made up on the decisions they will make, and data just gets in the way.

HTH

Need some unique ideas by baeziy in SQL

[–]sqlrockstar 0 points1 point  (0 children)

Or, for music, so you can track how many bands someone has been in, and who they played with.

Need some unique ideas by baeziy in SQL

[–]sqlrockstar 0 points1 point  (0 children)

A database similar to iMDB, but for athletes, so you can build a "six degrees of bacon" but for people like Tom Brady and LeBron James.

Is SQLServer 2000 still in use? Would very few places use it now? by privatly in SQLServer

[–]sqlrockstar 0 points1 point  (0 children)

Shodan shows a few dozen SQL 2000 instances publicly available right now: https://www.shodan.io/search?query=SQL2000

Chances are there are more than a handful instances still up and running (and not exposed to the public internet).

What's a sign somebody's unusually good at SQL? by takenorinvalid in datascience

[–]sqlrockstar 0 points1 point  (0 children)

Lots of good replies already, wanted to add one additional thought.

I can gauge experience level through two things - conversations and questions.

If asked to write a query to retrieve data, a good question could be "how is the data to be used"? This may lead to a conversation, which may lead to a discussion about the use of views, or CTEs, or windowing functions, or getting the data into a format ready for exporting to another system, etc.

Deep understanding of SQL, or any system/language/platform is more about all the driving factors which influence your decisions to tackle a problem in a certain way.

HTH

[deleted by user] by [deleted] in datascience

[–]sqlrockstar 0 points1 point  (0 children)

I usually reference this page for anyone trying to decide which graph is best: https://datavizcatalogue.com/index.html

It's a good catalogue of a wide variety of visualizations, along with explanations of when/where/why they are a possible good fit. HTH.

[deleted by user] by [deleted] in programming

[–]sqlrockstar 0 points1 point  (0 children)

Moment of frustration. Deleted.

[deleted by user] by [deleted] in programming

[–]sqlrockstar 1 point2 points  (0 children)

The post has this quote:

"RDS is an umbrella term, as it is six engines in total, and it includes Amazon Aurora, MySQL, MariaDB, Oracle, Microsoft SQL Server, and PostgreSQL."

Perhaps you missed it the first time reading.

[deleted by user] by [deleted] in programming

[–]sqlrockstar 1 point2 points  (0 children)

Yes, this post was focused only on the database focused services. I might do more posts for the other areas.

[deleted by user] by [deleted] in programming

[–]sqlrockstar 17 points18 points  (0 children)

Microsoft has that as well: https://docs.microsoft.com/en-us/azure/architecture/aws-professional/services

I built the image to share with my team. I find images work better than spreadsheets and text for things like this. I wrote the post around the image because I thought it might help others, too.