Category Archives: Community

Power BI find Percentage on 2 columns in 2 different table

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

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

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

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

SSIS Script Task Read Write Variable

This post I wanted to post for quite a while but keep forgetting. In order to use Variable in SSIS Script Task there is no Intellisense. You have to remember the exact syntax for it. Very first you need to … Continue reading

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

SSIS Edit Script… not openning

This post shows you one of the remedies when your Edit Script in SSIS is not opening in Visual Studio 2017. When you need to do is to uninstall the SSDT. Reinstall it with the option Install new SQL Server … Continue reading

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

MS Access VBA accessing to SQL Server

This article expect you know how to create a Form with a button in Microsoft Access. Like it or not they are still many Microsoft Access users out there today, like a group that I am teaching today. Unfortunately C# … Continue reading

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