SQLSaturday #818 - Malaysia 2019
Event Date: 01/26/2019 00:00:00
Event Location:
- Microsoft (Malaysia) Sdn Bhd
- Level 17 18, Menara Shell, No. 211, Jalan Tun Sambanthan
- Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Let’s Build SSIS Packages with Biml – Live!
Abstract: Have you heard about the Business Intelligence Markup Language (Biml)? Maybe you’ve even seen a session about it before but you still have doubts about how easily you can make something useful out of it. In this session, we’ll use Biml to build and populate a staging area including the corresponding SSIS packages. But there won’t be any pre-compiled demos - everything is happening live! Starting with a blank staging database, we will end up building a complete solution over the course of this session to prove that you can start from scratch and still quickly be successful. Let’s see, how that goes…
PS: Even if you have not heard about Biml but are still tired of manually building SSIS packages, this is the right session for you!
Speaker(s):
- Ben Weissman
Track and Room: Information Delivery - Room 2
Title: GITHB 101 - An introduction to using Github and Git for Source Control and Open Source Projects
Abstract: In the last few years the requirement to understand and use distributed Source control systems has become an increasing part of a Data Professionals life. With the move into Open Source and community involvement even Microsoft has embraced the use of GitHub!
In this session we will investigate the setup and use of GitHub and Git for source control. Using the highly popular DBATools open source project we will also investigate getting involved in an Open Source project and the process of Pull and Push requests!
Based around personal experience of learning not to hate Source control, this session assume no experience with Git or Github
Speaker(s):
- Patrick Flynn
Track and Room: Application Database Development - Audi
Title: AIOps for Sql Server - Introduction
Abstract: For years we have been bombarded with AI-enabled/smart/intelligent features, tools and platforms. But what does it actually mean for Sql Server developers and DBAs in practical terms? Is it just marketing hype or contrary - distinct trend that has already started and impacts how and what we do, our workplaces and future careers? This session defines what AIOPs is, provides framework to measure AI, goes through the list and evaluates ‘the latest and greatest’ tools and features available in Sql Server both on-premises and in the cloud and finally shows practical use cases of the best of them that we have to adopt to stay relevant on increasingly competitive market. Let’s find out if maintenance free, self-healing, auto-tuning databases that are able to detect and automatically mitigate security risks are ready for real-world workloads! Areas covered:
- Conditional Access VS Thread Detection
- Query Store and Automatic Tuning
- Intelligent Query Processing
Speaker(s):
- Janusz Rokicki
Track and Room: Enterprise Database Administration Deployment - Audi
Title: SQL Server in “The Cloud”: High Availability and Disaster Recovery in Azure, AWS and Google
Abstract: If you are considering moving your SQL Server instances to “The Cloud” you will need to have a plan in place for both high availability and disaster recovery. In this session we will examine the three top public cloud providers and what they have to offer in terms of both high availability and disaster recovery. We will discuss where the providers are the same and where the differ. Some real life customer configurations will be presented. With content from Cloud and Datacenter Management MVP Dave Bermingham, Jason Aw will lead this session and encourages you to bring your questions specific to your environment.
Speaker(s):
- Jason Aw
Track and Room: Enterprise Database Administration Deployment - Audi
Title: Placeholder (Testing)
Abstract: We will discover what are the best new features in SQL Server 2019!
Speaker(s):
- Chiu Kiang Phua
Track and Room: Enterprise Database Administration Deployment - Room 1
Title: Orchestrating Data Movement in the Cloud
Abstract: Data sourcing has changed a lot in the past. This session walks through on orchestrating data movement by an ELT approach by sourcing data from a centralized data lake store to Azure SQL DW and performing data transformation using Azure Data Factory.
Speaker(s):
- Danaraj Ram Kumar
Track and Room: BI Platform Architecture, Development Administration - Room 2
Title: Become a SQL Ninja: SQL Server Tools
Abstract: In this session I will walk through some of the out-of-box SQL Server tools that you will need to know or never knew could be so much fun. A number of commandline utilities exist with SQL Server that we are never exposed to. In this session, I will take a tour of each of these tools and the scenario’s that real world customers used them in innovative ways. From SQL Server Management Studio to every tools will be an hour of Demo extravaganza not to be missed. This is a Zero slide but an hour of demo marathon.
Speaker(s):
- Vinod Kumar M
Track and Room: Application Database Development - Room 1
Title: ETL2.0: Data Engineering with Azure Databricks
Abstract: Spark and Azure Databricks have become game changing features in data world and processing large volume of data has never been faster. In this session , I will give a introduction to Azure Databricks, Apache Spark and will walk though step by step on how to use Azure Databricks.Additionally I will showcase how to perform ETL operations using Azure Databricks.
Speaker(s):
- Asanka Padmakumara
Track and Room: BI Platform Architecture, Development Administration - Audi
Title: Data Visualization: How to truly tell a great story!
Abstract: We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There’s a lot more to creating that story than just getting the correct information. Come learn not just the do’s and don’ts, but the whys…
Speaker(s):
- Jonathan Stewart
Track and Room: Analytics and Visualization - Room 2
Title: Optimum Environment for SQL Server
Abstract: During this session, you will learn about what is neccessary to know and learn about SQL Server to have the best performing database environment in terms of managability, performance, security, HADR and etc. SQL Server is not just only a data storage, and due to very complex and complicated interanl engines, requires to be maintained and administrated in proper manner. This session will give you enough knowledge about what you are not aware about SQL Server.
Speaker(s):
- Hamid J. Fard
Track and Room: Enterprise Database Administration Deployment - Room 1
Title: Performance Tuning for the BI Professional
Abstract: Being a BI Professional, you need all the performance tuning the DB folks get and more. In this hour, we will go over important performance tuning tips that you can use to help make your deliverables faster and more effective. We will touch on the MSBI tools of SSIS, SSAS, SSRS and PowerBI.
Speaker(s):
- Jonathan Stewart
Track and Room: BI Platform Architecture, Development Administration - Room 2
Title: Microsoft Data AI Landscape
Abstract: The Data AI technology landscape have change drastically for the past few years and we are beginning to see more real-life implementation of modern data warehouses, big data, machine learning, chat-bots IoT in customers environment. In this years keynote session, I will share Microsoft’s overall Data AI technologies and which have been the most asked about from real customers on the ground and how are they implementing the various software services components to realize business value.
Speaker(s):
- Ian Choy
Track and Room: Strategy and Architecture - Room 1
Title: Common TSQL Mistakes
Abstract: We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application’s performance. I have given this talk over 100 times now and it is always very highly rated!
Speaker(s):
- Kevin Boles
Track and Room: Other - Room 1
Title: Build Dashboards in Power BI with Real-time* Data
Abstract: In this session, we will go through architecture, components demos in order to build Power BI Dashboards with Real-time* data. Of course in fun way :)
Speaker(s):
- Khilitchandra Prajapati
Track and Room: BI Information Delivery - Room 2
Title: Modern Azure Data Warehouse
Abstract: What is a Modern Data Warehouse? How is it different from the traditional Data Warehouse architecture? Where to start building the Data Warehouse? Cloud or no Cloud?
This session will answer and expand upon each one of these questions.
From the traditional data warehouse architecture to the modern data warehouse using Azure technologies, you will learn different services that are a good fit for your solutions and how to integrate them.
Speaker(s):
- David Alzamendi
Track and Room: BI Platform Architecture, Development Administration - Audi
Title: SQL Server Big Data Clusters - A game changer?
Abstract: With SQL Server 2019, Microsoft is introducing a new couple of features for data virtualization, data mart scale out and big data analysis. They all together for the SQL Server Big Data Clusters.
Let’s take a look at what that means and how you can make use of the extended polybase capabilities, built in spark queries and more!
Speaker(s):
- Ben Weissman
Track and Room: Information Delivery - Room 1
Title: Know What Your Code is Doing to SQL Server!
Abstract: ORMs - oh how I LOVE them! As a consultant, when I see them in play at a client I go KACHIIINNNNGGGG!! :-D Seriously though, they can provide some substantial benefits for coding throughput. But if you don’t Read The Fine Manual and do some things right and avoid some major gotchas you will fall prey to one of my favorite Guruisms: “Anything that allows developers to slap code together more quickly is inversely proportional to the performance, concurrency and scalability you will get from that code”! Although this talk is based on Entity Framework, all ORMs suffer from the same flaws.
Speaker(s):
- Kevin Boles
Track and Room: Application Database Development - Room 1
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Vinod Kumar M
Twitter: - http://twitter.com/vinodk_sql
Contact: http://blogs.ExtremeExperts.com
Vinod Kumar has worked with SQL Server extensively since joining the industry over more than 17 years back. Working on various versions from SQL Server 7.0, Oracle 7.3 and other database technologies - he now works with Microsoft Technology Center (MTC) as Technology Architect. With extensive database, BI and application background, he currently helps customers maximize on the investments on technologies to solve real world business and technology integration problems. Speaker in major conferences like TechEd India (12 yrs), TechNet, MSDN, Azure Conference etc.
Jonathan Stewart
Twitter: - sqllocks
LinkedIn: Jonathan Stewart
Contact: https://sqllocks.net/
Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.
Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on
Ian Choy
Ian Choy is Microsoft#39;s Technology Solution Professional for the data platform business, working with customers on Microsoft data platform adoption, architecture design decisions and best practices. His work and passion involves partner enablement on upcoming Microsoft technology and involvement community events. Prior experiences includes managing large scale data warehouse operations, business intelligence implementations and software development projects.
Asanka Padmakumara
Twitter: - asanka_e
LinkedIn: Asanka Padmakumara
Contact: https://asankap.wordpress.com/
Asanka is an experienced data engineer who is currently performing the role of Business Intelligence Consultant in Qrious. He has worked close to 10 years in BI and data analytics field and has implemented BI solutions for different industries. As a technology enthusiastic, he enjoys conducting technical presentations both locally and internationally. He is a MCSE in Data Management and Analytics as well as a Microsoft certified Azure Data Engineer. He is passionate about Data Analytics, Business Intelligence and AI related technologies.
Janusz Rokicki
Twitter: - DataSic
LinkedIn: Janusz Rokicki
Contact: https://www.datasic.com/
Microsoft Data Platform Expert and certified Azure Solutions Architect with over 12 years’ experience working in the City of London in the Financial Services Industry (retail and investment banking, multi-asset class trading systems). He has passion for secure, high-performance, maintainable data-driven applications that can be deployed with confidence on-premises and in-cloud. With educational background in intelligent sensor networks and machine learning he is always in search of automation and optimisation opportunities.
Has presented at SqlBits, PASS Summit, SqlDay and multiple SQLSaturday events (Tel-Aviv, Kiev, Paris, Tallinn, Bonn, Bratislava, Goteborg, Kharkiv, Bucharest, Sofia, Ljubljana) and user groups.
Ben Weissman
Twitter: - bweissman
LinkedIn: Ben Weissman
Ben Weissman has been working with SQL Server since SQL Server 6.5, mainly in the BI/Datawarehousing field. He is a Data Platform MVP, MCSE Data Management and Analytics, and a Certified Data Vault Data Modeler. He is also the first BimlHero Certified Expert in Germany and a co-author of ‘SQL Server Big Data Clusters’ and ‘The Biml Book’. Ben has been involved in more than 150 BI Projects and is always looking for ways to become more productive and make SQL Server even more fun! Together with his team at Solisyon, Ben provides training, implementation and consultancy for SQL/BI developers and data analysts in upper-mid-market companies around the globe.
Danaraj Ram Kumar
LinkedIn: Danaraj Ram Kumar
Danaraj works on modern BI delivery activities that includes corporate BI data models development and data integration in the cloud.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
David Alzamendi
Twitter: - techtalkcorner
LinkedIn: David Alzamendi
Contact: https://www.techtalkcorner.com
Delivering Business Intelligence and Data Analytics Solutions with On-Premises and Cloud technologies since 2011, David Alzamendi is a Microsoft Certified Solutions Expert and event speaker who solves problems with best practice procedures and the latest technology.
David is passionate about the positive impact data can have on our lives, businesses, economy and the environment. He prides himself on using his creativity and optimism to solve what others thought impossible.
Hamid J. Fard
LinkedIn: Hamid J. Fard
I am SQL Server Data BI Platform Expert with more than 9 years’ of professional experience, I am currently Microsoft Certified Master: SQL Server 2008, Microsoft Certified Solutions Master: Charter-Data Platform, Microsoft Data Platform MVP and CIW Database Design Specialist. After a few years of being a production database administrator I jumped into the role of Data Platform Expert. Being a consultant allows me to work directly with customers to help solve questions regarding database issues for SQL Server.
Khilitchandra Prajapati
Twitter: - @khilitchandra
LinkedIn: Khilitchandra Prajapati
Contact: http://www.bigator.com/
Khilitchandra has been working with SQL Server, Data Warehouse amp; Business Intelligence projects for more than 14 yrs. He is currently working as Vice President, BI Data Analytics for UOB in Singapore.
He is community leader of Singapore PASS Chapter. He mainly works on Microsoft technologies, which includes Power BI, Azure, SQL Server, SharePoint, SSAS, SSIS, SSRS, C#.Net, VB.Net etc. He is an avid Business Intelligence enthusiast and shares his knowledge, experience expertise via this blog (http://www.bigator.com) to everyone.
Jason Aw
LinkedIn: Jason Aw
Contact: http://www.sios-apac.com/
A passionate IT leader with over 20 years of experience in in technology, infrastructure, cloud environments particularly with high availability and disaster recovery solutions for different architectures including SQL database applications.
Jonathan Stewart
Twitter: - sqllocks
LinkedIn: Jonathan Stewart
Contact: https://sqllocks.net/
Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.
Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on
Ben Weissman
Twitter: - bweissman
LinkedIn: Ben Weissman
Ben Weissman has been working with SQL Server since SQL Server 6.5, mainly in the BI/Datawarehousing field. He is a Data Platform MVP, MCSE Data Management and Analytics, and a Certified Data Vault Data Modeler. He is also the first BimlHero Certified Expert in Germany and a co-author of ‘SQL Server Big Data Clusters’ and ‘The Biml Book’. Ben has been involved in more than 150 BI Projects and is always looking for ways to become more productive and make SQL Server even more fun! Together with his team at Solisyon, Ben provides training, implementation and consultancy for SQL/BI developers and data analysts in upper-mid-market companies around the globe.
Patrick Flynn
Twitter: - sqllensman
Contact: http://sqllensman.com/blog/
Patrick Flynn is a Senior Database Administrator with 10 years experience in large 24 x 7 enterprise environments. He is a certified master for SQL Server and a regular attendee of the PASS Summit.
Has presented at SQLSaturday events in Sydney, Melbourne, Brisbane and Auckland, Edmonton and Calgary, Oslo and Cambridge
Chiu Kiang Phua
Chiu Kiang is the principal of PCK Consulting, a provider for SQL Server and Microsoft .NET development and consulting services. He works with customers and partners on technologies covering data management, business intelligence, performance tuning and enterprise integration. He is currently in his 11th year in his role as a Microsoft MVP for SQL Server.
Sponsors
The following is a list of sponsors that helped fund the event: