Workflow Execution
Below we describe scenarios on using the workflow execution features and their expected behaviors.
Execute workflow end to end
Here, the user can execute workflow to completion without stopping. The “Run” button accomplishes this.
Steps
- In the “Compose” perspective, create a new workflow or load an existing workflow. Make sure the workflow you are trying to execute is syntactically correct. You can verify this by clicking on “Validate” button in “Compose” perspective.
- Click on “Execute” perspective. The loaded workflow will be displayed in the “Execute” perspective. Note, the user cannot modify the workflow in “Execute” perspective as the workflow is “read-only”. However, the user can see the graph model of the workflow in the “read-only” mode and see what parameters are set in each service.
- Click on “Run” button.
- If the workflow is syntactically valid and all the services in the workflow run successfully then the workflow will execute successfully. During execution, each service will highlight to show that it is “executing”. The “Logger Console” will show which service is executing by displaying a message “Executing service ABC…” Once the workflow execution is successfully completed, the execution results will be displayed on the screen with a pop-up. Depending on what is being executed, an appropriate link will be provided to go to the execution results.
- If the workflow is syntactically invalid, then the workflow will not execute further. The message that “Error: there was a problem with the requested operation. See the logger for details.” In the “logger console”, the reason for workflow being syntactically incorrect will be displayed. The user will have to fix these errors first by going back to the “Compose” perspective. The user can then come back to “Execute” perspective and try to execute the workflow again by pressing the “Run” button.
- If any service in the workflow has an error during its execution, then the workflow will not execute further. The message that “Error: there was a problem with the requested operation. See the logger for details.” In the “logger console”, the reason for workflow service throwing an error will be displayed. The user will have to contact the SORASCS administrator (Bradley Schmerl<EMAIL_ADDRESS>to fix the service error to continue using that service within the workflow.
Step by Step Execution
Here, user can execute one step of the Workflow at a time. It allows user to step through one service at a time in the workflow regardless of breakpoints are set or not
This feature is currently not available in this release of the software. Its user behavior will be updated here once the feature becomes available.
Step in and Step Out of Composite Services during execution
Here, user can step inside of the service regardless of breakpoints are set of not. Once inside the composite service, the user can step out of it.
This feature is currently not available in this release of the software. Details on its user behavior will be updated here once the feature becomes available.
Step In
Here, user can step inside of the service regardless of breakpoints are set of not given that the service is composite (has internal services) and is in user’s realm (user has permissions to see internal details of the composite service)
This feature is currently not available in this release of the software. Details on its user behavior will be updated here once the feature becomes available.
Step Out
Here, once stepped inside the composite service, user can step out of the service.
This feature is currently not available in this release of the software. Details on its user behavior will be updated here once the feature becomes available.
Workflow Pause during Execution
Here, the user can pause the workflow execution by pressing “Pause” button. The workflow execution is paused in a safe state. “Workflow execution has been paused” message will be displayed in the “Logger” console. This action is available all the time to user when in “Execute” perspective.
This feature is currently not available in this release of the software. Details on its user behavior will be updated here once the feature becomes available.
Terminate Workflow Execution
Here, the user can terminate the workflow execution by pressing “Terminate” button. The workflow execution will be terminated completely. “Workflow execution has been terminated” message will be displayed in the “Logger” console. This action is available all the time to user when in “Execute” perspective.
This feature is currently not available in this release of the software. Details on its user behavior will be updated here once the feature becomes available.
Viewing Intermediate Results during Execution
Here, the user will be able to mark the “view point” at the output of the service for which they want to see the execution results. These are the intermediate results of the workflow execution on a particular service that the user desires to look into.
Steps
- In the “Compose” perspective, create a new workflow or load an existing workflow. Make sure the workflow you are trying to execute is syntactically correct. You can verify this by clicking on “Validate” button in “Compose” perspective.
- Click on “Execute” perspective. The loaded workflow will be displayed in the “Execute” perspective. Note, the user cannot modify the workflow in “Execute” perspective as the workflow is “read-only”. However, the user can see the graph model of the workflow in the “read-only” mode and see what parameters are set in each service.
- Click on “Mark Viewpoint” button. This will take the user into “Mark Viewpoint” mode. To get out of Mark Viewpoint” mode, click on “Mark Viewpoint” button again.
- Hover over the service you want to mark the view-point on. Click on the output port of the service and you will see the “Eye” icon image appear at the output port of the service. This means that the view point is marked.
- If you click on the marked view-point on the service again, the view point can be removed.
- Click on “Run” button, to start workflow execution.
- At the bottom, in “View Intermediate Results” Logger you will see the intermediate results of the workflow execution for the services that had the viewpoints marked on their output port.
Constraints
View point cannot be set on the “Data” services. View point cannot be set on the “input” ports of the services. User cannot mark the viewpoint dynamically when the execution is in progress. User can only mark the view-point before execution begins or when the workflow is in the pause state.
Execution with UI interaction service
TO DO
Debug Workflow
This section will describe the features that will allow user to debug the workflow as needed in case there are error’s during execution.
Setting Breakpoints
Here, user can set the break-point at the beginning of the service and one break-point at a time using the “Set Breakpoint” button.
Steps
- Click on “Set Breakpoint” button. This will take the user into “Set Breakpoint” mode. To get out of Set Breakpoint” mode, click on “Set Breakpoint” button again.
- Hover over the service you want to set break-point on. Click on the service and you will see the breakpoint image appear at the beginning of the service. This means that the breakpoint is set.
- If you click on the service again, the breakpoint can be removed.
- You can set the breakpoints inside the composite service as long as you have permissions to step inside the composite service. (See Step In section to see how to step inside of a composite service).
Constraints
This action is not allowed on the data source or sink services. This action is available when the workflow has not started executing at all or when the workflow is “paused” in a safe state.
This feature is currently not available in this release of the software. Details on its user behavior will be updated here once the feature becomes available.
Run to breakpoint
Here, user can run to the break-point.
Steps
- Click on “Run to break-point”
- If next breakpoint is available
- Workflow will execute up to next service with the breakpoint.
- Execution progress is shown in the “Logger” console.
- If there is no breakpoint available
- Workflow will execute to the end. This is equivalent to pressing “Run” button.
- Execution progress is shown in the “Logger” console depending on what SORASCS is providing to the front end.
This feature is currently not available in this release of the software. Details on its user behavior will be updated here once the feature becomes available
Clear all breakpoints
Here, user can clear all the set breakpoints.
Steps
- Click on “Clear all breakpoints” button.
- All the set breakpoints will be cleared.


| Interface | Description |
|---|---|
| CombatUsable |
Provides both type and behavior for things usable in combat (items, abilities, etc).
|
| Item |
Objects implementing this interface are considered representations of physical items.
Items should be immutable, relying on their containing Inventory and ItemDrop objects to determine changeable attributes such as stack size.
If the item is to be usable, it should also implement either Usable or CombatUsable.
|
| ItemType |
Each item has a type.
|
| PotionType |
Each Potion.class object contains a reference to a PotionType object, which is used to determine the behavior of the Potion's use(user,target) function.
|
| Usable | |
| WeaponType |
Each Weapon object stores a reference to a WeaponType object, which it uses to determine its behavior on use(user,target).
|
| Class | Description |
|---|---|
| AbstractItem |
This class provides basic implementation of the methods in the Item interface, primarily so that classes that wish to implement it don't have to write all of the implementation from scratch.
|
| Armor |
Currently half-implemented, Armor will be used in combat to determine how much damage a successful attack on its wearer does.
|
| Food | |
| ItemBuilder |
This class is the only way to instantiate a new Item.
|
| Material |
This class is used for items used only for crafting/selling.
|
| Potion |
The Potion class is used for single-use, combat-usable items that apply some sort of effect to an entity.
|
| Weapon |
Items of this class can be equiped to an Entity's weapon slot, and delegate the use function to a WeaponType object.
|
| Enum | Description |
|---|---|
| BasicItemType | |
| BasicPotionType | |
| BasicWeaponType | |
| Rarity | |
| UseTag |
Each object that implements the Useable interface has a UseTag.
This tag is intended to be used by context-dependant parts of the program to determine if an item can, in fact, be used.
Important: This tag does not prevent the use of an item by itself.
|


DON'T HAVE AN ACCOUNT ?
© COPYRIGHT 2020
HELIOS BLOCKCHAIN TECHNOLOGIES LTD.
Don't have an account? Register here


{% extends "layout.html" %} {% block page_title %} What type of tax is your dispute about? - Tax Tribunals Prototype {% endblock %} {% block content %} {% include "includes/phase_banner_alpha.html" %} Back Step 5 of 6 What type of tax is your dispute about? Select the option that is relevant to you. Income tax (including self assessment and PAYE) Corporation tax Capital gains tax Value Added Tax (VAT) Insurance Premium Tax (IPT) Landfill tax National insurance contributions Inheritance tax Stamp taxes (Stamp Duty, Stamp Duty Land Tax and Stamp Duty Reserve Tax) {% endblock %}
Back Step 5 of 6
Select the option that is relevant to you.


Mum pleads 'help bring my baby home' after teen not seen for six days
David Bivol may be wild camping in Scotland but hasn't made contact with his family.
by Julie Dunnett, https://www.dailyrecord.co.uk/authors/julie-gilbert/The mum of a missing teenager is pleading for help to bring him home.
Aliona Bivol made a poignant post on the Missing People Scotland Facebook page in a bid to track down her 16-year-old son David Bivol.
It is believed he may be wild camping in rural areas around Edinburgh .
The teen is from Northampton but Edinburgh Police are assisting in the search for him.
He hasn't been seen since Wednesday, November 6.
Last night, Aliona made a plea for help on Missing People Scotland.
She said: "Please help to find my missing 16 years old son. He is missing for six days now.
"It a belief that he may adventure survival camping in Scotland.
"Please watch out for him. Help to bring my baby home. Please contact 101 or myself."
David is described as 6ft 1" and slim with short brown hair.
Edinburgh Police issued a statement last week saying: "David Bivol, 16, has been reported missing from Northampton and is believed to be in the Edinburgh area."
Northamptonshire Police also issued as appeal for information on Facebook.
They said: "Officers are re-appealing for information to help find a missing teenage boy
"David Bivol, aged 16, was last seen at around 8am on Wednesday, November 6, in the Northampton area.
"He is described as 6ft 1in, of slim build and has short brown hair. It is thought David may have been wearing jeans and a t-shirt when he was last seen, and took a bag with him.
"David, please make contact with us to let us know you're safe.
"Anyone who sees David or has information about where he is should call Northamptonshire Police on 101, reference MPN2/3502/19".


View Meeting
Title : {{session.current_meeting.title}}
Proposer : {{session.current_meeting.proposer_name}}
Description : {{session.current_meeting.desc}}
Time Range :{{session.current_meeting.start_date}} {{session.current_meeting.start_time}} - {{session.current_meeting.end_date}} {{session.current_meeting.end_time}}
Send this link to invite people:
below user accept this invite
{% if session.names is defined %}
{% for name in session.names %}
{% endfor %}
{% else %}
{% endif %}
avaiable times utill now :
{% if session.free_times is defined %}
{% if session.free_times is equalto []%}
There are not non-conflicting times. : (
{% else %}
{% for start, end in session.free_times %}
{{ start | fmtdatetime }} - {{ end | fmtdatetime }}
{% endfor %}
{% endif %}
{% endif %}


9
Job Replies: There Is No Arbiter
1 Then Job answered and said:
2 “Truly I know that it is so:
But how can a man be in the right before God?
3 If one wished to contend with him,
one could not answer him once in a thousand times.
4 He is wise in heart and mighty in strength
—who has hardened himself against him, and succeeded?—
5 he who removes mountains, and they know it not,
when he overturns them in his anger,
6 who shakes the earth out of its place,
and its pillars tremble;
7 who commands the sun, and it does not rise;
who seals up the stars;
8 who alone stretched out the heavens
and trampled the waves of the sea;
9 who made the Bear and Orion,
the Pleiades and the chambers of the south;
10 who does great things beyond searching out,
and marvelous things beyond number.
11 Behold, he passes by me, and I see him not;
he moves on, but I do not perceive him.
12 Behold, he snatches away; who can turn him back?
Who will say to him, ‘What are you doing?’
13 “God will not turn back his anger;
beneath him bowed the helpers of Rahab.
14 How then can I answer him,
choosing my words with him?
15 Though I am in the right, I cannot answer him;
I must appeal for mercy to my accuser.
16 If I summoned him and he answered me,
I would not believe that he was listening to my voice.
17 For he crushes me with a tempest
and multiplies my wounds without cause;
18 he will not let me get my breath,
but fills me with bitterness.
19 If it is a contest of strength, behold, he is mighty!
If it is a matter of justice, who can summon him?
20 Though I am in the right, my own mouth would condemn me;
though I am blameless, he would prove me perverse.
21 I am blameless; I regard not myself;
I loathe my life.
22 It is all one; therefore I say,
He destroys both the blameless and the wicked.
23 When disaster brings sudden death,
he mocks at the calamity of the innocent.
24 The earth is given into the hand of the wicked;
he covers the faces of its judges—
if it is not he, who then is it?
25 “My days are swifter than a runner;
they flee away; they see no good.
26 They go by like skiffs of reed,
like an eagle swooping on the prey.
27 If I say, ‘I will forget my complaint,
I will put off my sad face, and be of good cheer,’
28 I become afraid of all my suffering,
for I know you will not hold me innocent.
29 I shall be condemned;
why then do I labor in vain?
30 If I wash myself with snow
and cleanse my hands with lye,
31 yet you will plunge me into a pit,
and my own clothes will abhor me.
32 For he is not a man, as I am, that I might answer him,
that we should come to trial together.
33 There is no arbiter between us,
who might lay his hand on us both.
34 Let him take his rod away from me,
and let not dread of him terrify me.
35 Then I would speak without fear of him,
for I am not so in myself.


Home
Stats
Help
Language
Login
Create Account
Best Buy Price
Latest Price
Best Sell Offer
Each customer account is linked to a payment account held for you by a licensed Payment Institution partner: you send euros to an account owned by you to purchase bitcoins.
Your withdraw requests are transmitted directly to our Payment Institution partner.
We apply a 100% cold storage policy on all bitcoins sent to your Bitcoin-Central account.
No bitcoins are stored on customer-facing servers: private keys are held in bank vaults located in several cities. We use secret splitting techniques to ensure that no bitcoin can be stolen even if a bank vault is compromised.
Footer goes here


The name? completely random, your guess is as good as mine ;)
I am a Computer Science undergrad and this is a website made to host or showcase fun projects that I am working on, and also scripts that make my life easier(Which for now is the only thing here :) ).In time I will also hope to host fun JavaScript and Python projects on this website. So, this website too will, hopefully, get better along the way as I learn cool new things. This is also a platform for me to experiment on the cool stuff I'll test out. If you're reading this I have no idea how you got here but Kudos!
These are some of the cool projects that I am working/worked on and scipts that make my life easier.
A python script to find and tag album/artist/cover art from the internet and sort your music based on artist
This is a simple python script which sorts all the files in a given folder into corresponding well organised folders This could be used to organise clumsy folders with ease


