Triphic
Introduction
Triphic does pharmacophore-based 3D similarity searching of a file of
molecules. Most commonly, this will involve a single conformation of a
molecule querying an OEBin file. It can run in serial or parallel
using OpenMPI. It is similar in concept (though developed independently
of) the CLIP program of Rhodes et al. (JCICS, 43, 443-448 (2003)).
The triphic search is done by identifying, using SMARTS and points
files, features of interest in the query and database molecules and
using clique detection to find database molecules that have a features
of the same type and relative spatial arrangements as 3 or more of the
features in the query. Any such database molecules are overlaid onto
the query using the matching features and scored.
Running Triphic
Triphic runs from the command line. As a bare minimum you need a
query file, a database file and an output file. There are numerous
other options controlling the scoring, defining features or feature
types that must be matched in the query etc.
Mandatory Arguments
A molecule file name means one
that ends in an extension that the OEChem toolkit recognises,
e.g. .mol2, .sdf, .oeb.gz etc. The format will be deduced from the
extension. You can specify a SMILES file, but the
amount of information about the overlays contained in the SMILES
file is low.
Optional Arguements
-
--help Produces the help text. Giving no arguments or an incorrect
argument will also have this effect.
-
-S <string> or --smarts-file <string> Gives the name of
the SMARTS
file containing the definitions to be used for defining the
pharmacophore features.
-
-P <string> or --points-file <string> Gives the name of
the points
file containing definitions of the features to be
used in the searching, including some extra
information about which directional vectors are to be
included, if any. These are ring normals, X-H bond
vectors or lone-pair vectors. If neither the SMARTS
or points file is specified, a default set of
definitions will be used which will probably do you
right in most cases.
-
--db-files-file Specifies a file containing the names of database
files to be read. Used instead of giving multiple -D options. You
can use both options in the same run if that's your thing.
-
-M <int> or --max-hits <int> The maximum number of hits that will be
output. It defaults to 1000. These are always the
top-scoring hits for the search, according to the
primary score. Giving a value of 0 means no maximum -
all hits will be accumulated and output in sorted
order. Make sure you've got enough memory!
-
--protein-file <string> Gives the name of a molecule file containing a
protein structure. As part of the scoring for each hit the overlap
volume with the protein will be calculated. Optionally, the hit can
be optimised in the field of the protein. For this to be useful, the
query must be in the same reference frame as the protein, such that
hits overlaid onto the query are in an orientation relevant to the
protein. The overlap volume calculation is grid-based and the
speed is largely independent of the size of the protein.
-
--subset-file <string> A file containing names of molecules to be used
in the search. Molecules in the database file not mentioned in this
file will be ignored. The names must match exactly, so if your
database file has been prepared according to some ionisation
and/or tautomer model, and tautomer numbers have been added to the
names in the database, those numbers must be added to the names in
the subset.
-
-G <string> or --grid-score-file <string> The name of a grid file,
probably prepared by PSG. For each hit, the overlap
volume with the grid will be reported in the output
file. More than 1 grid can be used, but each one
needs a separate -G <string> option.
-
--primary-score <string> where <string> is one of <RMS_AND_SIZE|ROBINS_PARETO|OVERALL_PARETO|GAUSS_SHAPE_TANI|GRID_SHAPE_TANI|SURFACE_OVLP_VOLUME|PROTEIN_CLASH|MMFF_ENERGY>
Specifies the primary score to be used for sorting the hits. The
options are string values, only one of which should be
attempted. The default is RMS_AND_SIZE. GAUSS_SHAPE_TANI,
GRID_SHAPE_TANI and SURFACE_OVLP_VOLUME
refer to calculations between the query and each hit. The grid-based
shape tanimoto, overlap volume and total volume will be reported for
the hits, and can be used for the sorting and filtering of results
if required. PROTEIN_CLASH is the overlap volume between the protein
and each hit, and MMFF_ENERGY is the strain energy between same. If
there is no protein, you'll get undefined behaviour. ROBINS_PARETO
is very close to the scoring method from Robin Taylor, as used in
CCDC's pharmacophore overlay program (JCAMD, 26, 451-472) and is the
combination score from shape tanimoto, h-bond and hydrophobe
scores. OVERALL_PARETO uses all the scores in the current
search to come up with a best consensus order. In order to
get a Robin_HPhobe score for ROBINS_PARETO scoring, you need a
point of type Hydrophobe in the points file. It's a sad fact
that the ROBINS_PARETO method is an afterthought, and
therefore doesn't fit in with points file structure very well.
Triphic will check that the points file is compatible with
ROBINS_PARETO and not proceed if it isn't.
-
--ring-normal-vector <IGNORE|SCREEN|ALIGN> How to treat ring normal
vectors. If this option is given, the points file must have
specified which points are to be used for generating ring
normals. The three options are strings, only one of which should be
given. They refer to how the search and overlap procedure should use
any ring normal vectors on features that match between the query and
any hit. IGNORE is pretty easy. SCREEN says that the vectors in matching
features must be aligned within a tolerance (see below) for the hit
to be accepted. ALIGN takes the ends of the vectors and adds them to
the matching features and the alignment repeated. This will try and
bring the ring normals into closer alignment than they were. After
the ALIGN has been carried out, the SCREEN criteria are applied.
-
--ring-normal-tolerance <float> Gives the tolerance on the directions
of ring normal vectors when they are being used in SCREEN or ALIGN
mode. Default is 30 degrees.
-
--h-bond-donor-vector <IGNORE|SCREEN|ALIGN> How to treat H-bond donor
vectors. Similar remarks apply as to ring normal vectors, with the
addition that if the X-C bond is deemed rotatable (if it's a single
bond, and the X atom (O or N) is not conjugated with a pi-system)
the X-H bond will be aligned as closely as possible with the query
first by rotation about the X-C bond.
-
--h-bond-donor-tolerance <float> Same as for ring normal vectors.
-
--h-bond-acceptor-vector <IGNORE|SCREEN|ALIGN> And the same for H-bond
acceptor vectors
-
--h-bond-acceptor-tolerance <float> Likewise.
-
--use-omega Use the Omega toolkit to do conformation expansion of
the input structures on the fly. Really only makes sense if the
input file is a set of 2D structures, but it will use Omega
regardless.
-
--use-flipper By default, Omega rejects input structures with
unspecified stereochemistry at stereocentres it recognises. The
flipper protocol gets round this by generating all possibilities
before sending them to Omega. Of course, this might mean that
you search and hence get hits for a stereoisomer that isn't the
one in the bottle. Whether you use flipper or not is a matter of
debate, but you do at least have the choice!
-
--do-ionisation-and-tautomers This imposes the ionisation and
tautomer models currently in vogue at AstraZeneca for preparing
virtual screening databases. It uses the code in the TautEnum
project that should be available from the same place you
obtained this code.
-
--no-warts By default, when the Omega conformations are enumerated
the conformation number is appended to the molecule name, such that
Mol1 conformation 111 becomes Mol1_111. The standalone Omega program
calls these decorations 'warts' and hence so does triphic. This
option turns them off.
-
--optimise-ligand-rigid Specifies that a rigid-body optimisation of
each hit within the protein should be performed. There's no subtlety
about this, and it's more than likely that the ligand will ping
miles out of the active site if there's any sort of clash. Unless a
bit of it is so embedded that it's trapped. It uses OpenEye's
implementation of the MMFF forcefield for the optimisation
(Szybki toolkit), and the
final energy is reported as a score. If you're checking the
alignment of vectors, this is done after the optimisation. If
you don't have a license for the Szybki toolkit, this option
will be ignored.
-
--optimise-ligand-flexi Same as above, but with the ligand allowed
torsional flexibility. In both cases, the protein is kept
rigid.
-
--min-clique-size <int> Minimum size of clique for a hit i.e. minimum
number of matching features between the query and the hit. Defaults
to 3. You need at least 3 features for a sensible overlay.
-
--dist-tol <float> The tolerance on distances between matching
features. This is not the maximum RMS distance in the overlay, but
the tolerance on matching pairs of features passed into the
clique-detection algorithm that determines whether there's a hit or
not. If A in the query matches A' in the target molecule, and B
matches B' then for both A and B to appear as matching features, the
distance between A and B must be the same as the distance between A'
and B' with the tolerance. The default is 1 Angstrom.
-
--scaled-dist-tol <float> This introduces a scaled tolerance instead
of the --dist-tol fixed value. The tolerance, as described above,
becomes the A to A' distance multiplied by the scaling factor, so
that nearer features have a tighter tolerance than features that
are further apart.
-
--max-rms <float> This is the maximum RMS between overlaid matching
features in the query and hit. Default is 2.5 Angstrom.
-
--min-gauss-shape-tanimoto <float> The minimum Gaussian shape tanimoto
between the query and a hit for the hit to be accepted. Can be any
number, but if it is to be effective, needs to be between 0.0 and
1.0. The default, -1.0, means no filtering. The shape tanimotos
aren't quite the same as those calculated by ROCS - the formula's
the same, but different approximations are used. There is a
reasonable correlation in the limited set I compared.
-
--min-grid-shape-tanimoto <float> Similar to
--min-gauss-shape-tanimoto. This is the grid calculation that the
more recent manifestations of triphic used. It was deemed too slow
for some applications but it is, in my opinion, more
correct. There is a strong but not complete correlation with the
Gaussian shape tanimoto.
-
--max-mmff-energy <float> A cutoff on MMFF energy between the ligand
and protein. Hits with an energy greater than the cutoff won't be
reported. The default is the largest floating point number your
machine can think of (MAX_FLOAT) and so is effectively no cutoff.
-
--min-surface-volume <float> A cutoff on the surface overlap volume
between the query and the hit. Hits that have less than this value
will be discarded. Defaults to 0.0.
-
--max-protein-clash <float> A cutoff on the overlap volume between the
protein and the hit. Hits that intrude into the protein by more than
this value will be discarded. Default is MAX_FLOAT.
-
--min-included-volume <float> A cutoff on the overlap volume between
the query and the hit. Hits that have an overlap volume less than
this will be discarded. Default is MaX_FLOAT.
-
--no-hit-conf-number Specifies that the hit molecules should not have
the conformation number added to the name, but should just be called
the same as the parent molecule.
-
--output-query-to-hits If the query is a molecule, then the query
structure is written to the top of the output file. There will be no
corresponding line in the scores file, though, so there should be 1
more molecule in the output file than score in the scores file.
-
--print-sites-and-stop Runs the program until the query sites have
been generated, prints details of same to screen and stops. Useful
if you are going to want to specify required sites (see below).
-
--comma-output Specifies that the scores file should have
comma-separated fields. The default is spaces.
-
--output-scores-only Specifies that just the scores file should be
produced, not the molecules file. You still specify the output file
as a molecule file though.
-
--single-conf-mols Specifies that the database file is to be treated
as a collection of single conformation molecules. Only relevant for
ASCII molecule files such as MOL2 or SDF. The default behaviour is
to assume that molecules with the same name and connection pattern
are different conformations of the same molecule.
-
--req-sites-or <string> Specifies that the named site must be added to
the OR'ed list of required sites. One or more of the OR'ed required
sites must be matched in the query by a site in the hit for the hit
to be accepted. If you want more than one site in the OR'ed list,
you must give multiple --req-sites-or <string> options. Site means a
specific instance of a feature in the query
e.g. Site_1_acceptor.
-
--req-sites-and <string> Similar to previous option, but the named
site is added to the AND'ed list. All query sites mentioned in the
AND'ed list must be matched by a feature in the hit for the hit to
be accepted.
-
--req-points-or <string> Similar to req-sites-or except it refers to a
feature type rather than a specific site, so would be something like
acceptor or donor.
-
--req-points-and <string> Similar to req-sites-and.
-
--ignore-sites <string> Removes the named site from the query before
the searching starts. Can be used more than once.
-
--dont-give-me <string> Specifies a file of SMARTS definitions, that
may have vector bindings, and/or may use vector bindings from the
main SMARTS file, that the hits may not match. Database molecules
that match any SMARTS so specified will not be searched further.
-
--i-already-know-about <string> Synonymous with ---dont-give-me-file
-
--sites-score-file <string> Specifies a file of molecule structures,
for use when the query file is in MOE ph4 format. The
molecule in the file will be used to calculate the
normal volume scores during the run, such as the shape tanimoto,
that aren't normally available in a ph4 query because there isn't
a structure to work with.
-
--gauss-shape-tanimoto Specifies that the Gaussian shape tanimoto
should be calculated between each hit and the corresponding
query. The default is for this to be true, and, thinking about it, I
don't think it can be turned off!
-
--grid-shape-tanimoto Specifies that the grid-based shape tanimoto,
included volume and total volume between each hit and the query
should be calculated. By default, they aren't, to save time, unless
some other option requires it, such as min-grid-shape-tanimoto.
-
--all-best-hits By default, triphic returns at most one hit per target
molecule, the one with the best primary score. This option has it
putting out all the best hits from each target molecule. So if there
are two different sets of features that both match between the query
and the target, both will be reported. If for a given matched set
there is more than one conformation that matches, the best match by
primary score is returned. That's what the 'all the best hits' bit
means. This option does not over-ride the --max-hits argument, nor
does it alter the sorting of the hits - the hits are still fed into
the sorted hit list in the normal way and truncated at the maximum
number. So if you're going to use this option, you'd probably be
better raising the --max-hits number or setting it to 0.
-
--dont-do-sub-cliques By default, if a clique is found that is larger
than --min-clique-size, triphic also generates all sub-cliques down
to that size. This can slow things down quite a lot as the number of
overlays that need scoring shoots up, and you might not always want
it. So this option turns off that behaviour.
-
--restart Specifies that the job is a restart of a
partially-completed run. Give exactly the same command as you
did for the first run, adding --restart and if the output file
is called dead_output_file.sdf, it expects to find a file
dead_output_file.RESTART. This file contains all information
needed to restart the job from the last checkpoint.
-
--restart-number <int> This option behaves exactly the same as
--restart but allows you to over-ride the point in the database file
it starts from, using the integer argument, which is the number of
molecules to skip before starting searching again.
-
--parallel-chunk-size Sometimes, to reduce latency, it's quicker if
the slave process in a parallel job do more than one molecule at a
time. The default is to do chunks of 5 molecules.
-
--max-versions This controls the number of ionisation, tautomer and
stereoisomer states that are generated if doing these things. The
default is 16. Some compounds can produce ridiculous numbers of
these, which slows the whole thing down. If the number is exceeded,
the molecule is skipped. The program is for rapid screening of
likely drug molecules, after all.
Some Notes
It turns out that Pareto ranking is inappropriate for sorting lists of
items and particularly for inserting a new item into a sorted list. It
is quite possible to get a situation where A > B > C > A if there
isn't strict dominance between them. This makes the final answer
dependent on the input order of the hits, which in a parallel run
makes it all pretty random. After a bit of experimentation, for the
ROBINS_PARETO and OVERALL_PARETO primary scores, I've come up with a
score that attempts to put each of the different constituent scores on
a scale of 0.0-1.0, and then sums them. For ROBINS_PARETO, this is
done by comparing scores for a hit back to the best possible score,
which is assumed to be the query scored against itself. To this end,
the score for a hit would be ((HPhobe_Hit/HPhobe_Query) +
(HBond_Hit/HBond_Query) + (Grid Shape Tanimoto)). Similar things are
done for OVERALL_PARETO, with a bit of bodging in places. For example,
the protein clash term (which is measured in cubic angstrom) is
converted to the fraction of the hit that sticks into the protein. In
this case, it's not appropriate to compare to the query's protein
clash since that should be zero if the crystallographer's been doing a
proper job.
MOE is a molecular modelling program from the Chemical Computing Group
(ccG). It can be used to create pharmacophores and those can be
written to file for database searching. It has a fairly complex and
not, as far as I know, documented, format. Triphic uses just the feature
points and included volumes bits. I think that's all the useful
stuff in the file, but it's difficult to be sure. Extension points can
also be used as part of the query. If they are clearly associated with
a base site, they will be converted into site directions such as
triphic has always had as an option. MOE also lets you specify them
'naked', such as when setting up the query from a protein active
site. In this case, the virtual sites from ROBINS_PARETO scoring are
used from each database conformation to match. This is the best
method yet found for making triphic crawl at an appallingly slow rate,
because it dramatically increases the number of features in the
database conformation, meaning vastly more cliques to be scored. A
hydroxyl produces 12 virtual site points, for example. In one simple
test case, adding a single extension point to the query increased the
number of cliques to be scored by a factor of 40, and two extension
points by a factor of 60. You probably want to use
--dont-do-sub-cliques at least when doing big searches or preliminary
screening. Included volumes in the PH4 file will be reported as
overlay volumes MOE_Volume_1 etc.


| Dat tungg tho pupperino length boy. borkdrive aqua doggo. Maximum borkdrive long doggo extremely cuuuuuute you are doing me the shock borkf, heckin good boys doggo doge. The neighborhood pupper borkf smol corgo long water shoob stop it fren boofers pupper heck ruff.
|
Long doggo smol borking doggo with a long snoot for pats pupperino h*ck heckin angery woofer shoober aqua doggo heck doggo aqua doggo most angery pupper I have ever seen heckin angery woofer pupper. ruff adorable doggo very hand that feed shibe. Extremely cuuuuuute corgo waggy wags stop it fren.
|
Most angery pupper I have ever seen such treat heck, dat tungg tho. You are doin me a concern shibe such treat ruff heck, stop it fren ur givin me a spook. Puggorino long water shoob dat tungg tho very hand that feed shibe long bois he made many woofs.
|


<taskbody>
The <taskbody>
element is the main body-level element inside a task
topic. A task body is designed to contain information specific to completing a task, such
as prerequisites, contextual information, and steps. DITA 1.2 introduced a much looser
<taskbody>
content model in order to allow for more variations in the
structure of a task. A constraint module was also provided in order to maintain
compatibility with the previous strict model; this constraint is used in the default task
distributed by OASIS.
Category: Task elements


Event Location:
Whitireia New Zealand
3 Wi Neera Dr, Elsdon, Porirua
Wellington, Wellington, New Zealand
Abstract:
Extended events to aid in performance tuning and in day to day administration specially when you don't have any benchmarking data for troubleshooting issues. In this session, we will see how the Extended Events streaming API can be used to process events in a near real-time. We will demonstrate how this feature enables new possibilities to capture real time problems without enabling any third party tools or inbuilt SQL Server features to capture issues like blocking, deadlocks, high CPU and many more. Extended Events were introduced in SQL Server 2008 but by SQL Server 2016, it has enhanced significantly. After this session, hopefully you will start using extended event, if you haven't started using till now.
Speaker(s): Dharmendra Keshari,
Abstract:
Powershell has been part of Windows for > 10 years and has been part of SQL Server since 2008. In spite of this the adoption among Database Professionals for use in investigating and managing their environments has been low. With the release of the open source DBA Tools module from DBATools.IO, with its 300+ commands, the time has arrived for Database Professionals to embrace PowerShell and upgrade their skills to support the modern Hybrid environment. In this session we will look how to download, install and begin using the power within both this module and Powershell. No prior experience with Powershell required!
Speaker(s): Patrick Flynn,
Abstract:
You may have heard the word "DevOps" and wondered whether it is just another buzzword and/or what it can do for you. In this session I will demystify the concepts of DevOps and we will look at two aspects of DevOps - Continuous Integration Continuous Delivery. Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team.It also involves automating tests around the integrated work Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments. Database migrations/changes are an area that may not be typically automated or utilise Continuous Delivery. Through the use of a comprehensive live demo to a running database hosted in Azure the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline.
Speaker(s): Hamish Watson,
Abstract:
2016 is an exciting year for all of us, that continues within 2017 as well! We need a process and procedure to follow upgrading to SQL Server 2016., let's walk through a high-level upgrade workflow to help us put the process in perspective by breaking down the upgrade process - DBA Workbench. We will overview live demo with suite of Upgrade Advisor, a single consistent tool that contains three categories of advisors: Upgrade, New Features, and Best Practices, with an extensibility option to add new scenarios over time. A showcase of analyser to go through detailed list of upgrading and features that we have from SQL Server 2016 arsenal. This session focus is upon what-to-do and what-not-to-do in your data platform upgrade management.
Speaker(s): Satya Jayanty,
Abstract:
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2016 / 2017 has introduced many new features. In this 75 minute session we will be learning quite a few of the new features of SQL Server 2016 / 2017. Here is the glimpse of the features we will cover in this session. • Adaptive Query Plans • Batch Mode Adaptive Join • New cardinality estimate for optimal performance • Adaptive Query Processing • Indexing Improvements • Introduction to Automatic Tuning This 75 minutes will be the most productive time for any DBA and Developer, who wants to quickly jump start with SQL Server 2016 / 2017 and its new features.
Speaker(s): Pinal Dave,
Abstract:
In an ideal world, we would not need any error handling, because there would be no errors. But in the real world we need to have error handling in our stored procedures. Error handling in SQL Server is a most confusing topic, because there are such great inconsistencies. But that does not mean that we as database developers can hide our head in the sand. This presentation starts with a horror show of the many different actions SQL Server can take in case of an error. We will then learn how should deal with this - what we should do and what we should not and that with SET XACT_ABORT we get better consistency. We will learn how TRY-CATCH works in SQL Server, and we will get a recipe for how to write CATCH blocks. More generally, we will learn why it pays off to be simple-minded to survive in this maze. The session mainly looks at traditional T-SQL code, but the session ends with a quick look at natively compiled stored procedures, where everything is different.
Speaker(s): Erland Sommarskog,
Abstract:
High Availability and Disaster Recovery (HA/DR) planning is not just about the technology. When thinking or talking about High Availability/Disaster Recovery, many people jump straight to a particular technology without understanding other factors impacting the solution, and then waste time working backwards to understand requirements. Recovery Objectives, SLA’s and budget are some of the commonly overlooked factors when planning and developing a HA/DR solution. In this session we will walk through the 6 building blocks I take into account when developing a HA/DR solution. You can then use this same methodology to implement High Availability and/or Disaster Recovery in your own environment, working forward to determine the right technology.
Speaker(s): Warwick Rudd,
Abstract:
It’s almost a daily occurrence to hear about some sort of data breach. But what are the consequences of a data breach – for both the victims and companies involved – and what does that mean for you as a data professional. As governments start to legislate more in an effort to protect the privacy of its citizens the entire concept of data storage become more complex. Exactly what is legislation like the General Data Protection Regulation (GDPR) and how will it affect around the world. We’re seen Microsoft give us tools over the years – like Transparent Data Encryption and Dynamic Data masking - to help with this sort of thing – but is there a better answer? Come along to this session and hear how you and your team can lessen your chances of being the ones responsible for the next data breach.
Speaker(s): Martin Catherall,
Abstract:
The R server 2017 provides many functionalities for database developers. It helps us to get more insight out of data by applying descriptive, predictive, and prescriptive analysis on data. Writing R and Python codes inside SQL server management studio 2017 make this happen. In this session, first I will provide some descriptions on the predictive analysis and how to use decision tree algorithm for that reason. Then I will show how to set up SQL server 2017 to run R and Python scripts inside it. Moreover, audience will learn about the best practice of predictive analytics insider SQL server management studio with the aim of creation predictive model, storing model, training model and doing prediction.
Speaker(s): Leila Etaati,
Abstract:
Come to this session to learn all about security and sharing in Power BI. Session starts with covering all types of sharing (basic sharing, work spaces, apps, publish to web, embedded), and their pros and cons. Session will then continue with Row Level Security topic. You will learn how to secure the content of Power BI based on roles. You will learn through live demos different types of implementing row level security, such as; Row level security through SSAS Live query, RLS in Power BI regardless of the data source, and dynamic row level security. Finally, in this session you will learn best practices and architecture advise for both Sharing and Security, and would be able to choose best security and sharing architecture for your Power BI solution requirement.
Speaker(s): Reza Rad,
Abstract:
Analyzing data from IoT devices, web-sites and user applications can be challenging if the insights needed are in real-time. Azure has developed solutions to meet those challenges. But there is more than one solution available for this problem. Which one do I choose and what are the decision points? Come to this session and learn about how do you choose the right architecture and solution for processing real-time data on Azure. In this session you will learn about different Real-Time Data Processing solutions on Azure and how to choose the right one for your business problem. 1. Azure Stream Analytics 2. Storm on Azure HDInsight 3. Spark on Azure HDInsight
Speaker(s): Anupama Natarajan,
Abstract:
GDPR (General Data Protection Regulation) is an EU legal initiative taking effect in May 2018, which protects data held anywhere by anyone on EU citizens. Why should you care about a new law from the other side of the planet? Because we live in an inescapably interconnected world. This legislation comes with painful penalties for those who don't comply. As a data professional, you will need to be aware of its implications for your organisation and the data which it holds. This is a high-level look at the requirements of and obligations arising from GDPR for application designers and data professionals. For specific guidance for your company, please seek specialised legal advice. I am not a lawyer. I am only qualified to utter my own opinions.
Speaker(s): Julie Woolner,
Abstract:
What percentage of people in New Zealand have a KiwiSaver account? Who is more likely to have one, and who is less? How is KiwiSaver participation affected by the fact that the money can be withdrawn to buy a home, especially given that the housing market is currently very difficult to enter into? These questions can be answered using SQL within Python to join summarise data from multiple sources, and subsequently performing some analysis and data visualisation in Python. KiwiSaver has been around since 2007, but how much do we really know about its impact? Analysing this further requires gathering data from various sources and shaping it so that it is ready to be combined using SQL. The classifications used by different data sources needs to be addressed before choosing appropriate SQL joins. Once this is done, we can calculate new summary statistics using SQL within Python. These then form the basis of the analysis and visualisation that can be performed in Python.
Speaker(s): Emma Vitz,
Abstract:
SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC). But when mission-critical databases go offline, bringing them back online could be a nerve-wracking experience. This session will look at understanding how the underlying WSFC platform works to help us maintain availability of our databases. This is for DBAs and systems administrators who are responsible for administering SQL Server FCIs and AGs but are not so comfortable with figuring out why the databases went offline and what they can do about it. We’ll walk thru the troubleshooting process that I follow to quickly identify and resolve SQL Server FCI and AG availability issues.
Speaker(s): Edwin M Sarmiento,
Abstract:
Imagine you develop for, or manage, a database system that powers a platform that must be operational 24/7/365. There are users worldwide every minute of the day. Need to update a schema to support an application change? Since the old versions of the app will still be using the database during update, you can’t do a breaking change until after the new app is rolled out everywhere. How do you do fit index maintenance in when there is constantly a heavy workload? What about backups? In this session we’re going to look at real world problems faced by many organisations and some ways to "work around them"
Speaker(s): Dave Dustin,
Abstract:
Over the last 10 years, Data Vault has become a common concept in the Data world. What is it? Why is it interesting? Where can it be used? How is it implemented in SQL Server? This presentation will give you a flavour of Data Vault. It will introduce: The concepts which make up Data Vault; The common tools used for building Data Vaults; How it works in SQL Server; The importance of Data Modelling and how it is structured; Interaction with modern Analytic Tools; Where to go for more information.
Speaker(s): Brian Bradley,
Abstract:
When Machine Learning Services in SQL Server 2017 was announced, I was really impressed with the potential of the idea: Bringing the algorithm right to the data! No more fiddly and expensive data pipelines! I wanted to investigate what this would look like in practice, to see if it was a good fit for Xero's use cases. In this session, I'll give a brief overview of the results of my investigation, demonstrate what using R for machine learning in SQL Server looks like, and give some opinions on how that fits with Xero's needs. And because we're all sick of the usual toy datasets, I'll be using data about dinosaurs!
Speaker(s): Simon Carryer,
Abstract:
Without doubt SQL Server 2017's release had surprised the industry with it's support for Linux. It's ability to run on Linux has garnered a lot of publicity and focus.But SQL Server 2017 includes a myriad of smaller new features and enhancements. This session is going to cover these "gems" and highlight how they can have a dramatic influence on how you develop, administer, optimize and troubleshoot SQL Server 2017.
Speaker(s): Victor Isakov,
Abstract:
Are you a whizz at SQL and curious about learning more about DAX? This session will be aimed to share some helpful tips and tricks for creating beautiful DAX when building Power BI reports or Tabular Cubes. Most people who learn DAX come from an Excel background, but this session will be tailored to those used to set based approaches such as SQL. We will create data from thin air and show how you can shape your data model using DAX.
Speaker(s): Phillip Seamark,
Abstract:
Is Machine Learning still a buzz word or can we easily put it to use to gain actionable insights from our data ? In this demo filled hands-on session we will cover how you can find hidden patterns in the data, find outliers, predict results using real world datasets. This should also get you accustomed to ML concepts like regression, classification, over-fitting, cross validation etc., The goal of the session is to make audience knowledgeable enough to be able to build, deploy and consume a machine learning models easily.
Speaker(s): Ram Katepally,
Abstract:
In my life as a Consultant, partitioning is one of the least used or even inefficiently used components of SQL Server that I have seen. Partitioning provides many potential benefits such as easier index maintenance, data loads and archiving using partition switching and improved query performance through partition elimination.. In this session we'll cover the basics of partitioning - from getting started with partition switching to partition elimination to make your queries go faster - with plenty of demos for you to take away.
Speaker(s): Martin Cairney,
Abstract:
What is DAX all about? Come to this session to learn about Calculated Column, Measure, and Calculated Tables and their differences. You will learn about the basics of language. You will learn about Filter functions, table functions, and iterators. You will learn about what is the difference between SUM and SUMX and many other scenarios.
Speaker(s): Reza Rad,
Abstract:
With SQL Server almost available on Linux, seasonal SQL Server DBAs, who spent most of their work on Windows, should hone their skills on Linux. The session will explore the essential skills needed to manage SQL server on Linux. It will also explore the most common tasks and procedures DBAs commit on Windows and their equivalents on Linux. Some troubleshooting skills on Linux will be explored, as well
Speaker(s): Mohamed Mawla,
Abstract:
This session will focusing on providing a SQL/BI developer with a walkthrough developing apps for Windows 10 IoT core running on a Raspberry Pi and using this to collect data and send data to Azure IoT hub. Some of the aspects that will be looked at is development environment , Windows 10 IoT core running on a Raspberry Pi , Azure IoT the challenges faced, from getting started to getting an app running that sends data to IoT hub and visualizing this data in Power BI.
Speaker(s): Arohan Naidoo,
Abstract:
Opportunity for the Women attending the Wellington SQLSaturday event to get to know each other and get connected. Come and say Hi and let us get to know each other.
Speaker(s): Anupama Natarajan,
Abstract:
Imposter Syndrome, career stops and starts, toxic workplaces - there are many reasons why women leave technology careers. This lightening talk aims to provide some thoughts on how to overcome the barriers and get the career you deserve.
Speaker(s): Michelle Burke,
Abstract:
With the introduction of Distributed Availability Groups in SQL Server 2016, it is becoming even more confusing to decide on the appropriate high availability and disaster recovery architecture to implement. In this session, we will cover how Distributed Availability Groups work, how you need to think about them in a possible deployment scenario and how you can combine them with the other high availability and disaster recovery features to meet your database recovery objectives and service level agreements.
Speaker(s): Edwin M Sarmiento,
Abstract:
Tips and tricks for using the Amazon Web Services' Database Migration Service to painlessly migrate a SQL Server database to cloud computing.
Speaker(s): Steven Ensslen,
Abstract:
Power BI Report Server is a solution that you deploy on your own premises for creating, publishing, and managing reports, then delivering them to the right users in different ways. This session will cover • Tips on getting your Power BI Report Server installed • Create a power BI report • Publish the report on the Power BI Report Server
Speaker(s): Indira Bandari,
Abstract:
Azure Analysis Services has been in the cloud for a few months and it rocks! This session will cover fundamentals of using Azure Analysis Services. I will go through the new capabilities of the service and compare it with the SQL Server Analysis Services on-premises. I will also explain why we should take it into account for our solutions and how to build models in the new service.
Speaker(s): David Alzamendi,
Abstract:
MDX Cubes are they still there in the Azure World? Come and learn
Speaker(s): Phillip Seamark,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Arohan is a Business Intelligence developer working at Entelect primarily on the Microsoft BI stack who has an interest in using Big Data and IoT to find insights into ways to improve daily life as well as focused research on using technology to enhance learning.
LinkedIn: https://uk.linkedin.com/sqlmaster
Contact: http://www.sqlserver-qa.net
My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast
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: SQL Saturday 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, SQL Saturday, 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.
With more than 35 years industry experience, Dave has worked with organisations and data systems of all sizes. He is currently Principal Engineer at Xero.
LinkedIn: https://www.linkedin.com/in/seamark
An accomplished database and business intelligence (BI) professional with an in-depth knowledge of the Microsoft BI stack along with extensive knowledge of data warehouse (DW) methodologies and enterprise data modelling. Expert knowledge in all facets of BI/DW including planning architecture, project management, dimensional modelling, performance tuning, ETL design, development and optimization, report and dashboard design as well as installation and administration. Author of multiple books on DAX. Over 27 years of commercial experience in delivering business applications across a broad range of technologies.
LinkedIn: http://ca.linkedin.com/in/edwinmsarmiento
Contact: http://www.EdwinMSarmiento.com
Edwin M Sarmiento is the Managing Director of 15C, a consulting and training company that specializes in designing, implementing and supporting SQL Server infrastructures. He is a 12-year former Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada (but he’s originally from the Philippines) specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. His background in Unix has taken him to the world of DevOps and Docker to containerize SQL Server. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.
LinkedIn: https://nz.linkedin.com/in/anupama-natarajan-516a107
Contact: http://www.anupamanatarajan.com
Anu Natarajan is a Data and AI Consultant with 15+ years of experience working in design and development of Data Warehouse, Business Intelligence, AI enabled applications, and SaaS integrated solutions. Anu is a Microsoft MVP Data Platform, Microsoft Certified Trainer and passionate in sharing knowledge. She loves solving complex business problems with innovative solutions using technologies. Anu also speaks at conferences including PASS Summit, SQL Saturdays, Data Platform Summit, Difinity, and she organizes local user group meetups.
LinkedIn: https://www.linkedin.com/in/brian-bradley-a9786b9/
Brian Bradley is a Business Intelligence Specialist who has solid experience in all things Data. Hailing from South Africa, Brian now calls New Zealand home. He has had a long and extensive career working for many top organisations such as Optimal BI, Xero and Fujitsu. On this journey he has paved his way as a Data Warehouse and Business Intelligence Solution Architect, specialising in Data Vault Architecture, Design, Build and Modelling. In his spare time he is a Blockchain enthusiast and keeps abreast of all the new and improving developments in the market, strengthening and building on business focus and the Microsoft BI Stack. He is a "Certifed Data Vault Modeller" as well as being certified to conduct the CDVDM Certifcation.
Contact: http://sqllensman.com/blog/
Patrick Flynn is a Senior Database Administrator with 10 years experience in large 24 x 7 enterprise environments. He is a certified master for SQL Server and a regular attendee of the PASS Summit. Has presented at SQLSaturday events in Sydney, Melbourne, Brisbane and Auckland, Edmonton and Calgary, Oslo and Cambridge
Emma has recently graduated from Victoria University with a degree in Statistics and Psychology. She is working as an Actuarial Analyst in for a consulting firm in Auckland, and also has a strong passion for data science and the new approaches it allows us to take to solve complex problems.
LinkedIn: https://nz.linkedin.com/in/anupama-natarajan-516a107
Contact: http://www.anupamanatarajan.com
Anu Natarajan is a Data and AI Consultant with 15+ years of experience working in design and development of Data Warehouse, Business Intelligence, AI enabled applications, and SaaS integrated solutions. Anu is a Microsoft MVP Data Platform, Microsoft Certified Trainer and passionate in sharing knowledge. She loves solving complex business problems with innovative solutions using technologies. Anu also speaks at conferences including PASS Summit, SQL Saturdays, Data Platform Summit, Difinity, and she organizes local user group meetups.
LinkedIn: http://www.linkedin.com/in/rkatepally
Contact: http://katepally.com/
Ram Katepally is an experienced Data Analytics Consultant who worked on multiple BI projects in varied set of business domains. He is MCSE in both Data Platform Data Analytics verticals, with a passion for analytics and visualizations. In his free time he is a avid player of chess.
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: http://www.linkedin.com/in/pinaldave
Contact: https://blog.sqlauthority.com
Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 30 Pluralsight courses and has written over 5000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.
LinkedIn: https://www.linkedin.com/in/martincatherall
Contact: http://martincatherall.com
Martin is a data consultant in Melbourne, Australia, a Microsoft Data Platform MVP, and PASS Regional Mentor for the Asia Pacific (APAC) region. Martin founded the Christchurch, New Zealand PASS Local Group and lead the group for a number of years before relocating to Melbourne. He has been using SQL Server in various roles since 2000. In addition to anything data related, he enjoys playing the guitar and having fun with his family.
LinkedIn: http://au.linkedin.com/pub/warwick-rudd/0/956/718
Contact: http://www.sqlmastersconsulting.com.au/Blog
Warwick Rudd is a Microsoft Certified Master – SQL Server 2008 and Principal Consultant at SQL Master Consulting. He is a frequent speaker at local SQL Server User Groups and SQLSaturday events in Australia. When not playing with the SQL stack, Warwick likes to get away to the cold and spend time snowboarding.
Contact: https://smrtgirl.nz
Michelle has been working in data and SQL Server for longer than she'd care to admit. One of her current favourite datasets is her Untappd check-ins (if you're going to invest so much in craft beer, you might as well mine the data, right?). She is passionate about data quality, data security, solving business problems, and building welcoming and diverse teams.
Julie is a Database Solutions Architect for Xero, building on many years' experience as a DBA on SQL Server and other (not to be mentioned here) vendors' offerings. Having seen much poor use of database technology in her time, her passion is to see it done right more often! Her current focus is on Data Governance and associated issues.
LinkedIn: https://sg.linkedin.com/in/dharmendra-keshari-a7043398
Contact: http://dharmendrakeshari.com/
Dharmendra Keshari has strong and in-depth experience in Database Management. Currently, working as Senior Database Administrator at Micron Technology in Singapore and handling one of the most critical databases which are being used by Singapore Public Hospitals, national specialty centres and polyclinics. Dharmendra is an avid, regular mentor on social media, helping several enthusiast in solving their problems related to Database management. he is co-leader and regular speaker at Singapore SQL Server Pass Chapter (User Group). He has done certification for “Microsoft SQL Server#174; 2008, Implementation” and “Maintenance amp; Administering Microsoft SQL Server 2012 Database”.
LinkedIn: https://www.linkedin.com/in/indira-bandari/
Contact: http://mytechlearning.blogspot.co.nz/
Indira is a Microsoft Data Platform MVP in New Zealand. She has a Masters degree in Statistics and is passionate about data, analytics and Artificial Intelligence. She is a BI and SQL Lead, an international speaker, mentor and part time trainer with over 15 years of experience in designing and developing data warehouses and analytical solutions. Volunteering and sharing her knowledge is her passion. In her pass time, she runs free game development classes, database concepts and data visualization classes for 9-16 year old kids. She is a Co-organiser for Data, Insights and Power BI User Group , Auckland AI Meetup Group and SQL Saturday Auckland. She speaks at various conferences, Virtual Webinars, PASS events etc
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: https://www.linkedin.com/in/steven-ensslen-01b87018/
Contact: http://stevenensslen.com
I'm a leader in business intelligence. I work to replace ignorance with knowledge by reducing uncertainty. I gather information that answers important questions and I help to define the questions that need answering. Along the way I use analytical software and databases. I automate scrupulously. And I build teams by teaching my peers to do these things too.
LinkedIn: https://nz.linkedin.com/in/hamishwatson8
Contact: http://www.sqlservercentral.com/blogs/the-hybrid-dbas-blog/
Hamish Watson is a Microsoft Data Platform MVP and VMware Expert with a passion for efficient database and application deployment using DevOps methodologies. He has 20+ years of IT experience in managing and deploying large scale databases on SQL Server technologies. He has been managing SQL Server since SQL Server 2000, and pragmatic approaches to delivering business value to clients is his career passion. Educating and helping others learn is a driver for Hamish. He is a Director-At-Large on the PASS Board, international speaker, and a repeat guest lecturer at a local university.
LinkedIn: http://ca.linkedin.com/in/edwinmsarmiento
Contact: http://www.EdwinMSarmiento.com
Edwin M Sarmiento is the Managing Director of 15C, a consulting and training company that specializes in designing, implementing and supporting SQL Server infrastructures. He is a 12-year former Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada (but he’s originally from the Philippines) specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. His background in Unix has taken him to the world of DevOps and Docker to containerize SQL Server. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.
LinkedIn: https://www.linkedin.com/in/seamark
An accomplished database and business intelligence (BI) professional with an in-depth knowledge of the Microsoft BI stack along with extensive knowledge of data warehouse (DW) methodologies and enterprise data modelling. Expert knowledge in all facets of BI/DW including planning architecture, project management, dimensional modelling, performance tuning, ETL design, development and optimization, report and dashboard design as well as installation and administration. Author of multiple books on DAX. Over 27 years of commercial experience in delivering business applications across a broad range of technologies.
Contact: http://www.sommarskog.se
Erland Sommarskog is an independent consultant based in Stockholm, working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.
LinkedIn: http://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 SQL Saturday events and User Groups round the world
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/dalzamendi
Contact: https://www.techtalkcorner.com
Delivering Business Intelligence and Data Analytics Solutions with On-Premises and Cloud technologies since 2011, David Alzamendi is a Microsoft Certified Solutions Expert and event speaker who solves problems with best practice procedures and the latest technology. David is passionate about the positive impact data can have on our lives, businesses, economy and the environment. He prides himself on using his creativity and optimism to solve what others thought impossible.
Trilingual Principal Consultant amp; Team Tech lead at a global Tech Consulting Mohamed had worked with large SQL server environments such as financials and gov of hundreds of SQL server instances and enormous amounts of data. His favorite subjects are Cloud Analytics, performance tuning, High Availability, especially Replication and Disaster recovery. Certified Google Cloud and Azure Data Engineer. When not working, Mohamed carries his cameras and takes a trip somewhere.
Simon Carryer is a Data Scientist at Xero, in Wellington. He works with a team of Data Engineers to "bring the magic" to small business accounting - helping the application learn about your accounting so you can spend less time entering data, and more time getting insights about your business. Simon's focus is on fostering a culture of data-driven decision making, and building data products that deliver real value to customers.
The following is a list of sponsors that helped fund the event.


