sqlsathistory

Nr: 210

Back to Main list

SQLSaturday #210 - Brisbane 2013

Start Time (24h) Speaker Track Title
00:00:00 Craig Bryden Business Intelligence Introducing Microsoft Data Explorer for Excel
00:00:00 Greg Low SQL Server Administration Windows Azure SQL Databases - Lessons Learned
00:00:00 Greg Low SQL Server Administration Understanding SQL Server Indexing
00:00:00 Mohamed Kabiruddin Business Intelligence Agile BI with SQL Server 2012
00:00:00 Peter Myers Business Intelligence Big Data Analytics with PowerPivot and Power View
00:00:00 Peter Myers Business Intelligence Introduction to SQL Server 2012 MDS and DQS
00:00:00 Peter Ward SQL Server Administration Finding the SQL Server Go-Faster Switch
00:00:00 Peter Ward Business Intelligence Achieving Infinite Scale with HDInsight
00:00:00 Rod Colledge Business Intelligence Self-Service Business Analytics in 2013
00:00:00 Victor Isakov SQL Server Administration Windows Server 2012: How It Changes the "SQL Server Game"
00:00:00 Victor Isakov SQL Server Administration SQL Server Optimization: Tuning the Processor, RAM, Disk and Network Subsystems
00:00:00 Warwick Rudd SQL Server Administration Pimp my Availability Groups

SessionID: 11986

Introducing Microsoft Data Explorer for Excel

Back to calendar

Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Craig Bryden

Title: Introducing Microsoft Data Explorer for Excel

Abstract:

In this session, I will introduce the audience to Microsoft Data Explorer for Excel. "Data Explorer" is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access. It has often been referred to as the end-user ETL tool, but I believe that it will also be a valuable tool for all technical staff. This demo rich presentation will expose many great features of the newest addition to the Microsoft self-service offering.

SessionID: 14818

Windows Azure SQL Databases - Lessons Learned

Back to calendar

Event Date: 27-04-2013 - Session time: 00:00:00 - Track: SQL Server Administration

Speaker: Greg Low

Title: Windows Azure SQL Databases - Lessons Learned

Abstract:

There seems to be a perception that working with Windows Azure SQL Databases is just a case of redirecting your connection strings to the cloud. In this session, Greg will explain why that isn't the case, explain what is and isn't provided by WASD, and detail lessons that he has learned from working with this environment.

SessionID: 14819

Understanding SQL Server Indexing

Back to calendar

Event Date: 27-04-2013 - Session time: 00:00:00 - Track: SQL Server Administration

Speaker: Greg Low

Title: Understanding SQL Server Indexing

Abstract:

There are a lot of misconceptions in the community about how indexes do and don't work in SQL Server. In this session, Greg will make sure that you have a solid understanding of the core concepts and will dispel many of the common myths.

SessionID: 20011

Agile BI with SQL Server 2012

Back to calendar

Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Mohamed Kabiruddin

Title: Agile BI with SQL Server 2012

Abstract:

In a world where executives/CXOs are keen to perform analytics and data consolidation with lightning speed, there is a strong push towards incorporating the principles of Agile manifesto in the BI world to deliver solutions faster than ever before. In this session, I will share techniques that will help a BI consultant deliver BI solutions without having a formalised requirements document and how these techniques ultimately add more value to any given business. The session will involve case studies and practical demos using Team Foundation Server and SQL Server 2012's BI tools - SSIS, SSRS, SSAS (tabular) and Excel PowerPivot.

SessionID: 21970

Big Data Analytics with PowerPivot and Power View

Back to calendar

Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Peter Myers

Title: Big Data Analytics with PowerPivot and Power View

Abstract:

This presentation will introduce big data analytics for the business analyst with PowerPivot and Power View. It will be of interest to those new to the concept of big data, new to self-service data modelling with PowerPivot, and those interested to understand what is new for PowerPivot and Power View in Excel 2013.

Demonstrations will include creating a big data solution by using HDInsight Server; producing a PowerPivot model based on the big data solution; using PowerPivot to integrate big data with local data; and, analyzing the PowerPivot model data by using Power View.

SessionID: 21971

Introduction to SQL Server 2012 MDS and DQS

Back to calendar

Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Peter Myers

