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 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.  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 diﬀerent 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 diﬀerent 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.


Python is a programming language that lets you work more quickly and integrate your systems more
effectively. Listed below are some applications of Python:
- Web and Internet Development
- Education
- Software Development
- Business Applications
Of course, this is just a brief synopsis of all the amazing things that Python can do. To check our
sources
and learn more complex information please visit Python . Check out
the
documentation, current events, and community sections and code away!


Survey form
This is a short explanation for this survey form
Name
Email
Age
Yes
No
Male
Female
HTML
CSS
Javascript
Additional Comments
Submit


Welcome
Here you will find information about the Carolina Bay neighborhood community and what makes it so great. There are several different sections of Carolina Bay, each with their own style and feel.
Amenities
Pools
There are three pools to choose from, available to all Carolina Bay homeowners regardless of which section you live in. Each pool has a pavillion which you can reserve to hold small events such as birthday parties and also includes restrooms. The pools open on April 15th and close October 15th.
Park
The main attraction is the park, conveniently located in the middle of the neighboorhood. We have Food Truck Fridays throughout most of the year and our Social Committee throws awesome events for the kids including Movies and carnival type activies. You'll also see adult organized fitness activites such as Yoga and soccer.
Playgrounds
There are four playgrounds; one at each pool and the another within the Park.
Dog Park
We even have our very own 1/4 acre fenced dog park! The shaded area is great for a hot summer day.
Trails
The entire neighborhood has sidewalks which in some areas are super-wide but perhaps you like to explore the scenery. There are several miles of short disconnected trails that weave throughout the neighborhood. Most go around the ponds so be careful of stumbling upon a gators!
Kayak Launch
There's a spot in the neighborhood to launch a kayak onto a 1.5mi section of Long Branch River which averages 35 feet wide and only 5 feet deep at mid-tide.
Fishing
There are about two dozen ponds, small and large, in the community and you frequently see people fishing. At least the main ones are stocked seasonally with fish such as triploid grass carp.
Active Community
There are over 1700 living units in Carolina Bay and still growing. With that there are over 1400 members in communication on private Facebook group which is a great way to stay involved in neighborhood news. NextDoor is active as well for the surrounding West Ashley neighborhoods.
Greenway
Just across the main entrance of community, at Savannah Highway, is access to the West Ashley Greenway, a 8 mile walking/biking trail. Take it all the way to Avondale!


