This event has ended

SQL Soton - August 7th User Group

Southampton SQL Server User Group

Wednesday, August 7, 2013 from 6:00 PM to 9:15 PM (BST)

Southampton, United Kingdom

SQL Soton - August 7th User Group

Ticket Information

Type Remaining End     Quantity
SQL Soton - August 7th 2013 17 Tickets Ended Free  

Who's Going

Loading your connections...

Share SQL Soton - August 7th User Group

Event Details

August SQL Server user group meeting.

Prizes

  • One License of SQL Data Generator from Redgate
  • Two, one month, Pluralsight passes
  • One, £20 Amazon voucher from SpectrumIT

 

Agenda

18:00 - Doors Open

18:30 - Introductions

18:45 - Dave Morrison (@TSQLNinja)

Myth Busters! Busting Common TSQL Myths

In this session we will take a look at, and hopefully bust, my list of common myths and misconceptions I see and hear about on a daily basis. We will look at areas such as Indexing / SARGability, joins & sub queries, nested views, query plans and a host of other myths. Using lots of a demos and examples attendees will walk away with a better understanding of the best ways to use TSQL and hopefully bust at least one myth or misconception that they have.

David is a senior BI consultant at itelligence. Having worked in some for of database development or another for around 14 years his areas of specialisation are sql server engine internals, tsql and query performance tuning. David has spoken at numerous conferences including several SQLBits and SQL Saturday events as well as user group meetings. He is a a confident speaker who uses humor and a down to earth approach to make even the most technical subject matters easily attainable and engaging.

19:45 - Pizza, drinks & chat.

20:00 - Stuart Moore @napalmgram )

 Automating Database Restores and Verification with PowerShell

SQL Server makes it simple to automate backups with jobs and maintenance, but doesn't provide a simple method to schedule test restores to prove the backups have worked. Using PowerShell we can write simple scripts that allow us to automate test restores from our SQL backups, and then check that the restored database is valid, consistent and usable. This session will introduce you to the basics of restoring simple databases with PowerShell scripts, and then extending this to cope with more complex situations including data file relocation, point in time restores and running DBCC checks against the restored database

Stuart has been working with SQL Server since 1998 and version 7. Splitting the years between roles as a DBA and a Developer. 
Tweets as napalmgram and blogs at http://stuart-moore.com

 

21:00 - End

Have questions about SQL Soton - August 7th User Group? Contact Southampton SQL Server User Group

When & Where



Avenue St Andrew's United Reformed Church

Southampton
SO17 1XQ

United Kingdom

Wednesday, August 7, 2013 from 6:00 PM to 9:15 PM (BST)


  Add to my calendar

Organizer

Southampton SQL Server User Group

Southampton SQL Server User Group was established in 2010 to bring together the SQL Server Community.

At our regular monthly meeting we host presentations from first timers to internationally renown speakers.

Whether you have only just downloaded SQL Server or a seasoned pro, there will be something for you.

For more information, please visit http://sqlsoton.sqlpass.org

 

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.