Preparation time
30 mins to 1 hour
Cooking time
10 to 30 mins
Serves
Serves 4
Place the pears upright in a saucepan so they fit snugly. Cover with cold water then remove the pears, add the sugar and cinnamon sticks to the water, and bring to the boil, stirring.
Peel the pears, leaving the stalks and trimming the base so they sit flat, and return to the pan.
Poach for 15 to 20 minutes or until tender but not too soft, and then drain. Chop the cheeses, and combine in a small pan with the créme fraîche.
Heat gently, stirring with a wooden spoon, until melted. Remove from the heat. Add a little more créme fraîche if not runny enough to pour.
Pour the hot cheese sauce over the pears, coating them well. (Don't pour too much or you'll end up with too big a puddle at the bottom).
Serve immediately.


{% load staticfiles %} {% load static %}
WEB DEVELOPMENT FOR TODAY'S WORLD
Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live the blind texts.
Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live the blind texts.
Made with love by the fine folks at FreeHTML5.co
Even the all-powerful Pointing has no control about the blind texts it is an almost unorthographic life One day however a small line of blind text by the name of Lorem Ipsum decided to leave for the far World of Grammar. The Big Oxmox advised her not to do so, because there were thousands of bad Commas, wild Question Marks and devious Semikoli, but the Little Blind Text didn’t listen.
Even the all-powerful Pointing has no control about the blind texts it is an almost unorthographic life One day however a small line of blind text by the name of Lorem Ipsum decided to leave for the far World of Grammar.
Even the all-powerful Pointing has no control about the blind texts it is an almost unorthographic life One day however a small line of blind text by the name of Lorem Ipsum decided to leave for the far World of Grammar. The Big Oxmox advised her not to do so, because there were thousands of bad Commas, wild Question Marks and devious Semikoli, but the Little Blind Text didn’t listen.


--- title: "Main Content Headlines" type: typography scss: src/assets/stylesheets/_page.scss usage: "Headline hierarchy found in post content" ---


{% extends "admin/base.html" %} {% load markdown_deux_tags %} {% block admin_content %}
| Start Sending | {{email.start_sending}} |
|---|---|
| Stop Sending | {{email.stop_sending}} |
This email was sent {{email.sent_emails.first.sent_datetime}}.
{% endif %} {% endif %}| Sent | Recipient | Email Address | ||
|---|---|---|---|---|
| {{sent_email.sent_datetime}} | {% if sent_email.user %}{{sent_email.user}} | {{sent_email.user.email}} | {% else %}{{sent_email.email_address}} | {% endif %}


Archive
Blog Posts
-
18 Mar 2016 » milk+coffee
-
03 Mar 2016 » kopi vendor
-
02 Mar 2016 » 10 Incredible AeroPress Posters
-
01 Mar 2016 » Making Coffee is easy
-
01 Feb 2016 » Brew Guide (Aeropress)
18 Mar 2016 » milk+coffee
03 Mar 2016 » kopi vendor
02 Mar 2016 » 10 Incredible AeroPress Posters
01 Mar 2016 » Making Coffee is easy
01 Feb 2016 » Brew Guide (Aeropress)


Intro to Javascript
Our introductory course serves as an easy way in for people just starting out in their developer journey.
Intro to React
Our introductory course serves as an easy way in for people just starting out in their developer journey.
Intro to Flutter
Our introductory course serves as an easy way in for people just starting out in their developer journey.
Intro to Javascript
Our introductory course serves as an easy way in for people just starting out in their developer journey.
Intro to React
Our introductory course serves as an easy way in for people just starting out in their developer journey.
Intro to Flutter
Our introductory course serves as an easy way in for people just starting out in their developer journey.
Intro to Javascript
Our introductory course serves as an easy way in for people just starting out in their developer journey.
Intro to React
Our introductory course serves as an easy way in for people just starting out in their developer journey.
Intro to Flutter
Our introductory course serves as an easy way in for people just starting out in their developer journey.


Basic Algebra
Equations
Inequalities
Systems of Equations
Popular Problems
Basic Geometry
Basic Trigonometry
Pythagorean Theorem
Basic Physics
Mendel's Law
Basic Chemistry
Carbon Combustions
Contact
Legal
©2021 MathFlare.xyz - All rights reserved.


#nav(__SID__,__ACT__)
Miscellaneous Laboratory
Conversion Laboratory
Validation Laboratory
Database Laboratory
Ajax Laboratory
Exit
#kyojoLab/githubRibbon


Founded on the coast of Costa Rica, Tres Banañas has been a favorite resort of rich, spoiled Americans, and white, pasty Canadian snowbirds for generations!
We take hospitality and quality seriously. That is why our staff is committed to serving you any time, day or night. From drinks, food, and recreation, to fluffing your pillow and killing the roaches, we are always there for you to enhance your enjoyment.
Here are the things we offer:


class PageBindingsContainer extends JsonContainer
Purpose of this class is to hold on json values for data-devise bindings in the IoC container...
those will be spit out in the devise::scripts view...
Methods
|
__construct()
|
from JsonContainer | |
| void |
merge(string/array $data)
Merge the data into this class... |
from JsonContainer |
| string |
toJSON()
Outputs this data out as json string |
from JsonContainer |
| array |
getData()
Outputs this data as just regular data in case we want to tamper or examine it |
from JsonContainer |
Details
in JsonContainer at line 17
public
__construct()
in JsonContainer at line 29
public void
merge(string/array $data)
Merge the data into this class...
it allows us to have data-devise on multi-pages
in JsonContainer at line 45
public string
toJSON()
Outputs this data out as json string
in JsonContainer at line 56
public array
getData()
Outputs this data as just regular data in case we want to tamper or examine it


|
Good food, good friends, and good times. Here at The Main Squeeze we are inspired by a love for food and sharing it with those we love! Stop by our Minneapolis eatery and chill on the patio while enjoying our gorgeous view of the city skyline. |
|
Good food, good friends, and good times. Here at The Main Squeeze we are inspired by a love for food and sharing it with those we love! Stop by our Minneapolis eatery and chill on the patio while enjoying our gorgeous view of the city skyline. |


