SQLSaturday #202 - Edinburgh 2013

Event Date: 06/08/2013 00:00:00

Event Location:

  • University of Edinburgh
  • 18 Holyrood Park Road
  • Edinburgh, , United Kingdom

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: SQL Azure from Plan, to Backup, to Cloud

Abstract: Microsoft released SQL Azure more than two years ago - that’s enough time for testing (I hope!). So, are you ready to move your data to the Cloud? If you’re considering a business (i.e. a production environment) in the Cloud, you need to think about methods for backing up your data, a backup plan for your data and, eventually, restoring with Red Gate Cloud Services. In this session, you’ll see the differences, functionality, restrictions, and opportunities in SQL Azure and On-Premise SQL Server 2008/2008 R2/2012. We’ll consider topics such as how to be prepared for backup and restore, and which parts of a cloud environment are most important: keys, triggers, indexes, prices, security, service level agreements, etc.


  • Tobias Koprowski

Track and Room: Track 1 - N/A

Title: SQL Server AlwaysOn for Dummies

Abstract: Welcome to Microsoft’s world of the buzzword. Yes, they’ve done it again and created another ambiguous term that no one really understands. AlwaysOn is a powerful group of highly available technologies, and in this presentation, we will delve into their murky world reveal the technology behind the buzz.

Focusing specifically on the two key components of SQL Server 2012 AlwaysOn in Failover Clustered Instances and Availability Groups, we will investigate their pre-requisites, setup, administration, use drawbacks. We will look at: Using Windows 2008, 2012 and Server Core Windows Clustering Quorum Failover Clustered Instances Availability Groups Readable Secondaries Clustering Tools and PowerShell Dummies and higher are welcome


  • Mark Broadbent

Track and Room: Track 1 - N/A

Title: Thinking Big Understanding PDW

Abstract: Do you design and build Data Warehouses? Are you interested in learning about big data design challenges and how you can avoid them? Would you like to know more about Parallel Data Warehouse (PDW), MPP Architectures and Microsoft’s Big Data Platform? If so then this is the session for you.

We will visit the architectural components of PDW and look at some of the new features available in V2. We will also dive into some of the lessons learned developing systems for PDW in the field.

You will leave this session understanding why you should be thinking about PDW for your data warehouse and how you can accelerate the delivery of your PDW project.


  • James Rowland-Jones

Track and Room: Track 1 - N/A

Title: Data Explorer - The future of selfservice ETL

Abstract: Data Explorer is an Information Worker focused ETL Tool integrated in Excel 2013. We will show this cool new tool to mash up data from different data sources (from Facebook to ODATA, from SQL Server to Files in a table). We will show in many live demos transformations and will go into the formular engine and possibilities for using it with PowerPivot and PowerView as an output.


  • Oliver Engels

Track and Room: Track 2 - N/A

Title: SQL Server 2012 Integration with MDS DQS

Abstract: Data Quality Services is a solution for helping maintain the quality of data and ensure the data is suited for business usage. MDS is the solution for master data management in the enterprises by providing a central data hub to ensure the consistency of data across different applications and environments. In this session we will have a quick look at the basics of DQS and MDS in SQL Server 2012 and discuss the integration of DQS and MDS with the enterprise environments along with some interesting demos.


  • Sanjaya Padhi

Track and Room: Track 2 - N/A

Title: Session Details not available

Abstract: Session Details not available


  • n/a n/a

Track and Room: Track 2 - N/A

Title: Troubleshooting Query Plan Quality Issues

Abstract: When the query optimizer inaccurately estimates the number of rows for query execution plan iterators, performance can suffer due to the generation and use of a suboptimal plan. Fixing cardinality estimate issues will help the query optimizer generate a higher quality plan. This session will teach you how to identify cardinality estimate issues in your query execution plan and also cover various ways in which cardinality estimate issues can be addressed.


  • Joe Sack

Track and Room: Track 1 - N/A

Title: Hadoop for the Business Intelligence Professional

Abstract: Microsoft have teamed with HortonWorks to provide their own distribution of Hadoop running on both Windows Server as well as Azure. This shows a real intention on looking to Big Data. Being able to store huge amounts of data is no good if you do not have the tools to get the information back out. Luckily Microsoft have those tools in PV and PP. This session will be broken into 2. Allan will set the scene with Hadoop and give us a tour of what is on offer and quickly how to look at the data. Jen will then follow this up and really drive some business benefits from the data stored in Hadoop.


  • Allan Mitchell

Track and Room: Track 2 - N/A

Title: Microsoft Access Power Hour

Abstract: This fun and demo packed hour is a look at some of cool stuff you can do with Micosoft Access and SQL Server


  • How you can create complex data entry forms in 2 minutes
  • Use access as a RAD or prototyping tool
  • Publish database forms to sharepoint
  • Create complex reports
  • No need for ETL processes. Learn how to master the black art of cut and paste.
  • Go behind the scenes to see how access uses extended properties to extend SQL Data Models
  • How to create a 200 user access solution (we have one!)
  • Some horror stories and how people abuse Access