Version 4.6¶
Release date: 2019-05-02
This release contains a number of new features and fixes reported since the release of pgAdmin4 4.5
Features¶
Issue #4165 - Depend on psycopg2-binary in the Python wheel, rather than psycopg2.
Bug fixes¶
Issue #2392 - Ensure that on clicking Delete button should not delete rows immediately from the database server, it should be deleted when Save button will be clicked.
Issue #3327 - Ensure that newly added row in backgrid should be visible.
Issue #3582 - Ensure that JSON strings as comments should be added properly for all the objects.
Issue #3605 - Fix an issue where Deleting N number of rows makes first N number of rows disable.
Issue #3938 - Added support for Default Partition.
Issue #4087 - Fix an issue where ‘GRANT UPDATE’ sql should be displayed for default sequence privileges.
Issue #4101 - Ensure that confirmation dialog should be popped up before reload of query tool or debugger if it is opened in a new browser tab.
Issue #4104 - Ensure that record should be add/edited for root partition table with primary keys.
Issue #4121 - Fixed alignment issue of columns in definition section of Index node.
Issue #4134 - Fixed ‘Location cannot be empty’ error when open Tablespace properties.
Issue #4138 - Fix an issue where the dropdown becomes misaligned/displaced.
Issue #4154 - Ensure the treeview shows all sequences except those used to implement IDENTITY columns (which can be edited as part of the column). Show all if Show System Objects is enabled.
Issue #4160 - Fixed ‘Increment value cannot be empty’ error for existing tables.
Issue #4161 - Ensure that parameters of procedures for EPAS server 10 and below should be set/reset properly.
Issue #4163 - Prevent duplicate columns being included in reverse engineered SQL for tables.
Issue #4182 - Ensure sanity of the permissions on the storage and session directories and the config database.


