For this assignment, it needed to be in black and white. Not only does it have to be in black and white, it also need to have a creepy, mysterious, or haunted etc. feeling. What I did with this image of the Winchester Mystery House, I decided to make it look haunted yet antique. I increased the brightness and contrast. After fiddling with the brightness and contrast, I noticed that the white were too bright. What I did to fix the issue was to add a layer of Hue/Saturation over the whole image. With the Hue/Saturation, I managed to create a blue tint that porrays both haunted and antique feeling.


To add a puzzle to the database, you need the secret database access code. Otherwise, the solvability of the puzzle will still be checked, but it will not be added to the database.
Secret database access code:


Event Location:
Sofia Tech Park
Boulevard "Tsarigradsko shose" 111B
Sofia, Sofiya, Bulgaria
Abstract:
How easy is it to hack a SQL Server? In this session we'll see examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace. We'll start by gaining access to a SQL Server (using some "creative" ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), hacking DDM, and more. Most importantly, we'll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016. This is a demo-driven session, suited for DBAs, developers and security consultants.
Speaker(s): André Melancia,
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:
Microsoft surprised a lot of people with the announcement that SQL Server is going to be released for Linux. And there we have it - preview releases available in public are regularly delivered, working great and fast. On my session I'll show details of solution that allowed this idea to come true. We'll see how to install, use and administer Linux version of SQL Server. We'll see it working as a service and in Docker containers. I'll give you details of why the second option is really interesting, or to say it more clearly - groundbreaking. In addition to slides you're going to see lots of terminal windows, tools that are familiar to you and new stuff as well.
Speaker(s): Andrzej Kukula,
Abstract:
In times past, Data Science was only for those elite few with a rare combination of skills including advanced knowledge of statistics. Microsoft has been making sure that everyone can participate in the data revolution by giving people access to predictive API’s, in-database advanced analytics and drag-and-drop predictive experiments. All thanks to SQL Server 2016 and the Cortana Intelligence Suite in Azure. These advances have given people with less knowledge of statistics and programming the ability to become what Gartner calls citizen data scientists. Should we be worried about creating fools-with-tools or should we embrace the democratization of data science as the golden age of data? Using a combination of theory and demo’s, we explore Microsoft’s solutions to ensure democratization of data science and the possible dangers that lurk below the surface.
Speaker(s): Jan Mulkens,
Abstract:
Devices from the IoT realm generate data in a rate and magnitude that make it practically impossible to retrieve valuable information without support of adequate AI engines. Although being one among many solutions available, Azure ML has proved to be a great balance between flexibility, usability and affordable price. But how does Azure ML compare with the other ML providers? How to choose the appropriate algorithm? Do you understand the key performance indicators and how to improve the quality of your models? This session is about managing and understanding IoT data. Check this out and see how Azure Machine Learning could support real life problems in building IoT solutions.
Speaker(s): Ivelin Andreev,
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, demonstrating the process of building, deploying and debugging an app.
Speaker(s): Simon Whiteley,
Abstract:
We already know that cloud provides us with a way to control the amount of resources provisioned based on app load, scale them up and down. But what if I will say that there is a way to create your app, host it in the cloud and make it ready to respond at your call, but if you will have zero load during a month it will cost you nothing? Try to imagine that you will pay not for fixed amount of CPU and RAM, but for a number of function calls and amount of CPU time consumed to execute them. In this scenario you do not have a dedicated virtual machine, but you have an abstract web farm, which consists of 100500 servers and each of them is able to execute your code. In this case we do not have a server, neither physical nor virtual, we have a platform which can scale from zero to infinite in a few seconds. On top of that you can use your favorite language - C#, F#, Java, PHP, Python, Node.JS, PowerShell, Bash, etc.
Speaker(s): Anton Boyko,
Abstract:
Do you fancy learning regression and classification in one hour? We will start with linear regression, simple but powerful machine learning algorithm. With it you will learn about correlation coefficient, loss function, optimization algorithms and regularization. At the end of this section we will built a ML model using Fast linear model with Stochastic Dual Coordinate Ascent (SDCA) optimization. Next step is get to know artificial neural networks, their architecture, activation functions and backpropagation algorithm. This allows us to build a (better?) model using rxNeuralNet and N#. Evaluation metrics for regression models will conclude first part of the session. In the second part we will use almost the same ML algorithms for classification — the difference is that Logistic regression will replace Linear regression. Finally we will learn about Evaluation metrics for classification models, which allows us to pick the very best model for problems we are going to solve together.
Speaker(s): Marcin Szeliga,
Abstract:
You are already familiar with T-SQL and are eager to learn R but do not know, where to start? Start from what you already know: T-SQL. Both languages have many things in common on some levels, but are very different on others. This session will kick you off to the new language by using analogies from T-SQL. You will learn how to write your first R-scripts, make usage of packages and will leave this session with a basic understanding of typical use-cases of R and how to integrate that into your existing environment with SQL Server.
Speaker(s): Markus Ehrenmueller-Jensen,
Abstract:
A look at the state of the art in database continuous delivery using SQL Server Data Tools (SSDT), Visual Studio Team Services(VSTS), and VSTS Release Management. The features provided by platforms such as TFS and VSTS have been widely adopted by application developers in support of modern software development practices such as continuous delivery. In the world of database development, adoption has been much slower, due to a number of organisational and technical considerations. This session will discuss some of the challenges associated with database continuous delivery, and the ways in which Visual Studio, SQL Server Data Tools and Visual Studio Team Services can help to improve delivery of SQL Server databases.
Speaker(s): Gavin Campbell,
Abstract:
Anomaly detection is one of the most advanced data mining and machine learning tasks. There are many statistical procedures and data mining algorithms that can be used for it, including Expectation-Maximization Clustering, and Principal Component Analysis. In this session, you will learn through presentation and demos how to detect the low quality data areas with some basic statistics and with advanced algorithms. You will see how you can use T-SQL queries, R code in SQL Server, SSAS Data Mining, and Azure ML for this complex task.
Speaker(s): Dejan Sarka,
Abstract:
During this session we will review all types of replications in SQL Server and find out principal differences between them and when should be applied. Besides examples of practical scenarios, we will consider what we have as alternatives and why the AlwaysOn is not one of them. As always on my sessions quite a lot of demonstrations and T-SQL code.
Speaker(s): Kamil Nowinski,
Abstract:
From 25 May 2018, the EU General Data Protection Regulation (GDPR) will affect every organisation that processes EU residents’ personally identifiable information (PII). The GDPR contains requirements that systems and processes must consider compliance with the principles of data protection. The essence of privacy by design is that privacy in a service or product is taken into account not only at the point of delivery, but from the inception of the product concept. There is also a requirement that controllers should only collect data necessary to fulfil specific purposes, discarding it when it is no longer required, to protect data subject rights. This presentation provides a breakdown of the key provisions introduced by the new law, which every organisation must be aware of
Speaker(s): Miroslav Lessev,
Abstract:
An improvement of cardinality estimation is something we try to find in every next version of SQL Server. Even with all the improvements the SQL Server 2014 Query Processor gained, we still need to deal with Hash and Sort Warnings, extremely high or low Memory grants, or the well-known User Defined Functions performance issues. That’s why we are so existed to find the new wave of adaptive query processing improvements to handle the more intractable cardinality estimation issues that often result in a poor query performance. Find out how the new wave of adaptive query processing improvements to handle the more intractable cardinality estimation issues that often result in a poor query performance.
Speaker(s): Margarita Naumova,
Abstract:
CosmosDB service is a NoSQL is a globally distributed, multi-model database database service designed for scalable and high performance modern applications. CosmosDB is delivered as a fully managed service with an enterprise grade SLA. It supports querying of documents using a familiar SQL over hierarchical JSON documents. Azure Cosmos DB is a superset of the DocumentDB service. It allows you to store and query noSQL data, regardless of schema. In this presentation, you will learn: • How to get started with DocumentDB you provision a new database account. • How to index documents • How to create applications using CosmosDb (using REST API or programming libraries for several popular language) • Best practices designing applications with CosmosDB • Best practices creating queries.
Speaker(s): Mihail Mateev,
Abstract:
Thanks to the rapid, community-driven release cycle, Microsoft Power BI has caught and overtaken many visualisation tools and now sits alongside Tableau at the top of the Gartner Magic Quadrant for 2017. It is fast becoming the first-choice reporting tool for both small and large organisations. However, as with all reporting tools, if the underlying data model is badly designed or custom measures/calculations are poorly written, performance can really suffer. Whether you are designing the front-end for a carefully crafted warehouse, or performing an ad-hoc analysis exercise, you can follow some best practice advice to ensure you’re getting the best out of your reports. This 1 hour session will range from quick development wins to more strategic, enterprise considerations. The session also aims to explain ad-hoc transformations within the Query Editor and demonstrates best practices for encouraging Query Folding. Designed for all levels of Power BI expertise.
Speaker(s): Callum Green,
Abstract:
The European General Data Protection Regulation (GDPR) suggests penalties for those companies and organizations which do not comply with the directive. Fines can go as high as 4% of annual global revenue or 20 million Euros, whichever is greater. That's why everybody from C-level management to regular DBA is crucial to enforce compliance with the new data protection rules and for this very reason data maintenance tasks become absolutely obligatory and if a legal entity has skipped them, from now on it is not going to be possible. In this session, based on our experience, we will speak about the most important DBA maintenance tasks you need to perform to keep your databases GDPR compliant. Session is suitable for beginner DBAs and Developers.
Speaker(s): Tsvetozar Ivanov,
Abstract:
In this session, we will discuss where to start when you get your job as a DBA. What are the first steps you need to do to discover and arrange the environment for which you are responsible. How to answer questions like: How many databases do you have on each server? How big are they? What they are used for and how many of them are critical? Do you need backups and do you have such, Etc. There are many questions you got from the day 1, but where to start is always the key to not get panicked. The goal of this session is to help you perform your first steps in a DBA job, especially when you get into a situation with only one Excel spreadsheet containing your servers’ list.
Speaker(s): Rozalina Zaharieva,
Abstract:
So you want to use AlwaysEncrypted, but your app is not using driver level parameters? Or you want to parameterize ad-hoc queries, without rewriting your application? Or you just want to pretty print your t-sql code? SQLDOM is here to help. Not very popular but extremely useful utility/library that can help anyone to intercept and rewrite queries during runtime so they meet feature requirements or just fix performance.
Speaker(s): Ivan Donev,
Abstract:
In this session we will look at SQL Server Machine Learning Services and, in particular, the new MicrosoftML package available in SQL Server 2017 and how it can be used to build an in-database Predictive Analytics Model, that can scale. The session will initially provide a primer to supervised Machine Learning before applying that to a real world scenario, taking you through each of the steps required to build an in-database predictive analytics model using R and SQL Server 2017.
Speaker(s): Sacha Tomey,
Abstract:
This session covers the internals of statistics and indexes in Microsoft® SQL Server®. Creating and maintaining statistics and indexes is a core element in enhancing the performance of the SQL Server Database Engine. Both statistics and indexes are used to select suitable query execution plans; indexes also speed up the retrieval of data. To understand and influence query performance, you should have a good understanding of queries and indexes.
Speaker(s): Gilberto Zampatti,
Abstract:
Best practices and recommendations for leveraging/deploying Power BI within a large scale Enterprise environment, utilising new features and a look at the road map.
Speaker(s): Scott Hudson,
Abstract:
With Azure Analysis Services (Azure AS) we have full set of PAAS and SAAS services like Azure SQL DWH, Azure SQL DB, Azure AS and Power BI for creating our BI solutions in the cloud. In this session I will introduce Azure AS and how we can use it together with other Azure services for creating complete BI solution in the cloud.
Speaker(s): Sergiy Lunyakin,
Abstract:
End-to-end encryption deserves end-to-end demo :) In this session you will see not only what Always Encrypted is and how it works, but also how it looks like from developer’s perspective. It is a demo-heavy session and we will spend more time in Visual Studio and SSMS than in PowerPoint. I will show how to read encrypted columns in SSMS and how to do this in the application. You will also learn how to manage certificates in Windows Certificate Store and Azure Key Vault and why we need a separate security officer. This session is intended for both developers and database administrators.
Speaker(s): Andrey Nikolov,
Abstract:
In our new POS application intended for chains of markets we use Azure SQL Database, for many reasons we decide to store part of data also locally. We decide to use localDB as our local cache of data. In this presentation we will show: - what we considered for local storage - what is localDB - versioning and differences - what you need to install - tools for working locally - SqlLocalDB functionality - SqlCmd functionality - tips tricks
Speaker(s): Daniel Joskovski,
Abstract:
A common requirement in database applications is that users need a function to search a set of data from a large set of possible search conditions. The challenge is to implement such searches in a way that is both maintenanble and efficient in terms of performance. This session looks at the two main techniques to implement such searches and highlights their strengths and limitaitons.
Speaker(s): Erland Sommarskog,
Abstract:
The current IoT devices are pretty powerful, so could very well run a version of SQL engine. It would be a good idea? What will be the use of it? How to make it work and make the most of it? How does all fit with the field gateway concept? During the presentation, we will take a real word scenario, real hardware, and together we will try to answer these questions
Speaker(s): Catalin Gheorghiu,
Abstract:
Join me in a session where we will explore PowerBI strength for beginners and what can be achieved with it in about several clicks. We will go through PowerBI Desktop, PowerBI Webservice, different visualizations and a shallow look at Power Query.
Speaker(s): Miroslav Dimitrov,
Abstract:
In this session, we’ll see in detail how to create nodes and edges tables designed for graphs traversal in SQL Server 2017. After a summary of the underlying graph theory and its implementation in databases, we’ll see how to create graph tables in SQL Server 2017, and how to query them with the match operator. This session will give you a kickstart on using graphs in SQL Server 2017.
Speaker(s): Rudi Bruchez,
Abstract:
As data warehouses become more advanced and move to the cloud, Master Data Management is often bottom of the list. Being tied to an IAAS server solely for MDS feels like a big step in the wrong direction! In this session, I will show you the secret of ‘app-iness with a cloud alternative which leverages Power Apps and Logic Apps. We will step through a number of real world scenarios, demonstrating how easy it is to deliver a mobile friendly, no-server, no-code Master Data Management solution.
Speaker(s): Matt How,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Andrea Martorana Tusa is a Business Intelligence Team Manager at Würth Phoenix, the IT and consulting company of the Würth-Group. He is awarded as MVP in the Data Platform category Former BI Specialist at Widex, a Danish manufacturing company, and BI Developer in the IT department of an Italian banking group. 20+ years of experience working with data. He is focused on the entire BI stack: database development, data warehousing, data analysis, reporting, etc. Andrea is a usual speaker at many events: SQLSaturdays, conferences in Europe and PASS Summit, and for PASS Virtual Groups. Andrea is an author for sqlshack.com, sqlservercentral.com, and UGISS (User Group Italiano SQL Server).
LinkedIn: http://www.linkedin.com/pub/mihail-mateev/1/6b3/4b1
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
Daniel Joskovski work in IT since 1985, he is a database-centric application developer and architect, instructor, course author, user group leader. Over the Past 17 Years as MCT he#39;s been teaching Microsoft SQL Server and .NET Development courses to premier customers in Macedonia, Serbia, Norway, Kosovo and Albania. From 2009 He is being awarded with Microsoft MVP award for SQL Server 8 times in a row. At the moment Daniel works for CloudCoder DOOEL Skopje.
LinkedIn: https://www.linkedin.com/in/kamilnowinski/
Contact: https://sqlplayer.net
Blogger, speaker, #sqlfamily member. Microsoft Data Platform MVP. Data passionate, Data engineer and Architect. Over 13 years of programming and experience with SQL Server databases, he worked both as developer and administrator big databases designing systems from the scratch. Passionate about tuning database engines, code transparency and maximising performance database engine. Currently, he is expanding new horizons as a contractor in the UK market, making troubleshooting, prototyping BI and Big Data solutions, enhancing existing processes among Microsoft stuff environments, popularizing the DevOps approach and efficient solutions in the cloud. An originator of the "Ask SQL Family" podcast and founder of SQLPlayer blog.
LinkedIn: https://bg.linkedin.com/pub/miroslav-lessev/62/238/34
I am a PhD candidate at Faculty of Economics and Business Administration, University of Sofia quot;St. Kliment Ohridskiquot; in Implementation of modern computer engineering in economic studies at. I have study on cloud computing and its effect on economics and people. I have more than 20 years of experience in designing, developing, implementing and supporting databases. At the moment I#39;m a Big Data Developer in DataCore Software.
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.
Contact: http://www.dbi-services.com/index.php/blog/dbi-bloggers/blogger/listings/sth
St#233;phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is MVP as well as MCSA and MCSE for SQL Server 2012 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals amp; Pharmaceuticals, Banking / Financial Services and many other industries.
LinkedIn: https://pl.linkedin.com/in/marcinszeliga
Data Philosopher. Since 2006 invariably awarded Microsoft Most Valuable Professional title in the Data Platform category. A speaker at numerous conferences across Europe, as well as at user groups meetings. The author of many books and articles devoted to Microsoft Data Platform. An independent consultant, database-centric application practitioner and architect totally focused on SQL Server and Azure. Huge fan of Data Science and Machine Learning.
LinkedIn: ?https://ro.linkedin.com/in/catalingheorghiu?
Contact: http://ronua.ro/author/catalin/
Catalin Gheorghiu is a solution architect from Romania. He has more than 15 years of experience in developing solutions, especially on Microsoft technologies in very demanding environments. Is contributing articles and blogs to several user groups (MrSmersh), lecturing all over Romania and abroad, is also RONUA Timisoara (PASS Chapter) user group leader. Since 2011, every year he was awarded the Microsoft MVP Award.
LinkedIn: https://www.linkedin.com/in/sharepointviking/
Bjoern is an experienced Cloud and Big Data architect with great enthusiasm for Machine Learning and Advanced Analysis He has a background from .NET, SharePoint and Office 365 and is a current Office Servers and Services MVP. He is also an MCT Regional Lead for his native country Norway and delivers classroom and virtual courses all over the world
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://blogs.adatis.co.uk/sachatomey
Contact: http://blogs.adatis.co.uk/sachatomey
Sacha Tomey is Technical Director and co-founder of Adatis, a Microsoft Gold Partner for Data Analytics. He has an extensive background in technology, data in particular having delivered strategic enterprise solutions into a variety of industries across a broad selection of organisations.
LinkedIn: https://www.linkedin.com/in/markus-ehrenmueller/
Contact: http://www.savorydata.com
Markus Ehrenmueller-Jensen, as the founder of Savory Data, has a long history of providing customer solutions in the areas of data engineering, data science, and Business Intelligence. He is a certified software engineer, a graduated business educator, and professor of Databases Project Management at HTL Leonding, and is certified as an MCSE MCT. He is a published author and writes articles for well-known journals. He co-founded PASS Austria and organizes SQLSaturdays in Austria. Markus is a founding member of Power BI Usergroup Austria. Since 2017 Markus was awarded as an Microsoft Data Platform MVP.
LinkedIn: https://bg.linkedin.com/in/ivelin
Contact: https://www.slideshare.net/ivoandreev
Ivelin is a Microsoft Azure MVP and software architect in one of the leading and highly innovative Bulgarian IT brands - Interconsult Bulgaria Ltd. He is an external ICT expert in the European Commission, Eurostars-Eureka programme and Innovation Fund Denmark, Microsoft professional developer, senior project manager and Data Platform specialist. With 17+ years of strong experience in design and development of web systems, SOA, enterprise integration, machine learning, web security and data management, he is a practical man who always tries to balance between risk and flexibility. Never scared of work he has turned the weighing of pros and cons into own marked style that urges to make conscious decisions.
LinkedIn: https://www.linkedin.com/in/ivandonev/
I am a Data platform MVP with more than 10 years of real-life experience with SQL Server and its stack of services. Besides the support and project work, I am also a trainer, conference speaker and user group organizer (and volunteer).
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!
Andrey is MCSA for SQL Server 2012/2014 with almost 20 years of experience in designing and implementing applications for Windows. He is working with various database platforms, but SQL Server is his favorite. He is also a leader of Plovdiv Power BI User Group and active member of local .NET, Power BI and SQL Server communities.
Contact: http://blogs.solidq.com/dsarka/Home.aspx
Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, Radacad, SolidQ, and Pluralsight.
LinkedIn: https://www.linkedin.com/in/stijn-wynants-ba528660?trk=hp-identity-name
Contact: http://swyssql.wordpress.com
Stijn is a Microsoft Premier Field Engineer on Data AI and a DataMinds core member. He is also one of the organizers of the local user group sessions the yearly event called DataMinds Connect (SQL Server Days). He is a speaker at various international events (SQL Saturday,PASS Summit,Difinity,...). He spends his days tuning SQL Servers solving problems with the full data platform. His focus is primarily on sql server core, but has also done various BI ETL projects. He gets his kicks out of Columnstore indexes tuning queries but shivers at the sight of an SSAS cube. When Stijn is not working with SQL Server, you can probably find him enjoying the local cuisine local beers or enjoying time with his wife and his dog.
LinkedIn: https://www.linkedin.com/in/boykoant
Founder and main speaker at Ukrainian Microsoft Azure Community. 15+ years in application development. Builds apps based on Microsoft Azure platform since 2011. Microsoft Azure technical expert. Microsoft Azure MVP since 2014. Owner and one of the organizers of the most popular Microsoft Azure conferences in Ukraine: Azure Day and Global Azure Bootcamp.
LinkedIn: https://www.linkedin.com/in/callum-green
Contact: http://blogs.adatis.co.uk/callumgreen/
Callum is a Senior BI Consultant with Adatis Consulting, passionate about improving presentation layer architecture and finding new ways to exploit traditional warehouse structures. He has worked on many BI projects over a 9 year period, deviating from the typical Microsoft Stack and more into the Azure domain. Callum has written a number of blogs on subjects like Power BI, Power Query and the M programming language.
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.
MSSQL Server 2012/2008/2005 administration: - Installation and configuration - design and implement backup solutions - design and implement disaster recovery solution (mirroring, transaction log shipping, always on availability groups) - design and implement high availability solution (clustering, replication) - security management - troubleshooting - capacity planning - Performance and health monitoring, performance tuning
LinkedIn: https://bg.linkedin.com/in/dimitrovmiroslav
Contact: http://www.sqlshack.com/author/miroslav-dimitrov/
Miroslav Dimitrov is a Senior Big Data and Analytics Engineer at DXC Technology, regular speaker at various events and Microsoft Certified Trainer. He is MCSE: Data Platform for SQL Server and MCITP on SQL 2008. In the last years he had worked on great variety of customers' environments and involved in complex transitions and transformation projects as well as developing private and public cloud solutions. Miroslav is also leading database courses at Sofia University.
LinkedIn: http://www.linkedin.com/profile/view?id=5113407
Contact: http://blog.justb.dk
Independent BI consultant with extensive experience in all phases of BI development on Microsoft SQL Server, Azure and Power BI. Founder and coordinator of Microsoft Business Intelligence Professionals Denmark (MsBIP.dk) and Power BI UG Denmark (PowerBI.dk). Is a Microsoft Certified Trainer at Orange Man.
LinkedIn: http://LinkedIn.COM/in/AndreMelancia
Contact: http://Andy.PT
Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security. 19+ years' fun developing information and multimedia systems, DBA, project and IT management. Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world. Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion. Go to http://Andy.PT and you'll know the same as the NSA...
LinkedIn: https://www.linkedin.com/in/janmulkens
Contact: http://www.janmulkens.be
Jan Mulkens is a Microsoft MVP in AI, a Solution Expert at Ordina Belgium, and a Microsoft Data Platform BI Consultant. In his spare time, he is a speaker at conferences and user groups in Europe and he organizes two user groups and a conference in Belgium. Power BI Days conference (www.powerbidays.com), Belgium Microsoft Advanced Analytics User Group (bit.ly/msaaug), and Flemish Power BI User Group (meetup.powerbibelgium.com).
Contact: http://www.sommarskog.se
Erland Sommarskog is an independent consultant based in Stockholm, working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.
LinkedIn: http://it.linkedin.com/pub/gianluca-sartori/23/50b/a12
Contact: http://spaghettidba.com
Gianluca Sartori is a Data Platform MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and in Italy in particular. He is currently working as lead DBA at a famous Formula 1 team.
Iva Velkova is a SQL Server trainer in SQL Master Academy. She has nearly 4 years’ experience with SQL Server. Focusing on querying SQL Server, SQL Server development, performance tuning and optimization, Cloud development and course content development. Iva Velkova has successfully completed the requirements to be recognized as a Microsoft Certified Solution Associate: SQL Server 2016 Database Development.
LinkedIn: https://fr.linkedin.com/in/rudibruchez
Contact: http://www.babaluga.com/
(same as before)
LinkedIn: https://www.linkedin.com/in/slunyakin
Contact: https://slunyakin.wordpress.com
Sergiy Lunyakin (MCSA, MCSE, MCTS) is a Big Data Architect at SoftServe, Inc. He has extensive experience in designing and developing Big Data Analytics, Data Warehouse, and BI solutions, using both on-premises and cloud products. In 2016, Sergiy became Microsoft Data Platform MVP and has since maintained his MVP status. Sharing knowledge is another one of his passions. He regularly speaks at international conferences such as SQLSaturday, SQLDay, SQLNexus, and SQLBits. He also runs the Lviv SQL Server User Group in Ukraine and organizes SQLSaturday Lviv.
Consulting in Microsoft BI for over 5 years Working in a host of different industries: - Education - Government - Finance - Retail - Media - Subscription services Skills include: - Power BI - Azure Data Factory - Cosmos DB - Data Lake - Azure Data Warehouse - Warehouse design - SQL Server Integration Services - SQL Server Analysis Services Multidimensional/Tabular - SQL Server Reporting Services - Master Data services
LinkedIn: https://www.linkedin.com/in/rozalina-zaharieva-35402761/
SQL expert in Microsoft’s Data Platform Solution. Enthusiast with more than 10 years of experience in support, implementation, design and architecture of small and large projects for SQL Core – Consolidations and Migrations. Passionate speaker in SQL Master Academy and events like SQL Saturday and community events. Experience in Financial Sector Data platform Operations.
LinkedIn: http://bg.linkedin.com/pub/margarita-naumova/9/965/206
Contact: www.maginaumova.com; http://blogs.technet.com/b/magi/
Magi Naumova is SQL Server Architect and Consultant, speaker and trainer, Microsoft Certified Master, MVP Data Platform, MCT, Founder of SQL Master Academy, founder and leader of the Bulgarian SQL User group. She has more than 15 years SQL Server training and consulting experience. Magi is a former member of Microsoft Services Worldwide Technical Leadership Team, а Microsoft Women worth watching http://zd.net/1lwNYKH Currently she speaks, writes, trains and consults people on SQL Server technology. She runs a Data Platform consulting company part of which is SQL Master Academy training program. It helps hundreds of specialists to feel knowledgeable in their daily work or to find an inspirational career path in the world of SQL Server.
LinkedIn: https://www.linkedin.com/in/matt-how-bb981834/
Contact: http://blogs.adatis.co.uk/matthow/
Matt is a Business Intelligence specialist with a commitment to staying up to date with the latest tech and delivering solutions that clients want to use. With a strong knowledge of both the traditional SQL BI Stack and modern data warehouse architecture, Matt strives to pass on his learning to the community where possible.
LinkedIn: https://bg.linkedin.com/in/kosev
Kaloyan Kosev is a SQL Server expert working with enterprise companies for the last 9 years. His daily work routine is a mixture of troubleshooting bugs and issues, consulting and advising clients and presenting to students. Within his free time he is trying to balance between SQL and x-sports.
LinkedIn: https://www.linkedin.com/in/wollatondba
Contact: http://www.chrisadkin.io
Chris is a freelance SQL consultant who has been working with SQL Server since 2000, his passion is for squeezing every last drop of performance out of SQL Server and understanding the database engine at a level which conventional tools cannot provide any insights on.
LinkedIn: https://www.linkedin.com/in/andrzejkukula
Consultant and trainer in SQLExpert.pl with more than 20 years of IT experience. Architect of HA/DR solutions, BI solutions, Data Platform solutions, cloud solutions. Solves SQL Server related problems, including performance tuning. Passionate about SQL Server and programming. Speaker at various conferences including SQLSaturday, SQLDay, SQLNexus, AzureDay, Global Azure Bootcamp and local user groups.
LinkedIn: https://www.linkedin.com/in/dsavovic/
Contact: http://www.savovic.com.hr
Dean is Senior DBA practicing SQL Server since version 7.0 and main areas of interest are performance tuning and troubleshooting SQL Server database. He speaks at Microsoft Windays Croatia, ATD Croatia, SSWUG, KulenDayz Croatia, SQL Saturday events, etc... Primary focus is on OLTP databases with occasional adventures with Business Intelligence. He finished Faculty of Electrical Engineering and Computing and MBA on Faculty of Economics in Zagreb. His premise was that it is very useful to combine technical knowledge with management process knowledge that help us in our everyday work. He works in SPAN which is specialized in data management field on Microsoft SQL Server.
Time ago (a lot of time ago…) an excellent IT pro brought me with him and became my Mentor in the IT wonderland…it was a world full of mainframes… I met the Relational theory when there were no commercial RDBMS, and I was spellbound by that “magic”. When Microsoft appeared in the IT market, I felt finally which trek I had to follow. I’m still walking on such road, and in my rucksack I’ve ben putting some other stuff (like SharePoint, for example). My sole regret: I’ve left the College to consecrate all my time to my job; curiously, since then, I’ve never stop learning…
The following is a list of sponsors that helped fund the event.


