Query a JSON array in SQL

1
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

6
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

1
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,...

1
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),...
TugaIT Preview Image

100 hours of fun: Tuga IT 2017!

0
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

4
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

2
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

1
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

0
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

0
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...