Alberto MorilloApr 27
No more excuses: AI-powered assistants are in SSMS, VS Code, and Fabric
#AI #ArtificialIntelligence #MicrosoftFabric #Azure #VSCode $SSMS #TSQL #GitHHubCopilot #SQLDatabase #CloudDatabases
https://blog.fabric.microsoft.com/en-US/blog/no-more-excuses-ai-powered-assistants-are-in-ssms-vs-code-and-fabric/?wt.mc_id=DP-MVP-4015656
No more excuses: AI-powered assistants are in SSMS, VS Code, and Fabric | Microsoft Fabric Blog | Microsoft Fabric

You like writing T-SQL. You&#8217;re good at it. Or maybe you’re not. But let&#8217;s be honest—there are days when you&#8217;d rather not write that same GROUP BY clause for the hundredth time or spend twenty minutes deciphering a stored procedure someone wrote in 2014. Good news: AI-powered assistants are now available wherever you write SQL &hellip; <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/no-more-excuses-ai-powered-assistants-are-in-ssms-vs-code-and-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> &#8220;No more excuses: AI-powered assistants are in SSMS, VS Code, and Fabric&#8221;</span></a>

Future CodingApr 22

Learn SQL database with examples and full explaination of roadmap follow for more

#coding #programming #sql #sqldatabase #databases

Alberto MorilloApr 20
Compute auto-scaling choices to better optimize price-performance for SQL databases in Microsoft Fabric.
#SQLDatabase #Microsoft #MicrosoftFabric
https://blog.fabric.microsoft.com/en-US/blog/compute-auto-scaling-choices-to-better-optimize-price-performance-for-sql-databases-in-microsoft-fabric-preview/?wt.mc_id=DP-MVP-4015656
Compute auto-scaling choices to better optimize price-performance for SQL databases in Microsoft Fabric (Preview) | Microsoft Fabric Blog | Microsoft Fabric

One of the most common pieces of feedback we hear from customers using SQL databases in Microsoft Fabric is the need for stronger cost control and predictable resource usage, especially in shared capacities. Today, SQL databases in Fabric automatically scale to meet workload demand. This delivers great performance, but in shared environments it can also &hellip; <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/compute-auto-scaling-choices-to-better-optimize-price-performance-for-sql-databases-in-microsoft-fabric-preview/" class="more-link">Continue reading<span class="screen-reader-text"> &#8220;Compute auto-scaling choices to better optimize price-performance for SQL databases in Microsoft Fabric (Preview)&#8221;</span></a>

PrecisionSQLApr 4

Why does this SQL ORDER BY in subquery get ignored?

Why does this SQL ORDER BY in subquery get ignored. The SQL code uses ORDER BY inside a derived table. In MySQL without LIMIT the optimizer ignores it. In SQL the order you expect is not the order you get.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlorderby #sql...

https://www.youtube.com/watch?v=f4mdNHOjKTg

Why does this SQL ORDER BY in subquery get ignored? #sqldebugging

YouTube
PrecisionSQLApr 1

Why does this SQL phantom read show rows that vanish?

Why does this SQL phantom read show rows that vanish. The SQL code runs REPEATABLE READ. In MySQL another transaction can insert matching rows. In SQL you see rows in one read that disappear in the next.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlphantomread ...

https://www.youtube.com/watch?v=2HZvRkzESXA

Why does this SQL phantom read show rows that vanish? #sqlproductionbug

YouTube
PrecisionSQLApr 1

Why does this SQL ORDER BY RAND() melt the database?

Why does this SQL ORDER BY RAND() melt the database. The SQL code uses ORDER BY RAND() for random rows. In MySQL that sorts the entire table. In SQL one query can take down the server.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlorderbyrand #sqlrandom #sqlsort ...

https://www.youtube.com/watch?v=2G3tRvhnyJM

Why does this SQL ORDER BY RAND melt the database? #sqlperformance

YouTube
PrecisionSQLMar 31

Why does this SQL SUM return NULL for empty?

Why does this SQL SUM return NULL for empty result. The SQL code sums a column without COALESCE. In SQL SUM of zero rows returns NULL not zero. In SQL APIs this breaks calculations and causes NaN downstream.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlsum #sqlnull #sql...

https://www.youtube.com/watch?v=gG4KtBljZ-o

Why does this SQL SUM return NULL for empty? #sqlreliability

YouTube
PrecisionSQLMar 29

Why does this SQL OFFSET get slower with every page?

Why does this SQL OFFSET get slower with every page. The SQL code uses OFFSET for pagination. In MySQL OFFSET forces a full scan and skip. In SQL page 10000 can take minutes.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqloffset #sqlpagination #sqlkeyset #sqlscaling

https://www.youtube.com/watch?v=LmfRuHBSCV4

Why does this SQL OFFSET get slower with every page? #sqloffset

YouTube
PrecisionSQLMar 28

What's wrong with this SQL REPLACE deleting related rows?

What's wrong with this SQL REPLACE deleting related rows. The SQL code uses REPLACE instead of INSERT ON DUPLICATE. In MySQL REPLACE deletes then inserts, firing deletes on child tables. In SQL this cascades to data loss.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengine...

https://www.youtube.com/watch?v=fIHKcR7Dh28

Whats wrong with this SQL REPLACE deleting related rows? #sqldebugging

YouTube
PrecisionSQLMar 28

What's wrong with this SQL dividing integers?

What's wrong with this SQL dividing integers losing decimals. The SQL code divides two integer columns. In SQL integer division truncates to integer. In SQL analytics this undercounts rates and percentages.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqldivision #sqlinte...

https://www.youtube.com/watch?v=xULrs5LG75M

Whats wrong with this SQL dividing integers? #sqltruncate

YouTube