SQLSaturday #549 - Singapore 2016
Event Date: 08/20/2016 00:00:00
Event Location:
- Microsoft Singapore Operations Pte Ltd
- #22-01 One Marina Boulevard
- Singapore, Singapore, Singapore
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: SQL Server 2016 – The Evolution of In-Memory Technologies
Abstract: For SQL Server 2014 a completely new In-Memory Engine for memory optimized table indexes was integrated into SQL Server with in fact very limited functionality. For SQL Server 2016 the In-Memory engine is being extensively improved in terms of both scalability as well as T-SQL language support. Moreover the ColumnStore index technology has been improved and can now even be combined with memory-optimized tables. In this session, Microsoft Certified Master Andreas Wolter, will provide an overview of the new possibilities and demonstrate where a particular technology may help – or where you cannot expect benefits. If you are planning to go on SQL Server 2016 any time soon, this session shows you two of the most important features that SQL Server 2016 brings.
Speaker(s):
- Andreas Wolter
Track and Room: Database Development - L22 - CF12
Title: SQL Server 2016 Stretch Database: top to bottom
Abstract: Got tables with millions or billions of rows but can’t truncate or archive to reduce their sizes? How is that affecting your maintenance window, performance and availability? Is your CIO/CFO mandating DBAs to leverage “cheap”, “elastic compute/storage capacity” and “infinite scale” capabilities of the cloud after reading the glossy brochures? Do your users want all data, including cold/archive data always online? All this while IT budgets remain flat or are being reduced?
Find out how StretchDB can help solve some of these problems by leveraging Azure without requiring application changes in most cases. We will cover core StretchDB scenarios, recommended use cases and non-use cases. We walk through key tasks involved in enabling a database for stretch, query behavior, security model and impact to existing high availability and disaster recovery processes. We will then review existing limitations, workarounds and some recommended practices based on lessons learned from early adopters.
Speaker(s):
- Joe Yong
Track and Room: Database Administration - L21-Auditorium
Title: Power BI - Bring your data to life
Abstract: Power BI is a cloud-based business analytics service that enables anyone to visualize and analyze data with greater speed, efficiency, and understanding. It connects users to a broad range of live data through easy-to-use dashboards, provides interactive reports, and delivers compelling visualizations that bring data to life. In this session we will cover:
-
Power BI Architecture
-
Power BI Security
-
Power BI Desktop Service
-
Data Cleansing and Data Modelling capabilities
-
How to create Dashboards and Reports
-
Collaboration Sharing
-
Natural Language Query Support
-
Data Gateway
-
The session is also complimented with end-to-end demo.
Speaker(s):
- Harminder Sethi
Track and Room: Analytics, Azure and Big Data - L22 - CF15
Title: Automated and Repeatable Test Cases for SQL Server Development.
Abstract: Automated and repeatable test cases are required for agile software development. In this session we will look at some of the tools and techniques for automated testing with SQL Server. Demonstrations during the session will create tests using the Visual Studio toolset and discuss how they can be used for Test Driven Development (TDD), unit testing, integration testing and acceptance testing. The presentation will cover testing SQL Server Databases, SQL Server Analysis Services and SQL Server Integration Services. Following the session attendees will be able to incorporate these tools and practices into their projects.
Speaker(s):
- Stefan Riedel
Track and Room: Database Development - L22 - CF12
Title: Bleed Blue for the clouds – SQL Azure
Abstract: Bleed Bright Blue for the clouds in the Sky. Yes I would be presenting Microsoft Azure and how SQL Server DBA’s can benefit with Azure as your platform. This session would introduce you to Microsoft SQL Azure and helps to put Production DBA’s mind at ease that their jobs will not be going away with Azure. This session would give a complete clarity and good foundation of where to start and what would be the next step with the Azure. It would cover on how to plan for Azure and demonstrate on DTU Calculator on Azure suitability and also important tools that are very handy and crucial to understand.
Speaker(s):
- Krishna Deepak Chamana
Track and Room: Database Administration - L21-Auditorium
Title: Secrets of SQL Server - Database Worst Practices
Abstract: “OMG! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. In this session we will focus on some of the common errors and their resolution. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.
Speaker(s):
- Pinal Dave
Track and Room: Database Administration - L21-Auditorium
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 and scalability you will get from that code”! Although this talk is based on Entity Framework, most ORMs suffer from a lot of the same flaws.
Speaker(s):
- Kevin Boles
Track and Room: Database Development - L22 - CF12
Title: Think work like a Data Scientist with SQL 2016 R
Abstract: What are these DATA Scientists up to? How can we see their statistical model in our day to day familiar tool like Microsoft SQL Server?
You now have answers to these questions and thanks to Microsoft for integrating R Revolution within new SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016.
In this session, you will definitely take away a breakthrough concept of Advanced R Analytics within SQL 2016 and get ready to kick your creative horse, and go beyond your imagination on how you can build advanced analytics and impress your employers/customers.
Speaker(s):
- Dr. Subramani Paramasivam
Track and Room: Analytics, Azure and Big Data - L22 - CF15
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 SEVENTY times now and it is always very highly rated!
Speaker(s):
- Kevin Boles
Track and Room: Database Development - L22 - CF12
Title: Creating High Performance Tabular Models
Abstract: In this session James will use his experience building large cubes for large organisations and show how you can optimise all aspects of the process - preparing data for load, processing tips and how to get the thing to perform as users expect.
Speaker(s):
- James Beresford
Track and Room: Analytics, Azure and Big Data - L22 - CF15
Title: Rock Your Reports with SSRS 2016
Abstract:
SQL Server Reporting Services has really come a long way with great changes and overhauls. New capabilities features introduced with release of SQL Server 2016 are just amazing. In this session, we would touch base some of the top features capabilities offered by SSRS 2016. We will see how much we can do with it to make our Reporting simple and powerful.
Speaker(s):
- Khilitchandra Prajapati
Track and Room: Analytics, Azure and Big Data - L22 - CF15
Title: Security with SQL Server - Things you never knew
Abstract: Compliance and auditing are some of the core tenants around which SQL Server based applications can be built. But understanding the intracacies of each of these fundamentals is critical to both developers and administrators alike. Come to this fun filled, demo centric and interesting session where we unearth some of these fine prints in understanding why we use SQL Server the way we use it and build the system is the most secure and locked down mode. Some of the enhancements with SQL Server 2016 make it even more compelling to look at SQL Server from a security standpoint.
Speaker(s):
- Vinod Kumar M
Track and Room: Database Administration - L21-Auditorium
Title: SQL Server Performance Tuning - Parallelism
Abstract: During query optimization, SQL Server is looking for queries or index operations that might benefit from parallel execution. This session will give you a better understanding of parallelism in SQL Server. The default server configurations are no longer enough for controlling parallelism, as a DBA, you need to know how to tweak the settings to make it run optimally. When parallelism goes wrong, it can cause performance problems to SQL Server. Sometimes only for a particular query, sometimes it can hurt performance server-wide. What is best practices to MAXDOP.
Speaker(s):
- Dharmendra Keshari
Track and Room: Database Administration - L21-Auditorium
Title: Data Storage and Analytics with Azure Data Lake
Abstract: With all the capabilities required to make life for developers, data scientists, and analysts a tad simpler this session will investigate how we can use Azure Data Lake to store data of any size, shape and speed, and do all types of processing and analytics across platforms and languages.
A demo rich session we will see how we can use Azure Data Lake to solve many of the productivity and scalability challenges that prevent you from maximizing the value of your data assets.
Speaker(s):
- Glenn Morris
Track and Room: Analytics, Azure and Big Data - L22 - CF15
Title: Index Internals
Abstract: In this session we’ll dig into the internal structures of indexes. We will look at how SQL Server Navigates through the index. We’ll look at the various types of pages within the index and how SQL Server uses these different pages to access your data. We’ll look at what happens within the index as data changes. There will be lots of demos using undocumented commands as we dive into the depths of the database pages.
Speaker(s):
- Denny Cherry
Track and Room: Database Development - L22 - CF12
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
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.
Denny Cherry
Twitter: - mrdenny
LinkedIn: Denny Cherry
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
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.
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.
Glenn Morris
Twitter: - @glennrm
LinkedIn: Glenn Morris
With over 18 years of experience in the IT Industry, Glenn Morris is truly one of the most respected MVP#39;s, Microsoft Certified Trainers and Consultants in Australia.
A Mathematics graduate turned IT Wrangler, Glenn quickly immersed himself in the world of code while also looking #39;beyond the code#39; at an area that he then termed quot;Intelligent Businessquot;. Combining the code with the business processes he took a role Lecturing at the London School of Accounting and Management where he taught Programming, Performance Analytics and Business Intelligence. He subsequently moved into the Data Science which he saw as his #39;sweet spot#39; and this has been what has underpinned his IT life since.
Glenn lives on the beautiful Gold Coast of Australia.
Harminder Sethi
Harminder Sethi, is a Data Platform Solution Architect at Microsoft Singapore. In his current role he leads Data solution discussions with Enterprise Partner Group Customers to help them envision, plan and build Modern Data Architectures and new Data Culture across organizations. He leads Product roadmaps deep-dive conversations for SQL Server, Power BI, Advanced Analytics and Azure Data Services. With over 13+ years of deep experience in Data Platform domain he exhibits why SQL Server is a Mission Critical Intelligent ready Platform!
Krishna Deepak Chamana
Twitter: - @kd_kdssg
LinkedIn: Krishna Deepak Chamana
Contact: http://www.kdssg.com/blog
Krishna Deepak (aka KD) is founder of Knowledged Dedicated SQL Server Group (KDSSG) community in Bangalore, India operating since 2007. Regular speaker at SQLSaturdays, KDSSG MSSQL Tech Unite. He has 14+ years of experience on Data Platform, Windows Powershell and Virtualization and Azure Cloud. He is MCITP and having specialized skills on HA/DR Implementations, Advanced Backup and Recovery, Upgradations and Migrations, Performance Tuning/Optimization, Powershell and Azure Cloud. When not with SQL Server and his family, he spends time in Gym.
Stefan Riedel
LinkedIn: Stefan Riedel
Stefan Riedel has been working with databases for more than 15 years, the last 10 of which have been focused on Microsoft SQL Server. Stefan has led and contributed to the implementation of many data warehouse and business intelligence solutions built using the Microsoft BI stack. To support these projects Stefan has designed and implemented automated testing and deployment tooling to support agile BI development methodologies. Stefan has presented at previous SQLSaturday events in Melbourne, Brisbane and Singapore.
Pinal Dave
Twitter: - pinaldave
LinkedIn: Pinal Dave
Contact: https://blog.sqlauthority.com
Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 30 Pluralsight courses and has written over 5000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.
Dharmendra Keshari
LinkedIn: Dharmendra Keshari
Contact: http://dharmendrakeshari.com/
Dharmendra Keshari has strong and in-depth experience in Database Management. Currently, working as Senior Database Administrator at Micron Technology in Singapore and handling one of the most critical databases which are being used by Singapore Public Hospitals, national specialty centres and polyclinics. Dharmendra is an avid, regular mentor on social media, helping several enthusiast in solving their problems related to Database management. he is co-leader and regular speaker at Singapore SQL Server Pass Chapter (User Group). He has done certification for “Microsoft SQL Server#174; 2008, Implementation” and “Maintenance amp; Administering Microsoft SQL Server 2012 Database”.
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.
James Beresford
Twitter: - @BI_Monkey
LinkedIn: James Beresford
Contact: http://www.bimonkey.com
James - aka the BI Monkey - has been delivering Microsoft BI Solutions for over a Decade. He#39;s an unashamed SSIS geek and is responsible for the heavily downloaded BI Monkey ETL Framework on Codeplex. Recently he#39;s been digging in to Data Quality Services in SQL2012 and also developing on the HDInsight Big Data platform.
In his spare time he cultivates two small BI Monkeys - so really has no spare time!
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.
Joe Yong
Twitter: - sqlmojoe
Joe is currently in the Azure SQL Data Warehouse team working primarily on the storage engine and tier-1, Petabyte (almost) enterprise data warehouse scenarios. Prior to this, he was the PM owner of SQL Server 2016 Stretch Database; the first truly hybrid database in the industry.
Joe cut his database teeth on Oracle serving hard time as a developer then DBA. One too many ORA-01578 later, he joined Microsoft to work on SQL Server in the areas of upgrade/migrate, performance, scalability and security on both on-premises and Azure services. Between stints in the product group he spent several years as a consultant designing, deploying, managing and fixing large and/or distributed SQL Server systems around the world.
Sponsors
The following is a list of sponsors that helped fund the event: