This event has ended

SQL Soton - SQL at the Weekend [Saturday 12th of July]

Southampton SQL Server User Group

Saturday, 12 July 2014 from 08:00 to 18:00 (BST)

Southampton, United Kingdom

SQL Soton - SQL at the Weekend [Saturday 12th of July]

Ticket Information

Type Remaining End Quantity
SQL Soton - SQL At the Weekend   more info 2 Tickets Ended Free  

Who's Going

Loading your connections...

Share SQL Soton - SQL at the Weekend [Saturday 12th of July]

Event Details

Southampton SQL Server user group will be hosting a free full day event at Southampton University Science Park on Satuday the 12th of July 2014.

There are a number of speakers confirmed that will be coming in from around Europe (Slovenia, Germany, Netherlands, Poland) with a further two speakers to be confirmed.


Sessions 

Time   Session   Speaker   Title
08:00 Registration
09:00    Introduction   John & Steph       Event Introduction                             
09:15   Session One   Jonathan Allen  
LogParser-quicker than SSIS, easier than BCP
 
This session will introduce people to a free tool from Microsoft that will speed up adhoc data import processes and file parsing among other data manipulation uses. LogParser uses a SQL-like query language to work with data in many formats (CSV, IISW3C, HTML, XML, ADS, REG, EVT, BIN and many more) and can convert the data into may outputs types (CSV, NAT, SQL, W3C, XML etc). It has many uses and can be employed in many ways to assist a busy DBA.
10:15 Break  
10:30   Session Two   Dave Morrison  
Statistics, Estimation &  Plan Caching - The Big Three

In this session we will take an in depth look at statistics, how they are built, stored and used. We will go over why they are so important and what role they play in selecting a query plan. We will also take a look into estimation and how this affects query plan selection and how estimation and statistics tie together. Also in this session we will take a look into plan caching, what it is, why it is done and how it can be both a help and a hindrance. Using lots of demos and examples attendees will leave the session with a greater understanding of these three key areas and also the tools and techniques to work with and understand them in their own environments.
11:30 Break  
11:45   Session Three   William Durkin    
Database Replication - What, How, Why?

Database replication doesn't get much attention, especially now that the AlwaysOn features have been released into the wild. However, replication offers another way to make data available on multiple servers/locations that steps outside of "normal" HA/DR scenarios. This session will explain what database replication is, what the different parts are that make up the replication architecture and when/why you would use replication. The content will be valid for all versions of SQL Server from 2005 onward.
12:45 Lunch  
13:45   Session Four   Tobiasz Koprowski    
Windows Azure Databases for Beginners

The special edition of Microsoft's SQL Database - The Cloud Edition. The special edition of this session - presenting first time for SQL Soton Event. Even this session is dedicated for beginners, we going a little deeper than You expected. In a first part of my session we executing a short version of SWOT analyze, in a second we trying touch the sky, and at the end we discuss about our (the SQL DBA's), future.
14:45 Break  
15:00   Session Five   Andre Kamman    
Running SQL Server 2014 On A Scale Out File Server

A few years ago when someone would suggest to run SQL Server on a file share I would protest and start a rant about latency versus throughput etc.
But today I think that some of the coolest new features of SQL Server 2014 are actually Windows Server 2012 R2 features. In this session I will show you how to use Storage Spaces and Auto Tiering and some other features to build a highly available, fast, scale out file server. And then we'll use it to host SQL Server data & log files on it. Which is fully supported when using SQL  Server 2014.
16:00 Break  
16:15   Session Six   Mladen Prajdic    
SQL Server and Application Security for Developers

A lot of companies have a philosophy of ship early with as much features as possible.
Thoughts about security are an afterthought since it isn't fun to do and no one will attack them anyway.
But the dark side never sleeps and  security breaches have always happened. 
Many have left companies severely exposed or even bankrupt.
In this session we'll look at a few attack vectors that can be used against your company,
and what you as a developer can and should do to protect against them.
It will involve good mix of security conscious SQL Server and application development. 
Because you care about your work and nobody messes with you. 
17:15 Prize Draw  
17:30 Close  

 


