Microsoft SQL Server Management Studio for SQL Server 2016

This short article is to let you know SQL Server Management Studio is no longer part of the SQL Server installation in SQL Server 2016 and it is also not part of the ISO.

When you go to installation page like the one below you realized there is a “Install SQL Server Management Tools”.

clip_image002

Of course, I do have any SQL Server Management Server upon completion of my SQL Server 2016 installation.

 

clip_image004

I would then click the “Install SQL Server Management Tools” in the installation page and thought it will just launch the installation of SQL Server Management Tool. But it didn’t, when it does was, it brought me to an URL to download SSMS-Setup-ENU.exe. The exe is around 800MB. To a developing country, this size is not small.

When you run the SSMS-Setup-ENU.exe, you realized they have a new installation interface.

clip_image006

Finally I got the SQL Server Management Studio.  

clip_image008

The SQL Server 2016 Management Studio is still look pretty much the same as.

clip_image010

Posted in .Net, Community, Servers | Tagged , , , , | Leave a comment

Windows 10 IT Pro Essential Support Secrets Free EBook

This ebook is pretty much for end users. For IT technical guys, most likely on chapter 8 is more interesting to them.

Windows 10 IT Pro Essential Support Secrets

https://blogs.msdn.microsoft.com/microsoft_press/2016/07/14/free-ebook-windows-10-it-pro-essentials-support-secrets/?MC=Windows&MC=IoT&MC=SysMagSof&MC=Open&MC=CloudPlat

Posted in Community, Operating System | Tagged , , , , | Leave a comment

Reduce memory footprint for Windows 10

This short article shows you one of the possibilities to reduce memory footprint when you start up your Windows 10.

To reduce the memory, I choose the Windows Services to start manually o it will not be started if there are not used.

To start the Windows Services.

1.  Press Windows Key + R.

2. Type Services.msc.

clip_image001

You will then see the Services like below.

clip_image003

You can select the one you do not need and set it to start manually.

Double click one of the items and choose the Startup type to Manual.

clip_image005

For me I choose those items to Startup manually (so far so good) below based on Windows 10 1151. I have not checked in my Windows 10 1607.  You may not have some of the services in your machine. Also you might need some functions that I do not need so you need to decide on this.

Services:

AllJoyn Router Service

Application Layer Gateway Service

Bluetooth Support Service

BranchCache

Certificate Propagation

Connected User Experiences and Telemetry

DataCollectionPublishingService

dmwappushsvc

Downloaded Maps Manager

HomeGroupListener

HomeGroup Provider

Network Connection Broker

Network List Service

Remote Registry

IP Helper

Microsoft Office Click-to-Run Service

Network Location Awareness

Security Center

Skype Click to Call PNR Service

Skype Click to Call Updater

Themes

Tile Data Model server

Windows Image Acquisition (WIA)

Windows Search

Posted in .Net, Community, Operating System | Tagged , , , , , | Leave a comment

Create Tab in Office 365 SharePoint Lists

This short article shows you how to create tab look in SharePoint Custom List.

When I went to http://www.w3schools.com/howto/howto_js_tabs.asp. I saw the tab I want but how am I going to put this in my Office 365 SharePoint.

1. Create a SharePoint Custom List

2. Open SharePoint Designer 2013 and point to the SharePoint site.

3. Choose Lists and Libraries.

image

4. Choose a List, in my example is Tabblist.

image

5. Click New in Forms.

6. Name the form, for example, NewFormCust.aspx. Check the Set as default form for the selected type.

 tab

7. Click on the new form, NewFormCust.aspx, to edit.

8. Click on the Advanced Mode.

image

9. Under the line

<asp:Content ContentPlaceHolderId=”PlaceHolderMain” runat=”server”>

add the JavaScript

https://someone.sharepoint.com/sites//sitecollection/subsite%20/b%20style=   

The JavaScript as below.

function openCity(evt, cityName) {
// Declare all variables
    var
i, tabcontent, tablinks;

// Get all elements with class=”tabcontent” and hide them
    tabcontent = document.getElementsByClassName(“tabcontent”
);
for (i = 0
; i < tabcontent.length; i++) {
tabcontent[i].style.display =
“none”
;
}

// Get all elements with class=”tablinks” and remove the class “active”
    tablinks = document.getElementsByClassName(“tablinks”
);
for (i = 0
; i < tablinks.length; i++) {
tablinks[i].className = tablinks[i].className.replace(
” active”, “”
);
}

// Show the current tab, and add an “active” class to the link that opened the tab
    document.getElementById(cityName).style.display = “block”
;
evt.currentTarget.className +=
” active”
;
}

10. Under the line

<SharePoint:CssRegistration Name=”forms.css” runat=”server”/>

Add the css