Review of ROMEO + JULIET (1996)
The Book-Lover's Guide to Cinema
http://www.panix.com/~mgold/meter.htm copyright1998 Matthew K. Gold all rights reserved
Kitsch For Sale
ROMEO + JULIET does to Shakespeare's play what CLUELESS did to Jane Austen's novel: it modernizes and updates a classic work for the 18-24 year-old market. After seeing this loud, ambitious movie twice, I remain conflicted about it: while I was moved by it, I also think that it is a piece of manipulative fluff--a kind of "Teen Beat" magazine in cinemascope.
Each generation reinvents Shakespeare for itself. This ROMEO + JULIET is ridden with 90's kitsch. It uses Shakespeare's words, but takes its imagery from the exaggerated vocabulary of soap operas, MTV, and Andy Warhol. It was filmed in Mexico City, which is an exaggeration of urban life in itself. The kitsch works well in some sequences: in an invigorating party scene, at which Romeo (Leonardo DiCaprio) and Juliet (Claire Danes) first meet, characters wear costumes that effectively communicate their personalities: Romeo wears the stylish armor of a post-modern knight, Juliet wears the foam wings of an earthbound angel, Capulet (Juliet's dominating father) wears the Caesaric robes of an august patriarch, Mercutio (Romeo's friend and the Prince's kinsman) wears the sequined dress of a drag queen, and Paris (Juliet's establishment-minded suitor) wears the dorky space-gear of an enthusiastic astronaut. I appreciated the way the movie updated Shakespeare's characters. In this movie, the Prince of Verona is a tough police commissioner, the Capulets and Montagues are rival gangs, the chorus is a TV anchorwoman, and the Friar Laurence (Pete Postlethwaite, who gives a fun performance) is a hip priest who proclaims the benefits of "herbs." Many of these touches are original and thought-provoking; this movie could be understood as a comment on recent racial disturbances in Los Angeles, Bedford-Stuyvesant, Miami, and Crown Heights. The problem is that I'm not sure what, exactly, it might be saying.
As Romeo and Juliet, Leonardo DiCaprio and Claire Daines give effective performances. The camera adores these young stars. As soft golden light plays over DiCaprio's wet hair, skinny torso, and sensuous lips, one thinks of James Dean's body and Marlon Brando's cheekbones. As the angelic Juliet, Danes looks pristine--until she smirks naughtily while considering that "other part/ belonging to a man." The single best scene of the movie occurs when DiCaprio and Danes first lock eyes through a fish tank. For a few brief moments, pure innocence and charm take command of the screen. These actors, both on the cusp of puberty, convey the wonder and the angst of two young lovers in the throes of an overpowering, but impossible, love. DiCaprio and Danes are a perfect Romeo and Juliet for the 1990's: their budding bodies are completely in sync with the recent trend of unisex ad campaigns.
At a certain point during the movie, the many excesses began to bother me. The brashness that was at first charming soon became tiresome. In many scenes, such as the one in Church where Juliet reposes amid millions of crosses and candles, the layers of kitsch became so thick that I had trouble locating any glimmer of sincerity or feeling. The imagery of ROMEO + JULIET has the puffed-up ethos of a TV commercial. Watching this movie made me think of Thomas Carlyle, who, in Past and Present (1843), decried the effects of advertising on shoemaking: "Thy shoes are vamped up falsely to meet the market; behold, the leather only seemed to be tanned; thy shoes melt under me to rubbishy pulp, and are not veritable mud-defying shoes, but plausible vendible similitudes of shoes." At their best, movies like ROMEO + JULIET cannot create true emotions, because they themselves evince none; they can only produce "vendible similitudes" of emotions. In the end, that's just not enough for me.
Rating: 3.5/5.0
1/31/97 © Matthew K. Gold 1998
Production Notes:
ROMEO + JULIET is rated PG-13. Cast: Claire Danes (Juliet Capulet), Leonardo DiCaprio (Romeo Montague), Harold Perrineau (Mercutio), Pete Postlethwaite (Father Laurence), Paul Sorvino (Fulgencio Capulet), Brian Dennehy (Ted Montague).
Directed by Bas Luhrmann. Screenplay by Baz Luhrmann and Craig Pearce. Based on the play by William Shakespeare. Running time: 120 minutes.
The Book-Lover's Guide to Cinema http://www.panix.com/~mgold/meter.htm copyright 1998 Matthew K. Gold
The review above was posted to the
rec.arts.movies.reviews newsgroup (de.rec.film.kritiken for German reviews).
The Internet Movie Database accepts no responsibility for the contents of the
review and has no editorial control. Unless stated otherwise, the copyright
belongs to the author.
Please direct comments/criticisms of the review to relevant newsgroups.
Broken URLs inthe reviews are the responsibility of the author.
The formatting of the review is likely to differ from the original due
to ASCII to HTML conversion.
Related links: index of all rec.arts.movies.reviews reviews


