#sql

jirikiha@diasp.org

Oof.
A new dev wrote a procedure. I think they may have broken every best practice I'm aware of for a short #SQL report procedure.
Columns in a nonsensical order, temp tables galore each holding maybe a single row of data, hitting the database for every UPDATE instead of collecting the data needed into a local table and working from that...
I think I'll suggest one improvement and refer them to an article on SQL best practices. They need to improve, but at the same time I don't want them to get discouraged while learning.
Also, the procedure works. So there's that.
Looking at the output, it needs some adjustment before it'll be usable for an SSRS template to ingest it.
I'm going to be busy for a bit tonight...

waynerad@diasp.org

Airsequel claims to use AI prompts to generate SQL databases for you, make a GraphQL API, make a Spreadsheet UI, generate cloud functions, by which they mean TypeScript and Python code to run on cloud servers, and generate dashboards for visualization of your data.

"Airsequel automatically generates a complete GraphQL API and provides a spreadsheet UI, a SQL workbench, cloud functions, and a dashboard builder for your SQLite databases and CSV files."

"Utilize AI to effortlessly generate SQL queries. Simplify data retrieval and elevate your analytics with minimal manual input."

One interesting bit is that they make SQLite databases. The SQL can probably be easily adapted for other databases. I use SQLite for a ton of stuff, so it's interesting to see other people sticking up for it. Why SQLite? They say:

"SQLite is the most deployed database for good reason: It's fast, stable, self-contained, highly reliable, fully-featured, supported until at least 2050, and the only database recommended by the US Library of Congress for long-term archival."

Airsequel

#solidstatelife #ai #genai #databases #sql

jirikiha@diasp.org

Tried to get ChatGPT to write a #SQL update query for me. About 100 lines of repetitive code.
It gave me the first three and
-- Do the same for the rest of the lines
Realized I could have Excel write the query for me instead. Only took a couple minutes and done!
Later I realized I could tell GPT to give me the full query, but Excel was still faster.
Eventually GPT will do almost everything but for now sometimes Excel is still a better tool.

jirikiha@diasp.org

Huh, I've gotten a little too comfortable with the small test sites and forgot about a simple update to make SQL procedures much faster.
CREATE TABLE #tblOutput
instead of DECLARE @tblOutput TABLE
For larger datasets, the temp table outperforms the table variable by a significant margin. From minutes to less than a second in my case. Hopefully, I'll remember next time.
#SQL

tina@diaspora.psyco.fr

— Sorry, you have been blocked. You are unable to access CHARLIEHEBDO.FR.

— Heing ?..._ oO'

— This website is using a security service to protect itself from ONLINE ATTACKS.

— Eh, oh, les gars... Faut arrêter de sniffer la choucroute. Je jette oeil chez vous, allez... trois fois par an. Vous vantez pas.

#flip #flip-numérique #SQL #je-suis-Nono-le-petit-robot

virtual7@pod.dapor.net

A Day in a Life as a Business Intelligence Developer

with Gerhard Höll

Many paths lead to the goal if you want to become a Business
Intelligence Developer. There is no defined route, much more important
is the fun and enthusiasm for this job. Gerhard has always been
interested in the BI environment and enjoyed working in it the most. In
his studies in Business Informatics, he got to know the whole range of
BI, from Business Intelligence to Data Warehousing and Data Analytics.
In his role as Recruiting Support, he can give you important tips about
his job that can increase your chances of landing your dream job.

::: {.wp-block-spacer style="height: 15px;"}
:::

Are there any main tasks that arise on a daily basis?

That depends on the project. As a developer, not really, apart from the
coordination rounds within the development team.  I am currently
involved in a project in which I have contact with the business side,
DWH operations and the developers of the source system. In this project,
the entire spectrum of data warehouse development is covered -- from
requirements gathering to development and operation. We look at making
sure the data warehouse is running smoothly and that up-to-date data is
being delivered daily for users to work with. When you come in after
your morning coffee, the first task that comes up is to see if the load
runs have gone correctly. It is important that the business users can
work with the BI and DWH system.

::: {.wp-block-spacer style="height: 15px;"}
:::

{.wp-image-58454
width="1024" height="683"}

::: {.wp-block-spacer style="height: 0px;"}
:::

What influence do you have on the customer's work?

Efficiency and benefit should always be at the priority to make sure
that the customer gets the most value from what we do. You can avert or
recommend various things that can harm or benefit the system. In this
way you can influence customers in their decisions. In the area of
evaluations and graphical presentations, you also have influence on the
use of the various presentation options. The goal is always to recognize
facts and contexts more quickly through the evaluations in order to gain
new insights.

::: {.wp-block-spacer style="height: 0px;"}
:::

What do you enjoy the most?

The best part of my job is dealing with issues together with my
colleagues and finding solutions together. You are involved in exchanges
and coordination on a wide variety of topics. Both at the customer's
site and with colleagues at virtual7.  It is always a welcome change to
work together with other people and not just to develop in a quiet room.
Of course, that also has to be done, but the variety and interaction is
crucial for me here.

::: {.wp-block-spacer style="height: 0px;"}
:::

Which skills are essential for a job at virtual7?

The requirements are first of all of a technological nature, of course.
Since we work with Oracle products, you should be familiar with Oracle
technologies. These include: The Oracle Database, SQL and PL/SQL, Oracle
Data Integrator and Oracle Analytics Server. You will also need to be
familiar with the methods to create data warehouse architectures and
models, dashboards and analytics. Since we are always working with
different people and teams, soft skills are just as important, if not a
bit more important. Communication is especially important here. You have
to be able to ask the right questions. Likewise, being able to present
and explain complicated issues in a simple way. The knowledge level and
perspectives of individuals on different aspects can vary greatly, so
you need to have an understanding and background knowledge of the
project and the subject area. It is not always easy to get everyone
involved on the same page. Apart from that, you need to be a team player
and be able to organize yourself in your team. As a developer you always
need a good grasp and analytical thinking, as well as convincing
presentation skills.

::: {.wp-block-spacer style="height: 0px;"}
:::

{.wp-image-58453
width="1024" height="683"}

::: {.wp-block-spacer style="height: 0px;"}
:::

Is Oracle a must have to work for us?

Our clients make it a point to see in resumes that you have experience
with Oracle. So hard facts: X/Y years of Oracle experience. Everything
that is Oracle-specific about the tools can be learned quickly.
Methodological knowledge in the data warehouse and BI environment are
much more important in our projects. You should know modeling approaches
and how to represent certain facts and justify them. It is important to
be honest about your experience, this will bring you and us much further
than a pimped CV.

::: {.wp-block-spacer style="height: 0px;"}
:::

Good to know that...
  • virtual7 likes to celebrate successes together.
  • the job is not just a consulting assignment, but a safe place to work for several years.
  • you mainly work at the customer's and can also do a lot at virtual7.
  • team building is huge internally, be it at the conference, chat 'n' chills or meet-ups.
  • you can be yourself and (almost) everything is informal.

Der Beitrag <strong>A Day in a Life as a Business Intelligence
Developer</strong>

erschien zuerst auf virtual7 GmbH - Blog.

https://blog.virtual7.de/a-day-in-a-life-as-a-business-intelligence-developer/

#virtual7 #digitalisierung #deutschland #virtual #digitalezukunft #digital #zukunft #agile #virtual7gmbh #BI #job #Oracle #Recruiting #SQL

jirikiha@diasp.org

Have to use STUFF because this server doesn't support STRING_AGG available in 2017 and later. The table join is... difficult. I should do some #SQL lessons.