SQLSaturday #252 - Christchurch, NZ 2013
Event Date: 08/10/2013 00:00:00
Event Location:
- Christchurch Polytechnic Institute of Technology (CPIT)
- Madras Street
- Christchurch, New Zealand
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Building to scale: Overcoming Performance Hurdles
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
Track and Room: Track 1 - N/A
Title: Are you High? Can you Recovery?
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
Track and Room: Track 1 - N/A
Title: Using Event Notifications with SQL Server
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
Track and Room: Track 1 - N/A
Title: Code-Less Securing of SQL Server
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
Track and Room: Track 1 - N/A
Title: 10 easy ways to improve data quality
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
Track and Room: Track 1 - N/A
Title: SQLSaturday #252 - Keynote and Introduction
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
Track and Room: Track 1 - N/A
Title: Microsoft SQL Server – Project Hekaton
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
Track and Room: Track 1 - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Dave Dustin
Twitter: - venzann
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.
Argenis Fernandez
Twitter: - DBArgenis
LinkedIn: Argenis Fernandez
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.
Rob Douglas
Twitter: - Rob_DouglasNZ
LinkedIn: Rob Douglas
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.
Ray Bachert
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.
Martin Catherall
Twitter: - MartyCatherall
LinkedIn: Martin Catherall
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.
David Curlewis
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). ;-)
Brent McCracken
Twitter: - @sqldba_nz
LinkedIn: Brent McCracken
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.
Sponsors
The following is a list of sponsors that helped fund the event: