Power Apps – Mount a SQL Server table as an entity in Dataverse
Business Case: We have a need where we have an existing database from a legacy app and we really enjoyed how easy and fast it is to use Power Apps (Model Driven app) to access entities…
-
-
Use Power Shell to execute SQL Server script files
Below is the snippet for using Power Shell to execute list of SQL scripts under a specific folder. I use this script in Octopus deployment to deploy database changes (* for this particular case, we don’t…
-
Table Valued Parameter – SQL Server 2008
Simple sample in how to use Table Valued Parameter which is a new feature in SQL Server 2008. I found it very useful to pass bulk data from one SP to another SP CREATE TYPE JobQueueBroker…
-
MERGE Insert, Update and Delete SQL Server
In SQL Server 2008, we can do a table synchronisation in one transaction of SQL Command. For example normally, we have a source table and then we have an updated records and what we would like…
-
SQL Splitting function performance
I was required to create a SQL Splitter function and I tried to browse internet to find an article about it but I never thought there is someone has done wonderful job in comparing the performance…
-
IIF in SQL Server 2012
Now you can use IIF in SQL Server 2012 instead of CASE (again this only if you have 2 possible values that you want to evaluate) –This will return Apple SELECT IIF(‘APPLE’ = ‘APPLE’, ‘Apple’, ‘Banana’)…
-
OFFSET FETCH in SQL Server 2012 – Paging
In SQL Server 2005, normally when we do paging we need to use CTE or nested SELECT Statement, but in SQL Server 2012 we can use OFFSET and FETCH to do the paging Let’s start of…
-
TRY_CONVERT in SQL Server 2012
One of the new TSQL feature in SQL Server 2012 is TRY_CONVERT, basically it’s a function that will return null if the object passed is not compatible with the expected casting. In earlier version of SQL…