Sound is a disturbance in the pressure of the air.
When you vibrate a tuning fork or a string, you create regions of compression and of rarefaction. These are the crests and troughs of the wave. Those compressions and rarefactions then travel away from the tuning fork through the air in all directions. If they hit your ear drum... it vibrates, and you hear the sound!
If you vibrate the guitar string twice as slow (reduce the frequency by two) then the distance between the compressed regions will be twice as big (you would double
Just as for any waves, we have:
What is the speed of a sound wave? When you see lightning outside, it often takes a while to hear the thunder. We saw this already in week 1. The speed of sound at normal temperature and pressure is
1 mile per 5 seconds = 1,000 feet per second = 330 meters per second.
This is the same speed as the average speed of molecules in air.


Happy Birthday Dia Mirza: Alia Bhatt, Sonali Bendre and others shower wishes for the actress on her special day
by TIMESOFINDIA.COMDia Mirza might be away from the silver screen, but the actress often makes headlines for raising her voice against environment and wildlife issues. Not just that, the actress is an avid social media user and keeps her fans all updated about her routine. The actress turned a year older today and social media is buzzing with birthday wishes and rare and unseen pictures of the actress shared by her fan clubs. B-town celebs took to their social media handle to wish the birthday girl with some lovely messages and pictures.
Read Also: When Dia Mirza’s personal diary got her in trouble
Sonali Bendre shared a gorgeous photo of the actress and wrote, ''Lots of love to the birthday girl @deespeak! Have an amazing one #HappyBirthday''. While Randeep Hooda shared a stunning candid photo and wrote, ''God bless you, you crusader you @deespeak .. keep up the good fight .. much love #DiaMirza''. Alia Bhatt, Divya Dutta and Sophir Choudry too wishes the actress on Twitter.
Check out their tweets here:
The actress recently attended the UN Climate Summit 2019 in the capacity of a Sustainable Development Goals (SDG) advocate. She is India’s Goodwill Ambassador to the United Nations. The actress is a strong advocate about climate change, and how societies across the globe need to address this situation on an urgent basis.
Meanwhile, on the work front, the actress was last seen in a web series alongside 'URI' fame actor Mohit Raina.
Facebook Twitter Pintrest


This is my header!
Here are my top three favourite websites:
youtube.com
imdb.com
realclearpolitics.com
Hello there, awesome person!


>>
<<
Usr
Pri
JfC
LJ
Phr
Dic
Voc
!:
Help
Primer
When they aren't
You have seen that =. and =: in the ijx window are the same. And you have seen that inside a verb they are different. It is important to realize there is also a difference in scripts.
When you run a script, the load sentence is executed in the ijx window and the verb load executes the sentences in the script. So, the sentences in the script are executed in the load verb. This means that names defined with =. are defined as locals of the verb load. If you want to define a global in the script you must use =: . This is why the lines which define globals such as centigrade and fahrenheit in your script cf.ijs must use =: . If you used =. , they would be local to load and would disappear as soon as load finished execution.
Always think about whether a definition is global or local and use =: and =. accordingly.
>>
<<
Usr
Pri
JfC
LJ
Phr
Dic
Voc
!:
Help
Primer


dash.forms.image_filetype_help_html
By default we fallback to using Gravatar if you have one. If you would like to disable the Gravatar fallback, you can toggle this on. What is Gravatar?


---
title: "Sports"
permalink: /resources/activities/sports/
layout: single
---
Disclaimer This compilation of public data is provided for the convenience of community members. It is important to note that the inclusion of organizations on this page does not imply any affiliation with OCC.
{% for sport in site.activities_sports %}
{{ sport.title }}
{{ sport.location }}
{% endfor %}


Welcome to UESTC Guitar Association
About us
Members
Photos
Join us
Name
Time
Position
Zhang Jianhua
2014
Chairman
Zhan Xu
2014
Chairman
Wang Yuan
2014
Boss
Xi Xuanming
2015
Member
Hu Jian
2014
Member
Chen Li
2014
Member
Yu Chunhao
2015
Member


{{title1}}
{{city}}
{{street}}
{{zipCode}}
{{title2}}
{{title3}}
{{phoneNumber}}
{{email}}
{{skype}}
{{whatsApp}}
{{tech}}


|
|
static double | ExecuteLinear (double value) |
| |
|
static double | ExecuteDerivativeLinear (double value) |
| |
|
static double | ExecuteSigmoid (double value) |
| |
|
static double | ExecuteDerivativeSigmoid (double value) |
| |
|
static double | ExecuteSigmoidSymmetric (double value) |
| |
|
static double | ExecuteDerivativeSigmoidSymmetric (double value) |
| |
|
static double | ExecuteGaussian (double value) |
| |
|
static double | ExecuteDerivativeGaussian (double value, double field) |
| |
|
static double | ExecuteGaussianSymmetric (double value) |
| |
|
static double | ExecuteDerivativeGaussianSymmetric (double value, double field) |
| |
|
static double | ExecuteSine (double value) |
| |
|
static double | ExecuteDerivativeSine (double value) |
| |
|
static double | ExecuteSineSymmetric (double value) |
| |
|
static double | ExecuteDerivativeSineSymmetric (double value) |
| |
|
static double | ExecuteCosine (double value) |
| |
|
static double | ExecuteDerivativeCosine (double value) |
| |
|
static double | ExecuteCosineSymmetric (double value) |
| |
|
static double | ExecuteDerivativeCosineSymmetric (double value) |
| |
|
static double | ExecuteElliot (double value) |
| |
|
static double | ExecuteDerivativeElliot (double field) |
| |
|
static double | ExecuteElliotSymmetric (double value) |
| |
|
static double | ExecuteDerivativeElliotSymmetric (double field) |
| |
|
static double | ExecuteThreshold (double value) |
| |
|
static double | ExecuteThresholdSymmetric (double value) |
| |
The documentation for this class was generated from the following files:


|
Ext.NET
5.3.0
.NET Component Framework for Enterprise Level Apps
|
Public Member Functions | |
| Builder (TRowSelectionModel component) | |
| virtual TBuilder | Listeners (Action< RowSelectionModelListeners > action) |
| Client-side JavaScript Event Handlers More... | |
| virtual TBuilder | DirectEvents (Action< RowSelectionModelDirectEvents > action) |
| Server-side Ajax Event Handlers More... | |
| virtual TBuilder | DeselectOnContainerClick (bool? deselectOnContainerClick) |
| Set to true to deselect current selection when the container body is clicked. More... | |
| virtual TBuilder | SelectedRows (Action< SelectedRowCollection > action) |
| virtual TBuilder | SelectedRow (Action< SelectedRow > action) |
| virtual TBuilder | SelectedIndex (int selectedIndex) |
| virtual TBuilder | SelectedRecordID (string selectedRecordID) |
| virtual TBuilder | HiddenName (string hiddenName) |
| HiddenField name which submits selected rows More... | |
| Builder () | |
| Builder (RowSelectionModel component) | |
| Builder (RowSelectionModel.Config config) | |
| Public Member Functions inherited from Ext.Net.AbstractSelectionModel.Builder< TRowSelectionModel, TBuilder > | |
| Builder (TAbstractSelectionModel component) | |
| virtual TBuilder | AllowDeselect (bool allowDeselect) |
| Allow users to deselect a record in a DataView, List or Grid. Only applicable when the SelectionModel's mode is 'SINGLE'. Defaults to false. More... | |
| virtual TBuilder | IgnoreRightMouseSelection (bool ignoreRightMouseSelection) |
| True to ignore selections that are made when using the right mouse button if there are records that are already selected. If no records are selected, selection will continue as normal. Defaults to: false. More... | |
| virtual TBuilder | PruneRemoved (bool pruneRemoved) |
| Prune records when they are removed from the store from the selection. More... | |
| virtual TBuilder | ToggleOnClick (bool toggleOnClick) |
| true to toggle the selection state of an item when clicked. Only applicable when the mode is 'SINGLE'. Only applicable when the allowDeselect is 'true'. More... | |
| virtual TBuilder | Mode (SelectionMode mode) |
| Modes of selection. Valid values are SINGLE, SIMPLE, and MULTI. Defaults to 'SINGLE' More... | |
Static Public Member Functions | |
| static implicit | operator Builder (RowSelectionModel component) |
| TRowSelectionModel | : | RowSelectionModel | |
| TBuilder | : | Builder | |
| TBuilder | : | TRowSelectionModel | |
| TBuilder | : | TBuilder |
|
inline |
|
inline |
|
inline |
|
inline |
|
inlinevirtual |
Set to true to deselect current selection when the container body is clicked.
|
inlinevirtual |
Server-side Ajax Event Handlers
| action | The action delegate |
|
inlinevirtual |
HiddenField name which submits selected rows
|
inlinevirtual |
Client-side JavaScript Event Handlers
| action | The action delegate |
|
inlinestatic |
|
inlinevirtual |
|
inlinevirtual |
|
inlinevirtual |
| action | The action delegate |
|
inlinevirtual |
| action | The action delegate |


A cryptocurrency is a medium of exchange based on cryptography to secure the transactions and to control the creation of additional coins.
A cryptocurrency is mined using a hashing function. The two most popular hashing functions are SHA-256 and Script, but several others are used.
As Bitcoin grew in popularity, ASIC SHA-256 machines were built which made GPU mining obsolete.


parentheses ( ) - Used to contain a list of parameters passed to functions. Used for grouping expressions to enforce the Order of Operations. Used for containing expressions e.g. in an ‘if’ statement. Used to call functions.
brackets [ ] - Used for accessing the properties of an Object and the elements of an Array
braces { } - Used to declare Objects. Also used to enclose blocks of code in function definitions, conditional blocks:
if (10 > 5) {
var outcome = "if block";
}
single quotes '' or double quotes " " - Used for writing strings. Neither style has special semantics over the other. However can be used strategically by the programmer the help understanding reading of the code. The one thing that should be noted is that JSON (JavaScript Object Notation) only uses double quotes:
var myObject = {
"element" : "value"
};


Why should you cry?
Crying improves your mood and helps relieve stress. Tears cleanse your eyes and keep your nose moist and bacteria-free. But gender and cultural norms keep men from reaping the benefits of crying.
Men cry only 1.3 times per month while women cry 5.3 times per month. It's a systemic problem.
You can change that today.


UserGen is a simple JavaScript username generator. Press the button below to generate usernames.
Your randomly generated username:
UserGen grabs one random word from usernames.txt by jeanphorn on GitHub using the Math.random method and generates one random number, again using the Math.random method.
You can find the source code on GitHub.


|
1
|
POSTAL SERVICES BILL [LORDS]: Second Reading.
|
|
|
2
|
POSTAL SERVICES BILL [LORDS] [MONEY]: Queen’s Recommendation signified.
|
|
|
|
| |
That, for the purposes of any Act resulting from the Postal Services Bill [Lords] it is expedient to authorise the payment out of money provided by Parliament of—
|
|
|
(1)
|
expenditure in connection with the provision of benefits under the Royal Mail Pension Plan,
|
|
|
(2)
|
other expenditure incurred by a Minister of the Crown by virtue of the Act,
|
|
|
(3)
|
expenditure incurred by the Postal Services Commission by virtue of the Act, and
|
|
|
(4)
|
any increase attributable to the Act in the sums payable under any other Act out of money so provided.
|
|
|
3
|
POSTAL SERVICES BILL [LORDS] [WAYS AND MEANS]:
|
|
|
|
| |
That, for the purposes of any Act resulting from the Postal Services Bill [Lords] it is expedient to authorise—
|
|
|
(1)
|
the imposition of charges to corporation tax, capital gains tax and stamp duty land tax,
|
|
|
(2)
|
the making of provision in connection with the restructuring of the Royal Mail Pension Plan,
|
|
|
(3)
|
the imposition of charges on providers of postal services and users of such services by the Office of Communications, and
|
|
|
(4)
|
the payment of sums into the Consolidated Fund.
|
|
|
4
|
ENVIRONMENTAL PROTECTION
|
|
|
|
| |
That the draft Groundwater (England and Wales) Regulations 2009, which were laid before this House on 16 June, be approved.
|
|
|
5
|
INTERNATIONAL DEVELOPMENT
|
|
|
|
| |
That the draft Caribbean Development Bank (Seventh Replenishment of the Unified Special Development Fund) Order 2009, which
was laid before this House on 17 June, be approved.
|
|
|
|
|
|
| |
That the draft Statistics and Registration Service Act 2007 (Disclosure of Higher Education Student Information) Regulations
2009, which were laid before this House on 17 June, be approved.
|
|
|
|
|
|
| |
That the draft Double Taxation Relief and International Tax Enforcement (Guernsey) Order 2009, which was laid before this
House on 17 June, be approved.
|
|
|
|
|
|
| |
That the draft Double Taxation Relief and International Tax Enforcement (Jersey) Order 2009, which was laid before this House
on 17 June, be approved.
|
|
|
|
|
|
| |
That the draft Double Taxation Relief and International Tax Enforcement (Virgin Islands) Order 2009, which was laid before
this House on 17 June, be approved.
|
|
|
10
|
LOCAL DEMOCRACY, ECONOMIC DEVELOPMENT AND CONSTRUCTION BILL [LORDS]: As amended in the Public Bill Committee, to be considered.
|
|
|
For Amendments see pages 987, 989, 991, 1055–56, 1147, 1193–95 , 1205–06 and 1207–08 of Supplement to Votes.
|
|
11
|
TRADE UNION AND LABOUR RELATIONS
|
|
|
|
| |
That the draft ACAS Code of Practice: Time Off for Trade Union Duties and Activities, which was laid before this House on
24 June, be approved.
|
|
|
|
|
|
| |
That the draft National Assembly for Wales (Legislative Competence) (Social Welfare) Order 2009, which was laid before this
House on 25 June, be approved.
|
|
|
|
|
|
| |
That the draft National Assembly for Wales (Legislative Competence) (Exceptions to Matters) Order 2009, which was laid before
this House on 25 June, be approved.
|
|
|
|
|
|
| |
That the draft Saving Gateway Accounts (No. 2) Regulations 2009, which were laid before this House on 7 July, be approved.
|
|
|
15
|
EQUALITY BILL: As amended in the Public Bill Committee, to be considered.
|
|
|
For Amendments, see pages 1113–29, 1161–62, 1191–92 and 1201 of Supplement to Votes.
|
|
|
|
|
| |
That the draft Crime and Disorder Act 1998 (Youth Conditional Cautions: Code of Practice) Order 2009, which was laid before
this House on 8 July, be approved.
|
|
|
|
|
|
| |
That the draft Criminal Justice Act 2003 (Conditional Cautions: Code of Practice) Order 2009, which was laid before this House
on 8 July, be approved.
|
|
|
|
|
|
| |
That the draft Charities Act 2006 (Changes in Exempt Charities) Order 2009, which was laid before this House on 8 July, be
approved.
|
|
|
|
|
|
| |
That the draft Charities Act 2006 (Principal Regulators of Exempt Charities) Regulations 2009, which were laid before this
House on 8 July, be approved.
|
|
|
|
|
|
| |
That the draft District Electoral Areas Commissioner (Northern Ireland) (Amendment) Order 2009, which was laid before this
House on 8 July, be approved.
|
|
|
|
|
|
| |
That the draft Electoral Law Act (Northern Ireland) 1962 (Amendment) Order 2009, which was laid before this House on 8 July,
be approved.
|
|
|
22
|
MARINE AND COASTAL ACCESS BILL [LORDS]: As amended in the Public Bill Committee, to be considered. [Queen’s and Prince of Wales’s consent to be signified on Third Reading].
|
|
|
|
|
|
| |
That the draft Welsh Ministers (Transfer of Functions) (No. 2) Order 2009, which was laid before this House on 20 July, be
approved.
|
|
|
The Instrument has not yet been considered by the Joint Committee on Statutory Instruments.
|
|
|
|
|
| |
That the draft Government of Wales Act 2006 (Consequential Modifications, Transitional Provisions and Savings) Order 2009,
which was laid before this House on 20 July, be approved.
|
|
|
The Instrument has not yet been considered by the Joint Committee on Statutory Instruments.
|
|
25
|
CONSTITUTIONAL REFORM AND GOVERNANCE BILL: Second Reading.
|
|
|
26
|
PERPETUITIES AND ACCUMULATIONS BILL [LORDS]: Second Reading.
|
|
|
|
|
|
| |
That the draft Legislative and Regulatory Reform (Regulatory Functions) (Amendment) Order 2009, which was laid before this
House on 20 July, be approved.
|
|
|
The Instrument has not yet been considered by the Joint Committee on Statutory Instruments.
|
|
|
|
|
| |
That the draft Private Security Industry Act 2001 (Amendment) (Northern Ireland) Order 2009, which was laid before this House
on 21 July, be approved.
|
|
|
The Instrument has not yet been considered by the Joint Committee on Statutory Instruments.
|
|
29
|
SAVING GATEWAY ACCOUNTS
|
|
|
|
| |
That the draft Saving Gateway Accounts Regulations 2009, which were laid before this House on 21 July, be approved.
|
|
|
The Instrument has not yet been considered by the Joint Committee on Statutory Instruments.
|
|
|
|
|
| |
That the Value Added Tax (Buildings and Land) Order 2009 (S.I., 2009, No. 1966), dated 21 July 2009, which was laid before
this House on 21 July, be approved.
|
|
|
The Instrument has not yet been considered by the Joint Committee on Statutory Instruments.
|
|
31
|
ROYAL COMMISSION ON SEPARATION OF POWERS
|
|
|
|
|
|
| |
That this House requests the Prime Minister to recommend the establishment of a Royal Commission to examine ways of introducing
an effective separation of powers to the constitutional arrangements of the United Kingdom.
|
|


FCC Full Stack Voting App
generic poll name
I'd like to vote for...
Option 1
Option 2
Option 3
Submit
Share on Twitter
Data Vizualization


Event Location:
103 Princess Street
Manchester, , United Kingdom
Abstract:
Still using Reporting Services? Yeah me too! Does this scenario sound familiar? You already have a large SSRS environment but the users still want more reports.  You launch it and explain to the business that you are deprecating the old reports. "WAIT! We still need that for Jill in HR to do her end-of-month", or "We might still need that" - these types of comments are what leads to having a load of reports that are not being used. Wouldn't it be great if you could see who is viewing a report, in what format and how often, all inside your current SSRS environment? With this data wouldn't it then be even better if we could automate a process to email the owner of that report to say "HA! I told you no one looked at this report!". In this session we will look at how we can do all of this and more by mining the SSRS DB.
Speaker(s): Terry McCann,
Abstract:
Why Upgrade? Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2008. In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server 2000, 2005, 2008 R2 SQL Server 2012 (with a good overview on 2014 too) by using best practices and available resources. A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQLSaturday SQLbits UK. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution.
Speaker(s): Satya Jayanty,
Abstract:
Analysis Services OLAP cubes provide an incredibly powerful platform for the analysis and reporting of complex data. Unfortunately we often find that our source data is not in the right structure to make the best use of the cube’s power. This limits the cube’s functionality, compromises performance and complicates the reports. In this session we’ll look at a number of different data scenarios that we encounter and explore ways of remodelling the data within the data warehouse to optimize it for cubes and MDX. We’ll see how adding functionality into the ETL layer and data warehouse can have a dramatic effect on the functionality and simplicity of the cube.
Speaker(s): Alex Whittles,
Abstract:
As an ETL developer using SQL Server Integration Services have you ever wondered how to: 1. Import all .csv files from a folder 2. Replace dynamic SQL using variables in SSIS 3. How to configure the data flow buffer 4. Create custom logging solutions 5. Use a script component as a data flow transformation This session focuses on advanced techniques that are used in SSIS and is meant for the experienced SSIS developer. We will focus on tasks and techniques that are native to SSIS 2005-2014 as well as some of the more advanced and vague properties. Attendees must have a good working knowledge of SSIS as well as familiarity with VB.NET or C# as some time will be taken looking at extending SSIS with script tasks and components. Upon completion of this workshop attendees will be able to: 1. Import/export multiple sources/destinations 2. Use an execute SQL task with variables to replace dynamic SQL within a package 3. Dynamically handle errors within any part of a package 4.
Speaker(s): David Dye,
Abstract:
Continuous integration (CI) is a development practice that has become widely adopted for the application layer because it allows teams to detect problems quickly and locate errors more easily. By regularly integrating code into a shared repository and automatically verifying it you'll build confidence in your code. But database CI continues to be a painful, manual process in many projects. There are many reasons for this, most obviously the issue of data persistence, but there are ways to handle these issues. In this session, I will show you: -How easy it is to get your SQL Server database changes in source control -How to set up an automated build process for your databases -How this process helps you spot and fix errors quicker -How to produce an artifact you can use for reliable, repeatable deployments in the future
Speaker(s): Alex Yates,
Abstract:
Machine learning is the science of making computers act without being unambiguously programmed. Machine learning is something that we use every day when we search and shop on the web and talk to our devices. Microsoft AzureML is a fully-managed cloud service that enables data aware developers to efficiently embed predictive analytics into their applications, without a PhD in statistics helping organizations use massive data sets and bring all the benefits of the cloud to machine learning. So join Andrew for a practical insight into the fascinating world of Machine Learning, where you can be significantly different but never certain, deviation is normal, and you are amongst friends if you found the above quote funny.
Speaker(s): Andrew Fryer,
Abstract:
Give your queries a multidimensional makeover. In this session we'll look at the structure and basics of MDX, the Multi Dimensional query eXpression language for querying Analysis Services OLAP cubes. MDX can seem a very daunting language, but when it's broken down into the basics it's easier than you think. We'll start at the beginning, so you need no previous MDX experience, but it does help to have some experience with cubes. If you already write MDX but struggle with the syntax, then you need to attend this session! We'll walk through the difference between a member, measure, tuple, set and dimension. Well describe how to decipher a [] from a {} or a (), and we'll look at some of the awesome power that MDX can provide to our reporting.
Speaker(s): Alex Whittles,
Abstract:
Come round to talk about Application Lifecycle Management (ALM) and deployment/delivery of Business Intelligence (BI) Applications! You will learn how Team Foundation Server (TFS) and Release Manager or Octopus Deploy will help you in in that feat. I will share my view of end-to-end architecture of MS BI ALM and practical tips on how to make it happen with TFS toolkit and Octopus Deploy, with specific examples for every MS BI project type. The presentation will also compare features of Release Manager and Octopus Deploy for your deployment needs will show a demo of continuous deployment for a typical BI project using Octopus Deploy. The material does not assume prior knowledge of TFS administration, but some experience using Visual Studio database projects and general TFS terminology will be helpful.
Speaker(s): Dmytro Andriychenko,
Abstract:
The Microsoft Data Platform used to be Microsoft SQL Server, now we have a variety of different options spanning on-premises and cloud. With this increasing array of options the role of the DBA is changing, understanding how these technologies compliment each other and what they are will become more important for the DBA as the roles change. In this session we will look at Microsoft SQL Server, Azure SQL DB, DocumentDB and Azure Table Storage, all of which can be used to provide a highly effective data platform on which to build applications. I will help you understand what each of the offerings is, how it differs from the others and demonstrate some examples of when you might want to use one over another.
Speaker(s): John Martin,
Abstract:
Register @ http://manchesterpass.ddns.net/Speaker5.html Assuming no prior knowledge of In-memory technologies we first introduce concepts, what do we mean by in-memory, what features exist in SQL Server 2012 and SQL Server 2014. We then drill into each feature giving you a working knowledge that can be applied into your own environments, the day will be example led. Introduction to in-memory technologies and features baked into SQL Server 2012 and 2014 OLAP - Columnstore •Nonclustered •Clustered •Design considerations, how it works and troubleshooting/monitoring OLTP - In-memory OLAP •Tables •Natively compiled stored procedures •Design considerations, how it works and troubleshooting/monitoring
Speaker(s): Tony Rogerson,
Abstract:
Microsoft recently launched a new service into Azure; SQL Data Warehouse. SQL Data Warehouse is a scale out, distributed database that can scale its compute resources on demand. Come to this session and learn all about it from the co-author of the official documentationlt;https://azure.microsoft.com/en-gb/documentation/articles/sql-data-warehouse-overview-develop/gt;!
Speaker(s): James Rowland-Jones,
Abstract:
Since the acceptance of enterprise flash technology as a viable alternative to legacy hard disk drives; there has emerged a diverse range of solid state products. Consumers are faced with daunting task of needing to consider (amongst others) cost, capacity, endurance, interfaces; and the reality that not all flash is the same. Principal Solutions Architect Phil Clarke, will discuss these challenges, enabling you to make an informed choice for your SQL infrastructure
Speaker(s): Steve Wharton,
Abstract:
Register @ http://manchesterpass.ddns.net/Speaker6.html Bring your own laptop! R is a powerful language to add to the BI, analytics and data science technologies you may already be using. This one day training session circumvents the painful experience of on-boarding a new technology and will give you the foundation needed to use R effectively via a series of focussed modules complete with hands-on labs. Topics covered will include effective R coding, development best-practices, using R as a reporting tool, and how to build and administer a solid platform for analysis. •Effective R will take you from "0 to Hero" and with no prior knowledge required, we'll get R installed and get you wrangling and visualising data in no time. •DevelopeR Skills teaches you how to build robust, scalable, and version controlled code. •R is for Reporting takes you through the "reproducible research" and reporting functionality so you can deliver cost free awesome reports to your business
Speaker(s): Stephanie Locke,
Abstract:
Ask the internet for help when you have a performance issue with tempdb and you will find a slew of articles on how to configure and setup tempdb on your server, how many files to use, where to place them on the disk subsystem, even what hardware to use.  In this session Kevan explains what tempdb is and what it is used for and leading on from that how you can, through development approaches, control how you use it. The usage of tempdb will go hand-in-hand with the overall performance of your queries, so do not be surprised if you learn how to make your queries fly at the same time.
Speaker(s): Kevan Riley,
Abstract:
Let’s talk about constraints. What’s holding you back from achieving Continuous Delivery? Databases. If it’s painful, do it often... Your app is automatically integrated, tested and packaged for deployment in minutes. But what about databases? Of course, databases come with complications and risks. We’ll talk about both the human and technical changes which are necessary to achieve a reliable, nimble, and automated database deployment process. You’ll learn how to bring Dev and Ops closer together as well as customise established practices and existing toolsets to build a database deployment pipeline and speed up delivery while at the same time protecting the data (and your sanity). In particular, we’ll look at two alternative solutions to the problem and their relative pros and cons. Declarative/state based development vs purely migrations driven development. By the end of the session, delegates will have learned not only that this elephant in the room can be tamed, b
Speaker(s): Alex Yates,
Abstract:
This session looks at how to implement, maintain and evolve solutions developed on Azure SQL Database, through the use of the tools like SQL Sever Management Studio and Visual Studio. Through examples and case studies, will be presented the versatility, power and reliability of the database as a service in the cloud.
Speaker(s): Emanuele Zanchettin,
Abstract:
For those who already have a basic understanding of Hekaton this session takes a deeper look; the session focus will be: Row Chains and MVCC, Hash and Range index internals and when and how to use. We will cover how to diagnose and deal with issues (through DMV’s and Perfmon). Hekaton basics are assumed.
Speaker(s): Tony Rogerson,
Abstract:
Whether you are a Data Wizard, a Dwarf mining for insights, an Elf creating elegant visualisations or an ordinary Hobbit seeking business enlightenment before second breakfast, BI Office from Pyramid Analytics can help you achieve your quest for insights and timely business information. By demonstrating how to build a BI Solution in 45 minutes, this session will show you how BI Office can make you a BI Hero in your organisation!
Speaker(s): Ian Macdonald,
Abstract:
2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW? Which tasks should have been finished BEFORE. Is virtual or physical SQL matter? We talk about systems, databases, peoples, encryption, passwords, certificates and users. In this session (on few demos) I'll show which part of our SQL Server Environment are critical and how to be prepared to disaster. In some documents I'll show You how to be BEST prepared.
Speaker(s): Tobias Koprowski,
Abstract:
With Microsoft’s acquisition of DataZen, dashboard and mobile BI is now easier than ever. Come along and see how to get started with DatZen. We will be showing an end to end demo of creating and publishing dashboards for mobile and tablet devices.
Speaker(s): Bob Duffy,
Abstract:
Join us for a lightning tour of Microsoft’s Azure HDInsight service for Big Data. Based on open-source Hadoop technologies, HDInsight provides the tools you need to process and analyze large volumes of diverse data; and in this session you’ll find out how to provision an HDInsight cluster and get started with a veritable alphabet soup of Hadoop technologies such as Hive, Pig, Sqoop, Oozie, HBase, Storm, and Mahout.
Speaker(s): Graeme Malcolm,
Abstract:
If you want to take the first step in improving your database development process with DLM, this is the workshop for you. You’ll learn how to: 1.Source control your database – the first step in any DLM process 2.Deploy your databases from source control 3.Monitor and track database changes across development, testing, and production environments Are you ready for this workshop? To get the most out of this workshop, you should be: •Performing database development •Looking to improve your processes •Working with: ◦SQL Server 2005+ ◦SQL Server Management Studio (SSMS) ◦T-SQL
Speaker(s): Alex Yates,
Abstract:
We will be taking you through how to setup replication, what types of options are available to you (snapshot,merge,transaction,peer to peer), how to implement them, an explanation of the various SQL Agent Jobs and Replication binaries involved and what the limitations are. This session will provide you with almost everything you need to know to get started with replication or give you a valuable refresher to the topic if you haven't done it in a while.
Speaker(s): David Williams,
Abstract:
This session takes you through the Power BI product set and explains how you can get analyse, experiment and iterate during the first stages of data warehouse proof of concept using Excel and Power BI. You will see how to model your data warehouse schema, make the processes more intuitive and specify the required outputs, aggregations and KPIs more efficiently while giving users an instant feel for the necessary outputs,
Speaker(s): Adam Aspin,
Abstract:
Extended Events is the profiler tool replacement, it is the premium tool for capturing diagnostic information for SQL Server, with advanced capabilities unlike we've had available before, using new features can take time to learn This session is focused to make you Effective with Extended Events, find out how to be up and running with using EE in just minutes not hours or days, join us to take a look what EE can do and discover what's happening inside your SQL Servers in ways no possible before
Speaker(s): Neil Hambly,
Abstract:
Database testing can be challenging, for a number of reasons that will be touched on in this session. We will discuss the motivations for unit testing, as well as some of the particular challenges involved in testing database code and integrating this testing into the software development process. Over the years, a number of tools and approaches have been developed to address these difficulties, and we will draw comparisons between some of these in order to highlight the questions you need to consider in choosing a testing approach for your own projects.
Speaker(s): Gavin Campbell,
Abstract:
Want to get your systems to the cloud, not entirely sure how to go about it? Let me guide you through the design considerations and process for building a Highly Available and resilient SQL Server infrastructure, looking at entirely cloud based and hybrid options. By the end of this session we will not only have discussed, but actually built and deployed a HA/DR SQL infrastructure and website that accesses it.
Speaker(s): John Martin,
Abstract:
Register @ http://manchesterpass.ddns.net/Speaker1.html Need to work with big data? Attend this session to learn how to use Microsoft Azure HDInsight to process big data and to generate results for analysis and reporting. The session will explain how to provision and manage Azure HDInsight, how to use Hadoop technologies like Pig, Hive, Oozie, Sqoop, HBase, and Storm to process data, and how to consume and visualize the results.
Speaker(s): Graeme Malcolm,
Abstract:
DML is used in most cases without thinking about the multiple operations for the db engine. This session will give a deep dive into the internal storage engine down to record level. After finishing the theory (and inside the theory) the differen DML commands and their tremendous operational tasks for the db engine will be investigated. SEE, what a workload will be caused by a "forwarded record". What tremendous workload will occur in a page split. What happens if an existing record will be updated in fixed length attributes
Speaker(s): Uwe Ricken,
Abstract:
Agile methodologies are widely used in the dev world and are becoming increasingly adopted in the database world. But what about BI? Covering the technology and process sides of enabling agile BI, this session is designed to give you practical tips to get things moving more quickly for you.
Speaker(s): Stephanie Locke,
Abstract:
Today’s Business Intelligence systems are increasingly perceived as mission critical, but their value is only as good as the quality of data they contain. How can you improve BI value by ensuring data quality through Microsoft SQL Server Master Data Services, accelerated by Profisee’s Master Data Maestro.
Speaker(s): Ben Cooper,
Abstract:
This session starts out with a demo which defies conventional wisdom, the purpose of this being to provide a 'Hook' into how CPUs are designed, how they work and how batch mode leverages modern CPU architectures. The concept of batch mode back pressure will be explored along with the pressure points batch mode places on modern CPUs and where the next quantum leap in performance might come from.
Speaker(s): Christopher Adkin,
Abstract:
Session Details not available
Speaker(s): n/a n/a,
Abstract:
Session Details not available
Speaker(s): n/a n/a,
Abstract:
Register @ http://manchesterpass.ddns.net/Speaker2.html Traditional BI has been all about creating consistent data sets fronted with easy to use tools to allow our users to explore data and make decisions. While this still has its place it doesn't cover predictions well nor does it deliver any actionable insight. That gap is starting to be filled by machine learning and while this has been expensive and complex to implement, Azure Machine Learning takes away a lot of this and at low risk. So if you are curious, you know the data you work with and the business you are in let us enlighten you about how this might really transform your business with only the most basic knowledge of statistics!
Speaker(s): Andrew Fryer,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa
LinkedIn: https://www.linkedin.com/profile/preview?locale=en_USamp;trk=prof-0-sb-preview-primary-button
Contact: http://uk.linkedin.com/pub/ian-macdonald/1/381/2a1
Ian is a data wizard, who has nearly 30 years’ experience in the Enterprise Business Intelligence market. Starting in Technical Support, training and consulting with Information Builders in 1986, he subsequently developed a career in presales, product marketing and marketing , holding senior VP positions with companies such as Microsoft, Hyperion Solutions and HP. Ian has been working with Pyramid Analytics for five years, initiating their UK presence in 2011.
LinkedIn: http://uk.linkedin.com/in/gavincampbell
Contact: http://arapaima.uk
Gavin Campbell is a recovering Business Intelligence developer specialised in improving working practices in database delivery through the use of tools such as SQL Server Data Tools, tSQLt, Visual Studio Team Services, Git and Jenkins, on platforms such as AWS and Microsoft Azure, and methodologies such as Continuous Delivery and Agile.
LinkedIn: 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://uk.linkedin.com/in/alexwhittles
Contact: http://www.PurpleFrogSystems.com/blog
Alex is a Data Platform MVP, and is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specializes in Data Warehouse modelling, ETL, Cubes, MDX amp; DAX. He#39;s a chartered engineer amp; has an MSc in Business Intelligence. He runs the Birmingham (UK) SQL Pass chapter amp; Azure user groups, and is on the SQLBits and SQL Relay committees in the UK. Alex is a regular speaker at global events including SQLBits, PASS Summit, SQL Relay, SQLSaturdays as well as numerous SQL Pass chapters around Europe
Contact: http://blogs.prodata.ie/author/bob.aspx
Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM. and Analysis Services Maestro certified. Bob works as a Database Architect at the Prodata SQL Centre of Excellence where he specializes in business intelligence and performance tuning.
LinkedIn: http://uk.linkedin.com/in/alexanderyates
Contact: http://www.workingwithdevs.com
Alex Yates has been helping organisations to apply DevOps principles to relational database development and deployment since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins. A keen community member, he co-organises SQL Relay, is the founder of www.SpeakingMentors.com and has been recognised as a Microsoft Data Platform MVP since 2017.
LinkedIn: https://uk.linkedin.com/in/alexwhittles
Contact: http://www.PurpleFrogSystems.com/blog
Alex is a Data Platform MVP, and is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specializes in Data Warehouse modelling, ETL, Cubes, MDX amp; DAX. He#39;s a chartered engineer amp; has an MSc in Business Intelligence. He runs the Birmingham (UK) SQL Pass chapter amp; Azure user groups, and is on the SQLBits and SQL Relay committees in the UK. Alex is a regular speaker at global events including SQLBits, PASS Summit, SQL Relay, SQLSaturdays as well as numerous SQL Pass chapters around Europe
LinkedIn: https://uk.linkedin.com/in/stephanielocke
Contact: https://itsalocke.com
Steph Locke leads a life of data, coffee, books and board games. During the day, Steph runs her own consultancy helping people start doing data science. Steph enjoys being her own gal as it means she gets to spend plenty of time building communities to provide platforms for people to help each other be better with data.
LinkedIn: https://www.linkedin.com/in/kevriley/
Contact: https://www.rileywaterhouse.co.uk/blog
Kevan Riley (MCSE: Data Management and Analytics) has been working with SQL Server since 1999 in a variety of DBA and DB developer roles. He now works as a freelance SQL Server Consultant in the UK and is no more happier than when knee-deep in performance tuning. He can be often found contributing at ask.sqlservercentral.com and getting involved with the SQL community at UK user groups, SQLSaturdays, SQLBits and SQL Relay.
Contact: http://www.andrewfryer.com
Andrew Fryer is a Technical Evangelist at Microsoft UK Ltd, specialising in database management amp; BI. When not blogging and making screencasts in the office he can be found presenting at various technical events across the UK including, Future Decoded, TechDays OnLine, and any event with the acronym SQL in the title.
LinkedIn: http://uk.linkedin.com/in/johnqmartin/
Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/
John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK. John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.
LinkedIn: http://www.linkedin.com/profile/view?id=270775013amp;trk=tab_pro
Contact: http://www.sqlmaster.de
Uwe Ricken is working with IT systems since the 90’s. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. In the same year he earned his first award as a Data Platform MVP for his support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.
LinkedIn: https://uk.linkedin.com/in/andriychenko
Contact: http://www.data-united.co.uk
Dmytro Andriychenko has over 10 years of SQL Server experience working as analyst, admin, developer and designer. Dmytro is a Microsoft Certified BI Expert with plenty of experience in all components of SQL Server in a variety of business settings (Betting, Banking, Legal, NHS and Bio-Pharma). His most recent focus is on BI architecture and delivery.
LinkedIn: https://uk.linkedin.com/in/tonyrogerson
Contact: http://dataidol.com/tonyrogerson
Tony is a freelance SQL Server and Data Specialist, he is a Fellow of the British Computer Society, has a masters degree in BI and a PGCert in Data Science. For the past 18 years he has been using SQL Server, received the SQL Server MVP award for the past 16 years. Interested in distributed commodity data processing.
LinkedIn: http://www.linkedin.com/in/bencooper2
Ben has over 15 years’ experience working with SQL Server and supporting Microsoft data platform technologies. Ben joined Profisee 6 months ago as a Pre-Sales Solutions Consultant to build capability and revenue streams in the UK. Prior to Profisee, Ben spent 9 years working at Microsoft as a SQL Server Premier Field Engineer and recently as a Technical Solution Architect designing solutions and supporting the Enterprise Sales teams position SQL Server as a tier 1 mission critical platform.
LinkedIn: http://uk.linkedin.com/in/johnqmartin/
Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/
John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK. John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.
LinkedIn: https://uk.linkedin.com/in/koprowskit
Contact: http://koprowskit.eu/geek/
Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff. Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador. Traveler. Coffee Addicted.
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: https://www.linkedin.com/in/wollatondba
Contact: http://www.chrisadkin.io
Chris is a freelance SQL consultant who has been working with SQL Server since 2000, his passion is for squeezing every last drop of performance out of SQL Server and understanding the database engine at a level which conventional tools cannot provide any insights on.
Contact: http://www.andrewfryer.com
Andrew Fryer is a Technical Evangelist at Microsoft UK Ltd, specialising in database management amp; BI. When not blogging and making screencasts in the office he can be found presenting at various technical events across the UK including, Future Decoded, TechDays OnLine, and any event with the acronym SQL in the title.
Graeme Malcolm has been a trainer, consultant, and author for longer than he cares to remember, specializing in SQL Server and the Microsoft data platform. After years of working with Microsoft as a partner and vendor, he joined Microsoft as a full-time employee and now works in the Microsoft Learning Experiences team as a Senior Content Developer, where he plans and creates content for developers and data professionals who want to get the best out of Microsoft technologies.
LinkedIn: http://uk.linkedin.com/in/alexanderyates
Contact: http://www.workingwithdevs.com
Alex Yates has been helping organisations to apply DevOps principles to relational database development and deployment since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins. A keen community member, he co-organises SQL Relay, is the founder of www.SpeakingMentors.com and has been recognised as a Microsoft Data Platform MVP since 2017.
Graeme Malcolm has been a trainer, consultant, and author for longer than he cares to remember, specializing in SQL Server and the Microsoft data platform. After years of working with Microsoft as a partner and vendor, he joined Microsoft as a full-time employee and now works in the Microsoft Learning Experiences team as a Senior Content Developer, where he plans and creates content for developers and data professionals who want to get the best out of Microsoft technologies.
LinkedIn: https://uk.linkedin.com/in/stephanielocke
Contact: https://itsalocke.com
Steph Locke leads a life of data, coffee, books and board games. During the day, Steph runs her own consultancy helping people start doing data science. Steph enjoys being her own gal as it means she gets to spend plenty of time building communities to provide platforms for people to help each other be better with data.
LinkedIn: http://uk.linkedin.com/in/alexanderyates
Contact: http://www.workingwithdevs.com
Alex Yates has been helping organisations to apply DevOps principles to relational database development and deployment since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins. A keen community member, he co-organises SQL Relay, is the founder of www.SpeakingMentors.com and has been recognised as a Microsoft Data Platform MVP since 2017.
LinkedIn: http://it.linkedin.com/pub/emanuele-zanchettin/18/921/34/
Emanuele Zanchettin, after studying in Computer Engineering, began his career with DB2 in the banking sector in 1998. After a few years and a change of scope of application, he encountered Access and Oracle with which he subsequently worked for several years in data access tuning and database design for new application features. Since 2007 he has also launched into the SQLServer world 2K, 2005, 2008* and 201* and more importantly, since 2011, into Azure SQL Database (SQL Azure). In order to have a greater capacity for assessment and familiarity with the various technologies that the market offers, he has deepened his knowledge to include MySQL and DocumentDB. Today Emanuele is mainly involved in IT projects and database management.
LinkedIn: https://uk.linkedin.com/in/tpmccann
Contact: https://www.advancinganalytics.co.uk/blog
Microsoft MVP. Principal Consultant and Owner of Advancing Analytics Limited, an Advanced Analytics consultancy in the UK. Advancing Analytics helps businesses advance their analytical capabilities. Our focus is on Data Science, Data Engineering, DataOps and applied AI. Terry holds a Master's degree in Data Science - with a focus on DataOps for Machine Learning. Speaker at conferences across the world and the host of the Data Science in Production Podcast.
LinkedIn: https://uk.linkedin.com/in/tonyrogerson
Contact: http://dataidol.com/tonyrogerson
Tony is a freelance SQL Server and Data Specialist, he is a Fellow of the British Computer Society, has a masters degree in BI and a PGCert in Data Science. For the past 18 years he has been using SQL Server, received the SQL Server MVP award for the past 16 years. Interested in distributed commodity data processing.
Adam Aspin is an independent Business Intelligence consultant based in the United Kingdom. He has worked with SQL Server for nineteen years. During this time, he has developed several dozen reporting and analytical systems based on the Microsoft BI product suite. He is the author of quot;High Impact Data Visualization with Power View, Power Map, and Power BIquot;, “SQL Server Data Integration Recipes” and quot;Business Intelligence with SQL Server Reporting Servicesquot; - all with Apress
LinkedIn: http://uk.linkedin.com/in/jrowlandjones/
James Rowland-Jones (JRJ) is a Principal Program Manager at Microsoft. He is currently part of the SQL Server team working on SQL Server 2019 Big Data Clusters and data virtualization. Prior to joining SQL Server, JRJ worked extensively on Azure SQL Data Warehouse. He helped the team launch Gen 1 of the service and led the product management effort to bring Gen 2 into preview.
Steve Wharton is a Principal Systems Engineer at Fusion-io a SanDisk Company. Steve has been working in IT for more than 20 years and has previously held positions at Data Domain, Dell, Compaq and several bluechip companies in IT delivery roles.
LinkedIn: https://www.linkedin.com/in/justdaveinfo?trk=nav_responsive_tab_profile
Contact: http://justdave.info
David is a cross product DBA (SQL Server, DB2, Oracle, Informix, Sybase) who has worked for 25 years as a DBA for both private, local/central government customers including a Fortune 50 investment bank. Certifications include MCSE 2014 Data Platform, MCTS SQL Server 2008 DBA and Developer as well as certifcations in other products. David has spoken at multiple SQLSaturdays as well as local usergroups and is a regular volunteer at events including SQLBits.
The following is a list of sponsors that helped fund the event.


Standard system time functions.
More...
|
|
#define | TZ_LEN 6 |
| |
|
#define | SECONDS_PER_MINUTE (60) |
| |
|
#define | MINUTES_PER_HOUR (60) |
| |
|
#define | SECONDS_PER_HOUR (SECONDS_PER_MINUTE * MINUTES_PER_HOUR) |
| |
|
#define | HOURS_PER_DAY (24) |
| |
|
#define | MINUTES_PER_DAY (HOURS_PER_DAY * MINUTES_PER_HOUR) |
| |
|
#define | SECONDS_PER_DAY (MINUTES_PER_DAY * SECONDS_PER_MINUTE) |
| |
|
#define | TZ_LEN 6 |
| |
|
#define | SECONDS_PER_MINUTE (60) |
| |
|
#define | MINUTES_PER_HOUR (60) |
| |
|
#define | SECONDS_PER_HOUR (SECONDS_PER_MINUTE * MINUTES_PER_HOUR) |
| |
|
#define | HOURS_PER_DAY (24) |
| |
|
#define | MINUTES_PER_DAY (HOURS_PER_DAY * MINUTES_PER_HOUR) |
| |
|
#define | SECONDS_PER_DAY (MINUTES_PER_DAY * SECONDS_PER_MINUTE) |
| |
Standard system time functions.
This module contains standard time functions and formatters for printing. Note that Pebble now supports both local time and UTC time (including timezones and daylight savings time). Most of these functions are part of the C standard library which is documented at https://sourceware.org/newlib/libc.html#Timefns
◆ difftime()
| double difftime |
( |
time_t |
end, |
|
|
time_t |
beginning |
|
) |
| |
|
noexcept |
Obtain the number of seconds elapsed between beginning and end represented as a double.
- Parameters
-
| end | A time_t variable representing some number of seconds since epoch, January 1st 1970 |
| beginning | A time_t variable representing some number of seconds since epoch, January 1st 1970. Note that end should be greater than beginning, but this is not enforced. |
- Returns
- The number of seconds elapsed between beginning and end.
- Note
- Pebble uses software floating point emulation. Including this function which returns a double will significantly increase the size of your binary. We recommend directly subtracting both timestamps to calculate a time difference.
int difference = ts1 - ts2;
◆ gmtime()
| struct tm * gmtime |
( |
const time_t * |
timep | ) |
|
convert the time value pointed at by clock to a struct tm which contains the time expressed in Coordinated Universal Time (UTC)
- Parameters
-
| timep | A pointer to an object of type time_t that contains a time value |
- Returns
- A pointer to a struct tm containing Coordinated Universal Time (UTC)
◆ localtime()
| struct tm * localtime |
( |
const time_t * |
timep | ) |
|
convert the time value pointed at by clock to a struct tm which contains the time adjusted for the local timezone
- Parameters
-
| timep | A pointer to an object of type time_t that contains a time value |
- Returns
- A pointer to a struct tm containing the broken out time value adjusted for the local timezone
◆ mktime()
| time_t mktime |
( |
struct tm * |
tb | ) |
|
convert the broken-down time structure to a timestamp expressed in Coordinated Universal Time (UTC)
- Parameters
-
| tb | A pointer to an object of type tm that contains broken-down time |
- Returns
- The number of seconds since epoch, January 1st 1970
◆ strftime()
| int strftime |
( |
char * |
s, |
|
|
size_t |
maxsize, |
|
|
const char * |
format, |
|
|
const struct tm * |
tm_p |
|
) |
| |
Format the time value at tm according to fmt and place the result in a buffer s of size max
- Parameters
-
| s | A preallocation char array of size max |
| maxsize | the size of the array s |
| format | a formatting string |
| tm_p | A pointer to a struct tm containing a broken out time value |
- Returns
- The number of bytes placed in the array s, not including the null byte, 0 if the value does not fit.
◆ time()
| time_t time |
( |
time_t * |
tloc | ) |
|
|
noexcept |
Obtain the number of seconds since epoch. Note that the epoch is not adjusted for Timezones and Daylight Savings.
- Parameters
-
| tloc | Optionally points to an address of a time_t variable to store the time in. If you only want to use the return value, you may pass NULL into tloc instead |
- Returns
- The number of seconds since epoch, January 1st 1970
◆ time_ms()
| uint16_t time_ms |
( |
time_t * |
t_utc, |
|
|
uint16_t * |
out_ms |
|
) |
| |
Obtain the number of seconds and milliseconds part since the epoch. This is a non-standard C function provided for convenience.
- Parameters
-
| tloc | Optionally points to an address of a time_t variable to store the time in. You may pass NULL into tloc if you don't need a time_t variable to be set with the seconds since the epoch |
| out_ms | Optionally points to an address of a uint16_t variable to store the number of milliseconds since the last second in. If you only want to use the return value, you may pass NULL into out_ms instead |
- Returns
- The number of milliseconds since the last second
◆ time_start_of_today()
| time_t time_start_of_today |
( |
void |
| ) |
|
Return the UTC time that corresponds to the start of today (midnight).
- Returns
- the UTC time corresponding to the start of today (midnight)


This is time-sensitive because the acquisition of the papers is in progress
assigned
by None at 2023-03-06 22:45:01.labeled
by None at 2023-03-06 23:31:44.assigned
by None at 2023-03-06 23:42:40.closed
by None at 2023-03-07 01:41:44.Run against an export of data in XML from ASPACE.
referenced
by Jane Sandberg at 2023-03-07 15:25:42.merged
by Jane Sandberg at 2023-03-07 15:25:42.closed
by Jane Sandberg at 2023-03-07 15:25:42.head_ref_deleted
by Jane Sandberg at 2023-03-07 15:25:44.Leaving this open until we re-index.
closed
by Kevin Reiss at 2023-03-07 18:08:30.reopened
by Kevin Reiss at 2023-03-07 18:29:07.labeled
by Kevin Reiss at 2023-03-07 18:49:37.labeled
by Kevin Reiss at 2023-03-07 18:49:44.I think that in the current landscape, this is not desirable. There are a lot of records with no holdings or portfolios that have no errors (like records with arks currently).
ready_for_review
by Christina Chortaria at 2023-03-06 22:25:54.convert_to_draft
by Christina Chortaria at 2023-03-07 10:26:10.ready_for_review
by Christina Chortaria at 2023-03-07 13:45:01.convert_to_draft
by Christina Chortaria at 2023-03-07 14:36:10.head_ref_force_pushed
by Christina Chortaria at 2023-03-07 15:59:01.head_ref_force_pushed
by Christina Chortaria at 2023-03-07 16:03:39.ready_for_review
by Christina Chortaria at 2023-03-07 16:04:05.deployed
by None at 2023-03-07 19:07:38.referenced
by Jane Sandberg at 2023-03-07 19:14:04.merged
by Jane Sandberg at 2023-03-07 19:14:04.closed
by Jane Sandberg at 2023-03-07 19:14:04.head_ref_deleted
by Jane Sandberg at 2023-03-07 19:14:06.closed
by Jane Sandberg at 2023-03-07 19:14:06.progress https://github.com/pulibrary/bibdata/tree/2078-process-scsb
labeled
by Kevin Reiss at 2023-03-07 18:40:08.labeled
by Kevin Reiss at 2023-03-07 18:40:13.unlabeled
by Kevin Reiss at 2023-03-07 18:40:38.assigned
by Christina Chortaria at 2023-03-07 20:46:34.Some possible gems:
We could also forego using an additional gem, and use the debian iso-codes package or the tables directly from SIL.
assigned
by Cliff Wulfman at 2023-03-07 16:41:54.I don't see the CSS?
@cwulfman I didn't include any CSS — the above produces a collapsible/expandable menu with pure HTML. But if we want to have the styling look more like the current site, I believe we can use CSS to e.g., customize the bullets, etc. to do that.
Wow. I'd never heard of the details element.
mentioned
by Cliff Wulfman at 2023-03-07 17:23:13.subscribed
by Cliff Wulfman at 2023-03-07 17:23:13.review_requested
by Cliff Wulfman at 2023-03-07 17:37:45.mentioned
by Kate Lynch at 2023-03-07 17:37:46.subscribed
by Kate Lynch at 2023-03-07 17:37:46.referenced
by esmé cowles at 2023-03-07 19:23:22.merged
by esmé cowles at 2023-03-07 19:23:22.closed
by esmé cowles at 2023-03-07 19:23:22.head_ref_deleted
by esmé cowles at 2023-03-07 19:23:26.head_ref_force_pushed
by Jane Sandberg at 2023-03-07 21:20:24.Many of these errors occur on certain dates, every few months and may be related to bots crawling the site. When a valid locale (e.g., "es") is provided as the value it does not error, but does not do any translation on the page.
Honeybadger error title: [DPUL/production] I18n::InvalidLocale: "TEDsQ" is not a valid locale
labeled
by None at 2023-03-07 15:33:19.labeled
by None at 2023-03-07 15:33:19.renamed
by Shaun Ellis at 2023-03-07 15:37:16.Honeybadger Error: [DPUL/production] RuntimeError: Exhibit id exists (puo), but @exhibit hasn't been loaded yet
This could be due to an old link or bookmark. Perhaps adding the ability to alias or forward old exhibit links to updated ones would help.
@eliotjordan suggests setting up the blacklightdynamicsitemap gem. Example in PulfaLight: https://github.com/pulibrary/pulfalight/pull/1127/files
labeled
by None at 2023-03-07 17:36:47.labeled
by None at 2023-03-07 17:36:47.mentioned
by Eliot Jordan at 2023-03-07 17:39:48.subscribed
by Eliot Jordan at 2023-03-07 17:39:49.mentioned
by None at 2023-03-07 17:39:49.subscribed
by None at 2023-03-07 17:39:49.renamed
by Shaun Ellis at 2023-03-07 17:40:30.closed
by Bess Sadler at 2023-03-07 13:32:26.head_ref_force_pushed
by None at 2023-03-07 15:42:57.head_ref_force_pushed
by None at 2023-03-07 15:44:32.assigned
by Eliot Jordan at 2023-03-07 19:12:58.unassigned
by Eliot Jordan at 2023-03-07 19:13:07.assigned
by Eliot Jordan at 2023-03-07 19:13:18.referenced
by Trey Pendragon at 2023-03-07 20:00:37.merged
by Trey Pendragon at 2023-03-07 20:00:37.closed
by Trey Pendragon at 2023-03-07 20:00:38.head_ref_deleted
by Trey Pendragon at 2023-03-07 20:00:39.This got closed by 5703, but I don't think it's quite done yet - they need to be able to click the reference in Figgy to get all of them that have that reference, so they know which to edit.
assigned
by Eliot Jordan at 2023-03-07 16:47:32.closed
by Trey Pendragon at 2023-03-07 20:00:40.reopened
by Trey Pendragon at 2023-03-07 20:02:44.I ran the report like this, and gave the output to Kim:
docs = Blacklight.default_index.connection.get("select", params: {qt: "search", fl: "id, imported_location_tesim", qf: "imported_location_tes
im", "q.alt": "imported_location_tesim:(CTSN CTSNRF HSVC XC RCPXC SCACTSN SCAHSVC XCR)", defType: "edismax", rows: 10000})["response"]["docs"].map{|x| x["id"]
}.lazy.map{|x| ChangeSetPersister.default.query_service.find_by(id: x)}
report = CSVReport.new(docs, fields: ImportedMetadata.fields)
report.write(path: Rails.root.join("tmp", "report.csv"))
It's not pretty, but it's literally every field Figgy knows how to import or manages itself.
assigned
by Trey Pendragon at 2023-03-07 20:08:57.referenced
by Trey Pendragon at 2023-03-07 21:00:26.unlabeled
by Trey Pendragon at 2023-03-08 02:44:38.referenced
by Bess Sadler at 2023-03-06 23:40:09.merged
by Bess Sadler at 2023-03-06 23:40:09.closed
by Bess Sadler at 2023-03-06 23:40:09.head_ref_deleted
by Bess Sadler at 2023-03-06 23:40:10.assigned
by None at 2023-03-07 00:02:10.closed
by None at 2023-03-07 01:38:27.labeled
by Kevin Reiss at 2023-03-07 17:20:09.assigned
by Francis Kayiwa at 2023-03-07 17:22:23.assigned
by Robert-Anthony Lee-Faison at 2023-03-07 17:22:23.convert_to_draft
by Francis Kayiwa at 2023-03-07 22:13:04.head_ref_force_pushed
by Francis Kayiwa at 2023-03-07 22:16:30.assigned
by Max Kadel at 2023-03-07 14:34:30.labeled
by Eliot Jordan at 2023-03-07 17:46:21.assigned
by Eliot Jordan at 2023-03-07 17:46:26.Coverage: 95.093% (-0.02%) from 95.109% when pulling 7e0fcd46c7d35729fd74e9c1e08d7cd9a71e6fb5 on 3444-numismatic-citations into 8524e0ab7bc7bde3c81a4b54daaabda3d3ce5316 on main.
labeled
by Kevin Reiss at 2023-03-07 18:56:59.labeled
by Kevin Reiss at 2023-03-07 18:57:07.closed
by Kevin Reiss at 2023-03-07 18:58:01.closed
by Kevin Reiss at 2023-03-07 19:03:45.moved_columns_in_project
by Kevin Reiss at 2023-03-07 19:03:46.Coverage: 95.091% (-0.02%) from 95.109% when pulling c9f8013e52f13fae70b5bfacdce475c8af5e7957 on 3409-pa11y into 8524e0ab7bc7bde3c81a4b54daaabda3d3ce5316 on main.
head_ref_force_pushed
by Christina Chortaria at 2023-03-07 19:32:21.head_ref_force_pushed
by Christina Chortaria at 2023-03-07 19:49:51.Thank you, @christinach ! @eliotjordan can we talk about this ticket tomorrow as well?
mentioned
by Eliot Jordan at 2023-03-07 21:43:58.subscribed
by Eliot Jordan at 2023-03-07 21:43:58.mentioned
by Christina Chortaria at 2023-03-07 21:43:59.subscribed
by Christina Chortaria at 2023-03-07 21:43:59.referenced
by Bess Sadler at 2023-03-07 14:04:04.merged
by Bess Sadler at 2023-03-07 14:04:04.closed
by Bess Sadler at 2023-03-07 14:04:04.head_ref_deleted
by Bess Sadler at 2023-03-07 14:04:06.head_ref_force_pushed
by James R. Griffin III at 2023-03-07 22:06:02.head_ref_force_pushed
by Francis Kayiwa at 2023-03-06 22:10:49.head_ref_force_pushed
by Francis Kayiwa at 2023-03-06 22:18:21.head_ref_force_pushed
by Francis Kayiwa at 2023-03-06 22:32:58.review_requested
by Francis Kayiwa at 2023-03-06 22:46:58.referenced
by Alicia Cozine at 2023-03-07 17:42:40.merged
by Alicia Cozine at 2023-03-07 17:42:40.closed
by Alicia Cozine at 2023-03-07 17:42:40.head_ref_deleted
by Alicia Cozine at 2023-03-07 17:42:41.assigned
by James R. Griffin III at 2023-03-07 17:50:11.review_requested
by Francis Kayiwa at 2023-03-07 18:26:48.referenced
by Jane Sandberg at 2023-03-07 18:27:09.merged
by Jane Sandberg at 2023-03-07 18:27:09.closed
by Jane Sandberg at 2023-03-07 18:27:09.head_ref_deleted
by Jane Sandberg at 2023-03-07 18:27:11.referenced
by Francis Kayiwa at 2023-03-07 18:31:14.merged
by Francis Kayiwa at 2023-03-07 18:31:14.closed
by Francis Kayiwa at 2023-03-07 18:31:15.head_ref_deleted
by Francis Kayiwa at 2023-03-07 18:31:16.head_ref_force_pushed
by Alicia Cozine at 2023-03-07 20:11:43.head_ref_force_pushed
by Alicia Cozine at 2023-03-07 20:14:10.Closing in favor of #3741.
closed
by Alicia Cozine at 2023-03-07 20:25:36.head_ref_force_pushed
by Alicia Cozine at 2023-03-07 20:26:37.head_ref_force_pushed
by Alicia Cozine at 2023-03-07 20:27:36.head_ref_force_pushed
by Alicia Cozine at 2023-03-07 20:28:52.Current failure is in the figgy role - VIPS is refusing to build. It looks like a missing-package problem. First part of the error message is:
./configure && make && make install", "delta": "0:00:59.656087", "end": "2023-03-06 23:23:28.844471", "msg": "non-zero return code", "rc": 2, "start": "2023-03-06 23:22:29.188384", "stderr": "./configure: line 11955: /usr/bin/file: No such file or directory
configure: WARNING:
You will not be able to create source packages with 'make dist'
because gtk-doc >= 1.14 is not found.
configure: WARNING: fftw not found; disabling fftw support
configure: WARNING: neither MagickCore nor ImageMagick found; disabling Magick support
configure: WARNING: orc-0.4.11 or later not found; disabling orc support
configure: WARNING: OpenEXR not found; disabling OpenEXR support
configure: WARNING: libheif not found; disabling HEIF support
configure: WARNING: librsvg-2.0 >= 2.40.3 or cairo >= 1.2 not found; disabling SVG load via rsvg
configure: WARNING: OpenSlide >= 3.3.0 not found; disabling virtual slide support
configure: WARNING: matio not found; disabling matio support
configure: WARNING: cfitsio not found; disabling cfitsio support
configure: WARNING: libwebp, mux, demux not found; disabling WEBP support
configure: WARNING: pangoft2 not found; disabling pangoft2 support
configure: WARNING: giflib not found; disabling direct GIF support
configure: WARNING: libimagequant not found; disabling 8bpp PNG support
pdfload.c: In function ‘vips_foreign_load_pdf_buffer_open’:
pdfload.c:715:17: warning: ‘poppler_document_new_from_data’ is deprecated: Use poppler_document_new_from_bytes instead [-Wdeprecated-declarations]
715 | !(pdf->doc = poppler_document_new_from_data(
| ^
In file included from /usr/include/poppler/glib/poppler.h:246,
from pdfload.c:69:\n/usr/include/poppler/glib/poppler-document.h:298:18: note: declared here
298 | PopplerDocument *poppler_document_new_from_data(char *data, int length, const char *password, GError **error) G_GNUC_DEPRECATED_FOR(poppler_document_new_from_bytes);
closed
by Francis Kayiwa at 2023-03-07 20:42:16.Current CI failure is in the libwww role:
TASK [libwww : libwww | ensure MaxRequestWorkers is set for system use] ********
An exception occurred during task execution. To see the full traceback, use -vvv. The error was: NoneType: None
fatal: [instance]: FAILED! => {"changed": false, "msg": "src and dest are required"}
supercedes #3732
closed
by Kevin Reiss at 2023-03-07 16:08:57.This may be due to bots crawling the site since it occurs frequently on one day every few months. It's unclear if this is intended behavior. It's also unclear as to why the query string is there as it does not seem to be related to any Pulfalight features.
Honeybadger Title: [PULFALight/production] NoMethodError: undefined method `except' for "1":String
labeled
by None at 2023-03-07 15:38:51.labeled
by None at 2023-03-07 15:38:51.renamed
by Shaun Ellis at 2023-03-07 15:43:10.This happens frequently. It looks like the []
characters in the query string date range are to blame here. If we replace this snippet:
range[solr_year_i][begin][]=1850&range[solr_year_i][end][]=1899
With this snippet:
range[solr_year_i][begin]=1850&range[solr_year_i][end]=1899
It then works as expected.
assigned
by Bess Sadler at 2023-03-07 13:35:11.I can prioritize addressing Ansible as well as contacting Steve in order to ensure that this is addressed before the end of this week.
I have just e-mailed Steve with a request for an update. I shall proceed now immediately with the Ansible updates.
unassigned
by None at 2023-03-07 13:37:23.assigned
by James R. Griffin III at 2023-03-07 13:37:24.


GPS
public class GPS : CustomStringConvertible
GPS provides an library for many calculations involving GPS and earth.
A GPS
instance contains a latitude and longitude and is used for performing operations in the GPS library. GPS
instances have a few instance methods. All instance methods use public static methods for the calculations.
-
Declaration
Swift
public var description: String { get }
-
Undocumented
Declaration
Swift
public var latitude: Double
-
Undocumented
Declaration
Swift
public var longitude: Double
-
Initiazlizes a new
GPS
objectDeclaration
Swift
public init(latitude: Double, longitude: Double)
Parameters
latitude
Latitude of the GPS coordinate
longitude
Longitude of the GPS coordinate
-
Initiazlies a new
GPS
objectDeclaration
Swift
public init(locationCoordinate: CLLocationCoordinate2D)
Parameters
locationCoordinate
A
CLLocationCoordinate2D
to create theGPS
object from.
-
Distance to a point using the Equitectangular formula. Units will match planet radius units. Less accurate than Haversine but less time consuming.
Declaration
Swift
public func distanceToEquirectangular(gps: GPS) -> Double
Parameters
gps
Distance to this
GPS
coordinateReturn Value
Distance in units matching
GPS.planetRadius
units. -
Distance to a point using the Haversine formula. More accurate than equirectangular but more time consuming.
Declaration
Swift
public func distanceToHaversine(gps: GPS) -> Double
Parameters
gps
Distance to this
GPS
coordinateReturn Value
Distance in units matching
GPS.planetRadius
units. -
Returns the GPS coordinates on the other side of the world from the instance
GPS
.  -
Calculate the time of sunrise at the instance
GPS
Declaration
Swift
public func sunriseTime(date: Date, sunZenith: SunZenith) -> Date?
Parameters
date
Requested
Date
for sunrise time. (UTC)sunZenith
Requested
GPS.SunZenith
for sunrise timeReturn Value
Date
of the sunrise time (UTC). Null if no sunrise on this day -
Calculate the time of sunset at the instance
GPS
Declaration
Swift
public func sunsetTime(date: Date, sunZenith: SunZenith) -> Date?
Parameters
date
Requested
Date
for sunset time. (UTC)sunZenith
Requested
GPS.SunZenith
for sunset timeReturn Value
Date
of the sunset time (UTC). Null if no sunset on the day -
Calculate the duration of the day at the instance
GPS
Declaration
Swift
public func dayDuration(date: Date, sunZenith: SunZenith) -> Double
Parameters
date
The requested
Date
for day durationsunZenith
The requested
GPS.SunZenith
for calculating sunrise and sunset and the difference.Return Value
Day duration in seconds. 0 if no sunrise or no sunset on this day.
-
Calculate the bearing to another
GPS
Declaration
Swift
public func bearingTo(gps: GPS) -> Double
Parameters
gps
GPS
to find the heading to.Return Value
The bearing to the given
GPS
in degrees. (between 0 and 360) -
Halfway along the great circle path between two coordinates
Declaration
Swift
public func midpointTo(gps: GPS) -> GPS
Parameters
f
Origin
GPS
s
Destination
GPS
Return Value
GPS
of midpoint
-
Undocumented
Declaration
Swift
public static let MAX_LATITUDE: Double
-
Undocumented
Declaration
Swift
public static let MIN_LATITUDE: Double
-
Undocumented
Declaration
Swift
public static let MIN_LONGITUDE: Double
-
Undocumented
Declaration
Swift
public static let MAX_LONGITUDE: Double
-
Radius of Earth (Miles)
Declaration
Swift
public static let EARTH_RADIUS: Double
-
Radius of Earth (Kilometers)
Declaration
Swift
public static let EARTH_RADIUS_METRIC: Double
-
Radius of Moon (Miles)
Declaration
Swift
public static let MOON_RADIUS: Double
-
Radius of Moon (Kilometers)
Declaration
Swift
public static let MOON_RADIUS_METRIC: Double
-
Radius of Mars (Miles)
Declaration
Swift
public static let MARS_RADIUS: Double
-
Radius of Mars (Kilometers)
Declaration
Swift
public static let MARS_RADIUS_METRIC: Double
-
Planet Radius used for calculations. Defaults to radius of Earth in Miles.
Declaration
Swift
public static var planetRadius: Double
-
Distance to a point using the Haversine formula. More accurate than equirectangular but more time consuming.
Declaration
Swift
public static func distanceBetweenHaversine(f: GPS, s: GPS) -> Double
Parameters
f
First
GPS
s
Second
GPS
Return Value
Distance from f to s in units matching
GPS.planetRadius
-
Distance to a point using the Equirectangular formula. More less than Haversine but less time consuming. Can be used accuratly for short distances on earth. When calculating distances on other planets, use equirectangular always.
Declaration
Swift
public static func distanceBetweenEquirectangular(f: GPS, s: GPS) -> Double
Parameters
f
First
GPS
s
Second
GPS
Return Value
Distance from f to s in units matching
GPS.planetRadius
-
Calculate the bearing between two
GPS
Declaration
Swift
public static func bearingBetweenCoordinates(f: GPS, s: GPS) -> Double
Parameters
f
First
GPS
(heading from)s
Second
GPS
(heading to)Return Value
The bearing to the given
GPS
in degrees. (between 0 and 360. 0 is North) -
Halfway along the great circle path between two coordinates
Declaration
Swift
public static func midpointCoordinate(f: GPS, s: GPS) -> GPS
Parameters
f
Origin
GPS
s
Destination
GPS
Return Value
GPS
of midpoint -
GPS coordinates on the other side of the world. (If you were to dig a hole perfectly straight this is where you would end up)
Declaration
Swift
public static func oppositeCoordinate(gps: GPS) -> GPS
Parameters
gps
GPS
to operate withReturn Value
GPS
of opposite coordinate -
Convert decimal format coordinates to degrees, minutes, seconds
Declaration
Swift
public static func toDegreesMinuteSecond(coordinate: Double) -> (degrees: Double, minutes: Double, seconds: Double)
Parameters
coordinate
Decimal version of coordinate
Return Value
Tuple containing degrees, minutes, and seconds
-
Convert degrees minutes and seconds to decimal format
Declaration
Swift
public static func toDecimal(degrees: Double, minutes: Double, seconds: Double) -> Double
Parameters
degrees
Degrees of coordinate to convert
minutes
Minutes of coordinate to convert
seconds
Seconds of coordinate to convert
Return Value
Double representing decimal value of coordinate
-
Calculates the distance to the horizon.
Precondition
Planet radius must be in milesWarning
Doesn’t take refraction into accountDeclaration
Swift
public static func distanceToHorizon(atHeight: Double) -> Double
Parameters
atHeight
Height in feet
Return Value
Distance to the horizon (miles)
-
Calculates the distance to the horizon.
Precondition
Planet radius must be in kilometersWarning
Doesn’t take refraction into accountDeclaration
Swift
public static func distanceToHorizonMetric(atHeight: Double) -> Double
Parameters
atHeight
Height in meters
-
Calculate the time of sunset
Declaration
Swift
public static func sunsetTime(gps: GPS, date: Date, sunZenith: SunZenith) -> Date?
Parameters
gps
GPS
to find the time of sunset atdate
Date
on which to find the sunset time. (UTC)sunZenith
GPS.SunZenith
to calculate sunset time with. (Zenith specifies the angle of the sun. Official is when it just dips below the horizon)Return Value
Date of sunset (UTC). Null when no sunset on the given date.
-
Calculate the time of sunrise
Declaration
Swift
public static func sunriseTime(gps: GPS, date: Date, sunZenith: SunZenith) -> Date?
Parameters
gps
GPS
to find the time of sunrise atdate
Date
on which to find the sunrise time. (UTC)sunZenith
GPS.SunZenith
to calculate sunrise time with. (Zenith specifies the angle of the sun. Official is when it just breaks the horizon)Return Value
Date of sunset (UTC). Null when no sunrise on the given date.
-
Returns the duration of the day in seconds at a given GPS coordinate on a given day with a given sun zenith Calculate the duration of the day
Declaration
Swift
public static func dayDuration(gps: GPS, date: Date, sunZenith: SunZenith) -> Double
Parameters
gps
GPS
to calculate the day duration ofdate
Date
on which to calculate day duration (UTC)sunZenith
GPS.SunZenith
to calculate day duration with.Return Value
Duration of the day in seconds. 0 if there is no sunset or there is no sunrise.
-
Sun Zenith is used to describe the angle of the sun relative to the surface of earth for calculations involving sun phases.
See moreDeclaration
Swift
public enum SunZenith : Double


---
layout: archive
title: Archives
permalink: archives.html
---
Site index
This web site began in 2001 when it seemed like a good idea at the time.
Pages have accumulated as interests came and went. Here is a list to
try to make some order out of the collection.
- Veronica's Sheet Music Collection
- Peter's Minis -
- Family photos
- Home Education
and Teaching resources, ideas,
recommended reading and things like that. Lots of book reviews.
- Brandt Family Garb Guide
- Crochet a Thurible -- a safety
thurible for the aspiring thurifer.
- Knit some shepherds inspired by
Jean Greenhowe's cute dolls.
- Opustex installation and usage.
- Mastitis and all that my inexpert advice on
mastitis and its complications.
- Fabiola - the first few chapters online.
Also available as fabiolahtml.zip.
Blog Posts
In April 2012 the brandt Lab went all Wordpress-y. Now, October 2013, I'm having a go at migrating those posts back over into a Jekyll-y static site. The mastitis post above is still the most popular article, followed by how to use hotpotatoes in Wordpress. It still seems a bit odd to convert that one over to static.
{% for post in site.posts %}
- {{ post.date | date_to_string }} » {{ post.title }}
{% endfor %}


KMDBTC has had MASSIVE volume on Binance.
Chart is on Bittrex for a better history of it.
A move to resistance at 45k or so could be the makings of a beautiful cup and handle.
A break below 22k sats will cause it to potentially fall back to sub 20k.
This is a long term b...


CAUGHT A film review by James Berardinelli Copyright 1996 James Berardinelli
RATING (0 TO 10): 7.5 Alternative Scale: *** out of ****
United States, 1996 U.S. Release Date: undetermined Running Length: 1:59 MPAA Classification: R (Sex, nudity, violence, profanity) Theatrical Aspect Ratio: 1.85:1
Cast: Edward James Olmos, Maria Conchita Alonso, Arie Verveen, Bitty Schram, Steven Schub Director: Robert M. Young Producer: Richard Brick, Irwin Young Screenplay: Edward Pomerantz based on his novel, INTO IT Cinematography: Michael Barrow Music: Chris Botti
Because it lacks a precise ideological agenda, CAUGHT is something of a departure for veteran director Robert M. Young (NOTHING BUT A MAN..., DOMINICK AND EUGENE, SHORT EYES), a film maker known for socially and politically-motivated dramas. In fact, this is little more than an erotic, contemporary tale that plays like a Greek tragedy (OEDIPUS, to be exact). CAUGHT crossections a dysfunctional family whose uncomfortable stability is disturbed by the introduction of an outsider.
That outsider is Nick (Arie Verveen), a homeless Irish drifter trying to survive on the streets of Jersey City. Luck is with Nick, for when he ducks into a fish store to escape the police, the owners, Joe (Edward James Olmos) and his wife, Betty (Maria Conchita Alonso), take pity on him. They offer him a room, board, and $80 a week to work as Joe's assistant. Nick accepts, not intending to stay for long. But days turn into weeks, then months, and, soon, the young Irishman is more dear to Joe and Betty than their real son, Danny (Steven Schub), a failed standup comic who lives in Los Angeles.
Nick treats Joe like the father he never knew, but his feelings for Betty are more complex. Although he regards her as a mother at the outset, he is powerless to stop a growing attraction. Eventually, after one-too-many moments of hightened sexual awareness, their relationship is consummated. From that point on, Nick and Betty are all over each other at every opportunity. A further complication arises when Danny returns home with a wife and son to find that his place has been usurped.
CAUGHT examines psychological and emotional family bonds as they apply to the "real" son and the "adopted" one. The film also explores the most intense kind of sibling rivalry, a jealousy that is rooted in Oedipal impulses. Danny has many reasons to hate Nick, but he doesn't go over the edge until he recognizes the sexual nature of Nick and Betty's relationship.
The final scenes close the story in an unforgettably stark manner. Although a relentless premonition of doom hangs over this picture, we're still not quite prepared for the brutal twist of events that marks CAUGHT's climax. Even though the movie's overall arc is somewhat predictable, and occasionally melodramatic, it's impossible to deny the cumulative impact.
CAUGHT contains isolated moments of visual poetry that accomplish for fish displays what EAT DRINK MAN WOMAN did for food preparation. Joe teaches Nick the tricks of boning shad and placing snapper on ice in a manner that offers the greatest customer appeal. In his words, "it's a gimmick -- a gimmick and an art." Joe loves selling fish -- for him, it's more of a passion than a profession, and Nick's enthusiasm for it forms the basis of their relationship.
Edward James Olmos and Maria Conchita Alonso, both of whom worked with Young in ROOSTERS, are in fine form. Alonso radiates sexuality, and many of her scenes with newcomer Arie Verveen smolder, even when the two are fully clothed. Steven Schub occasionally overplays his bitterness, but, in general, his portrayal of Danny is a study of grief and anger born through personal and professional failure.
CAUGHT opens and closes with an image of fish caught in a net, struggling to escape. It's an apt metaphor, since all the characters in this film are trapped by fate in one way or another. Due primarily to its dark, unsettling tone, CAUGHT has yet to capture a distributor.
- James Berardinelli e-mail<EMAIL_ADDRESS>web: http://www.cybernex.net/~berardin (or) http://www2.cybernex.net/~berardin
The review above was posted to the
rec.arts.movies.reviews newsgroup (de.rec.film.kritiken for German reviews).
The Internet Movie Database accepts no responsibility for the contents of the
review and has no editorial control. Unless stated otherwise, the copyright
belongs to the author.
Please direct comments/criticisms of the review to relevant newsgroups.
Broken URLs inthe reviews are the responsibility of the author.
The formatting of the review is likely to differ from the original due
to ASCII to HTML conversion.
Related links: index of all rec.arts.movies.reviews reviews


{{ partial "header.html" . }}
{{ partial "head.html" . }} {{ partial "introduction.html" . }} {{ partial "talks.html" . }} {{ partial "podcasts.html" . }} {{ partial "publications.html" . }}
{{ partial "footer.html" . }}


WITNESS LIST Environmental Regulation Committee (Subcommittee on Environmental Education) May 21, 1998-9:30A Environmental Education For: Baxter, David (himself) Davies, Shannon (herself) Flanakin, Duggan (himself) Glazebrook, Catriana (herself/Audobon Soc.) Hahn, Jeff (Am Electr Assn/Motorola) Isleib, Jim (Tx Asn for Envt. Edu.) McFadden, Jackie (Sierra Club) Patton, Robert (himself/Audobon Soc.) Phillips, Glen L (himself/Tx Chem Cncil) Porter, Cathy (herself/Cons. Education) Tallent, Bobbie (NAAEE) Against: Bentley, H.R. Mickey (himself) On: Anderson, David D. (TEA) Cook, Don (himself/EE2000) Gosdin, John (himself/LCRA) Green, James F. (Jim) (himself) Hoppe, John (himself) Lester, Jim (himself/EE2000) Lilley, Floy J.D. (Free Enterprise) Neblett, Andrew (TNRCC/EE2000)


{% for article in article_list|slice:':1' %}
{% include "articles/snippets/article_ov_wide_span8.html" %}
{% endfor %}
{% for article in article_list|slice:'1:2' %}
{% include "articles/snippets/article_ov_wide_span4.html" %}
{% endfor %}
{% for article in article_list|slice:'2:3' %}
{% include "articles/snippets/article_ov_wide_span4.html" %}
{% endfor %}
{% for article in article_list|slice:'3:4' %}
{% include "articles/snippets/article_ov_wide_span8.html" %}
{% endfor %}
{% for article in article_list|slice:'4:5' %}
{% include "articles/snippets/article_teaser_item.html" %}
{% endfor %}
{% include "blocks/articles_popular.html" %}
{% for article in article_list|slice:'5:6' %}
{% include "articles/snippets/article_teaser_item.html" %}
{% endfor %}
{% for article in article_list|slice:'6:7' %}
{% include "articles/snippets/article_ov_wide_span12.html" %}
{% endfor %}
{% for article in article_list|slice:'7:8' %}
{% include "articles/snippets/article_teaser_item.html" %}
{% if not forloop.last %}
{% endif %}
{% endfor %}
{% include "blocks/programs_explore.html" %}
{% for article in article_list|slice:'8:9' %}
{% include "articles/snippets/article_teaser_item.html" %}
{% if not forloop.last %}
{% endif %}
{% endfor %}
{% include "blocks/gallery_carousel.html" %}
{% for article in article_list|slice:'9:10' %}
{% include "articles/snippets/article_teaser_item.html" %}
{% endfor %}
{% include "blocks/articles_blog_posts.html" %}
{% for article in article_list|slice:'10:11' %}
{% include "articles/snippets/article_teaser_item.html" %}
{% endfor %}
{% for article in article_list|slice:'11:15' %}
{% include "articles/snippets/article_ov_wide_span3.html" %}
{% endfor %}


Like SSAO, depth of field is an effect you can't live without once you've used it. Artistically, you can use it to draw your viewer's eye to a certain subject. But in general, depth of field adds a lot of realism for a little bit of effort.
The first step is to render your scene completely in focus. Be sure to render this into a framebuffer texture. This will be one of the inputs to the depth of field shader.
The second step is to blur the scene as if it was completely out of focus. Like bloom and SSAO, you can use a box blur. Be sure to render this out-of-focus-scene into a framebuffer texture. This will be one of the inputs to the depth of field shader.
For a great bokeh effect, dilate the out of focus texture and use that as the out of focus input. See dilation for more details.
Feel free to tweak these two parameters. All positions at or below minDistance
will be completely in focus. All positions at or beyond maxDistance
will be completely out of focus.
// ...
vec4 focusColor = texture(focusTexture, texCoord);
vec4 outOfFocusColor = texture(outOfFocusTexture, texCoord);
// ...
You'll need the in focus and out of focus colors.
You'll also need the vertex position in view space. You can reuse the position framebuffer texture you used for SSAO.
The focus point is a position somewhere in your scene. All of the points in your scene are measured from the focus point.
Choosing the focus point is up to you. The demo uses the scene position directly under the mouse when clicking the middle mouse button. However, it could be a constant distance from the camera or a static position.
// ...
float blur =
smoothstep
( minDistance
, maxDistance
, abs(position.y - focusPoint.y)
);
// ...
smoothstep
returns values from zero to one. The minDistance
is the left-most edge. Any position less than the minimum distance, from the focus point, will be in focus or have a blur of zero. The maxDistance
is the right-most edge. Any position greater than the maximum distance, from the focus point, will be out of focus or have a blur or one. For distances between the edges, blur will be between zero and one. These values are interpolated along a s-shaped curve.
The fragColor
is a mixture of the in focus and out of focus color. The closer blur
is to one, the more it will use the outOfFocusColor
. Zero blur
means this fragment is entirely in focus. At blur >= 1
, this fragment is completely out of focus.
(C) 2019 David Lettier
lettier.com


{% extends "base.html"%} {%load static%}{% block page_title %} Manage Employees {% endblock page_title %} {%block main_content%} Add New Employee S/N Employee Name Email Company Phone Edit Delete {% for employee in employees %} {{ forloop.counter}} {{ employee.first_name }} {{employee.last_name}} {{ employee.email }} {{ employee.company.name }} {{employee.phone_number}} {% endfor %} {%endblock main_content%} {% block custom_js %} {%endblock custom_js%}


Full
Address
{{this.addresses.fullAddress}}
Short
Address
{{this.addresses.shortAddress}}
Click to
Copy
Non Bounceable
Address
{{this.addresses.nonBounceableAddress}}


Selected: {{ selectedItem1 }}
Selected: {{ selectedItem2 }}
Selected: {{ selectedItem3 }}
Selected: {{ selectedItem4 }}
Selected: {{ selectedItem5 }}
Selected: {{ selectedItem6 }}


Section 1
email<EMAIL_ADDRESS>You will need a text editor and a browser.
Hack Google Search
JavaScript is a programming language for your browser. It is interpreted instead of compiled.
It was orginally created by Brendan Eich, who was born in Pittsburgh!!!
Each browser and device has its own implementation of JavaScript, but the ECMAScript specification is what guides JavaScript enhancements in each browser.
JavaScript is always updating.
MDN is a great reference.
Despite the constant changes, programming fundamentals ALWAYS STAY THE SAME!
window.prompt("Who is your favorite band?");
Let's write your first JavaScript program.
<!DOCTYPE html>

<title>Test Page</title>

This is my awesome JavaScript code.

You can mix JavaScript and HTML. The script tag tells your browser the stuff inside is code, not content.

You used the script tag.

Put your JavaScript in a separate file.
Just like CSS, you can split a long block of JavaScript into its own file.

That depends.

The instructions run line by line.
one at a time.
<!DOCTYPE html>

<title>Test Page</title>

This is my awesome JavaScript code.

document.write("Happy March!");
Inspect the element.
document.write("Happy March!");
document.write("And other stuff.");
That's the job of CSS.
<!DOCTYPE html>

<title>Test Page</title>
<link href="css/style.css" rel="stylesheet" />

This is my awesome JavaScript code.

It's time to talk about the DOM.
The DOM is a programming interface for HTML documents.
It represents the page so that programs can change the document structure, style, and content.
The DOM represents the document as nodes and objects.
<!DOCTYPE html>

<title>Test Page</title>

My Page

Hello World!

There is a list of commands that allow for access, creation, and modification.
Hack Google Search
Modified via the DOM
tag, id and class

Breaking News!

Traffic is backed up in the
Fort Pitt Tunnel!

Use only once on a page.
It's a specific target.
Also used for anchor links.
https://developer.mozilla.org/en-US/docs/Web/JavaScript#Tutorials
Use as many times as you would like.
// document.getElementsByTagName(tagName) - get list;
document.getElementsByTagName("a");
// document.getElementsByTagName(tagName)[number] - get 1;
document.getElementsByTagName("a")[0];
document.getElementsByTagName("img");
// document.getElementsByClassName(class) - get list;
document.getElementsByClassName("warning");
// document.getElementsByClassName(tagName)[number] - get 1;
document.getElementsByClassName("warning")[0];
document.getElementsByClassName("rISBZc");
// document.getElementById(id) - get 1;
document.getElementById("headline");
document.getElementById("dimg_6");
document.getElementById vs document.getElementsByClassName
The "s" is very important
If you can target an element.
You can change an element.
document.getElementsByTagName("a")[0].innerHTML = "Nailed it!";
document.getElementsByClassName("e2BEnf")[0].innerHTML="
COFFEE!
";
Every day, pick a random website.
Target the headline.
Change it.
Try it now.
Change styles via JavaScript
document.getElementsByTagName("body")[0].style.backgroundColor="orange";
document.getElementsByTagName("body")[0].style.backgroundColor="orange";
We are practicing targeting html elements via tag names, id's, and class names.
So we can manipulate them.


Click the city name to see the weather
Click
here
to reset
Weather in major cities
London
Paris
New York
Mumbai
Beijing
Sydney
Unknown
°Celsius
Unknown
°Fahrenheit


— 40 mg PTCDA - --50 mg PTCDA tote 60 mg PTCDA
© 100- 80-
aD oO 1
20-
Discharge capacity (mAh/g) BR oO
o+
120 ae ~ “ 110 iS an sunsaggocesscsssetce’???? mynen gees 100 g “ ee EOE 2490 oS 80 § “SAREE RANI 470 “O C/24 cio = CIs C2 60 & o 50 © 40 30 & —a— 40 mg PTCDA 20 5 —o— 50 mg PTCDA 5C 10 © —— 60 mg PTCDA 0 O r r —T Too 0 5 10 15 20 25 30 35
Number of cycles


Use the tool below to find your state legislators. Then, call or email them and urge them to implement state level internet privacy laws.
Dear [Your Legislator],
A bill in congress recently passed that opened the gates to allow Internet service providers to sell their customers data and Internet history to third parties. Though this was a deregulation of a previous bill, it is a major violation of the rights of consumers and leaves them exposed to have their data sold to third parties. The data people send over the Internet is sensitive, yet this recent bill is treating it as if it is not so, when in fact much of this data is private and confidential.
The only reason that such a bill passed is because Internet service providers, the only parties whom this would benefit, lobbied for this bill to pass without the best interest of their customers in mind. Arguments have been made that these regulations were unnecessary and suppressed the Internet service providers that it regulated, but this is a falsehood. Most Internet service providers are already monopolies, and as a result regulations are required to prevent these companies from abusing their customers without their knowledge.
The state of Minnesota has already passed a law that protects the consumer privacy that the bill sacrificed. Several other states have also followed suit. We too, should also protect consumer privacy and pass laws similar to that of Minnesota's.
As a concerned citizen of this state I urge you to consider the best interests of your constituents and push for a law to protect the privacy of the citizens of this state.
Sincerely,
[Your Name]