List: SQL Stuff | Curated by Luchiana Dumitrescu

Jan 7, 2024
18 stories
4 saves
SQL Stuff
Luchiana Dumitrescu
Revolutionize Efficiency: Unleash the Potential of Automated Processes through Stored ProceduresIn our modern hectic world, the quest for efficiency has led everyone to seek automation eagerly. From mundane and repetitive tasks to…
Jan 7, 2024
Jan 7, 2024
Luchiana Dumitrescu
Three games for a fun SQL learning experienceBefore exploring the rest of the article, we need to have an idea of what SQL is.
Feb 16, 2023
Feb 16, 2023
Luchiana Dumitrescu
Modeling isn’t just for clay, it’s also for dataGenerally, when we hear about modeling, our mind thinks of clay modeling, but it’s not really like that. In the world of data management…
Feb 26, 2023
Feb 26, 2023
In
Women in Technology
by
Luchiana Dumitrescu
Data model tools — work once and be praised twiceIn a previous article, I talked about data modeling and its importance in the data management process (read it here: link).
Mar 5, 2023
Mar 5, 2023
Luchiana Dumitrescu
Dynamic SQL —keep the mystery till running itWhoa, dynamic SQL? When did SQL become dynamic?
Mar 13, 2023
Mar 13, 2023
In
Women in Technology
by
Luchiana Dumitrescu
Dynamic SQL: The Double-Edged Sword — How to Harness its Power Without Getting Stabbed by SQL…We tend to love dynamic things for the flexibility and performance they give us; as discussed in my previous article (check here for it)…
Mar 21, 2023
Mar 21, 2023
In
Women in Technology
by
Luchiana Dumitrescu
Dynamic SQL and JSON — an amazing pairing for modern web applicationsWhenever we want to create an amazing web application that communicates with the database, most probably we will use APIs to ensure the…
Mar 29, 2023
Mar 29, 2023
Luchiana Dumitrescu
Unlock the second great superpower of the JSON-SQL team: How to generate JSON from SQLIn a previous article, we explored one of the superpowers of the JSON-SQL team, which was parsing a JSON string into SQL (you can find the…
Apr 8, 2023
Apr 8, 2023
In
Women in Technology
by
Luchiana Dumitrescu
Dynamic SQL Select: A Flexible Solution for Querying Data with Dynamic SchemaWe usually tend to use the wildcard character (*) when we want to select all the columns from a table, but we’re not fully aware that this…
Apr 29, 2023
Apr 29, 2023
Luchiana Dumitrescu
SQL Server metadata: Unlock the black box of your database schemaDo we need a fortune teller, like the men in the picture above, when we have metadata? Oh course not, we already have everything we need to…
May 21, 2023
May 21, 2023
Luchiana Dumitrescu
Error Handling in MS SQL Server: Don’t let anything slip through your fingersHave you ever been lost in a city and asked a local for directions and they couldn’t help you?
May 28, 2023
May 28, 2023
Luchiana Dumitrescu
Boosting database performance — use batch data transfer79 zettabytes in 2021 to 120 zettabytes in 2023 (at least this is the expected volume of data by the end of this year)… sound familiar? If…
Jun 24, 2023
Jun 24, 2023
In
Women in Technology
by
Luchiana Dumitrescu
XML Generation Made Easy: How to Use SSMS for Quick and Accurate ResultsXML (eXtensible Markup Language) is one of the most used file formats tailored for storing and exchanging data between different systems…
Jul 17, 2023
Jul 17, 2023
Luchiana Dumitrescu
Database Indexing: Enhancing Query Performance for Efficient Data RetrievalWe produce and consume data every second, so this fact isn’t any more a surprise, so welcome again to a crazy data-driven world!
Aug 1, 2023
Aug 1, 2023
In
Women in Technology
by
Luchiana Dumitrescu
Table vs.View — The unnoticed database wrestling matchAre you looking to enter the database world? Beware of the fierce competition that often goes unnoticed. Two intimidating opponents are at…
Sep 17, 2023
Sep 17, 2023
In
Women in Technology
by
Luchiana Dumitrescu
Stored Procedures vs. Functions: The right tool for the jobWhen working on or developing a database, you’re akin to a craftsman selecting the perfect tool from a well-organized toolbox. In the realm…
Sep 24, 2023
Sep 24, 2023
In
Women in Technology
by
Luchiana Dumitrescu
Decoding Database Discrepancies: How to compare table structures across different databasesDid you know that data migrates at a particular time like birds do during the cold season? However, data migration occurs much less…
Oct 8, 2023
Oct 8, 2023
In
Women in Technology
by
Luchiana Dumitrescu
Maximizing SQL Performance: Choosing Between Cursors and While LoopsIf you’re not a Medium member, you can still enjoy the full article for free. Click here to read it all 😊
May 8, 2023
1
May 8, 2023
1