Content Management System
Manage Bookings
Manage Companies
Manage Company Credits
Manage Credits
Manage Employees
Manage Equipment
Manage Events
Manage Extras
Manage Log Events
Manage Meeting Rooms
Manage Orders
Manage Room Equipment
Manage Users


You work as a customer service officer at Gondwana Finance, a company which provides loans and financing deals to individual and small business customers.
 He says that he wants to borrow a large amount of money from Gondwana Finance.
After you conduct a risk-profile assessment and carry out your KYC obligations, you notice some inconsistencies in the information Aiden has supplied to you. You are unable to verify Aiden's identity, or the nature of his business.


Nick Saban Offers Injury Update For Tua Tagovailoa After Mississippi State Game
by Andrew McCartyEarlier Saturday afternoon, Alabama star quarterback Tua Tagovailoa left the game against Mississippi State with an apparent injury.
Tagovailoa scrambled to his left and was hit by two Mississippi State defenders. His helmet popped off and his face could be seen covered in blood.
However, the more serious injury appears to be to Tua’s hip.
According to multiple reports, Tua is being transported by helicopter to a hospital in Birmingham. That by itself shows the severity of the injury.
After the game, head coach Nick Saban revealed Tua suffered what could be a “serious” injury.
In the post-game press conference, Saban said “godspeed” to Tua and his family.
Earlier this morning, ESPN analyst Tim Tebow suggested Tua should not play in today’s game. After Tua suffered the injury, media from all around the country chimed in, ripping Saban for the decision to leave Tagovailoa in the game.
While he left the game with an injury, he was clearly healthy enough to start the game. Tagovailoa completed 14-of-18 passing for 256 yards and two touchdowns in the first half before he left the game.
With the win over Mississippi State on Saturday, Alabama improved to 9-1 on the year. Backup quarterback Mac Jones took over in the second half and completed 7 of 11 passes for 94 yards in the win.