Preparation time
30 mins to 1 hour
Cooking time
over 2 hours
Serves
Serves 10-12
I love roasting turkey with the stuffing inside the cavity of the bird - after all, that’s why it’s called stuffing! It absorbs all the lovely turkey juices, creating a flavourful accompaniment to the Christmas roast. Trust me, you'll never go back to making stuffing in a separate tin again! Oven temperatures vary, so be sure to check your turkey is cooked through.
For this recipe, you will need a piece of muslin cloth large enough to cover the turkey.
For the stock, put the gizzard, heart, wing tips, wishbone, onion, carrot, celery and herbs in a saucepan and season. Cover well with about 2 litres/3½ pints cold water and bring to the boil, then reduce the heat and simmer for 2 hours, or until you have a flavoursome stock. Strain and set aside for making the gravy. (The stock can be made a day or two in advance; cover and store in the fridge, then de-grease if any fat floats to the top.)
Preheat the oven to 200C/180C Fan/Gas 6. For the stuffing, melt the butter in a saucepan over a medium heat. When it is foaming, add the chopped onions and season. Cover with greaseproof paper and a lid, turn the heat to low and cook for 8-10 minutes, or until completely softened. Set aside to cool.
Put the cooled onions in a mixing bowl. Mix in the breadcrumbs and mixed herbs and season to taste. Weigh the stuffing to assist with calculating the cooking time.
Season the turkey cavity at both ends. Stuff some of the stuffing into the main cavity, but be careful not to pack it in - there must be enough space between the stuffing and breastbone to fit the handle of a wooden spoon. Stuff the smaller cavity at the neck end, again leaving a little space (you may not need all the stuffing, depending on the size of your turkey).
To assist with calculating the cooking time, add the weight of the turkey, stuffing and 175g/6oz butter together or weigh the stuffed turkey and add the weight of the 175g/6oz butter.
Put the turkey in a large roasting tray. Melt the 175g/6oz butter, then soak the muslin in the butter and wrap it over the turkey. Roast for 15 minutes, then turn the oven down to 180C/160C Fan/Gas 4 and roast for a further 15 minutes per 450g/1lb total turkey/stuffing/butter weight. Baste every 30 minutes; it is important to do this quickly so as to not let the turkey cool down, as this could alter the cooking time. Remove the muslin 15 minutes before the end of roasting and baste again.
To test the turkey is cooked, insert a small fruit or vegetable knife into the thicktest part of the meat, between the leg and breast; the juices that run should be clear, with no sign of pink; if there is any pink, return the turkey to the oven for another 15-20 minutes, or until cooked through. Tranfer the turkey to a carving dish. Cover it with parchment paper, then place a clean tea-towel over it to keep it nice and snug. Leave it to rest for at least 30 minutes, or up to 1½ hours.
Meanwhile, for the gravy, remove the surplus fat from the roasting tray with a spoon. Place the tray on a medium heat and deglaze it by pouring in the stock. Using a whisk, scrape free all the caramelised bits on the bottom of the tray. Bring the mixture to the boil, then carefully pour it into a saucepan through a sieve and season. To thicken the gravy, mix together the butter and flour, then whisk it into the gravy. Bring the mixture to a simmer, then remove from the heat.
Carve the turkey and serve on warm plates with the stuffing and hot gravy.


| Specification | PS4 Specification |
|---|---|
| Dimensions | 275mm (w) x 53mm (h) x 305 mm (l) |
| Weight | 2.8kg |
| Processor | CPU: Eight-core x86 AMD Jaguar |
| GPU | GPU: AMD Radeon Graphics Core Next Engine, 1.84 TFLOPS floating point performance |
| RAM | 8GB GDDR5 RAM |
The PS4 is Sony's most attractively designed piece of hardware. It's a beautiful system, with a sharp, slightly angled profile accented by a light bar that acts as a console status indicator.
On the back, PS4 has gone digital-only with HDMI/optical ports, and no analogue audio or video outputs.
Sony has solved every one of these problems with the DualShock 4. Its sticks are farther apart, with semi-concave pits in the middle designed to hold the tips of your thumbs in place. The shoulders feature actual concave triggers with pull similar to an Xbox 360 controller.
The controller is just a little heavier, just a little bigger. It's much more comfortable to hold over long periods of time. The DualShock 4 is the most immediately apparent improvement offered by the PS4.
These are two locations at which it is possible to buy this console.
The first location it is at is Game. If you click on the higlighted Game text you will be taken to another web page where you can buy the console.
The second location it is at is Argos. If you click on the higlighted Argos text you will be taken to another web page where you can buy the console.


This application lets you explore a phylogenetic tree, which expresses evolutionary relationships among species. Click on a node to expand/collapse its descendants recursively.
Modern species appear in the leaves of the tree, while the nodes represent common ancestors of the modern species that lived at various times in the past.