Done! If the email address is linked to a user in this organisation, you will receive an email containing instructions on how to reset your password.
Please enter the email address linked to your {{organisationName}} account (i.e. the email address you specified at registration time) and we will send you a password reset code.


[gecode-users] How control the engine??
Rafael Meneses
rafaparafernalia at gmail.com
Fri Feb 24 19:02:31 CET 2006
On 2/24/06, Guido Tack <tack at ps.uni-sb.de> wrote:
> > No, the only way you currently can interrupt is in between requesting
> > better solutions from the BAB engine. However this sounds like a useful
> > (and reasonably simple) addition, even though it should be a user supplied
> > stop criterion being more general than just time... But it should be very
> > simple for you to hack something up by yourself and tell us...
>
> Maybe a hint to get you started:
> Have a look at search/bab-copy.cc or search/bab-reco.cc. Both contain a
> similar while(true) loop that does the main exploration. The easiest way to
> implement something like a timeout would be to use the failure count - just
> stop the search when it exceeds a certain limit. You must then return true
> and set s1 to NULL.
>
Thanks...
I finished the patch....
The patch includes an example, in the directory examples the file
golombTimeout.cc
Bye....
--
Rafael Meneses
http://www.labsd.inf.utfsm.cl/~rmeneses
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gecode_1.0.0_parcheTimeout.patch
Type: text/x-patch
Size: 16771 bytes
Desc: not available
URL: <http://www.ps.uni-sb.de/pipermail/users/attachments/20060224/3d872f37/attachment.bin>
More information about the gecode-users
mailing list


管理员登录
Remember me
Forget Password ?
登录
Sign Up
Enter your details to create your account:
I Agree the
terms and conditions
.
Sign Up
Cancel
Forgotten Password ?
Enter your email to reset your password:
Request
Cancel
Don't have an account yet ?
注册
RIL
Researching Information Library
借我亡命天涯的勇敢
借我说得出口的旦旦誓言
借我孤绝如初见
借我不惧碾压的鲜活
借我生猛与莽撞不问明天
借我一束光照亮黯淡


[1]
a bit hard to find , but i eventually tracked in down in a cloth bag .
[2]
bathroom has a shower -lrb-/-lrb- but no bath -rrb-/-rrb- , a full-length mirror and l'occitane products .


Front end developer dedicated to making responsive websites across platforms. Experience with project management, teamwork, and many other programming languages. Looking for a developer role.


Event Location:
Mittleman Community Center
6651 SW Capitol Highway
Portland, Oregon
Abstract:
Secure your SQL Server infrastructure and your Windows installations to enhance resiliency and minimize exposure to attacks -- all without touching a single line of code! In this session you will learn about Transparent Data Encryption, IPSec, Database Firewalls, Contained Databases and many other technologies that help you lock down your systems and close attack vectors. This talk puts great emphasis on the biggest threat to your database: SQL injection, offering many remediation techniques to prevent such attacks. During the demos, you will learn techniques to deal with vendors who require SA accounts to run their applications. Protect your SQL Servers without having to wait for your Developers or Vendors to make changes!
Speaker(s): Argenis Fernandez,
Abstract:
In-Memory OLTP (code name: Hekaton) is the most important new feature in SQL Server 2014, and this session will teach you how query processing and optimization work with this new database engine. After explaining the basics, we will discuss how the query optimizer is used in In-Memory OLTP by both natively compiled stored procedures and by traditional stored procedures accessing memory-optimized tables through the query interop functionality. We will also take a look at how the new hash and range indexes are used, as well as how their performance implications are also covered along with the process of translating the plan created by the query optimizer into C code. Finally, some limitations with the current release will also be explained.
Speaker(s): Benjamin Nevarez,
Abstract:
Major disaster events resulting in unplanned downtime get all the press—but planned downtime constitutes almost 80% of the outages in any IT environment. This downtime is typically for tech refresh, migration projects, and OS/SQL Server patching. And when do you have to schedule the large downtime windows required to accomplish these upkeep tasks? Nights and weekends. Like you don't have better things to do then! In this session, learn how you can get the safety of a parallel deployment with the speed of an in-place upgrade for OS and/or SQL Server as fast as SQL Server can stop restart, no data migrations for tech refresh, low-impact break/fix, and planned downtime windows of less than 2 minutes.
 The time has come to tame these beasts, and the solution is available now, in SQL Server 2012. New T-SQL functions offer out-of-the-box solutions for many problems that previously required complex workarounds. Paging, Running totals, Moving aggregates, YTD, and much more comes at the power of your fingertips in SQL Server 2012. The only thing you need to do is learn the syntax. And that is exactly what this session is all about: a thorough description and explanation of the syntax, and loads of demos to demonstrate how you can use all these new features. Attend this session to boldly take SQL Server where it has never gone before!
Speaker(s): Hugo Kornelis,
Abstract:
Are you working with an application supporting different time zones and international date formats? How does your choice of storing date / time values differ if you are using Windows Azure SQL Database instead of on-prem SQL Server database? Did you know that SQL Server Database Engine, Integration Services (SSIS) and Analysis Services (SSAS) all have slightly different date / time data types? How can you bullet proof your system for the ever growing data in your organization with much more date and time data to come? With time being the one thing that constantly changes, date and time calculations are widely used and essential to all business transactions. Yet, most systems only use one or two date data types; Is this a wise decision? Quite often data retrieval relating to a period of time does performs poorly, or worst of all, is not accurate. These 10 tips will help you bridge the gap, and provide the techniques to build bulletproof systems the users demand and DESERVE!
Speaker(s): Julie Koesmarno,
Abstract:
Columnstore indexes were introduced in SQL Server 2012 have been wholly re-architected optimized in SQL Server 2014. Columnstore indexes are optimized for data warehouse workloads are a hybrid technology leveraging the best of off-disk in-memory capabilities. Transparent to the app, columnstore has been shown to render queries at subsecond response times which heretofore took many minutes or longer. This presentation includes an overview of SQL Server 2012 a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, big wins at customer sites inside MSIT. The presentation is rich in demos, including leveraging IaaS—Columnstore in The Cloud. Learn whether columnstore can change your users' world why columnstore may be a compelling reason to upgrade. Learn how columnstore indexes flip the DW faster bit why columnstore manifests my motto, “Change the world or go home!”
Speaker(s): Jimmy May,
Abstract:
There are different types of enumerators in the SSIS Foreach Loop Container which helps to implement different loop scenarios. In this chapter these different types explained with few case studies, with resort of these different types of enumerators , SSIS Developers can loop through specific files, or through rows of a data table, or items of an array or other kinds of list structures. Variaty of these types will reduce needs of scripting. In this article these types of enumerators considered: File Enumerator, Item Enumerator, ADO Enumerator, ADO.NET Schema Rowset Enumerator, From Variable Enumerator, NodeList Enumerator, SMO Enumerator. This session is based on the book chapter of SQL Server MVP Deep Dive 2
Speaker(s): Reza Rad,
Abstract:
This session discusses a proven organizational approach and important technical considerations that lead to the successful adoption of Master Data Management (MDM) on SQL Server. Organizational considerations include building buy-in, team capability expertise, and selling MDM to the rest of the organization while building a subject-area center of excellence. We also discuss approaches to improved time-to-value and to ensure that the technology and staff investment is matched to the expected outcome. Great technology choices will help ensure that your best laid plans succeed and the second half of this session goes over some important technology considerations. In this part of the session we discuss User Experience, Integration Patterns, Matching, Programmability, and Data Quality.
Speaker(s): John McAllister,
Abstract:
In the most marketing departments, the tactical question is about who are going to buy our products. It is more cost effective to identify and spend money on highly potential customers (than those who are not likely to purchase). This also affects the advertisement strategy. Potential customers and their traits can be identified by analysing previous purchasing information. Management experts can predict who is going to be their new customers by analysing their current customer purchase information. There are many data mining algorithms which can help with this task. Microsoft Business Intelligence employs data mining algorithms that are deployed in an easy to use environment. This demonstration based session will show how to use previous customer purchase information to predict potential customers. We will discuss how to set data sets and use different data mining algorithms to get predictive results and then demonstrate how to find the best predictions.
Speaker(s): Leila Etaati,
Abstract:
BIG DATA! There, I've said it. But, what exactly does it mean for YOU? This session will help to dispel some of the Big Data confusion. This session will focus on HD Insight, Microsoft's Hadoop based implementation. Loading data and querying a database is one thing and that will certainly be covered. Exploring how we can integrate data from HD Insight into our existing analytic solutions is one of the real world implementations this session will be focused on. This is one of the keys to successfully selling management on the needs for a Big Data solution. It's not just another database, it's a tool to enhance existing analytic structures. During this session, we'll start with a brief overview of Hadoop and HDFS. Next we'll take a look at HD Insight, and explore some of the features therein. Finally, integration with SSAS and Power View (using Excel 2013) will be shown, which will close the loop on Big Data visualizations.
Speaker(s): Josh Fennessy,
Abstract:
This session will provide an introduction to Master Data Management (MDM). We explore the basic concepts, types of MDM solution, and the basics for a successful MDM Implementation. With a working definition in hand, we'll discuss strategies for beginning a successful MDM pilot in your organization and look at some of the pitfalls to avoid. We'll wrap the business discussion up with some tips for selecting the right domains to solve and some tips for managing the politics of MDM. After we've set the stage for what, how and why you need MDM, we'll take a brief look at SQL Server MDS through the Excel add-in and talk about the Architecture of MDS
Speaker(s): John McAllister,
Abstract:
It’s often difficult to know how your SQL Servers will perform under different loads. By performing load testing, we can gain these key insights, perform modifications to existing configurations, and understand the impact on performance levels. Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler – we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.
Speaker(s): Neil Hambly,
Abstract:
You'll learn about a best practice framework that alleviates many of the pain points for deploying, managing, and supporting multiple SQL Server deployments from development to production. There are many variables to consider when supporting SQL Servers in the real world, including: • Cloud systems (Microsoft Azure/Amazon AWS), virtualization (VMware/HyperV), physical servers • Different versions of SQL Servers, and different editions (Standard/Enterprise) • Service packs and specific Hotfixes • Configuration differences based on OS/Memory/Disk configuration • Different products need specific configurations and features of SQL Server • Post installation steps and default access The best practice framework will get us past the complexities and provide us with the following capabilities and benefits: • A Process framework configured to support the above requirements • Flexibility to easily add new configurations • A consistent experience
Speaker(s): Prakash Heda,
Abstract:
Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!
Speaker(s): Rob Volk,
Abstract:
If "Data is the Lifeblood of Modern Business," then most businesses are walking corpses with sludge in their veins, because 10% to 25% of all data records in the average enterprise are wrong. Until the dramatic problems of Data Quality Management are addressed, SQL can never fulfill its original promise to eliminate application "silos", enable systems to communicate and provide useful, actionable information to the modern business. I believe that we are on the cusp of a revolution in Data Quality that is even greater in scope and impact than the revolution in manufacturing quality that began over 40 years ago. Businesses that make the transition will survive and thrive. Those that don't will finally stop shambling about and lay down to die.What is this revolution in Data Quality? How can you be a part of it (and avoid the headman's ax)?!? This presentation will change the way you think about your jobs as Database Administrators and Application Developers.
Speaker(s): David Moutray,
Abstract:
All data warehouses need a date and time dimension to enable proper analysis across time. Most Data Warehouse designers will just use one provided by tools or whip it up in Excel, but what if you need to set up custom holidays or want different calendars, such as Fiscal or Julian? You can have any date and time dimension you need by using a single SQL script that can be modified and rerun as necessary. Learn what it takes to design a date and time dimension that does all of the calculations and formatting up-front so the reports can be easier to create. Sample script will be provided that creates the date and time dimensions and can be reused as often as necessary without breaking your data warehouse and it only take seconds to run!
Speaker(s): Steve Wake,
Abstract:
You’re taking basic backups and you know how to restore them. Things have been running smoothly in your environment but you want to be confident that you’re equipped with the backup and restore tools, techniques, and options that you’ll need to adapt your strategies as business needs change. You’ve heard about piecemeal restores, filegroup backups, and backing up to multiple files, and now you’re ready to dig into learning more about these topics. In this demo-rich presentation, we’ll review scenarios using these options and you'll gain an understanding of some intermediate and advanced options related to backup performance, corruption detection, and the new SQL Server 2014 hybrid backup scenarios. You'll return to the office inspired to validate your backups and test your restore processes regularly, and you'll have references to great tools the SQL community has shared to help you get started.
Speaker(s): Theresa Iserman,
Abstract:
SQL Server comes with a powerful built-in permission management system. However, as most powerful tools, this one too can be difficult to use and get right. This is a two-part session. During the first part, we will go through a review of SQL Server security terms and concepts, particularly the GRANT, REVOKE and DENY statements. For the second part, the audience selects topics that we will cover in detail. You will be able to choose from 12 different security pitfalls and misconceptions. All these pitfalls/misconceptions have one thing in common: If you are not aware of them, you might GRANT or DENY more permissions than you intended.
Speaker(s): Sebastian Meine,
Abstract:
Communicating. We all do it, every day. But can you do it better? You present to management, share with peers, advise your direct reports. A common thread of success or failure here is how well you get your message across. Can you share bad news and soften the blow with humor while respecting the nature of the news you have to deliver? Can you support your direct reports when they make a very human mistake? Do you know how you communicate your support without micromanaging them can make a huge difference in the quality of their work for years to come? These questions and more will be answered, with stories, with humor, and with experience (both good and bad). Once you've figured these things out, how do you communicate your own skills to the world? After attending, you’ll be on the road to better, more direct communication, whether it’s with your management, your peers, or your reports.
Speaker(s): Tom Roush,
Abstract:
When a query is run against a database, a plan is formed to do the work. This session will serve as an introduction on how to read and interpret execution plans. We will also take a look at the execution plan that won the 'Hairy' Execution Plan contest on SQLCruise Miami in 2013! Take a peek at http://sqlcruise.com/winner-of-the-2013-caribbean-landlubber-sql-sentry-hairy-execution-plan/
Speaker(s): Carlos L Chacon,
Abstract:
Microsoft's new In-Memory OLTP Tables ("Hekaton") promise to seriously change the performance of database solutions that you can design and implement or refactor. In this session, we will examine this new technology's architecture and internals, new T-SQL syntax, and various use cases. We'll then discuss how it affects your SQL Server environment, including performance considerations, troubleshooting, administration, and high-availability design considerations.
Speaker(s): Victor Isakov,
Abstract:
On occasion as DBAs we have need to disable the foreign keys and constraints on one or more tables. Guess what, SQL Server no longer trusts those constraints when you re-enable them. What does that mean? In this discussion, we’ll talk about what the impact is to your queries when you have non-trusted constraints, how to find the non-trusted constraints, and how to soothe SQL Servers mistrusting heart so that it will trust your constraints again! How about your foreign keys? Are you using implicit conversions? Are your stats 'stale'? All of these things effect how the query optimizer works and can negatively affect you query performance.
Speaker(s): Mike Tutor,
Abstract:
SQL Server Reporting Services Report Manager provides a great web platform for managing and delivering many types of reports. We will review delivering reports with Report Manager and look at the options for integrating SSRS as the report presentation engine within web and windows applications. We will also explore creating a standalone application to navigate and display reports using the reporting services database.
Speaker(s): Phil Robinson,
Abstract:
Do you dread handing your T-SQL over for code review?  Does the DBA always want to tweak your T-SQL? In this demo heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn about formatting T-SQL for readability and why top down design is not the best solution for writing T-SQL. You’ll learn why implicit conversions slow queries down and how to leverage simple techniques for minimizing the performance impact of explicit conversions. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.
Speaker(s): Mickey Stuewe,
Abstract:
In this session we will do a case study for a typical situation in industries like telecommunication or healthcare. We have a stream of multiple relatively small files incoming from external system and we need to load them to SQL Server database in near-real-time. Typical examples are CDR billing files, HL7 diagnostic results or medical claims. In this session we will cover how we can use WMI event watchers to monitor for incoming files and we examine option for managing worker treads loading the files. We will look into SQL Server broker queues, conversations between treads and activation to achieve robust solution.
Speaker(s): Piotr Palka,
Abstract:
This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
Speaker(s): Jason Horner,
Abstract:
In this session, we will look at the new BI query language for PowerPivot and Tabular - DAX. This session will give you an introduction to Data Analysis eXpressions (DAX) and will provide you the necessary understanding to start using in your environment for data analysis. No prior experience with DAX is needed to attend this session.
Speaker(s): Damu Venkatesan,
Abstract:
VLDBs (Very Large Databases) play in a different league: common maintenance operations can take much longer to run, and some settings and features that work well on smaller databases become much less effective. These downsides generally have a negative impact on users, however through some creativity and changes in our game plan we can have highly performant VLDBs. This session will cover a wide variety of tips and tricks assembled from years of working with databases up to 40TB in size.
Speaker(s): Bob Pusateri,
Abstract:
If you have a SQL Server license (Standard or higher) then you already have the ability to start data mining. In this presentation, you will see how to scale up data mining from the free Excel 2013 add-in to production use. Aimed at beginning to intermediate data miners, this presentation will show how mining models move from development to production. We will use SQL Server 2014 tools including SSMS, SSIS, and SSDT. Also included is an overview of Microsoft Azure Machine Learning.
Speaker(s): Mark Tabladillo,
Abstract:
As a Database Administrator, one will find that there are plenty of ways to implement SQL Servers, and develop code for applications. While there is plenty of debate on how best to do things, there are some agreed upon practices that should be found in any implementation of a database project. When these practices are ignored, the longevity of that server may be compromised. This session will define the phrase "best practices", and discuss several things that should be found in any SQL Server implementation to avoid issues in the long run.
Speaker(s): Michael Swinarski,
Abstract:
Microsoft Cluster MVP Dave Bermingham will discuss how to create #SANLess clusters in environments where traditional shared storage clusters are impractical or impossible. He will also be discussing high performance clusters leveraging SSD and Flash-based PCIe storage for faster SQL application response times - no SAN (or SAN Admin required) - and be touching on HA protection and native Windows Failover Clustering in cloud environments.
Speaker(s): SIOS Technology,
Abstract:
It's an all too common occurrence to have table columns or variables that have been assigned less than ideal data types. My goals in this presentation are to show you the importance of choosing the proper data type; show you some guidelines in determining what an appropriate data type would be; and once chosen, give you some tools for proper usage and management. I will demonstrate several performance and accuracy issues, along with their possible solutions, caused by either the assignment of imappropriate data types or improper usage of them. In addition, I will cover serveral data type related functions and point out caveates in their usage.
Speaker(s): Vern Rabe,
Abstract:
Partitioning allows us to isolate parts of our table as small chunks called partitions. In turn, these partitions allow us to do some really cool tricks for manageability and performance. In this session we'll look at the concepts surrounding partitioning and how we can apply them. We'll reinforce what we cover with some cool demo's showing some really neat tricks.
Speaker(s): Brandon Leach,
Abstract:
Everything that's old is new again, as Windows Server moves back to the terminal interface. With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure. This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it.
Speaker(s): Michael Fal,
Abstract:
Parameter sniffing is a misunderstood issue on SQL Server. Most of the time, parameter sniffing is helping performance on your servers. But sometimes, circumstances change, and what was helping you is now hurting you – bad. In this session, we’ll gain an understanding of what exactly parameter sniffing is and why it’s usually so helpful. Then we’ll explore how parameter sniffing can go wrong and look at seven different ways you can deal with it when it does. You’ll take away a wealth of knowledge that will help you identify and resolve bad parameter sniffing in your own environment.
Speaker(s): Grant Fritchey,
Abstract:
Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.
Speaker(s): Randy Knight,
Abstract:
In-Memory OLTP aka Hekaton aka XTP is without a doubt one of the key features in brand new SQL Server 2014. By placing your data in memory and using native compile stored procedures you can boost and increase you SQL Server performance in times. But it is not so easy to implement as it may seem, you need to make a lot of changes in your code and even in your application architecture. In this session you'll learn what parts of your system can benefit by using In-Memory OLTP and what you should take into consideration before starting. As a bonus, I'll share my own experience of implementing In-Memory OLTP into a real production system.
Speaker(s): Sergey Olontsev,
Abstract:
The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or the incorrect version. Each database is made up of a lot of objects in different environments. When you create an object like a table or stored procedure, you need to get this object deployed into each environment. Together we will discover how to separate each object for proper order deployment while releasing only objects which have changed. Deployments can cause you trouble but we will provide a reliable deployment and version control process.
Speaker(s): Thomas Norman,
Abstract:
SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could. This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
Speaker(s): Kathi Kellenberger,
Abstract:
Some aspects of SQL Server installations are easily repeatable using things like config files and command line installs. However, so much of the preparation and post-install configuration still needs to be done manually. This session will show how Powershell can be used to prep the servers (including how easy it can be to deploy a cluster) and how Powershell can then be used to deploy and configure SQL Server according to your company standards.
Speaker(s): Martin Cairney,
Abstract:
Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder makes creating executive dashboards easy!
Speaker(s): David Eichner,
Abstract:
This session will take a look at things that you should regularly know and use when coding TSQL. How can you be really friendly to SQL? The items covered will show you things that will help ensure that your code is readable, efficient and maintainable. We will look at query semantics, datatypes, things to avoid as well as how to be super friendly to the SQL Engine and allow things to work well.
Speaker(s): Ben Miller,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://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/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.
Database Administrator with five years experience in database design, business intelligence, application development, performance tuning and day-to-day administration with SQL Server. Experience covers administration of both transactional and data-warehouse databases, application development and database design for business applications. Certifications include MCITP Database Administrator and Developer. Passionate about database security and promoting data integrity through rock-solid database design and good development practices.
LinkedIn: http://www.linkedin.com/in/victorisakov
Contact: http://www.victorisakov.com
Victor Isakov (MCA, MCM, MCSM, 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/Ignite, PASS Summit, IT/Dev Connections, and SQLSaturdays. Victor has written a number of books on SQL Server and has worked with Microsoft to develop the SQL Server exams and certification. In 2017 he authored "Exam Ref 70-764 Administering a SQL Database Infrastructure (1st Edition)". He is one of only three non-Microsoft, Microsoft Certified Architects in the world.
LinkedIn: http://linkedin.com/in/sergeyolontsev
Contact: http://SergeyOlontsev.com/
I have been working with SQL Server since SQL Server 2000 version as a database administrator, developer, consultant and trainer, focusing on high availability and disaster recovery solutions, ETL, troubleshooting and performance tuning, developing high performance solutions . I'm a regular speaker at SQL Server user group meetings, SQLSaturday events and other conferences. An owner of MCM certification and MVP award on SQL Server.
LinkedIn: http://www.linkedin.com/in/armordba
Contact: https://armordba.com/
Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.
LinkedIn: http://www.linkedin.com/in/randyknight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
LinkedIn: http://www.linkedin.com/in/dbaduck/
Contact: https://dbaduck.com
Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let's catch up.
LinkedIn: http://linkedin.com/in/tomroush
Contact: http://www.geeql.com/
Tom is a master storyteller, known to translate Geek into plain English in a single bound. His wry sense of humor, life experiences and vivid descriptions are skillfully combined with his expertise as a DBA to have you understanding SQL in ways you never thought you would. Tom’s explanations of why to do something are insightful, why *not* to do something enlightening, and the stories behind them, both tech and non-tech, will leave you laughing to the point you forget you’re learning something.
LinkedIn: http://www.linkedin.com/in/mswinarski/
As an enthusiastic technical leader with over fifteen years of experience in Information Technology, I can attest to the notion that IT is not about technology as much as it is about people and the relationships that are formed to create collaborative teams that are able to address the needs of businesses, communities, and our environment. By leveraging the diversity of the team, we are able to make use of technical assets to construct highly available solutions that enable customers
LinkedIn: http://www.linkedin.com/in/scarydba
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
LinkedIn: https://nz.linkedin.com/pub/leila-etaati/36/46/b03
Contact: http://blog.radacad.com
Leila Etaati is the First Microsoft AI MVP in New Zealand and Australia, as well as a Data Platform MVP. She has a Ph.D. from the University of Auckland and is the co-director and data scientist in RADACAD company with many clients around the world. Additionally, she is the co-organizer of Microsoft Business Intelligence and Power BI Use group in Auckland with more than 1300 members. Leila has also co-organized 3 main conferences in Auckland: SQLSaturday Auckland (from 2015), Difinity (from 2017) and Global AI Bootcamp. She is a data scientist, BI consultant, trainer, and speaker. She is a well-known International speaker to many conferences such as MS Ignite, SQL PASS, Data Platform Summit, SQLSaturday, Power BI World Tour and in Europe, USA, Asia, Australia, and NZ. She has over 10 years’ experience with databases and software systems. Leila is an active Technical Microsoft AI blogger in RADACAD.
LinkedIn: http://nz.linkedin.com/in/rezarad/
Contact: http://radacad.com/blog
Reza Rad is a Microsoft Regional Director, MVP, author, trainer, speaker and consultant. He is a Microsoft Data Platform MVP for nine years from 2011. Reza wrote many books on Power BI subjects including the Power BI from Rookie to Rock Star, and Pro Power BI Architecture. Reza is the invited speaker at the world's well-known conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Ignite Tour, PASS Summit, and many other conferences. Reza is an active blogger and writes regularly about Power BI at https://radacad.com.
LinkedIn: https://www.linkedin.com/in/michaelfal/
Contact: http://mikefal.net
Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently. Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.
LinkedIn: http://www.linkedin.com/in/jasonhorner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I'm a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I'm fluent in several languages including: SQL, C#, Python, and PowerShell. I'm a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years. In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning Optimization”, “Inside the SQL Server Query Optimizer” and has contributed to other SQL Server books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits.
Contact: http://sqlblog.com/blogs/jimmy_may
Jimmy May is a Principal Architect in Microsoft IT. He's formerly a Senior Program Manager for the SQL Server Customer Advisory Team (SQL CAT) where he managed the Customer Lab which hosts the biggest, fastest, most interesting SQL Server apps from all over the world. He is a Microsoft Certified Master (MCM). Visit his SQL Server performance personal productivity blog at http://blogs.msdn.com/jimmymay. Jimmy tweets at www.twitter.com/aspiringgeek.
Phil Robinson is an independent consultant focused on developing Business Intelligence solutions using Microsoft Reporting Services and Power BI. He is founder of the San Diego SQL Business Intelligence Group and co-founder of SQLSaturday – San Diego.
Contact: http://www.sqlsolutionsgroup.com/
Mike Tutor has been in the IT industry for over 30 years. He has worn many hats, including developer, systems admin, and project manager, but he has worked almost exclusively as a SQL Server DBA since the late 90s. He has worked as a development DBA in the medical research industry for many years, but is currently working as a Sr. consultant at SQL Solutions Group in Lehi UT.
LinkedIn: https://www.linkedin.com/in/sqlservernerd
A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.
LinkedIn: http://www.linkedin.com/pub/prakash-heda/8/a60/b77
Contact: http://www.sqlfeatures.com/
Prakash Heda works as Manager (Data-IT) at SSC Advent. His expertise encompasses the work of automation, performance tuning/troubleshooting, high availability, san configuration and windows administration. Heda has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Heda holds certifications for MCDBA and MCITP. His background includes administration development using VB/ASP/SSIS with SQL server 2000 to 2017. He is an active member of PASS, SQLSaturday, and as well a frequent presenter at user groups, SQLSaturdays, and other community events. He is also an avid tweeter, blogger and runner.
LinkedIn: http://www.linkedin.com/in/theresaiserman/
Theresa Iserman is a SQL Server Premier Field Engineer at Microsoft. She’s been working with databases for over 15 years and has held roles working with transactional amp; data warehouse systems, web application development, amp; technical project management. Theresa tweets at www.twitter.com/theresaiserman
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/in/bobpusateri
Contact: http://www.BobPusateri.com
Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years of experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is an active member of two Chicago-area PASS Local Groups, a community speaker, and maintains a web presence through both Twitter (@SQLBob) and his blog (bobpusateri.com).
LinkedIn: http://www.linkedin.com/in/damuvenkatesan/
Damu Venkatesan is a Business Intelligence Consultant with over 25 years of IT experience including architecting and implementing BI/DW solutions using Microsoft SQL Server, PDW, SSIS, SSAS, SSRS, and Power BI. He has been speaking at many SQLSaturdays and user groups on data analytics and is actively involved in the Atlanta SQL community for several years. He has successfully delivered several BI/DW solutions and data migrations to various clients. He is also currently serving as President of DAMA Georgia chapter in Atlanta. He is the co-organizer of BI SQLSaturday in Atlanta.
LinkedIn: http://www.linkedin.com/in/kathikellenberger
Contact: http://auntkathisql.com
Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.
LinkedIn: https://www.linkedin.com/in/marktab
Contact: http://marktab.net
Mark Tabladillo Ph.D. works for Microsoft as a Cloud Solution Architect for the US CTO Customer Success Team. He has a science doctorate from Georgia Tech. Based in Atlanta, GA, Mark provides cloud enterprise solutions for companies in the US for Microsoft's strategic clients. He is a chapter leader for the PASS Data Science virtual chapter.
Piotr Palka has been working with high volume data processing systems since 1999. Piotr implemented and maintained multiple systems for telecommunication companies, including call records processing, billing and customer relationship management and operation support systems. Now he is lead data warehouse developer for Washington State Department of Corrections. He regularly delivers technical presentations at Olympia, WA, PASS chapter.
LinkedIn: http://www.linkedin.com/in/juliekoesmarno
Contact: http://www.mssqlgirl.com
Julie Koesmarno, MCSE Data Platform, and MCSE Business Intelligence, MCT, is a Senior Program Manager at Microsoft, with a Bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her past projects include delivering a SQL Server 2012 data warehouse and BI solutions in the US and Australia. She now works with hybrid, cloud and on-prem SQL projects.
LinkedIn: http://www.linkedin.com/in/sebastianmeine
Contact: http://sqlity.net/en/blog/
Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.
LinkedIn: http://au.linkedin.com/in/martincairney
Martin has 20 years’ experience in SQL Server technologies. His experience spans both the Database Engine and infrastructure requirements, and Data Warehousing and BI implementations. He has worked across many industry sectors including London’s global financial institutions and both State and Federal Government Departments. He is a SQL Server MVP, MCT and an experienced conference presenter, having presented at PASS Summit, SQLBits, and SQLSaturday events and User Groups round the world
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: 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://dh2i.com/
Carl Berglund has 20+ years of experience helping businesses source and implement sophisticated datacenter infrastructures. Carl has held senior business development roles at HP and PolyServe, where he helped drive enterprise organizations’ SQL Server consolidation, virtualization and optimization projects. As a technology evangelist, Carl helps organizations reduce spend on overall SQL Server lifecycle costs while reducing risk. He is a regular speaker and author on Windows datacenter issues.
LinkedIn: http://www.linkedin.com/in/johnbmcallister
Contact: http://www.profisee.com
John McAllister co-founded Stratature, an Independent MDM software vendor, in 2001. Following Microsoft’s acquisition of Stratature in 2007 John served as Group Program Manager for MDS and oversaw the incorporation of MDM into SQL Server. John now serves as the Regional Sales Director for Profisee, Inc. which provides enterprise-class MDM Solutions built on top of Microsoft’s MDS offering. John has worked with 100’s of organizations around the world in all phases of MDM projects.
LinkedIn: https://www.linkedin.com/in/carloslchacon
Contact: http://sqldatapartners.com/blog
Carlos Chacon is the managing partner of SQL Data Partners LLC and co-host of the popular SQL Data Partners Podcast. While getting his start as a typical accidental DBA, Carlos has sat on Microsoft exam review panels, served as regional mentor and chapter leader. He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven). He and his family live in Richmond, Virginia.
LinkedIn: https://www.linkedin.com/company/1319388
Contact: http://us.sios.com/blog/
SIOS Technology Corp. makes software products that protect data and applications from downtime, while eliminating complexity, and reducing labor costs. SIOS products make clusters in both SAN and #SANLess environments easy to use and easy to own. By removing the configuration limitations of traditional clusters, SIOS products give enterprise data managers the freedom to run applications in the environment that best meets their needs -- physical, virtual, cloud or any combination thereof.
LinkedIn: http://www.linkedin.com/in/b5lurker
Contact: http://blog.wakebi.com
Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.
Contact: http://www.profisee.com
John McAllister co-founded Stratature, an Independent MDM software vendor, in 2001. Following Microsoft’s acquisition of Stratature in 2007 John served as Group Program Manager for MDS and oversaw the incorporation of MDM into SQL Server. John now serves as the Regional Sales Director for Profisee, Inc. which provides enterprise-class MDM Solutions built on top of Microsoft’s MDS offering. John has worked with 100’s of organizations around the world in all phases of MDM projects.
LinkedIn: http://www.linkedin.com/in/joshuafennessy/
Contact: http://www.joshuafennessy.com
Josh Fennessy, Solution Architect at BlueGranite, has been building solutions with the SQL Server BI stack for 8 years. He is a Microsoft Certified Solutions Expert in Business Intelligence. Josh#39;s passions include manipulating data in novel ways to open analytic possibilities not before possible. Josh is active in the SQL Server and Open Source communities. Beyond relational and OLAP data projects, Josh is also involved in projects using cluster computing platforms such as Hadoop.
LinkedIn: https://www.linkedin.com/in/rob-volk-134ba81
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
LinkedIn: http://www.linkedin.com/in/mickeystuewe/
Contact: http://www.MickeyStuewe.com
Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design. She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQLSaturdays, User Groups and other events. When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often...just ask her children.
The following is a list of sponsors that helped fund the event.


What The Duck
A simple browser extension that replaces the F word with Duck
Exclude sites
One per line


The Registration beta login type is being phased out. We will be replacing it with an improved custom data capture entry form.
In the mean time your splash page will continue to work as-is but you will not be able to change the login type.
Please create a new splash page if you want to use a different login type.
What login types do you want to offer?
Please be aware that SMS usage is charged separately to your subscribed plan. See here for more information.
Vouchers have their own rules. When you create a batch of vouchers, you also create the policies which limit speed, time etc.
To use QuickCodes, generate some code in your location settings. They can be generated on the fly for and you can set restrictions, just like vouchers.
Guests will be redirected to this URL after they log in
Set the start and end times to 00:00 to allow access all day
Upload a background image. Please note, large images will delay page load times.
Upload your logo which must be 200px by 106px. Upload your banner image which must be 851px by 315px.
It is a legal requirement to be GDPR compliant if you run a hotspot within the EU.
Saving...


Working with JSON Data
Objective
In this chapter, you will learn how to send and receive JSON data from a remote data source via the HTTPClient object.
Contents
The best data transport format for use with JavaScript (and hence Titanium) is JavaScript Object Notation, or JSON. JSON is a great fit for JavaScript applications since it can very easily be serialized into and out of JavaScript Objects. Moreover, since JSON is such a terse transport format, it takes less less time and less bandwidth to transfer over the air, which can become important on low-speed data networks. For more on JSON, check out the official website.
Titanium has built-in support for JSON serialization in the JSON namespace. The two functions provided in this namespace are:
-
JSON.stringify() which takes a JavaScript object and converts it to a string.
-
JSON.parse() which takes a JSON-formatted string and converts it to a JavaScript object
(Remember that in JavaScript, arrays are objects. So these methods work with both arrays and objects.)
var myObject = {
foo:'bar',
stuff:[1,2,3]
};
//serialize
var myObjectString = JSON.stringify(myObject);
// returns '{"foo":"bar","stuff":[1,2,3]}'
//deserialize...
var myNewObject = JSON.parse(myObjectString);
// myNewObject.stuff[1] === 2
If you have a server-side resource (web service) that has a JSON response format, you can very easily serialize that response inside HTTPClient's onload function. The data returned from your web service will be stored as a property of the HTTPClient object, so it is accessed and parsed like so:
xhr.onload = function(e) {
var myData = JSON.parse(this.responseText);
};
No methods
JSON cannot represent methods. So, the stringify() method will not support converting an object with methods to a JSON string. If you attempt to stringify an object that has methods, the function will return an empty string. Keep in mind that most native Titanium objects have methods. Attempting to stringify any of them will return an empty representation.
Receiving and parsing JSON data
You retrieve JSON data using the HTTPClient object. Within the onload callback, this.responseText contains the raw text response from the target URL. It is the property you should use when processing JSON or other plain text data.
var url = "http://example.com/json.txt";
var json;
var xhr = Ti.Network.createHTTPClient({
onload: function() {
// parse the retrieved data, turning it into a JavaScript object
json = JSON.parse(this.responseText);
// ...
}
});
Sending JSON data
The HTTPClient's send() method automatically stringifies data for you. So, you don't need to explicitly take this action before submitting data in a POST payload. Then again, since send() accepts null, dictionary, string, File object or Blob data, there's no harm in calling JSON.stringify() on the data first. Should you need to send object data in a GET querystring, you will need to stringify data first. You'll probably need to URL encode the resulting string to safely pass it as a querystring parameter. Use the JavaScript encodeURIComponent() function to do that.
var blogPost = {
title: 'My awesome blog',
body: 'Today I met Susy at the laundromat. Best day EVAR\!'
};
var xhr = Ti.Network.createHTTPClient({
onload: function() {
// handle the response
}
});
xhr.open('POST','http://www.myblog.com/post.php');
// optional:
// blogPost = JSON.stringify(blogPost);
xhr.send(blogPost);
Hands-on Practice
Goal
In this activity, you will retrieve and parse JSON data and display the information in a TableView
Resources
In this activity, you will retrieve a JSON-formatted file from https://raw.github.com/appcelerator/Documentation-Examples/master/HTTPClient/data/json.txt. That file contains data formatted like this:
{
"fighters": [
{
"name": "Muhammad Ali",
"nickname": "The Greatest"
},
{
"name": "Chuck Liddell",
"nickname": "The Iceman"
},
// etc.
]
}
Steps
-
Create a new Titanium Mobile project.
-
Replace the code in app.js with code that defines a single window containing a TableView.
-
Add the code to retrieve the JSON data from the URL given above. When the data is successfully retrieved, parse it and populate the table. For each row:
-
Add a label with large, bold text listing the fighter's name. Position it at the top-left of the row.
-
Add a label with smaller, normal text listing the fighter's nickname. Position it below the first label.
-
Set the resulting data as the TableView's data to populate the table.
-
-
Add the code to handle a network error. Log the HTTP status code, the text retrieved, and any error message. Alert a simple message to the user.
-
Set the timeout to 5 seconds.
-
Build and test your app in the simulator/emulator.
References and Further Reading
-
See Handling Remote Data with HTTPClient and JSON for one possible solution to the hands-on activity above
Summary
In this chapter, you learned how to send and receive JSON data from a remote data source via the HTTPClient object.


We believe in coming up with original ideas and turning them into digital work that is both innovative and measurable. Show us your talent and help yourself with the exposure around. Best idea will be rewarded with deserved things. Our valuators will vote the ideas and the highest voted will get a chance to be the member of our foundation team.
Put a frame to your ideas and post it to us. We promise your ideas will be safe with us and the better ideas will get selected to attend our competation
Your Hackathon journey will start with us in this stage. At the entry you need to submit your designs about your idea and then you start working with it. Every team will get a platform to express their work with the presentation
In the Implementation part you need to complete your project coding and host it in our private repository. You need to acompolish it in a given time and the best idea will get the ultimate prize
Online Hackathon
24 hours Hackathon
48 hours Hackathon
12 hours Hackathon
Address: 11231 Buah Batu Bandung
Phone: 987-654-321
Email<EMAIL_ADDRESS>2610, 38th B Cross, 26th Main
9th Block, Jayanagar
Bangalore - 560069
974-265-3096
973-994-5538


Class FixedMultiValueDatabase
Implements
Inherited Members
Namespace: KdSoft.Lmdb
Assembly: KdSoft.Lmdb.dll
Syntax
public class FixedMultiValueDatabase : MultiValueDatabase, IDisposable
Methods
OpenCursor(Transaction)
Create a fixed multi-value cursor. A cursor is associated with a specific transaction and database. A cursor cannot be used when its database handle is closed. Nor when its transaction has ended, except with mdb_cursor_renew(). It can be discarded with mdb_cursor_close(). A cursor in a write-transaction can be closed before its transaction ends, and will otherwise be closed when its transaction ends. A cursor in a read-only transaction must be closed explicitly, before or after its transaction ends. It can be reused with mdb_cursor_renew() before finally closing it. Note: Earlier documentation said that cursors in every transaction were closed when the transaction committed or aborted. Note: If one does not close database handles (leaving that to the environment), then one does not have to worry about closing a cursor before closing its database.
Declaration
public override Cursor OpenCursor(Transaction transaction)
Parameters
| Type | Name | Description |
|---|---|---|
| Transaction | transaction |
Returns
| Type | Description |
|---|---|
| Cursor | Instance of MultiValueCursor. |
Overrides
OpenFixedMultiValueCursor(Transaction)
Create a fixed multi-value cursor. A cursor is associated with a specific transaction and database. A cursor cannot be used when its database handle is closed. Nor when its transaction has ended, except with mdb_cursor_renew(). It can be discarded with mdb_cursor_close(). A cursor in a write-transaction can be closed before its transaction ends, and will otherwise be closed when its transaction ends. A cursor in a read-only transaction must be closed explicitly, before or after its transaction ends. It can be reused with mdb_cursor_renew() before finally closing it. Note: Earlier documentation said that cursors in every transaction were closed when the transaction committed or aborted. Note: If one does not close database handles (leaving that to the environment), then one does not have to worry about closing a cursor before closing its database.
Declaration
public FixedMultiValueCursor OpenFixedMultiValueCursor(Transaction transaction)
Parameters
| Type | Name | Description |
|---|---|---|
| Transaction | transaction |
Returns
| Type | Description |
|---|---|
| FixedMultiValueCursor | Instance of FixedMultiValueCursor. |