Title: Introduction to SQL Server 2012 MDS and DQS

Abstract:

This presentation introduces the upgraded features of SQL Server 2012 Master Data Services (MDS) and the new service, SQL Server 2012 Data Quality Services (DQS).

MDS is a solution for master data management. First released in SQL Server 2008 R2, this upgraded version includes many new features and enhancements, including a new web interface developed with Silverlight, an Excel add-in to support simplified model creation and easier data updates and management.

DQS is a new knowledge-driven data cleansing solution, and it supports building knowledge bases that provide correction and de-duplication of data.

SessionID: 22064

Finding the SQL Server Go-Faster Switch

Back to calendar

Event Date: 27-04-2013 - Session time: 00:00:00 - Track: SQL Server Administration

Speaker: Peter Ward

Title: Finding the SQL Server Go-Faster Switch

Abstract:

In this fast paced world there is an ever increasing need to squeeze extra performance out of your SQL Server environment. SQL Server will always run well when there are no applications running on it – but when you need to scale the database to thousands of transactions a second what do you do? In this session Peter Ward from WARDY IT Solutions (www.wardyit.com) will empower you with numerous tips and tricks on to finding the “SQL Server Go-Faster Switch” based on real-world experience from some of the largest SQL Server implementations in APAC.

SessionID: 22065

Achieving Infinite Scale with HDInsight

Back to calendar

Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Peter Ward

Title: Achieving Infinite Scale with HDInsight

Abstract:

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 extend the scalability of Microsoft SQL Server by using HDInsight and how to achieve 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.

SessionID: 23379

Self-Service Business Analytics in 2013

Back to calendar

Event Date: 27-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Rod Colledge

Title: Self-Service Business Analytics in 2013

Abstract:

In this session, I make the case for Self-Service Analytics as one part of a broader reporting and analytics strategy. On its own, Self-Service Analytics struggles to deliver business users the insights they need, but when combined with a corporate BI platform, the power of Self-Service Analytics shines, and the often toxic relationship between the IT department and the Business changes to one of mutual respect and working together to achieve common goals. After laying the foundations, we'll launch into a range of demos covering PerformancePoint dashboards, SSRS Report Alerts, Report Builder Report Parts, Power View, Pivot PowerPivot. All demos will show how corporate BI solutions can be extended and enhanced with Self-Service Analytics.

SessionID: 27415

Windows Server 2012: How It Changes the "SQL Server Game"

Back to calendar

Event Date: 27-04-2013 - Session time: 00:00:00 - Track: SQL Server Administration

Speaker: Victor Isakov

Title: Windows Server 2012: How It Changes the "SQL Server Game"

Abstract:

Windows 2012 is out! And it potentially completely changes how you deploy your SQL Server infrastructure.

As a DBA, you should understand Microsoft's new operating system and its important set of features that impact SQL Server and your high availability solution design. In this session Victor Isakov (MCA, MCM, MCT, MVP) will present a session on the benefits that Windows 2012 brings to SQL Server, how to install and configure Windows 2012 for a SQL Server deployment, and explore new features that will affect your virtualization and high availability architectures.

SessionID: 27417

SQL Server Optimization: Tuning the Processor, RAM, Disk and Network Subsystems

Back to calendar

Event Date: 27-04-2013 - Session time: 00:00:00 - Track: SQL Server Administration

Speaker: Victor Isakov

Title: SQL Server Optimization: Tuning the Processor, RAM, Disk and Network Subsystems

Abstract:

You can't escape hardware or the laws of physics. Ultimately your SQL Server instance will be using the processor, memory, disk and network subsystems!

In this session Victor Isakov (MCA, MCM, MCT, MVP) will go through the various subsystems and examine how the SQL Server database engine works with them. Along the way he will discuss how to tune both the hardware and SQL Server for optimal performance.

SessionID: 27664

Pimp my Availability Groups

Back to calendar

Event Date: 27-04-2013 - Session time: 00:00:00 - Track: SQL Server Administration

Speaker: Warwick Rudd

Title: Pimp my Availability Groups

Abstract:

AlwaysOn Availability Groups became available in SQL Server 2012. They provide a more granular approach to providing High Availability for you databases. In this session Warwick will introduce you to how you can utilise your AGs with Replication, Change Tracking Change Data Capture.