What You Should Know About Table Partition Pruning

Table partitioning is a very handy feature supported by several databases, including PostgreSQL, MySQL, Oracle, and YugabyteDB. This feature is useful when you need to split a large table into smaller independent pieces called partitioned tables or partitions. If you’re not familiar with this feature yet, consider the following simple example. Let’s pretend you develop … Read more

sql server – Exporting data to Excel with multiple worksheets from MS SQL Database through vb.net

My task is to import the data from the test_import table into multiple sheets of the same excel workbook. What I am trying to achieve is to fill up specific cells in the selected sheet with selected data columns that I have in my MS SQL database through VB.NET. I am currently undergoing my internship … Read more

SQL Database Schema: Beginner’s Guide

What Is a Database Schema? That’s actually a bit of a difficult question to answer! Like many database terms, database schema gets used in a variety of contexts. Depending on the context, it can mean different things. In the context of generally discussing a database and how it’s organized, the term database schema describes the … Read more

sql server – Convert JSON data to T-SQL

I am new to SQL Server querying and need some help with querying the following JSON file in T-SQL. This is my JSON: { “12”: “GUARDIAN COURT”, “13”: “”, “14”: “”, “15”: “FERRES STREET”, “16”: “HEREFORD”, “17”: “”, “18”: “HR1 2LP”, “19”: “20001”, “20”: { “20[1_Asbestos_ID]”: “2000131/2”, “20[<Row_2>2<Col>Asbestos_ID]”: “2000132/3”, “20[<Row_3>3<Col>Asbestos_ID]”: “2000132/1”, “20[<Row_4>4<Col>Asbestos_ID]”: “2000135/3”, “20[<Row_5>5<Col>Asbestos_ID]”: “2000135/1”, … Read more

Blind SQL Injection — Threat or Child’s Play?

One of the primary issues in the database world is SQL injection – it’s prevalent to such an extent that even OWASP continuously lists it as the #1 threat targeting web applications. SQL injection can have many types, and one of these types is blind SQL injection – in this blog post, we will go … Read more

Blind SQL Injection — Threat or Child’s Play? | by Arctype | Jun, 2022

Blind SQL injection is a type of SQL injection where an attacker cannot figure out how our web applications “think” One of the primary issues in the database world is SQL injection — it’s prevalent to such an extent that even OWASP continuously lists it as the #1 threat targeting web applications. SQL injection can … Read more

Go and SQL: Pitfalls With Existing Libraries (and a Better Solution) | by Vinícius Garcia | Jun, 2022

Meet KSQL — A library I wrote to address the problems of Golang and SQL Photo by Chinmay Bhattar on Unsplash In my years working with Golang, I came to the conclusion that working with SQL is not a well-solved problem yet. The libraries that we have available are just not easy to use and … Read more

Five Tips to Fasten Skewed Joins in Apache Spark

Joins are one of the most fundamental transformations in a typical data processing routine. A Join operator makes it possible to correlate, enrich and filter across two input datasets. The two input datasets are generally classified as a left dataset and a right dataset based on their placement with respect to the Join clause/operator. Fundamentally, … Read more

JIT Compilation of SQL in NoSQL

Hi everyone! My name is Georgy Lebedev, and I’m a part of Tarantool’s kernel development team. In 2021, we participated in the Google Summer of Code (GSoC) for the first time: one of the proposed projects was migration of SQL from VDBE to a JIT platform — that’s where my journey in Tarantool began. Having … Read more

Dealing With Slow SQL Queries? Let the “EXPLAIN” Statement Handle It | by Max | Jun, 2022

Understand EXPLAIN query plans (part 1 of 2) Photo by Markus Winkler on Unsplash Have you ever had a slow-running SQL query but you weren’t sure where to even start looking for optimizations? If only there was some way to pinpoint exactly which parts of your query were causing the whole thing to run slow, … Read more