Event Location:
Portland Community College - CLIMB Center
1626 SE Water Ave
Portland, Oregon
Abstract:
The session is mainly a review of Cube Health Monitoring and Load Balancing in adCenter Enterprise Cube Environment. It is a detailed discussion and review of our process on achieving the following goals: 1. Create a load balancer across the OLAP cubes 2. Achieve better monitoring and alerting of our enterprise OLAP systems 3. Increase our Up-time and monitor our SLA 4. Increase our ROI of the HW Currently AdCenter has two major services that are integrated / connected to each other: first one does the monitoring and alerting of the OLAP cubes and the second one does load balancing across the OLAP servers. The monitoring service notifies the load balancer when a server is not available so the cube balancer does not route traffic to it
Speaker(s): Bilal Obeidat,
Abstract:
The Query Optimizer uses statistics to decide how to execute a query. If statistics are out of date, improperly sampled or simply don’t exist, then you could unintentionally deceive the Optimizer. Accurate statistics can help avoid poor query plans, so if you’re not familiar with how to read a histogram, the various options for updating statistics or want to know why sample size does matter, this session is for you! We will also delve into what happens when a value doesn’t exist in a statistic, discuss methods to manage statistics for volatile tables and examine the challenges that exist with statistics on partitioned tables. Expect a session filled with demos and real-world examples that will create a foundation of statistics knowledge.
Speaker(s): Erin Stellato,
Abstract:
Do you remember what it was like to fall in love? Wasn't it wonderful? Lately it just hasn't been the same. You've been stuck in the same old routine, doing the same old charts and tables. Maybe Reporting Services doesn’t tell you what’s wrong. Maybe you're even thinking about seeing other reporting products (!) In this session made for report developers with less than 2 years' experience, Doug will re-ignite your passion for RS by showing you how to design for better performance, explaining what RS has been trying to tell you through logs (but you haven't been listening), and demonstrating some new -- and easy -- tricks you may not have known RS can do. After this session, you'll want to spend some time alone with your new old flame.
Speaker(s): Doug Lane,
Abstract:
In this demo-packed session we will explore the use of SysInternals tools like Process Monitor, Process Explorer, and many others to troubleshoot various problem scenarios with SQL Server. This session is not for the faint of heart and is tailored toward those adventurous DBAs who often like to step out of their comfort zone. A fair knowledge of Windows OS internals is recommended.
Speaker(s): Argenis Fernandez,
Abstract:
MDX is an elegant and powerful query language for SQL Server Analysis Services but it's not easy for most to figure out, unguided. This session is led by Microsoft BI Architect, author and SQL Server MVP, Paul Turley. We will start with a review of the basic of concepts of cubes, dimensions and hierarchies. From the ground up, you will learn how to use MDX query constructs to report business analytical data to your users with measures, calculated members, KPIs, slicers. You'll learn to use some of the most useful MDX functions so you can take what you learn and put it to practical use next Monday morning.
Speaker(s): Paul Turley,
Abstract:
The focus of this session is on describing best practices every SQL Server DBA needs to know. These are foundational best practices that, if not followed, could have a significant negative effect on the performance and availability of their SQL Servers. This session focuses on key fundamentals, such as: Installing Upgrading SQL Server; SQL Server Configuration; User Data and Log File Management; Database Configuration Settings; Configuring Critical Maintenance Jobs; Setting Up Alerts for Critical Errors; Security Basics; Implementing a Backup and Restore Strategy; Creating a Disaster Recovery Plan; Testing; Monitoring; and Documentation.
Speaker(s): Brad McGehee,
Abstract:
Taking the periodic table of elements into consideration I've created The Periodic Table of Dynamic Management Objects as a reference tool for these functions and views that have become so critical for today's SQL Server DBA to performance tune and gain metadata insights into their various SQL instances. In navigating the table we will examine key DMVs and DMFs of interest: requests, sessions, wait stats, indexes, system information will all be covered. We will also delve into how these DMOs - just like their elemental counterparts - can be combined to yeild interesting insights into your servers. We will also look at how things can go awry as well! Like mixing vinegar and baking soda, sometimes combining DMOs can cause a big mess too!
Speaker(s): Tim Ford,
Abstract:
With the widespread availability of location and spatial data to both consumers and corporations (such as smartphone GPS data), there is a need to manage and analyze all this data as well. SQL Server 2008 introduces new standards-based spatial data types and associated functionality to the relational engine. Spatial data can be stored in the cloud using SQL Azure. And SQL Server 2008 R2 Reporting Services allows spatial data to be visualized as Maps. In this session, we'll explore both the SQL spatial data types and SSRS maps, using demos to show this functionality in action. We'll also cover enhancements to spatial functionality in the forthcoming "Denali" version of SQL Server.
Speaker(s): Deepak Puri,
Abstract:
By now you have probably already heard about Analysis Services. Maybe you've even said to yourself that you were going to learn more about it but just haven't found the time. The biggest barrier to learning something new is figuring out the first few steps. But where do you begin? Come learn those first few steps by attending this presentation. We will discuss what Analysis Services is, where it shines and more importantly, how to get started.
Speaker(s): Marc Beacom,
Abstract:
You may have heard that it’s a good idea to use a server-side trace to capture SQL profiler data, but do you know how to create one? And, do you know how to process the data you’ve captured? If not, then this session is for you. First, we’ll examine the anatomy of a server-side trace script and look at the different ways it can be customized. Then, we’ll talk about methods for stopping and starting the trace, how to know what traces are already running, and ways to schedule a trace to start under certain server conditions. Last, we’ll look at different tools available to you for analyzing the data you’ve gathered, including the SQL Server Profiler client application, “home-grown” T-SQL queries, ClearTrace, and the ReadTrace.
Speaker(s): Christina Leo,
Abstract:
MERGE is a new capability in SQL Server 2008. This session will start with the basics of what MERGE is and then dig into how it works and how it compares to using traditional INSERT/UPDATE semantics. You should come away from this session with a good understanding of MERGE, ready to implement it in your environment.
Speaker(s): Rob Garrison,
Abstract:
I'm sure you've been told seeks are better than scans. I'm sure you've been told that a covering index is ideal.  Get the whole story.
Speaker(s): Rob Farley,
Abstract:
How your business applications interact with the corporate database directly can have a dramatic impact on how successful you are, and one of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates you can focus performance concerns to where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently, and minimizes the conflicts with your critical updates. This session will walk you through the steps to get Service Broker up and running and providing a consistent delivery of your business data.
Speaker(s): Allen White,
Abstract:
With so much interest in Cloud technology, where does it really fit in, and what is the role of the DBA and Database Developer? What is available in SQL Azure, as it compares to SQL Server? Can you leave some data on-premise, and put other data in the cloud? Buck shows you the ins and outs of SQL Azure, how to connect to it, manage it, what the limitations are, and real-world examples of architectures that work.
Speaker(s): Buck Woody,
Abstract:
Extended Events is the replacement for profiler in many respects, and will be the choice of capturing data from within SQL Server now and in future editions, so we need to understand the differences it has to profiler "old guard" and why we should be using this new feature for this purposeI'll take you on a Guided tour of the key aspects, and show you simply how in just minutes you can up and running and capturing data using this new method and how to analyze it effectivelyFollow me to the "new age" of understanding your systems activity
Speaker(s): Neil Hambly,
Abstract:
You have mastered the art of linking a dataset to a table in SQL Server Reporting Services. You have solid, reliable reports that you and others depend on. Learn how to take them from basic to "wow", using features such as tablix, lists, images, and charts. At the end of this session, you will be familiar with: - Report properties such as headers, footers and backgrounds - Tablix properties such as ToolTip and NoRows - How to build and customize a matrix - How to effectively use lists, an often-overlooked feature - Adding charts to make reports visually appealing and easy to understand
Speaker(s): Jes Schultz,
Abstract:
This session will present a Database and ETL Architecture that allows you to smoothly move data from your application databases across the enterprise in real-time to your data warehouse. Carlos Bossy will show you how to use SQL Server features such as Replication, Change Data Capture, and SSIS to extract, transform and load data fast and dependably and view a real demonstration of the system in action. Finally, Carlos will show how to use Reporting Services to present data with a minimum amount of latency.
Speaker(s): Carlos Bossy,
Abstract:
Forget Profiler for a second, I have seen one poorly placed index bring an enterprise database to its knees. We will cover the basic tips of performance which always work and the ones which always fail. What can you do – and what should you do –when it comes to the most common types of indexes so you always make the right move. The Author will use lessons from SQL Architecture Joes 2 Pros Vol3.
Speaker(s): Rick Morelan,
Abstract:
We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Speaker(s): Allen White,
Abstract:
In this session Ben Muller, Practice Manager BI Productivity at CSG will discuss Microsoft's upcoming Business Intelligence tool, 'Crescent'. Packaged with the next release of SQL Server (currently code named 'Denali'), 'Crescent' lets users of all skill levels quickly create dynamic and compelling reports and analyses which can be instantly published to SharePoint. Ben will review the features and functionality of 'Crescent', and talk through some common 'Crescent' scenarios.
Speaker(s): Benjamin Muller,
Abstract:
Management Data Warehouse and custom collectors are a potentially powerful tool set for DBAs and developers. While the feature can seem a bit rough around the edges, the hidden potential within is great. Creating Custom Collectors provides DBAs and Developers a quick, easy and powerful way to collect and store metrics and other data over time. This data can be used to answer a host of potential questions.
Speaker(s): Edwin Quick,
Abstract:
Can T-SQL be run in multi-threaded manner? Yes, this session will explain how to use TSQL to implement multi-threading application, including process control, resource access, execution ordering, synchronization, semaphore, etc. If you are looking for a solution to turn your processes to run in parallel, you should not miss this session.
Speaker(s): John Huang,
Abstract:
Self-promotion is often times the best promotion you can get. In this session, we will talk about how to promote yourself, your brand and your career without looking like “That Guy”. We will discuss Social Medias, communities, volunteering and other ways to get your name out… What are the first steps? Come find out.
Speaker(s): Mitchell Bottel,
Abstract:
Can't find the component to use in your SSIS control flow or data flow? You might want to consider to script it yourself! One of the most flexible components in SSIS is the script task. This session covers the basics of the SSIS script task, what you can do with it and some tips and tricks how to use it.
Speaker(s): Erik Monchen,
Abstract:
Microsoft offers three distinct platforms for data analysis and a variety of related reporting tools. When should you use BI Semantic Models, PowerPivot, tabular column storage, SSAS cubes or relational data marts? Learn about the right fit for each of these choices and what you need to know to use the next generation of BI reporting tools like Project Crescent, SSRS and SharePoint BI.
Speaker(s): Paul Turley,
Abstract:
Dates and times seem simple at first. Kendra Little will show you there’s more to it than you think. She’ll give you five best practices that will help you select the right temporal data type, avoid common issues, and use the most effective techniques to aggregate data. She’ll also explain painful problems with query performance and how to avoid them. Choose wisely: the correct types and high performing data access logic will scale well and save development and administrative time.
Speaker(s): Kendra Little,
Abstract:
A brief introduction and explanation of MofuMobi, a new mobile business tool developed by Aaron and his team. This mobile platform is driven by SQL Queries, enabling users to extend any internal software system to their smart phones. This session will show viewers how easy it is to create their very own custom apps within the MofuMobi portal and what kind of functionalities it is capable of, for instance updating users with new apps (reports within apps) without having to update phones. If you can write SQL Queries or views than you can develop MofuMobi apps.
Speaker(s): Aaron Allison,
Abstract:
SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing.
Speaker(s): Janis Griffin,
Abstract:
A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
Speaker(s): Karen Lopez,
Abstract:
One of the new features of SQL Server 11 (Code Name Denali) is columnstore indexes, where the storage of index data is “turned on its head”. We will look into how this feature is implemented internally, how it can greatly improve query performance in the right environment, and its current limitations.
Speaker(s): Vern Rabe,
Abstract:
There's so much more to know about joins than INNER, OUTER, CROSS. Understanding other kinds of joins, and the impact of decisions about how you write them can seriously impact your T-SQL effectiveness.  No slides here - just demos. We'll create slides as we go.
Speaker(s): Rob Farley,
Abstract:
In this introductory session, we will go through an overview of SQL Server Mirroring and Log Shipping. We will do a brief overview of the parts and modes of database Mirroring. You will also be introduce to Log Shipping and how it works. We will have a demo part of the session where we will go through step-by-step on how to set up Mirroring and Log Shipping. By the end of this session, you should have a general understanding and ability to deploy database Mirroring and Log Shipping.
Speaker(s): Harry Chandra,
Abstract:
Does your company use agile development? It can deliver more value to customers with lower project risk. However, it can also make the system design change rapidly, and require frequent software rollouts. This session will focus on best practices for DBAs and developers to make design, testing and deployments easier. Keep your systems agile, not fragile!
Speaker(s): Dev Nambi,
Abstract:
Conversations about SQL Server administration tends to be all about administering OLTP systems. If you administer BI systems, you can't apply everything you know about administering OLTP systems to BI systems. BI systems usually end up being administered by OLTP DBAs or by BI developers and architects. Where does one even find a BI Administrator? Fortunately, I've been administering BI systems for several years, and I have learned the hard way the difference between administering OLTP and BI systems. This session will cover the top 10 things that I think an administrator of BI systems need to know.
Speaker(s): Robert Davis,
Abstract:
You can master Integration Services to solve complex business data issues! For the SSIS beginner; learn to implement best practices and design patterns that will prove to be indispensable and easy to perform. There are multiple options to perform tasks or transformations and we will explore these choices so you can use the right tool for the job. You will also see how to use expressions for connection strings and precedence logic, and process more data in less time. Get the scoop on package configurations, deployment and package portability. Using some basic, proven design techniques; you can be an SSIS pro!
Speaker(s): Sopheap Suy,
Abstract:
So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you!I will explore advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries, But I will also show the dangers of using too many indexes, and the tools SQL Server itself hands you to help identify just the right subset of indexes.
Speaker(s): Hugo Kornelis,
Abstract:
This session will describe the best practises for designing a data warehouse to get the most out of SQL Server. Doug has worked in data warehousing for 12 years and will blend experience, with best practises and recommendations from Microsoft's Fast Track program. Each version of SQL Server introduces new features specifically for data warehousing - by applying the correct technique, feature, hint, modelling approach and layout the data warehouse will be faster and more scalable.
Speaker(s): Doug Barrett,
Abstract:
Slow running packages? SSIS consuming all your resources? No idea what it's doing? After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. You will also be armed with a list of transformations and perfmon counters to watch out for.
Speaker(s): David Eichner,
Abstract:
SQL Server 2008 R2 supports up to 256 logical processors! Intel has released CPUs that support 10 cores and hyper-threading. So a quad-socket commodity server can easily support 80 logical processors. It's time for DBAs and Developers to understand how parallelism works in SQL Server! There are a lot of myths and misconceptions about how parallelism works in SQL Server and, more importantly, how to troubleshoot and solve parallelism problems. CXPACKET waits are not necessarily bad! In this session, Victor Isakov (MCT, MCM, MCA) will cover how parallelism works before presenting how to detect, troubleshoot and solve parallelism problems.
Speaker(s): Victor Isakov,
Abstract:
SQL Server And Oracle: Tips, Tricks and Traps for Working In A Heterogeneous DB Environment In this session I will present and discuss managing an environment that includes both SQL Server (our main development platform is .Net/SQL Server) and Oracle in which data moves in both directions. The session is organized in 3 major sections: Getting Data Out Of Oracle into SQL Server Getting Data into Oracle from SQL Server Managing Differences between the environments
Speaker(s): Steve Moss,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Ben is an accomplished business and technology professional with significant management experience and hands-on involvement in a wide variety of business areas, including Finance, Marketing, Operations, and Information Systems. He is skilled at designing, implementing, and managing complex business information systems. Ben leads the Business Intelligence and Productivity practice at CSG Professional Services, Inc. He has overseen and participated in many DW/BI projects for clients ranging in size from small manufacturers to regional utilities and national banks. Ben has given dozens of presentations and workshops on DW/BI and Productivity concepts and practices, and he loves to both teach and learn.
Contact: http://www.bradmcgehee.com
Brad M. McGehee is an MCSE+I, MCSD, and former MCT with a Bachelor’s degree in Economics and a Master's in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is a Microsoft SQL Server MVP with over 16 years' SQL Server experience. He has been involved in the industry since 1982. Brad is a frequent speaker at industry conferences and events, including PASS Summit, the European PASS Conference, SQL Server Connections, SQLTeach, devLINK, SQLBits, SQLSaturdays, Code Camps, and SQL Server user groups. He founded the popular community site SQL-Server-Performance.com, which he operated from 2000 through 2006, and is the author or co-author of more than 15 technical books and over 275 published articles. He blogs at www.bradmcgehee.com.
LinkedIn: https://www.linkedin.com/in/pturley
Contact: http://www.sqlserverbiblog.com
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
LinkedIn: http://www.linkedin.com/in/karenlopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality. Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
Contact: http://www.mitchespitch.com
Mitchell Bottel is a senior database administrator with Sutter Physician Services, owner of Innovative IT Consulting and President of the Sacramento SQL Sevrer User Group. He has 14 years of IT experience, focusing on SQL Server for the last ten years with an emphasis on database administration and high availability solutions. He has authored blog posts on the SQLServerPerformance website and written White Papers on using Dynamic Management Views.
LinkedIn: http://www.linkedin/in/carlosbossy
Contact: http://www.carlosbossy.com
Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.
Contact: http://dawabi.com/blog.aspx
Marc Beacom is President of DawaBI, a Data Warehouse and Business Intelligence Consultancy firm focusing on Making Data-Driven Decisions Possible. He has been working with SQL Server for over a decade delivering scalable solutions for organizations of all sizes. He has earned several industry certifications and degrees. Marc is an active member of the community and has volunteered for many organizations such as PASS, Denver SQL, Colorado GiveCamp, Camp To Belong, to name a few.
LinkedIn: http://uk.linkedin.com/in/neilhambly
Contact: http://dataidol.com/NeilHambly
Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.
LinkedIn: http://www.linkedin.com/in/robertldavis/
Contact: http://www.sqlsoldier.com
Robert is a SQL Server Certified Master, MVP, and has spent 17+ years honing his skills in security, performance tuning, SQL development, high availability, and disaster recovery. He served as PM for the SQL Server Certified Master Program at Microsoft Learning, and in various roles at Microsoft specializing in SQL Server administration, development, and architecture. He currently works as a Database Engineer at BlueMountain Capital Management where he spends a vast majority of his time tuning massively parallel queries. Robert feeds his passion for security by acting as co-leader of the PASS Security Virtual Chapter.
Rick has worked more than 12 years at Microsoft and has attained over 30 Microsoft technical including certifications in applications, networking, databases and .NET development (MCDBA, MCTS, MCITP, MCAD, MOE, MCSE, MCSE+I). He has also provided training for NW University, Volt Technical Education, The DigiGirlz, and Microsoft. Rick is the Author of the 5 volume SQL Joes 2 Pros book series.
LinkedIn: https://www.linkedin.com/in/emonchen
Erik has worked with the Microsoft BI products for over 7 years at different organizations in The Netherlands, Germany and the United States, responsible in the areas of information gathering to information delivery.
LinkedIn: http://www.linkedin.com/pub/dev-nambi/6/804/72b/
Contact: http://devnambi.com
Dev Nambi is a data scientist and aspiring polymath. He uses curiosity, math, and code to solve problems. Dev currently works in the University of Washington#39;s Enterprise Data amp; Analytics group.
LinkedIn: http://www.linkedin.com/pub/vern-rabe/a/ba3/980
Contact: http://www.rabedata.com
Vern Rabe is an independent SQL Server consultant and contract trainer in Portland, OR, and leader of the Oregon Data Community user group, formerly OregonSQL. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been passionate about databases since 1992 and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server knowledge gained from the mixture of academic and practical experiences acquired from his classroom instructing and varied consulting contracts. Vern regularly presents technical sessions at SQL Server user group meetings, SQLSaturdays, and PASS Summit.
LinkedIn: http://www.linkedin.com/in/icansoftware
David Eichner is a licensed CPA and is also CEO of ICAN Software Corporation, a Microsoft Dynamics amp; Acumatica ERP partner firm that sell and implements ERP and CRM software, develops software solutions and provides technology consulting. He is the host of a radio show called Business In The Cloud that airs weekly on KLAY 1180AM. He is skilled in building integrated cloud app solutions. His career spans more than 20 years in various technical/managerial positions within industries as diverse as military service, engineering/construction, municipal government, consulting and certified public accounting. Additionally, he holds various national certificates in technology (MCDBA, MCSE, CNE, CITP, Dynamics CRM and ERP, Acumatica CRM and ERP)
Contact: http://lobsterpot.com.au/bios
Rob Farley runs LobsterPot Solutions in Adelaide, Australia. He's delivering a precon at the PASS Summit, and has recently been appointed as an advisor to the PASS Board of Directors. He will also be performing a Lightning Talk at the Summit, and may even get his guitar out in Portland too. Hopefully by now he's received his sixth MVP award, and hopefully SQL Server MVP Deep Dives II is about to be published.
LinkedIn: http://www.linkedin.com/in/argenis
Contact: http://blog.purestorage.com/author/argenisfernandez/
Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.
LinkedIn: https://www.linkedin.com/in/pturley
Contact: http://www.sqlserverbiblog.com
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
 Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to become a database administrator for performance critical databases at Microsoft Corporation. Since then, Kendra has worked internationally as a teacher and consultant, and founded the training site SQL Workbooks. She joined Redgate as a Product Evangelist in 2018.
