SQLSaturday #438 - Malaysia 2015
Event Date: 08/18/2015 00:00:00
Event Location:
- Microsoft Malaysia
- Level 26, Menara 3 Petronas, KLCC
- Kuala Lumpur, 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: Inside Transactional Replication
Abstract: You can probably do a good job in configuring and maintaining transactional replication in your environment. You can get these things done with reasonable quality without knowing how SQL Server does things under the covers. However if you want to take your skills to the next level and troubleshoot complex replication issues, it’s crucial to know how transactional replication works internally.
This session will answers questions like; How does the log reader know where to start the scan? How does it add the commands to the Distribution database? How many threads are involved in a replication process? How does distribution agent look for pending transactions to distribute to its subscribers? Knowing all these will help you to manage and troubleshoot the replication very effectively. Come lets learn together!
Speaker(s):
- Prabhakaran Bhaskaran
Track and Room: Enterprise Database Administration Deployment - Audi1
Title: Advanced Reporting Techniques Managing Reports
Abstract: Any data that we have today is delivered to end users as reports and dashboards.
=gt; When it is more than 50 reports, 10 departments, 300 users, how to manage the department categories by folders, reports, users, groups security? =gt; What are the techniques to implement linked reports, subscriptions, report history, snapshot options? =gt; How to edit reports using browser based Report Builder and reuse some of the report parts? =gt; How to build a report that is very simple to use but has advanced capabilities? =gt; How do I see the subscription information that stores data in XML format within ReportServer database? =gt; How to take ownership of a deployed report(s) using T-SQL and is it healthy modifying the data using T-SQL directly on the DB?
There are plenty of things that we can do with Reporting services, Report Manager and you can find answers for all above questions in this session.
This session also helps you identify the performance bottleneck in poor performing SSRS solutions.
Speaker(s):
- Dr. Subramani Paramasivam
Track and Room: BI Platform Architecture, Development Administration - Audi2
Title: “SQL Attack…ed” – SQL Server under attack via SQL Injection
Abstract: One of the most often successfully attacked targets is the data that resides in a database server. SQL Server is considered “secure by default”, but this is only relevant until the first databases and configurations have been changed. Which is why most of the exploited weaknesses are due to misconfiguration or weak coding practices as opposed to security bugs in SQL Server itself, of which we had the first one since 7 years in 2014. In this purely demo-based session, I will show several real-life attacks, from mere reading up to disrupting service availability via various types of manual SQL Injection, including a broadly unknown elevation of privileges attack for a non-sa account. If you have a database-server which is accessible by processes beyond your direct control or that even can be reached by some kind of frontend applications and you are unsure regarding the possible security implications to watch out for, this session is meant for you.
Speaker(s):
- Andreas Wolter
Track and Room: Enterprise Database Administration Deployment - Audi1
Title: In-Memory OLTP Vol1 – XTP Fundamentals Future Development
Abstract: SQL Server 2014 introduced a completely new storage engine: XTP (Codename “Hekaton”) which offers so called memory optimized tables + indexes and natively compiled stored procedures. Both features together enable for potentially enormous performance-gains: from 3 up to 30 times compared with standard indexes and standard T-SQL. Of course, practice is somewhat more complex and it is important to understand which workloads truly can benefit from this technology and what migration challenges you may encounter. In this introductory session, enriched with a few demos, I will make sure, that everyone gets a basic understanding of In-Memory OLTP concepts and terminology. Also we will take a first glance on the upcoming SQL Server 2016 developments in In-Memory, which combine the mighty ColumnStore technology for DataWarehousing with XTP under the marketing-term “Real-time Operational Analytics In-Memory OLTP”.
Speaker(s):
- Andreas Wolter
Track and Room: Cloud Application Development Deployment - Audi1
Title: Visual Analytics and Data Science
Abstract: Visual analytics combines automated analysis techniques with interactive visualizations for an effective understanding, reasoning and decision making on the basis of very large and complex datasets”. To enable data analysts to explore large datasets involving varied data types (for example, multivariate, geospatial, textual, temporal, networked), flexible visual analysis tools must provide appropriate controls for specifying the data and views of interest to selectively visualize the data, to filter out unrelated information to focus on relevant items, and to sort information to expose patterns. Data analysts also need to derive new data from the input data, such as normalized values, statistical summaries, and aggregates. This session will highlight on Microsoft’s Power Query, Power Map to explore relevant data sources.
Speaker(s):
- Dr. J. Joshua Thomas
Track and Room: Analytics and Visualization - Audi2
Title: Data Insights with Power BI
Abstract: If you’re trying to make sense of ever-growing piles of data, and you’re into data discovery, visualization, and collaboration, get ready for Power BI. Learn about the tools you need to provide faster data insights to your organization, including Power Query, Power View, and natural language querying. We also showcase the new PowerBI.com portal, dashboards, and the Power BI Designer.
Speaker(s):
- Chiu Kiang Phua
Track and Room: Analytics and Visualization - Audi2
Title: Migration and Consolidation from non Microsoft DBMS to SQL Server 2014
Abstract: This session will touch on concerns and techniques as well as tools to be considered when migrating and consolidating to SQL Server 2014 especially from Oracle DBMS to SQL Server.
Speaker(s):
- Renganathan Palanisamy
Track and Room: Strategy and Architecture - Audi1
Title: Unleash SQL Server 2016 Database Engine
Abstract: This all-demo session will focus on SQL Server 2016 new features and some old features which can provide better database administration and performance. The breakout of this session is as below: 1- OLTP Performance Enhancement 2- Security Enhancement 3- Hybrid Database Environment 4- SQL Server and Big Data (Hadoop) 5- SQL Server Database Development Enhancement
Speaker(s):
- Hamid J. Fard
Track and Room: Enterprise Database Administration Deployment - Audi1
Title: Big Data Technology Matrix on Microsoft
Abstract: Big Data means different things to different people. Understand the technologies in use today that can bring business value out of Big Data.
Speaker(s):
- Ian Choy
Track and Room: Business Intelligence - Audi2
Title: Predictive Analytics with Microsoft Azure Machine Learning
Abstract: This session will introduce the audience on concepts and general overview of machine learning and how end users can benefit from the predictive analytics. The session will be conducted with various case scenarios and customer stories and challenges. The second half of the session, Azure Machine Learning will be introduced with technical demonstration by building an end-to-end machine learning prediction for various case scenarios using Azure Machine Learning and general algorithms to be used will be also discussed.
Speaker(s):
- Danaraj Ram Kumar
Track and Room: Analytics and Visualization - Audi2
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Andreas Wolter
Twitter: - AndreasWolter
LinkedIn: Andreas Wolter
Contact: http://www.andreas-wolter.com/blog/
Andreas Wolter is a Program Manager for SQL Server- and Azure Security at Microsoft. In this role he is working on Security features of SQL Server, Azure SQL Database and Managed Instance. He is currently focusing on “Separation of Duties”-concepts and RBAC-Integration. He has 18 years of experience with SQL Server before joining Microsoft and is the founder of Sarpedon Quality Lab, the Germany-based company specialized on SQL Server HA, Performance and Security. He is Microsoft Certified Master (MCM) for SQL Server and Microsoft Certified Solutions Master for the Data Platform (MCSM) and was recognized as MVP for multiple years in row.
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.
Dr. Subramani Paramasivam
Twitter: - https://twitter.com/dageop
LinkedIn: Dr. Subramani Paramasivam
Contact: http://www.yoursqlman.com/index.php/blogs
Dr.SubraMANI Paramasivam is a Microsoft MVP, PhD, Microsoft Certified Trainer and Head of Data AI at DAGEOP Ltd having 21 years of DB, BI, Analytics and AI experience. Mani has also spoken in various events like MS IGNITE, PASS Summit, MS Inspire, SQLBITS, Power Platform Summit, Global AI Bootcamp, Data BI Summit, SQLRelay, Power BI World Tour, Data Platform Summit, INSIDESQL UK, Global AI Nights, SQLServerGeeks Summit, MCT Global Summits, Data Day Events and various user group events. Mani also believes in Empowering Every Person in the planet and spreads the awareness on Global challenges via www.EmpoweringEveryPerson.com. He is also a co-owner of 1 Global AI Meetup and 3 Power BI PUG PASS local / user groups.
Deh Hui Chuan
LinkedIn: Deh Hui Chuan
Deh Hui brings with her a breadth of marketing, business and technology experience on the data platform, having started off as a Microsoft Certified Professional on SQL Server early in her career, having done business analysis with data tools - SAS/ SPSS and now marketing the data platform stack - SQL Server, Power BI, Datazen, Revolution Analytics. She is well recognized having won accolades such as NextGen Marketing Leader, Leadership Development and Talent Acceleration programs.
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.
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.
Prabhakaran Bhaskaran
Contact: http://www.pythian.com/blog/author/Bhaskaran/
Prabhakaran is SQL Server consultant at Pythian, a company based in Ottawa, Canada, specializing in Remote database services. He is former SQL Server Support Engineer at Microsoft. He always loves to learn and share his knowledge.
Andreas Wolter
Twitter: - AndreasWolter
LinkedIn: Andreas Wolter
Contact: http://www.andreas-wolter.com/blog/
Andreas Wolter is a Program Manager for SQL Server- and Azure Security at Microsoft. In this role he is working on Security features of SQL Server, Azure SQL Database and Managed Instance. He is currently focusing on “Separation of Duties”-concepts and RBAC-Integration. He has 18 years of experience with SQL Server before joining Microsoft and is the founder of Sarpedon Quality Lab, the Germany-based company specialized on SQL Server HA, Performance and Security. He is Microsoft Certified Master (MCM) for SQL Server and Microsoft Certified Solutions Master for the Data Platform (MCSM) and was recognized as MVP for multiple years in row.
Dr. J. Joshua Thomas
Dr. J. Joshua Thomas, MSc, Ph.D., is currently a senior lecturer in department of computing at the School of Engineering, Computing and Built Environment, KDU Penang University College. He received his PhD in Intelligent Systems Techniques from University Sains Malaysia. He is currently work with machine learning (Deep learning) problems in computer vision, cross industry standard process for data science/mining (CRISP-DM) targeting manufacturing sensor dataset modelling, evaluation and deployment, Big data visual analytics and its applications. He has published academic articles from his research domain as book chapters, journal articles and conference proceedings. He has experience in Microsoft PowerBI, Azure Machine Learning studio.
Renganathan Palanisamy
LinkedIn: Renganathan Palanisamy
A well experience SQL Server Practitioner and Consultant with keen interest on migration and consolidation task. Especially from non Microsoft DBMS such as Oracle , IBM DB2 and MySQL to SQL Server.
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: