SQL - Security - How can users 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.

SharePoint – 2 Mistakes to avoid when importing Excel data

At some point, many app builders want to use the SharePoint feature to import Excel data into a new list. There's a 'knack' to doing this and in this post, I'll describe the settings to make this process as smooth as possible.

SQL - Don't let this DateTime bug catch you out!

With SQL Server, there is a bug that prevents us from filtering datetime columns with equality operators. All SQL Server app builders should be aware of, and this post describes the behaviour of this bug in more detail, including workarounds to the problem.

Settings - What's the purpose of the "Explicit Column Selection" Setting?

The "Explicit Column Selection" setting improves the performance of our apps. But how exactly does it work, and what problems can it cause? This post describes the setting in more detail, including demonstrations of behaviour with traces.

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.

Searching data–What you need to know about case sensitivity

It's important to understand how PowerApps behaves in terms of case sensitivity. Here are 3 things you should be aware of.

Images - How to create images that can change depending on data

If you want to build charts or images that can change depending on data, here are some blog posts you should definitely read.

Excel - Reasons NOT to use Excel as a data source

Before you choose to Excel as a data source, you must read this.

SharePoint - What you need to know about Filtering Data

Before you use SharePoint as a data source, make sure to read this to find out what problems you might encounter.

Formulas - Generating Row Numbers

Find out how to display row numbers against records.