Markus Winand
@MarkusWinand
Followers
9K
Following
7K
Media
294
Statuses
7K
SQL Renaissance Ambassador. Author, Trainer, Coach. PhD in Common Sense. Creator of https://t.co/6oKhq87B43 and https://t.co/RrIy2AY7Tl.
Vienna, Austria
Joined August 2010
Teaching is about making students reach the same level of understanding as the teacher—but with less mental effort. This allows students to put their mental efforts into growing beyond their teachers.
0
18
133
GROUP BY ALL Very popular, not yet standard but set to become standard. Also expected for PostgreSQL 19. https://t.co/8oqau6wQJp
modern-sql.com
Automatically put non-aggregate SELECT items into GROUP BY clause
0
2
4
At least it's not dying without notice: Apache Derby is retired. https://t.co/YwXgPQdbJj Below: Poll if people would miss Derby on https://t.co/DbUylcUDcg (not even a year ago).
modern-sql.com
SQL has evolved. Beyond the relational model. Discover it now.
Would you miss Apache Derby when I would remove it from the charts on https://t.co/DbUylcUDcg?
0
3
3
Oracle 26ai¹ was released yesterday. Noteworthy SQL addition: QUALIFY. https://t.co/RoZo63LY47 I bet this starts an avalanche (there are already PostgreSQL patches). ¹ 26ai is the marketing version, 23.26.0 is the technical version.
modern-sql.com
QUALIFY: filter rows based on window functions
3
5
14
My favorite change is that MariaDB got an improved "WHERE year(...) = ?" rewriting. https://t.co/9liw4kyyp4 In picture: the green check mark used to be yellow, with the "a" footnote: Unconditionally rewritten—even if only a matching function-based index exists
0
1
5
Do you live in New Jersey? We're looking for motivated people to take online Cybersecurity classes 👇Click below to request info about earning your Cybersecurity degree
33
72
361
After being « gone fishin' » during summertime I just updated my website for the releases that happened during that time: * MariaDB 11.8 and 12.0 * Oracle 23.9 * Db2 12.1.2 All charts on https://t.co/j7tt9vJVKd and https://t.co/LANd9rXpC7 are updated.
use-the-index-luke.com
SQL indexing and tuning tutorial for developers. No unnecessary database details—just what developers need to know. Covers all major SQL databases.
1
7
21
Hallo Wien, Das ViennaDB Meetup findet im klimatisierten Office statt ;) Spannende Vorträge über Datenbanken, wie man sie loswird und wie man selbst eine macht. Heute ab 18:30, nähe Praterstern. https://t.co/9Q29rG1Qf8
meetup.com
[As an exception, our next meetup will be held in German] Am Montag, dem 23. Juni, ist es (schon) wieder so weit. In drei Vorträgen geht es um Datentypen, das Leben ohne D
0
1
6
Nächsten Montag bei ViennaDB: Braucht man denn überhaupt eine Datenbank? Hinken RDBM-Systeme anderen Sprachen hinterher? Wofür opfert man seinen Schlaf? Drei Praxis-Vorträge, nähe Praterstern. Kostenlose Anmeldung zwecks Planung erwünscht:
meetup.com
[As an exception, our next meetup will be held in German] Am Montag, dem 23. Juni, ist es (schon) wieder so weit. In drei Vorträgen geht es um Datentypen, das Leben ohne D
0
1
1
Das nächste ViennaDB meetup steht an. Diesmal deutsch, mit drei super Vorträgen. Kostenlose Anmeldung erforderlich. https://t.co/9Q29rG1ipA
meetup.com
[As an exception, our next meetup will be held in German] Am Montag, dem 23. Juni, ist es (schon) wieder so weit. In drei Vorträgen geht es um Datentypen, das Leben ohne D
0
0
3
@MarkusWinand I wrote a tool that does this for Postgres:
github.com
Open PostgreSQL relation files in a hex editor with tags and annotations - petergeoghegan/pg_hexedit
0
2
6
Laetitia Avrot: > I am announcing my resignation from my position as treasurer of our association, effective immediately. It's not even saying "for private reasons". IMHO, something went terribly wrong (and might continue to go wrong). Change my mind. https://t.co/Ct4thjPOw2
postgresql.org
Dear PostgreSQL Europe members, I am announcing my resignation from my position as treasurer of our association, effective immediately. During …
1
0
3
On April 7th, we will have a ViennaDB meetup with talks about ClickHouse & Exasol. Free registration required (limited seats): https://t.co/uBxYWxAX8B
meetup.com
Our next meetup is long overdue! So let's meet on Monday, April 7th for talks about ClickHouse and Exasol. Doors open at 18:30, talks start at 19:00. **Location & Food**
0
1
7
Just updated https://t.co/xcQW5xMJX0 and https://t.co/Bk1fXje2hj for MariaDB 11.7. One enhancement is the FROM-clause column renaming, as described in this article:
modern-sql.com
Rename(alias) columns in the SQL FROM clause
0
2
10
A Christmas present for SQL standard lovers? Part 1 is available for free again. https://t.co/bzVCF4la5w The last edition that was available for free was 2011, AFAIK. And that disappeared when 2016 was released. Merry Christmas :)
1
21
38
Opportunities don’t wait for cash flow. Fundwell makes it easy to secure $25K–$5M fast, so your business can say yes when it matters most.
0
1
0
Software developers should know about infinite loops.
1
1
7
ChatGPT & Co is the real “ministry of truth”. Their output is copied unvalidated to 1000s of websites poisoning the collective memory of mankind.
1
4
14
Survey on performance optimization for database systems (2023) https://t.co/hZu8wWoEJy
researchgate.net
PDF | The performance optimization of database systems has been widely studied for years. From the perspective of the operation and maintenance... | Find, read and cite all the research you need on...
0
5
15
“adding an index on a table that already has data is not supported yet” That’s a DSQL error message. Well, it’s in preview.
Is Aurora DSQL a SQL database that scales like DynamoDB, or is it a DynamoDB that offers many SQL features? Let's examine this from a developer's perspective. https://t.co/eqNl5a1i6X
3
1
23
This is what 30 minutes a day adds up to💰
0
222
7K
Some SQL-Systems can rewrite expressions such as YEAR(dt_col) = 2024 into range conditions. I've made my typical matrices about that: https://t.co/9liw4kyyp4 Also note: Only the mailing list gets the full content of the articles. The web-version is basically just the matrices.
use-the-index-luke.com
Some systems convert expressions like EXTRACT(YEAR FROM COL) = 2024 into a range condition.
The scraping of content for AI training makes some changes required. I'll publish less on my website and RSS feed. The mailing lists will probably stay the same for the time being. If you want to still get everything, subscribe here: https://t.co/sWsaCfYwDw
0
3
11
The scraping of content for AI training makes some changes required. I'll publish less on my website and RSS feed. The mailing lists will probably stay the same for the time being. If you want to still get everything, subscribe here: https://t.co/sWsaCfYwDw
winand.at
Technical details about SQL and SQL performance as well as strategic insights.
0
2
6