A jQuery plugin to create a listbox that works as you want.
With this jQuery plugin you can create a listbox which can contain an array of almost any kind of item: string, Number, Object, etc. You can define your own render and encoder functions. Insert, multi insert, move up and down is supported out of the box - and much more!
JSON.stringify
to post in a
hidden input)
transfer
methods to copy or move elements between two jqListbox'es (from v1.1)
This is a very simple example using a div with some CSS to display our scrollable list.
The list contains Objects but only the title
field is displayed.
This example uses the build in JSON.stringify()
encoder to transform the list to a JSON
string in the textarea field.
There are several ways to do things in jqListbox. For example updating multiple (selected) items: you can update all of the selected items with the same data or you can update each selected items with different data.
This example is using the itemRenderer
option in a creative way. As you can see you can
really render your items as you want!
Also this one is using a custom select render method - not the built in (automatic)
selectedClass
!
The first example is using Bootstrap's Modal for asking for user input, but the second one just throws simple JS prompt boxes. With jqListbox it's up to you how to do things, how to interact with the user.
This example is using the transferSelectedTo
method to move the selected elements between the
listboxes. For this setup both listboxes should contain the same type of elements. There are two other methods
available: transferByIndexTo
and transferByIndexMultiTo
methods.
This example is using the listboxValueEncoder
option to transform the items to the
needed target value. This target value can be posted in a hidden input for example.
Also we are using multiUpdate
here. With multiUpdate
you can update all of
the selected elements with different data.
We are using the onBeforeItemInsert
callback to limit the number of elements to
10.


Touch me anywhere to get started.
Oooo,
that’s it.
Touch me again.
Oooo, yeah!
That’s how
I like it.
Now your turn.
Select a swing:
Ok, if that’s how you like it.
Now my turn.
I want to hear you make a sound in my microphone.
Are you ready?
But wait.
I want you to make it last this time.
A few seconds, at least.
Ok... you promised.
Now touch and hold me while you make your sound.
Did you like that?
or


Recently a few of our sites experienced data reception that was severely throttled or stopped for no apparent reason. Symptoms were inconsistent and somewhat sporadic and included:
We determined that Packetshaper had been installed at these sites. Packetshaper is a product developed by Packeteer to analyze and "shape" network traffic. It is often used to limit traffic from low priority applications. Packetshaper is a box that generally sits between a router and switch. Thus, there's no way to tell whether it's running except to ask your network administrator.
Packetshaper can discriminate traffic based on port number, IP address, application, protocol, subnet, URL, and other criteria. But if it's misconfigured, LDM traffic can be adversely affected.
If you determine that Packetshaper is running at your site, perhaps the easiest way to determine if it is affecting your data flow is to ask your network engineer to turn it off for 30 minutes. If your data reception quickly improves, it's reasonable to assume that Packetshaper was not properly configured. With technical help from Packeteer, we are providing the instructions below for configuring Packetshaper to allow LDM traffic to flow.
Note: when buying Packetshaper, sites have an option to purchase support. Please check to see if your contract includes support. If you have support, you should use that, as these pages may become outdated.
Note: Technical support at Packeteer recommends that the Packetshaper be upgraded to the current software version, 5.2.2 if they have not done so already. Performance of the rate policies is improved over previous versions. Also, Packeteer is regularly adding applications to the "autodiscover" process, which are made available via upgrades.
To isolate this traffic it will be necessary to create two classes to capture traffic on this port. One will be an inbound class, the other will be outbound. For each class we will
Each class, both inbound and outbound, will contain two matching rules. One rule will match the ports "inside:any" and "outside:388". The other rule will match ports "inside:388" and "outside:any". This will allow us to catch traffic on port 388 on either side regardless of whether the machine is a server or client. (Technically, an LDM site can switch roles, so that at any time it may be either a client or a server.)
To create the inbound class, first click the "/Inbound" folder in the left frame. This will take you to the manage page for the root /inbound folder. Click the "class" button, then "add" in the drop down menu. This will take you to the page shown here:
First, name the class.
Next, we will specify two rules for the class. When creating a new traffic class, the Packetshaper automatically adds at least one matching rule. For the first rule, choose location "any", then specify an inside port of "any" and an outside port of "388". All other fields are left as their defaults. Click "add class".
To add the second rule, return to the manage page, click the "class" button once again, then "add matching rule". This will take you to a class which is identical to the newclass page, except it will be missing the class name. Add another rule that will match ports "inside:388" "outside:any". Click "add rule" and the class is complete.
This now takes us to the manage page for the LDM class:
Choose Type: "Exception" then "Apply Changes". The Packetshaper classifies traffic from top to bottom, so this will move the class toward the top of the tree.
All classes get priority 3 by default. To prioritize this traffic one can give it a higher rate policy. First of all, on the manage page for the class, click the "Policy" button then "add" to get the following page:
On this screen you can choose to add either a rate policy, or a priority policy. The page Selecting and Using Policies describes the differences between both types of policies and when it is appropriate to use each type. For the LDM, it is recommended that you set a rate policy because this allows reservation of bandwidth. Packeteer technical support recommends setting the rate policy to Priority 5. Although Priority 7 is the highest, very high rate policies should be used with caution because they tend to starve those traffic types with lower-priority policies if the traffic type is persistent and particularly aggressive. A rate 5 is usually sufficient.
With a rate policy you are required to fill out several fields. First of all, enter 0 for "Guaranteed". Check the "burstable" box, then choose Priority 5 from the drop down menu. Upper limit should be left blank. Click "add policy" to complete the process.
There is also an option to add a bandwidth partition for the class. The most important difference between a policy and a partition is that a policy will work on individual flows, while a partition will work on the aggregate of all flows within the partition. So if a traffic type is particularly delay sensitive it is usually a good idea to guarantee some bandwidth to the class as a whole.
To add a partition go to the manage page for the class and click on "partition" (and then "add"?) to get this window:
The "size" specifies the reserved bandwidth for this traffic type. This can remain fixed by unchecking the "burstable" box, or a "limit" can be specified up to which it can burst. If the upper limit is left blank, the traffic will be allowed to burst up to the link rate. Otherwise, it will be capped. Click "add partition" to complete the process. In this example, all LDM traffic is guaranteed 200k. It will not compete for these 200k with any other traffic types but if LDM does not need all 200k, the remaining bandwidth will be available to classes outside the partition. When it reaches 200k, if it needs more bandwidth then it will receive it based on the policy on the class. In this case it is a rate policy with 0 guaranteed, and burstable at priority 5.
(If you would like help in estimating the volume of data to your site, please send email to<EMAIL_ADDRESS>Please include the 'request' lines from your ldmd.conf file.)
This completes the class in the /Inbound folder.
To get to this screen click the "Manage" tab, then the "traffic class test" button on the upper right hand side. You will then get the screen in the image.
To test, enter the server port number 388 then click "test". This will list the traffic class which is currently classifying this traffic. You can also test for both directions of traffic flow, Inbound and Outbound to make doubly sure. Most likely, it will be going to DiscoveredPorts/TCP_Port_388.