Rotten Tomatoes Provided for anyone that really hates Microsoft Access


  • Bob Duffy

Track and Room: Track 2 - N/A

Title: Analyzing Twitter Data

Abstract: This session will concentrate on explanation of how to start using and analysing the data from one of the most popular social networks - Twitter. We shall take a look at the different dashboards and we shall try to understand some of the meanings. This presentation shall try to explore the best of the existing Microsoft technologies for an accessible Twitter data analysis.


  • Niko Neugebauer

Track and Room: Track 2 - N/A

Title: Solving Complex Problems with Extended Events

Abstract: New to SQL Server 2008, Extended Events provide a refreshingly new method of looking at what occurs inside of SQL Server. This session will show you how to leverage Extended Events to solve complex problems by identifying the root cause faster than other methods of data collection provide.


  • Jonathan Kehayias

Track and Room: Track 1 - N/A


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Tobias Koprowski

Twitter: - @KoprowskiT

LinkedIn: Tobias Koprowski

Contact: http://koprowskit.eu/geek/

Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff.

Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador.

Traveler. Coffee Addicted.

Joe Sack

Twitter: - @JoeSackMSFT

LinkedIn: Joe Sack

Joe Sack is a Principal Program Manager in the SQL Server product team at Microsoft, with a focus on the Query Optimizer. Joe is an author and speaker with over 18 years of experience in the industry, specializing in performance tuning, high availability and disaster recovery.

Niko Neugebauer

Twitter: - NikoNeugebauer

LinkedIn: Niko Neugebauer

Contact: http://www.nikoport.com

Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.

Bob Duffy

Twitter: - @bob_duffy

LinkedIn: Bob Duffy

Contact: http://blogs.prodata.ie/author/bob.aspx

Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM. and Analysis Services Maestro certified.

Bob works as a Database Architect at the Prodata SQL Centre of Excellence where he specializes in business intelligence and performance tuning.

Allan Mitchell

Twitter: - @allanSQLIS

Contact: https://onlysearch.wordpress.com/

Allan Mitchell is a SQL Server MVP and runs elastio, a small consultancy helping customers to make informed decisions about their data storage and integration. His focus is on enterprise search as well as real-time data integration.

Sanjaya Padhi

Twitter: - @sqlinsider

Contact: http://blogs.msdn.com/sqlserverfaq

Sanjaya Padhi has worked at Microsoft for more than 6 years and on SQL Server since 2004. He’s worked on the SQL Server Support team for more than 4 years and is currently a SQL Server PFE in Europe. He’s passionate about SQL Server, especially replication, performance tuning, and SQL Server BI. Recently, he’s been delivering workshops and chalk talk sessions to customers about the latest and upcoming SQL Server releases.

Mark Broadbent

Twitter: - retracement

LinkedIn: Mark Broadbent

Contact: http://tenbulls.co.uk

Mark Broadbent is a Microsoft Certified Master in SQL Server, Chapter Leader, Virtual Chapter Leader, SQLSaturday Cambridge and SharePoint Saturday Cambridge founder (the UKs first SQLSaturday) and awarded Microsoft#39;s Community Contributor award in 2011 and the PASS Outstanding Volunteer award in 2012. Mark is a regular speaker at both International and National events and is an expert in HADR solutions, SQL Server migration, and SQL Server Concurrency control.

n/a n/a

Jonathan Kehayias

Twitter: - @SQLPoolBoy

Contact: https://www.sqlskills.com/blogs/jonathan

Jonathan Kehayias is a Principal Consultant and trainer with SQLskills, and has been recognized as a Microsoft Data Platform MVP for over 10 years, and was the youngest person ever to achieve the Microsoft Certified Master – SQL Server certification. He has presented at numerous conferences including PASS Summit and SQL Rally, SQLBits, VMware Open Forum, SQLintersection, and multiple SQLSaturdays around the world. As a performance tuning and high availability expert for SQL Server, Jonathan has architected and implemented complex systems and solutions for some of the worlds most challenging workloads.

Oliver Engels

Twitter: - @oengels

Contact: http://www.ssis-components.net

Oliver Engels is CEO of oh22data AG, a Microsoft Gold Partner in Germany specializing in CRM and BI. His special interests are Azure, Data Governance and Integration, Visualisation Tools like SSRS, Power BI, Tableau, R, and SharePoint. He has worked with SQL Server since version 6.5 and is a founder and Board member of PASS Germany, a PASS Regional Mentor, and runs the Frankfurt PASS Local Group. For more than seven years he is a Microsoft Data Platform MVP and a Microsoft pTSP.

James Rowland-Jones

Twitter: - https://twitter.com/jrowlandjones

LinkedIn: James Rowland-Jones

James Rowland-Jones (JRJ) is a Principal Program Manager at Microsoft. He is currently part of the SQL Server team working on SQL Server 2019 Big Data Clusters and data virtualization. Prior to joining SQL Server, JRJ worked extensively on Azure SQL Data Warehouse. He helped the team launch Gen 1 of the service and led the product management effort to bring Gen 2 into preview.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page