sqlsathistory

Nr: 252

Back to Main list

SQLSaturday #252 - Christchurch, NZ 2013

Start Time (24h)	Speaker	Track	Title
00:00:00	Brent McCracken	Track 1	Using Event Notifications with SQL Server
00:00:00	Dave Dustin	Track 1	Microsoft SQL Server – Project Hekaton
00:00:00	David Curlewis	Track 1	Building to scale: Overcoming Performance Hurdles
00:00:00	Martin Catherall	Track 1	SQL Saturday #252 - Keynote and Introduction
00:00:00	Ray Bachert	Track 1	10 easy ways to improve data quality
00:00:00	Rob Douglas	Track 1	Are you High? Can you Recovery?
00:00:00	Argenis Fernandez	Track 1	Code-Less Securing of SQL Server

SessionID: 10717

Using Event Notifications with SQL Server

Back to calendar

Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Brent McCracken

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.

SessionID: 12234

Microsoft SQL Server – Project Hekaton

Back to calendar

Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Dave Dustin

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.

SessionID: 12911

Building to scale: Overcoming Performance Hurdles

Back to calendar

Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: David Curlewis

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!

SessionID: 19761

SQL Saturday #252 - Keynote and Introduction

Back to calendar

Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Martin Catherall

Title: SQL Saturday #252 - Keynote and Introduction

Abstract:

Keynote and introduction to all sessions and tracks at SQL Saturday #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.

SessionID: 22625

10 easy ways to improve data quality

Back to calendar

Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Ray Bachert

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.

SessionID: 23237

Are you High? Can you Recovery?

Back to calendar

Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Rob Douglas

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.

SessionID: 9777

Code-Less Securing of SQL Server

Back to calendar

Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Argenis Fernandez

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!

This site is open source. Improve this page.