Event Location:
Business School, Manchester Metropolitan University
All Saints Campus, Oxford Rd, Manchester
Manchester, England, United Kingdom
Abstract:
How do we implement Azure Data Lake? How does a lake fit into our data platform architecture? Is Data Lake going to run in isolation or be part of a larger pipeline? How do we use and work with USQL? Does size matter?! The answers to all these questions and more in this session as we immerse ourselves in the lake, that’s in a cloud. We'll take an end to end look at the components and understand why the compute and storage are separate services. For the developers, what tools should we be using and where should we deploy our USQL scripts. Also, what options are available for handling our C# code behind and supporting assemblies. We’ll cover everything you need to know to get started developing data solutions with Azure Data Lake.
Speaker(s): Paul Andrew,
Abstract:
The client has some burning business questions and you have the client's data. So which tools will help you to understand that data and tell your client something they did not know already? In this session, I'll take you through my personal choice, demo each of them and explain their value. These include Excel; Tableau; R and RStudio and my favourite packages; Power BI and especially the fabulous Query Editor; SQL; cubes and Azure Machine Learning. I will also demo the tools I expect to be using soon as my projects propel me into the new world of Azure cloud and big data, of Spark and Hadoop. I hope to show "plus ça change, plus c'est la même chose" and that old friends such as R and SQL are also useful in this new world.
Speaker(s): Mark Wilcock,
Abstract:
Come round to talk about Application Lifecycle Management (ALM) and deployment/delivery of Business Intelligence (BI) Applications! You will learn how to manage and deploy a full stack BI solution with Team Foundation Server (TFS). I will share my view of end-to-end architecture of MS BI ALM and practical tips on how to make it happen with TFS toolkit, with specific examples for every MS BI project type. The presentation will also compare features of Release Manager and Octopus Deploy for your deployment needs will show a demo of continuous deployment for a typical BI project using TFS. The material does not assume prior knowledge of TFS administration, but some experience using Visual Studio database projects and general TFS terminology will be helpful.
Speaker(s): Dmytro Andriychenko,
Abstract:
There are tools available from Microsoft, as well as from a number of third party vendors, to ease the process of integrating database unit testing into your development environments and your continuous delivery pipeline. This session isn't about any of those tools, but is an attempt to get back to basics - with the open source tSQLt framework - and address questions such as Why is database unit testing difficult? What do I need to test? What do I not need to test? What does a "good" unit test look like? What tests should I be writing anwyay? This session will incorporate real-life experiences with tSQLt, as well as lessons that can be learned from other testing framworks and other programming languages.
Speaker(s): Gavin Campbell,
Abstract:
With the addition of R into SQL Server 2016, Microsoft have provided a few extra degrees of freedom for the standard SQL developer. You can now use the R language to wrangle, clean and collect external data, using libraries and functionality that simply wasn’t available to you before with regular T-SQL. Performing data enrichment at scale with SQL Server or even Microsoft R Server can provide extremely valuable new insights for your clients and start reaping the benefits of big data. In this session, Consolidata’s Oliver Frost shows you how to develop your own application for tapping into ‘dark data’. Ollie will demonstrate how to stream live tweets, perform aggregations in R and pipe the output to a Power BI dashboard, giving you a full end-to-end experience of the importance of learning some basic R code in 2016. This session is for anyone who is new to R and is interesting expanding their skill set beyond their comfort zone in SQL Server.
Speaker(s): Oliver Frost,
Abstract:
When building a report or dashboard in Power BI and using DirectQuery or Live connection it is important to take into account what will happen when reports are being adopted by the business and the audience grows. Working with IT there is nothing worse when the business starts complaining. During this session I will show you how to approach the situation when the business already started complaining, what the most common pains appear and where you should be looking before the performance starts degrading. We will be looking into measuring different timings, what is important when building reports, investigating logs and what options you have to this in a structured fashion.
Speaker(s): Bent Pedersen,
Abstract:
Let me show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed module dbatools. Afraid of PowerShell? Worried its too complicated? Don't want to go through the learning curve? Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday Want to restore an entire servers databases to the latest available point in time of the backups in just one line? Be useful to know the Last DBCC Check for your entire estate in only one line of code? Need to test your restores but its complicated? and many many more All this in a fast paced, fun session
Speaker(s): Rob Sewell,
Abstract:
The JavaScript Object Notation format, known simply as JSON, has now become a standard in data interchange between client-server applications, it is also used to store information in non-relational databases and the SQL Server 2016 engine handles it natively . However, today, not everyone has passed to the latest version of SQL Server, however, it is possible to process the JSON format even with earlier versions: in this session, it is confident with this format and illustrates the non-native mode that allows you to be ready in the moment of the upgrade to 2016 (or later) with a few simple moves. Finally, with a few simple examples, you will find some tips on how to use JSON in an advanced way with SQL Server 2016.
Speaker(s): Emanuele Zanchettin,
Abstract:
Does your application suffer from performance problems even though you followed best practices on schema design? Have you looked at your transaction log? There's no doubt about it, the transaction log is treated like a poor cousin. The poor thing does not receive much love. The transaction log, however, is a very essential and misunderstood part of your database. There will be a team of developers creating an absolutely awesome elegant design the likes of which have never been seen before, but the leave the transaction log using default settings. It's as if it doesn't matter, an afterthought, a relic of the platform architecture. In this session, you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices.
Speaker(s): Lord Richard Douglas,
Abstract:
In this session we will look at how IT Pros (and developers) *could* be completing their day to day tasks in a more efficient manner with effective Unit Testing and Source Control of their Scripts. This is a session where there will be chance to follow along (if you bring your own laptop) and learn in real time from the co-ordinator of the UK PowerShell User Groups - however you will also be lead to further community resources if you require further time after the session to get this built into your current day to day workflow. As this session will be focused towards SQL Professionals we will take a look at SQL Specifics that can be used within PowerShell Scripts Unit Testing.
Speaker(s): Ryan Yates,
Abstract:
For the last few years Microsoft have been promoting declarative, model-based database development with tools like SSDT. For many this is the way forward – gone are the days of managing endless upgrade scripts and manual deployments. At the same time, leaders and shakers of our industry including Jez Humble, Pramod Sadalge and Paul Stovell promote an iterative, migration script driven approach asserting that deployment scripts should be tested early and not generated by a tool. I'm irritated whenever I go to a “how to do database continuous delivery” session and the speaker presents one way as good and the other as bad. Like most things, it depends. I’ll illustrate the limitations of each approach with a simple scenario. I’ll describe which projects are better suited to a model or a migrations approach, and whether it’s possible to get the best of both worlds.
Speaker(s): Alex Yates,
Abstract:
Analysing highly connected data using SQL is hard! Relational databases were simply not designed to handle this, but graph databases were. Built from the ground up to understand interconnectivity, graph databases enable a flexible performant way to analyse relationships, and one has just landed in SQL Server 2017! SQL Server supports two new table types NODE and EDGE and a new function MATCH, which enables deeper exploration of the relationships in your data than ever before. In this session, we seek to explore, what is a graph database, why you should be interested, what query patterns does they solve and how does SQL Server compare with competitors. We will explore each of these based on real data shredded from IMDB.
Speaker(s): Terry McCann,
Abstract:
Do you spend your day running the same routine tasks? Does it irk you when you do the same thing more than once? I (sadly) still have to answer yes to one of those questions. However, whilst I do still carry out some of the same routine tasks, learning Powershell has enabled me to automate the majority. The potential for automation that Powershell brings, can have a huge impact on regaining precious time for a busy DBA. The ability to create a codebase of cmdlets that sits outside your SQL Server instances allows you to introduce easy frameworks for standardisation, inventory collection and access to external processes that would be clunky in SSIS or require using the dreaded xp_cmdshell. In this presentation, I’m going to demonstrate some of the features I use to make my life easier, from the basics of creating a Powershell profile and how different objects and inbuilt cmdlets work, to creating my own cmdlets and modules.
Speaker(s): Matthew Darwin,
Abstract:
Building robust and resilient Data Platform solutions can be complex and costly, building out for both High Availability and Disaster Recovery. The Always On technologies incorporated in the Microsoft SQL Server stack help Data Platform Engineers to do just this. Creating solutions that span multiple locations, in an effort to protect the data that we are tasked to manage on a daily basis. Together we will walk through the architecture patterns, technology requirements, and configuration options that you need to know in order to build a solid Data Platform. Understanding the implementation differences between on-premises and cloud based deployments is important. Especially as there are specific requirements that need to be met for up-time SLAs to be applicable, as well as mitigating for region failures. All of these elements mean that it is more than just simple wizards to follow in order to have a solid, reliable, and robust SQL Server Data Platform.
Speaker(s): John Martin,
Abstract:
This session covers the new features in SQL Server 2017 - apart from Linux support - Using Query Store for automatic tuning of querys which have bad plans (multiple plans with regressions) - Additional information stored in actual execution plans - New DMVs e.g. log information, statistics histograms - Interleaved Execution for multi-statement T-SQL TVFs - Adapative joins for queries - Resumable online index rebuild - Faster non-cluster index builds on memory optimized tables. - Additional in-memory SQL Surface Area e.g. Computed columns, JSON, CROSS APPLY,sp_spaceused,sp_rename,CASE,TOP N with TIES - Parallel Redo for memory optimized tables, increases throughput for Always On Availability Groups - DTC support for Always On Availability Groups - Cluster-less Availability Groups - Minimum Replica Commit Availability Groups - New CLR strict security - Graph database queries - Running Python scripts in SQL Server - BULK INSERT directly from CSV files
Speaker(s): David Williams,
Abstract:
The SQLOS scheduler has been a core feature of SQL Server ever since its appearance as the User Mode Scheduler in version 7.0. In this session you will learn what makes it tick, where lines of responsibility are drawn between schedulers, workers and tasks, and how everybody has their own selfish ideas about fairness. We'll pay particular attention to synchronisation: the need to synchronise, the balancing act between busy waiting and context switching, and examples of internal SQLOS synchronisation primitives. All of this will complement your existing mental model of SQL Server waits. It is a deep session, but not a broad one. As long as you have an interest in either SQL Server or operating system internals, no specific background knowledge is assumed - we will build from the ground up.
Speaker(s): Ewald Cress,
Abstract:
We believe if you are in a competitive market, the companies that have a DevOps culture will have the best chance of succeeding. But what is a DevOps Culture? DevOps is one of those terms that has transcended its initial use. You still see people talk about being DevOps Engineer or do DevOps for SQL, but you also hear about a company being a DevOps company, having a DevOps Culture. What does it all mean? In this talk we will discuss and probably argue what DevOps is and isn't. I'll put forward what we consider a DevOps culture, what are the core elements, who does what and importantly what breaks it. You will gain an understanding of why companies with such a culture can get solutions to market quicker and can respond to changes better than their competition.
Speaker(s): Simon Sabin,
Abstract:
Sponsor Session with Simon Whiteley and Terry McCann from Adatis. Technology changes quickly – patterns and approaches less so. As people move towards the cloud, there are clear benefits of adopting a distributed cloud architecture employing a range of disparate tools. This session will attempt to help you understand 5 of the key technologies underpinning the Modern Data Warehouse. We'll run through: - Data Lake (Store Analytics) - Azure SQL DataWarehouse - Logic Apps - Data Factory - Streaming Analytics We'll then briefly show you how they all fit together into a coherent reference pattern for performing data analytics in Azure. This session is aimed as a primer for people considering moving to the cloud or for anyone looking to understand the current data analytics architecture.
Speaker(s): Sponsor Session,
Abstract:
Sponsor Session with Neil Hambly from Data Movements. Would having a good understanding of all the different versions, editions, OS Builds, CPU Memory and database details in a single reporting place be useful? Many of my previous clients have found that just to be the case…. Well now you can too and it’s totally FREE · Come Discover what really exists in your environments Visualise valuable details about your SQL Servers [Do you even know about all of them] · Claim your FREE PowerBI SQL Server Estate Report Every Attendee can sign-up for their free report · Useful for Capacity Planning, Migrations, Consolidations and Licensing and more. · Extend the report to add additional reports and information In this session, we showcase a sample report, giving you a flavour of what we can report on. This is just the beginning of the journey, if you want to know more then ask us about our SQL Server BI Health-Checks that expand on these reports.
Speaker(s): Sponsor Session,
Abstract:
Sponsor Session with Ian Macdonald from Pyramid Analytics. We will show you how easy it is to collaborate, integrate, share and publish content on-premises or in the cloud, and to unlock insights that might otherwise be trapped on individual computers. We will discuss how by using BI Office and Power BI Desktop together, you get a governed, secure, enterprise platform that can demonstrate personal productivity gains. Come and see for yourself! Ian Macdonald - Principal Technologist, Pyramid Analytics Bio: A ‘hands-on’, product oriented technical marketing professional with extensive experience of the international software market. Primary focus has been on the database, development and query tools, data mining, business intelligence applications and IT infrastructure management solutions, setting product strategy, marketing, partnering and selling to senior positions within Fortune 2000 companies.
Speaker(s): Sponsor Session,
Abstract:
Have you heard about the SQL Tiger Team? Do you know they provide a free set of SQL scripts to help you administer your SQL Server? In this session we explore the scripts in Tiger Team Toolbox. Can't wait for the session? Download the scripts from here. https://github.com/Microsoft/tigertoolbox
Speaker(s): Mark Pryce-Maher,
Abstract:
Docker has come to windows, and also SQL Server is coming to Linux. Can you run SQL Server in Docker? Why would you? In this session I'll show you what Docker is, what you can use it for and what the use case is regarding SQL Server. I'm using SQL Server on Docker for Windows myself in test environments for instance, it turns out to be very usefull in Continuous Integration and database upgrade testing scenarios. We'll discuss production scenarios as well.
Speaker(s): André Kamman,
Abstract:
What does SUM(Salary) OVER (ORDER BY EmployeeID RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) do exactly? Did you know that you can delete all duplicates in a table with just one query? Window functions are great! They open a whole new world of elegant data analysis. Their only problem is that they seem complicated at first glance. In this session we will get OVER() them and see how can we use them together with aggregation, analytic and ranking functions. After this session creating queries with things like running totals will be a piece of cake!
Speaker(s): Dejan Dular,
Abstract:
As we have always seen a steady growth in SSRS since 2005, we now have much more advanced brand new features in 2016 SQL Server Reporting Services, beyond our imagination. Sit tight and buckle up for an amazing roller coaster ride, to not only briefly see the advanced SSRS killer features but also some of the R statistical charts within SSRS 2016 and the new user interface of Report Builder.
Speaker(s): Dr. Subramani Paramasivam,
Abstract:
Azure offers many great tools and services, but how to they fit together and what are your options when trying to architect an end to end Azure BI platform? We'll take a high level look at the available Azure services, discussing what their capabilities are and how they fit together. Covering Azure Data Factory, Data Lake, Table Storage, Blob Storage, U-SQL, HDInsight, SQL Data Warehouse, Machine Learning, Power BI, Event Hub, Stream Analytics and more.
Speaker(s): Alex Whittles,
Abstract:
Although Microsoft Azure and the concept of Cloud Computing has been around for a number of years it is still a mystery to many. This talk takes offers an introduction to Microsoft Azure and the many services it has to offer. We will then go onto look in depth at SQL Azure Database; creating, configuring, scaling, connecting, using, securing, monitoring, uploading, scheduling, high availability and DR.
Speaker(s): David Postlethwaite,
Abstract:
Session Details not available
Speaker(s): n/a n/a,
Abstract:
A few of you have heard of SQL Server Data Tools (SSDT), you may have started using it but not entirely sure where to start and you're being pushed to make sure it's "Agile", "DevOps", "CI/CD" etc etc. This is more of a beginners session on how I've gone about getting monolithic old databases into an Agile practice so you can hit the ground running should you require to do so.
Speaker(s): Craig Ottley-Thistlethwaite,
Abstract:
Sponsor Session with Aidan King from Profisee The presentation will cover Current MDS functionality Making MDS Enterprise Grade Applications of Enterprise Grade MDS
Speaker(s): Sponsor Session,
Abstract:
For a long time we've dreamed of full-functioned SSIS in the cloud. If you've wrestled with Data Factory, well... It's not quite there yet. Logic Apps fills a huge gap in the Azure story and if you've not tried it yet - you should. Logic Apps provides control-flow style functionality and can orchestrate data from a huge range of common sources. Want to scrape twitter, perform sentiment analysis and write to PowerBI? Its now possible with zero coding. This session will introduce Logic Apps how it fits into the Modern Azure Warehouse then demonstrate building a twitter scraper step by step.
Speaker(s): Simon Whiteley,
Abstract:
PowERBI goes Bananas I'm scared of visualisations and I wanted to fix it. This is a talk by an artistic dimwit who is quite good at data. With a Trello-based Kanban board* as my muse and PowerBI as my canvass, I built a series of progressively less bad visualisations until I felt like an artist. As with all art, you be the judge. Tags: Power BI, Data Viz, Data Visualisation
Speaker(s): Pete Moore,
Abstract:
Sponsor Session with Christian Bolton from COEO. In this session you'll learn what parallelism is and how it affects your servers and your queries as well as how to troubleshoot and optimise your queries for parallelism. The technical content is very accessible and aimed at beginner level.
Speaker(s): Sponsor Session,
Abstract:
Locks and latches have long been the mechanism used to implement SQL Server concurrency control, but with the introduction of In-Memory OLTP the paradigm has shifted. Are we really looking at the Brave New World of Transaction Processing or a dystopian nightmare? In this session, we will understand how In-Memory OLTP architecture is implemented and how its mechanics function. We will learn what transactional bad dependencies and other considerations are introduced by its use and what capabilities are provided by SQL Server 2016.
Speaker(s): Mark Broadbent,
Abstract:
Sponsor Session from Robert Walters. This will be an overview of the IT market and emerging recruitment salary trends within IT delivered by Robert Walters.
Speaker(s): Sponsor Session,
Abstract:
In this session we will take an in depth look at how query plans work. We will go under the covers and see what happens when you run that query. We will also take a look at various operators, how they work, why they are chosen and how to avoid them being used in the wrong place / context,. Attendees of this session will walk away with a greater understanding of query plans and the operators, which will enable them to both better interpret their query plans and also write more efficient SQL code
Speaker(s): David Morrison,
Abstract:
Sponsor Session from Microsoft.
Speaker(s): Sponsor Session,
Abstract:
This session will look at how PowerBI dashboard developers can use R to solve data import and data visualisation challenges. By the end of this session, you’ll know how you can use R to connect to more data sources, do sophisticated data transformation easily, avoid spatial data point limitations, and build custom graphics.
Speaker(s): Stephanie Locke,
Abstract:
During this session, we will examine how to put in the right level of security, evaluate and define an appropriate database security model that is right for the environment. We will be covering SQL Server’s security hierarchy and terminology, identify security risks (know your security responsibilities), determine when SA usage is appropriate and not and more.
Speaker(s): Neil Hambly,
Abstract:
In this talk we will discuss best practices around how to design and maintain an Azure SQL Data Warehouse for best throughput and query performance. We will look at distribution types, index considerations, execution plans, workload management and loading patterns. At the end of this talk you will understand the common pitfalls and be empowered to either construct a highly performant Azure SQL Data Warehouse or address performance issues in an existing deployment.
Speaker(s): Robin Lester,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://uk.linkedin.com/in/robsewellsqldba
Contact: http://sqldbawithabeard.com
Rob was once a production SQL Server DBA, but is now generally found automating the Data Platform and providing training for clients. He has a passion for PowerShell, Data, and DevOps. He is an MVP, an officer for the DevOps PowerShell VG, and has spoken and volunteered at many PowerShell and Data events. He is a member of the committee that organises Data In Devon and the European PowerShell Conference. He is a proud supporter of the Data and PowerShell communities. He relishes sharing and learning and can be found doing both via Twitter @sqldbawithbeard and his blog sqldbawithabeard.com. He spends most of his time looking at a screen and loves to solve problems.
LinkedIn: http://www.linkedin.com/in/simonsabin
Contact: http://sqlblogcasts.com/blogs/simons
Simon runs a Data Consultancy Sabin.io enabling companies to make the most of the data they have. He has worked with data for all his career and worked with companies across all industry sectors including online retail, insurance, finance, motor sport. He works with companies to help them 1. Improve their data development practices including implementation of devops, agile methodologies and continuous integration. 2. Understand and define a cloud data platform strategy. 3. Optimise their data platform, including performance, scalability, security and certification Education of people is at the heart of what Simon and his company sabin.io stand for. It is epitomised by SQLBits, which Simon founded in 2007.
LinkedIn: https://www.linkedin.com/in/lookatmydata/
Contact: https://lookatyourdata.org/databackwriter/
Data bloke. Keeps it simple. Gets it done.
LinkedIn: https://dk.linkedin.com/in/bentnissenpedersen
Contact: http://www.biblog.eu
Bent is a Data Platform MVP and working as Senior Business Analytics Architect at Kapacity A/S, where he have been working with enterprise customers on solutions with SSAS Tabular, SQL Server and in general Azure Data Platform services for the last years. During the past years, he concentrated on working with architecturing, devOps, Automation, testing and simplifying development processes for the Azure Data Platform.
LinkedIn: http://uk.linkedin.com/in/neilhambly
Contact: http://dataidol.com/NeilHambly
Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.
LinkedIn: http://uk.linkedin.com/in/alexanderyates
Contact: http://www.workingwithdevs.com
Alex Yates has been helping organisations to apply DevOps principles to relational database development and deployment since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins. A keen community member, he co-organises SQL Relay, is the founder of www.SpeakingMentors.com and has been recognised as a Microsoft Data Platform MVP since 2017.
Manchester SQL Server User group
Contact: http://www.kilasuit.org/blog
SharePoint amp; PowerShell Specialist - moving more into a dedicated PowerShell focus to help coach organisations in methods that they can use to improve their configuration management on a larger scale allowing them to deploy production ready code quicker, easier and with more confidence and importantly at scale in a repeatable manner. Co-Ordinator of the UK PowerShell User Groups - with groups in Manchester amp; London but with a view to expand this across the UK in 2016 - If interested in getting one going in your area then lets talk about it :-)
LinkedIn: https://www.linkedin.com/in/olliefrost
I currently work predominantly as a Data Engineer for Consolidata Ltd with side roles in Engagement, Marketing and Sales. My background is in Neuroscience and so I would like to cover cross-over topics in the future (machine learning, deep learning and developing algorithms). My tool set includes: SQL Server, R, Microsoft R Server and Azure. I have a good knowledge of other NoSQL technologies including Hadoop, Spark and Neo4j. I also have an unconventiona background - I am also a current world record holder for solving the 4x4x4 blindfolded Rubik'sCube blindfolded!
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.
Manchester SQL Server User group
LinkedIn: http://uk.linkedin.com/in/richardpdouglas
Contact: http://SQL.RichardDouglas.co.uk
Lord Richard Douglas is a Principal Solutions Engineer at SentryOne, where he specialises in the SQL Server product range. He has worked with SQL Server since version 7.0 in various developer and DBA roles and holds a number of Microsoft certifications. Richard is a keen member of the SQL Server community, having run a PASS Chapter in the UK and having served on the organizing committee for SQLRelay. Richard is on Twitter as @SQLRich.
LinkedIn: http://it.linkedin.com/pub/emanuele-zanchettin/18/921/34/
Emanuele Zanchettin, after studying in Computer Engineering, began his career with DB2 in the banking sector in 1998. After a few years and a change of scope of application, he encountered Access and Oracle with which he subsequently worked for several years in data access tuning and database design for new application features. Since 2007 he has also launched into the SQLServer world 2K, 2005, 2008* and 201* and more importantly, since 2011, into Azure SQL Database (SQL Azure). In order to have a greater capacity for assessment and familiarity with the various technologies that the market offers, he has deepened his knowledge to include MySQL and DocumentDB. Today Emanuele is mainly involved in IT projects and database management.
LinkedIn: http://www.linkedin.com/in/retracement
Contact: http://tenbulls.co.uk
Mark Broadbent is a Data Platform MVP and SQL Server MCM with more than 20 years of experience working with SQL Server and principal of SQLCloud, a consultancy specializing in concurrency control and highly available solutions. He is the founder of the UK's SQLSaturday Cambridge (its first and largest), SharePoint Saturday Cambridge, the Hybrid Virtual Chapter and the East Anglia SQL User Group.
Contact: http://tsqltidy.blogspot.com
Mark Pryce-Maher is an Azure SQL Data Warehouse Architect at Microsoft with lots of database /azure experience.
Manchester SQL Server User group
LinkedIn: https://www.linkedin.com/in/justdaveinfo?trk=nav_responsive_tab_profile
Contact: http://justdave.info
David is a cross product DBA (SQL Server, DB2, Oracle, Informix, Sybase) who has worked for 25 years as a DBA for both private, local/central government customers including a Fortune 50 investment bank. Certifications include MCSE 2014 Data Platform, MCTS SQL Server 2008 DBA and Developer as well as certifcations in other products. David has spoken at multiple SQL Saturdays as well as local usergroups and is a regular volunteer at events including SQLBits.
LinkedIn: https://www.linkedin.com/in/matthewdarwindba/
Contact: https://naturalselectiondba.wordpress.com/
Matthew Darwin is a Microsoft SQL Server Administrator working in the Manchester area of the UK. He began working with SQL Server in 2008 and since this time has gained significant experience in performance tuning, bulk operations, disaster recovery and automation, working in the private finance and retail sector. He has worked in both the development and database administration fields, and firmly believes that this well rounded background allows him to provide complete and performant solutions. When not working with SQL Server, he can be found playing the tenor saxophone, or in the mountains snowboarding.
Manchester SQL Server User group
LinkedIn: https://uk.linkedin.com/in/andriychenko
Contact: http://www.data-united.co.uk
Dmytro Andriychenko has over 10 years of SQL Server experience working as analyst, admin, developer and designer. Dmytro is a Microsoft Certified BI Expert with plenty of experience in all components of SQL Server in a variety of business settings (Betting, Banking, Legal, NHS and Bio-Pharma). His most recent focus is on BI architecture and delivery.
Contact: http://tsqlninja.wordpress.com
David is a senior BI consultant at Coeo. Having worked in some for of database development or another for around 14 years his areas of specialisation are sql server engine internals, tsql and query performance tuning. David has spoken at numerous conferences including several SQLBits and SQL Saturday events as well as user group meetings. He is a a confident speaker who uses humor and a down to earth approach to make even the most technical subject matters easily attainable and engagin
LinkedIn: http://uk.linkedin.com/in/dageop
Contact: http://www.yoursqlman.com/index.php/blogs
Dr.SubraMANI Paramasivam is a Microsoft MVP, PhD, Microsoft Certified Trainer and Head of Data AI at DAGEOP Ltd having 21 years of DB, BI, Analytics and AI experience. Mani has also spoken in various events like MS IGNITE, PASS Summit, MS Inspire, SQLBITS, Power Platform Summit, Global AI Bootcamp, Data BI Summit, SQLRelay, Power BI World Tour, Data Platform Summit, INSIDESQL UK, Global AI Nights, SQLServerGeeks Summit, MCT Global Summits, Data Day Events and various user group events. Mani also believes in Empowering Every Person in the planet and spreads the awareness on Global challenges via www.EmpoweringEveryPerson.com. He is also a co-owner of 1 Global AI Meetup and 3 Power BI PUG PASS local / user groups.
LinkedIn: https://uk.linkedin.com/pub/simon-whiteley/32/994/aa8
Contact: http://blogs.adatis.co.uk/blogs/simonwhiteley/
Simon Whiteley is the Director of Engineering for Advancing Analytics Ltd and a Microsoft Data Platform MVP. Simon is a seasoned solution architect and technical lead with well over a decade of Microsoft Analytics experience. A deep techie with a focus on emerging cloud technologies and applying "big data" thinking to traditional analytics problems, Simon also has a passion for bringing it back to the high level and making sense of the bigger picture. When not tinkering with tech, Simon is a death-dodging London cyclist, a sampler of craft beers, an avid chef, and a generally nerdy person.
LinkedIn: https://www.linkedin.com/in/mrpaulandrew
Contact: https://mrpaulandrew.com/
Paul Andrew is a principal consultant and architect, specializing in big data solutions on the Microsoft Azure cloud platform. Paul's data engineering competencies include Azure Data Factory, Data Lake, Databricks, Stream Analytics, Event Hub, IoT Hub, Functions, Automation, Logic Apps, and of course the complete SQL Server Business Intelligence stack. He has many years’ experience working within healthcare, retail, and gaming verticals, delivering analytics using industry leading methods and technical design patterns. Paul is a STEM ambassador and a very active member of the data platform community delivering training and technical sessions at conferences both nationally and internationally. He is a father, husband, swimmer, cyclist, r
LinkedIn: https://uk.linkedin.com/in/alexwhittles
Contact: http://www.PurpleFrogSystems.com/blog
Alex is a Data Platform MVP, and is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specializes in Data Warehouse modelling, ETL, Cubes, MDX amp; DAX. He#39;s a chartered engineer amp; has an MSc in Business Intelligence. He runs the Birmingham (UK) SQL Pass chapter amp; Azure user groups, and is on the SQLBits and SQL Relay committees in the UK. Alex is a regular speaker at global events including SQLBits, PASS Summit, SQL Relay, SQL Saturdays as well as numerous SQL Pass chapters around Europe
Manchester SQL Server User group
LinkedIn: https://www.linkedin.com/in/ewald-cress/
Contact: http://sqlonice.com
Ewald is a software developer with particular interest in SQLOS and SQL Server internals. He spends an unseemly amount of time engaged with x64 assembly language. In a previous life he earned his bread as a musician, but then discovered the joys of databases, regular working hours, and middle age.
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 SQL Saturday Holland.
LinkedIn: https://uk.linkedin.com/in/robin-lester-626b338
Contact: https://blogs.msdn.microsoft.com/robinlester/
I am a Cloud / Data Solutions Architect with Microsoft. Based in the UK and working closely with partners across the Azure data stack. I have been working with data systems since SQL 6.5 but now I focus the majority of my time on modern database warehousing, advanced analytics and IoT workloads.
LinkedIn: https://uk.linkedin.com/in/stephanielocke
Contact: https://itsalocke.com
Steph Locke leads a life of data, coffee, books and board games. During the day, Steph runs her own consultancy helping people start doing data science. Steph enjoys being her own gal as it means she gets to spend plenty of time building communities to provide platforms for people to help each other be better with data.
Manchester SQL Server User group
LinkedIn: https://www.linkedin.com/in/craigot
Contact: http://sql.limited/blog/
Craig has worked on small databases to petabyte data warehouses. Primarily focused on performance optimization and has an unhealthy obsession with the internals of database engines. Technologies include, SQL Server, Vertica, and VoltDB.
LinkedIn: http://uk.linkedin.com/in/gavincampbell
Contact: http://arapaima.uk
Gavin Campbell is a recovering Business Intelligence developer specialised in improving working practices in database delivery through the use of tools such as SQL Server Data Tools, tSQLt, Visual Studio Team Services, Git and Jenkins, on platforms such as AWS and Microsoft Azure, and methodologies such as Continuous Delivery and Agile.
LinkedIn: http://www.linkedin.com/in/dejandular
Dejan is an independent .NET and SQL developer. During his career he developed applications mainly in the area of Customer Management Systems and Supply Chain Management. In the last years he specialized as a back-end developer and data specialist. He is also a Microsoft Dynamics CRM expert. In his free time he is working with IoT and calls himself a DIY freak.
Manchester SQL Server User group
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.
LinkedIn: https://www.linkedin.com/in/zomalex
Contact: http://zomalex.co.uk
Mark is an independent consultant specializing in the analysis, reporting and visualization of financial data. Over the last 20 years, he worked on many systems to measure and monitor financial performance and manage market risks that arise from banking and trading activities. He is the organizer of the London Business Analytics Group, a popular community group that holds monthly talks on topics ranging from Predictive Analytics to Power Query to Personalized Medicine. He blogs at zomalex.co.uk
LinkedIn: http://www.linkedin.com/in/davidpostlethwaite
Contact: http://www.gethynellis.com/
David Postlethwaite has been a DBA for Liverpool Victoria in Bournemouth, England since 2008 He supports both Oracle and SQL Server from 2000 to 2017, DBMS, SSIS, SSAS and Reporting Services. In 2015 David built and deployed the company's first cloud solution using Microsoft Azure SQL Database and web services Before becoming a DBA David was a .NET developer and way back in history a Windows and Netware administrator. He is an occasional blogger on www.gethynellis.com David is a regular speaker for SQL Saturday. Most of his presentations can be found on his YouTube channel www.youtube.com/c/DavidPostlethwaiteSQL
The following is a list of sponsors that helped fund the event.


