Category: Sql Server
SQL - Caution! This is how users can hack shared SQL connections
Is your SQL Server data as secure as you think? If we create a shared 'implicit' connection, our database may be more open than we think. In this post, we'll look at how users can exploit the security vulnerability that is associated with this connection type.
SQL - How can we count rows accurately?
With SQL Server, the Count and CountRow functions produce delegation warnings. Without these functions, does it make it impossible to count records from large SQL Server tables? The answer is no! In this post, I'll describe a trick that enables us to carry out this task.
SQL - Have you seen these Power Platform options in SQL Azure portal?
From the SQL Azure Portal, there is now the option to create a Power App ontop of a SQL Table. Here's a closer look at this feature.
SQL Server for Beginners Part 3 - Installing On-Premises Gateway
Find out how to install and connect to a local SQL Server with the on-premises gateway
SQL Server for Beginners Part 1 - Installing SQL Server
If you're completely new to SQL Server, this post will show you how to install an on-premise instance of SQL Server.
Excel vs SharePoint vs SQL Server vs CDS
Don't know what data source to use? Read this to find out which data source can best suit your needs.
Recent Posts
- SQL - How to return data from Stored Procedures to Power Apps
- Reading Dynamics 365 and Power Platform User Group successfully holds its Q1 2024 meetup
- Data - How to show the distinct rows from 2 data sources or collections
- Data - How to implement circular rotational date sorting
- Dataverse - The easiest way to modify Dataverse data outside of Dataverse and Power Apps
- Forms - When calling SubmitForm, how to debug the error "Network error when using Patch function"
- AI Builder - Where to find the AI Models in the Power Apps designer
- Text - How to truncate and add 3 dots / ellipsis to long label text
- Controls - How to build a control to enter measurements in inches with fractional units
- FormuIas - Is it possible to call a user-defined function recursively in Power Apps?
- Formulas - A beginners guide on how to create and call user-defined functions (UDFs)
- Text - How to display text and content upside down
- Dates - How to convert a month name (eg January, Feburary, March) to month number (eg, 1, 2, 3)
- SharePoint - Deleting the last record from a SharePoint list - how NOT to do this!
- The easiest way to caption images with AI in Power Apps
- Controls - Top 6 changes that are coming to Modern Controls in 2024
- SharePoint - How to check if a user belongs to a Microsoft 365/ SharePoint group
- How to fix licensing error when registering for the Power Apps developer plan
Blog Author
Tim Leung Author, software developer, Power Platform specialist |