Thank you to those for submitting some great sessions this year. It was always going to be a difficult task in selecting the final 11 sessions for the Database and BI track. Congratulations to those who have been selected and we look forward to working with you on finalizing the presentations.
Attendees please ensure you start building your schedule and selecting the sessions. You can view the full catalog at - https://australia.msteched.com/topic/list/. Below are the Database & BI related ones:
Look forward to seeing you in Gold Coast.
Data Quality Services in Enterprise Info Management
Track Database and Business Intelligence
Type Track Session
This session introduces the basic concepts of SQL Server Data Quality Services (DQS) and how to use it as part of building Credible, Consistent Data. It will cover the concepts and terminology that the product uses and the basics of how to use it to cleanse data. The session will also showcase the automation of Data Quality processes via its integration with SQL Server Integration Services (SSIS), and how it can be used to help manage reference data in Master Data Services (MDS).
Killer real world PowerPivot examples part II
This session is even more jam packed with amazing PowerPivot report examples than last years entertaining presentation. This is *the* session to attend if you want to get the most out of Powerpivot visualizations. Essentially you will see real world PowerPivot reports from clients in Education, Retail, Banking, and Telco and learn a variety of visualization techniques including sparklines, slicers, and charts. You will leave this fun session armed with plenty of ideas for your next personal BI project. Oh and watch out for flying Koala's.
Big Data for Relational Practitioners
You’ve heard the hype about Big Data, Hadoop, and so on… How does this relate to you? This session will describe how the Hadoop ecosystem relates to the ETL, Data Warehousing and BI that you are already doing. We’ll discuss what no-SQL means in practice: What is gained and what is lost. There will be some examples showing Hadoop tools like Pig, Hive and Sqoop, and when you might use them. Finally, what skills should you focus on to make the transition from relational expert to Big Data expert?
Data Mining for Fun and Profit
Kevin Clarke, Russ Blake
SQL Server Data Mining is the crown jewel of the Microsoft BI stack, delivering Best of Breed data mining algorithms packaged for ready use. But these powerful tools remain neglected on the shelf of many shops in spite of the fact that, according to Gartner Group, BI is the top priority of IT organisations over the next 5 years, with the biggest skills gap in the data mining area. We’ll demystify the data mining algorithms, terminology and tools so you can apply the technology with ease to help your organisation look into its future and adapt as needed in the present, all without any need for a Cube. EB Games will join us to discuss how they have used Data Mining to improve their countrywide retailing operations.
Scalable SQL Server design with just a Credit Card
The traditional approach to database scalability has been to simply buy a bigger box. However with the ongoing data explosion that is occurring in organisations today there is a need to re-think how to achieve scalability for the database platform. In this session we will explore how to deploy Microsoft SQL Server into a Private Cloud and how to extend this scalability as a Hybrid solution using the Azure platform. With nothing more than a credit card and the Azure platform you will see how it is now possible to create highly-available, infinitely scalable SQL Server environments that support automated deployment and elastic scale.
Keeping the Lights On with SQLServer 2012 AlwaysOn
In today’s ever changing environment, the requirements for High Availability and Disaster Recoverability are becoming more complex. Are you able to meet these requirements with your current SQL Server Stack ? With the release of SQL Server 2012, the High Availability/Disaster Recovery feature AlwaysOn provides a more granular approach and control over your environment. In this presentation we will look at how to configure, setup & monitor SQL Server 2012 AlwaysOn.
Turbocharging a Warehouse with Columnstore Indexes
Do you have data warehouse queries that run too long? Adding a columnstore index can provide a tremendous performance boost. Do you know why? Do you know when to create a columnstore index and how to get the best performance from your columnstore indexes? In this session we’ll address how columnstore indexes speed up queries, best practices for creating and using columnstore indexes, and how to diagnose and treat potential issues.
Develop a SSAS Tabular Project BI Semantic Model
In this session learn how to develop and deploy a tabular project BI Semantic Model – a new data modelling approach made available to developers in SQL Server 2012 Analysis Services. The session will cover all design features including how to load and relate data, how to enrich the model with hierarchies and calculations, and how to secure and process the model data. Additionally, it will introduce and cover Data Analysis Expressions (DAX) and how it can be used to define calculated columns, measures and KPIs. A specific emphasis will be made on the new DAX functions available in the SQL Server 2012 release. Finally, and with due emphasis, theory and discussion to help you decide when the tabular project BI Semantic Model is the appropriate modelling choice will be covered.
SQL Server Database Private Cloud Deep Dive
In this session, learn about the DPC (Database Private Cloud) Reference Architecture and how it can be used to consolidate thousands of databases on a single scalable platform. The session will drill into the hardware and software configuration and cover how its wired together. We will cover the use cases, savings, workload types and migrating workloads to the solution as well as discuss management options.
SQL Server Warehousing (Fast Track 4.0 & PDW)
Matthew Winter, Stephen Strong
Whats in Windows Server 2012 for SQL Server
James Crawshaw, Raja Narayanaswamy
Learn about the new, key Windows Server 2012 features which compliments SQL Server on its High Availability, Performance & Scalability, Mobility and Security. The session will drill into the major enhancements such as SMB( SMB Transparent Failover, SMB Multichannel, SMB Direct (Remote Direct Memory Access), SMB Scale-Out, increased performance, and more), Hyper-V (replication-HA, Scalability, Mobility and Security enhancements)