Id: 306
Name: Scary Terry
Status: Alive
Species: Humanoid
Type: Monster
Gender: Male
OriginName: Mr. Goldenfold's dream
OriginUrl: https://rickandmortyapi.com/api/location/18
LocationName: Mr. Goldenfold's dream
LocationUrl: https://rickandmortyapi.com/api/location/18
Image: https://rickandmortyapi.com/api/character/avatar/306.jpeg
Episode: ['https://rickandmortyapi.com/api/episode/2']
Url: https://rickandmortyapi.com/api/character/306
Created: 2018-01-05T14:13:01.564Z


|
| Local Properties | ||
| Managed Object Types | Data Object Types | All Properties | All Methods |
Properties
| Name | Type | Description |
|---|---|---|
| cloneName* | xsd:string |
Name for the cloned virtual machine, if the operation type is a clone
|
| cloneSpec* | VirtualMachineCloneSpec |
Specification for a virtual machine clone operation
|
| configSpec* | VirtualMachineConfigSpec |
Configuration information for the virtual machine.
For an intra-vCenter migration, this argument should be unset.
For a cross-vCenter migration, this argument is required.
In the latter case, the following elements of the configSpec
will be expected: version, cpuAllocation, memoryAllocation, numCPUs,
memoryMB, files, swapPlacement; in addition, the configSpec.deviceChange
should contain all the virtual disks of the virtual machine to be migrated.
If configSpec.deviceChange is empty, the vm will be treated as a
diskless vm.
If a storage profile is specified for a virtual disk or vm configuration,
only datastores that match this profile will be considered for that
virtual disk or vm configuration.
|
| datastores* | ManagedObjectReference[]
to a Datastore[] |
A list of compatible datastores for the virtual machine.
This list is ignored if relocateSpec.datastore is set.
For both intra-vCenter and cross-vCenter migrations, this list is required
if relocateSpec.datastore is unset.
If neither relocateSpec.datastore nor a list of compatible datastores are
specified, all datastores connected to hosts in the cluster will be
considered, in which case, the selected datastores in the PlacementResult
are not guaranteed to be compatible with the incoming virtual machine.
|
| disallowPrerequisiteMoves* | xsd:boolean |
Specification for whether to disable pre-requisite vmotions or storage
vmotions for virtual machine placement. The default value is true,
that is, to disallow such prerequisite moves.
|
| hosts* | ManagedObjectReference[]
to a HostSystem[] |
A list of compatible hosts for the virtual machine.
This list is ignored if relocateSpec.host is set.
For both intra-vCenter and cross-vCenter migrations, this list is required
if relocateSpec.host is unset.
If neither relocateSpec.host nor a list of compatible hosts are specified,
all hosts in the cluster will be considered, in which case, the selected
hosts in the PlacementResult are not guaranteed to be compatible with the
incoming virtual machine.
|
| key* | xsd:string |
Client generated identifier as a reference to the placement request
|
| placementType* | xsd:string |
Type of the placement. The set of possible values are described in
PlacementSpecPlacementType
|
| priority* | VirtualMachineMovePriority |
Priority of the migration operation.
The default value is defaultPriority.
|
| relocateSpec* | VirtualMachineRelocateSpec |
Specification for relocating a virtual machine.
Can be used to optionally specify a target host, a target datastore,
or a target resource pool. If a target host is specified, this host
becomes the recommended host; if a target datastore is specified,
this datastore becomes the recommended datastore; if no resource
pool is specified, the virtual machine will be attached to the
cluster root resource pool; if the target resource pool specified
is a VirtualApp, an InvalidArgument fault will be thrown.
If a storage profile is specified for a virtual disk or vm configuration,
only datastores that match this profile will be considered for that
virtual disk or vm configuration.
For cross-vCenter migration, the caller
should set the service and the folder arguments properly either in
the input relocateSpec or in the output relocateSpec in the placement
recommendation before passing the relocateSpec to the RelocateVM API.
|
| rules* | ClusterRuleInfo[] |
A list of rules to respect while placing the virtual machine on
target cluster.
If the list is empty, rules will not be considered during placement,
in case of cross-cluster placement within a VC and cross VC
placement across VCs.
|
| storagePods* | ManagedObjectReference[]
to a StoragePod[] |
A list of compatible datastore clusters for the virtual machine.
This list is ignored if relocateSpec.datastore is set.
For both intra-vCenter and cross-vCenter migrations, this list can be
empty, in which case, the user should set either RelocateSpec.datastore
or PlacementSpec.datastores as the target datastore or the list of
compatible datastores.
|
| vm* | ManagedObjectReference
to a VirtualMachine |
The virtual machine to be placed.
For an intra-vCenter migration, this argument is required.
For a cross-vCenter migration, this argument is optional,
and if this argument is unset, the caller is responsible for
applying the DRS-recommended placement to the correct vm.
|
| Properties inherited from DynamicData | ||
| None |
| Top of page | Local Properties | ||
| Managed Object Types | Data Object Types | All Properties | All Methods |


Connexion
Pricing
Quickly build an effective pricing table for your potential customers with this Bootstrap example. It's built with default Bootstrap components and utilities with little customization.
Free
$0 / mo
- 10 users included
- 2 GB of storage
- Email support
- Help center access
Pro
$15 / mo
- 20 users included
- 10 GB of storage
- Priority email support
- Help center access
Enterprise
$29 / mo
- 30 users included
- 15 GB of storage
- Phone and email support
- Help center access
Checkout form
Below is an example form built entirely with Bootstrap's form controls. Each required form group has a validation state that can be triggered by attempting to submit the form without completing it.
Your cart 3
-
$12
Product name
Brief description -
$8
Second product
Brief description -
$5
Third item
Brief description -
-$5
Promo code
EXAMPLECODE - Total (USD) $20


Schwab leads Turkish Open, Rose 2 shots behind
Antalya - Austria's Matthias Schwab birdied the final hole to claim a one-shot lead at the halfway stage of the Turkish Open on Friday, with Justin Rose only two strokes behind in his chase for a third straight title.
World number 104 Schwab is still waiting for a maiden European Tour title despite posting nine top-10 finishes this season.
He started his second round with an eagle and added four birdies on the back nine to round out a five-under-par 67 and reach 12-under for the tournament.
"I think I scored well today, I wasn't hitting it that well early on but I kept it together," Schwab said.
"I'll try and go through the same routines tomorrow morning, and then obviously still a long way to go."
Schwab leads by one from a group of four players -- Ross Fisher, former Masters champion Danny Willett, Belgian Thomas Detry and Ryder Cup winner Alex Noren.
Sweden's Noren appeared set to take the lead when he reached the par-five 18th on 12-under, but he hit a wayward second shot before three-putting to make an ugly closing bogey.
"If somebody said you get 11-under after two days, I'd take it," said Noren. "I just have to refocus and not think of what it could have been today, but that's how it is."
Rose is one further back after a second successive 67 as the Olympic champion bids to become only the fourth player after Nick Faldo, Ian Woosnam and Colin Montgomerie to win a regular European Tour event three years in a row.
"I put myself in position. The dream is alive, no doubt," said the 39-year-old Rose.
"To win a tournament I've probably been in worse positions than this.
"Last year I was in way worse shape after two rounds and just got it going on the weekend... If I can build from here, obviously that would be a great place to be."
The former world number one is among a five-strong group on 10-under, including Scotland's Robert MacIntyre, who fired a stunning 63 which featured nine birdies.
American Patrick Reed also moved into contention with five birdies and an eagle in his 65, and he was matched by Lee Westwood as the veteran Englishman joined him on eight-under.
"It's definitely something to build on... pretty sure I'd sign for a 65," said Reed, who was named as a captain's pick for the Presidents Cup by Tiger Woods, who also selected himself, earlier on Friday.

