Nr: 310
SQLSaturday #310 - Dublin 2014
SessionID: 10565
The Irish Economic Crisis Visualised with Power BI
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 1. Lady Windermere
Speaker: Bob Duffy
Title: The Irish Economic Crisis Visualised with Power BI
Abstract:
In this session we will explore the Irish Economic Crisis from multiple perspectives, using Microsoft’s latest Visualisation tools including Power BI, Power Query, Power Map, Power View and SharePoint”. It starts from a very common business angle, where people need to make sense of data, fast, but don't know what questions to ask, nor how to combine available sources in a way that makes sense. This session converts the Irish Economic crisis into a story that can be explored in an interactive way, using familiar tools, in a way that people may feel should have been noticed in the run-up to the crisis. Come by to find out what led to a small country owing over 200 billion euro and if Power BI could have helped. Come and find out where all the money came from and what Ireland spent it on!
SessionID: 10566
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 4. Ideal Husband
Speaker: Bob Duffy
Abstract:
SessionID: 10925
The nightmare of locking, blocking and isolation levels!
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 2. Dorian Gray
Speaker: Boris Hristov
Title: The nightmare of locking, blocking and isolation levels!
Abstract:
SessionID: 11097
Big Data, Big Project
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 4. Ideal Husband
Speaker: Buck Woody
Title: Big Data, Big Project
Abstract:
By now, we're past the "hype cycle" of what Big data is - but how many people have really implemented a Big Data project yet? And what do those projects contain? Come here Microsoft's Buck Woody describe a big Data project engagement, and learn what to expect, how to prepare, and how to run your own project successfully.
SessionID: 11476
Power Query: Beyond The Basics
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 3. Intentions
Speaker: Chris Webb
Title: Power Query: Beyond The Basics
Abstract:
You already know that you can accomplish a lot within the Power Query user interface. If you are a data steward, however, you may be asked to deliver complex data sets in Power Query that require some knowledge of advanced functionality, including the M language. This session will examine what these requirements might be, how to implement them, and how best to deploy them to end users.
SessionID: 11705
First steps in continuous integration for databases with Red Gate’s SQL Automation Pack.
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 2. Dorian Gray
Speaker: Carmel Gunn
Title: First steps in continuous integration for databases with Red Gate’s SQL Automation Pack.
Abstract:
At previous SQL Saturday Dublin events, you’ve seen how easy it is to get your SQL Server databases in source control.
In this session, we’ll build on this foundation and look at the resources you can use to set up an automated build process for your databases.
Starting with a database that’s source controlled using Red Gate’s SQL Source Control, we’ll use the SQL Automation Pack and Team City to set up a simple build process that runs every time you commit a change.
You’ll see how this process helps you spot and fix errors quicker, and how you can use it to produce an artefact you can use for reliable, repeatable deployments in the future.
One lucky session attendee will also win a license of the SQL Automation Pack during this session, so don’t miss out!
SessionID: 11787
Inside the SQL Server Query Processor
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 1. Lady Windermere
Speaker: Conor Cunningham
Title: Inside the SQL Server Query Processor
Abstract:
Conor will go through how the query processor works, with focus on query optimization and how new technologies like the in-memory OLTP (Hekaton) and Columnstore Indexes/Batch Execution modes work.
SessionID: 14015
Shared technical learnings for building highly scalable and available cloud application
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 4. Ideal Husband
Speaker: Ewan Fairweather
Title: Shared technical learnings for building highly scalable and available cloud application
Abstract:
The Azure CAT team has successfully architected, designed and built over 200 cloud projects. In this session we will share the learnings on how to design a cloud application to scale to handle large, complex workloads. We will have a special focus on the telemetry management and monitoring requirements such large systems require. Building cloud applications are different than building on premise SQL Server applications. Agenda I) Share some of the existing successful cloud deployment feeds and speeds. II) The challenges we faced III) It is all about the architecture up front IV) Lessons Learned V) Summary QA.
SessionID: 15123
SQL Server PDW (APS) vs SQL Server, let's see the big differences
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 4. Ideal Husband
Speaker: Henk van der Valk
Title: SQL Server PDW (APS) vs SQL Server, let's see the big differences
Abstract:
SessionID: 16410
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 3. Intentions
Speaker: Jen Stirrup
Abstract:
SessionID: 17601
Migrating to APS
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 4. Ideal Husband
Speaker: James Rowland Jones
Title: Migrating to APS
Abstract:
In this 1-hour session, you will learn how to "embrace the change" and accelerate your migration to the data warehouse storage engine for the Microsoft Data Platform. This session will be packed with advice and recommendations from actual customer deployments and real-world experiences. Get on board the APS train, and transform your data warehouse with the Microsoft Analytics Appliance!
SessionID: 17879
Windows Azure SQL Database Design: Concepts and Trade-offs
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 4. Ideal Husband
Speaker: Karen Lopez
Title: Windows Azure SQL Database Design: Concepts and Trade-offs
Abstract:
Data modelers and designers need to understand the logical, physical, and technical differences in designing for Windows Azure SQL Databases (WASDs) and traditional on-premise SQL Server databases. In this session, we'll review the concepts that still work in both and the features that need to be tailored to each target environment.
You’ll see demonstrations of the database creation and initial design processes and gain best practices for model-driven development for each environment, including tool support. We’ll finish up with 5 tips for designing databases for both WASD and SQL Server.
SessionID: 18121
SQL anti patterns
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 2. Dorian Gray
Speaker: Kennie Pontoppidan
Title: SQL anti patterns
Abstract:
You can learn SQL in three days but it'll take you 10 years to become good at it. In this session we will have a look at some basic design errors and get a notion of the things that absolutely doesn't work. Antipatterns is a way of naming common design errors in order to make them easier to remember - even if you haven't done them yet.
We will become acquainted with antipatterns on a physical level, a logical level and an sql-queries and application level, and spice it up with some seriously foolish errors made by me and my colleagues. The session is relevant for developers and DBAs.
SessionID: 18460
Convince Me – Persuasion Techniques That Get Things Done
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 1. Lady Windermere
Speaker: Kevin Kline
Title: Convince Me – Persuasion Techniques That Get Things Done
Abstract:
Ever wanted to convince the boss to try something new but didn't know where to start? Ever tried to lead your peers only to fail to achieve your goals? This session will teach you the eight techniques of influencing IT professionals so that you can innovate and achieve change in your organization.
You’ll learn:
• The fundamental difference between influence and authority and how you can achieve a high degree of influence without explicit authority
• The eight techniques of influencing IT professionals, when to apply them, and how to best use them
• The communication and procedural techniques that ensure your ideas get a hearing by managers and peers and how to win support for them
SessionID: 18494
Plan Caching in SQL Server
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 2. Dorian Gray
Speaker: Klaus Aschenbrenner
Title: Plan Caching in SQL Server
Abstract:
SessionID: 19083
Learning Entity Framework 6
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 2. Dorian Gray
Speaker: Leonard Lobel
Title: Learning Entity Framework 6
Abstract:
We’ll begin with a quick introduction to ORM and EF, and then explain many of the special ORM features in EF6, such as the Entity Data Model, and table splitting, inheritance, entity splitting, and many-to-many relationships. With the basics covered, Lenni will then dive right into live demos that show what EF can do for you as a data access layer, using database-first, model-first, and code-first approaches with both direct SQL and stored procedures. We’ll also discuss new features introduced in EF6, and show how to use EF in N-Tier scenarios.
SessionID: 20125
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 5. Lord Arthur Saville
Speaker: Mark Stacey
Abstract:
SessionID: 21017
Storage for the DBA
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 2. Dorian Gray
Speaker: Denny Cherry
Title: Storage for the DBA
Abstract:
SessionID: 21475
Using ioMemory to leverage Buffer Pool Extension and In-memory OLTP capability with Microsoft
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 5. Lord Arthur Saville
Speaker: Justin Wheeler
Title: Using ioMemory to leverage Buffer Pool Extension and In-memory OLTP capability with Microsoft
Abstract:
SessionID: 22835
DBAs are from Mars, SharePoint admins are from Ve
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 5. Lord Arthur Saville
Speaker: Regis Baccaro
Title: DBAs are from Mars, SharePoint admins are from Ve
Abstract:
SessionID: 24440
Storing of sensitive data in SQL Server - Meeting the PCI Data Security Standards
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 3. Intentions
Speaker: Simon Sabin
Title: Storing of sensitive data in SQL Server - Meeting the PCI Data Security Standards
Abstract:
Your business needs to process credit card data and you need to store it somewhere.
The Payment Card Industry (PCI) requires that you store the data in an encrypted form and make sure your processes are robust to protect the data. These requirements are the PCI Data Security Standards currently at version 3.0 https://www.pcisecuritystandards.org/security_standards/pcidss_agreement.php?association=pcidss
If you want to use SQL Server as your data store what do you need to do?
This session covers the following for SQL Server
- Encrypting data in SQL Server
- Meeting Key management requirements of
- Detect and audit access to the data
- Retro fitting encryption of data into an existing application
We will do an overview of all the areas and drill down into the storage of data and how that can be achieved seamlessly from the application.
At the end of the session you will know what you need to do, to be able store card details in SQL Server and achieve PCI certificatio
SessionID: 24647
Multidimensional vs Tabular - May the Best Model Win
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 3. Intentions
Speaker: Stacia Varga
Title: Multidimensional vs Tabular - May the Best Model Win
Abstract:
Are multidimensional models dead on arrival? Are tabular models the future of analysis? Come to this session to learn the similarities and differences between these two approaches to analytical modeling first introduced in SQL Server 2012 Analysis Services. We'll explore the pros and cons of each type of model and review how to select the appropriate model to your analytical requirements.
SessionID: 24789
Digging Into the .Net SqlClient
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 2. Dorian Gray
Speaker: Mladen Prajdić
Title: Digging Into the .Net SqlClient
Abstract:
The prevailing opinion is that the optimizations for SQL Server are usually only done on the server itself. But is there anything we can do on the client to gain more speed? In this session aimed at .Net and SQL developers, we'll dive into the workings of the .Net SqlClient and give you insight into way more than just SqlCommand.ExecuteReader() and SqlCommand.ExecuteNonQuery().
SessionID: 28208
Replication Troubleshooting Monitoring
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 5. Lord Arthur Saville
Speaker: William Durkin
Title: Replication Troubleshooting Monitoring
Abstract:
Replication is a powerful feature that has long been available in SQL Server. However, with great power come great headaches! Replication normally runs happily once set up, but if things go wrong it can turn into a seemingly never ending list of errors. In this session I will dig into how replication can go wrong (and has gone wrong for me) and what steps you can take to fix these issues. Along the way I will go into what monitoring options you have when working with replication and also a couple of gotchas that have caught me out in the past.
SessionID: 34564
How to write professional Powershell scripts
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 5. Lord Arthur Saville
Speaker: André Kamman
Title: How to write professional Powershell scripts
Abstract:
You probably have a few Powershell scripts sitting around, perhaps written from scratch but most likely you borrowed the idea from a blog somewhere, and then used those as templates to achieve your goal. It's time to take those ad-hoc scripts turn them into your very own module. And while we're at it we might as well add proper error handling, parameterization and pipeline support. I will also demonstrate how to build help, force and whatif support.
This is a demo rich session and all demos will be covering practical SQL Server related solutions.
SessionID: 9217
MDX 101
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 3. Intentions
Speaker: Alex Whittles
Title: MDX 101
Abstract:
Give your queries a multidimensional makeover. In this session we'll look at the structure and basics of MDX, the Multi Dimensional query eXpression language for querying Analysis Services OLAP cubes.
We'll start at the beginning, so you need no previous MDX experience, but it does help to understand what a cube is.
Learn the difference between a member, measure, tuple, set and dimension. Well describe how to decypher a [] from a {} or (). We'll look at examples of each, and show how you can easily access the imense power of cubes with relative ease.
SessionID: 9286
SQOOP - Taking relational data to Hadoop and back again
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 4. Ideal Husband
Speaker: Allan Mitchell
Title: SQOOP - Taking relational data to Hadoop and back again
Abstract:
SQOOP is a command line tool but don't let that put you off.
This session will look at SQOOP and the plethora of options available to you on the command line. If you want to learn about SQOOP then this is the session for you.
SessionID: 9669
Using Power BI and SharePoint as a rapid development BI Strategy
Event Date: 20-09-2014 - Session time: 00:00:00 - Track: 3. Intentions
Speaker: Daire Cunningham
Title: Using Power BI and SharePoint as a rapid development BI Strategy
Abstract: