sqlsathistory

Nr: 438

Back to Main list

SQLSaturday #438 - Malaysia 2015

Start Time (24h)	Speaker	Track	Title
10:30:00	Ian Choy	Business Intelligence	Big Data Technology Matrix on Microsoft
10:30:00	Andreas Wolter	Cloud Application Development Deployment	In-Memory OLTP Vol1 – XTP Fundamentals Future Development
11:30:00	Dr. Subramani Paramasivam	BI Platform Architecture, Development Administration	Advanced Reporting Techniques Managing Reports
11:30:00	Hamid J. Fard	Enterprise Database Administration Deployment	Unleash SQL Server 2016 Database Engine
13:30:00	Andreas Wolter	Enterprise Database Administration Deployment	“SQL Attack…ed” – SQL Server under attack via SQL Injection
13:30:00	Dr. J. Joshua Thomas	Analytics and Visualization	Visual Analytics and Data Science
14:30:00	Prabhakaran Bhaskaran	Enterprise Database Administration Deployment	Inside Transactional Replication
14:30:00	Danaraj Ram Kumar	Analytics and Visualization	Predictive Analytics with Microsoft Azure Machine Learning
15:45:00	Renganathan Palanisamy	Strategy and Architecture	Migration and Consolidation from non Microsoft DBMS to SQL Server 2014
15:45:00	Chiu Kiang Phua	Analytics and Visualization	Data Insights with Power BI

SessionID: 38254

Big Data Technology Matrix on Microsoft

Back to calendar

Event Date: 18-08-2015 - Session time: 10:30:00 - Track: Business Intelligence

Speaker: Ian Choy

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.

SessionID: 38307

In-Memory OLTP Vol1 – XTP Fundamentals Future Development

Back to calendar

Event Date: 18-08-2015 - Session time: 10:30:00 - Track: Cloud Application Development Deployment

Speaker: Andreas Wolter

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".

SessionID: 37667

Advanced Reporting Techniques Managing Reports

Back to calendar

Event Date: 18-08-2015 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dr. Subramani Paramasivam

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.

SessionID: 37755

Unleash SQL Server 2016 Database Engine

Back to calendar

Event Date: 18-08-2015 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Hamid J. Fard

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

SessionID: 38306

“SQL Attack…ed” – SQL Server under attack via SQL Injection

Back to calendar

Event Date: 18-08-2015 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Andreas Wolter

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.

SessionID: 39029

Visual Analytics and Data Science

Back to calendar

Event Date: 18-08-2015 - Session time: 13:30:00 - Track: Analytics and Visualization

Speaker: Dr. J. Joshua Thomas

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.

SessionID: 37342

Inside Transactional Replication

Back to calendar

Event Date: 18-08-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Prabhakaran Bhaskaran

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!

SessionID: 38270

Predictive Analytics with Microsoft Azure Machine Learning

Back to calendar

Event Date: 18-08-2015 - Session time: 14:30:00 - Track: Analytics and Visualization

Speaker: Danaraj Ram Kumar

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.

SessionID: 38253

Migration and Consolidation from non Microsoft DBMS to SQL Server 2014

Back to calendar

Event Date: 18-08-2015 - Session time: 15:45:00 - Track: Strategy and Architecture

Speaker: Renganathan Palanisamy

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.

SessionID: 40157

Data Insights with Power BI

Back to calendar

Event Date: 18-08-2015 - Session time: 15:45:00 - Track: Analytics and Visualization

Speaker: Chiu Kiang Phua

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.

This site is open source. Improve this page.