Contact: http://edquick.blogspot.com/
Ed is currently a Senior DBA at SurveyMonkey supporting several multi-terabyte databases running on SQL Server2008 R2. He has been working with SQL Server for the past 9 years, the last 7 as a DBA. Prior to joining SurveyMonkey he worked in the healthcare and research arenas.
Steve Moss is the Data Architect at Ecova, the total energy and sustainability management company whose sole purpose is to see more, save more and sustain more for our clients. Steve has been working in IT for over 13 years as a Data Architect, Manager of Database Administration, Sr. DBA and Systems Consultant. He specializes in Microsoft data-centric techologies, including SQL Server, Analysis Services, Integration Services and other associated data technologies.
LinkedIn: http://www.linkedin.com/pub/janis-griffin/0/914/aba
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Contact: http://www.mofumobi.com
With years of experience in the technology industry, the MofuMobi Team has a practical understanding of what kind of software will works for a user and what will not. Our goal is to enhance any area of product functionality and overall user experience for busy individuals. Having a few years of experience with SBI software, the parent company to MofuMobi, a unique point-of view helps bridge the gap between technology and the user.
Sopheap Suy is a SQL Server Developer at WebMD with 14 years in SQL Server Database technologies. She enjoys making things run better and faster. She is passionate about SQL Server technologies and always looking for ways to learn and share her knowledge. She is actively involved in her local PASS chapter and her interests include SQL Server Development, Administration, and Data Architecture. She lives in Portland, OR with her husband, and 3 children.
LinkedIn: https://www.linkedin.com/in/timothyford
Contact: http://thesqlagentman.com
Tim Ford is a Data Professional, Author and Community Leader whose technical passions lie in creative solutions for managing and presenting data. He#39;s been a healthcare DBA since 2000 and leads SQL Agent Man Consultancy and SQL Cruise. He takes 25 students and leaders in the SQL Community and places them on cruise ships for technical and professional development training without the distractions of the office and internet twice a year on SQL Cruises (www.sqlcruise.com). Currently Tim serves on the Board of Directors for PASS and is passionate about taking fellow Data Professionals to the next level in their careers. He enjoys telling stories with data.
Bilal founded and continue to lead the AdCenter OLAP development team. He has more than eighteen years of experience in software development and delivering production quality code and analytic solutions for a wide range of enterprises.
LinkedIn: http://www.linkedin.com/in/buckwoody
Contact: http://buckwoody.wordpress.com/
Born helpless, naked, and unable to provide for himself, Buck Woody overcame these amazing handicaps to become a software developer, data professional, teacher, and a productive invertebrate member of society.
Contact: http://www.douglane.net
Doug Lane (MCITP, MCTS) is a consultant with Brent Ozar Unlimited and has over 14 years' experience with SQL Server. He blogs about SQL Server with emphasis on Reporting Services and professional development.
Douglas Barrett draws on 15 years of data warehouse experience, including 10 years as a Consultant and solution specialist for Microsoft and WhereScape, delivering data warehouse projects using agile tools and techniques. Major data warehouse projects have included Basel II Credit Risk for a Retail Bank, Airline Travel Agent, Hospital Episode of Care, Hotel Occupancy and Utility companies.
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo is co-founder and RD lead of perFact BV, a Dutch company that improves analysis methods and develops computer-aided tools to generate completely functional applications from the analysis deliverable. The platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. Hugo is also a SQL Server MVP since 2006.
LinkedIn: http://www.linkedin.com/pub/allen-white-sql-server-mvp/5/784/b08/
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
LinkedIn: http://www.sqlnotes.info
Contact: http://www.sqlnotes.info
John Huang, SQL MCM and MVP, has been working with SQL Server since 1994. He is an independent SQL Server consultant in Vancouver specialized in complex data processing, data warehouse, and performance tuning.
Contact: http://persistencevision.blogspot.com/
Rob is a Data Architect working for Fiserv in Portland, Oregon. He has over twenty years of IT experience, with most of that time focused on transactional SQL Server. He has a number of articles published and speaks regularly at user groups and other events.
Contact: http://christinaleo.net
Christina Leo is a Cloud Solution Architect at Microsoft specialising in the Data and AI Platform. Prior to joining Microsoft in 2016, she worked as an independent consultant focusing on T-SQL and BI development, as well as database performance tuning in the finance and investment banking sector. When she isn't sharing her 18 years of technical experience with the data community, you can find her racing around the Solent on a 40' sailboat or often in the Thames on a little Laser.
LinkedIn: http://www.linkedin.com/pub/allen-white-sql-server-mvp/5/784/b08/
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Deepak is a SQL Server MVP and a Business Intelligence Consultant who has been working with SQL Server Analysis Services since 2000. He's an active contributor to the MSDN Analysis Services Forum and a regular presenter at Ohio North SQL Server User Group meetings.
Contact: http://blogs.h2dclan.com
Harry Chandra is a SQL Server Database Administrator for a software company in Portland, Oregon with a Bachelor of Arts Degree in Information System from Portland State University. He's been working with various releases of SQL Server for over 4 years. His main focus is in Administration and High Availability for SQL Server, although he has always strived to expand his knowledge into other area of SQL Server. He is a member of the Portland SQL Server User Group and SQL Pass member.
LinkedIn: http://au.linkedin.com/in/robfarley/
Contact: http://blogs.lobsterpot.com.au
Rob Farley runs LobsterPot Solutions in Australia, where he's a consultant in the Microsoft Data Platform and Analytics space. He's been an MVP since 2006, probably because of his blogging, his presentations around the world, and his dedication to the Adelaide Data Analytics User Group which he has led since before the release of SQL Server 2005. He's on Twitter at @rob_farley, but you can always email him using<EMAIL_ADDRESS>LinkedIn: http://www.linkedin.com/in/erinstellato
Contact: http://www.sqlskills.com/blogs/erin
Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.
Contact: http://www.victorisakov.com
Victor Isakov (MCA, MCM, MCT, MVP) is a Database Architect and Trainer who provides consulting and training services to various organizations in the public, private and NGO sectors globally. He regularly speaks at international conferences such as Microsoft TechEd, SQL Connections, PASS Summit and SQL Code Camp and authored a number of books on SQL Server. He worked with Microsoft to develop the SQL Server exams and certification. He was one of the first Microsoft Certified Masters / Architects.
LinkedIn: http://www.linkedin.com/in/jesborland
Contact: https://blogs.lessthandot.com/author/jes-borland
Jes Schultz is a Software Engineer with Microsoft who has experience with a wide range of SQL Server features from version 2005 through 2019, and is on the cutting edge with Azure technologies. Since graduating Fox Valley Technical College with an IT-Programmer/Analyst degree, Jes has worked as an SSRS developer, DBA, and consultant. Before joining Microsoft, Jes was a six-time Data Platform MVP, recognized for her community work. Jes tackles every project and problem with tenacity and her enthusiasm is unmatched in the SQL Server community. In her free time, Jes never stops moving, and counts fitness, coffee, cooking, and travel as essentials in life.
The following is a list of sponsors that helped fund the event.


A channel to discuss trading. For useful links and more info click the pinned messages to the right.
100 messages
Before 05-Dec-19 12:00 AM
Deleted User17-Feb-19 02:59 AM
Why is KMD pumping?
Cryptofist17-Feb-19 03:00 AM
My theory is someone really wants the weekly candle to close in a good spot, so they are market making
Theres def been some whale wall action for the last 2 weeks
I had more to say up^ there
yorklab17-Feb-19 03:01 AM
They have been busy developing the platform the previous year, and I think between now and the end of this year we'll see the fruits of their labor.
I suspect we'll be hearing a lot from Komodo over the next 10 months.
1
Gordon Komodo17-Feb-19 03:13 AM
what will happen after the 10 months?
Sdunbar17-Feb-19 03:15 AM
85 cents
3
Likewise17-Feb-19 03:16 AM
8$.50 cents sounds more like it
Sdunbar17-Feb-19 03:18 AM
that would be amazing lol
Likewise17-Feb-19 03:23 AM
on longer term if it gets traction, sure why not. Look at what ETH did in 2017
not saying it will, but the possibility is there once and when a sustained bull run in crypto land starts.
KSanJuan17-Feb-19 03:36 AM
Comparing ETH to KMD isn't even quite fair. They are such different projects with one already near its maximum potential, while KMD is just now getting out into the wild and ready to show itself and its limitless potential to the world.
KMD/BTC CHART (Exchange: Binance) Indicators used: - Interval: 360. Published on Coinigy.com @2019-02-17 03:49:05
Likewise17-Feb-19 03:55 AM
oah the kid is here, missed u son
havent broken 0.00025 still no progress
still waiting for those trading results, if you dont have any, sto pwasting my time kid
Alright17-Feb-19 03:57 AM
@ComputerGenie 👴👴👴 I noticed you're a lot more focused on trading lately. Throw in the towel on mining business?(edited)
Likewise17-Feb-19 03:58 AM
he better not, he'll be broke in no time lol
Alright17-Feb-19 03:59 AM
I can't tell if you're playfully provoking him or actually mad at him
Likewise17-Feb-19 03:59 AM
playfully provocing
I dont get mad
Alright17-Feb-19 03:59 AM
I think anything genie gets involved with he will be good at
Likewise17-Feb-19 04:00 AM
20 years in asia teaches u that getting mad serves no purpose at all, however taking the mickey out of hin I like. Well I am waiting for his results, I can show mine.......
Alright17-Feb-19 04:00 AM
If he focuses on learning day trading, he'd be a pro within a few months. Dude does not do things lightly(edited)
either all in or nothing it seems
Likewise17-Feb-19 04:01 AM
day trading hey, hmm, most day traders lose their asses. Lonmger term swing trades are usually better RR
been in the trading game since 2006, live off it since then so do know my way around I suppose.
Alright17-Feb-19 04:01 AM
day trade, swing trade
all the same to me
Likewise17-Feb-19 04:01 AM
it isnt
Alright17-Feb-19 04:01 AM
sideways is what I want
Likewise17-Feb-19 04:09 AM
However I jsut noticed that he is on the dev list, hmm, not a good way to insult your investors, hence why I see he is a kid still.
1
yorklab17-Feb-19 04:38 AM
what will happen after the 10 months?
LOL, yea I guess the way I stated it, it does sounds like it ends after that. Only meant if you follow what the team has been posting they plan on releasing some important projects between now and end of year. Next year is too far in advance to know what will be next. So course the answer is...it continues to grow.
^ KMD and MANA are my two largest positions. Please make that happen
hastrup17-Feb-19 08:42 AM
@meatspoon If you create an atmosphere in which Genie can do no wrong and is allowed to be rude and aggressive to everyone.... and he posts constantly in all channels... you are setting the tone for this discord
I support this view
4
hastrup17-Feb-19 08:51 AM
@Alexfrog why don't you offer your help so "this" have a better chance to make it. I'm i none coder. Here are 3 things that a none coder can do to help a project.
1: translation
2: paying for a cloud pc like one from digitalOcean for testing
3: offer to help beta test new apps
However I jsut noticed that he is on the dev list, hmm, not a good way to insult your investors
@Likewise What team dev did you see "insulting investors"?
Cryptoon17-Feb-19 12:43 PM
if genie is way out of line feel free to point him to his bulshit, but don't expect not to get backlash. I also think that a lot of the stuff he says is to provoke people like saying btc is crap
btc is not the best crypto it can be, but nonetheless it currently is the big daddy of the entire crypto marktet from a price pov
And one could start argueing about that etc, but to what point
Better to invest your energy in other stuff
Everyone is entitled to his/hers/their opinion and everyone is free to debate and critisize other people's points of view
just try be be somewhat kind to one another and dont start calling names etc
yorklab17-Feb-19 12:45 PM
As long as the personal attacks are left out.
ComputerGenie 👴👴👴17-Feb-19 12:45 PM
I also think that a lot of the stuff he says is to provoke people like saying btc is crap
While the 1st bit may be true, the 2nd isn't part of that; I truly despise BTC
Cryptoon17-Feb-19 12:45 PM
I know you truely do :p
richardt17-Feb-19 02:14 PM
Hmmm... Koreans are really into gaming aren't they?
Reel Em In17-Feb-19 02:21 PM
wow, nice move
jl777c17-Feb-19 02:22 PM
but it was guaranteed to go below 20k...
3
1
ComputerGenie 👴👴👴17-Feb-19 02:24 PM
starts to wonder if he should quit trying to learn to code and just go into trading full time
CHMEX17-Feb-19 02:25 PM
what is your passion?
ComputerGenie 👴👴👴17-Feb-19 02:27 PM
spending time with wife
CHMEX17-Feb-19 02:29 PM
I see she is supportive
ComputerGenie 👴👴👴17-Feb-19 02:31 PM
exceptionally so
In more than a decade and a half of marriage, I don't think she's ever gotten my full attention 2 entire days in a row


Sen. Mazie Hirono of Hawaii is writing memoir, due in 2021
NEW YORK (AP) - Sen. Mazie Hirono of Hawaii, the Senate’s first Asian American woman and only current immigrant, is working on a memoir.
Viking announced Tuesday that the book, currently untitled, will come out in 2021.
Hirono, 72, will write about emigrating at age 8 to the United States after her mother fled an abusive marriage in Japan. In a statement issued through Viking, Hirono said the book was a tribute to her mother’s spirit.
“My deep emotional connection to my mother, a remarkable woman who made a hard choice to save her children, and who valiantly struggled to care for us as a single parent, is the current that has driven my entire life,” Hirono said in a statement. “Now, because she can no longer bear witness for herself, I am choosing to bear witness on her behalf by telling the story of the daughter she inspired to live boldly and to fight for the promises of this country.”
Hirono, a Democrat, is currently serving her second term in the Senate. She made news last year as a leading critic of Supreme Court nominee Brett Kavanaugh, who faced allegations of sexual harassment and attempted assault. Kavanaugh, who was narrowly confirmed, denied the allegations.
Sign up for Daily Newsletters
Copyright © 2019 The Washington Times, LLC.
Please read our comment policy before commenting.


Password Helper App
Check User entered password satisfies the given criteria
more_vert
close
Password Generation Rules
Lowercase Letters
Uppercase Letters
Numbers
Special Characters @ # $ % ^ & * ( ) - _ ] [ ; : gt; , . ?
Valid Length between 8 and 125
Enter Password
Check Password
Reset
Generate password based on user criteria chosen
more_vert
close
Lowercase Letters
Uppercase Letters
Special Characters
Numbers
Length 8 to 120 characters
Generate password
Password Generated
Reset
Copy to Clipboard


{{data.newsParagraph}}
| Description | Value |
|---|---|
| Equatorial Diameter: | 6,792 km |
| Polar Diameter: | 6,752 km |
| Mass: | 6.42 x 10^23 kg (10.7% Earth) |
| Moons: | 2 (Phobos & Deimos) |
| Orbit Distance: | 227,943,824 km (1.52 AU) |
| Orbit Period: | 687 days (1.9 years) |
| Surface Temperature: | -153 to 20 Degrees C |
| First Record: | 2nd millennium BC |
| Recorded By: | Egyptian astronomers |


Try out our Premium Member services: Virtual Legal Assistant, Query Alert Service and an ad-free experience. Free for one month and pay only if you like it.
IN THE HIGH COURT OF JHARKHAND AT RANCHI A.B.A. No. 5045 of 2018 1.Surendra Singh 2.Ajit Singh @ Ajit Kumar Singh 3.Ranjeet Mehta @ Ranjeet Kr. Mehta 4.Ganesh Munda 5.Sanjay Kumar @ Sanjay Mehta ..... Petitioners Versus The State of Jharkhand ..... Opp. Party ---------
CORAM: HON'BLE MR. JUSTICE ANANT BIJAY SINGH
---------
For the Petitioners : Mr. Pradeep Kr. Nayak, Advocate.
For the State : A.P.P. --------- 02/Dated: 04/09/2018
Petitioners are apprehending their arrest in connection with Ormanjhi P.S. Case No. 52 of 2018, corresponding to G.R. No. 2038 of 2018, registered under Section 379 of the I.P.C., Section 21 (A), 31 (A) / 37 of Air Pollution Control Act and Section 54 of the M.M.C.R. Act, 2004 and Section 8 / 9 of the J.M.S. Act, 2007.
Learned counsel for the petitioners submitted that petitioners have been falsely implicated in this case and the co- accused have been admitted on anticipatory bail under order dated 25.08.2018 in A.B.A. No. 4850 of 2018 on certain conditions.
Learned APP has opposed the prayer for anticipatory bail. Be that as it may, I am inclined to admit the petitioners on anticipatory bail. The above named petitioners is directed to surrender in the Court below within four weeks from the date of this order and in the event of their arrest or surrender, the Court below shall enlarge the above named petitioners on bail on furnishing bail bonds of Rs. 15,000/- (Rupees fifteen thousand) each with two sureties of the like amount each to the satisfaction of Chief Judicial Magistrate, Ranchi, in connection with Ormanjhi P.S. Case No. 52 of 2018, corresponding to G.R. No. 2038 of 2018, subject to the conditions as laid down under Section 438(2) of the Cr.P.C. and subject to the further condition that on the date of surrender, petitioners shall deposit Rs. 5,000/- each in the court below, which shall be subject to the result of the case and will not prejudice the case of the petitioners during trial.
(Anant Bijay Singh, J.) Sunil/


kernel_resource_sizes
Structure - Used to present the sizes of kernel's major structures.
SYNOPSIS
struct kernel_resource_sizes { vm_size_t task; vm_size_t thread; vm_size_t port; vm_size_t memory_region; vm_size_t memory_object; }; typedef struct kernel_resource_sizes* kernel_resource_sizes_t;
FIELDS
- task
-
Space consumed by an empty task.
- thread
-
Space consumed by a thread.
- port
-
Space consumed by a port with an empty message queue.
- memory_region
-
Space consumed by each distinct memory region (as reported by
vm_region) in a task's address space.
- memory_object
- Space consumed to manage a memory object with no resident pages or copy objects.
DESCRIPTION
The kernel_resource_sizes structure defines the sizes of significant kernel structures.
RELATED INFORMATION
Functions: host_info.


Hello, my name is Kristina Yin and I am currently a graduate student pursuing a Master's degree from Northeastern University in San Francisco. I have a background in foreign language and recieved a BA in Russian from the University of Maryland, College Park.
I am passionate about coding, gaming, art, and bubble tea.
I am based in the Maryland/DC area and the SF Bay Area.


{% extends "homepage.html"%} {% block title %}About Me{% endblock %} {% block head%} {{ super() }} {% endblock%} {% block page_content%}
I have experience in the following programming languages:
This project is developed by Kevin Gicheha.


