Tuesday, September 12, 2017

What is Microsoft Universal Windows Platform (UWP) App?

UWP is an app for the Windows 10 and Windows 10 runs on a number of hardware devices: PC, tablet, Xbox, HoloLens, Surface Hub etc. UWP with just one API set and one app package and one store can reach all screen sizes from the smallest to the largest.

It can support different modes of interaction;
touch
mouse + key board
pen
game controller

Programming UWP apps is very flexible, just not limited to C# and XAML. You can use JavaScript(& HTML). You could also use Unity or MonoGame. You can mix them as well.

You will just one project for (any) every device you want to address.

Let me enumerate the features:
  • Common API surface across all devices
  • Extension SDKs to do specific stuff on chosen device
  • Apps packaged using .AppX packaging format and distributed from store
  • One store for all devices
  • Adaptive controls and input are supported(Keyword Responsive design)
Go on, monetize your app!

Can you access data on a web page using Microsoft PowerBI?

You can not only access data on a web page but also from very many sources shown here:


Briefly from the menu item Get Data after you launch the Power BI Desktop, you can access Web in the Get Data window. When you insert the URL of the page from which you want to extract data, the Power BI program will display all the available data in the tables in the web page in its Navigator menu.

Once you have the tables listed in the Navigator menu, just choose the table or tables and load them to the Power BI for processing. You can then query the data that you just brought in and then create the pages of reports you want to create. It is that easy.

Here is an example from a web page (Wikipedia).


Here is an example fro SAP anywhere Server:


Here is an example from a text file using Power BI


You can find many more examples from my blog here:
https://hodentekmsss.blogspot.com

Monday, September 11, 2017

How do you get Data Analysis menu item in MS Excel?

If you want to do data analysis (regression, trend line, sampling, etc) using Excel, you should be able to locate the Data Analysis menu item on your ribbon in Excel.

For example, right now I do not have this in my ribbon (Microsoft Office Business, Build 8326.2096).


You need Analysis ToolPak add-in in your Excel application.

Follow these steps to add the Analysis ToolPak add-in:
Step 1: In MS Excel click File | Options

Step 2: In Excel Options window click Add-ins


NoDataAnalysis_1.png

Step 3: In Add-ins page, click Analysis ToolPak and Go shown here.


NoDataAnalysis_3.png

The following windows opens.


NoDataAnalysis_4.png


Choose the Analysis ToolPak add-in and click OK.

Immediately Data Analysis appears in the ribbon as shown.




Click on Data Analysis and the following window opens.


These are the various tasks you can carry out.












Tuesday, September 5, 2017

Do you know these Power-Shell commands for Network Connectivity?

These are some of the commands that you may need to note. Although similar information is obtained by the Windows commands as well.

This is the version of Power Shell I am running:
-----------
PS C:\Users\Owner> $PSVersionTable.PSVersion

Major  Minor  Build  Revision
-----  -----  -----  --------
5      1      16278  1000

------------------------------------------------

Test_Connection:

Test-Connection Sends Internet Control Message Protocol request packets to one or more computers

----------------
PS C:\Users\Owner> Test-Connection Hodentek9

Source        Destination     IPV4Address      IPV6Address                              Bytes    Time(ms)
------        -----------     -----------      -----------                              -----    --------
HODENTEK9     Hodentek9       192.168.0.10     fe80::dd68:c5d6:8d40:f244%2              32       0       
HODENTEK9     Hodentek9       192.168.0.10     fe80::dd68:c5d6:8d40:f244%2              32       0       
HODENTEK9     Hodentek9       192.168.0.10     fe80::dd68:c5d6:8d40:f244%2              32       0       
HODENTEK9     Hodentek9       192.168.0.10     fe80::dd68:c5d6:8d40:f244%2              32       0    
-----------
PS C:\Users\Owner> Test-NetConnection Hodentek9

ComputerName           : Hodentek9
RemoteAddress          : fe80::dd68:c5d6:8d40:f244%2
InterfaceAlias         : Wi-Fi
SourceAddress          : 2605:e000:d803:1800:4978:3d25:95cf:ed61
PingSucceeded          : True
PingReplyDetails (RTT) : 0 ms
----------------------------------------------------

You can also run commands as shown here in Power Shell's Command Addon window as shown
here.


