Event Location:
The Møller Centre
Churchill College, Storey's Way
Cambridge, , United Kingdom
Abstract:
Nothing is perfect, which means that your database may be not perfect as well. And one day you may decide that your database is slow and it's time to optimize it. But.. Where to start? When to end? What to look at? Which queries are slow? How to identify the real bottleneck? And so on, and so on. There are a lot of questions that should be answered in process of performance tuning. And in this session, we will find answers to all these questions going from collecting data for analysis, through identifying bottlenecks to optimization of the particular queries. On this way we will learn practical techniques of performance tuning and solve bunch of issues. All this will be done using tools, which are installed on your system by default. Minimum of theory and a lot of practice.
Speaker(s): Denis Reznik,
Abstract:
By now you’ve probably heard about Big Data 1.000 times or more so why a new session about big data you might ask. Show how to make creation and deletion of AZURE elements automatically as part of your ETL process or by Powershell, automate the trivial procedures and work on the interesting parts This session will show you how : • Downloads and prepares several years of demo data and storing it in a dedicated Azure Blob Storage account. • Create a storage account and container for the HDInsight Cluster. • Create a SQL database server instance and a SQL database for the Hive Metastore. We will also setup the necessary firewall rules so that you can access the server directly. • The HDInsight cluster is provisioned and configured for access to the sample data. • A partitioned Hive table is created over top of the sample data • Exploration of the result • And how to automate these task either in Powershell or SSIS.
Speaker(s): Kenneth Nielsen,
Abstract:
This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.
Speaker(s): Benjamin Nevarez,
Abstract:
Based on our work with converting an existing application to memory optimized tables and natively compiled stored procedures this session, will take you through this journey and show you the (large) gaps between what we have in our normal SQL belt and what is possible in Natively compiled stored procedures. I will show how to overcome all the gaps and get all out normal stuff to work in these monster fast procedures – even the things that the documentation says cannot be done. You will therefore be taken through the concept of in-memory tables and what to be aware of when considering converting your database tables and code to In-Memory tables and through a life migration demo be given all the tips and tricks I picked up while doing so. After attending this session, you will be able to leverage on the new concepts and work your way around its current limitations to gain enormous speed increase and a lock-free environment.
Speaker(s): Rasmus Reinholdt,
Abstract:
The SharePoint landscape has changed dramatically over the last few years, and this session is designed to help Business Decision Makers, IT Managers and SQL Professionals understand what it offers as reporting platform. Exploring the different options, benefits and considerations for using SharePoint to report on data in SQL Server. Explaining that there are important decisions to make about which platform to use, and whether cloud based services should be considered. It will show a number of SharePoint options including Business Connectivity Services, Reporting Services, Excel Services and Power BI. It will consider the differences in functionality and configuration for different versions of SharePoint and SQL. Including comparing the platforms of SharePoint Server, SharePoint Foundation and Office 365. Finally it will challenge attendees to think about the purpose of the solution being delivered, who it is for and the long term strategy.
Speaker(s): Peter Baddeley,
Abstract:
Still using Reporting Services? Yeah me too! Does this scenario sound familiar? You already have a large SSRS environment but the users still want more reports. You create a new, all singing, all dancing dashboard that removes the need for a bunch of reports, awesome. You launch it and explain to the business that you are deprecating the old reports. "WAIT! We still need that for Jill in HR to do her end-of-month", or "We might still need that" - these types of comments are what leads to having a load of reports that are not being used. Wouldn't it be great if you could see who is viewing a report, in what format and how often, all inside your current SSRS environment? With this data wouldn't it then be even better if we could automate a process to email the owner of that report to say "HA! I told you no one looked at this report!". In this session we will look at how we can do all of this and more by mining the SSRS DB.
Speaker(s): Terry McCann,
Abstract:
We're all familiar with reports or dashboards that show you a static snapshot of the data that has to be refreshed on an interval. And those are very important visualizations. But sometimes you just have to have a real time view of your data streams and snapshots aren't enough. What if you could monitor multiple servers with SQL Trace or Extended Events or had some other source of streaming data and be able to see it all happening live on a central monitoring website? This is a scenario we'll take a detailed look at and build a system for such monitoring. We'll do this by using Extended Events .Net provider to get the live data stream, SignalR to get the live stream from the server to the website and the D3 javaScript library for actual real time visualizations on any device. After seeing all this in action, you'll definitely get a few ideas on where you could use this in your company.
Speaker(s): Mladen Prajdić,
Abstract:
SharePoint – let’s admit it – is here to stay; It has become the business collaboration platform of choice for the enterprise and the binding element in the Office family of tools. However deploying and configuring can be a challenging task for the IT pro. In this session we will walk through the configuration of a complete on-premises BI platform with SharePoint. We will configure different scenarios, and the technologies necessary for building the infrastructure. After this session you will be able to setup the applications and all the supporting services to make SharePoint a successful and performant BI platform. From Excel services to Kerberos delegation.
Speaker(s): Regis Baccaro,
Abstract:
Unit-Test are a mature tool in traditional programming languages like C# and meanwhile accepted as de-facto standard. Using Stored Procedures and Functions you can put much programming logic right into the database. This logic has to be tested too. SQL Server Data Tools from Microsoft are one possible approach to generate unit tests for T-SQL Code. One of the disadvantages of SSDT is that the tests are implemented as C# or VB Solutions outside of the database. An alternative to these approach is using tSQLt, a Testing-Framework that is written entirely in T-SQL and is run completely in the database. So you are able to write unit tests in SQL Server Management Studio. In his talk SQL Server MVP Frank Geisler will show how the tSQLt Framework is set up and how it works and how you can write Unit Tests for different SQL Server Objects. Besides the free Version of tSQLt you can buy SQL Test from Redgate which is a very useful GUI for tSQLt and is demonstrated as well.
Speaker(s): Frank Geisler,
Abstract:
In a perfect world an ETL solution would only have to import data from a single file that always had the same name deliver it to a single already existing table. Unfortunately this case is the exception rather than the rule. How can you use SSIS to: 1. Iterate through all files in a folder and import their content into SQL 2. Dynamically create and name table based on a data source 3. Dynamically create a T-SQL statement at runtime based on run time conditions This session focuses on how to create SSIS packages that can change to meet runtime events dynamically based on the environment. Each attendee will leave with the knowledge and toolset necessary to: 1. Use expressions within SSIS packages 2. Use variables to dynamically create SQL statements 3. Configure custom dynamic logging 4. Use package configurations and parameters and environments to make packages more portable at execution 5. Replace dynamic SQL using expressions in SSIS
Speaker(s): David Dye,
Abstract:
[ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ] You can learn the basics of SQL in three days but it’ll take you 10 years to become good at it. In this full training day we will take a look at a range of common design and coding mistakes to get an idea of the patterns and practices that absolutely do not work well for optimum performance, scale and design. Anti-patterns are a way of naming these common design mistakes in order to make them easier to identify and remember (and correct!). Sooner or later as the demands on your database performance increase, so will the need to identify and resolve your anti-patterns. During the day we will grow acquainted with anti-patterns on a physical level, a logical level, a SQL Query and application level, and spice it them up with some seriously foolish errors made by both myself, my colleagues and the industry at large! Examples of SQL Anti patterns that we will address dur
Speaker(s): Kennie Pontoppidan,
Abstract:
[ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ] Many people are forced to use Microsoft#174; SharePoint#174; because it is already there or part of the Office 365™ ecosystem; therefore many users see it just as another task to add to their burgeoning workload of tasks they have to complete in their busy working day. When any technology is introduced into a business it should help not hinder users. It should enable users to do more, not less. Technology should meet business needs and not be focused around a single product. With this in mind, Penny will look at automating business processes using out-of-the-box functionality of SharePoint and with the use of Azure™ Logic Apps outside SharePoint, beyond firewalls and beyond even your own datacentre. You can create these workflows using no-code visual designers. SharePoint topics that will be cover
Speaker(s): Penelope Coventry,
Abstract:
[ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ] High Availability solutions have been around for nearly as long as SQL Server and with “Maintenance Windows” becoming an increasingly rare luxury, businesses are relying more and more on their Data Warehouse and Business Intelligence reporting platforms being available 24 hours a day for 365 days a year. In this pre-conference session we shall explain how to design, plan, implement and maintain an end-to-end Highly Available Business Intelligence and analytic platform laying not only the conceptual foundations for your learning, but providing the practical technical hands on know-how for Business Intelligence professionals, Database (and Windows) administrators, and Technical Architects. For more detail about this session please visit http://sqlcambs.org.uk/precon6/
Speaker(s): Mark Broadbent,
Abstract:
Errors can occur anywhere within an SSIS package and the cause and error message can be somewhat cryptic. This session focuses on identifying error causes and handling them dynamically and proactively. The means of dealing with errors is defined by where the error occurs and we will cover error handling in control flow, data flow, and script tasks in great detail. You will learn: •To identify the different error handling methods in control flow, data flow, and script tasks •Be able to utilize event handlers to proactively handle errors •Be able to redirect data error and proactively handle data flow errors •Be able to identify error descriptions and log error details
Speaker(s): David Dye,
Abstract:
[ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ] Make sure you spend the whole day learning about the most important technology Microsoft has launched since the beginning of SQL Server – Columnstore Indexes. We will investigate how you can optimise your BI DataWarehousing solutions and take the advantage of the modern Columnstore Architecture significantly boosting your query performance and analytics reporting. Learn how to get the very best out of your existing database environments and how you can monitor, optimise, implement and solve many Columnstore Indexing problems. Discover how to take the full advantage of the Batch Processing mode for Columnstore Indexes, which can significantly accelerate your query processing by hundreds of times, and learn about its limits. Through the use of Dynamic Management Views, Extended Events and Traceflags we shall analyse traditional Rowstore tables and turn them into highly
Speaker(s): Niko Neugebauer,
Abstract:
AlwaysOn Availability Groups provide an excellent way to build a High Availability platform with SQL Server at its core, however with these new capabilities come new and interesting maintenance requirements. In this session we will look at a number of the things you must do when making use of Availability Groups, and some of the things that you can do in order to ensure that you have a stable, reliable platform.
Speaker(s): John Martin,
Abstract:
To point and click our way through a SharePoint installation is relatively easy, but will more than likely result in some form of disaster. Join SharePoint expert, Andy Talbot for a detailed discussion on building and running SharePoint platforms fit for enterprise customers. In this session, Andy will address some of the common challenges that can take some enterprises by surprise, lessons learnt by large organisations, factors that we should have planned for, and common failure points. Attendees will benefit from this discussion regardless of if you are just starting out with your deployment, or you’re already in production. Although this is mainly targeted at the IT PRO audience, key points are made that very relevant to business users too.
Speaker(s): Andy Talbot,
Abstract:
For more details visit http://sqlcambs.org.uk/precon7/ IDC research, commissioned by Microsoft, shows that better outcomes from data and analytics projects correlate with greater competitiveness of an organization in its industry or a better ability to fulfil its mission in the public sector. Although correlation does not equate to causation, a growing body of research shows financial and productivity benefits directly linked to better data-driven decision making enabled by business analytics solutions. Four characteristics distinguish leaders in analytics—the use of more diverse data types and sources beyond social media to include the Internet of Things (IoT), adoption of more diverse analytical and self-service tools, methods, and metrics suited to broad range of users from data scientists to business analysts and executives, distribution of insights to a more diverse audience of business users, and the right-time application of most timely data.
Speaker(s): Microsoft and Guests,
Abstract:
[ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ] In this hands-on / bring your own laptop pre-con, Rasmus will show how you can take your ETL to the next level. You will go from “Zero to BIML to BIMLScript” in the duration of the day. That means, that leaving the pre-con, you will never ever again have to go over hundreds of packages to change a datatype or add a column, all you’ll need to do, is to change your meta-data and you are home free. As our meta-data repository, we will use SQL Servers built-in Master Data Services. You will be given a thorough introduction to this component and learn how to use and administer it. Besides getting a working knowledge of BIML AND MDS, and become able to use that in your ETL development, you will also get an overview of, and get to work with, the following advanced ETL concepts: Early arriving facts Slowly Changing Dimensions (SCD) with script task Least interdependent structu
Speaker(s): Rasmus Reinholdt,
Abstract:
Data mining on-premises has a long tradition with Microsoft SQL Server and Machine learning in Azure is the cloud based brother, both supporting a hand-full of great algorithms for your business to grow. This session will be focused on benefits of building a predictive model using Azure Machine Learning (ML) studio and exploring its capabilities. We will cover from 1) Quick introduction to ML to 2) creating ML workspace with data upload, 3) training the data-set and evaluating the solutions/models and 4) using this solutions with ML API Service. With a great support to R language in Azure ML, we will also explore the usage of R script in Azure ML.
Speaker(s): Tomaž Kaštrun,
Abstract:
Large organisations usually have their own dedicated Service Delivery IT platform for tracking and managing "Service Requests", but what happens in smaller organisations? Without the right management tools and software, tracking and delivering service request resolutions can be a resource intensive task in itself and does not bode well for the quality of service to the end-user. If your organisation has a SharePoint deployment, it doesn't have to be this way. In this session we will utilise SharePoint's Out-Of-The-Box functionality and through a selection of customisations and technical know how, we will lay the foundations so that you may implement your own Service Delivery platform and enable your organisation to provide the type of efficient service delivery your end users expect.
Speaker(s): Ryan Yates,
Abstract:
Want to get your systems to the cloud, not entirely sure how to go about it? Let me guide you through the design considerations and process for building a Highly Available and resilient SQL Server infrastructure, looking at entirely cloud based and hybrid options. By the end of this session we will not only have discussed, but actually built and deployed a HA/DR SQL infrastructure and website that accesses it.
Speaker(s): John Martin,
Abstract:
This session will discuss a high level overview of the migration process, the steps involved, and examine the many ways in which PowerShell can help reduce the time and pain associated with large scale Farm migrations. This will include live PowerShell demonstrations of the concepts being discussed throughout the session.
Speaker(s): Corey Burke,
Abstract:
The session will first cover how to go about transferring SQL Databases between SharePoint Farms using PowerShell. Including common scenarios, approaches and potential gotchas, as well as some example scripts. It will then move on to cover the often manual task of replicating Service Application Configurations between SharePoint Farms and demonstrate how this can also be simplified and automated with the use of PowerShell.
Speaker(s): Anthony Obi,
Abstract:
David will demonstrate how easy it is to not only visualise data from SQL Server and SharePoint, on-prem. or in the cloud, with Visio 2013+ Professional , but how you can use structured diagrams and validation rules to create data for your database from a drawing. He will also demonstrate how Visio diagrams stored in SharePoint 2013+ can be become interactive dashboards available on any modern device and in any modern browser.
Speaker(s): David Parker,
Abstract:
Dive deep into Columnstore Indexes and discover their advantages and some of the limitations. Look into some of the Columnstore Indexes myths, understand more complex concepts of Batch Mode Query Processing with another depth. Can you make your Columnstore queries ran even faster ? Can you actually lower the Degree of Parallelism and get a better performance ? How much memory does Columnstore Index actually use when working with queries ? How can you test your Columnstore queries in Row Mode and what is the actual difference between Row Batch Modes. The answers on those questions are to be revealed at this session.
Speaker(s): Niko Neugebauer,
Abstract:
[ To book this and any of the other pre-conference sessions please visit http://sqlcambs.org.uk/preconall/ ] This full-day seminar will show you how to optimize SQL Server queries and create high-performance applications. You will learn about the inner workings of the query processor so you can write better queries and provide the query processor with the quality information it needs to produce efficient execution plans. You’ll also get tips for troubleshooting under-performing queries. In-Memory OLTP (Hekaton), a key new feature of SQL Server 2014, will be covered as well. Topics include: How the query optimizer works Troubleshoot queries using extended events, SQL trace, dynamic management views (DMVs), the data collector, and other tools Work with query operators for data access, joins, aggregations, parallelism, and updates Speed up queries and dramatically improve application performance by creating the right indexes Understand statistics and how to detect and fix cardinal
Speaker(s): Benjamin Nevarez,
Abstract:
Learn about JavaScript frameworks and new developer practices in SharePoint and on Office 365. JavaScript frameworks are there for you to help you develop faster and easier. You don't need to do your apps from scratch. Apps and the cloud app model have brought not only new ways to interact, send, write, and receive data from SharePoint. Apps have also brought JavaScript frameworks into SharePoint development. JavaScript frameworks are right there as part of the app template when you start a SharePoint hosted or a Cloud app. In this session, I'll show what you can do with JavaScript frameworks that are part of the app template. I'll show jQuery, Bootstrap, and modernizr.
Speaker(s): Sonja Madsen,
Abstract:
In-memory means blazingly fast, at least most of the time. But modeling for the xVelocity/Vertipaq engine is a completely different beast than modeling for your trusty multi-dimensional SSAS cubes. Join me on a session of improving a malfunctioning PowerBI Excel sheet and pick up handy tips and tricks you will need to tune your xVelocity models.
Speaker(s): Johan Ludvig Brattås,
Abstract:
This back to basics demo rich session shows visualization you can add to your pages, using embedded links, Microsoft Visio#174;, Microsoft Excel#174; and Office apps, and shows you how these visualizations can work together using JavaScript and Web Part connections to provide an interactive dashboard. The solutions uses SharePoint lists and libraries and external data sources by directly connecting to them or by using Business Connectivity Services (BCS). Penny will highlight any limitations between the visualization when using Office 365™ or an on-premises installation of Microsoft SharePoint#174;.
Speaker(s): Penelope Coventry,
Abstract:
Do you think that your data is not secured in the cloud? Is that one of the reasons for you to not migrate at least some workloads there? Things changed in the last few months in terms of Azure database security. In this session we will take a closer look at what the features Row Level Security(RLS) and Dynamic Data Masking can do for your business and how they can help you secure your data.
Speaker(s): Boris Hristov,
Abstract:
An introduction to the different databases that SharePoint uses, with recommendations for High Availability, Disaster Recovery and configuration settings for SQL Server, including the constraints imposed in a single farm, a stretched farm between data centres and a separate DR farm.
Speaker(s): Al Eardley,
Abstract:
This has a simple demonstration using two columns stores created on the same data, but with the larger one out performing the smaller one when used in the same query, this 'Hook' leads onto a deep dive into how modern CPU architectures are designed how they work and how batch mode leverages these, culminating in where the batch mode CPU pressure point is.
Speaker(s): Christopher Adkin,
Abstract:
Microsoft recently launched a new service into Azure; SQL Data Warehouse. SQL Data Warehouse is a scale out, distributed database that can scale its compute resources on demand. Come to this session and learn all about it from the co-author of the official documentation https://azure.microsoft.com/en-gb/documentation/articles/sql-data-warehouse-overview-develop/
Speaker(s): James Rowland-Jones,
Abstract:
One of my client engagements lately was about replaying a workload. The system had so many batches per second that I couldn't actually do a replay but had to run in stress mode and try to slow down the replay in such a way that it resembled the production system. I'll show you how to do that amongst a bunch of other things that I learned and would love to share with you. If you are thinking about using OSTRESS / RML Utilities to analyse your system and stress test it on a different machine to find bottlenecks, then this session is for you.
Speaker(s): André Kamman,
Abstract:
Many developers are working with direct access to the data layer of a database (tables) by ORM or .NET, Access, ... This access methode maybe a good choice for small applications which use a dedicated database where no security or business requirement is needed. This session demonstrates the protection of data by using schemata for data protection and implementation of business logic for multiple applications. I will demonstrate the usage of schemata in an application life cycle to reuse codes for reporting in the same way as for the web application or the fat client application.
Speaker(s): Uwe Ricken,
Abstract:
My thesis in the Master of IT management program was about the life of IT operations people and how they learn. Specifically I worked on the following three research questions: 1) What is the difference between a normal IT operations professional and a true expert 2) How can you make your IT operations professionals better 3) What can you do to make your experts thrive Come and hear about my results and how to make your IT operations professionals grow
Speaker(s): Kennie Pontoppidan,
Abstract:
Continuous Integration is not normally associate with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply continuous integration techniques to data warehouse projects. In particular, the session will cover: * Automating your build and deployments with SQL Server Data Tools * Harnessing the power of BIML * Automated Integration and Regression testing of your Data Warehouse * Deploying and on-going management of OLAP databases using the OlapPartitionManager
Speaker(s): John Tunnicliffe,
Abstract:
Want to start a new business? You have the great idea, but what about creating a business plan, web site, invoicing, CRM, social media and all the other infrastructure you need to operate that great startup. Come and spend an hour with me and see how we did it with our new company Effektor. Ask all the questions you have. I might even be able to answer them.
Speaker(s): Kennie Pontoppidan,
Abstract:
Traditional DBA's do not just take care of making sure the backups work. We help teams promote their databases from DEV to Production, we make copies from Production to Dev and perhaps anonimize some data on the way. In this session we will look at a bunch of our tasks that are traditionally the domain of the DBA and we will look at how to perform these tasks in a cloud or hybrid cloud situation.
Speaker(s): André Kamman,
Abstract:
When you're starting out on your first Analysis Services Multidimensional cube project it's very easy to make design mistakes that can cause problems for you later on. In this session you'll learn about the mostly frequently made Analysis Services design mistakes, what the consequences of making them are, and how to fix them.
Speaker(s): Chris Webb,
Abstract:
Multi Dimensional eXtension (MDX) query language is still the most prominently used language, used to query Multi Dimensional Cubes. If you are ventouring into the world of MOLAP or taking over projects that contains cubes, this will bring you a basic understanding of the MDX language and hopefully give you a good platform to advance from. Aspects covered in the session: • Select, From and Where clauses • Sets, Tuples, Members • Period, Hierarchy, String, Math and Filtering functions
Speaker(s): Jens Vestergaard,
Abstract:
Indexing is the most important task for a good performing database. An optimized database need to be checked regularly for all kind of index problems. This session will Show the usage of DMV (dynamic management objects) for the maintenance of indexes. Get familiar with the physical thresholds for optimal Indexes; approve the usage of Indexes within a few minutes and demonstrate the results to the vendors! We will take a deep look into the dmos for the new Column Stored Indexes too!
Speaker(s): Uwe Ricken,
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().
Speaker(s): Mladen Prajdić,
Abstract:
Office 365 has many different capabilities that have historically been separated into different products. The convergence of the products on one platform is opening up new possibilities for collaborating in new, more effective ways. This session will explain some of the ways that Office 365 is being used and demonstrate some of the capabilities that convince millions of companies to invest in Office 365 to replace existing products with a single unified environment making the most of the familiar business critical tools from Microsoft.
Speaker(s): Al Eardley,
Abstract:
For a long time people have been asking where is SSIS for the cloud. Truth is it was never going to happen. Azure Data Factory has been designed from the ground up. It is designed for moving data at scale and with agility. Come to this session to learn about this new service and how it come provide value to your business processes
Speaker(s): Allan Mitchell,
Abstract:
Predictive analytics is touching more and more lives every day. Machine Learning lets you predict and change the future. Do you know that Microsoft products like Xbox and Bing integrate some machine learning capabilities in their workflows? Come to the session and take a look of the new cloud-based machine learning platform called AzureML from a BI architect perspective, without all the data scientist knowledge. Real machine learning solutions and some best practices when integrating ML on Apps and websites.
Speaker(s): Ruben Pertusa Lopez,
Abstract:
In this session we'll be integrating a variety of geospatial data sources to provide a scalable website using a Windows Azure SQL Database and it's built in Geospatial features such as nearest neighbour. Then we'll take this a step further and introduce another live data stream, finally rendering it all using Bing Maps to an Azure Website. The presentation is targeted at individuals wanting a quick overview of the rapidly evolving Azure Service offerings for today’s cloud ready business.
Speaker(s): Thomas Sykes,
Abstract:
SQL Server 2014 is full of new features and improvements. Some of them are "Killer" features like InMemory OLTP, Clustered Columnstore Indexes, Buffer Pool Extensions, etc., which are discussed a lot and we always can get a lot of information about them. And in the same time, SQL Server 2014 have several fantastic features and improvements, which are more hidden from our sight. In this session we will talk in details about these features and improvements. Query Fingerprints, Cardinality Estimator, Tempdb improvements, and more features will be covered in this session.
Speaker(s): Denis Reznik,
Abstract:
Experience how Maersk Line implemented a best practice installation on the SQL Server Stack. Focus in this session will be on three major aspects of delivering a smoothly running platform, from an IT perspective. How to accommodate for: A) A large number of Business Users simultaneous hitting the servers B) Keeping a high frequency processing/synchronization pipeline C) Ease of management
Speaker(s): Jens Vestergaard,
Abstract:
Recently, in April 2015, Microsoft aquired the company Datazen a specialist for mobile BI. This aquisition enables Microsoft to offer mobile, self service BI tools for Windows, iOS, Andorid and HTML. Besides using BI solutions on mobile devices online it is also possible to use these BI solutions offline. SQL Server MVP Frank Geisler will give insights into how Datazen works and how you can build BI Dashboards on different Datasources. He will show how a Datazen Server is installed and configured and how the Datazen Apps work on Windows 8.
Speaker(s): Frank Geisler,
Abstract:
Microsoft have made available HBase on HDInsight. Use HBase when you need random, realtime read/write access to your Big Data. host very large tables -- billions of rows X millions of columns on your HDInsight cluster. Come to this session to find out more.
Speaker(s): Allan Mitchell,
Abstract:
Indexes are incredibly powerful objects to optimize your database performance. However, when not implemented optimally, indexes can also have a negative impact on your queries! In this session we will take a close look at the different index types, how they work and how we can use that knowledge to design an efficient indexing strategy for your databases. We will also spend time analyzing existing indexes. Are those indexes being used? Can we combine indexes? Those are some of the questions you will learn to answer in this session.
Speaker(s): Enrico van de Laar,
Abstract:
Got a question about Azure SQL Data Warehouse (SQLDW), Analytics Platform System (APS) and/or Parallel Data Warehouse (PDW)? Then this is the session for you! Big Bang Data Co are hosting an open QA session about these technologies where we aim to answer your questions. We will also have some fun give-aways too! Please join us! Ask a question or just sit in, learn and share your experiences on Microsoft's distributed data platform. It's all good!
Speaker(s): James Rowland-Jones,
Abstract:
The traditional data warehouse has been the key of our business analytics architecture for many years. In a world ruled by the data culture concept, new challenges are emerging: data growth; unstructured data; hidden patterns and cloud-born data. Which is the best architecture in order to get over these new challenges? Join this session and learn how to enable the Modern Data Warehouse in your organization using Cubes, HDInsight, AzureML, Stream Analytics and DocumentDB. All through a continuous example using a retail shop scenario.
Speaker(s): Ruben Pertusa Lopez,
Abstract:
Well - they named it SQL2014 In-Memory OLTP tables - BUT that does not mean we can't optimize our BI solutions with this new feature. This demo intensive session takes you through the new possibilities In-Memeory tables and Native Compiled Stored Procedures opens up to us from a BI point of view - covering both the ETL and (R)OLAP angels of the BI process.
Speaker(s): Rasmus Reinholdt,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://pt.linkedin.com/in/webcaravela/
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.
LinkedIn: http://uk.linkedin.com/in/jrowlandjones/
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.
LinkedIn: http://dk.linkedin.com/in/kennethmnielsen/
Contact: http://funkylab.com
Kenneth M. Nielsen currently work at Microsoft as Data Platform Solution Architect, focusing on data services on Azure. Previously worked as managing consultant and teamlead for the company Rehfeld Partners in Denmark. He has worked at various consulting firms and worked on many small/large/very large bi installations in Denmark over the last 12 years. He really likes to advice the customers to take the right decisions, but also maintains a high technical knowledge, so he can act at both architect and developer.
LinkedIn: http://dk.linkedin.com/in/jvestergaard
Contact: http://www.t-sql.dk
Jens performs the traditional BI disciplines from imports in Integration Services through data consolidation in Analysis Services, to report in Power BI or Reporting Services. Jens has worked with The Stack since SQL 2000 and has a core competence in Integration Services and Analysis Services. Along with the certified skills in Microsoft SQL Server, Jens has also worked with Microsoft .Net platform for more than 15 years and currently manages a BI Platform in Azure for the CatMan Solution application(s).
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server independent consultant based in Los Angeles, California, who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning amp; Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals.quot; Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.
LinkedIn: https://uk.linkedin.com/in/tpmccann
Contact: https://www.advancinganalytics.co.uk/blog
Microsoft MVP. Principal Consultant and Owner of Advancing Analytics Limited, an Advanced Analytics consultancy in the UK. Advancing Analytics helps businesses advance their analytical capabilities. Our focus is on Data Science, Data Engineering, DataOps and applied AI. Terry holds a Master's degree in Data Science - with a focus on DataOps for Machine Learning. Speaker at conferences across the world and the host of the Data Science in Production Podcast.
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning Optimization”, “Inside the SQL Server Query Optimizer” and has contributed to other SQL Server books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits.
LinkedIn: https://www.linkedin.com/in/mladenprajdic
Contact: http://weblogs.sqlteam.com/mladenp
Mladen Prajdić is a Data Platform MVP from Slovenia. He's been programming for 20 years, developing different types of applications in .Net (C#) and SQL Server, ranging from standard line-of-business, image-processing applications to high performace and IoT applications. He's a regular speaker at various conferences and usergroup meetings, really likes to optimize slow SQL statements, analyze performance, and find unconventional solutions to difficult SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).
I#39;m SharePoint MVP and my blog on SharePoint 2013 has well over 1 million hits. I own Sonjasapps with over 20 apps in Microsoft SharePoint App Store. I#39;m both Microsoft Partner and Microsoft vendor. I started with SharePoint with MA degree in Multimedia and Information Science and as a .NET developer back in 2004.
LinkedIn: http://www.linkedin.com/pub/ruben-pertusa-lopez/24/ba3/b0
Contact: http://www.sqlpass.es
Ruben is a Global BI/BigData Manager and Global Data Lead Architect at DUFRY HQ, member of PASS Spanish Group and founder of SQLSaturday Barcelona and Madrid. MCP and MCSA in SQL Server 2012 and also awarded with Microsoft MVP Data Platform. With more than 9 years of experience, he has been working in top projects for leading worldwide companies and teaching in the SolidQ BI Master. He has presented at the SQL Server 2008 R2 and 2014 Spanish launch event, PASS BA Chicago, TechNet Webcasts, Microsoft Partner Program and SolidQ Summit events.
Corey Burke is a Principal Architect with Rackspace Hosting, a Managed Cloud Hosting provider located in Hayes, London in the UK. He is a contributing author for the Professional SharePoint 2013 Administration book, and a Technical Editor for Beginning SharePoint 2013: Building Business Solutions. Corey has presented at various SharePoint Saturday events as well as User Group Meetings and Microsoft TechEd Europe. He is a huge fan of SharePoint and using PowerShell for automation.
LinkedIn: http://uk.linkedin.com/in/aleardley
Contact: http://blog.eardley.org.uk
Alan Eardley is a Solution Architect at Corporate Project Solutions (CPS) specialising in Office 365. He has worked with SQL Server since version 7 and with SharePoint and associated products for the last seven years. He has been involved in the planning and delivery of on-premises and on-line solutions for a wide variety of clients ranging in size from small to global.
LinkedIn: http://www.linkedin.com/in/drjohntunnicliffe
Contact: https://devops-your-dwh.com/
Dr John Tunnicliffe is a well-respected designer and architect of business intelligence solutions who likes nothing more than getting his hands dirty with real life coding problems. John is a recognised expert in applying continuous integration techniques to data warehouse projects, thereby ensuring code is automatically built, deployed and tested as changes are made by the development team. As a regular speaker at the SQLBits conference and PASS SQLSaturday events, John has covered topics such as building an infrastructure to support real-time OLAP and continuous integration and the data warehouse.
Contact: http://community.obilogic.co.uk/blogs/
Anthony Obi - Independent SharePoint Consultant - Obilogic LtdWorking with SharePoint since Portal Server 2001 (10 years+)MCITP / MCTS SharePoint 2010
My background is in data visualisation ever since as a building architect in the 80s I struggled to produce lists of equipment from CAD models. I moved into building and infrastructure asset management in the late 80s using Unix systems, and gradually moved into Windows-based systems throughout the 90s. I became a European Business partner of Visio Corporation in 1996, and presented the database-linked Visio solutions that I was providing to the merchant banks in London and New York at several i
LinkedIn: http://www.linkedin.com/profile/view?id=270775013amp;trk=tab_pro
Contact: http://www.sqlmaster.de
Uwe Ricken is working with IT systems since the 90’s. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. In the same year he earned his first award as a Data Platform MVP for his support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.
LinkedIn: http://dk.linkedin.com/in/rasmusreinholdt/
Contact: http://rasmusreinholdt.wordpress.com
Rasmus is the Data Warehouse architect at UNOPS, the implementation arm of the UN, based in Copenhagen, Denmark. He has worked with Microsoft BI since 2005 both as a developer and architect, building large solutions on every release from sql2005 and onwards. Rasmus is certified is MSCE SQLServer (Data platform amp; BI), a long time speaker at various SQLSaturdays, PASS SQLRally Nordic and SQLBits. He also co-organizes SQLSaturday Copenhagen and blogs at http://rasmusreinholdt.wordpress.com.
LinkedIn: http://www.linkedin.com/pub/ruben-pertusa-lopez/24/ba3/b0
Contact: http://www.sqlpass.es
Ruben is a Global BI/BigData Manager and Global Data Lead Architect at DUFRY HQ, member of PASS Spanish Group and founder of SQLSaturday Barcelona and Madrid. MCP and MCSA in SQL Server 2012 and also awarded with Microsoft MVP Data Platform. With more than 9 years of experience, he has been working in top projects for leading worldwide companies and teaching in the SolidQ BI Master. He has presented at the SQL Server 2008 R2 and 2014 Spanish launch event, PASS BA Chicago, TechNet Webcasts, Microsoft Partner Program and SolidQ Summit events.
To point and click our way through a SharePoint installation is relatively easy, but will more than likely result in some form of disaster. Join SharePoint expert, Andy Talbot for a detailed discussion on building and running SharePoint platforms fit for enterprise customers. In this session, Andy will address some of the common challenges that can take some enterprises by surprise, lessons learnt by large organisations, factors that we should have planned for, and common failure points. Atte
LinkedIn: https://uk.linkedin.com/in/pjcov
Contact: http://www.sharepointdesignerstepbystep.com/Blog/
Penelope Coventry, MVP SharePoint Server, MCSE: SharePoint 2013 and MCITP: SharePoint Administration 2010, is an author and consultant based in the U.K., with more than 30 years of industry experience. Penny has authored and co-authored more than 10 SharePoint-related books. Penny has spoken at a number of conferences, including TechEd North America, SharePoint Conferences in United States, Canada, Australia, New Zealand, Sweden and the UK and at SharePoint Saturdays and user groups.
Contact: http://www.baddaz.com
Peter is a Solution Architect focusing on delivering Microsoft solutions including SharePoint, Dynamics CRM and Office 365. He has been working with SharePoint since 2004, lives in Cambridgeshire (United Kingdom) and can often be found on Twitter (@Baddaz) or his blog (www.baddaz.com). Peter is one of the organisers of East Anglia Region of the SharePoint User Group UK. His working life is spent leading a team of consultants delivering Microsoft Solutions to companies across UK and Ireland.
LinkedIn: https://www.linkedin.com/in/mladenprajdic
Contact: http://weblogs.sqlteam.com/mladenp
Mladen Prajdić is a Data Platform MVP from Slovenia. He's been programming for 20 years, developing different types of applications in .Net (C#) and SQL Server, ranging from standard line-of-business, image-processing applications to high performace and IoT applications. He's a regular speaker at various conferences and usergroup meetings, really likes to optimize slow SQL statements, analyze performance, and find unconventional solutions to difficult SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).
SharePoint Enthusiast working currently at a leading UK University Love of automation via Powershell and currently a CSOM enthusiast - Combine the two and thats where i come in :-)
LinkedIn: http://www.linkedin.com/pub/denis-reznik/3/502/234
Contact: http://reznik.uneta.com.ua
Denis Reznik is a Data Architect at Intapp, Inc. He has more than ten years experience in software development, database design, and performance tuning for cloud and on-premises solutions. In 2010 Denis became Microsoft Data Platform MVP and maintains MVP status today. Apart from his professional career, Denis actively participates in the development of the Ukrainian Data Community.
LinkedIn: http://pt.linkedin.com/in/webcaravela/
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.
LinkedIn: http://dk.linkedin.com/in/rasmusreinholdt/
Contact: http://rasmusreinholdt.wordpress.com
Rasmus is the Data Warehouse architect at UNOPS, the implementation arm of the UN, based in Copenhagen, Denmark. He has worked with Microsoft BI since 2005 both as a developer and architect, building large solutions on every release from sql2005 and onwards. Rasmus is certified is MSCE SQLServer (Data platform amp; BI), a long time speaker at various SQLSaturdays, PASS SQLRally Nordic and SQLBits. He also co-organizes SQLSaturday Copenhagen and blogs at http://rasmusreinholdt.wordpress.com.
LinkedIn: http://www.linkedin.com/tomaz.kastrun
Contact: http://www.tomaztsql.wordpress.com
Tomaž Kaštrun is BI developer and data analyst. His main focus are data mining, T-SQL development, programming and query optimization. He has been working with SQL server since version 2000. He is Microsoft Certified Professional, Microsoft MVP for data platform and Microsoft trainer.
LinkedIn: https://www.linkedin.com/in/chriswebb6/
Contact: https://blog.crossjoin.co.uk/
Chris Webb is a member of the Power BI CAT team. He is the author of "Power Query for Power BI and Excel" and a co-author of "SQL Server Analysis Services 2012: The BISM Tabular Model", "Expert Cube Development with SQL Server 2008 Analysis Services", and "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase".
LinkedIn: http://www.linkedin.com/in/kennie
Contact: http://www.pontop.dk/
Kennie Nybo Pontoppidan is a senior program manager in Microsoft working in the Dynamics NAV server backend team. He has worked in the dangerous field between developers, dbas, customers and project managers for many years and done his part of mistakes as a developer before that in his 15+ years in the it industry. He enjoys working with databases and really, really enjoys his daily dose of sql. Kennie has no humor.
LinkedIn: http://www.linkedin.com/profile/view?id=270775013amp;trk=tab_pro
Contact: http://www.sqlmaster.de
Uwe Ricken is working with IT systems since the 90’s. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. In the same year he earned his first award as a Data Platform MVP for his support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.
LinkedIn: http://dk.linkedin.com/in/rasmusreinholdt/
Contact: http://rasmusreinholdt.wordpress.com
Rasmus is the Data Warehouse architect at UNOPS, the implementation arm of the UN, based in Copenhagen, Denmark. He has worked with Microsoft BI since 2005 both as a developer and architect, building large solutions on every release from sql2005 and onwards. Rasmus is certified is MSCE SQLServer (Data platform amp; BI), a long time speaker at various SQLSaturdays, PASS SQLRally Nordic and SQLBits. He also co-organizes SQLSaturday Copenhagen and blogs at http://rasmusreinholdt.wordpress.com.
LinkedIn: http://uk.linkedin.com/in/jrowlandjones/
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.
LinkedIn: http://www.linkedin.com/pub/denis-reznik/3/502/234
Contact: http://reznik.uneta.com.ua
Denis Reznik is a Data Architect at Intapp, Inc. He has more than ten years experience in software development, database design, and performance tuning for cloud and on-premises solutions. In 2010 Denis became Microsoft Data Platform MVP and maintains MVP status today. Apart from his professional career, Denis actively participates in the development of the Ukrainian Data Community.
LinkedIn: https://uk.linkedin.com/in/pjcov
Contact: http://www.sharepointdesignerstepbystep.com/Blog/
Penelope Coventry, MVP SharePoint Server, MCSE: SharePoint 2013 and MCITP: SharePoint Administration 2010, is an author and consultant based in the U.K., with more than 30 years of industry experience. Penny has authored and co-authored more than 10 SharePoint-related books. Penny has spoken at a number of conferences, including TechEd North America, SharePoint Conferences in United States, Canada, Australia, New Zealand, Sweden and the UK and at SharePoint Saturdays and user groups.
LinkedIn: http://dk.linkedin.com/in/jvestergaard
Contact: http://www.t-sql.dk
Jens performs the traditional BI disciplines from imports in Integration Services through data consolidation in Analysis Services, to report in Power BI or Reporting Services. Jens has worked with The Stack since SQL 2000 and has a core competence in Integration Services and Analysis Services. Along with the certified skills in Microsoft SQL Server, Jens has also worked with Microsoft .Net platform for more than 15 years and currently manages a BI Platform in Azure for the CatMan Solution application(s).
LinkedIn: http://www.linkedin.com/in/kennie
Contact: http://www.pontop.dk/
Kennie Nybo Pontoppidan is a senior program manager in Microsoft working in the Dynamics NAV server backend team. He has worked in the dangerous field between developers, dbas, customers and project managers for many years and done his part of mistakes as a developer before that in his 15+ years in the it industry. He enjoys working with databases and really, really enjoys his daily dose of sql. Kennie has no humor.
LinkedIn: http://uk.linkedin.com/in/johnqmartin/
Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/
John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK. John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.
David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa
David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa
LinkedIn: http://www.linkedin.com/in/kennie
Contact: http://www.pontop.dk/
Kennie Nybo Pontoppidan is a senior program manager in Microsoft working in the Dynamics NAV server backend team. He has worked in the dangerous field between developers, dbas, customers and project managers for many years and done his part of mistakes as a developer before that in his 15+ years in the it industry. He enjoys working with databases and really, really enjoys his daily dose of sql. Kennie has no humor.
Jon Woodward is the BI and Analytics Lead for Microsoft UK. Stuart Aston is the Chief Security Officer for Microsoft UK. Stuart has been with Microsoft in the UK since 1998 and is the National Security Officer for Microsoft in the UK. Gary Richardson is the Director of Analytics Engineering for KPMG. Anthony Marzetti is the Director of Data Integration at Tagetik. Ric Howe works for Microsoft UK as a technical consultant. Anthony Saxby is the Data Platform Lead for Microsoft UK.
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.
LinkedIn: http://dk.linkedin.com/in/regisbaccaro
Contact: http://theblobfarm.wordpress.com
Regis has more than 15 years of experience with SQL Server, SharePoint and .Net as an architect and developer. R#233;gis is a SQL Server MVP since 2014 and a frequent speaker at SQL conferences, a PASS Regional Mentor and the founder of SQLSaturday Denmark community event. He is also a certified industry trainer on the APS/PDW platform. In his freetime he is an avid runner, cook and farmer.
LinkedIn: http://uk.linkedin.com/in/johnqmartin/
Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/
John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK. John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.
LinkedIn: https://www.linkedin.com/profile/view?id=4839367
Contact: http://www.gdsbi.de
Frank Geisler is owner and CEO of GDS Business Intelligence GmbH. He is SQL Server MVP, MCT, MCSE – Business Intelligence, MCSE – Data Plattform and MCSE - Azure Solutions Architect. In his Job he is building Business Intelligence Systems based on Microsoft Technology, mainly on SQL Server and SharePoint.
LinkedIn: http://uk.linkedin.com/in/sqltomato
Contact: http://sqltomato.com/
Tom is a Senior SQL Server consultant for Quorum Network Resources, a Microsoft Gold Data Platform Partner based in Edinburgh. He is a MCT in addition to being multiple MCSE in Data and Cloud. Current projects include SQL Infrastructure and Performance Tuning, Hybrid Azure SQL Solutions and SQL 2014 migrations.
LinkedIn: http://www.linkedin.com/in/kennie
Contact: http://www.pontop.dk/
Kennie Nybo Pontoppidan is a senior program manager in Microsoft working in the Dynamics NAV server backend team. He has worked in the dangerous field between developers, dbas, customers and project managers for many years and done his part of mistakes as a developer before that in his 15+ years in the it industry. He enjoys working with databases and really, really enjoys his daily dose of sql. Kennie has no humor.
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.
LinkedIn: https://www.linkedin.com/in/johanludvig/
Contact: http://brattas.org/sqlmusings
Johan Ludvig Brattås is a managing consultant at Capgemini, and a dedicated community guy. He has worked with MS SQL server since late 1999, mostly with BI in one form or another. The last 6 years, most of his work has been in Azure working on data platforms, Power BI and the last three years expanding to Azure IoT and Stream Analytics. Combining his passion for Microsoft SQL Server with his passion for sharing knowledge, he has spoken at various events in the SQL Community. This is also a way to give back to the community for all the things he has learned over the years. When not working, Johan Ludvig either spends his time with his kids, playing with new technology, or teaching coeliacs how to bake glutenfree food.
LinkedIn: http://www.linkedin.com/in/kennie
Contact: http://www.pontop.dk/
Kennie Nybo Pontoppidan is a senior program manager in Microsoft working in the Dynamics NAV server backend team. He has worked in the dangerous field between developers, dbas, customers and project managers for many years and done his part of mistakes as a developer before that in his 15+ years in the it industry. He enjoys working with databases and really, really enjoys his daily dose of sql. Kennie has no humor.
LinkedIn: http://bg.linkedin.com/in/borishristov
Contact: http://borishristov.com/blog/
Boris is a SQL Server Consultant, but also an Author for Pluralsight and a SQL Server MVP. He is frequently speaking at conferences all accross Europe and is heavily involved in training students and organizations in what he calls quot;The Art of SQL Serverquot;. Boris is frequently blogging and is the host of SQLHangouts.
Contact: http://andrekamman.com
André Kamman is a DBA and SQL Server Solutions Architect for CloudDBA. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML). He also likes to work with MPP platforms APS and AzureDW. André is a Data Platform MVP, Dutch PASS Chapter Leader and organiser of SQLSaturday Holland.
LinkedIn: http://nl.linkedin.com/pub/enrico-van-de-laar/33/882/756/
Contact: https://www.enricovandelaar.com
Enrico has been working with data in all kinds of formats and sizes for over 15 years. He is a Data Advanced Analytics Consultant for Dataheroes where he helps organisations take their first steps in the world of Advanced Analytics. Enrico is a Data Platform MVP since 2014 and a frequent speaker on various data related events all over the world. He authored the book “Pro SQL Server Wait Statistics” and blogs about technologies like Microsoft SQL Server and Azure Machine Learning on his blog at www.enricovandelaar.com
LinkedIn: http://uk.linkedin.com/in/aleardley
Contact: http://blog.eardley.org.uk
Alan Eardley is a Solution Architect at Corporate Project Solutions (CPS) specialising in Office 365. He has worked with SQL Server since version 7 and with SharePoint and associated products for the last seven years. He has been involved in the planning and delivery of on-premises and on-line solutions for a wide variety of clients ranging in size from small to global.
LinkedIn: https://uk.linkedin.com/in/retracement
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.
LinkedIn: https://www.linkedin.com/in/wollatondba
Contact: http://www.chrisadkin.io
Chris is a freelance SQL consultant who has been working with SQL Server since 2000, his passion is for squeezing every last drop of performance out of SQL Server and understanding the database engine at a level which conventional tools cannot provide any insights on.
LinkedIn: https://www.linkedin.com/profile/view?id=4839367
Contact: http://www.gdsbi.de
Frank Geisler is owner and CEO of GDS Business Intelligence GmbH. He is SQL Server MVP, MCT, MCSE – Business Intelligence, MCSE – Data Plattform and MCSE - Azure Solutions Architect. In his Job he is building Business Intelligence Systems based on Microsoft Technology, mainly on SQL Server and SharePoint.
Contact: http://andrekamman.com
André Kamman is a DBA and SQL Server Solutions Architect for CloudDBA. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML). He also likes to work with MPP platforms APS and AzureDW. André is a Data Platform MVP, Dutch PASS Chapter Leader and organiser of SQLSaturday Holland.
The following is a list of sponsors that helped fund the event.