@* * Copyright 2021 HM Revenue & Customs * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. *@ @import helper.{inputRadioGroup => _, _} @import sdil.config.AppConfig @import views.html.uniform.helpers._ @this(main: main_template) @(key: String, form: Form[Unit], breadcrumbs: List[String], tell: Html)(implicit messages: Messages, request: Request[_], config: AppConfig, extraMessages: ExtraMessages, lang: Lang) @main(Messages(Seq(s"heading.$key", "sdil.variations.title")), form = Some(form)) { @backlink(breadcrumbs) @if(messages.isDefinedAt(s"heading.$key.orgName")) {
}


--- layout: subpage title: List of EOS observables ---
The following is a (incomplete) list observables that EOS can predict.


Meeting point-2
问题描述 :
It has been ten years since TJU-ACM established. And in this year all the retired TJU-ACMers want to get together to celebrate the tenth anniversary. Because the retired TJU-ACMers may live in different places around the world, it may be hard to find out where to celebrate this meeting in order to minimize the sum travel time of all the retired TJU-ACMers.

There is an infinite integer grid at which N retired TJU-ACMers have their houses on. They decide to unite at a common meeting place, which is someone’s house. From any given cell, all 8 adjacent cells are reachable in 1 unit of time.
Eg: (x,y) can be reached from (x-1,y), (x+1,y), (x, y-1), (x, y+1), (x-1,y+1), (x-1,y-1), (x+1,y+1), (x+1,y-1).
Finding a common meeting place which minimizes the sum of the travel time of all the retired TJU-ACMers.
输入:
The first line is an integer T represents there are T test cases. (0<T <=10)
For each test case, the first line is an integer n represents there are n retired TJU-ACMers. (0<n<=100000), the following n lines each contains two integers x, y coordinate of the i-th TJU-ACMer. (-10^9 <= x,y <= 10^9)
For each test case, the first line is an integer n represents there are n retired TJU-ACMers. (0<n<=100000), the following n lines each contains two integers x, y coordinate of the i-th TJU-ACMer. (-10^9 <= x,y <= 10^9)
输出:
The first line is an integer T represents there are T test cases. (0<T <=10)
For each test case, the first line is an integer n represents there are n retired TJU-ACMers. (0<n<=100000), the following n lines each contains two integers x, y coordinate of the i-th TJU-ACMer. (-10^9 <= x,y <= 10^9)
For each test case, the first line is an integer n represents there are n retired TJU-ACMers. (0<n<=100000), the following n lines each contains two integers x, y coordinate of the i-th TJU-ACMer. (-10^9 <= x,y <= 10^9)
样例输入:
4 6 -4 -1 -1 -2 2 -4 0 2 0 3 5 -2 6 0 0 2 0 -5 -2 2 -2 -1 2 4 0 5 -5 1 -1 3 3 1 3 -1 1 -1 10 -1 -1 -3 2 -4 4 5 2 5 -4 3 -1 4 3 -1 -2 3 4 -2 2
样例输出:
20 15 14 38HintIn the first case, the meeting point is (0,2); the second is (0,0), the third is (1,-1) and the last is (-1,-1)
#include<iostream> #include<stdio.h> #include<string.h> #include<algorithm> using namespace std; const int maxn = 100005; struct point{ long long x,y,id; }; point d[maxn]; long long dx[maxn],dy[maxn]; bool cmpx(point a,point b){ return a.x < b.x; } bool cmpy(point a,point b){ return a.y < b.y; } int main(){ int t; scanf("%d",&t); while(t --){ int n; scanf("%d",&n); long long xx,yy; for(int i = 0;i < n;i ++){ scanf("%I64d%I64d",&xx,&yy); d[i].x = xx - yy; d[i].y = xx + yy; d[i].id = i; } sort(d,d + n,cmpx); long long minn = 0; long long tx = 0; for(int i = 1;i < n;i ++){ tx += d[i].x - d[0].x; } minn += tx; dx[d[0].id] = tx; for(int i = 1;i < n;i ++){ tx += i * (d[i].x - d[i - 1].x) - (n - i) * (d[i].x - d[i - 1].x); dx[d[i].id] = tx; } sort(d,d + n,cmpy); long long ty = 0; for(int i = 1;i < n;i ++){ ty += d[i].y - d[0].y; } dy[d[0].id] = ty; minn += ty; for(int i = 1;i < n;i ++){ ty += i * (d[i].y - d[i - 1].y) - (n - i) * (d[i].y - d[i - 1].y); dy[d[i].id] = ty; } for(int i = 0;i < n;i ++){ if(minn > dx[i] + dy[i])minn = dx[i] + dy[i]; } printf("%I64d\n",minn / 2); } return 0; }
(adsbygoogle = window.adsbygoogle || []).push({});
发自己的图让别人去说吧
打开www.np33.pw都是开放女
打开www.np33.pw都是开放女
打开www.np33.pw都是开放女
打开www.np33.pw都是开放女
打开www.np33.pw都是开放女


No client apps have been created in this organization yet. Create a client app using the New Client button.
No Client Apps found matching your filter criteria - please try searching for something different.


Profile
Wilfred Strating Design was established in 1988 and provides personalized, professional design and drafting service to the Brisbane Southside Area.
Wilfred Strating is a qualified Architectural Draftsman having obtained a Certificate for Architectural Technician from Q.I.T in 1978.
Prior to becoming self employed, Wilfred worked for number of different Architectural Practises and Drafting Offices throughout Brisbane.
Our Fees are very reasonable for professionally drawn plans in CAD (Computer Assisted Drawings) using a 3D CAD application.
We can also organize Soil Test and Engineering Design through our consulting Engineers.
The advantage of dealing with Wilfred Strating Design, is that all the work is done personally. We do not have employees or outsource any of the work, which means we keep control of the quality and standard of the work.
I have been a proud member of the HIA since 1995.


Grizzly Parking
Download Now!
Download Now!
Download Now!
Previous
Next
Meet the Team
Gianluca Parili
Joshua Tran
Chelsea D'Allessandro


I'm Gerard Ng, a software developer enthusiastic about developing web and mobile applications, software programs and managing databases. I recently completed the rigorous BCIT Computer Systems Technology: Database Option program this December. I am passionate about the world of programming, games and technology as a whole. I grew up in the Philippines but spent my entire post-secondary life in Richmond, BC. When not coding, I usually play various sports such as basketball, browse reddit, listen to podcasts and watch netflix!


I recently ordered a 1/4 ounce of Sceletium Tortuosum for $40 USD after reading some historical information and old trip reports on an ethnobotanical website. I received my package which contained a baggie of brown, fine ground powder. Some of the historical information mentioned that sceletium had been snorted by indiginous African tribes. I snorted approximately 1gm of the fine powder. After about 15 minutes I began to feel a little giddy and got up to walk around. Soon thereafter I experienced a powerful rush that reminded me of the onset of MDMA. Over the next 30min., I had a few more of these rushes, though not quite as powerful as the first. For the next few hours, I experienced a potent caffeine-like buzz tinged with some euphoric elements. I became very talkative and stayed up late into the night. I was expecting something a little more sedate, but even so, the experience was fairly enjoyable.
About a week later, I mixed sceletium with some tobacco and smoked it. This was more similar to the relaxing sceletium experiences I had read about. Similar to cannabis but without the clouded thought and not as potent.
Overall, I think this herb deserves some more investigation.
Experience Reports are the writings and opinions of the individual authors who submit them.
Some of the activities described are dangerous and/or illegal and none are recommended by Erowid.


Welcome to RuFound! The service for notifying students of their missing IDs. Please fill out the boxes below including the location drop down menu. If middle name is not present then leave it empty and hit send to notify the student.


---
layout: default
---
{% if site.github.url %}
{% assign url_base = site.github.url %}
{% else %}
{% assign url_base = site.url %}
{% endif %}
- Home
- Organization Members
{% for m in site.posts reversed %}
{% if m.categories contains 'cmember' %}
{% endif %}
{% endfor %}
Become a Member
Join the openHAB Foundation and make the difference!
Membership


I graduated in Master dgeree in wireless communication.  I go to swimming in the weekend and i am regular user of GYM.
Apart from my University courses I taught my self c and c++ from MIT open courseware courses


Freebase browser
A simple UI on top of Freebase allowing to read a part of Freebase content.
The data is extracted from the latest Freebase dumps and available under the Licence Creative Commons BY 2.5.
Some entity examples
{% extends "base.html" %} {% block navLinks %}
A simple UI on top of Freebase allowing to read a part of Freebase content.
The data is extracted from the latest Freebase dumps and available under the Licence Creative Commons BY 2.5.
Some entity examples


| type_id | integer | 10 | UNIQUE, NOT NULL | cvterm.cvterm_id | |
| value | text | 64000 | NULL | ||
| rank | integer | 10 | 0 | UNIQUE, NOT NULL |
| Name | Fields |
|---|---|
| libraryprop_idx1 | library_id |
| libraryprop_idx2 | type_id |
| Type | Fields |
|---|---|
| NOT NULL | libraryprop_id |
| NOT NULL | library_id |
| FOREIGN KEY | library_id |
| NOT NULL | type_id |
| FOREIGN KEY | type_id |
| NOT NULL | rank |
| UNIQUE | library_id, type_id, rank |
libraryprop_pub |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| libraryprop_pub_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| libraryprop_id | integer | 10 | UNIQUE, NOT NULL | libraryprop.libraryprop_id | |
| pub_id | integer | 10 | UNIQUE, NOT NULL | pub.pub_id |
| Name | Fields |
|---|---|
| libraryprop_pub_idx1 | libraryprop_id |
| libraryprop_pub_idx2 | pub_id |
| Type | Fields |
|---|---|
| NOT NULL | libraryprop_pub_id |
| NOT NULL | libraryprop_id |
| FOREIGN KEY | libraryprop_id |
| NOT NULL | pub_id |
| FOREIGN KEY | pub_id |
| UNIQUE | libraryprop_id, pub_id |
library_cvterm |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| library_cvterm_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| library_id | integer | 10 | UNIQUE, NOT NULL | library.library_id | |
| cvterm_id | integer | 10 | UNIQUE, NOT NULL | cvterm.cvterm_id | |
| pub_id | integer | 10 | UNIQUE, NOT NULL | pub.pub_id |
| Name | Fields |
|---|---|
| library_cvterm_idx1 | library_id |
| library_cvterm_idx2 | cvterm_id |
| library_cvterm_idx3 | pub_id |
| Type | Fields |
|---|---|
| NOT NULL | library_cvterm_id |
| NOT NULL | library_id |
| FOREIGN KEY | library_id |
| NOT NULL | cvterm_id |
| FOREIGN KEY | cvterm_id |
| NOT NULL | pub_id |
| FOREIGN KEY | pub_id |
| UNIQUE | library_id, cvterm_id, pub_id |
library_feature |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| library_feature_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| library_id | integer | 10 | UNIQUE, NOT NULL | library.library_id | |
| feature_id | integer | 10 | UNIQUE, NOT NULL | feature.feature_id |
| Name | Fields |
|---|---|
| library_feature_idx1 | library_id |
| library_feature_idx2 | feature_id |
| Type | Fields |
|---|---|
| NOT NULL | library_feature_id |
| NOT NULL | library_id |
| FOREIGN KEY | library_id |
| NOT NULL | feature_id |
| FOREIGN KEY | feature_id |
| UNIQUE | library_id, feature_id |
library_dbxref |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| library_dbxref_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| library_id | integer | 10 | UNIQUE, NOT NULL | library.library_id | |
| dbxref_id | integer | 10 | UNIQUE, NOT NULL | dbxref.dbxref_id | |
| is_current | boolean | 0 | true | NOT NULL |
| Name | Fields |
|---|---|
| library_dbxref_idx1 | library_id |
| library_dbxref_idx2 | dbxref_id |
| Type | Fields |
|---|---|
| NOT NULL | library_dbxref_id |
| NOT NULL | library_id |
| FOREIGN KEY | library_id |
| NOT NULL | dbxref_id |
| FOREIGN KEY | dbxref_id |
| NOT NULL | is_current |
| UNIQUE | library_id, dbxref_id |
cell_line |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| cell_line_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| name | varchar | 255 | NULL | ||
| uniquename | varchar | 255 | UNIQUE, NOT NULL | ||
| organism_id | integer | 10 | UNIQUE, NOT NULL | organism.organism_id | |
| timeaccessioned | timestamp | 0 | current_timestamp | NOT NULL | |
| timelastmodified | timestamp | 0 | current_timestamp | NOT NULL |
| Type | Fields |
|---|---|
| NOT NULL | cell_line_id |
| NOT NULL | uniquename |
| NOT NULL | organism_id |
| FOREIGN KEY | organism_id |
| NOT NULL | timeaccessioned |
| NOT NULL | timelastmodified |
| UNIQUE | uniquename, organism_id |
cell_line_relationship |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| cell_line_relationship_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| subject_id | integer | 10 | UNIQUE, NOT NULL | cell_line.cell_line_id | |
| object_id | integer | 10 | UNIQUE, NOT NULL | cell_line.cell_line_id | |
| type_id | integer | 10 | UNIQUE, NOT NULL | cvterm.cvterm_id |
| Type | Fields |
|---|---|
| NOT NULL | cell_line_relationship_id |
| NOT NULL | subject_id |
| FOREIGN KEY | subject_id |
| NOT NULL | object_id |
| FOREIGN KEY | object_id |
| NOT NULL | type_id |
| FOREIGN KEY | type_id |
| UNIQUE | subject_id, object_id, type_id |
cell_line_synonym |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| cell_line_synonym_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| cell_line_id | integer | 10 | UNIQUE, NOT NULL | cell_line.cell_line_id | |
| synonym_id | integer | 10 | UNIQUE, NOT NULL | synonym.synonym_id | |
| pub_id | integer | 10 | UNIQUE, NOT NULL | pub.pub_id | |
| is_current | boolean | 0 | false | NOT NULL | |
| is_internal | boolean | 0 | false | NOT NULL |
| Type | Fields |
|---|---|
| NOT NULL | cell_line_synonym_id |
| NOT NULL | cell_line_id |
| FOREIGN KEY | cell_line_id |
| NOT NULL | synonym_id |
| FOREIGN KEY | synonym_id |
| NOT NULL | pub_id |
| FOREIGN KEY | pub_id |
| NOT NULL | is_current |
| NOT NULL | is_internal |
| UNIQUE | synonym_id, cell_line_id, pub_id |
cell_line_cvterm |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| cell_line_cvterm_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| cell_line_id | integer | 10 | UNIQUE, NOT NULL | cell_line.cell_line_id | |
| cvterm_id | integer | 10 | UNIQUE, NOT NULL | cvterm.cvterm_id | |
| pub_id | integer | 10 | UNIQUE, NOT NULL | pub.pub_id | |
| rank | integer | 10 | 0 | UNIQUE, NOT NULL |
| Type | Fields |
|---|---|
| NOT NULL | cell_line_cvterm_id |
| NOT NULL | cell_line_id |
| FOREIGN KEY | cell_line_id |
| NOT NULL | cvterm_id |
| FOREIGN KEY | cvterm_id |
| NOT NULL | pub_id |
| FOREIGN KEY | pub_id |
| NOT NULL | rank |
| UNIQUE | cell_line_id, cvterm_id, pub_id, rank |
cell_line_dbxref |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| cell_line_dbxref_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| cell_line_id | integer | 10 | UNIQUE, NOT NULL | cell_line.cell_line_id | |
| dbxref_id | integer | 10 | UNIQUE, NOT NULL | dbxref.dbxref_id | |
| is_current | boolean | 0 | true | NOT NULL |
| Type | Fields |
|---|---|
| NOT NULL | cell_line_dbxref_id |
| NOT NULL | cell_line_id |
| FOREIGN KEY | cell_line_id |
| NOT NULL | dbxref_id |
| FOREIGN KEY | dbxref_id |
| NOT NULL | is_current |
| UNIQUE | cell_line_id, dbxref_id |
cell_lineprop |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| cell_lineprop_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| cell_line_id | integer | 10 | UNIQUE, NOT NULL | cell_line.cell_line_id | |
| type_id | integer | 10 | UNIQUE, NOT NULL | cvterm.cvterm_id | |
| value | text | 64000 | NULL | ||
| rank | integer | 10 | 0 | UNIQUE, NOT NULL |
| Type | Fields |
|---|---|
| NOT NULL | cell_lineprop_id |
| NOT NULL | cell_line_id |
| FOREIGN KEY | cell_line_id |
| NOT NULL | type_id |
| FOREIGN KEY | type_id |
| NOT NULL | rank |
| UNIQUE | cell_line_id, type_id, rank |
cell_lineprop_pub |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| cell_lineprop_pub_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| cell_lineprop_id | integer | 10 | UNIQUE, NOT NULL | cell_lineprop.cell_lineprop_id | |
| pub_id | integer | 10 | UNIQUE, NOT NULL | pub.pub_id |
| Type | Fields |
|---|---|
| NOT NULL | cell_lineprop_pub_id |
| NOT NULL | cell_lineprop_id |
| FOREIGN KEY | cell_lineprop_id |
| NOT NULL | pub_id |
| FOREIGN KEY | pub_id |
| UNIQUE | cell_lineprop_id, pub_id |
cell_line_feature |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| cell_line_feature_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| cell_line_id | integer | 10 | UNIQUE, NOT NULL | cell_line.cell_line_id | |
| feature_id | integer | 10 | UNIQUE, NOT NULL | feature.feature_id | |
| pub_id | integer | 10 | UNIQUE, NOT NULL | pub.pub_id |
| Type | Fields |
|---|---|
| NOT NULL | cell_line_feature_id |
| NOT NULL | cell_line_id |
| FOREIGN KEY | cell_line_id |
| NOT NULL | feature_id |
| FOREIGN KEY | feature_id |
| NOT NULL | pub_id |
| FOREIGN KEY | pub_id |
| UNIQUE | cell_line_id, feature_id, pub_id |
cell_line_cvtermprop |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| cell_line_cvtermprop_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| cell_line_cvterm_id | integer | 10 | UNIQUE, NOT NULL | cell_line_cvterm.cell_line_cvterm_id | |
| type_id | integer | 10 | UNIQUE, NOT NULL | cvterm.cvterm_id | |
| value | text | 64000 | NULL | ||
| rank | integer | 10 | 0 | UNIQUE, NOT NULL |
| Type | Fields |
|---|---|
| NOT NULL | cell_line_cvtermprop_id |
| NOT NULL | cell_line_cvterm_id |
| FOREIGN KEY | cell_line_cvterm_id |
| NOT NULL | type_id |
| FOREIGN KEY | type_id |
| NOT NULL | rank |
| UNIQUE | cell_line_cvterm_id, type_id, rank |
cell_line_pub |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| cell_line_pub_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| cell_line_id | integer | 10 | UNIQUE, NOT NULL | cell_line.cell_line_id | |
| pub_id | integer | 10 | UNIQUE, NOT NULL | pub.pub_id |
| Type | Fields |
|---|---|
| NOT NULL | cell_line_pub_id |
| NOT NULL | cell_line_id |
| FOREIGN KEY | cell_line_id |
| NOT NULL | pub_id |
| FOREIGN KEY | pub_id |
| UNIQUE | cell_line_id, pub_id |
cell_line_library |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| cell_line_library_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| cell_line_id | integer | 10 | UNIQUE, NOT NULL | cell_line.cell_line_id | |
| library_id | integer | 10 | UNIQUE, NOT NULL | library.library_id | |
| pub_id | integer | 10 | UNIQUE, NOT NULL | pub.pub_id |
| Type | Fields |
|---|---|
| NOT NULL | cell_line_library_id |
| NOT NULL | cell_line_id |
| FOREIGN KEY | cell_line_id |
| NOT NULL | library_id |
| FOREIGN KEY | library_id |
| NOT NULL | pub_id |
| FOREIGN KEY | pub_id |
| UNIQUE | cell_line_id, library_id, pub_id |
nd_geolocation |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_geolocation_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| description | varchar | 255 | A textual representation of the location, if this is the original georeference. Optional if the original georeference is available in lat/long coordinates. | ||
| latitude | real | 10 | The decimal latitude coordinate of the georeference, using positive and negative sign to indicate N and S, respectively. | ||
| longitude | real | 10 | The decimal longitude coordinate of the georeference, using positive and negative sign to indicate E and W, respectively. | ||
| geodetic_datum | varchar | 32 | The geodetic system on which the geo-reference coordinates are based. For geo-references measured between 1984 and 2010, this will typically be WGS84. | ||
| altitude | real | 10 | The altitude (elevation) of the location in meters. If the altitude is only known as a range, this is the average, and altitude_dev will hold half of the width of the range. |
| Type | Fields |
|---|---|
| NOT NULL | nd_geolocation_id |
nd_experiment |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_experiment_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| nd_geolocation_id | integer | 10 | NOT NULL | nd_geolocation.nd_geolocation_id | |
| type_id | integer | 10 | NOT NULL | cvterm.cvterm_id |
| Type | Fields |
|---|---|
| NOT NULL | nd_experiment_id |
| NOT NULL | nd_geolocation_id |
| FOREIGN KEY | nd_geolocation_id |
| NOT NULL | type_id |
| FOREIGN KEY | type_id |
| FOREIGN KEY | nd_geolocation_id |
| FOREIGN KEY | type_id |
nd_experiment_project |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_experiment_project_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| project_id | integer | 10 | NOT NULL | project.project_id | |
| nd_experiment_id | integer | 10 | NOT NULL | nd_experiment.nd_experiment_id |
| Type | Fields |
|---|---|
| NOT NULL | nd_experiment_project_id |
| NOT NULL | project_id |
| FOREIGN KEY | project_id |
| NOT NULL | nd_experiment_id |
| FOREIGN KEY | nd_experiment_id |
| FOREIGN KEY | project_id |
| FOREIGN KEY | nd_experiment_id |
nd_experimentprop |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_experimentprop_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| nd_experiment_id | integer | 10 | UNIQUE, NOT NULL | nd_experiment.nd_experiment_id | |
| type_id | integer | 10 | UNIQUE, NOT NULL | cvterm.cvterm_id | |
| value | text | 64000 | NULL | ||
| rank | integer | 10 | 0 | UNIQUE, NOT NULL |
| Type | Fields |
|---|---|
| NOT NULL | nd_experimentprop_id |
| NOT NULL | nd_experiment_id |
| FOREIGN KEY | nd_experiment_id |
| NOT NULL | type_id |
| FOREIGN KEY | type_id |
| NOT NULL | rank |
| UNIQUE | nd_experiment_id, type_id, rank |
| FOREIGN KEY | nd_experiment_id |
| FOREIGN KEY | type_id |
nd_experiment_pub |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_experiment_pub_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| nd_experiment_id | integer | 10 | UNIQUE, NOT NULL | nd_experiment.nd_experiment_id | |
| pub_id | integer | 10 | UNIQUE, NOT NULL | pub.pub_id |
| Name | Fields |
|---|---|
| nd_experiment_pub_idx1 | nd_experiment_id |
| nd_experiment_pub_idx2 | pub_id |
| Type | Fields |
|---|---|
| NOT NULL | nd_experiment_pub_id |
| NOT NULL | nd_experiment_id |
| FOREIGN KEY | nd_experiment_id |
| NOT NULL | pub_id |
| FOREIGN KEY | pub_id |
| UNIQUE | nd_experiment_id, pub_id |
nd_geolocationprop |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_geolocationprop_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| nd_geolocation_id | integer | 10 | UNIQUE, NOT NULL | nd_geolocation.nd_geolocation_id | |
| type_id | integer | 10 | UNIQUE, NOT NULL, The name of the property as a reference to a controlled vocabulary term. | cvterm.cvterm_id | |
| value | text | 64000 | NULL | The value of the property. | |
| rank | integer | 10 | 0 | UNIQUE, NOT NULL, The rank of the property value, if the property has an array of values. |
| Type | Fields |
|---|---|
| NOT NULL | nd_geolocationprop_id |
| NOT NULL | nd_geolocation_id |
| FOREIGN KEY | nd_geolocation_id |
| NOT NULL | type_id |
| FOREIGN KEY | type_id |
| NOT NULL | rank |
| UNIQUE | nd_geolocation_id, type_id, rank |
| FOREIGN KEY | nd_geolocation_id |
| FOREIGN KEY | type_id |
nd_protocol |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_protocol_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| name | varchar | 255 | UNIQUE, NOT NULL, The protocol name. | ||
| type_id | integer | 10 | NOT NULL | cvterm.cvterm_id |
| Type | Fields |
|---|---|
| NOT NULL | nd_protocol_id |
| NOT NULL | name |
| UNIQUE | name |
| NOT NULL | type_id |
| FOREIGN KEY | type_id |
| FOREIGN KEY | type_id |
nd_reagent |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_reagent_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| name | varchar | 80 | NOT NULL, The name of the reagent. The name should be unique for a given type. | ||
| type_id | integer | 10 | NOT NULL, The type of the reagent, for example linker oligomer, or forward primer. | cvterm.cvterm_id | |
| feature_id | integer | 10 | If the reagent is a primer, the feature that it corresponds to. More generally, the corresponding feature for any reagent that has a sequence that maps to another sequence. |
| Type | Fields |
|---|---|
| NOT NULL | nd_reagent_id |
| NOT NULL | name |
| NOT NULL | type_id |
| FOREIGN KEY | type_id |
| FOREIGN KEY | type_id |
nd_protocol_reagent |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_protocol_reagent_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| nd_protocol_id | integer | 10 | NOT NULL | nd_protocol.nd_protocol_id | |
| reagent_id | integer | 10 | NOT NULL | nd_reagent.nd_reagent_id | |
| type_id | integer | 10 | NOT NULL | cvterm.cvterm_id |
| Type | Fields |
|---|---|
| NOT NULL | nd_protocol_reagent_id |
| NOT NULL | nd_protocol_id |
| FOREIGN KEY | nd_protocol_id |
| NOT NULL | reagent_id |
| FOREIGN KEY | reagent_id |
| NOT NULL | type_id |
| FOREIGN KEY | type_id |
| FOREIGN KEY | nd_protocol_id |
| FOREIGN KEY | reagent_id |
| FOREIGN KEY | type_id |
nd_protocolprop |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_protocolprop_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| nd_protocol_id | integer | 10 | UNIQUE, NOT NULL, The protocol to which the property applies. | nd_protocol.nd_protocol_id | |
| type_id | integer | 10 | UNIQUE, NOT NULL, The name of the property as a reference to a controlled vocabulary term. | cvterm.cvterm_id | |
| value | text | 64000 | NULL | The value of the property. | |
| rank | integer | 10 | 0 | UNIQUE, NOT NULL, The rank of the property value, if the property has an array of values. |
| Type | Fields |
|---|---|
| NOT NULL | nd_protocolprop_id |
| NOT NULL | nd_protocol_id |
| FOREIGN KEY | nd_protocol_id |
| NOT NULL | type_id |
| FOREIGN KEY | type_id |
| NOT NULL | rank |
| UNIQUE | nd_protocol_id, type_id, rank |
| FOREIGN KEY | nd_protocol_id |
| FOREIGN KEY | type_id |
nd_experiment_stock |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_experiment_stock_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| nd_experiment_id | integer | 10 | NOT NULL | nd_experiment.nd_experiment_id | |
| stock_id | integer | 10 | NOT NULL, stock used in the extraction or the corresponding stock for the clone | stock.stock_id | |
| type_id | integer | 10 | NOT NULL | cvterm.cvterm_id |
| Type | Fields |
|---|---|
| NOT NULL | nd_experiment_stock_id |
| NOT NULL | nd_experiment_id |
| FOREIGN KEY | nd_experiment_id |
| NOT NULL | stock_id |
| FOREIGN KEY | stock_id |
| NOT NULL | type_id |
| FOREIGN KEY | type_id |
| FOREIGN KEY | nd_experiment_id |
| FOREIGN KEY | stock_id |
| FOREIGN KEY | type_id |
nd_experiment_protocol |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_experiment_protocol_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| nd_experiment_id | integer | 10 | NOT NULL | nd_experiment.nd_experiment_id | |
| nd_protocol_id | integer | 10 | NOT NULL | nd_protocol.nd_protocol_id |
| Type | Fields |
|---|---|
| NOT NULL | nd_experiment_protocol_id |
| NOT NULL | nd_experiment_id |
| FOREIGN KEY | nd_experiment_id |
| NOT NULL | nd_protocol_id |
| FOREIGN KEY | nd_protocol_id |
| FOREIGN KEY | nd_experiment_id |
| FOREIGN KEY | nd_protocol_id |
nd_experiment_phenotype |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_experiment_phenotype_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| nd_experiment_id | integer | 10 | UNIQUE, NOT NULL | nd_experiment.nd_experiment_id | |
| phenotype_id | integer | 10 | UNIQUE, NOT NULL | phenotype.phenotype_id |
| Type | Fields |
|---|---|
| NOT NULL | nd_experiment_phenotype_id |
| NOT NULL | nd_experiment_id |
| FOREIGN KEY | nd_experiment_id |
| NOT NULL | phenotype_id |
| FOREIGN KEY | phenotype_id |
| UNIQUE | nd_experiment_id, phenotype_id |
| FOREIGN KEY | nd_experiment_id |
| FOREIGN KEY | phenotype_id |
nd_experiment_genotype |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_experiment_genotype_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| nd_experiment_id | integer | 10 | UNIQUE, NOT NULL | nd_experiment.nd_experiment_id | |
| genotype_id | integer | 10 | UNIQUE, NOT NULL | genotype.genotype_id |
| Type | Fields |
|---|---|
| NOT NULL | nd_experiment_genotype_id |
| NOT NULL | nd_experiment_id |
| FOREIGN KEY | nd_experiment_id |
| NOT NULL | genotype_id |
| FOREIGN KEY | genotype_id |
| UNIQUE | nd_experiment_id, genotype_id |
| FOREIGN KEY | nd_experiment_id |
| FOREIGN KEY | genotype_id |
nd_reagent_relationship |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_reagent_relationship_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| subject_reagent_id | integer | 10 | NOT NULL, The subject reagent in the relationship. In parent/child terminology, the subject is the child. For example, in "linkerA 3prime-overhang-linker enzymeA" linkerA is the subject, 3prime-overhand-linker is the type, and enzymeA is the object. | nd_reagent.nd_reagent_id | |
| object_reagent_id | integer | 10 | NOT NULL, The object reagent in the relationship. In parent/child terminology, the object is the parent. For example, in "linkerA 3prime-overhang-linker enzymeA" linkerA is the subject, 3prime-overhand-linker is the type, and enzymeA is the object. | nd_reagent.nd_reagent_id | |
| type_id | integer | 10 | NOT NULL, The type (or predicate) of the relationship. For example, in "linkerA 3prime-overhang-linker enzymeA" linkerA is the subject, 3prime-overhand-linker is the type, and enzymeA is the object. | cvterm.cvterm_id |
| Type | Fields |
|---|---|
| NOT NULL | nd_reagent_relationship_id |
| NOT NULL | subject_reagent_id |
| FOREIGN KEY | subject_reagent_id |
| NOT NULL | object_reagent_id |
| FOREIGN KEY | object_reagent_id |
| NOT NULL | type_id |
| FOREIGN KEY | type_id |
| FOREIGN KEY | subject_reagent_id |
| FOREIGN KEY | object_reagent_id |
| FOREIGN KEY | type_id |
nd_reagentprop |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_reagentprop_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| nd_reagent_id | integer | 10 | UNIQUE, NOT NULL | nd_reagent.nd_reagent_id | |
| type_id | integer | 10 | UNIQUE, NOT NULL | cvterm.cvterm_id | |
| value | text | 64000 | NULL | ||
| rank | integer | 10 | 0 | UNIQUE, NOT NULL |
| Type | Fields |
|---|---|
| NOT NULL | nd_reagentprop_id |
| NOT NULL | nd_reagent_id |
| FOREIGN KEY | nd_reagent_id |
| NOT NULL | type_id |
| FOREIGN KEY | type_id |
| NOT NULL | rank |
| UNIQUE | nd_reagent_id, type_id, rank |
| FOREIGN KEY | nd_reagent_id |
| FOREIGN KEY | type_id |
nd_experiment_stockprop |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_experiment_stockprop_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| nd_experiment_stock_id | integer | 10 | UNIQUE, NOT NULL, The experiment_stock to which the property applies. | nd_experiment_stock.nd_experiment_stock_id | |
| type_id | integer | 10 | UNIQUE, NOT NULL, The name of the property as a reference to a controlled vocabulary term. | cvterm.cvterm_id | |
| value | text | 64000 | NULL | The value of the property. | |
| rank | integer | 10 | 0 | UNIQUE, NOT NULL, The rank of the property value, if the property has an array of values. |
| Type | Fields |
|---|---|
| NOT NULL | nd_experiment_stockprop_id |
| NOT NULL | nd_experiment_stock_id |
| FOREIGN KEY | nd_experiment_stock_id |
| NOT NULL | type_id |
| FOREIGN KEY | type_id |
| NOT NULL | rank |
| UNIQUE | nd_experiment_stock_id, type_id, rank |
| FOREIGN KEY | nd_experiment_stock_id |
| FOREIGN KEY | type_id |
nd_experiment_stock_dbxref |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_experiment_stock_dbxref_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| nd_experiment_stock_id | integer | 10 | NOT NULL | nd_experiment_stock.nd_experiment_stock_id | |
| dbxref_id | integer | 10 | NOT NULL | dbxref.dbxref_id |
| Type | Fields |
|---|---|
| NOT NULL | nd_experiment_stock_dbxref_id |
| NOT NULL | nd_experiment_stock_id |
| FOREIGN KEY | nd_experiment_stock_id |
| NOT NULL | dbxref_id |
| FOREIGN KEY | dbxref_id |
| FOREIGN KEY | nd_experiment_stock_id |
| FOREIGN KEY | dbxref_id |
nd_experiment_dbxref |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_experiment_dbxref_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| nd_experiment_id | integer | 10 | NOT NULL | nd_experiment.nd_experiment_id | |
| dbxref_id | integer | 10 | NOT NULL | dbxref.dbxref_id |
| Type | Fields |
|---|---|
| NOT NULL | nd_experiment_dbxref_id |
| NOT NULL | nd_experiment_id |
| FOREIGN KEY | nd_experiment_id |
| NOT NULL | dbxref_id |
| FOREIGN KEY | dbxref_id |
| FOREIGN KEY | nd_experiment_id |
| FOREIGN KEY | dbxref_id |
nd_experiment_contact |
Top |
| Field Name | Data Type | Size | Default Value | Other | Foreign Key |
|---|---|---|---|---|---|
| nd_experiment_contact_id | integer | 11 | PRIMARY KEY, NOT NULL | ||
| nd_experiment_id | integer | 10 | NOT NULL | nd_experiment.nd_experiment_id | |
| contact_id | integer | 10 | NOT NULL | contact.contact_id |
| Type | Fields |
|---|---|
| NOT NULL | nd_experiment_contact_id |
| NOT NULL | nd_experiment_id |
| FOREIGN KEY | nd_experiment_id |
| NOT NULL | contact_id |
| FOREIGN KEY | contact_id |
| FOREIGN KEY | nd_experiment_id |
| FOREIGN KEY | contact_id |


Trevor Noah on Bok win: 'To say we're proud would be an understatement'
Cape Town – Congratulations poured in from across the globe on Saturday after the Springbok team beat England to be crowned winners of the Rugby World Cup 2019.
Host of the Daily Show, Trevor Noah, had a particularly powerful message to the squad and his home country after the win.
"To say we’re proud would be an understatement," he tweeted, before adding; "Congrats to a team that many wrote off just a year ago. Our captain took criticism from all sides but today, the Springboks are back on top of the world. Well done Bokke. You have made us all proud."
Amidst a busy press day for her new film Bombshell, Oscar-winning actress Charlize Theron also send her love and support to the team and the country. She tweeted; "Sending so much love to these guys for a hard fought and well deserved #RWC win. CONGRATULATIONS Springboks - you’ve done our country proud!"
The Bokke also got a visit from Prince Harry in the locker room after the game. The Prince, who recently toured South Africa with his wife Meghan and son Archie, made a short speech to the team, saying: "I can't think of a nation that needs it more than you guys right now." (WATCH THE VIDEO HERE!)
The official Sussex Royal Instagram account also share a pic of Prince Harry hugging President Cyril Ramaphosa after SA's win.
SEE THE SUSSEX ROYAL INSTAGRAM POST HERE:
Even, Hollywood actor Matthew McConaughey was moved by Siya's post game interview:
(Compiled by Herman Eloff)


|
VA-API
2.6.0.pre1
|
Picture parameter for MPEG-2 encoding. More...
#include <va_enc_mpeg2.h>
Public Attributes | |
| VASurfaceID | forward_reference_picture |
| Forward reference picture. | |
| VASurfaceID | backward_reference_picture |
| Backward reference picture. | |
| VASurfaceID | reconstructed_picture |
| Reconstructed(decoded) picture. | |
| VABufferID | coded_buf |
| Output encoded bitstream. More... | |
| uint8_t | last_picture |
| Flag to indicate the picture is the last one or not. More... | |
| VAEncPictureType | picture_type |
| Picture type. | |
| uint32_t | temporal_reference |
| Same as the element in picture_header() | |
| uint32_t | vbv_delay |
| Same as the element in picture_header() | |
| uint8_t | f_code [2][2] |
| Same as the element in Picture coding extension. | |
| uint32_t | va_reserved [VA_PADDING_LOW] |
| Reserved bytes for future use, must be zero. | |
| uint32_t | intra_dc_precision: 2 |
| Same as the element in Picture coding extension. | |
| uint32_t | picture_structure: 2 |
| Same as the element in Picture coding extension. | |
| uint32_t | top_field_first: 1 |
| Same as the element in Picture coding extension. | |
| uint32_t | frame_pred_frame_dct: 1 |
| Same as the element in Picture coding extension. | |
| uint32_t | concealment_motion_vectors: 1 |
| Same as the element in Picture coding extension. | |
| uint32_t | q_scale_type: 1 |
| Same as the element in Picture coding extension. | |
| uint32_t | intra_vlc_format: 1 |
| Same as the element in Picture coding extension. | |
| uint32_t | alternate_scan: 1 |
| Same as the element in Picture coding extension. | |
| uint32_t | repeat_first_field: 1 |
| Same as the element in Picture coding extension. | |
| uint32_t | progressive_frame: 1 |
| Same as the element in Picture coding extension. | |
| uint32_t | composite_display_flag: 1 |
| Same as the element in Picture coding extension. | |
| uint32_t | v_axis: 1 |
| Same as the element in Picture coding extension. | |
| uint32_t | field_sequence: 3 |
| Same as the element in Picture coding extension. | |
| uint32_t | sub_carrier: 1 |
| Same as the element in Picture coding extension. | |
| uint32_t | burst_amplitude: 7 |
| Same as the element in Picture coding extension. | |
| uint32_t | sub_carrier_phase: 8 |
| Same as the element in Picture coding extension. | |
Picture parameter for MPEG-2 encoding.
This structure holds information for picture_header() and picture_coding_extension()
If packed picture headers mode is used, i.e. if the encoding pipeline was configured with the VA_ENC_PACKED_HEADER_PICTURE flag, then the driver expects two more buffers to be provided to the same vaRenderPicture()
as this buffer:
| VABufferID VAEncPictureParameterBufferMPEG2::coded_buf |
Output encoded bitstream.
coded_buf has type #VAEncCodedBufferType. It should be large enough to hold the compressed NAL slice and possibly SPS and PPS NAL units.
| uint8_t VAEncPictureParameterBufferMPEG2::last_picture |
Flag to indicate the picture is the last one or not.
This fields holds 0 if the picture to be encoded is not the last one in the stream. Otherwise, it is MPEG2_LAST_PICTURE_EOSTREAM.


Interactable.draggable([options])⚓➭
Gets or sets whether drag actions can be performed on the Interactable
Returns: boolean Indicates if this can be the target of drag events
var isDraggable = interact('ul li').draggable();
or
Parameters
- options boolean object true/false or An object with event listeners to be fired on drag events (object makes the Interactable draggable)
Returns: object This Interactable
interact(element).draggable({
onstart: function (event) {},
onmove : function (event) {},
onend : function (event) {},
// the axis in which the first movement must be
// for the drag sequence to start
// 'xy' by default - any direction
startAxis: 'x' || 'y' || 'xy',
// 'xy' by default - don't restrict to one axis (move in any direction)
// 'x' or 'y' to restrict movement to either axis
// 'start' to restrict movement to the axis the drag started in
lockAxis: 'x' || 'y' || 'xy' || 'start',
// max number of drags that can happen concurrently
// with elements of this Interactable. Infinity by default
max: Infinity,
// max number of drags that can target the same element+Interactable
// 1 by default
maxPerElement: 2
});


The Filter
object defines the single instance of the filters
collection property used in the Table Object schema.
Two instance types for the Filter
object are used internally.
The first, the static object definition, refers to the static Javascript definition.
The second, refers to a Javascript Filter
object which is created as part of the static Table Object migration process.
This instance allows the HTML code to directly access methods defined
for the Filter object.
The migration process copies all of the static properties to the dynamic version.
The Filter
object definition is found in the filters
property of the Table Object oTabProp
object.
That is the filters
property is an array of one or more Filter
object definitions. Each definition has one or more of the following properties. Some property
specifications depend on the type
value.
Note that the order the filters in this definition is the order they appear in both the List Controller Filter panel and, with the exception of the 'limit' type the order that the record selection cascades the results to the next filter (there is no 'OR' capability). The 'limit' filter is applied last and limits the result set to no more than the specified number.
If no type
'limit' filter is defined in the filters
array, one is inserted with a default value of '50'.
type:
This
property defines the type of filter. The internal record selection routines use this type
to alter their logic. The possible value are:
'cust' The methCust
property references a method that will be called.
'mask' The default string mask search against the field
is used. If uses standard Regular Expression syntax to match against the contents of the field
for each record still in the selection set.
'chkbox' A binary checkbox value. The methCust
property should reference a method that will be called.
'state' A tri-state input filter not fuilly implemented.
'limit' The input field specifies the maximum number of rows that will be displayed.
place:
Used with type
'cust' and 'mask' to specify a placeholder string.
title:
Used to provide a label for the filter and shown in the Filter Panel.
methCust:
The reference to a local function called by a type
'cust' filter.
The signature of the call is func-name(oTab,oObjs,oData,oFil)
where
oTab
is the dynamic Table Object, oObjs
is the cascaded array of Data Objects,
oData
is the oSel
work area and in which cached results can be stored and oFil
is the present Filter
object.
field:
Defines the related table field that the mask works against. For type
'cust' and 'chkbox' it can define an internal scope property stored in $scope.oSel
that can be used to store intermediate of cached values.