SQLSaturday #210 - Brisbane 2013 4/27/2013 12:00:00 AM (GMT+10:00) Brisbane SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat210 Microsoft 400 George St Brisbane , Australia 4000 http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 3238 abaX Data Partner http://www.abaxdata.com.au/ http://www.abaxdata.com.au/images/thumbs/abax_small.jpg 40 100 3252 Red Gate Partner http://redg.at/11egQ1g http://paultebraak.files.wordpress.com/2013/03/rglogo_simpletools_onwhite_rgb1.png 40 100 2983 WARDY IT Solutions Gold Sponsor http://www.wardyit.com http://www.wardyit.com/img/SQLSaturdayLogo.jpg 60 170 3237 Microsoft Partner http://www.microsoft.com/en-au/default.aspx http://i.s-microsoft.com/global/ImageStore/PublishingImages/logos/hp/logo-lg-1x.png 40 100 3236 xSQL Software Software http://www.xsql.com/ http://www.xsql.com/images/xSQLSoftware.png 40 100 12829 SQLSaturday 210 Business Intelligence Room 1 4/27/2013 12:00:00 PM 4/27/2013 1:30:00 PM 12829 SQLSaturday 210 SQL Server Administration Room 2 4/27/2013 12:00:00 PM 4/27/2013 1:30:00 PM 12830 SQLSaturday 210 SQL Server Administration Room 2 4/27/2013 8:30:00 AM 4/27/2013 9:00:00 AM 12830 SQLSaturday 210 Business Intelligence Room 1 4/27/2013 8:30:00 AM 4/27/2013 9:00:00 AM 12882 Warwick Rudd SQL Server Administration Room 2 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. 4/27/2013 10:00:00 AM 4/27/2013 11:00:00 PM 13075 Greg Low SQL Server Administration Room 2 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. 4/27/2013 2:30:00 PM 4/27/2013 3:30:00 PM 13077 Greg Low SQL Server Administration Room 2 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. 4/27/2013 11:00:00 AM 4/27/2013 12:00:00 PM 13129 Rod Colledge Business Intelligence Room 1 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. 4/27/2013 11:00:00 AM 4/27/2013 12:00:00 PM 13669 Peter Ward SQL Server Administration Room 2 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. 4/27/2013 3:30:00 PM 4/27/2013 4:30:00 PM 13670 Peter Ward Business Intelligence Room 1 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. 4/27/2013 9:00:00 AM 4/27/2013 10:00:00 AM 14330 Craig Bryden Business Intelligence Room 1 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. 4/27/2013 3:30:00 PM 4/27/2013 4:30:00 PM 14341 Victor Isakov SQL Server Administration Room 2 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. 4/27/2013 1:30:00 PM 4/27/2013 2:30:00 PM 14343 Victor Isakov SQL Server Administration Room 2 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. 4/27/2013 9:00:00 AM 4/27/2013 10:00:00 AM 14568 Mohamed Kabiruddin Business Intelligence Room 1 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. 4/27/2013 1:30:00 PM 4/27/2013 2:30:00 PM 14590 Peter Myers Business Intelligence Room 1 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. 4/27/2013 2:30:00 PM 4/27/2013 3:30:00 PM 14591 Peter Myers Business Intelligence Room 1 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. 4/27/2013 10:00:00 AM 4/27/2013 11:00:00 PM