Code of Thrones
Toggle navigation
Code of Thrones
Home
Blog
Projects
{{ content }} {% include JB/analytics %}


pager.js
one having or covering a specified number or kind of pages
- Merriam-Webster
See the demo.
pager.js is a JavaScript library based on KnockoutJS and jQuery that provides the possibility of creating single page applications in a declarative fashion - nesting subpages inside subpages where each subpage can be developed standalone but still communicate between each other.
This makes it easier to design very large scale single page web sites.
This readme is for version 1.0.1.
Getting Started
See the demo.
Install
Download
Using npm
npm install pagerjs
Dependencies
You will usually use pager.js in combination with either jQuery hashchange or History.js.
pager.js is not depending on any CSS framework!
For developing pager.js you'll also need
Philosophy
Developing a huge single page application should be like developing multiple small pages. That is the only way you'll be able to scale up and out the development. In order to ease development in the large pager.js got
- views (pages) that can be loaded on-demand
- view-models that can be loaded on-demand
These MVVM-triads can be developed in isolation and later on connected.
FAQ
Can I use it together with...
pager.js is not depending on anything but jQuery and KnockoutJS. You can use it together with any CSS framework.
Can I use true URLs instead?
Yes. Use pager.min.history.js
if you want to use it together with History.js.
Release Notes
0.2
- Should be possible to circumvent the routing
- Should be possible to route to custom widgets (accordions)
- Should be possible to load content into iframes
- Should send wildcards to source
- Should do deep navigation with wildcards
- Should match wildcard IDs if no other ID can match exactly
- withOnShow should lazy bind a new view model to the page
- Should change binding context using with
- Should specify relative page paths using page-href
- Should cache lazy loaded content the number of seconds specified by sourceCache
- Should cache lazy loaded content when sourceCache: true
- Should lazy load an external content into a page if sourceOnShow is declared
- Should load external content into a page using source and trigger sourceLoaded event
- Should be possible to do deep navigation
- Should navigate to page using scoped IDs.
- Should display page with id start by default
0.4
- Should be possible to add guards
- Should be possible to send URI (fragment identifier) parameters to a page
- Should be possible to load view content using a custom method
- Should be possible to navigate into modals
- Should be possible to specify loaders on pages
- Should be possible to change the page title
- Should be possible to run custom JS on "navigate failed"
- Tab panel custom widget
- Should be possible to run custom JS on "navigate to"
0.6
- Should contain common effects
- HTML5 History Boilerplate
- page-hash and page-href5 bindings for hash or html5 history
- Access to Page in withOnShow handler
- Add BeforeNavigate Event handler to allow user to stop transition
- page-href should be possible to feed with a page-instance
- Should be possible to use hash bang #!/ instead of hash
- Scoped pure view observables using vars
- Wildcards should deep-load content if configured so
- Should be able to change initial page
- Demo as is does not work in IE7
0.7
- Remove underscorejs dependency
- pager.start id does not honor pager.Href.hash
- Sending wildcards to the viewmodel
- Should handle pages that does not react to URL changes
- Should handle pages that does not hide on URL changes
- Should handle exceptions in with/withOnShow
- Should handle exceptions on source/sourceOnShow
1.0.0
- A lot of cleanup and some breaking changes!
1.0.1
- Work with Knockout 2.3
- hash urls
- withOnShow is not updating route after source is loaded
- Show/Hide Events event don't occur
- toJSON refinements
- pagerjs AMD support replies on global $ variable
- withOnShow not updating on navigation
- Added bower.json for dependency installation when pulling in this module.
- Do not overwrite nameParam on view model if it is already defined
Roadmap
See Milestones.
How to Contribute
Fork this repo. Install all dependencies (node.js, grunt, phnatomjs). Run all tests
(grunt qunit
). Run jslint (grunt lint
). Make your changes. Run all tests and the linter again. Send a pull request.
Contributors
License
pager.js is under MIT license.
Copyright (c) 2013 Oscar Finnsson
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
 IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.


Memory Cache
This button lets you reload the in-memory cache, by entirely reloading it from the database
cache (but it does not rebuild that database cache). This is relatively fast.
Use it when you think that the memory cache has not been properly refreshed, after some events
triggered—which would indicate a minor Umbraco issue.
(note: triggers the reload on all servers in an LB environment).
Database Cache
This button lets you rebuild the database cache, ie the content of the cmsContentNu table.
Rebuilding can be expensive.
Use it when reloading is not enough, and you think that the database cache has not been
properly generated—which would indicate some critical Umbraco issue.
Internals
This button lets you trigger a NuCache snapshots collection (after running a fullCLR GC).
Unless you know what that means, you probably do not need to use it.


{extend name="public:index"} {block name="title"}Add customers{/block} {block name="index"}
Street address *
Postal or zip code *
City*
Country*
Province or state*
Phone #1 *
Phone #1 type*
Phone #2
Phone #2 type
ID Status
Document number *
Document type *
Date of birth *
Expiration date *
Place of issue *
IMPORTANT: Place of issue for passports MUST be entered
as documented on the passport. "Canada" is not adequate.
ID Image 1/2
ID Image 2/2
Risk Rating
Occupation or principal business *
i.e. high school teacher, airline pilot, construction worker
Purpose and intended nature of the business relationship *
i.e. supporting family in China
Expected transaction frequency *
i.e. monthly
Expected average transaction amount *
Does the customer have a 3rd party?
Is the customer PEP/HIO?
Does the customer exhibit suspicious behavior?
Additional notes
| Transaction type | Trans. Date | Trans. Number | IN | Method IN | OUT | Method OUT | CAD amount |
|---|---|---|---|---|---|---|---|
| {$row['type']} | {$row['times']} | {$row['number']} | {$row['received']} | {$row['typex']} | {$row['money']} | {$row['typez']} | {$row['moneys']} |
| Report Number | Report Date | Report Type | Transaction ID | Method IN | Report |
|---|---|---|---|---|---|
| {$row['number']} | {$row['time']} | {$row['type']} | {$row['name']} | {$row['descibe']} |
| Relationship with customer | First name | Last Name | Initials | MStreet address | City | Customer's Third Party Details |
|---|---|---|---|---|---|---|
| {$row['namea']} | {$row['nameb']} | {$row['namec']} | {$row['named']} | {$row['namee']} | {$row['namef']} | view |
| Assessment date | Risk rating | Narrative |
|---|---|---|
| {$ro['time']} | {$ro['name']} | {$ro['rating']} |


Pat's Salmon Cookie Extravaganza.
These aren't just cookies. They're a way of life.
This is big. It's a big deal.
Pat's Salmon Cookies.
We don't oversell. All over Seattle.
Pat's Salmon Cookie Extravaganza.
These aren't just cookies. They're a way of life.
This is big. It's a big deal.
Pat's Salmon Cookies.
We don't oversell. All over Seattle.


Arrays vs Hashes
When to use what?
May 16, 2015
Arrays and hashes are two data structures that allow you to collect, view, and manipulate pieces of data in meaningful ways. For example, say you want to organize your contacts by their names and phone numbers. Both arrays and hashes can help you achieve that, except one would be more suitable than the other in this case.
Let's store the made-up contact list below so that we can easily retrieve the phone number of any given contact.
| Jane Smith |<PHONE_NUMBER> |
| Lorri Ale |<PHONE_NUMBER> |
| Amber Joe |<PHONE_NUMBER> |
| Rocky Lee |<PHONE_NUMBER> |
| Joseph Young |<PHONE_NUMBER> |
| Alpha Dare |<PHONE_NUMBER> |
| Corey Tan |<PHONE_NUMBER> |
| Angie Jones |<PHONE_NUMBER> |
If we were to use arrays to store the data and later retrieve a specific phone number, we execute the following ruby code:
contact_list = []
contact_list.push(["Jane Smith", "234-533-5344"])
contact_list.push(["Lorri Ale", "340-343-4449"])
contact_list.push(["Amber Joe", "320-348-3822"])
contact_list.push(["Rocky Lee", "284-239-3888"])
contact_list.push(["Joseph Young", "394-939-9999"])
contact_list.push(["Alpha Dare", "390-982-3332"])
contact_list.push(["Corey Tan", "299-333-5555"])
contact_list.push(["Angie Jones", "302-494-8842"])
We first created an empty array called "contact_list" and then populated it with contacts and their phone numbers wrapped in smaller arrays. Once the code runs, we can retrieve, say, Amber Joe's number with the following ruby code:
contact_list.each {|name, phone|
puts phone if name == "Amber Joe"} # =><PHONE_NUMBER>
The code has to loop through "contact_list" one name at a time until it finds Amber Joe and prints her phone number. Imagine if you were a social butterfly and had a contact list of 10,000 names. ruby would potentially have to loop through 10,000 contacts before finding the contact you want. Another more efficient way to manage your contacts is through hashes.
First populate your hashtable with the following ruby code:
contact_list = {}
contact_list["Jane Smith"] = "234-533-5344"
contact_list["Lorri Ale"] = "340-343-4449"
contact_list["Amber Joe"] = "320-348-3822"
contact_list["Rocky Lee"] = "284-239-3888"
contact_list["Joseph Young"] = "394-939-9999"
contact_list["Alpha Dare"] = "390-982-3332"
contact_list["Corey Tan"] = "299-333-5555"
contact_list["Angie Jones"] = "302-494-8842"
We created a hash called "contact_list" and populated the hash with key-value pairs. In this case, the keys are the contacts' names, which are each paired with the value of their phone number. In order to, once again, retrieve Amber Joe's number, we execute the following ruby code:
contact_list["Amber Joe"] # =><PHONE_NUMBER>
Notice that in this case, we are not cycling through the hash to identify a match to the name "Amber Joe". Instead, the hash has indexed each phone number by a contact's name. Thereby allowing you to simply provide a name (i.e., the key or index value) and the hash point to the corresponding phone number (i.e., the value). This concept is called key-value pairs.
Overall hashes are more efficient and effective for use cases where objects need to be associated with proprieties or values, like terms and definitions. Arrays are helpful when being able to iterate through data is important and when storing different types of data in a data set.
Latest Tweet
tweet tweet
Social
FB Twitter GitHub LinkedIn Google+


Logo
Dashboard
Generate Bill
Products
Dashboard
×
Generate Bill
Products
☰ open
Dashboard
Create a progress bar
Total Balance
Amount
No of Product Sold
Total Number of Product Sold
Last Product and transaction
Last Product Details


We offer pay-what-you-wish yoga classes online via Zoom. All classes are 60 minutes and geared towards all-levels. Each class will include asana (standing, seated, and balancing postures), as well as pranayama (breathwork) and rest.
Wednesdays at 10 AM CST / 8 AM AZ time with Abby
Click the link below to sign-up.
Wednesday, August 18
Wednesday, September 1
Wednesday, September 8
Wednesday, September 15
Saturdays at 11 AM CST / 9 AM AZ time with Chris
Click the link below to sign-up.
Saturday, August 14
Saturday, August 28
Saturday, September 11
See all scheduled classes here.
Private yoga sessions are available with Abby, online via Zoom at an agreed upon date and time.
A free 15-minute consultation is included prior to starting. We can discuss your intentions so I may tailor our sessions to meet your goals. I will also be able to answer any questions that you may have.
New Client Special: $300 for 6 60-minute sessions
E-mail Abby<EMAIL_ADDRESS>for more information or to get started.
Abby Wolff
After several brief encounters with yoga starting at a young age, Abby returned to the practice and has not stopped since January 2019. She began attending classes 4-5 times per week and quickly realized there was an entire system of yoga of which she knew nothing about.
In 2020 Abby decided to deepen her practice by completing a 200 hour teacher training with Gopi Om and is incredibly grateful to have learned about the roots of this traditional practice. Gopi Om considers herself a disciple of Sri Dharma Mittra, so although Abby has not practiced with him herself, she is inspired by his teachings.
Abby has worked in the field of early childhood education for over 10 years and has found she enjoys teaching people from all walks of life. She hopes her classes will inspire you to deepen your understanding of yoga.
Chris Wolff
Chris is a computer programmer and skateboarder and hopes to offer classes for those who are new to yoga. He has found yoga to be a compliment to not just his skateboarding practice, but to his life as well. He strives to live a life devoted to non-violence.
You can find us on IG @whywolffs
Subscribe to our newsletter above for class reminders and schedule updates.
You can e-mail any questions, comments, or concerns to:
<EMAIL_ADDRESS>- Abby
<EMAIL_ADDRESS>-Chris


I have worked with Wai on a number of projects, including a redesign of a web app, SEO consultancy and video integration for the web. He is intuitive, efficient and a pleasure to work with. He has the ability to come up with innovative problem-solving solutions which contribute greatly to the successful outcome of our projects. I would not hesitate in recommending his services.
Michael Pullman


--- layout: post title: Some nice sites tags: [] status: publish type: post published: true meta: {} ---
Just a couple of sites I stumbled across today and would like to make a note of:


-- Macbeth(1.7.46)
The society that Macbeth finds himself in is a very potent component in the reasonings behind his killing Duncan. Right from the beginning, three witches who have a questionable amount of power tell Macbeth that he will be King. By itself, this does nothing: It takes Macbeth's ponderings, with some help from Lady Macbeth, before he goes and kills Duncan in order to fulfil the witch's suggestions.
 One of the primary ways she goes about this is putting a question mark his manhood, on the basis that a man takes action, on the battlefield just like when he has ambitions to fulfil. Macbeth's society, Lady Macbeth primarily, still never directly defines manhood, however. Macbeth interprets what he hears into his own definition of manhood. It is Macbeth's own interpretation of manhood, based on what society is providing him, interacting with what he wants (he may be indecisive, but he does have wants) that results in his conclusion that killing Duncan is the right decision.
So while society is a very potent component in Macbeth's reasons for taking the actions that he does, it is Macbeth's interpretation of that society that causes him to kill Duncan. He is also, however, able to interpret society's definition of morals, as we clearly see when he is lamenting over how Neptunes Oceans can't wash the blood from his hands. It was in the end then his decision to put his interpretation of manhood and the Kingship that comes with it above his interpretation of morals. But with the situation he found himself in at the time, how much blame should fall solely on his shoulders?


{% extends 'mpa/common/base.html' %} {% block content %}
Default Primary Success Info Warning Danger Purple Inverse Pink
15 0 21 3 35 32 51 77 9
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Cras mattis consectetur purus sit amet fermentum.
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Cras mattis consectetur purus sit amet fermentum.
Consider speaking me prospect whatever if. Ten nearer rather hunted six parish indeed number. Allowance repulsive sex may contained can set suspected abilities cordially. Do part am he high rest that. So fruit to ready it being views match.
Started his hearted any civilly. So me by marianne admitted speaking. Men bred fine call ask. Cease one miles truth day above seven. Suspicion sportsmen provision suffering mrs saw engrossed something. Snug soon he on plan in be dine some.
Talking chamber as shewing an it minutes. Trees fully of blind do. Exquisite favourite at do extensive listening. Improve up musical welcome he. Gay attended vicinity prepared now diverted. Esteems it ye sending reached as. Longer lively her design settle tastes advice mrs off who.


To grow along with the organization and become a professional of excellent repute by effectively contributing towards the goal of the organization.
GPA: 2.90
GPA: 4.60
GPA: 5.00
As a part of the organizer's team my task was to spread the information about the program, the purpose of the event, monitoring the whole program, which was held on United International University in 2016.
Every year, British American Tobacco company arregnges 3 or 4 functions for their core employees to motivate them. I have worked with them twice as a volunteer. I would like to say the work was for an event organizer rather than volunteer.
Participated "Digital World Bangladesh" as a volunteer. The task was to direct the students to help them to arregnge their stalls. And also inform the guests about the sequence of the program slots.
I enjoy most of my time being outdoors. I love travelling and exploring world.Helping people makes me happy.


Please email me with suggestions and skin submissions. You can reach me at 22jamessemrad@csdecatur.net


critical, major, minor, warning
open (default), ack or closed
Comma-separated list of events
Comma-separated list of services
Regex match is enabled
Comma-separated list of tags
{{ statusText }}
{{ response | json }}