Event Location:
Christchurch Polytechnic Institute of Technology (CPIT)
Madras Street
Christchurch, , New Zealand
Abstract:
In this session I'll be using a fictional auction website's database (which I've created for demonstration purposes) to take an accelerated look at what a typical web-scale database application's performance pain points might be as it grows, both in size and load. We'll simulate some users, monitor some stuff, see what breaks, and then fix it. This will include some basic design and indexing best practices to kick things off - but we'll quickly move on to more interesting options for getting the most out of SQL Server under load. Time allowing, I'll also do some demo's on the impact that SQL Server 2014 In-Memory OLTP (i.e. Project Hekaton) tables have compared to our previous best efforts in 2012, and whether natively compiled stored procs will give us any additional zing as well!
Speaker(s): David Curlewis,
Abstract:
A look at the High Availability and Disaster Recovery options available natively within SQL server. Covering everything from backups alone to Mirroring, LogShipping and SQL Clustering. Time permitting we'll delve into the advantages and disadvantages that SQL 2012 Availability Groups present and talk about how the HA and DR landscape is changed by the advent of cloud computing.
Speaker(s): Rob Douglas,
Abstract:
Event Notifications are a great tool often not used by DBA's. I will show you how this is a good introduction into the world of Service Broker and why it is better than triggers or SQL Trace. I will demo a practical use of auditing that we use in Kiwibank that you can take away and use yourself.
Speaker(s): Brent McCracken,
Abstract:
Learn from a Microsoft Certified Master how to secure your SQL Server infrastructure and your Windows installations to enhance resiliency and minimize exposure to attacks—all without touching any of your code!
Speaker(s): Argenis Fernandez,
Abstract:
Learn 10 ways to dramatically improve your data quality using the tools you already own. This session is targeted for developers implemeting business intelligence, doing integration work or implementing new systems where data quality can make or break the success of your project.
Speaker(s): Ray Bachert,
Abstract:
Keynote and introduction to all sessions and tracks at SQLSaturday #252 Christchurch New Zealand. The event will run alongside events from the .NET group, Infrastructure group and Sharepoint / CRM group. There's a track for each so this is just to give people a taster for the rest of the day.
Speaker(s): Martin Catherall,
Abstract:
The release of Hekaton, Microsoft’s In Memory OLTP enhancements for SLQ Server, promises to change the kind of high performance solutions that can be implemented using SQL Server. In this session we'll look at what Hekaton actually is, how it achieves the 10x-50x speed improvements on the same hardware and how architects and developers can start planning future application.
Speaker(s): Dave Dustin,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
With more than 35 years industry experience, Dave has worked with organisations and data systems of all sizes. He is currently Principal Engineer at Xero.
LinkedIn: http://www.linkedin.com/in/argenis
Contact: http://blog.purestorage.com/author/argenisfernandez/
Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.
Contact: http://www.gumption.co.nz
Robs SQL history started as a remote DBA, branched into consultancy and now includes providing SQL Solutions to a variety of businesses, government departments and banks throughout Australia and New Zealand using a variety of native SQL solutions to meet their performance, higher availability and Disaster Recovery needs.
Business Intelligence and Data Quality Consultant | Founder The Data Quality Service Ray has 20 years experience in business intelligence, data quality and project management at organizations of all sizes including Microsoft, SAP, City Care, University of Canterbury and Farmlands/CRT. His goal is to make it possible for companies of all sizes to improve the quality of their data without having to spend a lot of time or money to get results.
LinkedIn: https://www.linkedin.com/in/martincatherall
Contact: http://martincatherall.com
Martin is a data consultant in Melbourne, Australia, a Microsoft Data Platform MVP, and PASS Regional Mentor for the Asia Pacific (APAC) region. Martin founded the Christchurch, New Zealand PASS Local Group and lead the group for a number of years before relocating to Melbourne. He has been using SQL Server in various roles since 2000. In addition to anything data related, he enjoys playing the guitar and having fun with his family.
Contact: http://www.curlewis.co.nz
I'm the database team lead at Trade Me; New Zealand's busiest website. I've been working with SQL for around 13 years now, and still learn something new every day (although I hope I've picked up enough tips tricks along the way that I can show you something new). ;-)
LinkedIn: http://nz.linkedin.com/pub/brent-mccracken/8/510/a34/
Contact: http://www.sqldba.co.nz
I've been working with SQL Server since v6.5 and nearly completed my MCM qualification. I am the technical lead for the database operations team in a nationwide bank in New Zealand.
The following is a list of sponsors that helped fund the event.