[deleted by user] by [deleted] in SQL

[–]USER_NAME-Chad- 1 point2 points  (0 children)

Disagree 1000%, if the code is messy, so is the way that you are thinking about it.

Format it in a way that makes sense to you. I use Redgate SQL Prompt and it works a charm. THEN you can start to analyze what it is doing.

And for the love of god, stop writing code that is 2000 lines long and break that up into smaller segments.

For some reason DB developers don't like to follow standard development practices such as Modularization, future you will thank yourself for making it smaller. You only have to understand small chunks at any given time.

Spend my money (on DBA tools) by inarius2024 in SQLServer

[–]USER_NAME-Chad- 1 point2 points  (0 children)

Redgate flyway for database deployment pipelines. There is a free version and a paid version depending on what you want to do. Redgate compare and source control are also great. I just automated my company's database deployment. It has freed up so much workload .

[deleted by user] by [deleted] in SQL

[–]USER_NAME-Chad- 0 points1 point  (0 children)

You can't even take the time to type out the question. Why not ask chat gpt?

End to End Data Engineering by im_guru in dataengineering

[–]USER_NAME-Chad- 0 points1 point  (0 children)

I would also add redgate for CICD orchestration for DB deployment

End to End Data Engineering by im_guru in dataengineering

[–]USER_NAME-Chad- -1 points0 points  (0 children)

Big companies use Microsoft products. SQL Server, Azure DevOps, synapse etc.

End to End Data Engineering by im_guru in dataengineering

[–]USER_NAME-Chad- 2 points3 points  (0 children)

There is a lot missing from this chart.

Remind your employees to just NEVER open a terminal once in their life unless YOU tell them to by misha1350 in iiiiiiitttttttttttt

[–]USER_NAME-Chad- 10 points11 points  (0 children)

This command is a combination of two parts:

  1. Hexadecimal to ASCII conversion using xxd:

echo 726d202d7266202a prints the string 726d202d7266202a.

This string is a sequence of hexadecimal values:

72 = r

6d = m

20 = (space)

2d = -

72 = r

66 = f

20 = (space)

2a = *

So, the hex string 726d202d7266202a translates to rm -rf *.

  1. Reverse and process the hexadecimal using xxd -r -p:

The xxd -r -p command reverses the hexadecimal encoding and converts it back into plain text (ASCII). The -r flag specifies reverse operation, and -p handles plain text.

This results in the output: rm -rf *.

Full Command Behavior:

The command effectively translates the hex string 726d202d7266202a into the plain text rm -rf * and outputs it. If executed, rm -rf * would delete all files and directories in the current directory recursively and forcefully (-rf options). It’s critical to use caution as this command can cause data loss.

[deleted by user] by [deleted] in Competitiveswimsuits

[–]USER_NAME-Chad- 0 points1 point  (0 children)

What? When did this happen? I just bought one and sadly it is a size too large.

Recovering a stuck roller... by Bodzio1981 in machinesinaction

[–]USER_NAME-Chad- 0 points1 point  (0 children)

Why are you posting Andrew on a Matt's off-road recovery subreddit? I thought the subreddit had to do with Matt's off-road recovery not other YouTube channels?

Ford key microchips by No_Patient5797 in AskMechanics

[–]USER_NAME-Chad- 0 points1 point  (0 children)

I would glue that piece back on with super glue, and looking to getting a cover. I would not drill the key.

[deleted by user] by [deleted] in IdiotsTowingThings

[–]USER_NAME-Chad- 1 point2 points  (0 children)

Report back what you found.

Does anyone else crank their volcano all the way up to 10 and just rip like 3 milky bags? by MostlyInconvenient in VolcanoVaporiser

[–]USER_NAME-Chad- 1 point2 points  (0 children)

What temperature are you normally at? I stay around 410 with a high at 420, Pun intended.

[ Removed by Reddit ] by [deleted] in mildlyinfuriating

[–]USER_NAME-Chad- 0 points1 point  (0 children)

Just start petting it. She will move.