"To have Tiger as your captain, it's going to be special. It's going to be fun."
Leading and selected second-round scores from the European Tour's Turkish Open in Antalya on Friday (par 72/GBR & IRL unless stated):
132 - Matthias Schwab (AUT) 65-67
133 - Ross Fisher 69-64, Danny Willett 67-66, Thomas Detry (BEL) 67-66, Alex Noren (SWE) 66-67
134 - Robert MacIntyre 71-63, Justin Harding (RSA) 69-65, Jason Scrivener (AUS) 68-66, Justin Rose 67-67, David Lipsky (USA) 66-68
135 - Shubhankar Sharma (IND) 71-64, Aaron Rai 68-67, Scott Jamieson 67-68, Tom Lewis 65-70
136 - Patrick Reed (USA) 71-65, Lee Westwood 71-65, Romain Langasque (FRA) 70-66, Fabrizio Zanotti (PAR) 69-67, Edoardo Molinari (ITA) 68-68, Joachim B Hansen (DEN) 68-68, Jorge Campillo (ESP) 68-68, Tyrrell Hatton 68-68, Joost Luiten (NED) 67-69, Thomas Pieters (BEL) 66-70
Selected others:
137 - Shane Lowry 72-65
141 - Francesco Molinari (ITA) 71-70, Matt Wallace 74-67, Padraig Harrington 75-66
142 - Martin Kaymer (GER) 71-72, Eddie Pepperell 70-72
143 - Bernd Wiesberger (AUT) 71-72
144 - Li Haotong (CHN) 73-71


