Pinned Tweet
Tomas H Johannsson@ThomasHelgi
7 Feb 2021
Take action to prevent #databreach using #SQL. SQL injection breaches are No 1 on the Top10 OWASP list 4th year in a row and likely to remain No 1 fifth year in a row. #Db2 #Oracle #mysql #MariaDB #PostgreSQL #SQLServer x.com/ExpertsExchang…
owasp.org/www-project-to…
Tomas H Johannsson@ThomasHelgi
10 Dec 2019
Take action to prevent #databreach using #SQL. SQL injection breaches are No 1 on Top10 OWASP list 3rd year in a row. #Db2 #Oracle #mysql #MariaDB
0
1
1
Tomas H Johannsson@ThomasHelgi
Mar 16
My recent article has been published : Eliminating Runtime Transformations with Generated Columns and Functional Indexes experts-exchange.com/articles/40855… via @ExpertsExchange
#performance #databases #tuning #Db2 #Oracle #MySQL #MariaDB #PostgreSQL
0
1
1
77
Tomas H Johannsson@ThomasHelgi
Mar 9
Check out this : Maximizing PostgreSQL Throughput through Advanced Partitioning Techniques experts-exchange.com/articles/40845… via @ExpertsExchange

#Postgresql #partitioning #database #performance
0
1
1
62
Tomas H Johannsson@ThomasHelgi
Feb 21
A small article from me on what any data professional actually needs to focus on in an effort to truly thrive in the world of data mining and knowledge extraction. That is, the actual "North Star" for data professionals.
#Data #DataScience #dataengineering #DataAnalytics
Tomas H Johannsson@ThomasHelgi
Feb 20
Know Your Data: The Architectural North Star for Analytics and AI. linkedin.com/pulse/know-you…
1
0
1
38
Tomas H Johannsson@ThomasHelgi
Feb 20
Know Your Data: The Architectural North Star for Analytics and AI. linkedin.com/pulse/know-you…
0
0
0
63
Tomas H Johannsson retweeted
Ovais Tariq
@ovaistariq
6 Sep 2024
Replying to @wottavm
@wottavm @aarondfrancis Here is one of the best resource on indexing for developers: use-the-index-luke.com
0
2
6
754
Tomas H Johannsson@ThomasHelgi
4 Sep 2024
Reached this milestone on EE last month. :)
Always happy to help fellow members at EE.
@ExpertsExchange #mysql #mariadb
0
1
1
88
Tomas H Johannsson@ThomasHelgi
4 Sep 2024
My first video on EE got published. Check it it out. : How Sequence Engine in MariaDB can aid and simplify complex queries in finding missing data and generate test data. experts-exchange.com/videos/80573/H… via @ExpertsExchange @MariaDB
0
1
2
66
Tomas H Johannsson retweeted
Peter Zaitsev
@PeterZaitsev
30 Aug 2024
SQL Injections are alive and well... ian.sh/tsa
2
6
20
2,045
Tomas H Johannsson retweeted
IBM Security
@IBMSecurity
24 Jul 2023
The average cost of a data breach has reached an all-time high of $4.45 million per incident.

Explore the Cost of a Data Breach Report that unpacks the rising costs, along with recommendations to upgrade your #cybersecurity strategy and minimize losses: ibm.biz/BdyVaH
1
39
77
18,820
Tomas H Johannsson retweeted
Craig Mullins - data, Db2, and mainframes@craigmullins
26 Jun 2023
AI is Impacting the Role of the DBA
dbta.com/Columns/DBA-Co…
#DBA #AI
0
1
2
139
Tomas H Johannsson retweeted
Mike Freedman
@michaelfreedman
22 Jun 2023
Today @TimescaleDB is not only for time series, but a powerful platform for all your @PostgreSQL data. 🐘🐯

Dozens of ready extensions at your fingertips, and easily request new ones if needed...
0
7
21
2,517
Tomas H Johannsson retweeted
Percona
@Percona
17 Jun 2023
📣 Calling all #MySQL users! Oracle's MySQL 5.7 support is about to end ⛔

Take advantage of the latest + greatest with MySQL 8.0, and unleash advanced security & optimized performance.

Don't miss out on these key upgrades from @Stoker via @TheNewStack. bit.ly/43foauR
0
3
3
799
Tomas H Johannsson retweeted
Percona
@Percona
16 Jun 2023
📊 Discover how #FinTech companies tackle the challenge of managing increasing #data volumes while optimizing operational costs.

Get valuable insights on data management and cost-efficiency from expert and Percona CEO, Ann Schlemmer. bit.ly/45BKO1Y #OpenSource
0
1
1
500
Tomas H Johannsson retweeted
Craig Mullins - data, Db2, and mainframes@craigmullins
10 Jun 2023
DBAs Need to Know the Essentials of Data Modeling
dbta.com/Columns/DBA-Co…
0
2
6
417
Tomas H Johannsson@ThomasHelgi
7 Apr 2023
#Database Capacity planning and #monitoring is vital DBA task to plan ahead and restructure your database for better #performane as well as backup andrecoverability.
#Mariadb #Db2 #Oracle #MySQL #PostgreSQL
Craig Mullins - data, Db2, and mainframes@craigmullins
7 Apr 2023
#Database Capacity Planning buff.ly/3Db1fFQ
0
0
2
165
Tomas H Johannsson retweeted
Andrés Torres@towerspro
25 Mar 2023
SQL Indexing and Tuning e-Book for developers: Use The Index, Luke covers Oracle, MySQL, PostgreSQL, SQL Server, ... use-the-index-luke.com
0
2
10
1,189
Tomas H Johannsson@ThomasHelgi
16 Mar 2023
Simple but very effective techniques to optimize your #database #performance

#db2 #oracle #mysql #mariadb #postgresql
Craig Mullins - data, Db2, and mainframes@craigmullins
16 Mar 2023
Techniques for Optimizing Database Performance
dbta.com/Columns/DBA-Co…
#databaseperformance #Database
0
0
1
64
Tomas H Johannsson retweeted
Craig Mullins - data, Db2, and mainframes@craigmullins
15 Mar 2023
Lack of Proper Test Data Poses Borrleneck for Software Development
buff.ly/3KLh7DN
0
1
3
164
Tomas H Johannsson retweeted
Craig Mullins - data, Db2, and mainframes@craigmullins
14 Mar 2023
How to Prevent SQL Injection Attacks?
buff.ly/3IQvzrl
0
1
1
94
Tomas H Johannsson retweeted
Modern SQL@ModernSQL
24 Jan 2023
The WITH clause allows you to write more literate SQL.

Meanwhile supported by most SQL dialects.

modern-sql.com/use-case/liter…
Literate programming is an approach to programming introduced by Donald Knuth that, among other ideas, aims to arrange source code in order of human logic so that it can be understood by reading it like a novel: from the beginning to the end. SQL works in the opposite way: due to the nesting of subqueries we must find and understand the innermost query and then start working from inside out. Not even well-chosen names can improve the recursive reading process notably because names follow the subqueries in SQL. Even the order of clauses in the simplest query has a forward dependency: the meaning of the select clause depends on the from clause. That actually poses an unsolvable problem for development tools: when typing select, it is not yet know which tables are accessed and it is therefore also unknown which columns are visible. Without from no sensible code completion for select. SQL:1999 introduced an alternative to the nesting at least: the with clause.
0
11
46
6,218
Load more