SSAS cannot find database after deploy

This short blog shows you where to find the SSAS database that you deployed.

After you deployed the SSAS cube in Visual Studio and you started SQL Server Management Studio then choose Analysis Services. You did not get to see the database you deployed.

ssas

The reason is, only the Administrator can see the SSAS database, I am not sure why is Microsoft doing that. It seems this is only way I can resolve this for now. This is SQL Server 2012, the newest version might have change the behavior, I am yet to try test.

 ssas1

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

Migrate from Docs.com to OneDrive

This short blog is showing you how to migration from Docs.com to OneDrive.

If you are a Docs.com users like me then unfortunately if should receive an email to notify you Docs.com is going to close down on 15 December 2017. Click on the link on your email then you will reach the migration page below. Click on Start Migration.

The site will bring you to Let this app access your info? And you have no choice but to click on Yes.

You will then receive a message on top of your Docs.com with only a Dismiss button.

Refresh the page then you will see a link to your OneDrive.

Microsoft has created curation site then Docs.com but I am not sure what is next and how can we migrate the data from our OneDrive to the new platform. We might not even able to do that but to recreate from the scratch again.

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

AMD ATI Radeon Driver keep crushing my Windows 10

This blog just to let you know ATI Radeon Driver can crush your Windows 10 version 1607 very bad.

I don’t dare to say what I suggest here is bullet proof solution but just make sure you don’t see any AMD related software in your Programs and Features (your software installation) then your life could be better.

In additional, Disable any in Windows Services.

I am really not sure how AMD is doing the QA control for their Engineering software but it is kind of disappointment to me.

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

Could not load System.Data.SqlServerCe.Entity.dll. Reinstall SQL Server Compact – Visual Studio 2017

This short blog show you how to resolve “Could not load System.Data.SqlServerCe.Entity.dll. Reinstall SQL Server Compact” in Visual Studio 2017.

Both Visual Studio 2015 and Visual Studio 2017, and even if you install SQL Server 2014 or SQL Server 2016 it does not add up to Microsoft SQL Server Compact 4.0.

You need to download the Microsoft SQL Server Compact 4.0 x86 or x64 to make in work even though your project already has System.Data.SqlServerCe.dll.

https://www.microsoft.com/en-us/download/details.aspx?id=17876

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

HTTP code 407 Proxy Authentication Required when connect to TFS using Visual Studio

This short blog is showing you how to resolve the error “HTTP code 407 Proxy Authentication Required” when you are connecting to Visual Studio Team Services using Visual Studio 2015.

When you want to connect to Visual Studio Team Services from Visual Studio then you get the error below.

clip_image002

Go to Tool -> Extensions and Updates

clip_image004

Click on the Updates.

clip_image006

Close the Extensions and Updates dialog and try to connect to VSTS again.

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

System.ValueTuple is missing

This short blog shows you how to fix the error System.ValueTuple is missing is Visual Studio.

You are happily type in the follow code into Visual Studio 2017.

class Program

{

    static void Main(string[] args)

    {

        List<Order> orders = new List<Order> { new Order { orderId = 1, productId = 1, sales = 20f },

        new Order {orderId=2, productId=2, sales = 30f},

        new Order { orderId=3, productId=3, sales=40f} };

 

        var t = GetOrders(orders);

 

        Console.WriteLine(“Sum: {0}, Count: {1}”, t.Sum, t.Count);

    }

 

    static (float Sum, int Count) GetOrders(List<Order> orders)

    {

        var r = (s: 0f, c: 0);

 

        foreach (Order od in orders)

        {

            r.s += od.sales;

            r.c += 1;

        }

        return r;

    }

}

 

class Order

{

    public int orderId { get; set; }

    public int productId { get; set; }

    public float sales { get; set; }

}

When you build the code above you realized there is an error saying System.ValueTuples is missing and you have .NET Framework 4.6.2 running.

Visual Studio 2017 is no longer like the previous version .NET Framework 4.6.2 itself is insufficient for the new C# features. You need to download the Microsoft .NET Framework 4.6.2 Developer Pack https://www.microsoft.com/en-us/download/details.aspx?id=53321 in order to get your code build successfully.

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

System.Data.Sqlclient for .NET Core

This is a quick tip for getting System.Data.Sqlclient for .NET Core console app.

When you look for EntityFramework in Nuget

clip_image002

then you will get the error “Package restore failed. Rolling back package changes for ‘ConAppNetCore’”.

Get the Microsoft.EntityFrameworkCore.

clip_image004

This one works for me.

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