SQLSaturday #194 - Exeter 2013 3/9/2013 12:00:00 AM (GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat194 Jurys Inn Hotel Exeter Western Way Exeter , United Kingdom EX1 2DB http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 2907 Fusion IO Premier Sponsor www.fusionio.com http://sqlsouthwest.co.uk/images/Fusion_IO_Logo.png 60 170 3033 Fusion IO Pre-Con Sponsor http://www.fusionio.com http://sqlsouthwest.co.uk/images/Fusion_IO_Logo.png 60 170 2879 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 3097 Nexus Gold Sponsor http://www.nexusopensystems.co.uk/ http://sqlsouthwest.co.uk/images/Nexus_logo_new_strap.jpg 60 170 2908 Purple Frog Silver Sponsor http://www.PurpleFrogSystems.com http://www.purplefrogsystems.com/download/PurpleFrogLogo170.png 60 170 2910 Red Gate Software Silver Sponsor http://redg.at/RwM0f1 http://www.red-gate.com/assets/images/common/logo.png 60 170 3096 Idera Silver Sponsor http://www.idera.com http://sqlsouthwest.co.uk/images/idera_logo_ORANGE_with-tagline.png 60 170 3100 The Big Bang Data Company Silver Sponsor http://www.bigbangdata.co.uk http://www.bigbangdata.co.uk/SiteImages/BBD.170x60.png 60 170 3014 Pluralsight Raffle prize donation http://pluralsight.com/training http://s.pluralsight.com/mn/img/logo/pluralsight-fullcolor-175x39-v1.png 40 100 3131 Jurys Inn Raffle prize donation http://exeterhotels.jurysinns.com/ http://www.jurysinns.com/files/images/a/logo.gif 40 100 3135 Wrox Raffle prize donation http://wiley.com http://www.sqlsouthwest.co.uk/images/Wrox_UG.gif 40 100 11999 SQLSaturday 194 Track 1 Babbage 3/9/2013 10:15:00 AM 3/9/2013 10:45:00 AM 11999 SQLSaturday 194 Track 1 Babbage 3/9/2013 2:35:00 PM 3/9/2013 3:00:00 PM 11999 SQLSaturday 194 Track 2 Christie 3/9/2013 10:15:00 AM 3/9/2013 10:45:00 AM 11999 SQLSaturday 194 Track 2 Christie 3/9/2013 2:35:00 PM 3/9/2013 3:00:00 PM 11999 SQLSaturday 194 Track 3 Trevithick 3/9/2013 10:15:00 AM 3/9/2013 10:45:00 AM 11999 SQLSaturday 194 Track 3 Trevithick 3/9/2013 2:35:00 PM 3/9/2013 3:00:00 PM 11999 SQLSaturday 194 Track 4 Bligh 3/9/2013 10:15:00 AM 3/9/2013 10:45:00 AM 11999 SQLSaturday 194 Track 4 Bligh 3/9/2013 2:35:00 PM 3/9/2013 3:00:00 PM 12000 SQLSaturday 194 Track 4 Bligh 3/9/2013 12:35:00 PM 3/9/2013 1:45:00 PM 12000 SQLSaturday 194 Track 3 Trevithick 3/9/2013 12:35:00 PM 3/9/2013 1:45:00 PM 12000 SQLSaturday 194 Track 2 Christie 3/9/2013 12:35:00 PM 3/9/2013 1:45:00 PM 12000 SQLSaturday 194 Track 1 Babbage 3/9/2013 12:35:00 PM 3/9/2013 1:45:00 PM 12001 SQLSaturday 194 Track 1 Babbage 3/9/2013 7:00:00 AM 3/9/2013 8:00:00 AM 12001 SQLSaturday 194 Track 2 Christie 3/9/2013 7:00:00 AM 3/9/2013 8:00:00 AM 12001 SQLSaturday 194 Track 3 Trevithick 3/9/2013 7:00:00 AM 3/9/2013 8:00:00 AM 12001 SQLSaturday 194 Track 4 Bligh 3/9/2013 7:00:00 AM 3/9/2013 8:00:00 AM 12002 SQLSaturday 194 Track 4 Bligh 3/9/2013 5:00:00 PM 3/9/2013 5:30:00 PM 12002 SQLSaturday 194 Track 3 Trevithick 3/9/2013 5:00:00 PM 3/9/2013 5:30:00 PM 12002 SQLSaturday 194 Track 2 Christie 3/9/2013 5:00:00 PM 3/9/2013 5:30:00 PM 12002 SQLSaturday 194 Track 1 Babbage 3/9/2013 5:00:00 PM 3/9/2013 5:30:00 PM 12020 Tobiasz Koprowski Track 4 Bligh Are You remember 'Sliders'? In my opinion Licensing World is similar to this series. How many time You tried to understand licensing? How many times You heard different opinions about same question? I'm sure, that You know what is CPU, CORE, SOCKET. Are You familiar with Processor / User / Device? And CAL / SAL/ SA too? Are You use SPLA program or just OEM or MOLP? Physical Instance, Virtual Instance, 90 Days, EULA, SPUR, LAR, Multiplexing, 5 Dollars (not 5 Cents)... It's not all the possibilities, if we are talking about licenses. Let's talk about it, from the Licensing Point of View 3/9/2013 4:00:00 PM 3/9/2013 4:50:00 PM 12022 Phil Quinn Track 4 Bligh A basic introduction of SQL Servers XML Capabilities, it will cover access of XML using .value and exist with variations of XPATH that can potentially improve the queries, explaining Typed and Untyped XML and cover the use of Primary and Secondary Indexes with XML and how these may (or may not) affect performance, and considerations to take before using XML at all. 3/9/2013 1:45:00 PM 3/9/2013 2:35:00 PM 12026 Richard Douglas Track 1 Babbage You’ll learn simple tricks to write better code, scripts, and tables. Plus, you’ll gain a deeper understanding of common database development and administration mistakes, and how you can avoid them. Plus, you’ll learn how to take corrective action when: •The optimizer isn’t using all available processors •The database engine fails to report all the resources a query has used •The optimizer uses the wrong plan •Database tables cause memory issues 3/9/2013 4:00:00 PM 3/9/2013 4:50:00 PM 12046 William Durkin Track 1 Babbage 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, 3/9/2013 3:00:00 PM 3/9/2013 3:50:00 PM 12056 Mladen Prajdic Track 2 Christie SQL Injection is still one of the biggest reasons various websites and applications get hacked. The solution as everyone tells us is simple. Use SQL parameters. But is that enough? In this session we'll look at how would an attacker go about using SQL Injection to gain access to your database, see its schema and data, take over the server, upload files and do various other mischief on your domain. 3/9/2013 11:45:00 AM 3/9/2013 12:35:00 PM 12062 John Martin Track 4 Bligh Compliance is something that we are all having to deal with and this is only going to increase with heightened privacy concerns and due diligence requirements in business. This session will cover three of the main areas that you are likely to have to deal with; Payment Card Industry - Data Security Standard (PCI-DSS), Sarbanes Oxley Act (SOX) and the UK Data Protection Act 1998 (DPA). I will look at what these standards are for and how they sometimes conflict. Information Heavy and Demo Light, this session will help you identify what you need to keep an eye on and I will show a couple of options on how to monitor who is doing what with your data. 3/9/2013 3:00:00 PM 3/9/2013 3:50:00 PM 12072 Eric Lawson Track 2 Christie A session covering the the core principles of the star schema database model, as required for decision support solutions and as the bedrock for Analysis Services cubes and the new Tabular model. In this session we cover -technical comparison of databases -features of the star schema database -where do you get one -how do you best exploit it -next steps 3/9/2013 8:00:00 AM 3/9/2013 8:50:00 AM 12074 Ian Meade Track 3 Trevithick Finding the best way to implement complex logic in TSQL can be more challenging then you’d expect. Often, the developer just makes the query bigger and more complex but this is not always ideal. We’ll look at how and when you should split larger queries into smaller chunks. We’ll explore the implication of larger queries, using temporary tables, table variables, functions and view, derived tables and sub queries and CTEs. 3/9/2013 8:00:00 AM 3/9/2013 8:50:00 AM 12075 David Morrison Track 3 Trevithick 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 3/9/2013 10:45:00 AM 3/9/2013 11:35:00 AM 12114 Thomas Kejser Track 1 Babbage A DBA running SQL Server 2008 or above will often need to understand if it is worth trading CPU cycles for I/O by enabling row or page compression. The benefits can be significant, but does the cost in core licensing offset the storage capacity saved? Often, comparing the workload before and after compression isn't an option. How then can you make an educated guess about the cost of compressing tables and indexes? In this session, we will use Grade of the Steel type workloads to quantify the CPU cost of enabling different types of compression. Using CPU profiling, we will try to quantify the cost of this feature. 3/9/2013 11:45:00 AM 3/9/2013 12:35:00 PM 12125 Dave Ballantyne Track 1 Babbage At the heart of SQL Server is the cost based optimizer. Stop and think about that a minute, it attempts to give the “best plan” based on the cost of the work undertaken. How does it know the cost of the work before its done the work ? This isn’t a conundrum, it doesn’t. It estimates! How does it estimate ? That is statistics. This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong and how you can have influence over these choices. 3/9/2013 10:45:00 AM 3/9/2013 11:35:00 AM 12156 Alex Whittles Track 3 Trevithick Give your queries a multidimensional makeover. In this session we'll look at the structure and basics of MDX, the MultiDimensional query eXpression language for querying Analysis Services OLAP cubes. We'll start at the beginning, so you need no previous MDX experience! 3/9/2013 4:00:00 PM 3/9/2013 4:50:00 PM 12162 Denny Cherry Track 3 Trevithick In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2012 databases. We will also be looking into the new indexing features that are available in SQL Server 2012 (and SQL Server 2005-2008) and how you the .NET developer can make the best use of them to get your code running its best. 3/9/2013 9:25:00 AM 3/9/2013 10:15:00 AM 12172 Régis Baccaro Track 3 Trevithick Now that Power View users can connect to multidimensional BI Semantic Model (cubes) we will have a look at how to get the best out of this interactive data exploration, visualization and presentation for multidimensional models. The session we'll present - An understanding of the Multidimensional Model Objects in Power View - How to create a Shared Report Data Source Connection to a Multidimensional Model - How to create a Power View Report with a Multidimensional Model Data Source - An visual exploration of a Multidimensional Model by using Power View 3/9/2013 11:45:00 AM 3/9/2013 12:35:00 PM 12174 Jonathan Allen Track 1 Babbage All SQL Server DBAs should know how Service Broker and Event Notifications work so that they can implement this very simple feature to make sure they are aware of events happening on their servers. Event Notifications is a very light-weight, asynchronous mechanism for identifying events and taking actions. In this session we will create sessions to monitor for and act on DDL changes, file size changes, index and statistics changes, security changes and more. Attendees will gain an understanding of how they can monitor many servers and stay in control. 3/9/2013 1:45:00 PM 3/9/2013 2:35:00 PM 12179 Mark Pryce-Maher Track 4 Bligh We all know about the low startup costs of using cloud based SQL Servers, but what are the (hidden) costs and benefits? In this session, we will run thought the supported feature sets of each and how they stack up against one another. Does one perform better than the other? Are they better for different work loads? If the demo gods are with us, will can see they both in action and you can see for yourself! 3/9/2013 11:45:00 AM 3/9/2013 12:35:00 PM 12256 Jamie Thomson Track 4 Bligh SQL Server 2012 introduced SQL Server Data Tools (SSDT) Database projects. In this session I shall explore how to develop SQL Server databases using SSDT and demonstrate why I think declarative, offline, database development is something we should all consider. 3/9/2013 9:25:00 AM 3/9/2013 10:15:00 AM 12289 Gavin Payne Track 2 Christie IT teams today have many different types of architect, yet their technical skills are just the foundation for a range of soft skills that if they didn’t have wouldn’t earn them the title of architect. The session will help you understand the type of architect you are or want to become; define the leadership, design and implementation skills you’re likely to need; and review some of the methodologies you could use to help you become a more successful architect. While the subject is a generic professional discipline, the session is aimed at people with SQL Server DBA or development backgrounds, and refers to the requirements of the Microsoft Certified Architect certification. 3/9/2013 1:45:00 PM 3/9/2013 2:35:00 PM 12399 Chris Testa-O'Neill Track 3 Trevithick SQL Server 2012 provides the ability to deliver solutions for BI users with all experience levels. See the ease of collaboration of business intelligence reporting between business users and IT departments and demonstrate a real world use case as used by a Coeo customer to present a business case for using SQL Server 2012 within your business. 3/9/2013 3:00:00 PM 3/9/2013 3:50:00 PM 12547 David Peter Hansen Track 4 Bligh Loading and managing large data sets in your Data Warehouse is not always a trivial task. Especially if the source systems can re-deliver data and you want to replace an old subset of your data. The quick answer you always hear is “just use partitioning”, but nobody really tells you how you should design or implement it. This session will show one way to load and manage your very large data sets, by using layered partitioning. We will walk through partitioned tables and partitioned views, before moving on to the concept of layered partitioning. 3/9/2013 8:00:00 AM 3/9/2013 8:50:00 AM 12582 James Boother Track 3 Trevithick PowerShell has evolved (again). PowerShell v3 released earlier this year comes with: • new cmdlets, • enhancements to familiar cmdlets, • better help system, • workflow, • PowerShell Web Access • + Lots more This is an opportunity for you to see the important new features first hand. 3/9/2013 1:45:00 PM 3/9/2013 2:35:00 PM 12607 Christian Bolton Track 1 Babbage In this session I'll cover advanced HA and DR architectures for SQL Server 2012 that also enable you to scale-out certain workloads. This will include design patterns and configuration best practices for Availability Groups (AG) and Failover Cluster Instances (FCI) across different sites as well AG replicas between FCIs. 3/9/2013 9:25:00 AM 3/9/2013 10:15:00 AM 12642 Gethyn Ellis Track 1 Babbage Virtualisation is a hot topic at the moment and the chances are your business is probably looking at or already implemented virtualisation to some degree. As a DBA there will be pressure for you to virtualise your SQL Servers too. Many DBAs are reluctant to virtualise their SQL servers usually because of the fear that that performance will suffer. If virtualisation is done properly though SQL Server will run perfectly well on a virtual platform and you may even get some added HA benefits thrown in for free. 3/9/2013 8:00:00 AM 3/9/2013 8:50:00 AM 12648 André Kamman Track 2 Christie I know what you're thinking, Powershell is not an ETL tool. And you're probably right. But I keep running into weird requests that were just easier to fix with Powershell. I'll show you why some things are not easy in SSIS. I'll also discuss how you can work around a lot of that instead of switching to Powershell like I did. This session will be around 70% 'why is this hard in SSIS and can you work around it?' and 30% 'Look how cool Powershell is' 3/9/2013 9:25:00 AM 3/9/2013 10:15:00 AM 12727 Dave Green Track 2 Christie Or, using unit tests to produce better quality code and do less (re)work! In this brisk session we will discuss some of the reasons to unit test your procedures as well as which tests are and are not appropriate as unit tests. We will look at how to use the open source tSQLt framework to achieve repeatable unit tests, including Test Driven Development approaches and writing tests for existing stored procedures; in short everything you need to begin writing unit tests for the stored procedures in your databases. 3/9/2013 10:45:00 AM 3/9/2013 11:35:00 AM 12731 Mark Broadbent Track 2 Christie Do you really understand SQL Servers’ Concurrency behaviour? Are you sure that Transactions are an ALL or NOTHING operation? Do you believe Read operations cannot start a Transaction? Do you really know if READ UNCOMMITTED is safe for reporting? Is being Optimistic really better than being Pessimistic? Can SQL Server 2012 be the solution to all our problems or our worst nightmare? I look forward to you joining me in this very revealing and thought provoking session where I will provide answers to all these questions and more and make you wish you had known all of this sooner. 3/9/2013 3:00:00 PM 3/9/2013 3:50:00 PM 12750 James Rowland-Jones Track 4 Bligh 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. 3/9/2013 10:45:00 AM 3/9/2013 11:35:00 AM 12754 Neil Hambly Track 2 Christie An in-depth session examining 'Waits' happening in your SQL Servers, using the well-known 'Waits Queues' methodology. With particular focus in the session on understanding and interpreting the information found the (DMV) sys.dm_os_wait_stats, Taking note of which “Waits “with the highest counts or excessive wait times, as well as those which “Waits” can be safely ignored, We can discover those 'performance hurdles' and ways to overcome or remove them, restoring your SQL Servers performance levels. By using established methodologies like “Waits Queues”, we can systematically identify and remove performance Previous Presented @ SQLBits 8 9 in UK @ SQLPASS Summit 2011 (310 Attendees) SQLDay And @ several UK User Groups 3/9/2013 4:00:00 PM 3/9/2013 4:50:00 PM 13063 James Rowland-Jones Track 2 Christie It's a great time to be a data professional. The world is changing and with it the ecosystem of data is changing too. Up till now, experts in the field have been measured by their depth in a given domain and deep insight into the internals of SQL Server has been the highest prize of all. Time's change. Is that how tomorrow's data platform professional will be measured? I'm not so sure. I believe that our roles are expanding and we need to embrace new concepts and technologies to stay ahead. I will share with you my experience to date, my training plan for the year ahead and issue you with a fun challenge. Join me! Seize the opportunity to learn something new and broaden your impact. Breadth is the new black. 3/9/2013 9:00:00 AM 3/9/2013 9:15:00 AM 13063 James Rowland-Jones Track 1 Babbage It's a great time to be a data professional. The world is changing and with it the ecosystem of data is changing too. Up till now, experts in the field have been measured by their depth in a given domain and deep insight into the internals of SQL Server has been the highest prize of all. Time's change. Is that how tomorrow's data platform professional will be measured? I'm not so sure. I believe that our roles are expanding and we need to embrace new concepts and technologies to stay ahead. I will share with you my experience to date, my training plan for the year ahead and issue you with a fun challenge. Join me! Seize the opportunity to learn something new and broaden your impact. Breadth is the new black. 3/9/2013 9:00:00 AM 3/9/2013 9:15:00 AM 13893 Jen Stirrup Social Select * Coffee Bar Our topic for discussion is ‘Networking for Techies’ and we’ll have an informal chat over coffee in the Community Corner. Come and join other interested people to build personal connections, and gain insights via our informative discussion. Attendees will share insights and experience, stimulate new ideas and have an engaging discussion! Topics include: · How to use LinkedIn? · Does ‘speed networking’ work? · How to network at technical events? · Ice-breakers? 3/9/2013 1:05:00 PM 3/9/2013 1:35:00 PM