{# This template is shared between Django and AngularJS #} {% load djangular_tags i18n %} {% angularjs ng %}


Definitions
def call(connection)
Send the request to the given connection.
Implementation
def call(connection)
if connection.http1?
return UpgradeRequest.new(self, **@options).call(connection)
elsif connection.http2?
return ConnectRequest.new(self, **@options).call(connection)
end
raise HTTP::Error, "Unsupported HTTP version: #{connection.version}!"
end


Before you start this lab, select Launch lab above.
To log in to your lab environment:
You can now begin your work on this lab.
The estimated time to complete the lab is 45 minutes
In this lab, you will enhance the Sales Analysis with advanced design features.
In this lab, you will learn how to:
Sync slicers
Create a drillthrough page
Apply conditional formatting
Create and use bookmarks
This lab is one of many in a series of labs that was designed as a complete story from data preparation to publication as reports and dashboards. You can complete the labs in any order. However, if you intend to work through multiple labs, for the first 10 labs, we suggest you do them in the following order:
Design a report in Power BI Desktop, part 2
In this exercise, you will sync the report page slicers.
In this task you'll set up the environment for the lab by signing in to Power BI.
Important
If you have already signed into Power BI, continue from the next task.
To open Microsoft Edge, on the taskbar, select the Microsoft Edge program shortcut.
In the Microsoft Edge browser window, navigate to https://powerbi.com.
Tip
You can also use the Power BI Service favorite on the Microsoft Edge favorites bar.
Select Sign In (located at the top-right corner).
Enter the account details provided to you.
If prompted to update the password, reenter the provided password, and then enter and confirm a new password.
Important
Be sure to record your new password.
Complete the sign in process.
If prompted by Microsoft Edge to stay signed in, select Yes.
In the Microsoft Edge browser window, in the Power BI service, in the Navigation pane, expand My Workspace.
Leave the Microsoft Edge browser window open.
In this task you'll set up the environment for the lab by opening the starter report.
Important
If you're continuing on from the previous lab (and you completed that lab successfully), do not complete this task. Instead, continue from the next task.
To open the Power BI Desktop, on the taskbar, select the Microsoft Power BI Desktop shortcut.
To close the getting started window, at the top-left of the window, select X.
To sign in to the Power BI service, at the top-right, select Sign In.
Complete the sign in process using the same account used to sign in to the Power BI service.
To open the starter Power BI Desktop file, select the File ribbon tab to open the backstage view.
Select Open Report.
Select Browse Reports.
In the Open window, navigate to the D:\DA100\Labs\design-report-in-power-bi-desktop-enhanced\Starter folder.
Select the Sales Analysis file.
Select Open.
Close any informational windows that may open.
To create a copy of the file, select the File ribbon tab to open the backstage view.
Select Save As.
If prompted to apply changes, select Apply.
In the Save As window, navigate to the D:\DA100\MySolution folder.
Select Save.
In this task, you will sync the Year and Region slicers.
You will continue the development of the report created in the Design a report in Power BI Desktop, Part 1 lab.
In Power BI Desktop, on the Overview page, set the Year slicer to FY2018.
Go to the My Performance page, and then notice that the Year slicer is a different value.
When slicers aren't synced, it can contribute to misrepresentation of data and frustration for report users. You'll now sync the report slicers.
Return to the Overview page, and then select the Year slicer.
On the View ribbon tab, from inside the Show Panes group, select Sync Slicers.
In the Sync Slicers pane (at the left of the Visualizations pane), in the second column (which represents syncing), select the checkboxes for the Overview and My Performance pages.
On the Overview page, select the Region slicer.
Sync the slicer with the Overview and Profit pages.
Test the sync slicers by selecting different filter options, and then verifying that the synced slicers filter by the same selection.
To close the Sync Slicer page, select the X located at the top-right of the pane.
In this exercise, you will create a new page and configure it as a drill through page. When you've completed the design, the page will look like the following:
In this task, you will create a new page and configure it as a drill through page.
Add a new report page named Product Details.
Right-click the Product Details page tab, and then select Hide Page.
Report users won't be able to go to the drill through page directly. They'll need to access it from visuals on other pages. You'll learn how to drill through to the page in the final exercise of this lab.
Beneath the Visualizations pane, in the Drill Through section, add the Product | Category field to the Add Drill-Through Fields Here box.
The labs use a shorthand notation to reference a field. It looks like this: Product | Category. In this example, Product is the table name and Category is the field name.
To test the drill through page, in the drill through filter card, select Bikes.
At the top-left of the report page, notice the arrow button.
A button is added automatically when a field is added to the drill through well. It allows report users to navigate back to the page from which they drilled through.
Add a Card visual to the page, and then resize and reposition it so it sits to the right of the button and fills the remaining width of the page.
Drag the Product | Category field into the card visual.
Configure the format options for the visual, and then turn the Category Label property to Off.
Set the Background Color property to a light shade of gray.
Add a Table visual to the page, and then resize and reposition it so it sits beneath the card visual and fills the remaining space on the page.
Add the following fields to the visual:
Product | Subcategory
Product | Color
Sales | Quantity
Sales | Sales
Sales | Profit Margin
Configure the format options for the visual, and in the Grid section, set the Text Size property to 20pt.
The design of the drill through page is almost complete. In the next exercise, you'll enhance the page with conditional formatting.
In this exercise, you will enhance the drill through page with conditional formatting. When you've completed the design, the page will look like the following:
In this task, you will enhance the drill through page with conditional formatting.
Select the table visual.
In the visual fields pane, for the Profit Margin field, select the down-arrow, and then select Conditional Formatting | Icons.
In the Icons - Profit Margin window, in the Icon Layout dropdown list, select Right of Data.
To delete the middle rule, at the left of the yellow triangle, select X.
Configure the first rule (red diamond) as follows:
In the second control, remove the value
In the third control, select Number
In the fifth control, enter 0
In the sixth control, select Number
Configure the second rule (green circle) as follows:
In the second control, enter 0
In the third control, select Number
In the fifth control, remove the value
In the sixth control, select Number
The rules are as follows:
Select OK.
In the table visual, verify that the that the correct icons are displayed.
Configure background color conditional formatting for the Color field.
In the Background color - Color window, in the Format By dropdown list, select Field Value.
In the Based on field dropdown list, select Product | Formatting | Background Color Format.
Select OK.
Repeat the previous steps to configure font color conditional formatting for the Color field, using the Product | Formatting | Font Color Format field.
You may recall that the background and font colors were sourced from the ColorFormats.csv file in the Prepare data in Power BI Desktop lab, and then integrated with the Product query in the Load data in Power BI Desktop lab.
In this exercise, you will enhance the My Performance page with buttons, allowing the report user to select the visual type to display. When you've completed the design, the page will look like the following:
In this task, you will add two bookmarks, one to display each of the monthly sales/targets visuals.
Go to the My Performance page.
On the View ribbon tab, from inside the Show Panes group, select Bookmarks.
On the View ribbon tab, from inside the Show Panes group, select Selection.
In the Selection pane, beside one of the Sales and Target by Month items, to hide the visual, select the eye icon.
In the Bookmarks pane, select Add.
To rename the bookmark, double-click the bookmark.
If the visible chart is the bar chart, rename the bookmark as Bar Chart ON, otherwise rename the bookmark as Column Chart ON.
To edit the bookmark, in the Bookmarks pane, hover the cursor over the bookmark, click the ellipsis, and then select Data.
Disabling the Data option means the bookmark won’t use the current filter state. That’s important because otherwise the bookmark would permanently lock in the filter currently applied by the Year slicer.
To update the bookmark, click the ellipsis again, and then select Update.
In the following steps, you’ll create and configure a second bookmark to show the second visual.
In the Selection pane, toggle the visibility of the two Sales and Target by Month items.
In other words, make the visible visual hidden, and make the hidden visual visible.
Create a second bookmark, and name it appropriately (either Column Chart ON or Bar Chart ON).
Configure the second bookmark to ignore filters (Data option off), and update the bookmark.
In the Selection pane, to make both visuals visible, show the hidden visual.
Resize and reposition both visuals so they fill the page beneath the multi-card visual, and completely overlap one another.
Tip
To select the visual that is covered up, select it in the Selection pane.
In the Bookmarks pane, select each of the bookmarks, and notice that only one of the visuals is visible.
The next stage of design is to add two buttons to the page, which will allow the report user to select the bookmarks.
In this task, you will add two buttons, and assign bookmark actions to each.
On the Insert ribbon, from inside the Elements group, select Button, and then select Blank.
Reposition the button directly beneath the Year slicer.
Select the button, and the in the Visualizations pane, turn the Button Text property to On.
Expand the Button Text section, and then in the Button Text box, enter Bar Chart.
Expand the Background section, and then set a background color using a complementary color.
Turn the Action property to On (located near the bottom of the list).
Expand the Action section, and then set the Type dropdown list to Bookmark.
In the Bookmark dropdown list, select Bar Chart ON.
Create a copy of the button by using copy and paste, and then configure the new button as follows:
Tip
The shortcut commands for copy and paste are Ctrl+C followed by Ctrl+V.
Set the Button Text property to Column Chart
In the Action section, set the Bookmark dropdown list to Column Chart ON
The design of the Sales Analysis report is now complete.
In this task, you will publish the report.
Select the Overview page.
In the Year slicer, select FY2020.
In the Region slicer, choose Select All.
Save the Power BI Desktop file.
The file must always be saved prior to publishing to the Power BI service.
On the Home ribbon tab, from inside the Share group, click Publish.
In the Publish to Power BI window, notice that My Workspace is selected.
To publish the report, choose Select.
If prompted to replace the report, select Replace.
When the publication has succeeded, click Got It.
Leave Power BI Desktop open.
In the next exercise, you will explore the report in the Power BI service.
In this exercise, you will explore the report in the Power BI service.
In this task, you will explore the report in the Power BI service.
In the Microsoft Edge browser window, in the Power BI service, in the Navigation pane, select the Sales Analysis report.
To test the drill through report, in the Overview page, in the Quantity by Category visual, right-click the Clothing bar, and then select Drill Through | Product Details.
Notice that the Product Details page is for Clothing.
To return to the source page, at the top-left corner, select the arrow button.
Select the My Performance page.
Select each of the buttons, and then notice that a different visual is displayed.
In this task, you will complete the lab.
To return to the workspace, in the breadcrumb trail, select your workspace name.
Leave the Microsoft Edge browser window open.
In Power BI Desktop, go to the My Performance page, and in the Filters pane, remove the Salesperson filter card.
Select the Overview page.
Save the Power BI Desktop file, and then republish the report to Power BI.
Leave Power BI Desktop open.
When you share the report in the Publish and share Power BI content lab, the report will enforce row-level security.


|
cocos2d-mac-extensions
0.2
Cocos2D Extensions API Reference (Mac OS X version) for Kobold2D developers
|
Public Member Functions | |
| id | initWithSourcePath:targetFilename:delegate: (NSString *sourcePath,[targetFilename] NSString *aTargetFilename,[delegate] id< SingleFileDownloaderDelegate > aDelegate) |
| void | startDownload () |
| void | cancelDownload () |
| NSString * | targetPath () |
| NSUInteger | contentDownloaded () |
| NSUInteger | contentLength () |
Static Public Member Functions | |
| id | fileDownloaderWithSourcePath:targetFilename:delegate: (NSString *sourcePath,[targetFilename] NSString *aTargetFilename,[delegate] id< SingleFileDownloaderDelegate > aDelegate) |
| NSString * | destinationDirectoryPath () |
Protected Attributes | |
| BOOL | _downloading |
| NSURLConnection * | _connection |
| NSFileHandle * | _fileHandle |
| NSString * | _filename |
| NSString * | _sourcePath |
|
NSObject < SingleFileDownloaderDelegate > * | _delegate |
| NSUInteger | _bytesReceived |
| NSUInteger | _bytesTotal |
uses NSURLConnection to download file from URL, that is set by concatanating source URL (i.e http://foo.com/files/ ) and file name (i.e. bar.png ), so URL for this file will be http://foo.com/files/bar.png , to APP_SANDBOX/Library/Caches on iOS or to ~/Library/Caches/APP_BUNDLE_ID on Mac (According to Mac OS X File System Guide ).
At the first SingleFileDownloader creates tmp file and downloads contents into it, only after downloading successfully ends - it renames tmp file to destination filename.
SingleFileDownloader is used internally in FilesDownloader class, if you're downloading many files at time from one place - you don't need to use SingleFileDownloader - use FilesDownloader instead.
| void SingleFileDownloader::cancelDownload | ( | ) | [virtual] |
Stops downloading.
| NSUInteger SingleFileDownloader::contentDownloaded | ( | ) | [virtual] |
Returns downloaded content size in bytes.
| NSUInteger SingleFileDownloader::contentLength | ( | ) | [virtual] |
Returns total content size in bytes. This value can be changed each. Use this method in downloadSizeUpdated delegate method to determine new expected content size.
| NSString * SingleFileDownloader::destinationDirectoryPath | ( | ) | [static, virtual] |
Returns shared destination path part for all files ~/Library/Caches/APP_BUNDLE_ID on Mac & APP_SANDBOX/Library/Caches on iOS.
| id SingleFileDownloader::fileDownloaderWithSourcePath:targetFilename:delegate: | ( | NSString * | sourcePath, |
| [targetFilename] NSString * | aTargetFilename, | ||
| [delegate] id< SingleFileDownloaderDelegate > | aDelegate | ||
| ) | [static, virtual] |
Creates SingleFileDownloader with given source path, target filename & delegate.
| sourcePath | - path from which to download file, without filename. I.e. "http://foo.com/files/" |
| aTargetFilename | subPath that will be added to sourcePath to determine full URL for a file. I.e. "foo/bar/file.txt" |
| aDelegate | delegate for SingleFileDownloader status callbacks. |
| id SingleFileDownloader::initWithSourcePath:targetFilename:delegate: | ( | NSString * | sourcePath, |
| [targetFilename] NSString * | aTargetFilename, | ||
| [delegate] id< SingleFileDownloaderDelegate > | aDelegate | ||
| ) | [virtual] |
Inits SingleFileDownloader with given source path, target filename & delegate.
| sourcePath | - path from which to download file, without filename. I.e. "http://foo.com/files/" |
| aTargetFilename | subPath that will be added to sourcePath to determine full URL for a file. I.e. "foo/bar/file.txt" |
| aDelegate | delegate for SingleFileDownloader status callbacks. |
| void SingleFileDownloader::startDownload | ( | ) | [virtual] |
Starts downloading.
| NSString * SingleFileDownloader::targetPath | ( | ) | [virtual] |
Returns full target path for file, that will be downloaded I.e. "APP_SANDBOX/Library/Caches/fooBar.png" (iOS) or @"~/Library/Caches/APP_BUNDLE_ID" (Mac)


--- layout: post title: Brighton Holistics date: 2008-03-02 00:00:00 categories: chop-socky personal ---
If you're in Brighton and looking to try something a little different, you could do worse than head along to one of Mark's taster classes for Holistics. Mark's a good friend of mine and has combined elements of Aikido (from which I know him) with all sorts of other stuff into an unusual melange - and he's doing first the class for free, at various venues across Brighton.


Temperature
Living room
0
Motion
Entrance
0
Distance (cm)
Garage
0
Luminosity
Garden (0-1023)
0
PushLight1
Roof
1
On/Off
MillWheel
Outside
1
On/Off
PushLight2
Front
1
On/Off
PushLight3
Entrance
1
On/Off
Heater
Home
1
On/Off
Window blind
Living room
1
On/Off


GetErDone-SPA
{{ site_state }}
Log In
Log Out
Assigned Tasks
Mark all complete
Double click a task to edit the title.


We didn't get here overnight. But we must stop here (virtually) overnight. That is a hard truth to accept.
But it is not too late to make a difference. It is not too late to express the best of what it means to be human: to care for each other. To recognize the intrinsic worth of another soul. To love life: all that is created. To leave the world a better place.
Why change our personal habits, communal priorities, and institutional regulations? Because we love our children, our neighbors, and our planet. Because action is where we will find our hope and joy. And because action can work: we saved the Bald Eagle, reduced acid rain, and stopped the growth of the ozone hole. We can do this.
"Let’s work together to make this planet earth environmentally sustainable so that our succeeding generations – children after children – will live peacefully. There is no Plan B because we do not have planet B."
U.N. Secretary General Ban Ki-moon
Myriads of others have written and spoken more eloquently about the morality of climate action. We commend you to them for further inspiration. Scroll down for a few links.
Book review: A Perfect Moral Storm: The Ethical Tragedy of Climate Change by Stephen M. Gardiner.
Video: The Moral Math of Climate Change, Krista Tippet interviewing Bill McKibben.
Statements: Religious Teachings collected by GreenFaith, or Religious Statements on Climate Change as collected by Interfaith Power and Light.


There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour?
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour?
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour?
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour?
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour?


Giving is not just about making a donation,
it's about making a difference!
Some of us are privileged, some of us are not.
Your small donation will make huge difference in the life of underprivileged
childrens and their
education. Let's become a helping hand, and make
everyone educated. All the donations will be used to buy books, pay
the school fees, and other
requirements for kids.
This is a sample project by Prem Joshi and The Sparks Foundation.
Note that the above donation is in a Test Mode, that means you
are not donating
your real money! But I surely support the ideology
that everyone must be educated, and we must help the needy.
Thank You for visiting this site!


Laurel True-McCarthy
Home
About Me
Education
Tools & Tech
hi! i'm laurel:
lover of user experience design,
humans,
their designs,
collaborations & experiences


Use Node.js
and Express
to build an API that
performs CRUD operations on blog posts
.
index.js
,
api/server.js
and
api/posts/posts-router.js
to implement the endpoints
listed below.
/api/posts
into a
separate Express Router inside api/posts/posts-router.js
.
api/posts/posts-model.js
.
| N | Method | Endpoint | Description |
|---|---|---|---|
| 1 | GET | /api/posts | Returns an array of all the post objects contained in the database |
| 2 | GET | /api/posts/:id | Returns the post object with the specified id |
| 3 | POST | /api/posts | Creates a post using the information sent inside the request body and returns the newly created post object |
| 4 | PUT | /api/posts/:id | Updates the post with the specified id using data from the request body and returns the modified document, not the original |
| 5 | DELETE | /api/posts/:id | Removes the post with the specified id and returns the deleted post object |
| 6 | GET | /api/posts/:id/comments | Returns an array of all the comment objects associated with the post with the specified id |
500
.{ message: "The posts information could not be
retrieved" }
.
If the post with the specified id
is not
found:
404
(Not Found).{ message: "The post with the specified ID does not
exist" }
.
If there's an error in retrieving the post from the database:
500
.{ message: "The post information could not be
retrieved" }
.
If the request body is missing the title
or
contents
property:
400
(Bad Request).
{ message: "Please provide title and contents for the
post" }
.
If the information about the post is valid:
201
(Created).If there's an error while saving the post:
500
(Server Error).
{ message: "There was an error while saving the post to
the database" }
.
If the post with the specified id
is not
found:
404
(Not Found).{ message: "The post with the specified ID does not
exist" }
.
If the request body is missing the title
or
contents
property:
400
(Bad Request).
{ message: "Please provide title and contents for the
post" }
.
If there's an error when updating the post:
500
.{ message: "The post information could not be
modified" }
.
If the post is found and the new information is valid:
request body
.
200
(OK).
If the post with the specified id
is not
found:
404
(Not Found).{ message: "The post with the specified ID does not
exist" }
.
If there's an error in removing the post from the database:
500
.{ message: "The post could not be removed" }
.
If the post with the specified id
is not
found:
404
(Not Found).{ message: "The post with the specified ID does not
exist" }
.
If there's an error in retrieving the comments from the database:
500
.{ message: "The comments information could not be
retrieved" }
.
The data
folder contains a database populated with test
posts
.
Database access will be done using the posts-model.js
file
included inside the api/posts
folder:
find()
: calling find returns a promise that resolves to
an array of all the posts
contained in the database.
findById()
: this method expects an id
as
it's only parameter and returns a promise that resolves to the
post corresponding to the id
provided or
undefined
if no post with that id
is found.
insert()
: calling insert passing it a
post
object will add it to the database and return a
promise that resolves to an object with the id
of the
inserted post. The object looks like this: { id: 123 }
.
update()
: accepts two arguments, the first is the
id
of the post to update and the second is an object with
the changes
to apply. It returns a promise that resolves
to the count of updated records. If the count is 1 it means the record
was updated correctly.
remove()
: the remove method accepts an id
as
its first parameter and upon successfully deleting the post from the
database it returns a promise that resolves to the number of records
deleted.
findPostComments()
: the findPostComments accepts a
postId
as its first parameter and returns a promise that
resolves to an array of all comments on the post associated with the
post id.
A Blog Post in the database has the following structure:
{ title: "The post title", // String, required contents: "The post contents", // String, required created_at: Mon Aug 14 2017 12:50:16 GMT-0700 (PDT) // Date, defaults to current date updated_at: Mon Aug 14 2017 12:50:16 GMT-0700 (PDT) // Date, defaults to current date }
A Comment in the database has the following structure:
{ text: "The text of the comment", // String, required post_id: "The id of the associated post", // Integer, required, must match the id of a post entry in the database created_at: Mon Aug 14 2017 12:50:16 GMT-0700 (PDT) // Date, defaults to current date updated_at: Mon Aug 14 2017 12:50:16 GMT-0700 (PDT) // Date, defaults to current date }
npm test
.npm run resetdb
.package.json
file except to install
additional libraries or add additional scripts.
To work on the stretch problems you'll need to enable the
cors
middleware. Follow these steps:
cors
npm module: npm i cors
.server.use(cors())
after
server.use(express.json())
.
Create a new React application and connect it to your server:
create-react-app
to create an application inside the
root folder, name it client
.
/api/posts
endpoint in the API and show the list of
posts.


On Tuesday 18th of July,
we got introduced to the client – Elise Allen, and requirements.
We joined desired groups and discussed extensively on how to go about creating the spinner app. Also, we
started with setting up communication means, version control for the project and Trello (to keep track of
activities).
The client, Elise, described what she wanted and when she needed it (in 2 weeks’ time). We decided on going home to think individually, about what platform would be best until the next meeting.
Elise wanted;
☛ An app that will have advert feature that brings income for her each time someone views the ad.
☛ A decision spinner with options/answers to questions.
☛ A button to start the spinner.
☛ Feature that allows users to add and edit choice set questions and options.
☛ Options to change interface (skin colour, SFX etc).
☛ Have space for ads.
☛ Get user’s name at the start.
☛ Have main activity page.
☛ Have history of user’s set choice options.
On Wednesday 19th of July , we couldn’t meet up but had our conversation online through Facebook. After deciding on making the project a Web App and, I found a resource online for the spinner project. I uploaded the file
on Trello for a review from my team members.
The resource was accepted and we opted to meet in class on Thursday 20th of July for further planning.
On Thursday 20th of July, we met in class to further discuss the next step. Although Grayson was unavailable for the class, Mark and I had our first scrum. During the scrum, we asked each other the questions;
☛ What have you done regarding the project since the last meeting?
☛ What are you planning to do?
☛ What obstacles prevents your efficiency?
The scrum master for that day (Mark) would then put measures in place to assist the person struggling in carrying out the given task. Afterwards, Mark allocated a set of tasks to everyone.
Also, we had our communication
going on Facebook and Trello.
On Friday 21st of July, we all concluded our individual tasks towards having a prototype ready for our client’s viewing Tuesday. However, Grayson suggested a different user interface for the Web App, which seemed great to
Mark and I. The new UI was uploaded to gitbucket and made ready for client’s viewing on Tuesday 25th of July.
We held our conversations of Facebook because we all had different schedules.
The cards of tasks to be done were updated on Trello, which leaves us with a very few tasks left to be carried out after initial client’s viewing.
On Tuesday 25th of July, we presented the prototype to the client (Elise) who was satisfied with the current state of the application. We assured her of other features, such as ability of user to set choice questions and options, that will be implemented before final presentation of the application.
In addition, we had a short meeting to review individual progresses and to figure out how far we have gone with the project.
On Thursday 27th of July , we had a setback with implementing the feature that allows the user to set choice questions and options. This was due to the JavaScript framework, d3.js, that we used. It occurred to us that creating a database for the user’s set choice questions and linking it to the app, would be difficult to implement within the remaining timeframe.
However, we decided to research ways of working around it, which led to a minor success. We created an external JavaScript file that collects information from the user, and stores it in a flat file. The only setback with this was the inability to pull data from the flat file into the external JavaScript, and passing it into the HTML + JavaScript file that holds the spinner.
Hence, we fixed a time for the following Monday for a meeting to review possible solutions, that individual persons have researched for fixing this problem.
On Monday 31st of July, we met in the department’s common room at 3pm. It appeared from individual persons’ report that implementing the feature through the initial means, within the remaining timeframe would be impossible.
So, we decided on collecting information from the user using JavaScript without storing the information, but still providing the user with the option of setting choice questions and options.
This idea seemed great to us all and we made our final changes to the application. We uploaded the files to Kate (department’s server) to make it accessible online for the client.
On Tuesday 1st of August, we had our final presentation which was a success as the client was pleased with the outcome.
However, we were unfortunately unable to implement the advertisement feature that the client wanted initially.
I am Olufemi Olusina, a second year Bachelor of Information Technology student at Otago Polytechnic, Dunedin, New Zealand.
This portfolio outlines my individual report regarding the Software Engineering project - The Decision Spinner.
The Decision Spinner is a Web App designed by Mark Gowans, Grayson Orr and myself. It is made to assist the user with making decisions based on the question and options provided.


Weather App
Toggle Navigation
Current
Forecast
Weather Forecast
Enter City Name:
Search
Icon
Weather
Description
Morning Temp.
Night Temp.
Min Temp.
Max Temp.
Pressure
Humidity
Wind Speed
Wind Direction


Specify your Google App Engine user account details and related
settings. For additional information, see the Google App Engine
documentation.
- Name:
The name of the Google App Engine configuration.
- Use passwordless login via OAuth2:
Use the OAuth 2.0 authentication.
- Login with email and password:
Log in to the cloud using your email and password.
- Email:
Your Google email address.
- Password:
Your Google account password.
- Remember password:
Save your password. For more information, see Settings/Preferences | Appearance and Behavior | System Settings | Passwords.


Gallery
Apps We Built
Unstoppable Wallet
Invest in Bitcoin, Ethereum, EOS, Binance DEX and 60+ projects. Non-custodial, p2p, private, decentralized crypto wallet app.
Guides Published
Understand how Bitcoin, Ethereum, EOS, Libra and other major blockchains work. We explain these projects in simple terms helping investors to onboard these decentralized economies as a pioneer.
What is Libra
What is Libra project? Why it's being built? What it means for people, crypto and traditional financial services?
Ethereum
coming soon ...
{% include subscribe-form.html %}
Code Released
We believe good ideas should be Unstoppable. As we sail through uncharted waters of building decentralized services we keep 100% of our work public and open source. Use our libraries to design autonomous systems that can't go offline.
Bitcoin Kit
iOS / Android
Ethereum Kit
iOS / Android
EOS Kit
iOS / Android
Binance Chain Kit
iOS / Android
Atomic Swap
iOS / Android
Lightning Kit
Soon
Team
Nickname Raph, is a fictional character and one of the four main characters of the Teenage Mutant Ninja
Turtles comics and all related media.


A collection of implementations of semi-supervised classifiers and methods to evaluate their performance. The package includes implementations of, among others, Implicitly Constrained Learning, Moment Constrained Learning, the Transductive SVM, Manifold regularization, Maximum Contrastive Pessimistic Likelihood estimation, S4VM and WellSVM.
| Version: | 0.7 |
| Depends: | R (≥ 2.10.0) |
| Imports: | methods, Rcpp, MASS, kernlab, quadprog, Matrix, dplyr, tidyr, ggplot2, reshape2, scales, cluster |
| LinkingTo: | Rcpp, RcppArmadillo |
| Suggests: | testthat, rmarkdown, SparseM, numDeriv, LiblineaR |
| Published: | 2018-07-12 |
| Author: | Jesse Krijthe [aut, cre] |
| Maintainer: | Jesse Krijthe <jkrijthe at gmail.com> |
| BugReports: | http://www.github.com/jkrijthe/RSSL |
| License: | GPL-2 | GPL-3 [expanded from: GPL (≥ 2)] |
| URL: | http://www.github.com/jkrijthe/RSSL |
| NeedsCompilation: | yes |
| Citation: | RSSL citation info |
| Materials: | README |
| CRAN checks: | RSSL results |
| Reference manual: | RSSL.pdf |
| Package source: | RSSL_0.7.tar.gz |
| Windows binaries: | r-devel: RSSL_0.7.zip, r-release: RSSL_0.7.zip, r-oldrel: RSSL_0.7.zip |
| OS X binaries: | r-release: RSSL_0.7.tgz, r-oldrel: RSSL_0.7.tgz |
| Old sources: | RSSL archive |
Please use the canonical form https://CRAN.R-project.org/package=RSSL to link to this page.


Rupee slips 9 paise to 71.80 against U.S. Dollar in early trade
Positive opening in domestic equities and easing crude oil prices supported the domestic unit
by PTIThe Rupee opened on a weak note and fell 9 paise to 71.80 against the U.S. Dollar in opening trade on November 20 as U.S.-China trade deal concerns weighed on the investor community.
Forex traders said, the decline in the domestic unit was largely in tandem with other Asian currencies, after U.S. President Donald Trump said China tariffs will go ‘even higher’ without a deal. “If we don’t make a deal with China, I’ll just raise the tariffs even higher,” he told reporters at the White House.
Moreover, sustained foreign fund outflows and strengthening of the American currency vis-a-vis other currencies overseas dragged down the local unit.
However, positive opening in domestic equities and easing crude oil prices supported the domestic unit.
The Rupee opened weak at 71.80 at the interbank Forex market, down 9 paise over its last close. The Rupee had settled at 71.71 against the U.S. Dollar on November 19 .
Brent crude futures, the global oil benchmark, eased 0.15% to $60.82 per barrel.
Foreign institutional investors (FIIs) remained net sellers in the capital markets, pulling out ₹915.37 crore on November 19, as per provisional data. On the domestic market front, benchmark indices Sensex was trading 172.52 points higher at 40,642.22 and Nifty was up 45.85 points at 11,985.95.
The dollar index, which gauges the greenback’s strength against a basket of six currencies, rose by 0.03% to 97.88. The 10-year government bond yield was at 6.47% in morning trade.