Like button for Outlook email

Recently my colleague was asking is there a like feature in Outlook.  I showed him the new Icon insert option.  It helped, but he was just looking for a one click solution.

Here the OneClick solution.  You need to have the below macro and introduce this as a new button in outlook menu!

Now you can start liking the emails.

Sub InsertLike()
    'Dim objDoc As Word.Document, objSel As Word.Selection
    On Error Resume Next
   
    '~~> Get a Word.Selection from the open Outlook item
    Set objDoc = Application.ActiveInspector.WordEditor
   
    Set objSel = objDoc.Windows(1).Selection
   
    '~~> Type Relevant Text
    'objSel.TypeText "Sorry cannot help"
    objSel.InlineShapes.AddPicture FileName:="https://hubblecontent.osi.office.net/ContentSVC/Content/Download?provider=MicrosoftIcon&fileName=ThumbsUpSign.svg" _
        , LinkToFile:=False, SaveWithDocument:=True
       
    Set objDoc = Nothing
    Set objSel = Nothing
End Sub

Power BI

Power BI Security White Paper - https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-power-bi-security/

Power BI YouTube Channel (Great Learning Source) - https://www.youtube.com/user/mspowerbi

Guy in a Cube: https://www.guyinacube.com/

Power BI Gateways - https://powerbi.microsoft.com/en-us/documentation/powerbi-personal-gateway/

Pricing and Key Differentiation between free and Pro - https://powerbi.microsoft.com/en-us/pricing/

Administrating Power BI in your Organization: https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-administering-power-bi-in-your-organization/

T4 Template

T4 templates are build-in feature for Visual Studio IDE.  Here is the video to get started.

https://www.youtube.com/watch?v=XK17iNvJqQs

T4 can be used in many areas.  Recently I am working on big data solutions, in which the scripting language does not provide looping mechanism.  The T4 template become handy to bridge the gap and avoid spinning up multiple jobs to process every day data.

Learning from CorpNet support help desk

Here is my learning from our Support Help desk for my CorpNet related issues.

RAS connection not working
Many time the RAS issues are due to IP cache, try the following commands to reset the IP 

• netsh int ip reset
• netsh winsock reset
• ipconfig/flushdns             
• ipconfig/flushdns
• nbtstat -R
• nbtstat -RR
• ipconfig/registerdns 

Unable to access local sites

If the group policy not updated you may have diff access issues.  By running gpupdate /force from elevated problem, you can make sure the gp is updated.

User autoenrollment is triggered by the Winlogon process (interactive logon with CTRL+ALT+DELETE keys) or at Group Policy refresh intervals. Normally, User Group Policy is refreshed at logon and Machine Group Policy is refreshed at machine reboot. Group Policy may be manually refreshed using the gpupdate.exe tool that is included in Windows XP.

https://technet.microsoft.com/en-us/library/cc728032(v=ws.10).aspx

Infographic tools

1. Easel.ly
2. Piktochart
3. Infogr.am
4. Visual.ly
5. InFoto Free
6. Venngage
7. Dipity
8. Get About
9. Vizualize: Visualize your resume
10. Google Developers : Google Chart

Data Science Cources

If you are planning to learn Data Science Space, here is the list of MOOC (Massive Open Online Courses) from edX.

1. From Indian Institute of Technology Bombay
1. Foundations of Data Structures
2. From University of California, Berkeley
1. Introduction to Apache Spark
2. Big Data Analysis with Apache Spark
3. Distributed Machine Learning with Apache Spark
3. From Microsoft
1. Data Science Essentials
2. Implementing Predictive Solutions with Spark in Azure HDInsight
3. Implementing Real-Time Analysis with Hadoop in Azure HDInsight
4. Principles of Machine Learning
5. Processing Big Data with Azure HDInsight
4. From Cornell University
1. Wiretaps to Big Data: Privacy and Surveillance in the Age of Interconnection
2. Machine Learning for Data Science and Analytivs
5. Hong Kong Polytechnic University
1. Knowledge Management and Big Data in Business

Cross Join

Recently met with a problem, where in I need to lookup a table using LINQ query where the JOIN clause is not supporting non-equi joins.  The Cross Join came as handy and helped.  Here is the sample SQL query which unit tested the same.

 

DROP TABLE BucketList
GO
CREATE TABLE BucketList
(
    StartNum INT,
    EndNum INT,
    Bucket VARCHAR(20)
)

INSERT INTO BucketList values
( 1,10,'[01-10]')
,( 11,20,'[11-20]')
,( 21,30,'[21-30]')
,( 31,40,'[31-40]')

drop TABLE #T1
go
CREATE TABLE #T1
(
    IP INT,
    Label VARCHAR(40)
)

INSERT INTO #T1 VALUES
(4,'Four')
,(9,'Nine')
,(34,'Thirty four')
,(44,'FortyFour')
GO

SELECT StartNum, EndNum, Label, Bucket
FROM #T1
CROSS JOIN BucketList
WHERE IP >= StartNum AND IP <= EndNum