Query a JSON array in SQL
For the purpose of this post, lets not evaluate the db design option and lets focus on the operations on the json column.
Lets say we have a table of...
Sending an email with attachments using Outlook and PowerShell
A few days ago, I had to find a way to automatically send an email with attachments, at a predetermined time, using Outlook and PowerShell. I decided to use...
Force Image Cache Refresh Programmatically
The best solution I found, to force the browser cache to refresh for an image, is to modify the image url in the html.
Example:
I have an image with this...
SP Editor – Create and update SharePoint Online/SP2013/SP2016 css/js files, inject files to web,...
Hi Everyone!!!
Today i will share a fantastic Google Chrome Extension that you can use on your developments on SharePoint.
A Google Chrome Extension for creating and updating files (js, css),...
100 hours of fun: Tuga IT 2017!
Tuga IT is surely one of the best and biggest tech events happening at Portugal.
Look at this:
A three-day event with a full day of workshops and two full days...
SharePoint Templates – Understand the differences
Hey Everyone!
Today i will talk about SharePoint Site Templates, and explain the main difference between each template and how it is extremely important to have in mind what each...
Converting a Vertical Table to an Horizontal Table in SQL Server
Today I've encountered a vertical table in an SQL Database and I wanted to transform it to an horizontal one. A vertical table is described as an EAV model.
Imagine...
Add scheduled adaptive live tiles to your UWP app
Today I'll help you add some bling to your UWP apps (and maybe something useful) with scheduled live tiles using the built-in features on the W10 SDK and some Azure...
log4net PatternLayout and PatternConverter
I have the following scenario:
I'm using Unity dependency injection container and interception techniques to log some WCF operation calls. I need to log the input parameters and also the...
nettiers – GetBy Index problem with StoredProcedure long name
Today I've discovered a problem with CodeSmith nettiers templates because it was possible to generate two SPs with the same name, for different entities.
This happens when there are two indexes for...