It was about 4 years ago that I’ve wrote a custom function to split a delimited string in T-SQL. I’ve wrote that because there was no split function for SQL Server at that time. Fortunately SQL Server 2016 comes with new excitements, and built-in split function is one of them. The new String_Split function is Read more about Split Function in SQL Server 2016[…]
Thanks to all attendees to my session today at SQL Saturday Sydney. It was a pleasure to have you all in front of me, and having those great questions and feedback from you. This was my second time in Sydney, and I’m looking forward to the next gathering hopefully next year. Special Thanks to Grant Read more about Presentation Materials for My Session at SQL Saturday Sydney 2016[…]
Thanks to all who attended on our pre-con, and sessions on SQL Saturday Melbourne. It was an awesome event, and we proud that we’ve been participating there at least as speakers. SQL Saturday Melbourne 2016 had 350 registrations. About 30 technical sessions, with the keynote from Mark Souza. Many international speakers as well as local. Read more about SQL Saturday Melbourne; Presentation Materials[…]
Thanks to all attendees to my webinar yesterday. It was pleasure to have you all attending in this session. I’ve uploaded session slides here and you can download them. Session was mostly demos rather than slides however. Unfortunately there was a technical issue and session didn’t recorded. I will get this recorded offline and upload Read more about Webinar Materials Ready: Power BI Rises; Wonderful Things You Can Do[…]
Power BI can connect to many data sources as you know, and Spark on Azure HDInsight is one of them. In area of working with Big Data applications you would probably hear names such as Hadoop, HDInsight, Spark, Storm, Data Lake and many other names. Spark and Hadoop are both frameworks to work with big Read more about Power BI and Spark on Azure HDInsight; Step by Step Guide[…]
Thanks to all attendees to my webinar today, with more than 400 registration I’m thrilled to say this very first RADACAD webinar was a successful step towards regular free webinars. If you are interested in future webinars please stay tuned, we will announce them all in our events page. Today’s webinar was about ETL Incremental Read more about ETL Incremental Load with SSIS; Q&A and Recording[…]
SQLBits is happening again in May 2016 this year in Liverpool, the biggest SQL Server conference in UK. This is a conference that I hadn’t yet chance to attend (I have been selected to present twice so far, but for some other reasons couldn’t attend unfortunately). So here we go; many awesome session abstract has Read more about Vote For your Favorite Sessions at SQLBits 2016[…]
It is pleasure to let you know that we will be in Australia: Sydney, and Melbourne February 2016 to deliver SSIS and Machine Learning Courses. Courses are adjusted to a one-day program with heaps of demos and handouts for audience. Our courses designed in a pragmatic approach in the way that enables you to start Read more about Our Courses: February 2016 Australia[…]
Previously I’ve mentioned how to implement Incremental Load within SSIS using CDC (Change Data Capture) feature. Unfortunately CDC is not always supported by the source database, so you have to implement an incremental load solution without CDC. In this post I’ll explain how to implement incremental load if there is a modified datetime column in Read more about SSIS Incremental Load with Datetime Columns[…]
I’ve been overseas with family and old friends till yesterday and hadn’t chance to say Happy New Year here. It’s another year beginning, and I wish you enjoy this year besides your friends and family, I wish this be a wonderful year for all of you. It is a fortunate to be in MVP award Read more about MVP awarded for 6th Year[…]