NONE
CRAWLED
CURATED
CURATED_AND_VERIFIED
NEEDS_RECURATION
ARCHIVED
Get Products
Next
Details
Please fill all the texts in the fields.
Name:
UserId:
Category:
Occassion:
Occassion:
LookingFor:
LookingFor:
Description:
GetAisles
ClearProducts


Buck Rogers to Earth five-hundred years later. Now were up in the big leagues getting' our turn at bat. The movie star the professor and Mary Ann here on Gilligans Isle. So get a witch's shawl on a broomstick you can crawl on. Were gonna pay a call on the Addams Family." The mate was a mighty sailin' man the Skipper brave and sure.
- 11 Comments
- 13 Likes
- 19 Viewers


{% extends "layout.html" %} {% block page_title %} GP Details {% endblock %} {% block content %} {% include "../includes/phase_banner_beta.html" %} Back Find your GP surgery Your GP surgery I can't find my GP surgery Save and come back later {% include "../includes/help.html" %} {% endblock %} {% block body_end %} {{ super() }} {% endblock %}
I can't find my GP surgery
Save and come back later


A way of representing things as collections of code with data and actions, including mechanisms for reusing code among related collections.
"Abstraction is the stripping away of details so that you can see the essence." (Douglas Hofstatder)
Creating an interface for your object model and abstracting the implementation of the actions of that model.
Can you explain the relationship between two objects "A" and "B" by: "A is a B" within the code structure provided in the language?
Literally: "many forms". The ability for a member of a collection to have different forms within the inheritance chain without changing the interface exposed outside the object.
JavaScript is a multi-paradigm language.
FYI, while undefined
is clearly not an object,
null
is: typeof null === "object"
Using the "curly brace" syntax (object literals)...
which is equivalent to...
this
inside an object method refers to the current context.
Context is typically the variable before the "." when called:
this === literalDog
inside speak()
Notice how our name
and speak
members are NOT in our prototype!
JavaScript is actually taking 3 distinct actions:
__proto__
property to point to Dog.prototype
;constructor
method on the new object.In fact, we can do these actions on our own:
Note that Object.create()
does not exist in IE < 9, but you can use a shim.
What about name
and speak
not being on the prototype?
We probably want them to be...
(That's pronounced "dunder proto", as in: "double underscore proto")
__proto__
has existed for a long time, and in ES6/ES2015 it is deprecated
public, private, privileged
Anything attached to the prototype
:
Anything on this
or a reference to the object instance:
And privileged methods
Variables declared inside a function
block only exist while that function's execution context exists.
If we want access to a private variable we have to create a "privileged" method...
Access to the alive
variable from isAlive()
and die()
is possible
because functions in JavaScript are closures.
If we want access to a private variable we have to create a "privileged" method...
Static members are set directly on our Dog constructor function.
Be careful when using static methods,
you cannot access the instance (this
) inside them!
We need to copy our properties and methods
from the mixin to the desired prototype...
Use a helper method!!
This looks nice, but it's just syntactic sugar!
In my opinion, this will just lead to more confusion...
There are plenty of good solutions out there...
Jordan Kasper


Daily Mail owner to buy i newspaper and website for £50m
Mail group sees opportunities for cost synergies
The owner of the Daily Mail newspaper on Friday said it would buy the “i” newspaper and website from JPI Media for a £49.6 million (€58.2 million) cash consideration.
The “i”, established as the cut-price national sister paper of The Independent in 2010, was bought by Johnston Press in 2016. The company was bought by bondholders last year after filing for bankruptcy protection, who formed JPI Media.
Daily Mail and General Trust (DMGT) said that while the deal to buy the “i” provided opportunities for cost synergies, the publication would retain its editorial independence and distinctive tone.
The Daily Mail newspaper targets an older, more conservative readership than the “i”.
“The i has a different editorial style and tone to the Mail and the audience has a different demographic. I want to make absolutely clear that we will ensure that the editorial independence of the i is preserved,” DMGT chief executive Paul Zwillenberg said in a statement.
“Its readers value its distinctive style and politically neutral approach and we are committed to maintaining that.”
The i sells around 170,000 copies each weekday, 190,000 copies of its Saturday edition and has around 300,000 daily browsers on its website, DMGT said, adding that it generated 11 million pounds in cash operating income last year.
The Daily Mail has a circulation of around 1.1 million, according to industry statistics, the second most-bought newspaper after The Sun. DMGT’s popular MailOnline online offering had 12.7 million daily unique browsers in the first half of this year. – Reuters


--- layout: default ---
Embrace your idea, no matter how abstract it is.
Define what you want to achieve, what is this for?
See the contrast between ideas.
Capture those important bits of information.
Recognize patterns of information.
Do not forget the context of your design.
Things will change and fail along the process, do not panic!
Analyze and synthesize information.
See the small and big stories behind.
Try different perspectives.
Expect the unexpected, and learn from it.
Do not get stuck on mistakes, follow them.
Do not underestimate the small details.
And remember, it is not only another project; the work is part of you.


TRLDefaultsManager
@objc public final class TRLDefaultsManager: NSObject
A wrapper for UserDefaults
This allows for eaiser handling of items into and out of NSUserDefaults with just a key and object been needed and we do the rest.
-
Initaliser to set up the key
Declaration
Swift
public init(withKey key: String)
Parameters
key
The string key for UD
-
Method to retrive an object from persistance storage
Throws
A Trolley.Error.nsudNilReturnValue if the object is nilDeclaration
Swift
public final func retrieveObject() throws -> Any
Return Value
The object for the key
-
Method to set the object
Declaration
Swift
public func set(_ object: Any)
Parameters
object
The object you wish to store
-
The method to remove objects for the key
Declaration
Swift
public func clear()


If you use jME3 together with the jMonkeyPlatform (recommended) then you benefit from the provided build script. Every new project comes with a default Ant script. The toolbar buttons and clean/build/run actions in the jMonkeyPlatform are already pre-configured.
The build script includes targets for the following tasks:
Usage on the command line:
ant clean ant jar ant run
Recommended Usage: Use the menu items or toolbar buttons in the jMonkeyPlatform to trigger clean, build, and run actions.
To see the build script and the predefined tasks
build.xml
listed.build.xml
to see how the jme3-specify build targets were defined. You typically do not need to edit the existing ones, but you can.build.xml
to see all targets.nbproject/build-impl.xml
opens. It contains very generic targets that you typically will never need to edit. Note that build.xml
includes build-impl.xml
!The build script is a non-proprietary Apache Ant script. It will work out-of-the-box, but if necessary, you can extend and customize it.
Read the comments in build.xml
, they explain how to override targets, or extend them, to customize the build process without breaking the existing functionality.


{{message}}
| Cliente | Data check-in | Data check-out | R$ Cliente | R$ Programa |
|---|---|---|---|---|
| {{entry.nome}} | {{entry.data_checkin | date:'dd/MM/yyyy'}} | {{entry.data_checkout | date:'dd/MM/yyyy'}} | {{entry.pontos | currency:'' | brazilianCurrency}} | {{entry.pontos * 2 | currency:'' | brazilianCurrency}} |
| Total | {{total | currency:'' | brazilianCurrency}} | {{total * 2 | currency:'' | brazilianCurrency}} |


The BioExcel Cloud Portal has been developed by the Software Development and Operations team at EMBL-EBI to simplify the experience for researchers when running their workloads across different cloud providers.
The portal enables cloud providers and research teams to package and share their BioExcel applications and environments with their respective users. That way, these key applications can be deployed on demand onto the cloud providers the user is able to access.
The BioExcel Cloud Portal is offered as a service to ELIXIR and other communities. Users will need a freely available ELIXIR identity to access the portal.
Obtain your ELIXIR identity here.
Access to the portal does not provide access to any cloud providers but is compatible with the work within the ELIXIR Compute Platform. Users will need to provide their own credentials to access cloud providers such as OpenStack, Google Compute Engine or Amazon Web Services.
Research groups can use the portal to share appliances and cloud credentials within their teams through the portal if they desire.
Further information on the design and documentation on how to use and contribute appliances to the portal is available. Any questions around the BioExcel Cloud Portal and its use can be sent to ecp[at]ebi.ac.uk.
The portal has been developed under funding provided by the following projects and organisations:
EC funded BioExcel project.
EMBL-EBI (European Molecular Biology Laboratory - European Bioinformatics Institute).
Cancer Research UK funding to develop infrastructure to support the PanCancer collaboration.
EC funded PhenomMeNal project.


Biden said we need to 'keep punching at' domestic violence, and the internet was not amused
by Michelle Mark- Former Vice President Joe Biden was derided online after using an unfortunate choice of words to condemn domestic violence.
- In response to a question about addressing sexual violence, Biden said people needed to "keep punching at it and punching at it and punching at it."
- Biden also noted in his answer that he had written legislation addressing violence against women.
- Visit Business Insider's homepage for more stories.
Former Vice President Joe Biden made a clumsy attempt Wednesday at condemning domestic violence, vowing to "keep punching at it and punching at it and punching at it" as the audience at the Democratic presidential debate stifled laughter.
Biden was asked during the evening's debate about how to address sexual violence, and he immediately mentioned that he created legislation addressing violence against women, known as the Violence Against Women Act.
But then he quickly veered into a tangent about combatting domestic violence.
"No man has a right to raise a hand to a woman in anger, other than in self-defense, and that's rarely ever occurred," he said. "And so we have to just change the culture. Period. And keep punching at it and punching at it and punching at it. It's a gigantic issue."
The audience could be heard laughing during his remarks.
The gaffe quickly sparked mockery and derision online, with Twitter users criticizing Biden's unfortunate choice of words.
Wednesday marked the fifth round of Democratic presidential debates; it was hosted by MSNBC and The Washington Post.


WITNESS LIST Nominations Committee February 24, 1997-2:00P Commissioner of Insurance For: Elton Bomer (himself), Montalba Public Insurance Counsel For: Roderick Bordelon (himself), Austin Public Utility Counsel For: Suzi McClellan (herself), Austin Texas Parks and Wildlife Commission For: Carol Dinkins (herself), Houston Ernest Angelo Jr. (himself), Midland John Avila Jr. (himself), Fort Worth


AoiYamada
<EMAIL_ADDRESS>Register
Others
Logout
Chat-Room
Register
Logout
menu
add
Welcome to the chat room!
textsms
Message:
attach_file
Send
mode_edit
insert_chart
format_quote
publish
attach_file


Features List
This is an accumulated list of the features we put thought into designing and implementing
User Management
User Signup Flow
- Two well-placed registration forms make it easier and more likely for users to sign up
- A registration form on the bottom of the front page
- A registration form accessible from a "REGISTER" button in the navbar
- Additionally, Sign In form has a link nearby to Sign Up and vice versa
Account Lockout
- Users are locked out after 3 unsuccessful attempts
- Super Admins see a special version of the USERS page which allows them to unlock accounts
User Roles
- Super Admin - Can perform all actions on the site regardless of sale
- Admin - Can perform all actions on that sale
- Seller - Can update the catalog, view financial records, create transactions, and view and print tags of that sale
- Bookkeeper - Can view financial records of that sale
- Cashier - Can create transactions of that sale
- Clerk - Can view and print tags of that sale
- Guest - Can view all open sales
Managing Users in a Sale
- Admins can assign users a role on a sale
- Users are by default guests unless they are added by an Admin
- Admins can revoke roles assigned to users
Inventory Management
Tag printing
- Print a tag for an individual item
- Print all tags for a sale
- CSS creates proper page breaks when printing tags
Transaction/Financial Management
QR Code Checkout System
- A mobile device can be used to scan items in a transaction
- Fully tested with all of the top iOS QR apps, leading to the recommendation of Scanbot
- This works without requiring typing any passwords on the device
- The mobile device authenticates itself by scanning a QR code on the transaction page
Financial Report
- A copy of relevant item data is stored with the transaction so that modifying or deleting an item does not affect the financial report
- Sellers can view a financial report split up by sellers
- Sellers can view a financial report that displays only their items that were sold
Security
- Cookies are implemented using Java Play's session feature
- Authorization checks are done on page requests to verify the user has permission to perform an action or view a page
- Passwords are hashed using Whirlpool hashing algorithm
- Website is served over https connection with grade A+ on ssllabs.com
Overall Design
- Utilized Bootstrap for buttons, navbar, tables, and general layout
- Developed custom CSS code
- Implemented asynchronous loading of page content with Javascript in several instances, such as search queries
- Custom 404 Not Found error page
- Custom message when sales list is empty or query returns no results
Other Features
- Website utilizes MySQL database
- Website and Database are bundled into Centos 7 Linux virtual machine
- Help page guides new users through using the website
- Image uploads are integrated into the native application without using an external API
- An instance of the virtual machine can work without being connected to the Internet, meaning a sale could be run on an isolated network where there is no Internet access
- IPv6 access is configured on the hosted version of the site
}


