Category Archives: Data Platform

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

Microsoft Access Northwind 2016 accdb download

To search the NorthWind template using Microsoft Access 2013 or 2016 may not work all the time. If you need a copy of accdb 2016 then you can get a copy here https://1drv.ms/u/s!AlUZkNIm6J4hgxoGNF28YaP80ukm.

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