nerdculture.de is one of the many independent Mastodon servers you can use to participate in the fediverse.
Be excellent to each other, live humanism, no nazis, no hate speech. Not only for nerds, but the domain is somewhat cool. ;) No bots in general. Languages: DE, EN, FR, NL, ES, IT

Administered by:

Server stats:

1.2K
active users

#database

30 posts14 participants3 posts today
CBC British Columbia<p>B.C. police misconduct allegations that have been substantiated now available in public database<br>B.C.’s police watchdog says its intended to provide information to the public and increase consistency in disciplinary measures.<br><a href="https://mastodon.hongkongers.net/tags/police" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>police</span></a> <a href="https://mastodon.hongkongers.net/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://mastodon.hongkongers.net/tags/misconduct" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>misconduct</span></a> <a href="https://mastodon.hongkongers.net/tags/BC" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>BC</span></a> <a href="https://mastodon.hongkongers.net/tags/News" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>News</span></a> <a href="https://mastodon.hongkongers.net/tags/Canada" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Canada</span></a><br><a href="https://www.cbc.ca/news/canada/british-columbia/bc-police-misconduct-database-1.7499656?cmp=rss" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">cbc.ca/news/canada/british-col</span><span class="invisible">umbia/bc-police-misconduct-database-1.7499656?cmp=rss</span></a></p>
Pierre Lindenbaum<p>🇫🇷 INBOX: "Nous avons été sollicité hier soir par le ministère pour identifier d'urgence une liste de bases de données, critiques pour nos activités de recherche, qu'il faudrait "back-uper". Avez-vous des suggestions ? "</p><p> <a href="https://genomic.social/tags/france" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>france</span></a> <a href="https://genomic.social/tags/Science" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Science</span></a> <a href="https://genomic.social/tags/BackupPlan" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>BackupPlan</span></a> <a href="https://genomic.social/tags/Backup" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Backup</span></a> <a href="https://genomic.social/tags/usa" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>usa</span></a> <a href="https://genomic.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a></p>
💧🌏 Greg Cocks<p>Critical Minerals In Ores (CMiO) Database<br>--<br><a href="https://lnkd.in/gynRjUfn" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">lnkd.in/gynRjUfn</span><span class="invisible"></span></a> &lt;-- shared USGS publication<br>--<br><a href="https://lnkd.in/gETca3DQ" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">lnkd.in/gETca3DQ</span><span class="invisible"></span></a> &lt;-- shared link to open data database, web map services, etc<br>--<br><a href="https://portal.ga.gov.au/persona/cmmi" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">portal.ga.gov.au/persona/cmmi</span><span class="invisible"></span></a> &lt;-- shared web map<br>--<br><a href="https://lnkd.in/gdmMp2zg" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">lnkd.in/gdmMp2zg</span><span class="invisible"></span></a> &lt;-- shared editorial piece on critical minerals and geopolitics<br>--<br><a href="https://techhub.social/tags/geology" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>geology</span></a> <a href="https://techhub.social/tags/fedscience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>fedscience</span></a> <a href="https://techhub.social/tags/opendata" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opendata</span></a> <a href="https://techhub.social/tags/CMMI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CMMI</span></a> <a href="https://techhub.social/tags/CMiO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CMiO</span></a> <a href="https://techhub.social/tags/criticalminerals" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>criticalminerals</span></a> <a href="https://techhub.social/tags/minerals" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>minerals</span></a> <a href="https://techhub.social/tags/ores" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ores</span></a> <a href="https://techhub.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://techhub.social/tags/opendata" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opendata</span></a> <a href="https://techhub.social/tags/GIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>GIS</span></a> <a href="https://techhub.social/tags/spatial" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>spatial</span></a> <a href="https://techhub.social/tags/mapping" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mapping</span></a> <a href="https://techhub.social/tags/spatialanalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>spatialanalysis</span></a> <a href="https://techhub.social/tags/commodities" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>commodities</span></a> <a href="https://techhub.social/tags/technology" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>technology</span></a> <a href="https://techhub.social/tags/components" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>components</span></a> <a href="https://techhub.social/tags/geochemistry" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>geochemistry</span></a> <a href="https://techhub.social/tags/deposits" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>deposits</span></a> <a href="https://techhub.social/tags/mining" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mining</span></a> <a href="https://techhub.social/tags/extraction" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>extraction</span></a> <a href="https://techhub.social/tags/classifaction" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>classifaction</span></a> <a href="https://techhub.social/tags/nomenclature" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>nomenclature</span></a> <a href="https://techhub.social/tags/environments" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>environments</span></a> <a href="https://techhub.social/tags/structuralgeology" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>structuralgeology</span></a> <a href="https://techhub.social/tags/exploration" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>exploration</span></a> <br>@USGS | @GeoscienceAustralia | @GeologicalSurveyOfCanada</p>
Wulfy<p><span class="h-card" translate="no"><a href="https://mas.to/@PrivacyDigest" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>PrivacyDigest</span></a></span> </p><p>YES!</p><p>FINALLY!</p><p>RESPONSIBLE <a href="https://infosec.exchange/tags/SYSADMIN" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SYSADMIN</span></a> DELETES THEIR <a href="https://infosec.exchange/tags/DATABASE" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DATABASE</span></a> WHEN THE FASCISTS TAKE OVER !!!</p>
PrivacyDigest<p><a href="https://mas.to/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenSource</span></a> <a href="https://mas.to/tags/Genetic" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Genetic</span></a> <a href="https://mas.to/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> Shuts Down to Protect Users From 'Authoritarian Governments'<br> <br>"The risk/benefit calculus of providing free &amp; open access to individual <a href="https://mas.to/tags/genetic" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>genetic</span></a> data in 2025 is very different compared to 14 years ago."<br><a href="https://mas.to/tags/privacy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>privacy</span></a> <a href="https://mas.to/tags/dna" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dna</span></a> </p><p><a href="https://www.404media.co/open-source-genetic-database-opensnp-shuts-down-to-protect-users-from-authoritarian-governments/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">404media.co/open-source-geneti</span><span class="invisible">c-database-opensnp-shuts-down-to-protect-users-from-authoritarian-governments/</span></a></p>
Pierre Lindenbaum<p>asking for a friend: do you know any database/framework to visualize RNAseq data ? (just like <a href="https://github.com/broadinstitute/gnomad-browser" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/broadinstitute/gnom</span><span class="invisible">ad-browser</span></a> for WGS)</p><p><a href="https://genomic.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://genomic.social/tags/rnaseq" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rnaseq</span></a> <a href="https://genomic.social/tags/bioinformatics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>bioinformatics</span></a></p>
SeanBurlington<p>Today I'm researching better workflows to backup databases, and create sanitised copies for local development.</p><p>I'm not able to find a great deal of informative discussion around best practice.</p><p>Is this stuff more obvious than I think - or is it so under-the-radar-unsexy that industry practice is just not very good?</p><p><a href="https://mastodon.me.uk/tags/backups" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>backups</span></a> <a href="https://mastodon.me.uk/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://mastodon.me.uk/tags/gdpr" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>gdpr</span></a> <a href="https://mastodon.me.uk/tags/webdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>webdev</span></a></p>
InfoQ<p>Ever wondered how to compute a function across multiple parties without revealing their inputs?</p><p>This technique can be used to split secrets among parties, perform logical operations, or count votes in a way that ensures data privacy is preserved.</p><p>Read the <a href="https://techhub.social/tags/InfoQ" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>InfoQ</span></a> article to learn more: <a href="https://bit.ly/4cx8sAV" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">bit.ly/4cx8sAV</span><span class="invisible"></span></a> </p><p><a href="https://techhub.social/tags/BigData" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>BigData</span></a> <a href="https://techhub.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://techhub.social/tags/DataPrivacy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataPrivacy</span></a> <a href="https://techhub.social/tags/SecureCoding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SecureCoding</span></a> <a href="https://techhub.social/tags/Algorithms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Algorithms</span></a></p>
James Gayfer<p>Is it a code smell for a table in Postgres to have mutually exclusive foreign keys?</p><p>For example, table A has foreign keys to table B and C, but there's a constraint in place where only one of those foreign keys can be populated.</p><p>My gut says I should be creating separate tables for these, as I'm effectively trying to tie a single table to multiple domain models (that happen to share the same fields).</p><p><a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://fosstodon.org/tags/databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>databases</span></a></p>
Truls<p>I am a (relational) database guy and have been for decades. </p><p>When I read "feature drop" it sounds to me, as if something was removed, not added. </p><p><a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://mastodon.social/tags/wording" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>wording</span></a> <a href="https://mastodon.social/tags/featureDrop" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>featureDrop</span></a></p>
.:\dGh/:.<p>Found the antichrist on myself.</p><p><a href="https://mastodon.social/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PHP</span></a> <a href="https://mastodon.social/tags/Laravel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Laravel</span></a> <a href="https://mastodon.social/tags/EloquentORM" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>EloquentORM</span></a> <a href="https://mastodon.social/tags/ORM" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ORM</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/DB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB</span></a> <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.social/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a> <a href="https://mastodon.social/tags/Code" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Code</span></a> <a href="https://mastodon.social/tags/SoftwareDevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SoftwareDevelopment</span></a> <a href="https://mastodon.social/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Software</span></a> <a href="https://mastodon.social/tags/WebDevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>WebDevelopment</span></a> <a href="https://mastodon.social/tags/WebDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>WebDev</span></a></p>
Paul Houle<p>💽 Hans-Juergen Schoenig: PostgreSQL: 1 trillion rows in Citus</p><p><a href="https://postgr.es/p/73O" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">postgr.es/p/73O</span><span class="invisible"></span></a></p><p><a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://mastodon.social/tags/computing" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>computing</span></a> <a href="https://mastodon.social/tags/performance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>performance</span></a> <a href="https://mastodon.social/tags/software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>software</span></a></p>
zartom<p>Troubleshooting DB2 REORG in Compound SQL Statements: Why Does It Fail?<br>Troubleshooting DB2 REORG compound statements. Learn the difference between compiled and inlined compound SQL blocks in DB2 LUW to avoid errors and optimize database reorganization. Key takeaways include best practices, error handling, and performance considerations. <a href="https://mastodon.social/tags/DB2" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2</span></a> <a href="https://mastodon.social/tags/REORG" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>REORG</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/Troubleshooting" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Troubleshooting</span></a> <a href="https://mastodon.social/tags/Performance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Performance</span></a><br><a href="https://tech-champion.com/programming/troubleshooting-db2-reorg-in-compound-sql-statements-why-doe" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/programming/</span><span class="invisible">troubleshooting-db2-reorg-in-compound-sql-statements-why-doe</span></a>...</p>
zartom<p>How to Overcome the Listagg Limit of 4000 Characters<br>Overcome the LISTAGG limit in SQL for large datasets! Strategies like chunking and recursive CTEs help manage massive concatenated strings. Learn practical solutions for efficient SQL queries. <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/LISTAGG" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LISTAGG</span></a> <a href="https://mastodon.social/tags/StringConcatenation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>StringConcatenation</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQLQueries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLQueries</span></a> <a href="https://mastodon.social/tags/LargeDatasets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LargeDatasets</span></a><br><a href="https://tech-champion.com/database/how-to-overcome-the-listagg-limit-of-4000-characters/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/how</span><span class="invisible">-to-overcome-the-listagg-limit-of-4000-characters/</span></a><br>...</p>
zartom<p>How to Find the Exact Count of Records in All Persistent Tables in a Database?<br>Finding accurate Total persistent table records in DB2 LUW can be tricky. Standard methods aren't always precise, especially in high-transaction environments. Learn alternative, efficient techniques to get accurate counts. <a href="https://mastodon.social/tags/DB2LUW" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2LUW</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/Performance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Performance</span></a> <a href="https://mastodon.social/tags/RecordCounts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RecordCounts</span></a> <a href="https://mastodon.social/tags/TableCounts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>TableCounts</span></a><br><a href="https://tech-champion.com/programming/how-to-find-the-exact-count-of-records-in-all-persistent-tables-in-a-database/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/programming/</span><span class="invisible">how-to-find-the-exact-count-of-records-in-all-persistent-tables-in-a-database/</span></a><br>...</p>
zartom<p>DB2 for i Date Comparison: A Guide to Efficient Date Handling<br>Master DB2 for i Date Comparison! Learn efficient techniques for accurate &amp; reliable date handling in your DB2 applications. Improve query efficiency &amp; avoid common pitfalls. <a href="https://mastodon.social/tags/DB2" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2</span></a> <a href="https://mastodon.social/tags/DateComparison" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DateComparison</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.social/tags/iSeries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>iSeries</span></a><br><a href="https://tech-champion.com/database/db2luw/db2-for-i-date-comparison-a-guide-to-efficient-date-handling/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/db2</span><span class="invisible">luw/db2-for-i-date-comparison-a-guide-to-efficient-date-handling/</span></a><br>...</p>
zartom<p>How to Change Column Collation in MySQL<br>Need to change column collation in MySQL? Our guide covers updating single columns, tables, and databases for better character support. Learn SQL commands &amp; automation tips! <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a> <a href="https://mastodon.social/tags/Collation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Collation</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/CharacterSet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CharacterSet</span></a> <a href="https://mastodon.social/tags/UTF8MB4" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>UTF8MB4</span></a><br><a href="https://tech-champion.com/database/mysql/how-to-change-column-collation-in-mysql/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/mys</span><span class="invisible">ql/how-to-change-column-collation-in-mysql/</span></a><br>...</p>
zartom<p>Find the Oldest Even-Numbered Patient Visit Using SQL<br>Learn to extract the Oldest Even Visit SQL record! This tutorial covers various SQL techniques, including CTEs and subqueries, to efficiently retrieve this data. Optimize your queries for speed and handle missing data. <a href="https://mastodon.social/tags/SQLqueries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLqueries</span></a> <a href="https://mastodon.social/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/OldestRecord" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OldestRecord</span></a> <a href="https://mastodon.social/tags/EvenVisit" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>EvenVisit</span></a> <a href="https://mastodon.social/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a><br><a href="https://tech-champion.com/database/sql-server/find-the-oldest-even-numbered-patient-visit-using-sql/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/sql</span><span class="invisible">-server/find-the-oldest-even-numbered-patient-visit-using-sql/</span></a><br>...</p>
zartom<p>SQL Server String Aggregation: SQL Server 2016 vs. 2017<br>Master SQL Server String Aggregation across versions (2016+). Learn dynamic SQL, best practices, &amp;amp; secure techniques to prevent SQL injection. <a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLServer</span></a> <a href="https://mastodon.social/tags/DynamicSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DynamicSQL</span></a> <a href="https://mastodon.social/tags/StringAggregation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>StringAggregation</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQLInjection" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLInjection</span></a> <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a><br><a href="https://tech-champion.com/general/sql-server-string-aggregation-sql-server-2016-vs-2017/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/general/sql-</span><span class="invisible">server-string-aggregation-sql-server-2016-vs-2017/</span></a><br>...</p>
zartom<p>Reverse Substrings in SQL Server: Four Efficient Methods<br>Master Reverse SQL Substrings in SQL Server! Learn efficient methods to reverse substring order, transforming "apple-banana-cherry" into "cherry-banana-apple". Explore modern techniques using STRING_SPLIT &amp; STRING_AGG for optimal performance. <a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLServer</span></a> <a href="https://mastodon.social/tags/stringmanipulation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>stringmanipulation</span></a> <a href="https://mastodon.social/tags/ReverseSubstring" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ReverseSubstring</span></a> <a href="https://mastodon.social/tags/SQLtips" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLtips</span></a> <a href="https://mastodon.social/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>programming</span></a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a><br><a href="https://tech-champion.com/database/sql-server/reverse-substrings-in-sql-server-four-efficient-methods/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/sql</span><span class="invisible">-server/reverse-substrings-in-sql-server-four-efficient-methods/</span></a><br>...</p>