Skip to content

Sam Tran ( 陈 偉明)

Business Intelligence Developer (MCSE)

  • Home
  • About Me
  • Blog
  • Reading
  • Site Statistics
  • CV
  • Contact

Category: Cosmos

Linked Server for CosmosDB

Linked Servers for Azure’s NoSQL Cosmos DB-Video Edition

January 26, 2019

One of my most popular post has been Linked Server for Cosmos DB. To provide greater clarity as a number of people have written to me for clarification, I’ve decided to record the actions on video. Hope this helps. … More Linked Servers for Azure’s NoSQL Cosmos DB-Video Edition

Leave a comment Linked Servers for Azure’s NoSQL Cosmos DB-Video Edition
Video Gallery

Social

  • Facebook
  • Twitter
  • LinkedIn
  • YouTube
  • Google+
  • Tumblr

Follow me on Twitter

My Tweets

Past Blogs

Power BI REST API for Python

Power BI REST API PythonOne of my more popular posts from last year was ‘Power BI REST API”. This was shown using C# but as this topic has also been asked many times on various other forums but for Python, I thought I’d write a quick piece on that. As with C# approach, the starting point is registering an … More Power BI REST API for Python

Linked Servers for Azure’s NoSQL Cosmos DB-Video Edition

Linked Server for CosmosDBOne of my most popular post has been Linked Server for Cosmos DB. To provide greater clarity as a number of people have written to me for clarification, I've decided to record the actions on video. Hope this helps. … More Linked Servers for Azure’s NoSQL Cosmos DB-Video Edition

Data Lakes Analytics-A Quick Look into Big Data on Azure

Relative to the other big data solutions, Data Lake Analytics is one of the more easier solutions to get up and running … More Data Lakes Analytics-A Quick Look into Big Data on Azure

SQL Python Integration: Unable to communicate with the runtime for ‘Python’ script. Please check the requirements of ‘Python’ runtime

After spending the whole night looking into and eventually fixing this problem, I thought I'd share my experiences as there doesn't seem to be a solution from Microsoft or anywhere on the net for this. … More SQL Python Integration: Unable to communicate with the runtime for ‘Python’ script. Please check the requirements of ‘Python’ runtime

Create a RESTful Web Service for SQL Server using OData with Entity Framework

One of the great things about the clouds is that it makes existing good technology even better and in the case of the Azure stack, also much more simpler. One example that came to mind this week was Entity Framework after reading that it now works with CosmosDB, albeit still in beta and for the … More Create a RESTful Web Service for SQL Server using OData with Entity Framework

Power BI REST API

Power BI REST APILike most modern servers nowadays, Power BI has a fairly good set of web APIs that developers can leverage to extend functionalities of the product and further automate many processes. The developer’s section of the documentation provides an easy to follow set of instructions on how to get started and showcases some very useful feature … More Power BI REST API

Serializing and Deserializing JSON

Came across a few little extensions in Visual Studio Code marketplace recently that has and will further save me considerable time when I need to work with JSON. … More Serializing and Deserializing JSON

PowerBI: Integration with Azure, Googles and other Web Services using JavaScripts

I’m my opinion, there’s no doubt Tableau is still the best and well ahead of everyone when it comes to visualization in terms of looks, functionality and ease. But that’s true only on the client side and as we know, BI is so much more than this … More PowerBI: Integration with Azure, Googles and other Web Services using JavaScripts

Auditing Database Servers with SQL Server-A Primer

Whether you're a manager, developer or DBA, SQL Auditing is a powerful tool that can help you understand what is happening within your platform and its underlying data. Auditing on SQL Server allows you to monitor your server from two different aspects: at the server level and the database level. … More Auditing Database Servers with SQL Server-A Primer

Partitioned for Performance

Partitioned TabelsIn my last blog on partition tables, I talked about the benefits from an archiving and management perspective. In this one, I'll go over the query performance that can be gained. If partitioning is something new to you, it's worth thinking it as dividing large tables into smaller ones … More Partitioned for Performance

Categories

  • .Net/C# (8)
  • API (7)
  • Audit (1)
  • Azure (1)
  • Azure and Cloud (6)
  • Coding Practice (1)
  • Cosmos (1)
  • Entity Framework (1)
  • General/Social (5)
  • Industry (3)
  • JSON (1)
  • NoSQL (2)
  • PowerBI (3)
  • Python (2)
  • Security (1)
  • software (2)
  • SQL Performance (1)
  • SQL/BI (6)
  • SSAS, OLAP (1)
  • SSIS (1)
  • SSMS (3)
  • Uncategorized (1)

Archives

  • February 2019 (1)
  • January 2019 (3)
  • November 2018 (2)
  • October 2018 (1)
  • August 2018 (1)
  • June 2018 (1)
  • April 2018 (2)
  • October 2017 (2)
  • September 2017 (1)
  • August 2017 (1)
  • July 2017 (2)
  • June 2017 (1)
  • May 2017 (3)
  • April 2017 (5)

Google Calendar

  • Busy March 6, 2019 at 5:00 pm – 6:00 pm
  • Busy April 12, 2019 at 12:00 am – 1:00 am
  • Raymond's birthday May 6, 2019 Sydney NSW 2000, Australia Ray turns four

Miscellaneous

  • Events
  • Video Gallery

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Location

1 Harbour Street, Sydney 2000
+61-428-069-521