InfoWorld

SQL unleashed: 9 ways to speed up your SQL queries

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...
TechRepublic

Determine when to use stored procedures vs. SQL in the code

Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one is best for your particular situation. I once was pulled into a discussion about the ...
Msdynamicsworld.com

From the Microsoft Power Platform blogs: SQL stored procedures; Power Automate flow screenshot; Send notifications V2; Business card reader

Using SQL stored procedures within PowerApps via PowerFx How to take a screenshot of your Power Automate flow Send notifications V2 to phones, tablets, and watches with Power Apps Utilize the power of ...
InfoWorld

SQL unleashed: 7 SQL mistakes to avoidPostgreSQL

SQL is a convenient way to manage and query your data, but badly written queries can tie up your database. Here are seven common SQL traps and how to avoid them. Database developers have it tough.
Msdynamicsworld.com

From the Microsoft Power Platform blogs: SQL Server procedures; Power Automate approvals; Planner checklist; Availability monitoring

Call SQL Server procedures directly in Power Fx (GA) User availability monitoring with Power Automate Power Automate approvals attachments with Dataverse files Update planner checklist with Power ...