Am back in UMAK!

So its another Saturday of community work for me and Allan. This time, we got a chance to talk about Windows Server, Microsoft Azure and .NET in the University of Makati’s College of Computer Sciences (CCS). https://umak.edu.ph/ last week (Feb 18)

WP_20170218_10_46_28_Pro

We did a couple of Demo, to start with, Allan did the whole Azure Web App complete with the ASP.NET Core demo. I think this is a highlight of the event, us doing demo especially this .NET MVP doing the end to end scenario in less than an hour, using again limited amount of cellular data.

WP_20170218_11_14_43_Pro

Then to cap off, did a demo on Windows Server 2016 and the installation including the nano server.

Events 2017 - UMAK - Feb 18

Its my 2nd time here in UMAK and hopefully we can be back with student requests for the hands on experience. 

Advertisements

Thank you EARIST Cavite!

Its a busy but fulfilling Saturday for me and Allan driving off to GMA Cavite to conduct a tech talk on Development, Infrastructure and Security with the students of Eulogio “Amang” Rodriguez Institute of Science and Technology (http://earist.edu.ph/) last Feb 04.

Events 2017 - EARST - Feb 18

We had a blast with these enthusiastic students, eager to ask questions even if the computer lab is already jam packed! The drive was really worth it.

WP_20170204_12_50_15_Pro

It was actually fun! So being two geeks with limited amount of cellular data driving around south.

WP_20170204_14_49_44_Pro

image

WP_20170204_14_33_47_Pro

So thanks again EARIST Cavite! Hope we can be back sooner!

Deploying SQL Server 2016 Management Tools

TL;DR SSMS is now a separate 800MB+ download. https://msdn.microsoft.com/en-us/library/mt238290.aspx

Long story (Begin Rant):

As much as I can, I always deploy Windows features and products using either direct to command line or with a configuration XML or INI file. In this case, I am installing SQL Server.

image

On previous version of SQL Server you can use the INI file to indicate what features you are going to install. Syntax is FEATURES=<FEATURE><,><FEATURE>

image

And before you can add the SSMS feature by adding SSMS –or- ADV_SSMS for Management Tool Basic –or- Advanced, respectively.

There seems to be a change with SQL Server 2016 as adding the SSMS will throw an install error.

So I saw the Management Tools now  located in the installation tab and under the new stand-alone link. I remember that in order for me to add SSMS before, it is under the add features to an existing installation. But now it seems that SSMS has its own link. But be warned, it is an actual “HREF” to a webpage. https://go.microsoft.com/fwlink/?LinkId=531355

image

Yes. You guess it right, you have to download SSMS as a separate installer.

image

https://msdn.microsoft.com/en-us/library/mt238290.aspx

That link, Download SQL Server Management Studio (16.5.3): https://go.microsoft.com/fwlink/?LinkID=840946 is 898MB. Surprise!

image

Now using Philippine internet connection: See you after 3 hours or more.

image

So after downloading we can now launch the installer.

image

Next time, I will be using /Install /Quiet as my command line parameters based on the MSDN article here: https://msdn.microsoft.com/en-us/library/bb500441.aspx but for now, lets do a GUI install.

image

Wait for the setup to finish. This will not ask for your install location nor what tool to install – it will install everything on your C:\Program Files so be careful if you have SSD. Hope in the future, since this is a standalone product that we can choose which drive to use. But for now its just a straight forward install.

image

image

So after installation, launch..

image

We now have SSMS back!

image

Cool DevLife Hack on VS2015–Paste Special!

So I saw this post on MSDN Philippines and Philippine .NET Users Group Facebook feed about “cool #DevLifeHacks” that nobody else knows about. So may as well contribute to this fun.

image

And my entry! Visual Studio 2015 Paste Special! Oh Yea!

image

Simply copy any XML or JSON and turn it into instant C# Classes!

image

I am not kidding. From Weather.gov Json result, instant C# classes, complete with getters and setters from primitive types to objects.

image

How’s that for a “cool #DevLifeHack”?

SCOM: The Data Access service is either not running or not yet initialized.

Microsoft.EnterpriseManagement.Common.ServiceNotRunningException: The Data Access service is either not running or not yet initialized. Check the event log for more information. —> System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://scom01.XXXXX.net:5724/DispatcherService. The connection attempt lasted for a time span of 00:00:02.0029072. TCP error code 10061: No connection could be made because the target machine actively refused it XX.XX.1.10:5724.  —> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it

 

1

So, I got an error today on my SCOM lab. It seems some service are failing on start-up. Its been a long while since I touched SCOM and right now I wanted to “get back in the horse” since I will be doing a lot of monitoring for a new project. Might as well go back to System Center.

4

This time its fairly easy, error says the connection “Actively refused”. Basically as a developer myself, I am just going to say that the endpoint is down or is in faulted state.

I checked IIS if SCOM uses any WCF endpoint and it struck me, its TCP. Duh. Maybe its a self hosted WCF service and is running as a “Service”. Low and behold, there are a couple System Center services that are not running but its on “automatic” which is weird.

5

Started both service and viola! I can go back to my console.

6

Now back to my lab. Cheers!

image

Philippines Community Leaders Meetup with Microsoft MVP’s

banner

So I had a chance to attend this meetup hosted at Fairmont hotel last December 6.

WP_20161210_15_16_29_Pro

Got to meet new faces and met some older (much older) ones. Its an exciting time to work with these fellow leaders, especially on the OSS community here in the Philippines.

coms

So thanks to Microsoft PH DX and our South East Asia Lead for inviting us and meeting us also in the event. Hope you guys can fly back here and see you guys soon!

MVP

Side by Side comparison of Windows Server 2016 Installation Memory Utilization (Hyper-V)

So I have 3 freshly installed Windows Server Virtual Machines with nothing installed but the base operating system. These are running on Windows 10 Enterprise with Hyper-V.

1. Windows Server 2012 R2 (GUI)

2. Windows Server 2016 (GUI)

3. Windows Server 2016 (Core

image

image

image

These virtual machines are on a strict memory diet Smile I have configured all three to have 32mb available RAM but on dynamic memory.

image

With no user logged-in and with only default services running, here are the results:

image

We see that the Windows Server 2016 Core installation runs at 454 MB next to it is the GUI for 2016 then finally at 692 MB for 2012 R2.

Now with Administrator Logged-in:

image

Now with Administrator Logged-in but closing server manager for virtual machines with GUI installed.

image

Trying to install IIS on all three VM using PowerShell:

image

image

After Installation:

image

I also tried browsing the default web site installation of each IIS as seen on this screenshot and here’s the memory assignment from Hyper-V:

image

I’m signing out of the server to make sure no UI is running or services other than the web server that we have just installed.

image

*Launches 3 Visual Studio 2015 and creates 3 web performance test projects*

I have created 3 simple load test from Visual Studio to simulate browsing to the websites. If you are familiar with Visual Studio impremise load test, you will notice that the scenario is a single webtest that will be invoked multiple times by a load test. The multiplied scenario is a just basic web request.

image

Lets run the load test:

image

We are running the load test for 5 minutes:

image

And after a few more minutes:

image

I want you to draw your own conclusions based on the data that I have shown in this blog. I also wanted to publish the Load Test Results, but thats for another time. Until then, see ya!

image