The Sparks Foundation
Home
Programs
about
contact
Welcome To The Family!
Our communities stand united against racism. Hate against Asian American Pacific Islander communities has risen during the COVID-19 pandemic. Together, we can stop it.
"Let's come together to make this world better."
Donate Now
Latest Reports
National Report (through June 2021)
Read more>>
Stop AAPI Hate Mental Health Report
Read more>>
The Rising Tide of Violence and Discrimination Against Asian American and Pacific Islander Women and Girls
Read more>>


Choose a service and event from the list below to edit or create scripts when that event is fired.
Please choose an event below.Working on {{currentScript}} ({{verb}} on /rest{{scriptPath}})
View Samples
Filter :
{{event.name}}
Path :
{{path.path}}
{{event}}
The Free Hosted Edition of the DreamFactory Services Platform does not support Server Side Scripting. Please install DreamFactory on your cloud or server for this capability. Click here to download the open source software package.


The main purpose of ITIC is to provide software devlopment services for both private and governmental companies. As a team leader, I encourage the ITIC team to follow up on the latest marketing strategies and modern methodologies of information technologies. ITIC also conducts free programming courses on YouTube for young software developers.
Founder of ITIC (Information Technologies Innovative Company). Bachelor degree of INHA University in Tashkent in the faculty of Software and Computer engineering.
Influencer, Motivator and characteristic of Leadership. To be more precise, I have strong organizational skills, award-winning educational background and ability to work well with people. Knowledge of HTML/HTML5, CSS/CSS3, SASS, Bootstrap tech, Javascript/Jquery, ReactJS, GIT.
We offer following information technologies services and be familiar with each service and it's benefit for your company or business.
This service provides your company or the business with the latest fashioned web sites and helps you to be admitted on the world web.
We create latest trendy designs for your business by developing memorable and user friendly interfaced web applications
Phones are daily usage of tool as daily need of water consumption. So provide your clients with mobile apps that defines your way of business.
By this service, your business will be guaranteed to success in the number of customers and enlarges your audience.
In order to provide pure evaluation, this section will make you sure about our service by the comment of clients like you. By working colloboratively with you, we acquire one more important comment for our service.
CEO of Al Bukhari Innovative School. Cooperation with ITIC helped us to run our website in a short period.
Founder of ACE ACADEMY. Our educational center is now accepting students via our official website by the help of ITIC
The services which ITIC provide are the most trendy and important requirement for every company to establish the way of business in the world market
ITIC helped me so much to create amazing UX/UI design for my term project and I am sure that we will continue working collaboratively
After the COVID and quarantine, we needed to work online and we made a contract with ITIC to develop web application for patients to analyze and advice to them online.
By subscribing us you will be notified about the latest events and offers of ITIC Company


