Skip to content

Sam Tran ( 陈偉明)

Business Intelligence Developer (MCSE)

Home
About Me
Blog
Reading
Site Statistics
CV
Contact

Capture

Posted on April 28, 2018 by Sam Tran

Post navigation

Leave a Reply Cancel reply

Search for:

Social

Facebook
Twitter
LinkedIn
YouTube
Google+
Tumblr

Video Gallery

Follow me on Twitter

Past Blogs

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 Tabels In 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

Untangle and Understand DLL Dependencies with NDepend

If you do any development beyond the most basic on the .Net Framework, understanding and resolving DLL dependencies is a necessity and a fact of life and without the right tools to guide you, this can be a very time consuming and frustrating exercise. … More Untangle and Understand DLL Dependencies with NDepend

Horizontal Partitioning for Big Tables

Partitioned Tabels It’s fairly common knowledge amongst database professionals partitioned tables can help considerably with performance in various situations but my guess is not many would have considered the enormous benefits when it comes to archiving, a necessity when it comes to massive tables. … More Horizontal Partitioning for Big Tables

Linked Servers for Azure’s NoSQL Cosmos DB

Despite its reputation, I'm still a massive fan of linked servers. Microsoft developed it for a reason and it's ongoing presence on the platform since day one says it all. No one told you to pull back a gazillion rows on an inner join with a local table. So, when I saw it's now possible ... … More Linked Servers for Azure’s NoSQL Cosmos DB

Get productive with Syncfusion

I have to say it didn’t come as a total surprise one of my more popular blogs (according to LinkedIn Stats and Google Analytics) was on places where you can pick up some great free e-books because let’s face it, we all like free things. … More Get productive with Syncfusion

CLR Integration: Bringing functionality and productivity to SQL Server

If you’ve been following the recent developments for SQL Server, you’ve probably noticed Microsoft is not only bringing more and more features onto the platform but also increasingly encouraging developers to extend the base functionalities through integration with other programming languages including those outside the core .Net languages of C# and VB.Net. … More CLR Integration: Bringing functionality and productivity to SQL Server

Continuous development and cool freebies

There was a popular post on LinkedIn recently that pointed to a blog that contained stacks of free Microsoft e-books. … More Continuous development and cool freebies

SSIS C# Interoperability

One of the things I love most about Microsoft is the deep integration of its vast array of products. … More SSIS C# Interoperability

JSON with SQL 2016

When I first read the reviews for SQL 2016 over a year ago just before its official release, one of the things that got me excited was JSON was finally coming to SQL Server. … More JSON with SQL 2016

Categories

.Net/C# (6)
API (3)
Audit (1)
Azure and Cloud (3)
Coding Practice (1)
General/Social (5)
Industry (3)
NoSQL (1)
Security (1)
software (2)
SQL Performance (1)
SQL/BI (5)
SSAS, OLAP (1)
SSIS (1)
SSMS (3)

Archives

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 February 16, 2019 at 9:00 pm – 10:00 pm
Busy March 6, 2019 at 5:00 pm – 6:00 pm
Busy April 12, 2019 at 12:00 am – 1:00 am

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.

Email Address

Location

1 Harbour Street, Sydney 2000

+61-428-069-521