TsqlREX @TsqlREX

◢ SQLServer | TSQL | SSIS | DataModeling | DataViz ◢ Can I help review your blog, dataviz, or book? SQLErudition.com Ontario, Canada Joined May 2015

Tweets

2K
Followers

1K
Following

5K
Likes

3K

TsqlREX @TsqlREX

8 months ago

@Manu_Sisti Start

0 0 0 12 0

View Details

Build an E2E SQL Analyst App on @streamlit 📊 The Na2SQL repo by @HarshadSurya1c is a complete starter kit for you to build an LLM-powered structured analytics app over your SQL database. Building a well-functioning text-to-SQL app requires a lot more features than just the prompt! This repo includes the following: 1️⃣ An interactive database viewer 2️⃣ Displays both the intermediate SQL queries as well as output tables 3️⃣ Works over multiple tables 4️⃣ Core orchestration logic with @llama_index This is an extension of @CarolineFrasca 's excellent @streamlit LlamaPack, which allows you to build an app in one line of code. Check out the repo: github.com/AI-ANK/Na2SQL/… Blog: blog.llamaindex.ai/transforming-n…

3 42 216 33K 225

View Details

DataCamp @DataCamp

3 years ago

🤯 DataCamp is now FREE (until Nov 12). No strings, no obligations. #FreeAccessWeek is officially underway, granting all free DataCamp users access to: 📚 All 450+ data and AI courses for every level. 🧠 Unlimited learning across the world's most in-demand skills, including ChatGPT and Generative AI, Python, SQL, Power BI, and more. 🚀 Our library of Data Analyst, Scientist, and Engineer career tracks. 🎓 Forbes' #1 ranked data certification. And much more. For free. Closes Nov 12, 11.59 PM EST. ⏰ Start now 👉ow.ly/n7Rp50Q445t

6 240 546 251K 478

View Details

Dr Milan Milanović @milan_milanovic

3 years ago

SQLFlow - a great tool to visualize SQL queries. sqlflow.gudusoft.com #technology #sql #data #programming

16 432 2K 256K 2K

View Details

TsqlREX @TsqlREX

3 years ago

@bolu_lasun Feedback: 1) use a different font color than the chart element, black or dark grey maybe 2) resize two charts to align with the ones below them

1 1 1 55 0

View Details

TsqlREX @TsqlREX

3 years ago

@EdsWonder Feedback: keep related data points close together. 1) you can move the numbers to the empty space at the top 2) bring "Leavers by Gender" bar chart below "% of Leavers" pie chart 3) bring "% of Promotion" pie chart next to "Total Promotions" bar chart

0 0 1 23 0

View Details

TsqlREX @TsqlREX

3 years ago

@Sun_Ever_shines No criticism, only feedback 🙏🙂

0 0 0 39 0

View Details

TsqlREX @TsqlREX

3 years ago

@Sun_Ever_shines 1) red is danger/bad/negative ... use different color for good/positive 2) use consistent color for the same data point e.g. Answered Calls is red or blue in different charts 3) use different colors for resolved/unresolved

0 0 0 35 0

View Details

Kevin Kline @kekline

3 years ago

Help me make this go viral! Do you know about SQuizL, essentially Wordle for #SQL. It's from #Oracle, but it's fun for the entire #SQLfamily, whatever your #database. I hope you'll check it out and let your followers know about it. bit.ly/SQuizL-game

6 18 42 8K 13

View Details

Atal @ZabihullahAtal

3 years ago

Microsoft is offering FREE online Azure courses with certification. No Payment Required! Discover the 9 FREE Microsoft Azure courses to become Azure expert in 2023! 1. Microsoft Azure Fundamentals → 04 Modules → 2.5 Hours → Beginner Friendly → Free Badge 🔗learn.microsoft.com/en-us/training… 2. Python for beginners → 10 Modules → 5.5 Hours → Beginner Friendly → Free Badge 🔗imp.i384100.net/Y9jMyP 3. Microsoft Azure Data Scientist Professional Certificate. 🔗imp.i384100.net/DKqvk2 4. Microsoft Azure Data Engineering. 🔗imp.i384100.net/jr59OP 5. Microsoft Azure Databricks for Data Engineering. 🔗imp.i384100.net/eKQLAO 6. Get started with Azure Cosmos DB → 06 Modules → 01 Hours → Intermediate → Free Badge 🔗imp.i384100.net/q40ayn 7. Microsoft Azure Machine Learning → 11 Modules → 2.5 Hours → Beginner Friendly → Free Badge 🔗imp.i384100.net/rQ0mXG 8. Get started with Azure Cosmos DB → 06 Modules → 01 Hours → Intermediate → Free Badge 🔗learn.microsoft.com/en-us/training… 9. Get started with AI on Azure → 10 Modules → 01 Hours → Beginner Friendly → Earn 10XP 🔗imp.i384100.net/k0krWM Follow @ZabihullahAtal for tech updates, knowledge and insights.

14 440 1K 211K 2K

View Details

Santiago @svpino

3 years ago

This is going to change databases! There are 1.7 million deployments of PostgreSQL worldwide. This makes it one of the world's most popular relational database management systems. The team behind @postgresml reached out to me and showed me their open-source extension, PostgresML. It's pretty cool! You can use this extension to train a model on text and tabular data using SQL queries. This example trains a model using XGBoost using a query! select * from pgml.train('Handwritten Digit Image Classifier', algorithm => 'xgboost', 'classification', 'pgml.digits', 'target' ); The extension integrates Hugging Face 🤗 Transformers. You can use it to run NLP models right into the database. Here is an example to determine the sentiment of some text: select pgml.transform( task => 'text-classification', inputs => ARRAY[ 'This product didn't work for our family.', 'This has been the best purchase of the year!' ] ) as positivity; I had never seen this before. You can train and run supervised and unsupervised algorithms. You can run pre-trained models. Machine Learning and AI right at the database level! Here is the GitHub repository: github.com/postgresml/pos… This post is sponsored by @postgresml and their fully managed cloud service. You can use them in addition to their open-source library. Horizontal scalability and support for JavaScript, Python, and Rust. Machine learning is now getting everywhere. How long before this is part of every database management system out there?

60 385 2K 671K 2K

View Details

Anton Zhiyanov @ohmypy

3 years ago

PostgreSQL: releases a major version every year. MySQL: jumps from 5.7 to 8.0 for no reason. MariaDB: jumps from 5.5 to 10.0 to show it's better than MySQL. ClickHouse: ties version number to a year. SQLite: stays at 3.x since 1847.

32 313 3K 265K 153

View Details

Ryan & Matt Data Science @RyanMattDS

3 years ago

This video took forever to make. 2.5 Hours of FREE Data Science Training + a full Portfolio Project I hope you enjoy:youtube.com/watch?v=6IGx7Z… Please RT and Share with Friends