CAN
— CAN controller¶
-
class
CAN
([, profile=0] [, id_filters=None] [, hard_reset=False] [, start=True])¶ Represents CAN controller hardware.
- Parameters
profile (int) – The profile for the CAN bus bit rate (see Profiles).
id_filters – A dictionary mapping integers to
CANIDFilter
instances (see ID filtering)hard_reset (bool) – Set to True to reset the CAN controller at the lowest level (equivalent to power-on reset)
start (bool) – Set to False to prevent the CAN controller from joining the CAN bus
- Raises
TypeError – if the key/value pairs in id_filters are not int/instances of
CANIDFilter
ValueError – if the profile value is out of range
RuntimeError – if the controller hardware is not connected via SPI
A value of None for id_filters sets up the CAN controller to accept all incoming frames.
Methods¶
-
send_frame
(frame[, fifo=False])¶ Queue a frame for transmission on the CAN bus
- Parameters
frame (CANFrame) – The CAN frame to send
fifo (bool) – Whether the queue the frame in the FIFO queue (see FIFO transmission)
- Returns
True if the frame was queued successfully, False otherwise
- Return type
bool
- Raises
TypeError – if frame is not an instance of
CANFrame
.
-
send_frames
(frames [, fifo=False)¶ Send a collection of CAN frames on the bus
- Parameters
frames (CANFrame) – A list of CAN frames to send
fifo (bool) – Whether the queue the frames in the FIFO queue (see FIFO transmission)
- Returns
None
- Raises
TypeError – if frames is not a tuple of
CANFrame
instancesValueError – if there is insufficient room in the queues
-
recv
([limit=128])¶ Receive CAN frames
- Parameters
limit (int) – The maximum number of frames to remove from the FIFO (defaults to the entire FIFO)
- Returns
a tuple of
CANFrame
instances for the CAN frames received since the last call to recv- Return type
tuple
The tuple is ordered by the order of CAN frame reception into the receive FIFO and the frames are removed from the FIFO. If no frames have been received then an empty tuple is returned. An element in the tuple is None if there are one or more missing frames because the FIFO was full at that point.
This function can be polled regularly to return the frames received.
-
recv_pending
()¶ Number of CAN frames in the receive FIFO
- Returns
the number of CAN frames pending in the receive FIFO (including any elements of type None)
- Return type
int
-
get_send_space
([fifo=False])¶ Number of slots for CAN frames in the transmit priority queue or FIFO
- Returns
the space in the transmit FIFO (if fifo is False) else the space in the transmit priority queue
- Return type
int
-
get_status
()¶ - Returns
a tuple of four elements: a bool indicating bus-off state, a bool indicating error passive state an int representing the Transmit Error Counter, and an int representing the Receive Error Counter
- Return type
tuple
-
get_time
()¶ - Returns
The value of the free-running timer used for timestamping transmitted and received CAN frames
- Return type
int
The time is represented by an incrementing integer that wraps around to 0. See Controller specifics for details on the controller-specific mapping of this count value to real-time.
Profiles¶
The table below gives the CAN bit rate settings for the valid profiles (in the future more profiles may be added).
Profile |
Bit rate (Kbit/sec) |
Sample point (%) |
Pre-defined constant |
|---|---|---|---|
0 |
500 |
75 |
BITRATE_500K_75 |
1 |
250 |
75 |
BITRATE_250K_75 |
2 |
125 |
75 |
BITRATE_125K_75 |
3 |
1000 |
75 |
BITRATE_1M_75 |
4 |
500 |
50 |
BITRATE_500K_50 |
5 |
250 |
50 |
BITRATE_250K_50 |
6 |
125 |
50 |
BITRATE_125K_50 |
7 |
1000 |
50 |
BITRATE_1M_75 |
Examples¶
In all the examples, the classes are assumed to have been imported with:
>>> from rp2 import *
To create (and initialize) a CAN controller:
>>> c = CAN()
This initializes the CAN controller on the board with the default profile (500kbit/sec, 75% sample point) and sets up the ID filtering to receive all frames.
To use a different bus bit rate:
>>> c = CAN(profile=CAN.BITRATE_250K_75)
To pick up the received CAN frames:
>>> frames = c.recv()
To run a simple bus analyzer:
>>> while True:
>>> frames = c.recv()
>>> for frame in frames:
>>> print(frame)
The bus analyzer prints each it sees (See CANFrame
for details).
To set up CAN ID acceptance filters:
>>> id_filters = {0: CANIDFilter('1001XXXXXXX'), 1: CANIDFilter('XXXXXXXXXXXXXXXXXXXXXXXXX0000'), 31: CANIDFilter())
>>> c = CAN(id_filters=id_filters)
The acceptance filters are set to accept all frames into the receive FIFO, but frames with an 11-bit ID where the
top four bits are 0b1001 will have an index tag of 0 (accessed by the frame’s get_index()
method), frames
with an extended ID where the bottom four bits are 0 will get an index tag of 1 and all other frames will
get an index tag of 31. These tags can be used to quickly identify a frame for further processing.
To only receive 11-bit standard ID frames:
>>> id_filters = {0: CANIDFilter('XXXXXXXXXXX'))
>>> c = CAN(id_filters=id_filters)