Monthly Archives: January 2019

70-764 Administering a SQL Database Infrastructure passing

Posted on January 31, 2019 by chanmingman

I just passed this exam today. There is a lot of questions regarding failover, AlwaysOn, Database Audit. There is not much help but you can try the prepaway.com. It will probably help you with 20-25% of the questions. There were … Continue reading →

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

How to shuffle the fields in PowerApp

Posted on January 22, 2019 by chanmingman

This post is showing how to change the fields’ position in the DetailScreen of PowerApp. This is a bit trick. I have a main page of PowerApp aa below. Click on The DetailScreen to display the detail screen. Click on … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | 1 Comment

Power BI find Percentage on 2 columns in 2 different table

Posted on January 15, 2019 by chanmingman

This post is showing how to find an average if you have sum of 2 columns in 2 different tables. For example, I have Sales 1 in Sheet 1. I have Sales 3 in Sheet 2. You will think to … Continue reading →

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

Sql Server Remove all tables

Posted on January 10, 2019 by chanmingman

This post shows you how to remove all the tables in a database. Sometime you just need to refresh all the table but you don’t want to keep deleting and creating the same database. The sql statements below work for … Continue reading →

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

SQL Server on Linux Posts You Might Find Helpful

Posted on January 6, 2019 by chanmingman

This post get have the useful links to SQL Server on Linux. Wanted to share a few links based on various conversions with you all https://blogs.msdn.microsoft.com/bobsql/2018/12/18/sql-server-on-linux-forced-unit-access-fua-internals/ https://blogs.msdn.microsoft.com/bobsql/2018/12/18/sql-server-linux-fsync-and-buffered-i-o/ https://blogs.msdn.microsoft.com/bobsql/2018/12/18/sql-server-linux-directory-fsync-activities/ https://blogs.msdn.microsoft.com/bobsql/2018/12/10/sql-server-instant-file-initialization-setfilevaliddata-windows-vs-fallocate-linux/ Previous Posts involving Linux you may also find handy: https://blogs.msdn.microsoft.com/bobsql/2018/07/31/sql-server-on-linux-how-is-delete-on-close-handled/ https://blogs.msdn.microsoft.com/bobsql/2018/07/18/sql-server-on-linux-why-do-i-have-two-sql-server-processes/ … Continue reading →

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

SQL Agent System.Runtime.InteropServices.COMException: Microsoft Excel cannot access the file

Posted on January 2, 2019 by chanmingman

This post shows you one of the possible ways to resolve the error when you are running SQL Agent job and you keep getting the error “System.Runtime.InteropServices.COMException: Microsoft Excel cannot access the file”. The complete message is the one below. … Continue reading →

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