Category Archives: SQL Community

Come to SQL Saturday South Island

Hi all – a quick note telling you to come along and support SQL Saturday South Island.

Once again Hamish has pulled together a great group of speakers from New Zealand, Australia and even the USA. As always it is a free day of training, and you even get a free lunch thrown in, so if not for bettering your professional career and learning lots of cool new stuff – come along and grab a free lunch – cause it turns out there IS such a thing as that.

SQL Saturday South Island 2023 (#1061)

Speaking at SQL Saturday Sydney 2017

I’m very happy to once again be making a trip across the Tasman and will be speaking about Increasing your SQL Server performance at SQL Saturday Sydney on February 18th.  Check out the list of speakers here:

SQL Saturday Sydney 2017

This will be my second time presenting at the Sydney event after an enjoyable trip there last year.  If you are in the Sydney area I look forward to seeing you there.

Speaking at SQL Saturday Melbourne 2017

I’m very happy to once again be making a trip across the Tasman and will be speaking about adding Powershell to your DBA toolkit at SQL Saturday Melbourne on February 11th.  Check out the list of speakers here:

SQL Saturday Melbourne 2017

It looks like the Melbourne team have once again pulled together a great list of speakers and it will be a fantastic days SQL learnings.  If you are in the Melbourne area I look forward to seeing you there.

SQL Saturday Auckland

SQL Saturday Auckland is on October 15th and is being hosted in the Microsoft Office in the Auckland Viaduct.  I’m fortunate enough to have been selected as a speaker which will mean dusting off my HA and DR talk which I last presented back at the start of the year in SQL Saturday Sydney, and adding some new content to it.

It’s a talk I enjoy giving, because although it is very much an entry level talk it gives people an introduction to technologies they may not be familiar with or use in their own SQL environment, and usually generates some good questions and discussions about why you would choose one technology rather than another.

So if you happen to be in Auckland next weekend come along and get some great free SQL training:  http://www.sqlsaturday.com/571/eventhome.aspx

 

SQL Sentry Plan Explorer

I’m all for spreading good news as far and wide as possible.  So I wanted to make sure everyone knows that the good folks at SQL Sentry have made the pro edition of SQL Sentry plan Explorer FREE!  See this blog post for details.

Plan Explorer is a great tool, and we were lucky enough to have Sofia Ng take us through some uses for it at one of our Nelson SQL Server User Group Lightning Talks last year.  Now with all the pro features in there there’s even more reason to check it out if you haven’t already.

 

Alan Featherston(TradeMe) On Online OLTP

Register for Nelson SQL Server User Group here:

http://www.meetup.com/Nelson-SQL-Server-User-Group/events/233048026/

Summary

SQL Server In-Memory OLTP can give you the opportunity to radically speed your applications. The presentation offers a quick intro to how it works, what’s new and some guidelines about good use case scenarios.

Abstract

SQL Server Hekaton, aka In-Memory OLTP, was released in SQL Server 2014, two years later SQL Server 2016 introduces some changes that might finally help Microsoft reach wider adoption. Every DBA needs to understands how this technology works (not only Microsofts take but the state of the art of in-memory RDBMS) and what to expect when a new project might benefit from it.

Goals:

  -A basic under the hood understanding of In-Memory OLTP

  -How to monitor and possibly troubleshoot potential issues

  -Understand usage patters

  -What’s new in 2016