<SharePoint:CssRegistration Name=https://someone.sharepoint.com/sites/sitecollection/subsite/SiteAssets/tabcontent.css runat=”server”/>

The css code as below.

.tabcontent {
    -webkit-animation
: fadeEffect 1s;
    animation
: fadeEffect 1s; /* Fading effect takes 1 second */
}

@-webkit-keyframes fadeEffect {
    from
{opacity: 0;}
    to
{opacity: 1;}
}

@keyframes fadeEffect {
    from
{opacity: 0;}
    to
{opacity: 1;}
}

11. Look for

</tr>

      <tr>

            <td width=”190px” valign=”top” class=”ms-formlabel”>

            <H3 class=”ms-standardheader”>

            <nobr>Title<span class=”ms-formvalidation”> *</span></nobr>

            </H3>

       </td>

add the follow code before that.

<tr>

   <div>

    <ul class=”tab”>

        <li><a href=”#” class=”tablinks” onclick=”openCity(event, ‘London’)”>London</a></li>

        <li><a href=”#” class=”tablinks” onclick=”openCity(event, ‘Paris’)”>Paris</a></li>

        <li><a href=”#” class=”tablinks” onclick=”openCity(event, ‘Tokyo’)”>Tokyo</a></li>

    </ul>

 

    <div id=”London” class=”tabcontent”>

        <h3>London</h3>

        <p>London is the capital city of England.</p>

    </div>

 

    <div id=”Paris” class=”tabcontent”>

        <h3>Paris</h3>

        <p>Paris is the capital of France.</p>

    </div>

 

    <div id=”Tokyo” class=”tabcontent”>

        <h3>Tokyo</h3>

        <p>Tokyo is the capital of Japan.</p>

    </div>

</div>

When you create a new item now then you should see.

image

Posted in .Net, Cloud, Community, Office 365, sharepoint | Tagged , , , , , , , | Leave a comment

How to Stop GlobalProtect client

This short article shows you how to stop GlobalProtect client in Windows Operating System.

GlobalProtect will keep restarting if you kill it using the Task Manager.

1.      To stop GlobalProtect client, click on Windows then type Services.msc.

clip_image002

2.      Look for PanGPS service then Stop it.

clip_image004

Posted in Community, Computers and Internet | Tagged , , , | Leave a comment

Inconsistent accessibility: parameter type ‘IReportRequest’ is less accessible than method ‘MyService.PrintReport(IReportRequest)’

This short blog shows you one of the possibilities to resolve the error “Inconsistent accessibility: parameter type  ,,,”

It is pretty hard to understand this error from the forums without example. Look at the example below.

interface IReportRequest

{

    void SampleMethod();

}

 

public class UserReportRequest : IReportRequest

{

    // Explicit interface member implementation:

    void IReportRequest.SampleMethod()

    {

        // Method implementation.

    }

}

 

public class PdfPrinterRequest : IReportRequest

{

    // Explicit interface member implementation:

    void IReportRequest.SampleMethod()

    {

        // Method implementation.

    }

}

 

public class MyService

{

    public void PrintReport(IReportRequest iReeport)

    {

    }

}

You will get the error below when you Build this code.

CS0051 Inconsistent accessibility: parameter type ‘IReportRequest’ is less accessible than method ‘MyService.PrintReport(IReportRequest)’

This mean your parent needs to be Public as well. So to resolve this change

interface IReportRequest

to

public interface IReportRequest

Posted in .Net, Community | Tagged , , | Leave a comment

How to create Office Add-ins for cross platform

This short article shows how to create Office Add-ins not in C# but in JavaScript.

1.                Left click on “New Project… (button)” in Start Page.

clip_image002

 

2.      Left click on “OK (text)” in “New Project”

clip_image004

 

3.      Left click on “Choose the add-in type (text)” in “Create Office Add-in”

clip_image006

4.      Choose Task pane, click on “Next > (button)” in “Create Office Add-in”

clip_image008

 

5.     Unchecked everything and left Excel,  click on “Finish (button)” in “Create Office Add-in”

clip_image010

6.      Click Start to Run the project.

clip_image012

7.      Excel will be launched and Type Hello World in Cell A1.

8.      Click Get data from selection in Task Pane.

clip_image014

The main JavaScript Home.js is in the Home folder under the AddIn folder. You can find in inside Solution Explorer.

// Reads data from current document selection and displays a notification

function getDataFromSelection() {

    Office.context.document.getSelectedDataAsync(Office.CoercionType.Text,

        function (result) {

            if (result.status === Office.AsyncResultStatus.Succeeded) {

                app.showNotification(‘The selected text is:’, ‘”‘ + result.value + ‘”‘);

            } else {

                app.showNotification(‘Error:’, result.error.message);

            }

        }

    );

}

Posted in .Net, Cloud, Community, Microsoft Office, Office 365 | Tagged , , , , , , | Leave a comment