Category Archives: Data Platform

The Web Service threw an error during method execution. The error is: Unable to connect to the remote server at Microsoft.SqlServer.Dts.Tasks.WebServiceTask

This post shows you one of the possibilities to resolve the error above. I have written to Microsoft team in email as below. I spent a day to troubleshoot this but no luck. I have web service running fine in … Continue reading

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

CTO Articles March 2020

This post shares the articles and videos good for CTO. Executive Spotlight: Top Priorities For Security And Risk Leaders In 2019. This document showing a good security transformation. https://1drv.ms/b/s!Aje-DdIVpfjSi2b7rM_2d8ZkGHmL Four ways to maximize your business intelligence investments https://1drv.ms/b/s!Aje-DdIVpfjSi2geksh8VqN4d6Vb?e=cDSSp1 The Sprawling … Continue reading

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

SQL Server convert varbinary blob to Excel

This post shows you the code to convert SQL Server varbinary field back to Excel. You might get some errors if you are using the code here https://chanmingman.wordpress.com/2011/06/21/read-image-file-blob-from-binary-field-in-ms-sql-database/. The pre-requisite of this post is you need to know ADO.NET. The … Continue reading

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

SQL Server 2014 Service Pack update

This post shows you how will it look like if you are installing a Service Pack. I believe many SQL administrators out there are wondering how exactly the process is like. I show it using SQL Server 2014 because this … Continue reading

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

SQL Server Case in Where clause

This post shows how to use the Case…When keyword in WHERE clause. I found a good article which has given me the idea to do this. Firstly, create a empty database name SQLShackDemo. Create Employee table and insert the sample … Continue reading

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

Power BI Scheduled refresh greyed out

This post shows you one of the reasons the Power BI Scheduled refresh is greyed, like the one below. Below I clicked the dummy then Scheduled refresh. The Scheduled refresh is greyed out If you scroll further up then you … Continue reading

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

SQL Server list all Views

This short port is to remind me on how to list all the Views in SQL Database. SELECT OBJECT_SCHEMA_NAME(v.object_id) schema_name, v.name FROM sys.views as v order by name Reference: https://www.sqlservertutorial.net/sql-server-views/sql-server-list-views/

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