Build Schedule

Advanced Filters:
  • Track

    clear all



  • Speaker


  • Level


  • Session Type

Sessions Found: 7
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:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 7
Back to Top