Event Location:
Loyola University
8890 McGaw Road
Columbia, Maryland
Abstract:
Self-service business intelligence is rapidly gaining popularity among business analysts today. It greatly relieves the problems created by traditional data warehouse implementations, which typically require a long formal development cycle. Using tools such as Microsoft's Power Pivot, Power Query and Power View alters the process significantly. These tools transform the BI analysis cycle into an agile process that will empower and excite your business analysts. At the core of every successful data analysis project is a robust data model. In this session, Dan will take you through the process of creating a solid data model in Power Pivot. You will learn how to import data from various sources, combine these in a scalable data model. In addition, you will discover how you can set various properties in the Power Pivot model to enhance the user experience when they create interactive visualisations of the data in Power View.
Speaker(s): Dan Clark,
Abstract:
When you design a Transactional System, learn to make decisions on what to normalize based on business rules, not just on the basis of the 1NF through 6NF (nothing wrong with the rules, but I do encourage that you understand your data as well as the rules). For example, do you need to which of the two addresses and order was shipped to? Which credit card out of the three that you have on file was used on the 106th order for this customer? My talk is based on breaking out a different table because you need to keep track of the data - when, as a part of your design or maintenance, it dawns on you that this particular piece of data is relevant to the present, and to past events, and needs to be kept track of. I back my suggestions with experience from designing Transactional Database Systems with 600+ tables used to keep track of multiple threads of information, passing relevant information on to efficient reporting structures.
Speaker(s): Raj More,
Abstract:
Have you ever needed to generate dozens (or even hundreds) of similar SSIS packages? Do you ever find yourself needing to regenerate a lot of packages when some piece of the upstream data format changes? Using native SSIS, this can be a tedious and error prone exercise. However, using Biml (Business Intelligence Markup Language) can greatly increase your productivity as an ETL developer. In this session, we'll cover the essentials of Biml. I'll discuss what it is and what it can do for SSIS, demonstrating how it can easily generate dozens or even hundreds of packages in just a few minutes. I'll also demonstrate some realistic examples and discuss how Biml fits into the enterprise ETL picture.
Speaker(s): Tim Mitchell,
Abstract:
Once you finish designing the SSIS packages needed for your project, the process of creating those packages is mostly redundant and time-consuming. As the source or target systems go through changes (even as small as a column rename), you’re forced to modify the packages. BI Markup Language (BIML), which is a free plugin, removes the pain-points involved in manual development by programmatically generating packages. In this session, you’ll learn the basics of BIML and see how you can use it along with metadata to create packages automatically. You’ll also see how easy it is to regenerate the packages when the system changes. You’ll leave the session with knowledge of BIML’s building blocks and a principle I call “D[ee]MOB” that helps you automate SSIS development in your environment.
Speaker(s): Samuel Vanga,
Abstract:
Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process. PowerShell scripts can greatly reduce the time required to complete the process. They can also ensure build standardization throughout your SQL environment. In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of a SQL Server.
Speaker(s): Jamie Wick,
Abstract:
Sharing your technical knowledge can be a gift for both you and others. But how would you share your knowledge through a presentation? There are so many things to consider: what topic to discuss, where should you present, and should you really imagine the audience naked. This presentation covers these topics, along with much more. Before long, you too can share the gift of presenting!
Speaker(s): Jessica Moss,
Abstract:
Common Table Expressions (CTE) are a temporary result set used within an SQL statement, such as SELECT, INSERT, UPDATE, or DELETE, that can be used in place of a subquery and can help simplify more complex queries such as when joining to the same result set multiple times. We'll begin with an overview of how a Common Table Expression is constructed. Then we'll build some queries using derived tables, and as the queries we build get more unwieldy, demonstrate how the query can be simplified by the use of a CTE.
Speaker(s): Ben Galluzzo,
Abstract:
Eric Simpson, Cisco Learn about Cisco Unified Computing System (UCS) and why it is an optimal platform for Microsoft SQL Server. During this session we’ll discuss key differentiators that place Cisco well ahead of the competition. Learn about UCS’ management model, Service Profiles, Virtual Interface Adapters, and how they help to simplify and standardize SQL Server deployments. We will also discuss how these differentiators drastically reduce deployment and recovery times, and how UCS provides the best of class hardware platform that can help to achieve the highest levels of consolidation and performance for both virtual and bare metal SQL Server implementations.
Speaker(s): Event Sponsor,
Abstract:
Come meet the Internals of SQL Server at this special get-together! In this presentation we will cover the basics of data storage and querying with SQL Server. We will cover how data is stored in pages and extents and how that translates to data reads/writes with the storage system. Additionally, we will explore how different queries are processed by SQL Server and how the query life cycle works in general. Finally we will cover disk storage and memory and tie it all together. This session is intended to be broad and to give a general overview of how a query is processed in SQL Server and how storage and memory play a part in that. Everyone is invited to this introductory level presentation and should be appealing to DBAs, DB BI Developers and System Administrators. Party hats not included, rated G for Geeks.
Speaker(s): Ayman El-Ghazali,
Abstract:
In this session we will do a demo-driven "101" level tour of Microsoft Power BI for Office 365, a solution hosted in the Microsoft Enterprise Cloud. We will take a look at the rich set of PowerBI capabilities, particularly the self-service BI solutions offered through Excel and Office 365. We will also take a look at ways to present levels of data analysis and data visualizations which can bring together deep levels of data insight . We will also discuss a "how to" list to get started as well as the Power BI for Office 365. This session if perfect for business / data analysts, data professionals whom are looking for a session to cover the fundamentals and take away enough information to get you jump started into the right direction.
Speaker(s): Timothy McAliley,
Abstract:
When reviewing your ETL processes, the No. 1 question is always, "Does it work as expected?" Closely following that question is the ubiquitous, "How fast does it run?" This session’s tips are targeted at improve the latter. In this session, we’ll focus on SSIS package performance, quickly reviewing 15 common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.
Speaker(s): Tim Mitchell,
Abstract:
Need to report on some data from SharePoint? We'll look at three different techniques to pull data from a SharePoint Server. We'll start with SSIS and the SharePoint List Source and Destinations. Next, we'll use Excel to connect to various SharePoint lists (both online and on premise), and finally we'll use Microsoft Access to do the same thing (and throw in the capability to do updates as well). At the end of the talk, we'll have three different ways to get data from SharePoint.
Speaker(s): David Patrick,
Abstract:
The difference between Analysis Services Multidimensional versus Analysis Service Tabular can be difficult to understand for both new and seasoned Microsoft business intelligence developers. However, this understanding helps you to pick the model type that will provide the best possible solution for your end users. This session will describe each model type, list the pros and cons of each model type, and show developer and end user functionality for both model types. After this session, you will be able to successfully pick the right Analysis Services model type for you.
Speaker(s): Jessica Moss,
Abstract:
The staging area of the data warehouse is an often under-utilized tool in the ETL developers tool belt. It can be used to optimize ETL performance while limiting impact on source systems. It can be used to identify data quality concerns before they hit the target load process. It can be used as a supplemental repository for unintegrated data. This discussion will cover several common and some not-so-common patterns in the design and use of the stage environment within the ETL process. The audience will come away with new ideas and core concepts to put to immediate use.
Speaker(s): Philip Noakes,
Abstract:
Are you someone (A DBA, Developer, etc) that connects to SQL Server to use data? You probably hear a lot about how protected your database can be when at rest. But what about when you connect to SQL and start running some queries? Using a simple hacking technique we will dig into some packets on our network and see what's in them. You may be shocked! Then we will create a self-signed SSL certificate, use it to encrypt our connections on the SQL Server, and see the actual changes in the packet as hackers would. *Warning - do not try some of these demos at work without proper permissions as hacking techniques are used.
Speaker(s): Chris Bell,
Abstract:
Sponsor Session
Speaker(s): Event Sponsor,
Abstract:
SQL Clinic is an open board discussion lead by couple of Microsoft field engineers. If you have any SQL related problem or question, you can go there and ask and get an answer for free. If you do not have problems or questions you can just stay there and learn what kind of problems other people have in their environments.
Speaker(s): Harsh Deep Singh,
Abstract:
In this session, we'll review PowerQuery, PowerPivot, PowerMap and PowerView, and see how to get started developing with these tools. Microsoft is betting on these Self Service BI tools - and rightly so. We'll see how it can help you automate even the mundane things that you do at work, and expand on this foundation towards more advanced development using DAX.
Speaker(s): Azhagappan Arunachalam,
Abstract:
Overview of MDM, Profisee, value of our solution, how organizations are using MDM, and how you can get started with an MDM project
Speaker(s): Event Sponsor,
Abstract:
Analysis Services have become a major part of upper management daily decision making activities. However, with our DW sizes reaching multiple terabytes minimizing time required to process our data has become our top priority. In this session, we will cover the options we have as DBA’s to improve the performance of our DW processing time. We will look at features and general best practices available to us within SSAS as well as enterprise level features within the database engine itself and how aligning them to work side by side would yield us at least 200% improvement in our processing time.
Speaker(s): Konstantin Melamud,
Abstract:
SQL Clinic is an open board discussion lead by couple of Microsoft field engineers. If you have any SQL related problem or question, you can go there and ask and get an answer for free. If you do not have problems or questions you can just stay there and learn what kind of problems other people have in their environments.
Speaker(s): Harsh Deep Singh,
Abstract:
In this session, we will focus on how to formulate a Master Data Management (MDM) strategy and build a solution to find the single version of the truth, aka the Golden Record. While these techniques can apply to any domain, we will demonstrate building a sample customer domain in this session, showing how to leverage SQL Server Master Data Services(MDS) and other tools for data quality, matching, and de-duplication across multiple data sources.
Speaker(s): Brian Benzel,
Abstract:
SQL Server 2012 brings with it nearly full ANSI compliance with the windowing functions. Come to this code filled session to learn about all of the windowing functions in SQL Server 2012: Ranking functions, changes for windowing in the Aggregate functions and the new Analytic functions. We’ll examine how this latest implementation of the windowing functions allows us to perform running and sliding aggregations; retrieve data from adjacent rows in the partition, and much more – all without self-joins back to the source table.
Speaker(s): Wayne Sheffield,
Abstract:
Business Intelligence tools make it easy to create reports that let your users absorb information quickly and easily, but what can you do to make it easy for the BI tools, and their developers, process information from your data warehouse quickly and easily? Learn about how to shape your data to work with Tableau's Measures.
Speaker(s): Jennifer Kenney,
Abstract:
We will have a conversation of what is APS and specifically how it differs from the normal SQL Server instances we work with daily. By the end of this talk, you will have a very good understanding of the differences between the APS' MPP architecture compared to SMP SQL Server. We will cover the topic of Polybase and what Hadoop Components are supported by Polybase.
Speaker(s): Warren Sifre,
Abstract:
It is difficult enough to implement database security when dealing with only a single database. If multiple databases are involved, the task of providing a security model that follows industry best practices seems insurmountable. In this session, we will do a quick review of access security best practices and then dive into the four different methods a DBA can use to tighten cross database access security. For each one we will walk through a demo and talk about how to implement it in your own environment. We will close the session with a discussion about the advantages and disadvantages of the four methods.
Speaker(s): Sebastian Meine,
Abstract:
SharePoint, the 800-pound gorilla that has probably eaten a great deal of space on your SQL Server, has certain consistent idiosyncrasies that can make trouble for a DBA. This session will go over some of the problems SharePoint frequently causes, or that you may encounter in managing databases for it.
Speaker(s): Alara Rogers,
Abstract:
We will start with basic reporting services report and work up to intermediate level. If time allows, we will cover some advance feature. We will also cover some "Gotchas" as we move along. The session will be heavily demo based.
Speaker(s): Ravi Kumar,
Abstract:
Do you have a query that you want to tune, but don't know where to start? Execution plans can be a great starting point for understanding what your query is doing under the hood. This course covers the bare bones basics: what an execution plan is, how to run them, how to read them, 5 common troublemakers, and where to learn more. If an execution plan looks like hieroglyphics, this course is for you!
Speaker(s): Eugene Meidinger,
Abstract:
Just because NoSQL is taking off doesn't mean that SQL developers are left behind. We'll begin with an overview of what MongoDB and NoSQL is and how it relates to our existing world of SQL. Then, we'll go over some of terminology in MongoDB and how these terms map to the SQL world. Lastly, we'll demonstrate how we can work with MongoDB from SSIS.
Speaker(s): Ben Galluzzo,
Abstract:
Sponsor Session
Speaker(s): Event Sponsor,
Abstract:
Using everyday tools, some free and some paid, you and the developers working with you might begin to feel out of sync in your efforts, over time. In this session, we'll review both tools and some suggested guidelines to help close the gap between today and where you want to be with the developers around you, whether that's immediate and technical or longer term and relational, or both.
Speaker(s): Brad McKuhen,
Abstract:
SQL Clinic is an open board discussion lead by couple of Microsoft field engineers. If you have any SQL related problem or question, you can go there and ask and get an answer for free. If you do not have problems or questions you can just stay there and learn what kind of problems other people have in their environments.
Speaker(s): Harsh Deep Singh,
Abstract:
Explore some of the mistakes and misconceptions DBAs tend to have about SSIS. Also look at the performance and scalability of ETL vs ELT with real world examples and sample code.
Speaker(s): Paul Rizza,
Abstract:
John knows everything and goes out of his way to correct you at every turn. Mary is agreeable to a fault and just placates everyone. Mike is full of doom and gloom and whines constantly. Are these your co-workers? Relatives? Frenemies? You? Learn two golden rules to reduce the stress produced by the difficult people in your life.
Speaker(s): Gigi Bell,
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://www.linkedin.com/in/timmitchell/
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
LinkedIn: http://www.linkedin.com/in/davidepatrick
Contact: http://www.madsharepoint.com
Dave has been developing database applications for over 25 years. An MCT since 2001, he has taught many classes from Intro to Visual Interdev to Advanced SharePoint Development. Dave runs two user groups, the Maryland and Pennsylvania Microsoft Developers User Group, www.mapamdug.com, and MAD SharePoint, www.madsharepoint.com. Dave does SharePoint training and development for DSA, Inc., a DoD contractor that does great work for the Army over at Aberdeen Proving Ground. Dave is also an MVP.
Contact: http://www.liquidmercurysolutions.com
Principal Analyst | Liquid Mercury Solutions Alara Rogers is commonly believed to be a brain in a tank, but this is in fact not true; she is a space alien. Alara entered the world of IT via database marketing and analytics on consumer demographic databases stored on mainframes, but soon discovered the joy of SQL Server, and has focused on BI, SQL development, and SharePoint as a platform for BI ever since.
LinkedIn: http://www.linkedin.com/in/prizza/
Contact: http://blogs.msdn.com/b/paulrizza/
Paul Rizza is a Senior Consultant at Microsoft Consulting Services (MCS), Lead on the MCS SQL Hiring Team, and has over 25 years’ experience consulting, teaching and developing on SQL Server platforms. Paul’s expertise includes ETLs, Dimensional modeling, architecting highly available SQL environments and performance tuning. Paul has an Undergraduate degree from UMBC and a Master’s degree both in Computer Science with a concentration in Database Theory from Johns Hopkins University.
LinkedIn: https://www.linkedin.com/profile/view?id=131567172
Contact: http://blogs.msdn.com/b/sqljourney/
HarshDeep Singh is a SQL Server Premier Field Engineer for Microsoft in the North America region. He has worked extensively on SQL Server with various Microsoft customers. He contributes to the community by speaking at technical events, as well as through his blog (http://blogs.msdn.com/b/sqljourney/).
LinkedIn: http://www.linkedin.com/pub/ben-galluzzo/20/7b9/389/en
Contact: http://www.bengalluzzo.com/
I#39;m a software developer with a passion for anything that beeps and blinks. I first delved into databases on an Atari 800XL, and I never stopped looking forward since. I often have my hands in everything from databases and software to circuits and embedded systems. When I#39;m not beeping or blinking, I#39;m often spending time with my family, woodworking, building things, or outdoors.
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
LinkedIn: http://www.linkedin.com/in/dxclark/
Contact: http://drclarkblog.wordpress.com/
Dan Clark is a senior data analytics consultant. He is focused on all things data analytics and training others how to get value from their data. Dan has published several books and numerous articles on .NET programming and data analytics. He is a regular speaker at various developer and database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. His latest book Beginning Power BI published by Apress is a will get you up and running with self-service data analytics on the Power BI platform in no time.
Contact: http://www.bradmckuhen.com
Brad McKuhen is a SQL Server Architect for Microtech Technologies, in the Washington, DC area. He has been working with SQL Server in some form or another since SQL Server 2000, and has been in IT for over 20 years. In his spare time, you#39;ll find him devoted to his family#39;s activities, and studying for the next certification.
LinkedIn: http://www.linkedin.com/pub/samuel-vanga/60/385/551
Contact: http://SamuelVanga.com
Sam Vanga helps business people solve their data problems and enables them make data-driven-decisions. His specialties include data integration, data warehouse and database development, and BI design. Sam blogs at http://SamuelVanga.com.
LinkedIn: http://www.linkedin.com/pub/christopher-bell/19/a08/93/
Contact: https://www.wateroxconsulting.com/
Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do 'Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris' thoughts and technical community activities at WaterOxConsulting.com.
LinkedIn: http://www.linkedin.com/pub/ben-galluzzo/20/7b9/389/en
Contact: http://www.bengalluzzo.com/
I#39;m a software developer with a passion for anything that beeps and blinks. I first delved into databases on an Atari 800XL, and I never stopped looking forward since. I often have my hands in everything from databases and software to circuits and embedded systems. When I#39;m not beeping or blinking, I#39;m often spending time with my family, woodworking, building things, or outdoors.
LinkedIn: https://www.linkedin.com/in/gehan-bell-bab55293
Known across the country as the SQL Registration Princess, Gigi Bell actually has vast experience in training and development. Being married to a SQL DBA, she knows enough about SQL to be dangerous, but her real passion is helping people learn and achieve their true potential. She has spoken at SQLSaturdays across the country since 2014.
Created to speak for sponsor#39;s at the event in Baltimore
Az Arunachalam has been working with SQL server since v4.21/SQLNT. He started his career with troubleshooting at chip level, worked as a network engineer managing Novell NetWare networks, graduated into managing Windows NT, moved onto development, administered databases, and is currently working as a database architect. He#39;s excited about all the cloud offerings that Microsoft and others have made possible, and in sharing his findings with aspiring data enthusiasts.
LinkedIn: https://www.linkedin.com/in/jamiewick/
Contact: http://blog.wicktech.net
Jamie Wick is the Systems Database Engineer for The College of William Mary and has been working with SQL databases for the past 10+ years. His background includes working for several years as a SQL SysAdmin for the University of Queensland (Australia), a Masters degree in Computer Information Systems from Boston University, and assorted Microsoft SQL certifications. He is the Chapter Leader of the Richmond SQL Server Users Group, a volunteer and speaker at regional SQL events (User Groups/SQLSaturdays), helps run the SQLSaturday RVA events, and is an avid photographer.
Created to speak for sponsor#39;s at the event in Baltimore
I have over 12 years of experience working with SQL Server and Business Intelligence Technology. My current focus is cloud technologies: Power BI, Azure Analysis Services, Azure SQL Data Warehouse, Azure Data Factory. As a PFE at Microsoft, I regularly deliver 2 - 4 day training workshops.
Jennifer Kenney has been with CapTech Consulting for two years, specializing in Data Architecture with Microsoft SQL Server. She has fifteen years of experience with SQL Server. During that time, she's worked with querying transactional databases, modeling both transactional databases and data warehouses, data integration into both transactional databases and data warehouses, change management, and administration. Jennifer lives in Goochland, VA with her husband Brian and their beagles.
LinkedIn: https://www.linkedin.com/in/timmitchell/
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
LinkedIn: https://www.linkedin.com/profile/view?id=131567172
Contact: http://blogs.msdn.com/b/sqljourney/
HarshDeep Singh is a SQL Server Premier Field Engineer for Microsoft in the North America region. He has worked extensively on SQL Server with various Microsoft customers. He contributes to the community by speaking at technical events, as well as through his blog (http://blogs.msdn.com/b/sqljourney/).
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
Created to speak for sponsor#39;s at the event in Baltimore
Brian is Regional Sales Director responsible for driving sales and onboarding new customers in PA, NJ, NY, DE, MD, and DC for Profisee. Profisee is the successor to the company Stratature that built the SQL Server Master Data Services (MDS) product which Microsoft acquired in 2007. Profisee focuses on Master Data Management (MDM) and is a Microsoft Gold ISV Partner providing solutions built on MDS. Brian was formerly with Microsoft Corporation as a Senior Account Manager for 7 years.
Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQLSaturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.
Contact: http://www.captechconsulting.com/
Philip Noakes is a data integration specialist with experience in all facets of SQL Server. He has been with CapTech Consulting for the last nine years and is an MCITP in SQL Server Business Intelligence. Philip hails from the Short Pump area where he lives with his wife and 2 daughters.
LinkedIn: http://www.linkedin.com/in/WayneSheffield
Contact: http://blog.waynesheffield.com/wayne
Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne
Contact: http://www.sqlgene.com
Eugene Meidinger works as a BI consultant and full time Pluralsight author. He currently focuses on content on Power BI and related products. He also leads the Pittsburgh Power BI User Group. He is certified in querying and administering SQL Server.
Created to speak for sponsor#39;s at the event in Baltimore
LinkedIn: http://www.linkedin.com/in/aymansqldba
Contact: http://www.thesqlpro.com
Ayman is a passionate SQL Server DBA, Developer, and BI Developer. His passion for technology started when he was a young boy playing DOS games on his father's computer. He can be reached via his blog or twitter handle and is looking forward to connecting with other SQL Geeks.
LinkedIn: http://www.linkedin.com/pub/timothy-mcaliley/10/530/787/
I am currently a Microsoft Cloud Solutions Architect in the Washington, DC area. Previously, I was a Microsoft Technology Solutions Professional (TSP), a Microsoft Account Technology Strategist and a SQL Server Premier Field Engineer. Prior to Microsoft, I was a Technical Trainer and DBA in the Enterprise Security Group at Symantec . I have been in IT for over 20 years. My particular interests are IT operations, IT auditing, IT audit frameworks, IT service management (ITSM), ITIL, information security, project management, and database/application tier high availability solutions. I also co-run the Northern Virginia SQL Server User Group ( @novasl) and also co-run the Azure Datafest events.
LinkedIn: https://www.linkedin.com/profile/view?id=131567172
Contact: http://blogs.msdn.com/b/sqljourney/
HarshDeep Singh is a SQL Server Premier Field Engineer for Microsoft in the North America region. He has worked extensively on SQL Server with various Microsoft customers. He contributes to the community by speaking at technical events, as well as through his blog (http://blogs.msdn.com/b/sqljourney/).
I am a Business Intelligence developer, having transitioned over from transactional systems a few years ago. I find business use of data extremely fascinating. I have recently moved to Baltimore, and I love life here.
LinkedIn: http://www.linkedin.com/in/sebastianmeine
Contact: http://sqlity.net/en/blog/
Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.
LinkedIn: http://www.linkedin.com/in/wsifre
Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com
Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.
The following is a list of sponsors that helped fund the event.


Author: {{quote.author}}
Submitted by: {{quote.submittedBy}}
Posted : {{quote.completeDate|dayCount}} Days ago


2.2.0
Create a new instance of the YeelightSearch class and start searching for new Yeelights once a Yeelight has been found it will create an Yeelight instance and emits the 'found' event light the Yeelight instance as payload
Extends EventEmitter
adds a new light to the lights array
(any)
refresh lights sending a new m-search
Class Yeelight provides all functionality
Extends EventEmitter
(any)
(object)
{
LOCATION: 'yeelight://<IP_ADDRESS>:55443',
ID: '0x0000000000000000',
SUPPORT: 'get_prop set_default set_power toggle set_bright start_cf stop_cf set_scene cron_add cron_get cron_del set_ct_abx set_rgb set_hsv set_adjust set_music set_name',
NAME: 'Living Room',
MODEL: 'color',
}
This method is used to retrieve current property of smart LED.
(array)
The parameter is a list of property names and the response contains
a list of corresponding property values. If the requested property name is not recognized by
smart LED, then a empty string value ("") will be returned.
Promise
:
will be invoked after successfull or failed send
getValues('power', 'bright');
Will change the color temperature of the Yeelight
(string)
is the target color temperature. The type is integer and
range is 1700 ~ 6500 (k).
(string
= 'smooth'
)
support two values: 'sudden' and 'smooth'. If effect is 'sudden',
then the color temperature will be changed directly to target value, under this case, the
third parameter 'duration' is ignored. If effect is 'smooth', then the color temperature will
be changed to target value in a gradual fashion, under this case, the total time of gradual
change is specified in third parameter "duration".
(number
= 1000
)
time specifies the total time of the gradual changing. The unit is
milliseconds. The minimum support duration is 30 milliseconds.
Promise
:
will be invoked after successfull or failed send
setColorTemperature(5000);
setColorTemperature(5000, 'sudden');
setColorTemperature(5000, 'smooth', 1000);
This method is used to change the brightness of a smart LED.
(string)
is the target brightness. The type is integer and ranges
from 1 to 100. The brightness is a percentage instead of a absolute value. 100 means
maximum brightness while 1 means the minimum brightness.
(string
= 'smooth'
)
Refer to 'setColorTemperature' method.
(number
= 1000
)
Refer to 'setColorTemperature' method.
Promise
:
will be invoked after successfull or failed send
setBrightness(25);
setBrightness(25, 'sudden');
setBrightness(25, 'smooth', 1000);
This method is used to switch on the smart LED (software managed on/off).
(string
= 'smooth'
)
Refer to 'setColorTemperature' method.
(number
= 1000
)
Refer to 'setColorTemperature' method.
Promise
:
will be invoked after successfull or failed send
turnOn();
turnOn('sudden');
turnOn('smooth', 1000);
This method is used to switch off the smart LED (software managed on/off).
(string
= 'smooth'
)
Refer to 'setColorTemperature' method.
(number
= 1000
)
Refer to 'setColorTemperature' method.
Promise
:
will be invoked after successfull or failed send
turnOff();
turnOff('sudden');
turnOff('smooth', 1000);
This method is used to set the smart LED directly to specified state. If + the smart LED is off, then it will turn on the smart LED firstly and then apply the specified command.
(array)
can be "color", "hsv", "ct", "cf", "auto_dealy_off".
Promise
:
will be invoked after successfull or failed send
setScene(['color', 65280, 70]);
setScene(['hsv', 300, 70, 100]);
setScene(['ct', 5400, 100]);
setScene(['cf', 0, 0, '500,1,255,100,1000,1,16776960,70']);
This method is used to change the color of a smart LED.
(string)
is the target color, whose type is integer.
It should be expressed in hex 0xFFFFFF.
(string
= 'smooth'
)
Refer to 'setColorTemperature' method.
(number
= 1000
)
Refer to 'setColorTemperature' method.
Promise
:
will be invoked after successfull or failed send
setRGB('#ffffff');
setRGB('#ffffff', 'sudden');
setRGB('#ffffff', 'smooth', 1000);
This method is used to change the color of a smart LED.
(string)
"hue" is the target hue value, whose type is integer.
It should be expressed in decimal integer ranges from 0 to 359.
(string)
is the target saturation value whose type is integer.
It's range is 0 to 100.
(string
= 'smooth'
)
Refer to 'setColorTemperature' method.
(number
= 1000
)
Refer to 'setColorTemperature' method.
Promise
:
will be invoked after successfull or failed send
setHSV(100, 50);
setHSV(100, 50, 'sudden');
setHSV(100, 50, 'smooth', 1000);
This method is used to change brightness, CT or color of a smart LED without knowing the current value, it's main used by controllers.
(string)
the direction of the adjustment. The valid value can be:
(string)
the property to adjust. The valid value can be:
Promise
:
will be invoked after successfull or failed send
setAdjust('increase', 'bright');
This method is used to start or stop music mode on a device. Under music mode, no property will be reported and no message quota is checked.
(number)
the action of set_music command. The valid value can be:
(string)
the IP address of the music server.
(string)
the TCP port music application is listening on
Promise
:
will be invoked after successfull or failed send
setMusicMode(0, '<IP_ADDRESS>', 4000);
This method is used to start a color flow. Color flow is a series of smart LED visible state changing. It can be brightness changing, color changing or color temperature changing.
(number)
is the total number of visible state changing
before color flow stopped. 0 means infinite loop on the state changing.
(string)
is the action taken after the flow is stopped.
(string)
is the expression of the state changing series.
Promise
:
will be invoked after successfull or failed send
startColorFlow(4, 2, '1000, 2, 2700, 100, 500, 1, 255, 10, 500, 2, 5000, 1');


Lack of comprehensive performance and rehabilitation analytics
Ineffective remote training and low athlete/trainer engagement
Player downtime due to injuries and lengthy rehabilitation
From the International Space Station to the NFL
Beginning with work conducted at NASA and national research labs, Cobalt’s Robotic Exercise Device leverages engineering design, scientific method, computer science, and health and human performance to create a safe and data-rich strength training device. This revolutionary development harnesses the power of robotics and artificial intelligence to change the way athletes are trained and rehabilitated.
The Robotic Exercise Device will optimize physiological performance of elite athletes across a wide range of professional franchises.


|
Reis
0.0.1
Reis is a cross-platform 2D game engine writen in C++/SDL.
|
Wrapper to manipulate keyboard, mouse and up to 4 (four) controller inputs. More...
#include <Input.h>
Public Member Functions | |
| void | init () |
| Init keyboard, mouse and controller inputs. Internal use only, don't call this method. | |
| void | free () |
| Clear inputs. Internal use only, don't call this method. | |
| void | update () |
| Update input entries. Internal use only, don't call this method. More... | |
| void | clear () |
| Clear input entries for the next update. Internal use only, don't call this method. | |
| bool | isKeyPressed (SDL_Scancode key) |
| Tells if the keyboard key is pressed. More... | |
| bool | isKeyReleased (SDL_Scancode key) |
| Tells if the keyboard key is released. More... | |
| bool | isKeyDown (SDL_Scancode key) |
| Tells if the keyboard key is currently being pressed. More... | |
| bool | isKeyPressed (KeyboardKey key) |
| Tells if the keyboard key is pressed. More... | |
| bool | isKeyReleased (KeyboardKey key) |
| Tells if the keyboard key is released. More... | |
| bool | isKeyDown (KeyboardKey key) |
| Tells if the keyboard key is currently being pressed. More... | |
| bool | isMousePressed (Uint8 button) |
| Tells if the mouse button was pressed. More... | |
| bool | isMouseReleased (Uint8 button) |
| Tells if the mouse button was released. More... | |
| bool | isMouseDown (Uint8 button) |
| Tells if the mouse button is currently being pressed. More... | |
| bool | isMousePressed (MouseButton button) |
| Tells if the mouse button was pressed. More... | |
| bool | isMouseReleased (MouseButton button) |
| Tells if the mouse button was released. More... | |
| bool | isMouseDown (MouseButton button) |
| Tells if the mouse button is currently being pressed. More... | |
| int | getMouseX () |
| Returns the current mouse X position. More... | |
| int | getMouseY () |
| Returns the current mouse Y position. More... | |
| bool | isMouseInside (int x, int y, int w, int h) |
| Tells if the mouse is currently inside the specified rectangle. More... | |
| bool | isMouseInside (SDL_Rect *box) |
| Tells if the mouse is currently inside the specified rectangle. More... | |
| bool | isMouseMoving () |
| Tells if the mouse is currently inside the specified rectangle. More... | |
| bool | isMouseMovingRight () |
| Tells if the mouse is moving right relative to the screen. More... | |
| bool | isMouseMovingLeft () |
| Tells if the mouse is moving left relative to the screen. More... | |
| bool | isMouseMovingUp () |
| Tells if the mouse is moving up relative to the screen. More... | |
| bool | isMouseMovingDown () |
| Tells if the mouse is moving down relative to the screen. More... | |
| bool | isControllerPressed (Uint8 button, int controller=0) |
| Tells if the controller button was pressed. More... | |
| bool | isControllerReleased (Uint8 button, int controller=0) |
| Tells if the controller button was released. More... | |
| bool | isControllerDown (Uint8 button, int controller=0) |
| Tells if the controller button is currently being pressed. More... | |
| bool | isControllerPressed (ControllerButton button, int controller=0) |
| Tells if the controller button was pressed. More... | |
| bool | isControllerReleased (ControllerButton button, int controller=0) |
| Tells if the controller button was released. More... | |
| bool | isControllerDown (ControllerButton button, int controller=0) |
| Tells if the controller button is currently being pressed. More... | |
| bool | isControllerPressed (ControllerAxis button, int controller=0) |
| Tells if the controller axis was pressed. More... | |
| bool | isControllerReleased (ControllerAxis button, int controller=0) |
| Tells if the controller axis was released. More... | |
| bool | isControllerDown (ControllerAxis button, int controller=0) |
| Tells if the controller axis is currently being pressed. More... | |
| int | getNumControllers () |
| Get total number of open game controllers. More... | |
| float | getSensibility () |
| Get current game controller axis sensibility. More... | |
| void | setSensibility (float new_sensi) |
| Change current game controller axis sensibility. More... | |
| int | getLeftAnalogDirX () |
| Get game controller Left Analog direction X. More... | |
| int | getRightAnalogDirX () |
| Get game controller Right Analog direction X. More... | |
| int | getLeftAnalogDirY () |
| Get game controller Left Analog direction Y. More... | |
| int | getRightAnalogDirY () |
| Get game controller Right Analog direction Y. More... | |
| bool | quitRequested () |
| Check if the user asked the game to quit (Alt+F4 or SDL quit). Use as a shortcut. More... | |
| void | lockInput (InputType peripheral=InputType::ALL_INPUTS) |
| Lock a game input. More... | |
| void | unlockInput (InputType peripheral=InputType::ALL_INPUTS) |
| Unlock a game input. More... | |
| void | unlockController (int controller) |
| Unlock only a specific game controller. More... | |
| bool | isLocked (int controller) |
| Check if a specific game controller is locked. More... | |
Wrapper to manipulate keyboard, mouse and up to 4 (four) controller inputs.
| int Input::getLeftAnalogDirX | ( | ) |
Get game controller Left Analog direction X.
| int Input::getLeftAnalogDirY | ( | ) |
Get game controller Left Analog direction Y.
| int Input::getMouseX | ( | ) |
Returns the current mouse X position.
| int Input::getMouseY | ( | ) |
Returns the current mouse Y position.
| int Input::getNumControllers | ( | ) |
Get total number of open game controllers.
| int Input::getRightAnalogDirX | ( | ) |
Get game controller Right Analog direction X.
| int Input::getRightAnalogDirY | ( | ) |
Get game controller Right Analog direction Y.
| float Input::getSensibility | ( | ) |
Get current game controller axis sensibility.
| bool Input::isControllerDown | ( | Uint8 | button, |
| int | controller = 0 |
||
| ) |
Tells if the controller button is currently being pressed.
| [in] | button | SDL controller button. |
| [in] | controller | ID of the controller. |
| bool Input::isControllerDown | ( | ControllerButton | button, |
| int | controller = 0 |
||
| ) |
Tells if the controller button is currently being pressed.
| [in] | button | Controller button. |
| [in] | controller | ID of the controller. |
| bool Input::isControllerDown | ( | ControllerAxis | button, |
| int | controller = 0 |
||
| ) |
Tells if the controller axis is currently being pressed.
| [in] | button | Controller axis. |
| [in] | controller | ID of the controller. |
| bool Input::isControllerPressed | ( | Uint8 | button, |
| int | controller = 0 |
||
| ) |
Tells if the controller button was pressed.
| [in] | button | SDL controller button. |
| [in] | controller | ID of the controller. |
| bool Input::isControllerPressed | ( | ControllerButton | button, |
| int | controller = 0 |
||
| ) |
Tells if the controller button was pressed.
| [in] | button | Controller button. |
| [in] | controller | ID of the controller. |
| bool Input::isControllerPressed | ( | ControllerAxis | button, |
| int | controller = 0 |
||
| ) |
Tells if the controller axis was pressed.
| [in] | button | Controller axis. |
| [in] | controller | ID of the controller. |
| bool Input::isControllerReleased | ( | Uint8 | button, |
| int | controller = 0 |
||
| ) |
Tells if the controller button was released.
| [in] | button | SDL controller button. |
| [in] | controller | ID of the controller. |
| bool Input::isControllerReleased | ( | ControllerButton | button, |
| int | controller = 0 |
||
| ) |
Tells if the controller button was released.
| [in] | button | Controller button. |
| [in] | controller | ID of the controller. |
| bool Input::isControllerReleased | ( | ControllerAxis | button, |
| int | controller = 0 |
||
| ) |
Tells if the controller axis was released.
| [in] | button | Controller axis. |
| [in] | controller | ID of the controller. |
| bool Input::isKeyDown | ( | SDL_Scancode | key | ) |
Tells if the keyboard key is currently being pressed.
| [in] | key | SDL key code. |
| bool Input::isKeyDown | ( | KeyboardKey | key | ) |
Tells if the keyboard key is currently being pressed.
| [in] | key | Key code. |
| bool Input::isKeyPressed | ( | SDL_Scancode | key | ) |
Tells if the keyboard key is pressed.
| [in] | key | SDL key code. |
| bool Input::isKeyPressed | ( | KeyboardKey | key | ) |
Tells if the keyboard key is pressed.
| [in] | key | Key code. |
| bool Input::isKeyReleased | ( | SDL_Scancode | key | ) |
Tells if the keyboard key is released.
| [in] | key | SDL key code. |
| bool Input::isKeyReleased | ( | KeyboardKey | key | ) |
Tells if the keyboard key is released.
| [in] | key | Key code. |
| bool Input::isLocked | ( | int | controller | ) |
Check if a specific game controller is locked.
| [in] | controller | ID of the controller. |
| bool Input::isMouseDown | ( | Uint8 | button | ) |
Tells if the mouse button is currently being pressed.
| [in] | key | SDL button code. |
| bool Input::isMouseDown | ( | MouseButton | button | ) |
Tells if the mouse button is currently being pressed.
| [in] | key | Mouse button code. |
| bool Input::isMouseInside | ( | int | x, |
| int | y, | ||
| int | w, | ||
| int | h | ||
| ) |
Tells if the mouse is currently inside the specified rectangle.
| [in] | x | Rectangle start position X. |
| [in] | y | Rectangle start position Y. |
| [in] | w | Rectangle width. |
| [in] | h | Rectangle height. |
| bool Input::isMouseInside | ( | SDL_Rect * | box | ) |
Tells if the mouse is currently inside the specified rectangle.
| box | SDL Rectangle. |
| bool Input::isMouseMoving | ( | ) |
Tells if the mouse is currently inside the specified rectangle.
| box | Shape object Rectangle. |
| bool Input::isMouseMovingDown | ( | ) |
Tells if the mouse is moving down relative to the screen.
| bool Input::isMouseMovingLeft | ( | ) |
Tells if the mouse is moving left relative to the screen.
| bool Input::isMouseMovingRight | ( | ) |
Tells if the mouse is moving right relative to the screen.
| bool Input::isMouseMovingUp | ( | ) |
Tells if the mouse is moving up relative to the screen.
| bool Input::isMousePressed | ( | Uint8 | button | ) |
Tells if the mouse button was pressed.
| [in] | key | SDL button code. |
| bool Input::isMousePressed | ( | MouseButton | button | ) |
Tells if the mouse button was pressed.
| [in] | key | Mouse button code. |
| bool Input::isMouseReleased | ( | Uint8 | button | ) |
Tells if the mouse button was released.
| [in] | key | SDL button code. |
| bool Input::isMouseReleased | ( | MouseButton | button | ) |
Tells if the mouse button was released.
| [in] | key | Mouse button code. |
| void Input::lockInput | ( | InputType | peripheral = InputType::ALL_INPUTS | ) |
Lock a game input.
Take care while using this since disconnecting/connecting controllers will cause to automaticaly lock/unlock the controller. Put it preferably inside update functions.
| [in] | peripheral | Game input to be locked. Lock all inputs if left empty. |
| bool Input::quitRequested | ( | ) |
Check if the user asked the game to quit (Alt+F4 or SDL quit). Use as a shortcut.
| void Input::setSensibility | ( | float | new_sensi | ) |
Change current game controller axis sensibility.
| [in] | new_sensi | { parameter_description } |
| void Input::unlockController | ( | int | controller | ) |
Unlock only a specific game controller.
| [in] | controller | ID of the controller. |
| void Input::unlockInput | ( | InputType | peripheral = InputType::ALL_INPUTS | ) |
Unlock a game input.
Take care while using this since disconnecting/connecting controllers will cause to automaticaly lock/unlock the controller. Put it preferably inside update functions.
| [in] | peripheral | Game input to be unlocked. Unlock all inputs if left empty. |
| void Input::update | ( | ) |
Update input entries. Internal use only, don't call this method.
This alg has given me a little trouble.
Axis are only recognized while in motion, knowing that (and to avoid threating SDL_GameControllers outside events), I also placed an interface for the axis movement here.
Check in which direction it is moving.
If the Axis is moving above the positive Dead Zone then it's moving right (1) or else it's moving left (-1).


CHANGE OF TAX
Rangers tax case – EBT expert says HMRC hasn’t ‘blundered’, Oldco isn’t due money and taxman didn’t cause liquidation
by Aidan ScottA LEADING EBT expert insists it’s wrong to say an HMRC ‘blunder’ caused the financial implosion that sent Rangers spiralling into liquidation.
A bombshell report in The Times stated that as much as £50million could be wiped from the total tax bill owed by Gers’ old operating company.
It is also claimed that the final EBT bill could be as low as £20m and if this figure was known back in 2011 the club would never have been plunged into financial turmoil.
A tweet from HMRC's official account read: "As widely reported today and to clarify: HMRC won against Rangers’ tax avoidance in the Supreme Court, and did not miscalculate anything."
SunSport asked Thomas Wallace, who is Head of Tax at London-based firm WTT, to look at these claims and give an independent assessment of what it all means for Oldco Rangers and its creditors.
In an extensive Q&A Mr Wallace, who spent years working for HMRC and has spent the last 24 months fighting on behalf of companies embroiled in EBT disputes with the taxman, answers 18 key questions and says:
- - HMRC have NOT made any serious mistakes in the case
- - The taxman DIDN’T cause Rangers’ liquidation
- - Oldco Gers AREN’T due any money back from the treasury
1. Has the taxman actually admitted to making any mistakes?
Whilst I would certainly say that HMRC is more than capable of making mistakes, it is difficult to see how they have here.
Whilst charging a 65% penalty needs HMRC to prove deliberate behaviour which is a very high bar where a taxpayer has taken suitable qualified advice as to their position, what has most likely happened is that HMRC have taken an unusually pedantic step of recognising that even if they were to pursue both the quantum of the assessment and the penalty levied back through the Courts, there will still be insufficient assets in the liquidation to gain any more than what they will on the new agreed basis.
2. Ally McCoist believes Rangers wouldn't have gone bust if it was known in 2012 that the final tax bill would be lower - do you agree?
I have to say I think that is incorrect given that the liquidation, even after these adjustments, is still only offering pennies in the pound to creditors.
3. Are Oldco Rangers due money back from the taxman?
No, because the liability had never actually been paid.
4. The £24m penalty figure in the original overall bill of around £94m had never been confirmed by any legal process - but was it a mistake by HMRC to originally ask for this? Why would they now drop the claim?
A penalty is charged in terms of a percentage, in this case 65%.
Therefore it cannot be levied until the final additional tax is agreed but I suspect it was lodged as a protective claim in the liquidation.
The legal process was still open to challenge this through the Courts but as I said above, I suspect there are sound commercial benefits of not pursuing the penalty where no funds are available to pay it regardless of outcome.
5. The Times article says up to £50m is set to be wiped off the tax bill. How likely is this, and what would you estimate the final reduction to be?
I can’t comment without hard figures around some of the variables but I think the important part is that in reality, whether £50m, £30m or £10m, HMRC were never getting that money. It just doesn’t exist.
6. A letter from HMRC says they are dropping the £24m penalty charge because 'there is no evidence of fraudulent or negligent behaviour'. So has the taxman over-reached himself by making the £24m claim? Why would they use such language if they still had a case?
Penalties are calculated on behaviour with the highest reserved for the most offensive conduct. Whilst I suspect HMRC may have overplayed its hand seeking a penalty of such a high threshold, it may have replaced it with a lessor one had there been funds available to pay it. As it is, another 5 years of litigation would produce no additional money for the treasury.
7. A further £2m worth of claims were overstated by HMRC and the figure has now been wiped off the original bill. Why would HMRC overstate figures?
I am not sure what this relates to, but again, I suspect it is more administrative in light of no funds being available to pay regardless.
8. Is it right to say HMRC could still pursue the full amount or close to it if they wanted, but have simply decided it's not worth the hassle?
Correct
9. Given that BDO won a reduction of unpaid tax to £68.3m in September 2018, what has actually changed now?
That is unclear until the next liquidation report is published.
10. How much money does Rangers Oldco actually now owe to HMRC?
Again, until the latest liquidation report becomes available all we know formally is that the penalty has been withdrawn (c£24m).
11. The Times claims £12m of interest charges is likely to be reduced "significantly". How likely is this, and by how much?
Interest is calculated on the tax not paid from when it should have been until when it is. As such if the underlying tax is reduced, the interest naturally reduces as a function.
12. So if HMRC do lose out on interest is it because they have lost the argument?
I believe it is because the pot available in liquidation is already exhausted and therefore there is no material financial benefit for HMRC to continue pursuit.
13. Will creditors now expect an improved return?
Improved, yes, but not substantially. The latest liquidators report shows that to that date an interim dividend of 3.91p in the £ had been paid, amounting to £1,365,856.
It then states that with the HMRC provision reduced by £30m, an additional £1m is available to creditors.
14. Who is the big winner from this development?
The creditors clearly come out of this in an improved position, but I’m not sure anyone is a big winner.
 Rangers and Celtic fans bombard HMRC after taxman asks for 'general queries'
CASH DROP Rangers players 'have EBT penalties wiped out'
TRANSFER FEARS Boumsong's transfer to Newcastle was start of financial collapse
AN ISSUE OF TRUST What is an EBT, why did club use them and who all got one?
I am not aware that any player had the liability transferred to them, and therefore none to my knowledge suffered the tax or penalty.
This is in contrast to the thousands of EBT users who have been personally pursued by HMRC over the years.
16. What if they have gone bankrupt as a result, could they take legal action?
Possible, but an insolvency practitioner is best placed to answer this.
17. Could Oldco Rangers and Newco Rangers join forces if it was beneficial to club?
Hard to see how that could be done in law, they are two separate entities.
18. Could Sir David Murray or anyone else involved in the dispute sue HMRC, and how likely is it they would be successful?
This is a legal question more than tax, but I struggle to understand why as he has not suffered any personal financial loss.


We currently use iterable and key/value differs to track changes to allow mutable changes to the bound objects/arrays. This can become inefficient for large layer arrays because we have to compare the contents of the arrays to tell if they are different.
There are several strategies for mitigating this performance impact if it becomes an issue:
LayerGroup
layers to keep the bound array size small.
But, this will be difficult to manage
This example shows how to use OnPush to improve change detection efficiency. See the README for more details.


You received this email to {{ recipient.email }} because you subscribed to email notifications on bacongamejam.org. If you don't want to receive further emails, you can turn these off on your profile page. Your username was {{ recipient.username }}.
All times are UTC/GMT.


the and HCV HIV were with for strains are that viral {background sequences study from virus was diversity N = hepatitis identified The URF this margin {border-style genotypes specimens PWID px;} recombinant #ffffff;} (Fig. IN-D India genotype not these also (.%), all sequence region samples testing treatment (). India, Table amongst cities each found resistance subtype using HIV- India. Northeastern circulating have pol prevalence which assay classification classifications env human infection load mutations patients px; recombination strain unique {font-family (.%) (Table Delhi IDR India: New RNA antigen been city diagnostic font-size most one people present regions sequencing (%) CRF Kanpur URFs Virus clinical common double; drug epidemiology higher included molecular positive recombinants reference shown volume where who within .%) ARCHITECT Abbott Aizawl Although Central Hepatitis INSTI Imphal Indian among border-color border-width both chronic conducted core could detection diverse identified. large numbers only participants previously quantification research site solid; sufficient than type unclassifiable {font-style {font-weight (Abbott AIDS All Amritsar CRF_AE Clinical Commons Creative Diagnostics, Figure Genbank Group Health Hopkins IL, MN-MN, North Notably, Phylogenetic This Total USA). accession across although approved available bold bootstrap branches characterization co-infected consistent courier; different drugs em; first five full genetics has identify immunodeficiency impact inject least less likely log majority more official other phylogenetic plasma prepared provided pt;} publication remains results review screened serological sites specimen study. subgenomic subset surveillance systematic tested total trees


IT'S MY PARTY A film review by Ben Hoffman Copyright 1996 Ben Hoffman
This is one party to which you may wish to bring along Kleenex. It's about AIDS and about someone who is about to die as the fatal day approaches. Nick Stark (Eric Roberts) is an architect, handsome, healthy-looking, personable and with a great sense of humor. Unlike most cases where the AIDS virus has withered the ill person with lost weight, pain, etc., Nick's has attacked his brain. His doctor has told him that in two days his vision, already beginning to blur, will disappear and he will go into a coma until he dies.
But Nick is not one to succumb that easily. He does not want tears and heartbreak to surround his last days. Instead he wants to die with dignity and arranges for that day with his friend, Tony (Paul Regina) that in two days he is to administer the pills that will put him to "sleep" forever. Meanwhile, he invites friends and family to a sort of going away party. He wants it to be uplifting, without tears ... but of course, those who have been invited know that tomorrow is his last afternoon, that the next day he will be dead. Not exactly a party but that is what Nick has opted for. Dignity above all.
Some of those who attend are his mother (Lee Grant) and the father (George Segal) who is divorced from the mother and who has never been close to Nick and is now confronted by a loving, dying son. There is his devoted sister, Daphne, (Marlee Matlin), a friend, Charlene (Magaret Cho). and Nick's ex-lover, Monty (Bronson Pinchot) who had deserted Nick when he learned he had AIDS.
Sad? Yes. Heartwarming? Also yes. This is a different aspect of the devastation of AIDS and how some people handle their final moments. A film not to be missed.
4 Bytes
Written and Directed by Randal Kleiser
4 Bytes = Superb 3 Bytes = Not to be missed 2 Bytes = So so 1 Byte = Don't both 1 Byte = Save your money
Ben Hoffman
The review above was posted to the
rec.arts.movies.reviews newsgroup (de.rec.film.kritiken for German reviews).
The Internet Movie Database accepts no responsibility for the contents of the
review and has no editorial control. Unless stated otherwise, the copyright
belongs to the author.
Please direct comments/criticisms of the review to relevant newsgroups.
Broken URLs inthe reviews are the responsibility of the author.
The formatting of the review is likely to differ from the original due
to ASCII to HTML conversion.
Related links: index of all rec.arts.movies.reviews reviews


Departure City
Bangalore
Hyderabad
Delhi
Chennai
Arrival City
Bangalore
Hyderabad
Delhi
Chennai
Departure Date
Departure Date
Fetch Flights


The RW-1 windmill has 2 or 3 blades that spin with a diameter of 12 inches and weighs about 1/2 pound. The generator is capable of making over 5 watts.
The base unit includes the windmill, a hook for hanging the windmill, electronics that charge a battery, and a USB port for charging phones and laptops, etc. A voltage regulator brakes or limits the speed of the blades in very high winds to avoid damage to the windmill.
The REVOLT Mini windmill is designed to charge cell phones and laptops. The electric power being generated by the windmill can be converted to run or charge any device using an appropriate voltage converter.
This windmill:


Kazuhiro Miyazaki
Kazuhiro Miyazaki holds Ph.D. in Geology. He is a deputy director of the Geology and Geoinformation Research Institute, Geological Survey of Japan (GSJ), AIST. He is also an associate editor of Island Arc (an international journal of Geological Society of Japan). His research field is metamorphic geology, especially textural evolution of metamorphic rocks using statistical analysis and numerical simulation, and evolution of metamorphic belts using geological mapping and thermal-advection modelling.
Kazuhiro has worked in GSJ for over 25 years, contributing to compilation of 1:50 000 and 1:200 000 scale geological maps in Japan. He also joined the ITIT research project on mineral resource assessment in fragmental oceanic crust, which was a collaborative project between GSJ, University of London (United Kingdom), Research and Development Centre for Technology, and the Geological Research and Development Centre (Indonesia) from 1992 to 1995. Kazuhiro was project manager of the geological mapping project of GSJ from 2007 to 2012, which included the completion of the 1:200 000 geological map of Japan in 2010. He also managed the project for the next generation 1:200 000 scale seamless map of Japan.
Contact details for Kazuhiro Miyazaki
Kazuhiro Miyazaki
Orgenic Processes Research Group
Telephone: +81-29-861-2390
Fax: +81-29-861-3653
Email:


Data sets and scripts used in the book "Generalized Additive Models: An Introduction with R", Wood (2006) CRC.
| Version: | 1.0-0 |
| Depends: | R (≥ 2.10) |
| Suggests: | mgcv, lattice, MASS, nlme, lme4, geoR, survival |
| Published: | 2016-10-07 |
| Author: | Simon Wood |
| Maintainer: | Simon Wood <simon.wood at r-project.org> |
| License: | GPL-2 | GPL-3 [expanded from: GPL (≥ 2)] |
| NeedsCompilation: | no |
| Citation: | gamair citation info |
| Materials: | ChangeLog |
| In views: | Environmetrics |
| CRAN checks: | gamair results |
| Reference manual: | gamair.pdf |
| Package source: | gamair_1.0-0.tar.gz |
| Windows binaries: | r-devel: gamair_1.0-0.zip, r-release: gamair_1.0-0.zip, r-oldrel: gamair_1.0-0.zip |
| OS X binaries: | r-release: gamair_1.0-0.tgz, r-oldrel: gamair_1.0-0.tgz |
| Old sources: | gamair archive |
| Reverse suggests: | HSAUR2, HSAUR3 |
Please use the canonical form https://CRAN.R-project.org/package=gamair to link to this page.


--- layout: newsstory title: TWO GOOD RESULTS match: WSC Yeltz 1 Evesham 0 ---
As we continued our epic march through the Worcestershire Senior Cup, much more importantly we stayed on top of the table when Chips and Ham could only draw in their game in hand against our friends in Gloucester.
Our game was won by another Jason Burnham penalty and continues our excellent run of late. However, we've got two very important league games coming up - first Weston come to The Grove on Saturday, and then the week after we travel to Clevedon in another promotion showdown. It's all getting very exciting.
Halesowen Town: Clarke; Colwell, Crawford, Hines, Newell, Burnham, G. Smith, Skidmore (L. Collins 60), Jones, Ross (Phillips 73), Hall (Spencer 79). Subs: N. Smith, Garvey
Evesham United: Steadman; Parmenter, Wolsey, Clark, Pendleton, Cunnington (Lutz 68), Mullen, McCartan, Taylor, Brown, Preedy. Subs: Maybury, Benjamin, Staley, Pratt
Referee: D. Hine (Worcester) Attendance: 201 Booked: Taylor (30), Wolsey (53), Preedy (83), L. Collins (86) Sent Off: Wolsey (62)
Halesowen progressed to the Worcs. Senior Cup semi-final where they will meet Moor Green.
In front of a sparse crowd, Matty Hall produced a 2nd minute run and shot which was clawed away by goalkeeper Darren Steadman in a much-changed Halesowen line-up. Tim Clarke returned the gesture by turning away Russell Parmenter's 20-yard shot in the 9th minute. Lee Ross hit over form close range in the 10th minute and Matty Hall sent in two off-the mark shots from good positions as the Yeltz pushed a tough Evesham line-up.
Evesham had an opportunity to take a 38th minute lead but Scott Mullen slotted wide after Steve Taylor had headed down. In the 42nd minute Gary Smith played a neat 1-2, but inexplicably hit wide when all alone on the penalty spot. The winner came in the last minute of the first half when Mullen tripped Les Hines and Jason BURNHAM despatched his sixth penalty of the season into the centre of goal.
The Yeltz created more openings in the second half, but could not add to the goal tally. Hines whipped in a 53rd minute free-kick which was gathered well by Steadman with Burnham about to pounce. Evesham were reduced to ten men in the 62nd minute when Mark Wolsey was dismissed for retaliation against Andy Jones. Matty Hall wasted a 70th minute opportunity to increase the lead when he elected to go alone instead of passing across goal to the three unmarked forwards after Lee Ross had set him clear.
Steadman then kept Evesham in the game with a string of fine saves. Kelvin Phillips, son of manager Brendan, almost rounded Steadman with his first touch of the ball in the 74th minute, but Steadman dived to take the ball. Steadman then saved a fierce Colwell shot with his feet following a fine surging run by the fullback and produced a fine reflex stop from a Jones header a minute later. In the last meaningful chance, Hines cracked the Evesham crossbar from 20 yards out in the 78th minute.


I am a 24 (soon to be 25) years old colombian, university student who is looking to help as many people as I am capable to reach. My main goal in life is to let people know that every problem and every situation has a wayout, we just need to keep calm, find our inner strenght and fight for who we are, who we want to be and for those who we love.
That is why my motto is "We will make everything all right" and my inner image, something like your inner animal, is a Spartan Warrior, and I am working my body and mind to become one.
Raised in a military family, the biggest learning of all is that you always need to be prepared for everything, always push your limits and always take care for your loved ones.
As I grew up, life took numerous turnings to bring me where I am, every new turn and new step brought new experiences and incredible people to learn from. Every single day has to be treated in a special way because you need to have your mind open to understand and enjoy every second of it.
With the broad, yet narrow approach that a universitarian life has given to me so far, one thing is taken for sure: I am not here just to watch the life past in front of me. Life has to be taken by the horns and make it our own, not one defined by the crowd. I am here to help, to raise my voice and the voice of those who need it the most so we all can fix a world that is slowly falling apart.


The Team of Jokesters
We take our jobs very seroiusly.
Poppy Chapman
Company Founder /
Dancing Queen
Grover Romero
Product Director /
Doomsday Prepper
Bailey Monroe
Technical Director /
Iguana Wrangler
Anastasia Calhoun
Marketing Director /
Ghost Whisperer


{% load i18n %} {% load displayutils %} {% trans "Support the project" %}
{% trans "Exercisync is free and open service, but development, support users, server maintenance - all this requires my efforts. Thank you for your contribution to the development of the service!" %}


Regular file upload
capture=camera
capture=camera (without mimetype constraint)
capture=camcorder
capture=microphone
Abschicken


Audio Rule 2: Test 4: object
element using @aria-describedby@ to reference a text transcription
Testing Testing one two three
object
element using @aria-describedby@ to reference a text transcription


{{page.include("includes/header.html")}} {{page.content}} Contents {{page.include("includes/footer.html")}}


Sorry!
This application requires javascript to be enabled.
Skip to
navigation
,
search
.
Places
Places of Interest
Places
Search
Exit
{{title}}
{{title}}
{{detail}}
{{title}}


This is a helper module for authors of Node.js native addon modules.
It is basically the "swiss army knife" of require()
ing your native module's
.node
file.
Throughout the course of Node's native addon history, addons have ended up being compiled in a variety of different places, depending on which build tool and which version of node was used. To make matters worse, now the gyp build tool can produce either a Release or Debug build, each being built into different locations.
This module checks all the possible locations that a native addon would be built at, and returns the first one that loads successfully.
Install with npm
:
$ npm install bindings
Or add it to the "dependencies"
section of your package.json file.
require()
ing the proper bindings file for the current node version, platform
and architecture is as simple as:
var bindings = require('bindings')('binding.node')
// Use your bindings defined in your C files
bindings.your_c_function()
When the .node
file could not be loaded, node-bindings
throws an Error with
a nice error message telling you exactly what was tried. You can also check the
err.tries
Array property.
Error: Could not load the bindings file. Tried:
→ /Users/nrajlich/ref/build/binding.node
→ /Users/nrajlich/ref/build/Debug/binding.node
→ /Users/nrajlich/ref/build/Release/binding.node
→ /Users/nrajlich/ref/out/Debug/binding.node
→ /Users/nrajlich/ref/Debug/binding.node
→ /Users/nrajlich/ref/out/Release/binding.node
→ /Users/nrajlich/ref/Release/binding.node
→ /Users/nrajlich/ref/build/default/binding.node
→ /Users/nrajlich/ref/compiled/0.8.2/darwin/x64/binding.node
at bindings (/Users/nrajlich/ref/node_modules/bindings/bindings.js:84:13)
at Object.<anonymous> (/Users/nrajlich/ref/lib/ref.js:5:47)
at Module._compile (module.js:449:26)
at Object.Module._extensions..js (module.js:467:10)
at Module.load (module.js:356:32)
at Function.Module._load (module.js:312:12)
...
(The MIT License)
Copyright (c) 2012 Nathan Rajlich<EMAIL_ADDRESS>Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.


Vlad the Impaler
The real Dracula
As the cognomen "The Impaler" suggests, his practice of impaling his enemies is part of his historical reputation.
Important events in Vlad's life:
- 1431 - Born at Sighisoara, Mures County, Kindgom of Hungary ( today Romania)
- 1436 - follows his father, Vlad II Dracul,who becomes King of Wallachia and moves to The Royal Court in Targoviste
- 1442 - by political reasons, he was sent by his father as a prisoner to Sultan Murad II's court toghether with his brother, Radu the Handsome.
- 1447 - freed imediatly after his father's death.
- 1448 - accompanied by Turkish army, he is crowned as King of Wallachia, but two months later is defeated by Vladislav II.
- 1456 - defeats Vladislav II, is crowned a second time and takes revenge on the boyars who killed his father and brother Mircea.
- 1459 - he arrested all noble families who had taken part in the princely party. The oldest ones were impaled and the others were obliged to walk 100 km from the capital to Poenari.He often ordered that condamned people to be skinned, boiled, beheaded,
blinded, strangulated, hanged, burnt, roasted, chopped, nailed, burried alive, or have their organs cut. But his favourite torture was impalement, hence the name. This year he refused to pay the 10.000 coins tribute to the Turks.
- 1460 - the Turks try to stop his allegience with Matei Corvin, but were unsuccessful.
- 1461 - 1462 - organised a surprise attack, killing 20.000 Turks
- 1462 - his greatest blow against the Turks happened, making them retreat before arriving at Targoviste. Later, instead of receiving help from his ally, he is let down by Matei and forced to live at Buda under house arrested.
- 1475 - is freed by his cousing Stephen the Great, Moldavia's king and was recognised as the true king of Wallachia.
- 1476 - is murdered and his head is sent to the Sultan, which impales it as a sign of triumph.
The connection of the name "Dracula" with vampirism was made by Bram Stoker around the 1890s. Since then, the character of 'Count Dracula' has recurred through vampire mythology and popular culture.
If you are interested in finding more about the real Dracula, please visit his Wikipedia page.


Import your .json file
Statistics
Duration of the video (seconds required) :
- Clicking here will give you some statistics of the video you annoted like the number of customers or the mean time passing to pay by customer or in general.
Category's id
This option permit to download the .json file where category's id are automaticly added.
Category Details
This option permit to download a .json file with all the informations below for each action :
- Total frames of the video
- Frame number where the action starts / stops
- Id of the person
- Category of the action / Category's id
- Number of customers


Integritet
This page informs you of our policies regarding the collection, use and disclosure of personal information we receive from users of our site (https://bitcoin.org). We use your personal information to better understand your usage of the site, and to collect traffic statistics.
By using the site, you agree to the collection and use of information in accordance with this policy.
Log Data
Like many site operators, we collect information that your browser sends whenever you visit our site ("Log Data"). This Log Data may include information such as your computer's Internet Protocol ("IP") address (with replaced last byte), browser type, browser version, the pages of our site that you visit, the time and date of your visit, the time spent on those pages and other statistics.
Cookies
Cookies are files with small amount of data, which may include an anonymous unique identifier. Cookies are sent to your browser from a web site and stored on your computer's hard drive. You can instruct your browser to refuse all cookies or to indicate when a cookie is being sent. However, if you do not accept cookies, you may not be able to use some portions of our site.
We use cookies for the following purposes:
- To keep track of whether you have pressed the "OK" button on the cookie disclaimer, so we don't bother you with the notification if you have.
- Our Analytics software (Google Analytics) uses cookies to measure and better understand user-interactions on our Site. You can read more about how Google Analytics uses cookies here.
Google Analytics
We use a third-party JavaScript plug-in provided by Google called "Google Analytics" to provide us with useful traffic statistics and to better understand how you use our site. We do not have direct access to the information obtained from Google Analytics, but Google provides us with a summary through their dashboard.
We may share the information obtained from Google Analytics with business partners who are interested in advertising on our website. The information shared with these business partners will not contain any personally identifying information (Google does not provide us with direct access to the data and therefore we cannot see this information).
You can opt-out of having your information collected by Google Analytics by downloading the Google Analytics opt-out browser add-on provided by Google. This will prevent your information being used by Google Analytics. Doing this will not affect your ability to use our Site in any way. You can download the opt-out browser add-on here. We also honor the Do Not Track header and will not track visitors who have Do Not Track switched on.
Changes to this Privacy Policy
We may update this privacy policy from time to time. We will notify you of any changes by posting the new privacy policy on the Site. You are advised to review this privacy policy periodically for any changes.
This Privacy Policy was last updated: 5th July, 2016.
Contact Us
If you have any questions about our privacy policy, or how your data is being collected and processed, please e-mail privacy@bitcoin.org.


"We’ll only pick the ripe ones, okay?
The ones that are brown all over...
Watch out! Here they come!"
WHOOOSH... WHUMP!


Hi, I'm Matthew. I'm a full stack software developer living in the Chicago area looking for the next step my career. I grew up loving video games, computers, and music, so I was drawn to technology and the internet from a very young age. I never imagined that one day I'd learn to design a webpage, build a game, or create a server. However, in 2015 I heard about a coding bootcamp called Nashville Software School.
I decided to leave behind my life in Illinois to make the move down south to attend NSS as part of their 11th cohort. Having finished school and a six month internship in Kentucky that followed, I've returned to the Chicagoland area that I've called home for most of my life, hoping to put the skills I've learned to use up here.
Thank you for taking the time to look at my webpage. If you'd like to contact me, feel free to reach me at any of these websites.


!doctype html>
The first paragraph is the most important.
Be less curious about people and more curious about ideas.
My list:


Be careful not to choke on your aspirations.
Introduction¶
Open any AWS certification job description, an excerpt is posted below.
- Excellent working knowledge of key AWS services such as EC2, ECS, Lambda, S3, ELB, CloudFront, RDS Aurora, API Gateway, etc.
- Expertise in creating cloud migration strategies; defining delivery architecture, creating the migration plans and designing the orchestration plans.
- Experience in defining new architectures and ability to drive project from architecture standpoint
- Experience with Leveraging appropriate AWS services to execute migration plan
- Experience writing Infrastructure-as-Code (IaC), using tools like CloudFormation.
- Experience with CI/CD systems.
- AWS certifications preferred.
If you started your career at the dawn of this new century, this list of requirements can be overwhelming. This is just a sample, if you go on searching, we will have different other technologies involved.
This is not the age of Master of one. You have to become Jack of all trades.
A Certification is just the beginning of the journey and not the destination.
If you have to target for next 5 years, I believe multi cloud is the future, as every cloud provider has something unique to provide for the customer.
When we combine multi cloud into the above job description, we cannot imagine what it will look.
The journey of a thousand miles begins with one step. Lao Tzu
You should start today, and we all should target one cloud certification first. A simple search on LinkedIn reveals we have 31,806 AWS jobs, 22,470 Azure jobs, and a very minimal 6,578 GCP jobs. We can target AWS or Azure as the first certification choice.
Now we have selected the cloud provider for certification, the next step is to choose from where to study. The internet is filled with options.
- Udemy
- Neal Davis
- Stephane Maarek
- DolfinED
- Tutorials Dojo
- A Cloud Guru
- LinuxAcademy which is now acquired by A Cloud Guru.
- CloudAcademy
Even here you can be overwhelmed with option. Just pick any one from the list.
Finally, and the most important problem. How do you recollect everything on the exam day and beyond?
There are lots of techniques which can help, especially if you are mid career, with kids, family and job you have limited amount of time for study. Your only approach can be the approach which saves time per day. You have to increase your efficiency because now you cannot sit like in your younger days and complete syllabus after syllabus in hours.
The 3 main techniques which help increase efficiency are.
- Spaced repetition.
- Active recall
- Richard Feynman's study technique.
Please read about the first 2 on Wikipedia, if you want me to write about it comment below.
Finally the important part is the Richard Feynman's study technique. This Blog is essentially my effort of teaching others the concept of cloud, AWS so that it sticks in my brain also. When you study for yourself, you tend to ignore a lot of concepts.
When you think of teaching other or helping others, it gives a purpose for learning, and that helps in the extra effort required to understand a vary tough or boring topic.
I am writing about my journey as it happens to that it can help you tomorrow to avoid any pitfalls which I have faced. When you Blog retrospectively you tend to forget very small details which could have created an impact on the long run.
Here I am updating all the learning as it happens. I am starting with AWS Developer Associate certification (DVA-C01), which will be followed by AWS Architect Associate.
Let me know in the comments below, How do you like the progression of Blogs.
AWS Certification | AWS Certified Developer - Associate ( DVA-C01 )¶
AWS IAM¶
- AWS Global Infrastructure & shared responsibility model
- AWS is very vast in its present form, understanding it would be very challenging. We will begin this journey at the epicenter of AWS, the Shared responsibility model and its global infrastructure.
- AWS IAM Introduction.
- In this Blog let us understand the basics of IAM, Identity and access Management. This is service which is used to control access to all the resources in AWS. The key component of IAM are User, Groups, Policy, Roles, API keys.
- AWS IAM Policy.
- When we want to give access to various resources to AWS, how do we do it, how do we define the various ways a user can get access. These are parameters are defined in a JSON document called IAM Policy. We will learn about this in this blog.
- AWS IAM Users.
- We have learned about IAM policy and its basics. We will apply those to a specific user here. We will also learn the various ways IAM users can get access to the AWS resources and also how can an IAM user rotate password.
- AWS IAM Roles
- When to create an IAM role and when to use an IAM User is always a confusing topic to master. You will learn through this piece the answer to this dilemma. You will learn when to create an IAM Roles, how to use the IAM Role, Uses of IAM roles. After learning this you will never be scratching your head using IAM Roles.
- AWS STS
- AWS STS or Security Token Service, provides temporary access credentials to access any AWS resource. This temporary access can be requested by the other AWS account, or a federated user in case of hybrid cloud environment who can be authenticated using SAML 2.0, Web identity provider. AWS STS works very closely with IAM Roles.
- AWS IAM API Keys
- Cloud technology is a tool for the developers, creating sophisticated softwares. How does developer access the cloud? Does AWS Console is the only way to access the cloud? Developers love code, CLIs and SDKs, AWS provides access to its cloud resources using AWS IAM API Keys.
- AWS KMS Blog
- When you are storing your data on a physical server, which is not owned by you. The concern of data security is paramount. AWS KMS or key management service helps in this regards to safeguard data by encrypting it. You can use the keys provided by you or by AWS to encrypt the data. AWS KMS makes sure that the data and the keys are not stored together, restricting the extent of data theft.
- AWS Inspector Blog
- As part of the Shared responsibility of cloud between users and AWS, as a user we have to manage the application security and VPC security. This may be difficult to do for a lot of independent developers. AWS has a managed service called AWS inspector. Lets study about it.
- AWS Cognito and Cognito Sync Blog
- Create a highly secure web application, by offloading user management, Social sign-in, login along with data sync across devices onto AWS Cognito. This is an intense AWS Cognito tutorial, which will explain about user pool, and identity pool. How to use the user pool with identity pool. We will even write a Python code, to implement the basic AWS Cognito API, using Boto3 SDK.
AWS EC2¶
- AWS EC2 - A Step by Step Guide to launch AWS EC2
- You might of heard a lot of cloud computing, The only thing that might bother you, how does it all work. The AWS Cloud is dependent on the AWS EC2 (Elastic Compute Cloud), its atomic unit for servers. You can learn to launch an EC2 instance, in 7 easy to follow steps, which will take less than 5 minutes to complete.
- The complete beginner's guide to AWS AMIs
- AMI (Amazon machine image) has further enhanced the options.. Many instances can use these AMIs to launch identical copies. AMIs are the blueprint. AMIs have a definite life cycle of creating, register, copy, launch and de-register. If you are not creating your own AMI, then you have only last three life cycle states.
- AWS SDKs & CLIs for using AWS resources
- AWS provides many ways to control its resources. One of the fastest and the most effective way is the AWS CLIs and SDKs. The best benefit of using CLI or SDKs it that you can automate complex workflow. In this article we will learn to download, install, configure AWS CLI and SDKs. It will also guide in using Postman Client to use HTTP APIs.
- Choose Your ideal AWS EC2 Instance.
- AWS EC2 is the heart of AWS. This is the server which is running. AWS provides 350 instance choices. This will become a difficult choice to pick a particular instance from a vast pool of servers. You have General propose instance, Compute Optimize, Memory Optimize, Storage Optimize & Accelerated Computing (Instance with GPUs) category of the instance. You have to decide based on Cost, hardware requirement and your use case. You can even use Instance Explorer to choose your perfect AWS EC2 instance.
- Save money when you select the instance.
- AWS is always on the look out for saving cost for you. It has also evolved the pricing model from having just one type of On-Demand to Reserved instance to the latest Savings Plans. AWS has also thought about the tenancy of the machine, be it shared, dedicated instance or dedicated host. Understanding the AWS Pricing and Tenancy can be little difficult. This blog tries to simplify the jargons and just bring the crux of the pricing and tenancy models. You can save up 99% over on demand pricing if you are clear on your compute usage and AWS pricing.
- IP world of AWS - Private, Public & Elastic.
- AWS EC2 instance cannot survive in isolation. IP is the universal medium of communication. AWS provides us with private IP, public IP and Elastic IP. Private IP used for internal communication within AWS. Public IP used to communicate to open Internet. Elastic IP are more like an Static IP. You will learn the uses of all these different IPs. Lets figure out the difference and similarities between these.


In this fast paced and exciting game the objective is to gain the most
money you can! For five minutes, you will be able to buy and sell fruits
at market value, and sell them to cash out on your inventory. Displayed below
is the average price that you paid for that particular fruit, and the amount you
currently have.


This tag allows the element to sit "inline" (on the same line) or within the neighbouring element. Common tags that operate "inline" are: 'em', 'strong', 'a' and 'img'. They never start on a new line and you can't apply margins or padding to the element. There is no setting the height or width.
Inline-block elements use the same tags as with "inline", it also sits within another element, not creating a new line..... So what is the point you may ask....? Well with this element you CAN use padding and margins on the element (this is often used when making "buttons"), this allows you to change the height or width of the element, yet the text remains on the same line as the surrounding text.


| HBASE-10274 |
MiniZookeeperCluster should close ZKDatabase when shutdown ZooKeeperServers |
Minor |
. |
chendihao |
chendihao |
| HBASE-10320 |
Avoid ArrayList.iterator() ExplicitColumnTracker |
Major |
Performance |
Lars Hofhansl |
Lars Hofhansl |
| HBASE-10335 |
AuthFailedException in zookeeper may block replication forever |
Blocker |
Replication, security |
Liu Shaohui |
Liu Shaohui |
| HBASE-10249 |
TestReplicationSyncUpTool fails because failover takes too long |
Major |
. |
Lars Hofhansl |
Jean-Daniel Cryans |
| HBASE-10400 |
[hbck] Continue if region dir missing on region merge attempt |
Major |
hbck |
Jonathan Hsieh |
Jonathan Hsieh |
| HBASE-10401 |
[hbck] perform overlap group merges in parallel |
Major |
hbck |
Jonathan Hsieh |
Jonathan Hsieh |
| HBASE-10383 |
Secure Bulk Load for 'completebulkload' fails for version 0.94.15 |
Critical |
Coprocessors |
Kashif |
Jesse Yates |
| HBASE-10371 |
Compaction creates empty hfile, then selects this file for compaction and creates empty hfile and over again |
Major |
. |
binlijin |
binlijin |
| HBASE-10448 |
ZKUtil create and watch methods don't set watch in some cases |
Major |
Zookeeper |
Jerry He |
Jerry He |
| HBASE-7963 |
HBase VerifyReplication not working when security enabled |
Major |
Replication, security |
Water Chow |
Matteo Bertozzi |
| HBASE-10319 |
HLog should roll periodically to allow DN decommission to eventually complete. |
Major |
. |
Jonathan Hsieh |
Matteo Bertozzi |
| HBASE-10470 |
Import generates huge log file while importing large amounts of data |
Critical |
. |
Vasu Mariyala |
Vasu Mariyala |
| HBASE-10363 |
[0.94] TestInputSampler and TestInputSamplerTool fail under hadoop 2.0/23 profiles. |
Critical |
. |
Jonathan Hsieh |
Lars Hofhansl |
| HBASE-10340 |
[BACKPORT] HBASE-9892 Add info port to ServerName to support multi instances in a node |
Major |
. |
stack |
stack |
| HBASE-10489 |
TestImportExport fails in 0.94 with Hadoop2 |
Major |
test |
Lars Hofhansl |
Lars Hofhansl |
| HBASE-10493 |
InclusiveStopFilter#filterKeyValue() should perform filtering on row key |
Major |
. |
Ted Yu |
Ted Yu |
| HBASE-10485 |
PrefixFilter#filterKeyValue() should perform filtering on row key |
Major |
. |
Ted Yu |
Ted Yu |
| HBASE-10481 |
API Compatibility JDiff script does not properly handle arguments in reverse order |
Minor |
test |
Aleksandr Shulman |
Aleksandr Shulman |
| HBASE-10505 |
Import.filterKv does not call Filter.filterRowKey |
Critical |
. |
Lars Hofhansl |
Lars Hofhansl |
| HBASE-10482 |
ReplicationSyncUp doesn't clean up its ZK, needed for tests |
Major |
Replication |
Jean-Daniel Cryans |
Jean-Daniel Cryans |
| HBASE-10508 |
Backport HBASE-10365 'HBaseFsck should clean up connection properly when repair is completed' to 0.94 and 0.96 |
Major |
. |
Ted Yu |
Ted Yu |
| HBASE-10506 |
Fail-fast if client connection is lost before the real call be executed in RPC layer |
Major |
IPC/RPC |
Liang Xie |
Liang Xie |
| HBASE-10545 |
RS Hangs waiting on region to close on shutdown; has to timeout before can go down |
Major |
. |
stack |
stack |
| HBASE-10551 |
Change local mode back to one RS thread by default |
Blocker |
. |
Lars Hofhansl |
Lars Hofhansl |
| HBASE-10555 |
Backport HBASE-8519 to 0.94, Backup master will never come up if primary master dies during initialization |
Minor |
. |
Jingcheng Du |
Jerry He |
| HBASE-10552 |
HFilePerformanceEvaluation.GaussianRandomReadBenchmark fails sometimes. |
Minor |
. |
Lars Hofhansl |
|
| HBASE-10562 |
Fix TestMultiTableInputFormat for Hadoop 2 in 0.94 |
Major |
. |
Lars Hofhansl |
Lars Hofhansl |
| HBASE-10539 |
HRegion.addAndGetGlobalMemstoreSize returns previous size |
Major |
regionserver |
Honghua Feng |
Honghua Feng |
| HBASE-10546 |
Two scanner objects are open for each hbase map task but only one scanner object is closed |
Major |
. |
Vasu Mariyala |
Vasu Mariyala |
| HBASE-10501 |
Improve IncreasingToUpperBoundRegionSplitPolicy to avoid too many regions |
Critical |
. |
Lars Hofhansl |
Lars Hofhansl |