TsqlREX

◢ SQLServer | TSQL | SSIS | DataModeling | DataViz
◢ Can I help review your blog, dataviz, or book?

[TsqlREX @TsqlREX]

#SQLFamily, please tell me a few things that you think could be done better in a #TSQL or #SQLServer book.

Any level: Beginner, Intermediate, Advanced

Trying to find if there are any gaps. Thanks!

Plz retweet.

[TsqlREX @TsqlREX]

@Manu_Sisti Start

[LlamaIndex 🦙 @llama_index]

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: https://t.co/q6GwzESHj0

Blog: https://t.co/U4CAFOIUzh

[DataCamp @DataCamp]

🤯 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 👉https://t.co/2UTWYIdH2s

[Dr Milan Milanović @milan_milanovic]

SQLFlow - a great tool to visualize SQL queries.

https://t.co/6STGbYaCXi

#technology #sql #data #programming

[TsqlREX @TsqlREX]

@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

[TsqlREX @TsqlREX]

@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

[TsqlREX @TsqlREX]

@Sun_Ever_shines No criticism, only feedback 🙏🙂

[TsqlREX @TsqlREX]

@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

[Kevin Kline @kekline]

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. https://t.co/5VD0LjQgvu

[Atal @ZabihullahAtal]

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

🔗https://t.co/MkOTYXTQmE…

2. Python for beginners
→ 10 Modules
→ 5.5 Hours
→ Beginner Friendly
→ Free Badge

🔗https://t.co/et33DmHSwD

3. Microsoft Azure Data Scientist Professional Certificate.

🔗https://t.co/8ngYQq60x8

4. Microsoft Azure Data Engineering.

🔗https://t.co/dedmdTCOKt

5. Microsoft Azure Databricks for Data Engineering.
🔗https://t.co/tSKkUZmgId

6. Get started with Azure Cosmos DB
→ 06 Modules
→ 01 Hours
→ Intermediate
→ Free Badge

🔗https://t.co/uuWjKjjZvQ

7. Microsoft Azure Machine Learning
→ 11 Modules
→ 2.5 Hours
→ Beginner Friendly
→ Free Badge

🔗https://t.co/a8J92CZs2k

8. Get started with Azure Cosmos DB
→ 06 Modules
→ 01 Hours
→ Intermediate
→ Free Badge

🔗https://t.co/MkOTYXTQmE…

9. Get started with AI on Azure
→ 10 Modules
→ 01 Hours
→ Beginner Friendly
→ Earn 10XP

🔗https://t.co/lHLmmRgwcw

Follow @ZabihullahAtal for tech updates, knowledge and insights.

[Santiago @svpino]

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: https://t.co/WOmAy6DE55

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?

[Anton Zhiyanov @ohmypy]

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.

[Ryan & Matt Data Science @RyanMattDS]

This video took forever to make. 2.5 Hours of FREE Data Science Training + a full Portfolio Project

I hope you enjoy:https://t.co/oH8y58Xask

Please RT and Share with Friends

[TsqlREX @TsqlREX]

Try out Glen's TempDb monitoring/warning queries for SQL Server 2016 or later.

DropBox link to download the T-SQL -

#SQLServer

[Glenn Berry (@glennalanberry.bsky.social) @GlennAlanBerry]

Here is a DropBox link to the set of tempdb queries I mentioned.

https://t.co/HAmT8Aguiv

#SQLServer

[TsqlREX @TsqlREX]

@unfilled @erinstellato @erikdarlingdata https://t.co/kgbdSIsSqu

[TsqlREX @TsqlREX]

@SQLDev_DBA @erinstellato https://t.co/kgbdSIsSqu

[TsqlREX @TsqlREX]

@theRenjie @erinstellato https://t.co/kgbdSIsSqu

[TsqlREX @TsqlREX]

@clausm73 @erinstellato https://t.co/kgbdSIsSqu

[TsqlREX @TsqlREX]

@VesDBA @erinstellato @Kendra_Little https://t.co/kgbdSIsSqu

[TsqlREX @TsqlREX]

@petermclarty @erinstellato https://t.co/kgbdSIsSqu