Landing Page
Special Projects
This story is part of a series of specially designed stories that represents some of the best journalism The Post has to offer. Check out the rest of the special projects here.
Abigail Dean | FOR THE POST
Freshman Alyssa Embry and her brother, Undergraduate Alumnus and Graduate student Brendon Embry stand together on College Green. Their parents also graduated from Ohio University.
10.05.17
Courtney Gibson has a long family history at Ohio University. Multiple generations on both sides of her family attended OU, including her grandmother, who was a school nurse.
“When she died of cancer, the university planted a tree in my grandma’s honor,” Gibson, a freshman studying psychology, said.
This weekend, alumni will come to Athens and see the places where they share so many memories. For some, they will be visiting other family members who are new Bobcats — sharing memories, going to their favorite food places and giving them advice to help make their adventure at OU one to remember.
Both Gibson’s parents attended OU for their undergraduate degrees. Her mother studied business; her father studied history. Her decision to attend OU was partially influenced by her ties to Athens.
“It certainly made it easier to adjust and move in,” Gibson said. “At first, it did make me want to go elsewhere.”
Now, she’s completely happy with her decision. Gibson added her parents shared the same excitement for her. Like many other parents, Gibson’s will visit the campus for Homecoming weekend, where they’ll recap memories from their time in Athens.
Aidan Crowl, a sophomore studying electrical engineering, said his parents attended OU to obtain their graduate degrees, but his grandparents also have links to the university.
“My grandparents both taught at (OU) in the English department, so my family’s connection to Athens was already much deeper than my parents attending school here,” Crowl said.
Crowl said he was unsure about attending OU because of his family’s background in Athens, but he does not regret his decision to remain in Athens.
“I kind of wanted to get away,” he said. “But I will say, having been here for a year, it’s been really great being this close to my family for a lot of different reasons.”
His parents and grandparents both still reside in the area and said they will be around for homecoming weekend, a festivity Crowl recalled attending with his family in past years.
“When I was younger, my dad would always put me on the back of his bike for the Homecoming parade, and we would follow the Marching 110,” he said.
Alyssa Embry, a freshman studying production design and technology, said her mother, father and brother, all attended OU, specifically, the Scripps College of Communication. Originally, Embry did not want to attend OU because she did not want to seem like she was following “the family trend.”
“(My mom and I) purposefully kept my dad out of the loop of what schools I was leaning towards so I wasn’t met with extreme bias towards OU,” she said in an email. “Yet, when I did decide, we gave my dad a shirt that said ‘Proud OU Dad’ and pinned a ‘x2’ onto it. Before it could fully sink in, I came out decked out in all my lovely OU gear to which he responded with lots of hugs and lots of tears.”
Her family will be one of the many people coming back to Athens for Homecoming because it is her parent’s favorite place to visit.
“It’s their fifth year and counting,” she said in an email. “However, this year may be the most exciting because they won sideline tickets to the football game.”
Just like her parents, Embry has grown to love OU and knows it was the right decision to attend.
“No other campus felt like home and I knew everyone in my family was happiest in Athens,” she said in an email. “I tried to kid myself that I liked other schools and their programs, but deep down I knew all along (it was) OU.”
Landing Page
This story is part of a series of specially designed stories that represents some of the best journalism The Post has to offer. Check out the rest of the special projects here.


-
Introducing Tweet-a-Program—Stephen Wolfram Blog
blog.wolfram.com
Compose a tweet-length Wolfram Language program. Tweet it to @WolframTaP. Our Twitter bot will run it in the Wolfram Cloud and tweet back the result.
-
Apple - Privacy - Government Information Requests
www.apple.com
Our commitment to customer privacy doesn’t stop because of a government information request.
-
Flight: Twitter's Mobile Developer Conference
www.twitterflight.com
Flight is a gathering built by developers, for developers. You'll be right at home if you live, breathe and occasionally dream in Java, Objective-C, ...
-
The Case For Intelligent Failure To Invent The Future | TechCrunch
techcrunch.com
The world is changing at an increasingly rapid pace. In the past, experts with spreadsheets and econometric models or social scientists with subscale ...
-
Cash – Send Money for Free
itunes.apple.com
Get Cash – Send Money for Free on the App Store. See screenshots and ratings, and read customer reviews.
-
M6.0 - 6km NW of American Canyon, California (BETA) 2014-08-24 10:20:44 UTC
comcat.cr.usgs.gov
USGS Earthquake Hazards Program, responsible for monitoring, reporting, and researching earthquakes and earthquake hazards
-
The Woman Who Walked 10,000 Miles (No Exaggeration) in Three Years
www.nytimes.com
For Sarah Marquis, a very long hike – from Siberia through the Gobi Desert, China and eventually Australia – can become a voyage of discovery.
-
Ferguson Police Chief Offers Apology to Michael Brown’s Family
www.nytimes.com
In an online video, Thomas Jackson, the police chief of Ferguson, Mo., said he was sorry for the loss of their son and regretted that it took ...
-
Michelin Guide Announces NYC's Inexplicable 2015 Bib Gourmands - Eater NY
ny.eater.com
The Michelin Guide has just released its "Bib Gourmand" picks for the forthcoming 2015 edition of its New York City dining guide. These are the ...
-
Shellshock DHCP RCE Proof of Concept -
www.trustedsec.com
DHCP bash shellshock POC: 1) Just about any DHCP string value should work for the exploit. Value 114 is URL, which is a string and should be reliable ...
-
An Insanely Detailed, Hand-Drawn Map of San Francisco
www.citylab.com
It took illustrator Jenni Sparks three months to finish this secret-laden cartography.
-
India Reaches Mars With Low-Cost Mission
newswatch.nationalgeographic.com
India's new entrant into orbit around Mars, the Mars Orbiter Mission (MOM), is a triumph for its space agency and represents the fourth country to ...
-
@Large: Ai Weiwei takes over Alcatraz with Lego carpets and a hippie dragon
www.theguardian.com
The big man of Beijing’s new show fills the former prison with a giant rainbow dragon and Lego models of 175 prisoners of conscience, from Nelson ...
-
The Rise of the Hacker Bounty Hunter
nymag.com
Symbiotically capitalizing on tech companies’ soft spots.
-
oss-sec: Re: CVE-2014-6271: remote code execution through bash
seclists.org
oss-sec mailing list archives
-
iOS8 MAC Randomization – Analyzed! - MOJO Wireless
blog.airtightnetworks.com
Investigation into the workings of randomized MACs addresses. Read on to find out how they work in iOS8 on iPhone 5 and 5s. iPhone 6 testing pending.
-
Blackphone’s Bug Bounty Program | Blackphone Blog
blog.blackphone.ch
Today we moved another step towards building a strong relationship with the security researcher community by announcing our bug bounty program . The ...
-
Make Dinner: A Home Cooking Manifesto - NYTimes.com
www.nytimes.com
Just cook. That is the message of the moment, the act to embrace. Just cook dinner. It is a habit as easy to form as a bad one, and more beneficial ...
-
On a Warmer Planet, Which Cities Will Be Safest?
www.nytimes.com
Scientists trying to predict the consequences of climate change see few havens from future storms, floods and droughts. But some regions will fare ...
-
Microsoft Starts Online Services Bug Bounty
threatpost.com
Microsoft today launched the Microsoft Online Services Bug Bounty Program which will pay out a minimum of $500 for vulnerabilities found in its cloud ...
-
Latest News: Climate Change Marches, Hong Kong Boycott, iPhone Orders
www.nytimes.com
Here’s what you need to know to start your day.
-
Too Young to Die, Too Old to Worry
www.nytimes.com
At some point, you have to start indulging in the pleasures of the present.
-
The Paleo Lifestyle: The Way, Way, Way Back - NYTimes.com
www.nytimes.com
Which is more primal, hard cider or a strawberry margarita?
-
Paris Falls Out of Love With the Padlocks on Its Bridges
www.nytimes.com
Thick glass, with nothing to hitch a lock to, has begun replacing the panels where thousands have symbolized everlasting devotion by fastening ...
-
Taking a Call for Climate Change to the Streets
www.nytimes.com
The People’s Climate March in Manhattan was a spectacle even for a city known for doing things big, and it was joined, in solidarity, by ...
-
Keeping the Government Out of Your Smartphone
www.aclu.org
Smartphones can be a cop's best friend. They are packed with private information like emails, text messages, photos, and calling history. ...
-
Apple Throws Down Privacy Gauntlet
www.aclu.org
Apple made big news today by announcing that they are no longer able to extract data from iOS devices for law enforcement agencies. The company had, ...


