SQL Soton - SQL at the Weekend [Saturday 12th of July]
Saturday, 12 July 2014 from 08:00 to 18:00 (BST)
Southampton, United Kingdom
San Francisco, California
London, United Kingdom
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.
|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: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: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.
|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.
|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: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.
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.
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.
There is plenty of free parking availalable on the site.
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).
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.
We are also lucky enough to have Wrox providing prizes for us to give away during the event.
When & Where
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