Resolve_DnsName

Resolve-DnsName Runs a DNS name query resolution for specified name
-----------
PS C:\Users\Owner> Resolve-DnsName Hodentek9
Name                                           Type   TTL   Section    IPAddress                             
----                                           ----   ---   -------    ---------                             
Hodentek9                                      AAAA   1200  Question   fe80::dd68:c5d6:8d40:f244             
Hodentek9                                      AAAA   1200  Question   2605:e000:d803:1800:dd68:c5d6:8d40:f244
Hodentek9                                      AAAA   1200  Question   2605:e000:d803:1800:4978:3d25:95cf:ed61
Hodentek9                                      A      1200  Question   192.168.0.10                          
* you can get the same information more descriptive using the Windows Command, IPCONFIG
------------------------------------------------------------------------------
 Test-DnsServer
Test-DnsServer Tests a computer for being a DNS Server

The command is not found in Windows 10 Professional. Perhaps this is to be run on a Windows Server OS

Help for Connection:
----------
PS C:\Users\Owner> get-help Test-Connection

NAME
    Test-Connection
   
SYNTAX
    Test-Connection [-ComputerName] [-AsJob] [-DcomAuthentication {Default | None | Connect | Call
    | Packet | PacketIntegrity | PacketPrivacy | Unchanged}] [-WsmanAuthentication {Default | Basic |
    Negotiate | CredSSP | Digest | Kerberos}] [-Protocol {DCOM | WSMan}] [-BufferSize ] [-Count ]
    [-Impersonation {Default | Anonymous | Identify | Impersonate | Delegate}] [-ThrottleLimit ]
    [-TimeToLive ] [-Delay ]  []
   
    Test-Connection [-ComputerName] [-Source] [-AsJob] [-DcomAuthentication {Default |
    None | Connect | Call | Packet | PacketIntegrity | PacketPrivacy | Unchanged}] [-WsmanAuthentication
    {Default | Basic | Negotiate | CredSSP | Digest | Kerberos}] [-Protocol {DCOM | WSMan}] [-BufferSize
    ] [-Count ] [-Credential ] [-Impersonation {Default | Anonymous | Identify |
    Impersonate | Delegate}] [-ThrottleLimit ] [-TimeToLive ] [-Delay ]  []
   
    Test-Connection [-ComputerName] [-DcomAuthentication {Default | None | Connect | Call | Packet
    | PacketIntegrity | PacketPrivacy | Unchanged}] [-WsmanAuthentication {Default | Basic | Negotiate |
    CredSSP | Digest | Kerberos}] [-Protocol {DCOM | WSMan}] [-BufferSize ] [-Count ]
    [-Impersonation {Default | Anonymous | Identify | Impersonate | Delegate}] [-TimeToLive ] [-Delay
    ] [-Quiet]  []

------------------------------------

Saturday, September 2, 2017

What is Google BigQuery?

If you want to query lots of data at great speeds, then this is the tool you should be aware of. The queries are not SQL, but SQL-like a slight variant. You can use your own data sets or use the sandbox. 



More here:

https://cloud.google.com/bigquery/docs/
You can store results on Google Cloud or download as a CSV.

Is it free? Yes, upto a certain size of data (10MB).

You can query as many times and as many queries as you like. If you are saving the data to cloud it may cost a little bit, assuming your data is a little set ($0.026 per GB/month).

You will also be working with a BigQuery browser tool. Use this tool to load data and run queries. Of course you can use a querying tool other than this as well.

Microsoft Power BI is another tool that can pull data of BigQuery according to this link here.






Friday, September 1, 2017

Is there a dashboard for SQL Server?

If you mean Server Dashboard, yes there is one.

You need to access from Reports.. menu as shown.


When you open Server Dashboard you would be able to see this one (specific to each installation).


If you do not see this and see a page full of errors, try logging in as an administrator.

Thursday, August 31, 2017

Where is the link to TypeScript 2.5?


TypeScript 2.5 (the latest) is now available for download here:

http://www.typescriptlang.org/#download-links



TypeScript2.5_0

If you have installed npm, installing TypeScript is a breeze.

> npm install -g typescript

Read here for installing npm:

http://hodentekhelp.blogspot.com/2017/08/what-is-npm-and-how-is-it-useful.html