SQL-Bits.com @sql_bits
We give you quick SQL recipes on Twitter and on SQL-Bits dot com. Because SQL matters! sql-bits.com Joined July 2021-
Tweets158
-
Followers23
-
Following39
-
Likes130
MariaDB and MySQL don't use indexes for regular expressions, even when they theoretically could. But in some cases you can solve the problem with this optimisation, that I call "REGEXP AND LIKE". vettabase.com/mariadb-the-re…
What's new in @mariadb's latest Long-Term Support release? We have selected a list of most interesting features and explained them all for you! Read the new post by our Founder @FedericoRazzol1 covering the recent MariaDB LTS release: vettabase.com/mariadb-10-11-… #MariaDB #database
In #SQL, this can’t use a regular index: WHERE DATE_PART(YEAR, date) = '2021'. This is an equivalent expression that can use a suitable index, if it exists: WHERE date BETWEEN '2021-01-01' AND '2021-12-31'. #database #Vettabase #VettabaseWeeklyTips
🗓 Get ready for the first edition of #datacomconf2022! 💬Meet the data infrastructure and platform community on 3 November in #Bern!
💬 Be part of this years #OracleBeerBern meets #tvdpdays! Meet the performance experts for the Q&A session on Wednesday afternoon! ⁉️ Register now! 🖊 meetup.com/de-DE/oracle-b… #SwissOUC
Storing filenames, urls or alphanumeric codes in #MariaDB/#MySQL? Consider storing them with #ascii charset and ascii_bin collation. This makes searches faster and physical tables smaller. #database #opensource #DBMS #Vettabase #VettabaseWeeklyTips
“Don’t use an #RDBMS as a cache” - yet another rule that we shouldn’t follow strictly. #Caching the results of a query in a table means that we can join it to other data, use a stricter WHERE or a different ORDER BY at a low cost. #database #Vettabase #VettabaseWeeklyTips
"Data Concurrency and Consistency" In a single-user database, a user can modify data without concern for other users modifying the same data at the same time. However, in a multiuser database, statements within multiple simultaneous transactions may update the same data 1/2
Do you know how to use GROUP BY to group results by *ranges* of values? #SQL sql-bits.com/group-rows-by-…
We can write very advanced #SQL queries just by nesting GROUP BYs. Check this example & explanation! sql-bits.com/groups-of-grou…
Do you know what #PostgreSQL autovacuum is, and how to tune it? Check this article from @kwaku_mikey! vettabase.com/blog/tuning-po…
The idea is amazing, it should seriously reduce resources used for data centres powering and water treatment. These guys are great. theregister.com/2022/04/02/dat…
Here are some creative uses of the LIKE operator. Maybe you won't use them often or at all, but it's good to know them. sql-bits.com/non-trivial-us…
How to work with IDENTITY columns in #Db2: sql-bits.com/db2-creating-i…
How to copy tables in #MySQL and #MariaDB. sql-bits.com/copying-tables…
#SQLServer: Understanding the differences between CHECKSUM(), CHECKSUM_BINARY(), HASHBYTES() sql-bits.com/sql-server-che…
#SQLServer: Learn how to count the occurrences if a substring in a string sql-bits.com/sql-server-how…
Learn how to find values above the average in #SQL. sql-bits.com/find-values-ab…
MariaDB.org: FOSDEM22 MariaDB devroom talks mariadb.org/fosdem22-maria…
Carlos Irigoyen @carlosir4
59 Followers 342 Following
Angus Miller @all4miller
410 Followers 1K Following Founder and CEO of Vulcan Labs. Vulcan Labs offers world-class Custom Software Development Services via a flexible engagement model.
Ranjan Priyadarshi @ranjanpriya
1K Followers 4K Following Product Management & Strategy @ Oracle Database; Data Management & Analytics; Innovation; Problem Solver Opinions are my own & may not represent my employer
Omar @nellaiomar
116 Followers 2K Following
Mihai G. Muntenas �... @MihaiMuntenas
61 Followers 312 Following Dad, Husband, Brother and Problem Solver. @[email protected] https://t.co/vwy5JkbyPy
Billy Rowe @spacebar208
12 Followers 319 Following
kirvirvi 💚🌻 @kirvirvi
395 Followers 659 Following husband, father, oracleNinja ... Database Administrator for Oracle, MySQL, Mariadb and MS SQL and PowerGoogler
AS400 and SQL Tricks @myeasyclasses
1K Followers 815 Following AS400 and SQL Tricks offers videos on topics such as RPG,CL, ILE and DB2 and SQL using DB2.
Swiss Oracle User Com... @swissOUC
869 Followers 1K Following #SwissOUC connects people and shares #CommunityTips for everyone. 📝Blogs on #SORAMagazine. 💻
🇫🇷 Sylvain ARBA... @SylvainArbaudie
206 Followers 406 Following // Information architect // Happy freelancer // jack of all MariaDB trades // Certified MariaDB DBA // praise the Omnissiah //
DBplatz @dbplatz
146 Followers 963 Following DBplatz. Read our handpicked database-related articles. Where all are welcome. #useThemAll #dbplatz
Dave Stokes @stoker
2K Followers 1K Following
Vettabase @vettabase
205 Followers 95 Following Expert DBA-as-a-Service and automation for your database infrastructure. Health Checks and professional services for #MariaDB, #MySQL, #PostgreSQL & #Cassandra.
Federico Razzoli @FedericoRazzol1
674 Followers 795 Following Founder of Vettabase | Database Automation & Consulting
Maria Colgan @SQLMaria
10K Followers 358 Following Oracle Database Product Manager with a passion for SQL, AI, and the Optimizer. Wildlife photographer and Lego builder. Views expressed are my own.
DB-Engines @DBEngines
3K Followers 102 Following Knowledge Base of Relational and NoSQL Database Management Systems
Justyna Lucznik @JustynaLucznik
6K Followers 332 Following Program Manager on the Azure Synapse team focusing on Spark & Data Science. Passionate about statistics, ML and data visualization.
Pantea @Pani_trng
278 Followers 454 Following Senior Data Engineer at Mydigipay Co, AI, ML and Database enthusiast I'm here to learn and share what I've learned :) https://t.co/WZxVLMUSMi
Firebird SQL Database @firebirdsql
3K Followers 450 Following Firebird is an open source #SQL relational database management system that runs on #Linux, #Windows, #MacOS , #Android / #iOS and a variety of Unixes : #FreeBSD
kirvirvi 💚🌻 @kirvirvi
395 Followers 659 Following husband, father, oracleNinja ... Database Administrator for Oracle, MySQL, Mariadb and MS SQL and PowerGoogler
AS400 and SQL Tricks @myeasyclasses
1K Followers 815 Following AS400 and SQL Tricks offers videos on topics such as RPG,CL, ILE and DB2 and SQL using DB2.
Swiss Oracle User Com... @swissOUC
869 Followers 1K Following #SwissOUC connects people and shares #CommunityTips for everyone. 📝Blogs on #SORAMagazine. 💻
Kendra Little @Kendra_Little
13K Followers 1K Following She/her. Cartoonist at https://t.co/eT9qOJhIMc (get free comics!), tech blogger at https://t.co/IBBOm623RL.
Jorge Segarra @SQLChicken
7K Followers 3K Following former @SQLServer MVP, #powerbi super nerd and general geek. https://t.co/VCLZFONCbs
DBplatz @dbplatz
146 Followers 963 Following DBplatz. Read our handpicked database-related articles. Where all are welcome. #useThemAll #dbplatz
CloudQuery @cloudqueryio
1K Followers 56 Following A complete cloud asset inventory solution enabling smarter cloud audits, better cloud inventories, and more targeted security monitoring.
osquery @osquery
3K Followers 131 Following osquery lets you ask questions about your Linux, Mac, and Windows infrastructure. Intrusion detection, infrastructure reliability, compliance, and more.
Modern SQL @ModernSQL
11K Followers 5 Following Still using Windows 3.1? So why stick to SQL-92? A lot has changed in 30 years. We embrace the standard.
SQL Performance Tips @SQLPerfTips
54K Followers 2 Following Tips to get best SQL performance. Covering all major SQL databases. https://t.co/pPX9UrXm8p is my book.
SQL Daily @sqldaily
26K Followers 4 Following Daily Oracle SQL tips from the Oracle Developer Advocates for SQL
MSSQLTips - Free Dail... @mssqltips
21K Followers 5K Following Resources for #Developer, #DBA, #BusinessIntelligence, and #Data Professionals. #SQL #Database #AI #AzureSQL #AWS #Cloud #Python #SSIS #Performance #PowerBI
MariaDB Foundation @mariadb_org
3K Followers 166 Following Ensuring continuity and open collaboration in the MariaDB ecosystem
Dave Stokes @stoker
2K Followers 1K Following
Markus Winand @MarkusWinand
9K Followers 265 Following SQL Renaissance Ambassador. Author, Trainer, Coach. PhD in Common Sense. Creator of https://t.co/6oKhq87B43 and https://t.co/RrIy2AY7Tl.
SQLServerGeeks.com @SQLServerGeeks
4K Followers 11 Following SQL Community led by SQL Server obsessives. We share knowledge around SQL, Azure & related technologies through our blogs, webcasts & in-person events.
SQLServer Data Tools @sqldatatools
4K Followers 137 Following A modern database development tool for SQL Server and Azure SQL Database. Develop a database with the same ease as developing an app in Visual Studio.
SQLServerCentral @SQLServerCentrl
14K Followers 325 Following SQLServerCentral is the #1 education & community site for SQL Server, featuring Articles, News, Forums, Q&A, Scripts, Tutorials & Book Reviews. Join us!
Vettabase @vettabase
205 Followers 95 Following Expert DBA-as-a-Service and automation for your database infrastructure. Health Checks and professional services for #MariaDB, #MySQL, #PostgreSQL & #Cassandra.
Our World in Data @OurWorldInData
300K Followers 22 Following Research and data to make progress against the world’s largest problems. Based out of @UniOfOxford, founded by @MaxCRoser.
smartData People @sdeievent
2K Followers 46 Following Welcome! Get insights on events, culture, leadership, initiatives and achievements of our people. smartCFG- smartData Community, Fitness and Green
FINTECHNA @fintechna
34K Followers 2K Following The most important #fintech weekly newsletter http://t.co/WipZDuDvqK Also discussion at: http://t.co/mAxbDF4ljI
DevCareer Africa @dev_careers
44K Followers 5 Following #Laptops4Developers | We support budding developers in Africa with resources (Laptop, Courses, Mentorship && Co-Learning space) to build a career | 💯Non-Profit
GitHub @github
2.6M Followers 326 Following The AI-powered developer platform to build, scale, and deliver secure software.
Ladybug Podcast @LadybugPodcast
24K Followers 4 Following An all lady-hosted tech podcast for all developers and engineering leaders! Season 7: Engineering Leadership coming Monday! 💁♀️
Cher Scarlett 🌌 @cherthedev
49K Followers 2K Following 🦋 https://t.co/bDmUt3vs6V SWE x-@Apple x-@Blizzard_ent studying physics | @nasajpl @caltech @earthscope_sci
CodeNewbie @CodeNewbies
151K Followers 2K Following The most supportive community of programmers. #CodeNewbie Podcast | @codelandconf | Part of the @forem & @thepracticaldev family 💜
Angie Jones @techgirl1908
113K Followers 626 Following VP Eng, AI Tools & Enablement | International Keynote Speaker | Java Champion | GitHub Star | Inventor {27 patents} | Working on AI agents and MCP @blocks
freeCodeCamp.org @freeCodeCamp
951K Followers 158 Following We're a community of millions of people who are building new skills and getting new jobs together. A 501(c)(3) public charity. Tweets by @abbeyrenn.
Emma Bostian @EmmaBostian
193K Followers 962 Following Engineering Manager @spotify 🇸🇪 American in StockholmTrends for United States
You might like
