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

Windows Calculator

Do you know Windows Calculator can do more than simple calculators.  Probably you may used different views of calculators like Standard, Scientific, Programmer and Statistics.  But do you know you can do more with Windows Calculator!!

Unit Conversion

Date Calculation (Even Excel cannot do this as simple as it is!!)

Lease Calculation

Fuel Calculation

VHD as a Drive

You can mount the VHD as a drive using simple UI.

1. Open Disk Management (from run you can use diskmgmt.msc)
2. Select Attach VHD
3. 
4. Alternatively you can also use the Diskpart to achieve the same

Microsoft Office Save – Backstage view

It is annoying to select the Save location every time to Computer when your most used location is local computer.  Though I hate to choose every time, explored the option to get rid of it.

Open the File –> Option Menu choose Save tab.

Use the following two options to make your preferences

• Don’t show the Backstage when opening or saving files: (To complete get rid of the backstage view)
• Save To Computer by default: (Just to make the Computer as the default on backstage view)