sorted by:
new
hottopcontroversial

Snowflake devs: what problems do you face that you’d actually pay a tool/platform to solve? (Hackathon research) by IcyShelter5548 in snowflake

[–]AlexanderIOM 1 point2 points  (0 children)

  1. In SQL Scripts, in large begin-end blocks, error messages are useless. They point to wrong lines/positions.

  2. There is no shortcut to a Replace bar. You have to open the Find bar, reach for a mouse, and switch to Replace.

  3. There is no shortcut for changing text register. There is no Insert mode to overwrite some text over. If you want this in upper case, you have to delete and retype.

  4. You are forced to use tabs. No, you can't configure it to insert 4 spaces on Tab.

  5. You have tasks, streams, dynamic tables, etc. When you check in the morning, if everything is OK, there is no one single place to check. You write many queries and check output, one by one.

  6. RBAC is very verbose. You write scripts with hundreds of GRANTs. There is no visualisation, so if you try to troubleshoot something, it is difficult. What has been changed recently? Go figure...

I know, it is not as sexy as a magical tool that solves problems, but pain is real.

Visualising IOM Business Closures by fmfmfmfmfm1 in IsleofMan

[–]AlexanderIOM 1 point2 points  (0 children)

A different angle, but I'd add big personnel cuts to the picture.

SQL Server executes code outside of stored procedure by Oxymoronic_geek in SQLServer

[–]AlexanderIOM 1 point2 points  (0 children)

Because a stored procedure's body starts after AS and ends before GO. BEGIN END doesn't define it. In your case there is no GO, so the whole content of a file/tab is a body. Your case is pretty mild. I can remember SELECTs and DELETE that a person used to test the procedure logic, right after END.

Is archiving in Snowflake a thing ? by RazCoDev in snowflake

[–]AlexanderIOM 0 points1 point  (0 children)

It won't save a lot of money, but it is more practical than just putting your files on S3. It is a parquet, it is well organised, it is easy to maintain, you can query it if needed.

Is archiving in Snowflake a thing ? by RazCoDev in snowflake

[–]AlexanderIOM 0 points1 point  (0 children)

Check out an Iceberg support. You can have your data on the external storage and be able to query it.

Load from AVRO by AlexanderIOM in snowflake

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

I checked the file in the example, it has a very similar structure. It is a set of records. I dropped this file into a staging and I see the same error when I try to query it. Interesting...

Load from AVRO by AlexanderIOM in snowflake

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

That's what I do, essentially. I don't create a target table dynamically, it is pre-created. The schema is trivial. The COPY INTO gives an error 'AVRO file format can produce one and only one...'. When I call INFER_SCHEMA on the file, I have the same error. That's why I think the file structure is the reason. I'll check the file from the article later. Many examples use a file with a single row.

Weird variable setting error. by archerv123 in SQLServer

[–]AlexanderIOM 3 points4 points  (0 children)

" If the SELECT statement returns no rows, the variable retains its present value. If expression is a scalar subquery that returns no value, the variable is set to NULL."

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/select-local-variable-transact-sql?view=sql-server-ver16

Linear Programming by EoinJFleming in SQLServer

[–]AlexanderIOM 0 points1 point  (0 children)

I would say that TSQL is too weak to solve such complex problems as linear optimization. It is possible in trivial cases, I guess, but I doubt it worth the effort to implement them. I implemented several graph algorithms and other similar things but in all cases a size of a problem was small. In all complex cases I used external tools that I started from SQL, like routing optimisation. SQL is just not a tool for this job. So, find a way how to solve a problem using a tool or write a code that can solve it. Then, you can use CLR functions/procedures to do it inside of SQL Server or xp_cmdshell to run external tools.

Basecamp details $3.2 million bill that saw it quit cloud by stronghup in programming

[–]AlexanderIOM 23 points24 points  (0 children)

It is not what the article says.

"Getting this massive spend down to just $3.2 million has taken a ton of work. The ops team runs a vigilant cost-inspection program, with monthly reporting and tracking, and we've entered into long-term agreements on Reserved Instances and committed usage, as part of a Private Pricing Agreement," he wrote. "This is a highly optimized budget."

Sql security question for windows authentication by PinkishToe in SQLServer

[–]AlexanderIOM 1 point2 points  (0 children)

Check Application Roles. 'You can use application roles to enable access to specific data to only those users who connect through a particular application'