Spinners are used to let the user know an action is in the works, so he doesn't become impatient.
Psychology studies show that in UI, it is very important to use the spinners when the user needs to wait or he is more likely to leave the application.
Now lets observe some of the spinners there are:


Page Links: Index Page
| ChristiaanJ 21st Aug 2010, 15:12 permalink Post: 46 |
Ozgrade3,
I would say those books already have been written... from the autobiographies of Turcat and Trubshaw, through the books by people like Brian Calvert, Christopher Orlebar and others, to the Haynes "Concorde Owners' Workshop Manual" (!), that's come out recently. I've written some bits and pieces, but it's more for my offspring, to explain what all that Concorde junk and documentation in the shed is all about, so they don't all thrash it when I'm gone... I don't think my story would interest a larger public. As M2dude says, we just like to share some of our experiences with those who are interested. |
||||
| BlueConcorde 12th Sep 2010, 16:08 permalink Post: 331 |
First of all, THANKS to all you from Concorde family for this fantastic topic. Started reading last night and almost slept in front of computer trying to read everything!
As a Concorde fan for 10 years (since I bought FS2000), and passionate developer of SSTSIM Concorde and FSLabs ConcordeX (flight dynamics, weight and balance), it's simply awesome to have you guys and gal here sharing your memories. Regarding the CG corridor, here's a fantastic graphic from online Concordepedia, aka ConcordeSST.com, Technical/Fuel System section: Interestingly, it doesn't show a warning for CG>59.1% above M1.6, opposite to what M2Dude said earlier on the topic. I got curious on the Max Climb/Cruise and ALT ACQ not being primed. How the levelling at FL600 was done? Manually? Regarding the fuel tanks, specially tanks 6 and 8: did these tanks' lateral center of gravity change with quantity? Due to their completely assymetrical shape, I'd expect some change in it. Operationial question: did BA use the 380kts descent profile? Have heard that only AFR used it, but Haynes' book says that BA started using it too. There are many doubts regarding procedures as manuals and informations available on the internet are mostly from BA 1976 entry-into-service era. But i understand many things changed along the years, as I can see on a Aug 2000 manual I've got, with percentages showing differences from the 76 era, or even completely new tables. Well, that's it, hope to be able to contribute on the topic, but mainly learn from you that flew the real thing. |
||||
| BlueConcorde 19th Sep 2010, 02:26 permalink Post: 390 |
Hello again!
I went on Thursday to one of the few aviation libraries in Brazil, and found a very rare book on Concorde. Once they take copies of the items I requested, will share here. The book in question was edited in 1969, French and English, and shows all suppliers of the protoypes, with some interesting ads. Well, just recycling my questions, lost on the previous page: 1) Were the flights to Ronivaniemi supersonic? 2) For BA001 and BA003, 2 Concordes were prepared for the same flight, right? Did ever happened some situation that required a ready-for-takeoff Concorde be brought back? How long a cargo and passengers transfer would take? The backup Concorde was fueled? And a new question: 3) Haynes' book on page 23, says about an increased MLW of 130 tons instead of the famous 111,13 tons. I NEVER, ever, heard/read about this, can anyone shine a light on it? Thanks again for all your posts, about to watch the BBC videos! |
||||
| Bellerophon 19th Sep 2010, 11:40 permalink Post: 391 |
BlueConcorde
... Haynes' book on page 23, says about an increased MLW of 130 tons instead of the famous 111,13 (sic) tons. I NEVER, ever, heard/read about this, can anyone shine a light on it?... I'm not aware of what Haynes may say about Concorde - I don't have a copy of the book and haven't read it - however it is well documented that landings at weights up to 130,000 kgs were permitted on Concorde, provided various conditions were met. It was a Conditional Procedure called Fuel Saving Landing . BA did not plan flights to land at 130,000 kgs but the procedure was available for use when required. In practice it was rarely used, and the occasions on which it was used tended to be following a return to the departure airfield, or a diversion in the early part of the flight, with the aircraft still above the (normal) maximum landing weight, in order to reduce the amount of fuel to be jettisoned. Best Regards Bellerophon |
||||
| BlueConcorde 19th Sep 2010, 18:53 permalink Post: 401 |
Quote:
By the way, I highly recommend this book to everybody, a different point of view, new photos and nice info regarding this bird.
Quote:
Nice info regarding BA004! But if a repair was needed, would BA004 take-off anyway to Gatwick or Birmingham? Has it ever arrived a bit late?
Quote:
Quote:
Thank you all, awesome topic!! |
||||
| Nick Thomas 18th Dec 2010, 19:34 permalink Post: 878 |
Thanks Dude and Bellerphon for such graphic descriptions of JFK 31L take off. Nearest I came to experiencing anything like that was landing at Kai Tak in the 80's!
Out of interest Bellerphon was there a supersonic acceleration point for JFK departures or as you were soon over the ocean, was it a case of it happened when it happened? Regards Nick P.S Thanks Christiaan for your Concorde book thread. I am hoping that Santa brings me the Haynes manual! |
||||
| ChristiaanJ 19th Dec 2010, 00:44 permalink Post: 882 |
Quote:
You'll have everybody here green with envy.... Even if it was on a "blunty" it was still spectacular. And I think Kai Tak is already in the Brooklands sim database.... so you can now come and fly it yourself....
Quote:
Quote:
CJ |
||||
| 911slf 28th Dec 2010, 17:51 permalink Post: 1031 |
Peak fuel consumption - question
I have been a Concorde fan since I won a flight on it in 1980, courtesy of a competition in the Birmingham Evening Mail.
I got the Haynes Manual for Christmas. On page 95 there is a diagram and photo of the centre dash panel, showing among other things the fuel consumption gauges, which, remarkably, read up to 35 tonnes per engine per hour. There appears to be two digital displays per gauge as well as an analogue display. What was the peak consumption per engine, and why two digital displays on each gauge? |
||||
| ChristiaanJ 28th Dec 2010, 21:54 permalink Post: 1032 |
Quote:
My guess is that the upper digital counter indicates the proportion of the fuel flow that goes to the reheat but it's only a guess. Sorry, I have no figure for the max fuel consumption. The '35 tonnes/hr' limit on the indicator is obviously beyond the upper limit, like the speedo on a car..... But yes, fuel consumption at takeoff with reheat was horrendous, and would have emptied all the tanks in an hour or less. CJ |
||||
| 911slf 5th Dec 2011, 09:06 permalink Post: 1505 |
handed? really?
If the quote in message #1504 is correct, why would there be a vibration problem on take off in engine #4
only
?
Ref: p80 Haynes 'Owners Workshop Manual' I make no claim to technical knowledge but this seems unlikely. Is there a source for this? Last edited by 911slf; 5th Dec 2011 at 09:18 . Reason: reference |
||||
| CliveL 18th Feb 2012, 18:45 permalink Post: 1573 |
Concorde modelling
Year of the Tiger
I don't envy you your self imposed task, you will I'm afraid find it quite difficult to get any detailed drawings as they were long ago buried in the archives of two now non-existent companies - Sud Aviation and British Aircraft Corporation. The best source of overall structure drawings I have seen is that on the HeritageConcorde.com site. which also gives some explanations of the structural concepts. The Haynes Concorde Owners Workshop Manual also has some interesting data. One problem is that the loading conditions on the various bits of the wing varied so much and the whole thing was so finely optimised for weight saving that there are many different structural concepts used. You (and others here) may find a 1999 lecture given by Dudley Collard (a much respected Concorde design engineer) of interest. You can find it at www.svfw.ch/Archiv/ConcordeDev.pdf Felicitations! Last edited by CliveL; 18th Feb 2012 at 18:47 . Reason: spelling |
||||
| YearoftheTiger 20th Feb 2012, 13:13 permalink Post: 1574 |
Quote:
The modeling in it self isn't difficult, I've been doing it for many years. To me, proportions and correct dimensions are more important than detail, so the real challenge is finding drawings that show major structural components accurately. As for the detail, ideally I'd love to capture it all, but that is impossible. In my experience helping friends who were studying Industrial Design in college, once you have the correct proportions down for the main components, you can continue adding smaller and smaller parts / details later on with relative ease as information on them become available. Whereas building the smallest detail and working up is a very bad way to start. Thank you all for your support. I'll keep reporting back as I make progress. Hopefully I haven't come across too crazy (but a little bit is OK and probably a given). |
||||
| stilton 27th Aug 2012, 07:29 permalink Post: 1664 |
Just finished the Haynes 'Concorde workshop manual'
This is a collaboration between a retired Concorde Captain and Flight Engineer. The one excerpt that really caught my eye was the reference to the method of construction and differences between the British and French built Aircraft. 'The French fuselage was designed to safe life principles while the British was designed to fail safe. From window line to window line across the top of the fuselage Bristol used three skin panels overlapping at 10 o'clock and 2 o'clock while Toulouse used two, overlapping at 12 o'clock' This revelation was a big surprise to me, for a production run of 14 airframes two different construction methods were employed apparently, amazing. I had always thought the airframes were virtually identical. Anyone have any further insight on this ? Last edited by stilton; 27th Aug 2012 at 07:30 . |
Page Links: Index Page


Previous: -output
The pointer size is used to inform precision mismatch warnings involving pointer variables, for example when a pointer is assigned a value from an allocation routine, or passed as a subprogram parameter.
See also: -f77, -portability, -truncation, -wordsize.
Next: -portability


There has been a server-side error, meaning the problem is not with your computer or internet connection but instead with this website's server.
We apologise for any inconvenience this may cause.
Go back or start again.


Sales Tables for Pat's Salmon Cookies
Add New Store Location
Name of Location:
Minimum Customers Per Hour:
Maximum Customers Per Hour:
Average Cookies Sold Per Customer:
Create New Store!
Link to Customer Facing Page