This is dangerous because it casts too wide a net; it can catch things like OutOfMemoryError.
This rule is deprecated, use {rule:squid:S1181} instead.


This is a beautiful video about animals and their habitats.
Some animals stay with us forever and depend on us for lifelong care because they are no longer able to fend for themselves. By adopting one or more of the permanent members of our family, you can help us keep them healthy, happy and safe and support our work rescuing and rehabilitating other animals too. In return, you’ll become a special friend to an animal in need. The pack is a small 'thank you' for your support. It also serves as a proud reminder of the animal you are helping to care for, with a photo for display, a fact sheet and exclusive updates on your chosen animal's progress. We have two pack options - an online printable option and a postal option.


|
BezoarsBezoars are masses found within the gastro-intestinal tract of humans and animals, which form over time from foreign bodies (such as swallowed hair or or cellulose) that lodge in the tract and build up over time. Normally the story would stop there (and it would be a nasty short story, indeed) were it not for the strange superstitions that have arisen around them.
 Phytobezoars come from compressed vegetable matter, such as leaves or undigested foods. Pharmacobezoars are from compacted amounts of undigested drugs. And Trichobezoars are composed of hair, usually by people who chew hair constantly, from either a mental defect or a really bad habit. The term "bezoar" derives from the arabic word badzehr, which means antidote.... which is what you need if your bezoar becomes too large; some patients have been found with bezoars that filled their entire stomachs, while others were able to lose them with ingestion of cellulase enzyme or some other medical trickery. Surgery or tubes down the throat are the usual methods these days, however. For at least a thousand years, Bezoars have built up a reputation as being talismans of luck, power, or health. Bezoars were used as antidotes to some poisons (explaining their name) or were sometimes kept as lucky talismans to ward off the evil spirits.


Shiori uses Bootstrap for styling. Here’s how fundamental HTML elements are displayed on Shiori. To learn more, check out Bootstrap’s documentation.
Do not use h1
tags, which is reserved for the post title. Use h2
tags mostly, and use h3
if you need subheadings.
This is a regular paragraph. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Aenean eu leo quam. Pellentesque ornare sem lacinia quam venenatis vestibulum.
Links look like this. Emphasis. Marked. Deleted. Code
. user-input.
This is a blockquote. Morbi leo risus, porta ac consectetur ac, vestibulum at eros. Sed posuere consectetur est at lobortis.
In Shiori, you don’t need to add the Bootstrap .table
class to table
. It just works.
| First Name | Last Name | Username |
|---|---|---|
| Elle | Kasai | @ellekasai |
Images have round corners and are responsive by default.
Continue onto Shiori by Example: Helpful Bootstrap Components to learn more.


Proximity allows you to import data from other databases using a three-step process:
Export the data to the specified tabular format.
Convert the data to the Proximity XML import format.
Import the XML data into Proximity.
See
$PROX_HOME/doc/user/text2xml/text2xml.txt
for a
specification of the required file format and instructions for using
the text2xml.pl
script to transform tabular data to
the Proximity XML import format.
To import XML data into Proximity, follow the procedure described in Exercise 3.1 to create and initialize the MonetDB database and import the data.


⣿
?°
unknown
day, month ?
city, country
day
?°
day
?°
day
?°
day
?°
temps
City
Language
API Key
You need a free api key from
openweathermap.
Temperature scale
°C
°F
Show weather in menu bar
Start at login
Time format
24h
12h
Apply
Quit
This application uses
Sciter Engine
,
©
Terra Informatica Software, Inc.


Transfergates, Buffers, Inverters, and WiredX
| Name | Description |
|---|---|
| NXFERGATE | Transfergate with enable active high |
| NRXFERGATE | Transfergate with enable active high. Output strength reduced. |
| PXFERGATE | Transfergate with enable active low |
| PRXFERGATE | Transfergate with enable active low. Output strength reduced. |
| BUF3S | Tristate buffer with enable active high |
| BUF3SL | Tristate buffer with enable active low |
| INV3S | Tristate Inverter with enable active high |
| INV3SL | Tristate inverter with enable active low |
| WiredX | Wired node with multiple input and one output |


Vancouver police say fireworks may be linked to destructive apartment fire
VANCOUVER - A blaze that injured one man and extensively damaged a south Vancouver apartment building is now considered suspicious.
Vancouver police Sgt. Steve Addison says detectives believe the blaze that started early Tuesday morning was sparked outside the apartment in the Marpole neighbourhood, then spread to the three-storey building.
He says witnesses report hearing fireworks and seeing a group of people walking away at the time of the blaze.
Firefighters rescued numerous residents from balconies, while two others, including a 33-year-old unconscious man, had to be pulled to safety from a smoke-filled hallway.
Addison says that man is recovering from serious injuries.
Police are now appealing for witnesses, video or any other evidence that can help the investigation.
 We're asking them to do the right thing and come forward," Addison says in a statement.
The fire destroyed or significantly damaged many of the suites in the 24-unit building, and endangered dozens of people, he says.
This report by The Canadian Press was first published Nov. 20, 2019


An essay/argument for Sir Isaac Newton and the author’s mathematical beliefs and philosophies. The full title is "A Defence of Free-Thinking in Mathematics: In answer To a Pamphlet of Philalethes Cantabrigiensis, intitled, Geometry no Friend to Infidelity, or a Defence of Sir ISAAC NEWTON, and the BRITISH Mathematicians. Also an Appendix concerning Mr. WALTON’s Vindication of the Principles of Fluxions contained in the ANALYST."
The life, theories, and discoveries of mathematician Leonhard Euler.
Flatland: A Romance of Many Dimensions is a classic 19th century novella that satirizes the social hierarchy of Victorian society using mathematical figures and ideas.
Lewis Carroll's Game of Logic is a way to understand classical logic by means of symbols.
"The Three Fundamental Laws of Thought. (1) The Law of Identity-- Whatever is, is; or, in a more precise form, Every A is A. (2) The Law of Contradiction-- Nothing can both be and not be; Nothing can be A and not A. (3) The Law of Excluded Middle-- Everything must either be or not be; Everything is either A or not A."
In this treatise, English thinker George William Joseph Stock explains deductive logic.
The Number Concept is an examination of the different cultural representations of numbers by the American mathematician Levi Leonard Conant, Ph.D.
Symbollic Logic is a text discussing the area of mathematics which studies the purely formal properties of strings of symbols.
History of Modern Mathematics is a comprehensive guide to different theories and strategies of mathematics ranging from Theory of Numbers, Theory of Equations, Complex Numbers, Calculus, Analytical Geometry, and others.
This book contains selections from A Short Account of the History of Mathematics, first published in 1908. A Short Account of the History of Mathematics is a classic and essential text in the history of math. It covers all of the major historical periods in the development of mathematics to the end of the 19th century, and it includes biographies of key figures in the field.
Philosophy and Fun of Algebra is meant for young readers as an introduction to the basics of algebra and logic. Her style is humorous, easy to read, and conversational.
Logic: Deductive and Inductive is a math treatise by the British logician and mathematician Carveth Read.
Lectures on Ten British Mathematicians is a collection of biographies about famous mathematicians from the 19th century.
Counting games are common among children in many cultures. This book collects many traditional counting rhymes and other verses that relate to basic numeracy.
A poem about Newton proving the law of gravity.
A child's nursery rhyme teaching counting.
A child's nursery rhyme teaching counting.
A child’s counting game.
A child's counting-out game.
A counting poem.
A child’s rhyme identifying the number “1”.
A child's counting-out game.
A funny limerick about the frustration of mathematics.
A child's nursery rhyme teaching counting.
A nursery rhyme that incorporates the days of the week.
A child’s subtraction rhyme.
A counting rhyme about indians.
A child's nursery rhyme dealing with time.
A bilingual counting rhyme in English and Spanish.
A traditional poem/song about Christmas.
A child's nursery rhyme about animals featuring the number three.
A nursery rhyme about pigs.
A nursery rhyme involving counting.
A children’s poem usually counted on toes.
A child's nursery rhyme teaching counting: similar to "This Little Piggy."
A fun limerick to learn how many days are in each month.
A nursery rhyme about the days of the week.
A child’s nursery rhyme involving numbers and counting
A children’s counting poem about elephants.
A child’s counting rhyme about addition.
A child’s subtraction nursery rhyme.
A child's nursery rhyme teaching telling time.
A child’s counting nursery rhyme.
A child's nursery rhyme teaching time.
A child's counting rhyme involving a sheep.
A child’s riddle involving multiplication and logic.
A child's nursery rhyme teaching counting.
A child’s counting poem about goldfish.
A child’s addition nursery rhyme
A child’s poem about subtraction.
A child's counting rhyme involving ducks.