Event Details 

The event will be comprised of one hour sessions covering a variety of SQL Server topics covering DBA, Development and Business Intelligence.

Bacon rolls and coffee will be provided for breakfast during registration with a light buffet at lunch time and free tea and coffee througout the day.

 


 

Location Details

Directions

Post Code: SO16 7NP

This event is being held at the Southampton University Science Park located beside Chilworth Mannor hotel. In order to get to this location, you need to take the second left (University Parkway) after the Cilworth Arms pub. Not the first left onto Mannor Road which is where many Satalite Navigation systems will direct you.

The venue is in Venture House which is the first left off University Parkway.

Parking

There is plenty of free parking availalable on the site.


Speakers

Jonathan Allen (@FatherJack)

Jonathan has been working with SQL Server since 1999. He enjoys performance tuning, development and using SQL Server to provide appropriate business solutions. He is the founder and leader of the PASS SQL South West user group http://www.sqlsouthwest.co.uk, is a moderator at SQL Q + A forum ask.sqlservercentral.com and is on twitter at @fatherjack. He has spoken at SQLBits and SQL in the City, SQL Saturdays and local user groups across the UK and Europe.
---------------------------------------

Dave Morrison (@tsqlninja)

Dave Morrison is senior BI consultant for Itelligence. Having worked in the IT industry for around 14 years his main area of expertise is SQL Server, namely TSQL, query optimisation, indexing, performance tuning and internals etc.

---------------------------------------

William Durkin (@sql_WilliamD)

William Durkin is a SQL Server DBA with 8 years’ experience starting with SQL Server 2000, born in the UK and now based in Germany. He has worked on small single user instances, medium volume OLTP systems and multi-TB data warehouses. His most recent project was creating a world-wide, 12 site transactional replication system (buy him a drink and he'll tell you the story!)

---------------------------------------

Tobiasz Koprowski (@KoprowskiT)

Community leader focused on SQL Server, SharePoint, security, collaboration, and ITIL, DR, BCM and SLA. Love licensing stuff. MCT, Freelancer, consultant. Conducts audit projects, consulting and implementation in Poland and across Europe. Member of the Boards of Directors in GITCA EMEA and  Polish Information Processing Society (Lower Silesia District). Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and several communities in the world. MVP for SQL Server since July 2010. Former president of the Polish SQL Server USer Group. Creator of SQLDay Conference. Active blogger (owner of five) and international speaker with many different conferences experience. Co-author of SQL Server MVP Deep Dives Volume Two.

---------------------------------------

Andre Kamman (@AndreKamman)


---------------------------------------

Mladen Prajdic (@MladenPrajdic)

Mladen has professionally started programming in 1999 in Visual C++ 6. Since 2002 he's been developing business oriented applications in .Net and SQL Server.

He especially likes to optimize slow SQL statements. His interests include database optimization, testing and tuning.

In his free time he develops hugely popular SQL Server Management Studio add-in called SSMS Tools Pack (http://ssmstoolspack.com).


 

Sponsors

This event is sponsored by SpectrumIT, who have been kind enough to help sponsor the user group for over two years now. Without their support we would not be able to put this event on for free.

Spectrum are a local recruitment company who specialise in the IT job market.

SpectrumIT

 

We are also lucky enough to have Wrox providing prizes for us to give away during the event.

Do you have questions about SQL Soton - SQL at the Weekend [Saturday 12th of July]? Contact Southampton SQL Server User Group

When & Where


2 Venture Road
Southampton Science Park
SO16 7NP Southampton
United Kingdom

Saturday, 12 July 2014 from 08:00 to 18:00 (BST)


  Add to my calendar

Organiser

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 Organiser

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.