A child’s nursery rhyme involving numbers and counting
A child’s subtraction poem.
A children’s subtraction poem about chickadees.
A child’s nursery rhyme involving multiplication.


| ID | Requirements | Priority | State | Contributors |
|---|---|---|---|---|
| 1 | The ability to ask a chatbot questions about projects and have it return a list that matches the
user’s criteria:
|
Must | ✓ | Adnan |
| 2 | A database of project data that the user can search through | Must | ✓ | Rajesh |
| 3 | A means of pushing and updating projects to the database through an administrator program | Must | ✓ | Adnan |
| 4 | Projects returned by the chatbot that display information on:
|
Must | ✓ | Adnan |
| 5 | LUIS integration so that the chatbot analyses human speech, rather than specific words and commands. | Must | ✓ | Adnan/Rajesh |
| 6 | A parser for IXN forms so that users can fill out a document and upload them, rather than fill out a form. | Must | ✓ | Adnan |
| 7 | Ability for local storage of database so academic institutes can host it for their own projects | Should | ✓ | |
| 8 | National database linking all databases together | Should | ✓ | Rajesh |
| 9 | Display information in Microsoft Adaptive Card format to make it easy to read | Should | ✓ | Adnan |
| 10 | Prompted responses on the card so that the user can intuitively click through as well as send messages | Should | ✓ | Adnan |
| 11 | Provide a summary on project partners including:
|
Could | ✓ | Adnan |
| 12 | Store information on contract and NDA information and its progress. This includes:
|
Could | ✓ | Adnan | 13 | Visualisation of the progress of contracts and NDA as they are completed | Could | ✓ | Adnan |
| 14 | Projects from academic institutions can be inserted with additional data, including:
|
Could | ✓ | Adnan |
| 15 | Add images to the cards related to the project and organisation to prevent a block of text being presented to the user e.g. Company Logos | Could | ✓ | Adnan |
| Key functionalities (must have and should have) | 100% | |||
| Optional functionalities | 100% |
1 - Project should be searched for based off of 4 different criteria, individuals leading, skills and devices used, keywords, and location. Searching for organisations. Able to return all projects by any given organisation as long as there are any that exist in the database. Able to search for devices used if any project exists that used a given device. Able to search via keywords if any projects contain the given keywords mentioned anywhere (description/title for example). Able to find projects based off of location if it is mentioned in the address. The search function is aided by LUIS which identifies what the user is searching for and the keywords that need to be passed to the query. The relevant data can be sent to the query which matches the intent most closely and searches for matching projects.
2 - A database containing projects which have been submitted using the provided IXN miner, this database contains all the information that we could collect from IXN forms and is hosted on azure. This database is then queried through the chatbot and information can be retrieved and viewed through dialogues or adaptive cards.
3 - We were first able to push and updated projects to the database using CLI prompts, following user feedback, we were able to create an administrator panel which allowed for easier pushing and updating of projects. This was created using a tkinter GUI. The panel allows for selection of the IXN form from the users local storage, there are a variety of text boxes and prompts to allow the user to add additional information about the project and is all pushed to one of the four databases.
4 - Firstly we display the description and full project title, secondly the contact details, thirdly where the project is located, and fourth the skills, data and devices required for the project. Each time we search for the project, we create an instance of the project to store the information about it. When it is first loaded, it only stores the relevant amount of detail until it is selected. A method is called which then calls a search query and gathers the relevant information needed to display it to the user. It goes on to display said information. An adaptive card is produced to display the relevant information in a friendly way.
5 - We were able to integrate LUIS in order to better determine the intent of the messages received by the chatbot. This allows a more dynamic feel to the chatbot which is much more usable as it doesn't rely on needing a detailed script in order to acquire information from the chatbot. We are able to further train our app so that it encompasses an even greater array of messages and more accurately determine what the best intent is for the users message so that they can receive the most accurate and relevant information.
6 - The admin panel provides a means of uploading the forms and parses the forms so that they can be uploaded. However it does reject files which are in the incorrect format. There is an OOP approach for the panel. As IXN forms are tables, we parse the docx file by using the xml behind it, we care able to retrieve a list of the data. We are able to use fuzzy string matching to map the fields of the form to our own schema (using a library called fuzzywuzzy). We also match conflicts using a method which finds the best match and also another method that checks for duplication and selects the best matching field.
7 - Local storage is possible by connecting to the database using the supplied credentials and downloading it from within MySQL Workbench, this provides a SQL dumps file which can then be executed in order to host the database anywhere else, even locally if desired.
8 - The national database is the main projects database, we have supplied credentials which trusted individuals can use to store project data on, this will then act as the national database for the entire UK.
9 - Projects are shown in an adaptive card format. These were designed using adaptivecards.io in a way that could allow for information to be displayed in a concise manner which was therefore easy to read.
10 - Prompted responses on the card so that the user can intuitively click through as well as send messages. The adaptive cards can each be clicked to navigate the sections, alternatively messages can also be sent to navigate.
11 - provide a summary on project partners including address and contact information which are all displayed on an adaptive card
12 - store information on contract and NDA information and its progress. We store information on the contract in a timeline including when it was completed and the signatories involved. This is similar for the NDA. If a project hasnt been finalised it will be displayed at the bottom.
13 - Visualisation of the progress of contracts and NDA as they are completed. This is done in a timeline format.
14 - Projects from academic institutions can be inserted with additional data. If this information is available, it can be selected and displayed within an adaptive card. The card functionality is enabled by storing cards in a "Cards" template. A getter method gets these cards and overwrites the information held in the card template with the information found from the databases. Projects which are missing pieces of information are not displayed, the option is not given to view data which does not exist.
15 - Images are added to the adaptive cards which are selected based off of which image would best represent the information being displayed. This includes the logo for the organisation which helps the user easily identify the organisation for which the data is being displayed.
| Work packages | Adnan | Rajesh |
|---|---|---|
| Client liaison | 70 | 30 |
| Requirements analysis | 50 | 50 |
| Research and experiments | 50 | 50 |
| Coding | 90 | 10 |
| Testing | 10 | 90 |
| Bi-weekly reports | 90 | 10 |
| Video editing | 100 | 0 |
| Website | 10 | 90 |
| Elevator pitch | 50 | 50 |
| Prototype demo slides | 40 | 60 |
| Azure deployment | 20 | 80 |
| Administration panel | 100 | 0 |
| Overall contribution | 57 | 43 |
| Main roles | Client Liaison, UI Designer, Programmer, Report editor | Researcher, Programmer, Report editor, Tester |
| ID | Bug description | Priority |
|---|---|---|
| 1 | We do not have proper input sanitisation with our IXN miner and hence it is vulnerable to SQL injection and can use issues when users use quotes within their normal data entry | High |
| 2 | The welcome card cannot be displayed for our chatbot, even though this works perfectly when running the chatbot locally, for some reason it does not work on deployment to a web app. | Medium |
User interface / user experience
The feedback that we have received shows that the user experience is pleasant and is nearly ideal for our target group. Our UI is intuitive and easy to understand, we have been able to successfully provide an interface for enquires to be made to projects and relevant information be shown. Prior to our user acceptance testing the experience wasnt as easy for using the chatbot interface as there was no guidance on the kinds of messages that the chatbot could respond to, however on development we were able to add a help section which opened the gates to a more full utilisation of our chatbot. The user experience in the end was overall a pleasant one.
Functionality
All core functionality has been completed to a high standard. The chatbot and parser are fully functional as per requirements.
Stability
Our chatbot can be considered to have good stability as there is a consistent output for a given input. The AI behind the chatbot can evolve however so it could be considered to be unstable as some inputs could produce different outputs as the model is trained further. Such instability will not be considered negatively, but a positive outcome for the future of the project.
Efficiency
Our chatbot can be considered to be extremely efficient as a single message can provide the user with plentiful options and information relevant to their query. Further information is also easy to access and very quick to do, which aids the efficiency of our chatbot. Our IXN miner is efficient as insertion of projects is quick and comprehensive, as well as updating of projects, as our GUI allows for quick and simple data entry with near instant response.
Compatibility
Our project is compatible with all operating systems, our chatbot is ran on browser and has been tested on various browsers and hardwares and works across all platforms with no performance deficit. No alteration is required for our project to be ran on any operating system / hardware.
Maintainability
Our code is commented and documented which adds to its maintainability. Our code is also very modular and so is extendable if requirements change over time. The monthly cost of hosting our national database is currently £46.43, in the long run this may increase depending on how vast the database expands.
Project management
Adnan has been the team leader of our project and has provided excelent management for the work which we have completed. He has communicated efficiently with clients and gathered requirements in a timely manner. Rajesh and Adnan kept eachother updated continuously for updates within the project, with the additional use of trello to keep track of milestones. Overall the project management was excellent as we have completed all requirements.
If we had more time for the project we hope to be able to fix the existing bugs, in particular the welcome card so that other organisations might be able to swap out the image within the welcome card to replace with their own for their own locally hosted chatbots.
We also hope to further train our AI so that it can recognise a wider array of messages which will come with time when our chatbot is used by practitioners and others in our target audience.
Further development can be guided by changes in requirements over time as well as further user feedback as our user base grows over time
In the future we would hope to integrate Google Maps API with our chatbot in order to be able to geographically locate where projects are taking place, unfortunately we were not able to complete this as we had reduced capability as one of our members of our team was no longer able to take part in the project.