How-To Geek
How to change a drive letter on windows 10 or windows 11.
You can change your drive letters in Windows 10 and 11 using the Disk Management utility.
Quick Links
What changing a drive letter does, how to change a drive letter, how to fix programs broken by changing a drive letter.
Changing the letter of a drive is easy on Windows 10 and Windows 11, but you should do it as soon as you add the drive to prevent future hassles. Find out how to change a drive letter here.
Windows assigns drive letters alphabetically --- starting with C --- when they're initialized. If you want to change a drive letter, you should do it before you install anything on the drive. Changing a drive letter after programs are installed could break them since there will be references to an installation location that is no longer there.
Windows has gotten pretty smart about updating shortcuts so that programs work after changing a drive letter. Most of your applications' shortcuts will probably be automatically corrected. Unfortunately, Windows isn't as good about updating file associations. You'll have to manually set the default apps associated with files to fix file associations if they were broken by changing the drive letter.
It is possible to change the boot drive letter to something else, but we don't recommend it. Changing C:\ to another letter is likely to result in severe issues, like a PC that cannot boot into Windows at all. Even if it were able to boot, there would be a huge number of programs that would not be able to run.
Technically speaking, while they are commonly called drive letters, each letter actually refers to a partition on a disk. If you have multiple partitions on a single disk, you will need to assign a letter to each partition to make them all accessible. If a disk has just a single partition, it will just have a single letter pointing to that partition. (However, you do not have to assign a letter to each partition. Partitions without drive letters will not appear in File Explorer and elsewhere.)
Changing a drive letter is pretty simple. Click the Start button, type "Disk Management" in the search bar, and then hit Enter.
The program name displayed in the search will not be Disk Management. It will be "Create and format hard disk partitions."
You could also hit Windows+X or right-click the Start button, and then click "Disk Management."
Identify the drive you'd like to change in the Disk Management Window. In this example, we'll change the letter of the D:\ drive to J:\. You can right-click the drive on the text list, or on the menu below. Either works.
Select "Change Drive Letter and Paths" in the right-click menu that appears.
In the window that pops up, click "Change."
Select whatever letter you want from the drop-down menu. Then click "Ok."
Two popups will warn you about changing your drive letter. Click "Yes" on both of them, and then restart your computer.
Once Windows has restarted, the drive letter should be changed.
There are a few ways you can fix a program broken by changing the drive letter.
Fix The Shortcut
If you're lucky, the only thing that is broken is the shortcut. Fix a shortcut by right-clicking the shortcut on your desktop, and then click Properties.
You need to change the target of the shortcut to the new drive letter.
For example, if GIMP was previously installed at " D :\GIMP 2\bin\gimp-2.10.exe," and you changed the D drive to J, change the target of the shortcut to " J :\GIMP 2\bin\gimp-2.10.exe."
Finalize the change by clicking "Apply" and then "Ok."
Reinstall the Program
Reinstalling the program will generate new entries in the registry, so everything on the computer will know where to look for the program. Some installers won't like reinstalling directly over existing files, so you may need to rename or delete the old installation first.
Change the Drive Letter Back
If you changed the drive letter of a drive with a lot of programs installed, it might be easier to change the drive letter back. Changing the drive letter back should automatically fix any programs and file associations that were broken.
Edit the Registry
You can break programs, or even Windows itself, by editing the registry. Be careful, and learn about how to edit the registry before you try it. Make sure you backup the Windows registry first. You should not attempt this method unless you have no other options.
Windows, and a lot of programs, track where programs are installed via the Windows registry. It is possible to manually adjust the registry to fix broken programs. Keep in mind that there could be dozens of registry entries you need to edit. A program like GIMP can have registry entries for the context menu, for the "Open With" menu, for any file associations, and for the location of its executables. Other programs may only have a few entries related to where it is installed.
If you're not deterred, here's how you do it.
First, you need to know where the program was previously installed. In this case, the program was installed to the "D:\GIMP 2" folder, and the executables were found the "D:\GIMP 2\bin" sub-folder. It is now located at "J:\GIMP 2" instead.
We need to update the registry to reflect the change in location. Click the Start button, type "regedit" into the search bar, right-click Regedit, and click "Run as administrator."
In Regedit, hit Ctrl+F to bring up a search window. Type in the old location for the program you're trying to fix --- "D:\GIMP 2" for our example --- then click "Find Next."
Once Regedit has found something with "D:\GIMP 2" as part of a path, it'll show it to you. Here is an example from the GIMP search.
To actually change them, double click the name of the registry entry you want to modify. Then change the drive letter to J, or whatever you chose. If you didn't otherwise move the folder, leave the rest of the path alone. Then click "Ok."
You'll need to repeat this multiple times. To find the next result using your search term, you can hit the F3 key. There will be a popup once you've found all of the entries.
Changing drive letters can be a simple way to customize your PC. Do it before you install anything on the drive, however. You'll prevent any problems before they occur, and probably save yourself quite a bit of troubleshooting.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Change a drive letter
 - 4 contributors
Applies To: Windows 11, Windows 10, Windows Server 2022, Windows Server 2019, and Windows Server 2016
If you want to change a drive letter assigned to a drive, or you have a drive that doesn't yet have a drive letter, use Disk Management to change it. You can also mount the drive in an empty folder so that it appears as a folder. For more information, see Mount a drive in a folder .
If you change the drive letter of a drive that already contains Windows or apps, apps might have trouble running or finding the drive. We suggest not changing the drive letter of a drive that already contains Windows or apps.
The following steps show how to change the drive letter.
Open Disk Management with administrator permissions.
In Disk Management, select and hold (or right-click) the volume on which you want to change or add a drive letter and select Change Drive Letter and Paths .
Screenshot showing the Disk Management window with the Change Drive Letter and Paths feature selected.
If you don't see the Change Drive Letter and Paths option or it's grayed out, the volume either isn't ready to receive a drive letter or it's unallocated and needs to be initialized . It might also be that the drive isn't accessible, which is the case with EFI system partitions and recovery partitions. If you've confirmed that your volume is formatted with a drive letter that you can access but you're still unable to change it, that's beyond the scope of this article. We suggest contacting Microsoft Support or the manufacturer of your PC for more help.
To change the drive letter, select Change . To add a drive letter if the drive doesn't already have one, select Add .
Screenshot of the Change Drive Letter and Paths dialog.
Select the new drive letter and choose OK . Then select Yes when prompted about how programs that rely on the drive letter might not run correctly.
Screenshot of the Change Drive Letter or Path dialog that shows how to assign a new drive letter.
Submit and view feedback for
Additional resources
 - Shop 'Til You Drop
 - Our Picks: The Best Tech Gifts This Year
How to Change a Drive Letter
Don't like the letters assigned to your drives in Windows? Change them!
how to change a drive letter windows 10
 - Emporia State University
how to change a drive letter windows 10
 - The Ultimate Laptop Buying Guide
What to Know
 - Open Disk Management. Locate the drive you want to change. Right-click and choose Change Drive Letter and Paths > Change .
 - Select the drive letter you want to assign


text:
Function of water pump frequency converter
Pump inverter is to change the frequency and amplitude of the motor power supply to control the power transmission components of AC motor. The function of pump inverter is to improve the starting mode of three-phase AC motor and achieve the purpose of smooth control of pump motor speed.
Characteristics of water pump inverter
Design of constant pressure energy saving control for water pump
Built in PID and advanced energy saving software
It can realize multi-point pressure timing function of one support and one time division
High efficiency and energy saving, 20% ～ 60% power saving effect (depending on actual working conditions)
Simple management, safety protection and automatic control
Extend equipment life, protect power grid stability, reduce wear and reduce failure rate
Realize soft start and brake function
Working principle of water pump inverter
The pump inverter can also control the speed of single-phase asynchronous motor. The pump inverter can receive the two-phase current generated by the capacitor before.
Pump inverter is usually composed of rectifier unit which converts alternating current into direct current and feeds DC intermediate circuit or DC voltage intermediate circuit, and inverter which feeds by intermediate circuit. The inverter can output the stop chord voltage of the desired frequency and interval. When driving the three-phase AC motor of frequency converter, it can provide stepless acceleration from zero to rated speed without torque reduction. Because the pump inverter will produce strong electrical interference signal on the motor power line, it is usually necessary to shield the pump inverter. In addition, a sine wave filter can be installed between the pump frequency converter and the pipeline booster pump motor to convert the PEM wave from the frequency conversion output into a sine wave.
Editor in charge: yyx

source: m-a-p/FineFineWeb


text:
Source Organization: Edinburgh Centre for Carbon Management and UN Environment Program
This tool from the Edinburgh Cenre for Carbon Management and UNEP helps business assess the quality of their systems for Carbon Management; that is, their ability to respond effectively and efficiently to the risks and opportunities that climate change presents. This tool is for companies with an interest in maintaining or strengthening their environmental reputation and/or those whose business that may be affected by policies intended to address climate change. CAMSAT comprises 23 multiple-choice questions in 5 sections, covering the major aspects of carbon management (Assessment and Monitoring of GHG Emissions; Emission Reducing Activities; Carbon Offset Strategies; Communication and Reporting; and Assessment of Carbon Risks and Opportunities). The results of the test will give company's an overall score and identify areas that may require further attention. The exercise takes about 30 minutes to complete.

source: openbmb/Ultra-FineWeb


text:
Toward definition of the structure of work: The development of a general-purpose job analysis instrument
Lynskey, Michelle C.
Howell, William C.; Autrey, Herbert S.
Doctor of Philosophy
The purpose of the current investigation was to develop and validate a general-purpose job analysis questionnaire capable of analyzing all types and levels of jobs, and to use this questionnaire as a means to investigate the underlying structure of work. The instrument was developed using existing items from the Job Element Inventory (Cornelius & Hakel, 1978) and managerial, supervisory, executive, and professional items which were based on dimensions reported in the literature. After completion of a pilot study, the questionnaire was administered to incumbents from a sample of jobs from various public and private sector organizations, resulting in the collection of 395 questionnaire responses. The job ratings were subjected to an exploratory factor analyses, and five overall and 28 divisional dimensions were interpreted. A policy-capturing approach was used to assess the validity of the questionnaire; R$\sp2$s ranged from.38 to.68. A confirmatory factor analysis investigated the following competing hypotheses of work structure. (1) The dimensionality of work resembles three dimensions: Working with People and Data, Physical Activities and Related Environmental Conditions, and Using Machines and Equipment. This structure is similar to Fine and Wiley's (1971) theory of work, which includes three factors: Data, People, and Things. (2) The dimensionality of work resembles six dimensions: Information Input, Mental Processes, Work Output, Relationships with Other Persons, Job Context, and Other Job Characteristics. These dimensions resemble information-processing theory and the a-priori divisions used by McCormick, Jeanneret, & Mecham (1977) to catagorize work. A covariance analysis confirmed the first two factors of the first hypothesis, but only three of the factors from the second hypothesis. Implications of these findings are discussed.


text:
Sat| 8.15am | Grade 3+ | Maximum 12 walkers | $55 | NEW
A rare opportunity to walk amongst the ancient limestone karst rocks formed eons ago on the seafloor before rising up above the ocean to be sculpted over millions of years into wondrous forms. See cave entrances and tomos that lead into the darkness below the ground.
The forest is some of the most biologically diverse native bush in the region with large stands of tall nikau and many rare plant species growing in a diverse range of microclimates. Home to kauri snails, many species of cave wētā and cave harvestman.
Cross over the rocky bottom stream where freshwater mussel, Hochstetter's frogs, kōura and bioluminescent freshwater limpets live. Experience a little of this privately owned park prior to official opening. There will be no access to caves on this walk.
Degree of difficulty Some steep climbs on newly formed paths
Equipment (What to bring) Good boots and poles essential. Bring morning tea, lunch, water
Meet up time 8.15 Saturday at the Domain
Transport to/from start of walk Bus
Duration to/from Domain 5-6 hours (including 1 hour travel time each way)
Cost $55 (including transport)


Click here to Skip to main content
11,576,354 members (59,757 online)
Click here to Skip to main content
An O(ND) Difference Algorithm for C#
, 14 Mar 2006 140K 3.9K 138
Rate this:
Please Sign up or sign in to vote.
This article is about comparing text files, and the best and most famous algorithm to identify the differences between them.
Introduction
This article is about comparing text files, and the best and most famous algorithm to identify the differences between them. The source code that you can find in the download implements a small class with a simple to use API that does this job. You must have this in your collection of algorithms.
Besides the class that implements the algorithm, there is also a sample web application that compares two files and generates an HTML output with a combined and colored document.
The algorithm was first published 20 years ago under the title "An O(ND) Difference Algorithm and its Variations" by Eugene Myers, Algorithmica Vol. 1 No. 2, 1986, p 251. You can find a copy if it here. In this article, you can find an abstract recursive definition of the algorithm, using some pseudo-code that needs to be transferred to an existing programming language.
There are many C, Java, and Lisp implementations publicly available of this algorithm out there on the internet. Before I wrote the C# version, I discovered that almost all these implementations came from the same source (GNU diffutils) that is available under the (unfree) GNU public license and therefore cannot be reused as a source code for commercial or redistributable application, without being trapped by the GNU license.
There are very old C implementations that use other (worse) heuristic algorithms. Microsoft also published the source code of a diff-tool (WinDiff) that uses some tree structures. Also, a direct transfer from a C source to C# is not easy because there is a lot of pointer arithmetic in the typical C solutions, and I wanted a managed solution. I tried a lot of sources, but found no usable solution written for the .NET platform.
These are the reasons why I implemented the original published algorithm from scratch, and made it available without the GNU license limitations, under a Creative Commons Attribution 2.0 Germany License. The history of this implementation traces back to 2002 when I published a Visual Studio add-in that also compares files, see Visual Studio 2005 Add-in that adds diff tools, an explore command, subversion support, and web project reporting. I couldn't find any bugs in the last 3 years, so I think the code is pretty stable.
I didn't need a high performance diff tool. I will do some performance tweaking as and when needed, so please let me know. I have also dropped some hints in the source code on that topic.
How it works (briefly)
You can find an online working version of the download files here.
 - Comparing the characters of two huge text files is not easy to implement and tends to be slow. Comparing numbers is much easier, so the first step is to compute unique numbers for all the text lines. If the text lines are identical then identical numbers are computed.
 - There are some options that need to be considered before computing these numbers, which are normally useful for some kind of text: stripping off space characters and comparing case insensitive.
 - The core algorithm itself will compare two arrays of numbers, and the preparation is done in the private DiffCodes method and by using a Hashtable.
 - The methods are DiffText and DiffInts.
 - The core of the algorithm is built using two methods:
 - LCS: This is the divide-and-conquer implementation of the longest-common-subsequence algorithm.
 - SMS: This method finds the Shortest Middle Snake.
 - To get some usable performance, I did some changes to the original algorithm. The original algorithm was described using a recursive approach, and compares zero indexed sequences, and passes parts of these sequences as parameters. Extracting sub-arrays and rejoining them is very CPU and memory intensive. To avoid copying these sequences as arrays around, the used arrays together with the lower and upper bounds are passed while the sequences are not copied around all the time. This circumstance makes the LCS and SMS functions more complicate.
 - I added some code to the LCS function to get a fast response on sub-arrays that are identical, completely deleted, or inserted instead of recursively analyzing them down to the single number case.
 - The result is stored in two arrays that flag for modified (deleted or inserted) lines in the two data arrays. These bits are then analyzed to produce an array of objects that describe the found differences.
 - Read the original article if you want to understand more.
The API
To use this functionality, you only have to call one of the DiffText methods. They all get a pair of strings, and return an array of items that describe the inserts and deletes between the two strings. There are no "changes" reported. Instead, you can find an "insert" and "deleted" pair.
DiffText(string TextA, string TextB)
Finds the difference between two texts, comparing by text lines without any conversion. An array of items containing the differences is returned.
DiffText(string TextA, string TextB, bool trimSpace, bool ignoreSpace, bool ignoreCase)
Finds the difference between two texts, comparing by text lines with some optional conversions. An array of items containing the differences is returned.
Diff(int[] ArrayA, int[] ArrayB)
Finds the difference between two arrays of integers. An array of items containing the differences is returned.
A sample application for the algorithm
The sample is a small web application that calculates the difference between two text files and displays the result using HTML.
To setup the sample, you have to create a web-project and copy all the files found in the zip file into the directory. The implementation of the algorithm is given inside the "diff.cs" class.
Further possible optimizations (if you really need speed)
(First rule: don't do it; second: don't do it yet.)
The arrays DataA and DataB are passed as parameters, but are never changed after the creation, so they can be used as members of the class to avoid parameter overhead. In the SMS, there is a lot of boundary arithmetic in the for-D and for-k loops that can be done by incrementing and decrementing the local variables. The DownVector and UpVector arrays are always created and destroyed each time the SMS gets called. It is possible to reuse them when transferring them to members of the class.
See TODO: hints.
Security issues with the web application
 - Using this web-site implementation enables clients to view all the source code of your website. Just be sure that you do not use it as-it-is on a public server.
 - You should implement a check of the parameters, and allow only a diff output on the files that can be displayed (text based files).
License
This work is licensed under Creative Commons Attribution 2.0 Germany License.
Built-in self-test
The class now has a built-in self-test, that works without changing the code. If you compile the diff and debug class files together, you get an EXE file that tests some simple diff-scenarios that were used to discover the bugs in versions 1 and 2 (OutOfArrayBounds typically).
The compile command is:
csc /target:exe /out:diffTest.exe /debug /d:SELFTEST Diff.cs Debug.cs
Thanks for your feedback and the two reported cases that did not diff correctly. (It was always my fault, not a problem of the algorithm).
History
This work was first published here.
 - 2002.09.20
 - There was a "hang" in some situations.
 - Now, I understand a little bit more of the SMS algorithm.
 - There have been overlapping boxes; those where analyzed differently. One return-point is enough.
 - An assertion was added in CreateDiffs when in debug-mode, that counts the number of equal (not modified) lines in both arrays. They must be identical.
 - 2003.02.07
 - Out of bounds error in the Up/Down vector arrays in some situations.
 - The two vectors are now accessed using different offsets that are adjusted using the start k-Line.
 - A test case is added.
 - 2003.04.09
 - Another test that threw an exception was found, but that seems to be fixed by the 2002.09.20 work.
 - 2006.03.10
 - Refactored the API to static methods on the diff class to make the usage simpler.
 - The self test is now using the standard debug class.
License
This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.
A list of licenses authors might use can be found here
Share
About the Author
Matthias Hertel
Architect Deutsche Bank AG
Germany Germany
see _URL_
You may also be interested in...
Comments and Discussions

GeneralMy vote of 5 Pin
Member 96680539-Jun-13 22:56
memberMember 96680539-Jun-13 22:56
QuestionWinForm or WPF version Pin
Member 78411351-Oct-12 11:13
memberMember 78411351-


text:
Estonian Museum Association
Muuseumi tee 2, Tartu, tel _PHONE_
Hiiumaa Museum was established during the reign of Kassari Manor located in the isle of Kassari, the fifth biggest island in Estonia with the size of 19 km2. After the construction of the Long House in 1998 it became the place for the permanent exposition of Hiiumaa with such hits as "The Last Wolf of Hiiumaa", the prism of Tahkuna lighthouse, a lifeboat from motor ship "Estonia" and other items concerning the ethnography, cultural history and nature of Hiiumaa.
Back to the list


text:
Young people are our future innovators
The NSTF promotes science, engineering, technology, (SET), including mathematics and innovation among the youth. This is important because
- SET subjects open doors for learners to pursue fulfilling careers
- The future of SET and innovation depends on young people being inspired to explore the subjects, study courses and exciting careers that exist already, and the new ones that will exist in future
The NSTF promotes SET among the youth in the following ways:
- The Brilliants programme celebrates the top performers in matric maths and science, and aims to motivate and inspire them to continue with studies for SET-related careers
- The Share 'n Dare programme creates platforms for top researchers and other SET professionals to inform and inspire high school learners and university students
- The Bursary database for SET-related studies collects bursary information so that SET-related study funding can be found in one place for easy access.
- The details of 50 SET career paths gives information for learners and students on SOME of the many great careers that can be pursued
- Financial contributions towards projects that promote SET education and awareness, through the proSET (professional associations) sector of the NSTF
Youth projects previously implemented by NSTF:
- National Youth Service (NYS) programme (on behalf of the Department of Science and Technology (DST)) which provides opportunities for work experience to previously unemployed young SET graduates. NSTF managed the NYS programme from 2007 to 2012. Anyone interested in the current programme can contact SAASTA, which is part of the National Research Foundation.
- Incentive Bursary Scheme for undergraduate students in SET studies (on behalf of the Department of Science and Technology) which provided study support to about 70 students from 2008 to 2015. (The programme has now been phased out by the DST).


text:
E. Cobham Brewer _PHONE_. Dictionary of Phrase and Fable. 1898.
An arrow. The feathers under the beak of a hawk were called barb feathers (beard feathers). The point of an arrow has two iron feathers, which stick out so as to hinder the extraction of the arrow. (Latin, barba, a beard.)
N.B.The barb is not the feather on the upper part of the shaft, but the hooked iron point or head.

source: HuggingFaceFW/fineweb-edu


text:
When photography was first introduced and became popular, it was a lengthy process, with prolonged exposure times and the requirement for the sitter to remain still throughout the process. This proved to be particularly difficult when dealing with children, and photographers often dreaded their visits to their studios. Neck and back braces might be used to help to prevent the child from moving during the photography, and this helps to explain the rather fixed look on the faces of many children.
As exposure times shortened, children were photographed more frequently. Wealthy families had their children photographed at least once a year to record growth, and important stages in development were symbolised by a change in clothing style. Little boys wore dresses until about the age of five, then short trousers until about twelve, when they adopted long trousers like adult men. The age of girls was indicated by the length of their skirts: short for little girls, calf-length for teenagers, and ankle length after 17, when they were considered grown up.
Full item descriptions:
"Victorian photograph" [i159], Midwinter, W H
"Victorian photograph" [i160], Haddy, W
"Victorian photograph" [i162], Hawkins, C
"Victorian photograph" [i163], Taylor, A & G
"Victorian photograph" [i164], White, Sydney Victor
"Victorian photograph" [i165], Edwards, B J
"Victorian photograph" [i166], Turnbull & Sons
"Victorian photograph" [i167], Elliott & Fry
"Victorian photograph" [i168], Banks, R


Entity API
Describes how to define and manipulate content and configuration entities.
Entities, in Drupal, are objects that are used for persistent storage of content and configuration information. See the Information types topic for an overview of the different types of information, and the Configuration API topic for more about the configuration API.
Each entity is an instance of a particular "entity type". Some content entity types have sub-types, which are known as "bundles", while for other entity types, there is only a single bundle. For example, the Node content entity type, which is used for the main content pages in Drupal, has bundles that are known as "content types", while the User content type, which is used for user accounts, has only one bundle.
The sections below have more information about entities and the Entity API; for more detailed information, see _URL_
Defining an entity type
Entity types are defined by modules, using Drupal's Plugin API (see the Plugin API topic for more information about plugins in general). Here are the steps to follow to define a new entity type:
 - Choose a unique machine name, or ID, for your entity type. This normally starts with (or is the same as) your module's machine name. It should be as short as possible, and may not exceed 32 characters.
 - Define an interface for your entity's get/set methods, extending either \Drupal\Core\Config\Entity\ConfigEntityInterface or \Drupal\Core\Entity\ContentEntityInterface.
 - Define a class for your entity, implementing your interface and extending either \Drupal\Core\Config\Entity\ConfigEntityBase or \Drupal\Core\Entity\ContentEntityBase, with annotation for @ConfigEntityType or @ContentEntityType in its documentation block.
 - The 'id' annotation gives the entity type ID, and the 'label' annotation gives the human-readable name of the entity type. If you are defining a content entity type that uses bundles, the 'bundle_label' annotation gives the human-readable name to use for a bundle of this entity type (for example, "Content type" for the Node entity).
 - The annotation will refer to several controller classes, which you will also need to define:
 - For content entities, the annotation will refer to a number of database tables and their fields. These annotation properties, such as 'base_table', 'data_table', 'entity_keys', etc., are documented on \Drupal\Core\Entity\EntityType. Your module will also need to set up its database tables using hook_schema().
 - For content entities that are displayed on their own pages, the annotation will refer to a 'uri_callback' function, which takes an object of the entity interface you have defined as its parameter, and returns routing information for the entity page; see node_uri() for an example. You will also need to add a corresponding route to your module's routing.yml file; see the node.view route in node.routing.yml for an example, and see Entity routes below for some notes.
 - Define routing and links for the various URLs associated with the entity. These go into the 'links' annotation, with the link type as the key, and the route machine name (defined in your module's routing.yml file) as the value; see Entity routes below for some routing notes. Typical link types are:
 - canonical: Default link, either to view (if entities are viewed on their own pages) or edit the entity.
 - delete-form: Confirmation form to delete the entity.
 - edit-form: Editing form.
 - admin-form: Form for editing bundle or entity type settings.
 - Other link types specific to your entity type can also be defined.
 - If your content entity has bundles, you will also need to define a second plugin to handle the bundles. This plugin is itself a configuration entity type, so follow the steps here to define it. The machine name ('id' annotation) of this configuration entity class goes into the 'bundle_entity_type' annotation on the entity type class. For example, for the Node entity, the bundle class is \Drupal\node\Entity\NodeType, whose machine name is 'node_type'. This is the annotation value for 'bundle_entity_type' on the \Drupal\node\Entity\Node class. Also, the bundle config entity type annotation must have a 'bundle_of' entry, giving the machine name of the entity type it is acting as a bundle for.
 - Additional annotations can be seen on entity class examples such as \Drupal\node\Entity\Node (content) and \Drupal\user\Entity\Role (configuration). These annotations are documented on \Drupal\Core\Entity\EntityType.
Entity routes
Entity routes, like other routes, are defined in *.routing.yml files; see the Menu and routing topic for more information. Here is a typical entry, for the block configure form:
block.admin_edit:
 path: '/admin/structure/block/manage/{block}'
 defaults:
 _entity_form: 'block.default'
 _title: 'Configure block'
 requirements:
 _entity_access: 'block.update'
Some notes:
 - path: The {block} in the path is a placeholder, which (for an entity) must always take the form of {machine_name_of_entity_type}. In the URL, the placeholder value will be the ID of an entity item. When the route is used, the entity system will load the corresponding entity item and pass it in as an object to the controller for the route.
 - defaults: For entity form routes, use _entity_form rather than the generic _content or _form. The value is composed of the entity type machine name and a form controller type from the entity annotation (see Defining an entity type above more more on controllers and annotation). So, in this example, block.default refers to the 'default' form controller on the block entity type, whose annotation contains:
 controllers = {
 "form" = {
 "default" = "Drupal\block\BlockForm",

Defining a content entity bundle
For entity types that use bundles, such as Node (bundles are content types) and Taxonomy (bundles are vocabularies), modules and install profiles can define bundles by supplying default configuration in their config/install directories. (See the Configuration API topic for general information about configuration.)
There are several good examples of this in Drupal Core:
Loading, querying, and rendering entities
To load entities, use the entity storage manager, which is an object implementing \Drupal\Core\Entity\EntityStorageInterface that you can retrieve with:
$storage = \Drupal::entityManager()->getStorage('your_entity_type');
// Or if you have a $container variable:
$storage = $container->get('entity.manager')->getStorage('your_entity_type');
Here, 'your_entity_type' is the machine name of your entity type ('id' annotation on the entity class), and note that you should use dependency injection to retrieve this object if possible. See the Services and Dependency Injection topic for more about how to properly retrieve services.
To query to find entities to load, use an entity query, which is a object implementing \Drupal\Core\Entity\Query\QueryInterface that you can retrieve with:
// Simple query:
$query = \Drupal::entityQuery('your_entity_type');
// Or, if you have a $container variable:
$query_service = $container->get('entity.query');
$query = $query_service->get('your_entity_type');
If you need aggregation, there is an aggregate query avaialable, which implements \Drupal\Core\Entity\Query\QueryAggregateInterface:
$query \Drupal::entityQueryAggregate('your_entity_type');
// Or:
$query = $query_service->getAggregate('your_entity_type');
Also, you should use dependency injection to get this object if possible; the service you need is entity.query, and its methods getQuery() or getAggregateQuery() will get the query object.
In either case, you can then add conditions to your query, using methods like condition(), exists(), etc. on $query; add sorting, pager, and range if needed, and execute the query to return a list of entity IDs that match the query.
Here is an example, using the core File entity:
$fids = Drupal::entityQuery('file')
 ->condition('status', FILE_STATUS_PERMANENT, '<>')
 ->condition('


text:
The FLXA402 offers multiple connection possibilities, eliminating the need for multiple analyzers and providing greater flexibility. This four-wire analyzer includes a color HMI and an easy touchscreen operation with a simple menu structure in 9 languages for simple and efficient setup and configuration.
With its modular design, the FLXA402 analyzer offers a range of measurement choices with the respective sensor module, including pH/ORP, resistivity/conductivity (SC), inductive conductivity (ISC), percent concentration, dissolved oxygen (DO), and 4-20mA input. Dual sensor measurements offer additional functionalities, such as a calculated data function that can be customized.
Support of Up to Five Sensors
The FLXA402 can connect up to five sensors, realizing interruption-free measurement even during maintenance. Multiple sensor measurement offers additional functionalities including a variety of calculated data as well as the option to program the analyzer as a redundant system.
With the FLXA402, one analyzer can accept: pH/ORP, Contacting Conductivity (SC), Inductive Conductivity (ISC), Dissolved Oxygen (DO), and Optical Dissolved Oxygen Sensors with self-diagnostic capabilities. Additional functions include:
- Continuous measurement of sensor impedance, asymmetric potential, and slope, and continuous monitoring for electrode contamination/damage, burnout, and a decline in measurement liquid level (ex. pH Analyzer)
- Online Sensor Wellness checking for predictive maintenance
Expert Guide: Clear Touch Panel Display for Improved Operability
The FLEXA™ series analyzer provides improved operability with intuitive touchscreen operation, featuring a clear display and user-friendly indication with 9 languages. The display of sensor status and estimated maintenance time improve efficiency. The interactive screen is housed in a robust aluminum die-cast housing.
Advanced Flexibility: Modular Design for Increased Scalability
The FLEXA™ series analyzer features a modular design with replaceable sensor modules, enabling the construction of a variety of systems. FLXA402 allows for the connection of up to five possible sensors resulting in a reduction in CAPEX and OPEX.
Preparing for the Future
Industrial automation is moving toward SMART products, with sensors changing from analog to digital SMART. This transition can affect plant operations and take time to fully implement.
In addition to being a high performance standalone analyzer, the FLXA402 is also a component of the new Yokogawa SENCOM 4.0 Platform, a SMART sensor system that simplifies in field maintenance and calibration. With the SENCOM 4.0 Platform, upgrading to the next generation SMART product is easy, and an upgrade transfer can be done at any time with little impact on operations.
SD card or Ethernet for easy data transfer and remote service, allowing for more in-depth process analysis.
Yokogawa's Optical Dissolved Oxygen Sensors offer reduced maintenance time and longer maintenance cycles for efficient process optimization.
Questionable flow and conductivity measurements during CIP could raise questions about food quality and safety.
SMART digital sensors and advanced data management software enhance reliability and process safety.
In today's tightening orange juice market, facilities must improve efficiency to deliver high-quality products. With that goal in mind, a leading U.S. juice and citrus processor uses or sells each part of the orange. Nothing goes to waste. In the drive to improve efficiency, the juice and citrus products producer needed a reliable partner to help determine ways to reduce maintenance costs and deliver high returns. The producer selected Yokogawa products such as the EJAC80E Diaphragm Seal System with DPharp sensor technology for level control and monitoring, ADMAG AXG magnetic flow meters (magmeters) for flow measurement, and FLXA402 analyzers for pH and conductivity monitoring.
Having too much oxygen in the process is not a problem for the biological system; however the cost for generating the oxygen is one of the largest expenses. By obtaining a good representative average of the dissolved oxygen present in the basin could save the plant large amounts of money. For this reason multiple measurements points are sometimes put into place.
For control of batch neutralization, a pH measurement coupled with a timer-controlled chemical feed scheme provides very satisfactory results.
This system can be adapted for either acid waste or alkaline waste neutralization.
Where and why are the pH Measurements important in a brewery? No one wants a skunky beer. pH measurements in the wort, during mashing/souring the malt, and in the yeast enzymes are critical.
Ion Exchange is a method for the exchange of ions between two electrolytes or between an electrolyte solution and a complex molecule. In most cases the term is used to denote the processes of purification, separation, and decontamination of aqueous and other ion-containing solutions with solid polymeric or mineralic ion exchangers.
Problems at the wet end of a paper machine can rarely be corrected downstream. That is why monitoring and controlling pH in pulp stock is critical to the paper-making process. Essentially, at every stage in the manufacture of paper, correct pH values play a vital role. Variations in the pH value at the headbox have a negative effect on the quality of the paper produced. Proper monitoring ensures minimizing plugging and fouling problems that occur with pH measurements in paper mills.
Process liquid analyzers such as pH meters, conductivity meters, ORP meters, and density meters play an important role at electrolysis plants in the control of concentrations of various process solutions. This requires both precision and stability under harsh conditions that include highly corrosive substances, high temperatures, and many impurities.
The kraft process, also known as kraft pulping or the sulfate process, is a technology for conversion of wood into wood pulp that consists of almost pure cellulose fibers. Today, the kraft process is used in approximately 80% of paper production.
In a semiconductor plant, a variety of chemicals are used in various manufacturing processes. The chemicals used for specific purposes are produced by diluting raw liquid with demineralized water using in diluting equipment, and the control of the concentration at this point is performed by conductivity measurement.
The treatment of wastewater from pulp and paper plants is a serious environmental concern. Yokogawa's submersion holder with an ultrasonic+air-jet cleaner (customized product) can reduce the manual cleaning frequency to just once every one or two months.
Wastes have been considered to be a serious worldwide environmental problem in recent years. Because of increasing pollution, these wastes should be treated. However, industrial wastes can contain a number of valuable organic components. Recovery of these components is important economically. Using conventional distillation techniques, the separation of acetic acid and water is both impractical and uneconomical, because it often requires large number of trays and a high reflux ratio. In practice special techniques are used depending on the concentration of acetic acid.
Clean-in-place (CIP) is the system designed for automatic cleaning and disinfecting in the food & beverage, pharmaceutical, and chemical industries. Tanks and piping are cleaned and sterilized with various cleaning solutions, fresh or hot water, or steam after manufacturing products is completed.
The quality of paper for printing or writing should be high and it depends on many parameters. Cobb is one of the parameters, which requires control. Using a retractable fitting, this optimum pH level can be achieved by using Yokogawa's 4-wire pH Analyzer with a suitable, retractable fitting and sensor. Since a separate controller is not required for the dosing pump, this solution provides a cost-saving.
Cyanide-bearing wastewater from mining and electroplating facilities and certain types of chemical plants is toxic and must be treated by oxidation with chlorine or chloride to bring the cyanide concentration within regulatory limits.
Industry:Electrical and Electronics
Continuous technology improvement is ongoing in the pulp & paper industry to obtain the best possible performance. Problems at the wet end (stock preparation) can rarely be corrected downstream. That is why monitoring and controlling pH in pulp stock is critical to the paper making process. Essentially, at every stage in the manufacture of paper, correct pH values play a vital role.
Reverse osmosis (RO) is a separation process that uses pressure to force a solution through a membrane that retains the solute on one side and allows the pure solvent to pass to the other side. More formally, it is the process of forcing a solvent from a region of high solute concentration through a membrane to a region of low solute concentration by applying a pressure in excess of the osmotic pressure.
Wastewater from electroplating facilities and certain types of chemical plants contains toxic forms of hexavalent chromium such as chromate and dichromate. The hexavalent chromium in this wastewater must be reduced before the water can be discharged. This requires a two-step process: hexavalent chromium (CR6) is reduced to trivalent chromium (CR3); and CR3 is precipitated as chromium hydroxide.
Industry:Electrical and Electronics
Removal of free oil and grease from a wastewater stream reduces the potential for equipment problems downstream. Three forms of oil are encountered in wastewater treatment at a refinery: Free Oil, Emulsified Oil, Dissolved Oil.
Sour Water is the wastewater that is produced from atmospheric and vacuum crude columns at refineries. Hydrogen sulfide and ammonia are typical components in sour water that need to be removed before the water can be reused elsewhere in the plant. Removal of these components is done by sending the sour water from the process to a stripping tower where heat, in the form of steam, is applied.
Power plant boiler houses designed to burn coal or high sulfur oil are required by Federal and State pollution


text:
online fashion. The method is illustrated on a 5-link RABBIT model, and is shown to allow the robot to walk safely while utilizing controllers designed in an online fashion.
Autonomous mobile robots must operate with limited sensor horizons in unpredictable environments. To do so, they use a receding-horizon strategy to plan trajectories, by executing a short plan while creating the next plan. However, creating safe, dynamically-feasible trajectories in real time is challenging; and, planners must ensure that they are persistently feasible, meaning that a new trajectory is always available before the previous one has finished executing. Existing approaches make a tradeoff between model complexity and planning speed, which can require sacrificing guarantees of safety and dynamic feasibility. This work presents the Reachability-based Trajectory Design (RTD) method for trajectory planning. RTD begins with an offline Forward Reachable Set (FRS) computation of a robot's motion while it tracks parameterized trajectories; the FRS also provably bounds tracking error. At runtime, the FRS is used to map obstacles to the space of parameterized trajectories, which allows RTD to select a safe trajectory at every planning iteration. RTD prescribes a method of representing obstacles to ensure that these constraints can be created and evaluated in real time while maintaining provable safety. Persistent feasibility is achieved by prescribing a minimum duration of planned trajectories, and a minimum sensor horizon. A system decomposition approach is used to increase the dimension of the parameterized trajectories in the FRS, allowing for RTD to create more complex plans at runtime. RTD is compared in simulation with Rapidly-exploring Random Trees (RRT) and Nonlinear Model-Predictive Control (NMPC). RTD is also demonstrated on two hardware platforms in randomly-crafted environments: a differential-drive Segway, and a car-like Rover. The proposed method is shown as safe and persistently feasible across thousands of simulations and dozens of hardware demos.


text:
- Category and information on auxiliary craft specific to Star Trek: Phoenix-X continuity. These may be separated into individual articles as more information becomes available.
USS Angel WingEdit
The USS Angel Wing was a Starfleet classified experimental shuttle that primarily focused on medical servicing and test-bed technologies. Some of its designed medical devices were Borg influenced. The shuttle was built and designed by the Section 31 select Corps of Engineers, and would eventually be destroyed by the Fragma Alliance techship, Trance, in 2383. ("Secret Shuttles, Part I", "Transphasic Meltdown")
The USS Paroga (or USS Paroga-X) was a transwarp capable vessel developed by the tech-team, a group of brainwashed individuals from Starfleet Corps of Engineers. It was eventually taken to Section 31 by Lieutenant Wallace. ("Secret Shuttles, Parts I & IV")
The USS Phoenix-X's 8 Hellonesian JumpersEdit
The Phoenix-X's 8 Hellonesian Jumpers were 8 fighter-type space craft, with advanced Hellonesian-type weaponry. They were traded off from a Larvekken freighter; an exchange that was arranged by Admiral Theseus, in 2377. The small craft were useful in missions and in combat. Instead of individual names, each craft were numbered, i.e. Jumper 1, Jumper 2, Jumper 3, etc. In 2378, one of the Jumpers was destroyed in battle with a Borg cube. ("Jumpers, Part I", "Destiny's Revenge, Part II", "The Timeship")
|Star Trek: Phoenix-X lists|
|astronomy | auxiliary craft | characters | science | sectors | series timeline | society and culture | space stations | starships | technology | uniforms|


bender
What is the Difference Between a Pipe and Tube Bender?
What's the difference between a tube bender and a pipe bender? is one of the inquiries we occasionally get. In a similar vein, we occasionally are asked to define the distinction between pipe and tube in general.
tube
There isn't much of a distinction between a pipe bender and a tube bender. Pipes can be bent by machines in the same way that tubes can.
The only exceptions to this rule would be for piping and tubes that are extremely huge or small.
Even yet, in this situation you would need a machine that could handle either specification whether the material being bent was a pipe or a tube because it wouldn't matter if it was very huge or very little.
There is a distinction between a tube and a pipe, despite the fact that there is no distinction between a pipe and a tube bending machine. It turns out that identifying that distinction can be a little challenging.
You may obtain a lot of information on tube vs. pipe by conducting a quick internet search. According to conventional belief, the disparity can be attributed to how they are measured. The internal diameter of a pipe is measured, whereas the outward diameter of a tube is measured. Many sources will also mention the usage of a schedule when calculating the wall thickness of a pipe.
Also, tubes don't always have to be round; they can take on a number of shapes, including square and oval. Contrarily, pipes are always round.
However, it appears that using an inside diameter and schedule for pipes and an outer diameter for tubes makes the most sense for separating tubes from pipes.
To know other construction guides, tips, and methodology for beginners, veterans, and contractors, please see here.
To know the flood prone areas in the Philippines, Top 10 Flood-Prone Areas to Live in the Philippines.
To know more about Concrete Hollow Blocks, Simple Reasons Why Hollow Blocks are Highly Used in the Philippines
To know more about Hammers and Nails, Tips for Guaranteed Best Technique for Hammering Nails
Leave a Comment
Your email address will not be published. Required fields are marked *


Take the 2-minute tour ×
I want to use the Python field calculator to remove the hyphen from a field column. For example, I would like to parse out the hyphen from an entry like "123-45-6789" and read "123456789".
share|improve this question
Why the down votes? – Nathan W Dec 26 '12 at 2:28
2 Answers 2
Use the built-in str.replace method accessible on all string objects.
Put this in the Expression box (replacing "FieldName" with your own):
share|improve this answer
The sub method in Python's regular expression module should do the trick.
import re
no_hyphens = re.sub('-','','123-45-6789')
This will replace any instance of a "-" with an empty string.
share|improve this answer
Your Answer


. This is to ease
 debugging of faulty test cases.
 * Test programs no longer isolate their test cases. This means that they
 will not create temporary directories nor sanitize the environment any
 more. Yes: running a test case that depends on system state by hand
 will most likely yield different results depending on where (machine,
 directory, user environment, etc.) it is run. Isolation has been moved
 to atf-run.
 * Test programs no longer print a cryptic format (application/X-atf-tcs)
 on a special file channel. They can now print whatever they want on
 the screen. Because test programs can now only run one test case every
 time, providing controlled output is not necessary any more.
 * Test programs no longer write their status into a special file
 descriptor. Instead, they create a file with the results, which is
 later parsed by atf-run. This changes the semantics of the -r flag.
 * atf-run has been adjusted to perform the test case isolation. As a
 result, there is now a single canonical place that implements the
 isolation of test caes. In previous releases, the three language
 bindings (C, C++ and shell) had to be kept in sync with each other
 (read: not a nice thing to do at all). As a side effect of this
 change, writing bindings for other languages will be much, much easier
 from now on.
 * atf-run forks test programs on a test case basis, instead of on a test
 program basis as it did before. This is to provide the test case
 isolation that was before implemented by the test programs themselves.
 * Removed the atf-exec tool. This was used to implement test case
 isolation in atf-sh, but it is now unnecessary.
 * It is now optional to define the descr meta-data property. It has been
 proven to be mostly useless, because test cases often carry a
 descriptive name of their own.
Revision 1.9 / (download) - annotate - [select for diffs], Tue Dec 22 16:08:30 2009 UTC (11 years, 10 months ago) by jmmv
Branch: MAIN
CVS Tags: pkgsrc-2010Q1-base, pkgsrc-2010Q1, pkgsrc-2009Q4-base, pkgsrc-2009Q4
Changes since 1.8: +64 -4 lines
Diff to previous 1.8 (colored)
Update to 0.7:
* Added build-time checks to atf-c and atf-c++. A binding for atf-sh
 will come later.
* Migrated all build-time checks for header files to proper ATF tests.
 This demonstrates the use of the new feature described above.
* Added an internal API for child process management.
* Converted all plain-text distribution documents to a Docbook canonical
 version, and include pre-generated plain text and HTML copies in the
 distribution file.
* Simplified the contents of the Makefile.am by regenerating it from a
 canonical Makefile.am.m4 source. As a side-effect, some dependency
 specifications were fixed.
* Migrated all checks from the check target to installcheck, as these
 require ATF to be installed.
* Fixed sign comparison mismatches triggered by the now-enabled
 -Wsign-compare.
* Fixed many memory and object leaks.
Revision 1.8 / (download) - annotate - [select for diffs], Sun Jun 14 18:48:08 2009 UTC (12 years, 4 months ago) by joerg
Branch: MAIN
CVS Tags: pkgsrc-2009Q3-base, pkgsrc-2009Q3, pkgsrc-2009Q2-base, pkgsrc-2009Q2
Changes since 1.7: +1 -2 lines
Diff to previous 1.7 (colored)
Convert @exec/@unexec to @pkgdir or drop it.
Revision 1.7 / (download) - annotate - [select for diffs], Sun Jun 14 17:48:34 2009 UTC (12 years, 4 months ago) by joerg
Branch: MAIN
Changes since 1.6: +1 -18 lines
Diff to previous 1.6 (colored)
Remove @dirrm entries from PLISTs
Revision 1.6 / (download) - annotate - [select for diffs], Sun Jan 18 21:23:14 2009 UTC (12 years, 9 months ago) by jmmv
Branch: MAIN
CVS Tags: pkgsrc-2009Q1-base, pkgsrc-2009Q1
Changes since 1.5: +14 -4 lines
Diff to previous 1.5 (colored)
Update to 0.6:
Release date: January 18th, 2009
Status: Experimental
* Make atf-exec be able to kill its child process after a certain period of
 time; this is controlled through the new -t option.
* Change atf-sh to use atf-exec's -t option to control the test case's
 timeouts, instead of doing it internally. Same behavior as before, but
 noticeably faster.
* atf-exec's -g option and atf-killpg are gone due to the previous change.
* Added the atf-check(1) tool, a program that executes a given command and
 checks its exit code against a known value and allows the management of
 stdout and stderr in multiple ways. This replaces the previous atf_check
 function in the atf-sh library and exposes this functionality to both
 atf-c and atf-c++.
* Added the ATF_REQUIRE family of macros to the C interface. These help
 in checking for fatal test conditions. The old ATF_CHECK macros now
 perform non-fatal checks only. I.e. by using ATF_CHECK, the test case
 can now continue its execution and the failures will not be reported
 until the end of the whole run.
* Extended the amount of ATF_CHECK_* C macros with new ones to provide more
 features to the developer. These also have their corresponding
 counterparts in the ATF_REQUIRE_* family. The new macros (listing the
 suffixes only) are: _EQ (replaces _EQUAL), _EQ_MSG, _STREQ and
 _STREQ_MSG.
Revision 1.5 / (download) - annotate - [select for diffs], Thu May 1 15:14:21 2008 UTC (13 years, 6 months ago) by jmmv
Branch: MAIN
CVS Tags: pkgsrc-2008Q4-base, pkgsrc-2008Q4, pkgsrc-2008Q3-base, pkgsrc-2008Q3, pkgsrc-2008Q2-base, pkgsrc-2008Q2, cwrapper, cube-native-xorg-base, cube-native-xorg
Changes since 1.4: +89 -44 lines
Diff to previous 1.4 (colored)
Update to 0.5. Release details:
Release date: May 1st, 2008
Status: Experimental
* Clauses 3 and 4 of the BSD license used by the project were dropped.
 All the code is now under a 2-clause BSD license compatible with the
 GNU General Public License (GPL).
* Added a C-only binding so that binary test programs do not need to be
 tied to C++ at all. This binding is now known as the atf-c library.
* Renamed the C++ binding to atf-c++ for consistency with the new atf-c.
* Renamed the POSIX shell binding to atf-sh for consistency with the new
 atf-c and atf-c++.
* Added a -w flag to test programs through which it is possible to specify
 the work directory to be used. This was possible in prior releases by
 defining the workdir configuration variable (-v workdir=...), but was a
 conceptually incorrect mechanism.
* Test programs now preserve the execution order of test cases when they
 are given in the command line. Even those mentioned more than once are
 executed multiple times to comply with the user's requests.
Revision 1.4 / (download) - annotate - [select for diffs], Mon Feb 4 20:19:33 2008 UTC (13 years, 8 months ago) by jmmv
Branch: MAIN
CVS Tags: pkgsrc-2008Q1-base, pkgsrc-2008Q1
Changes since 1.3: +15 -2 lines
Diff to previous 1.3 (colored)
Update to 0.4.
Changes:
* Added two new manual pages, atf-c++-api and atf-sh-api, describing the
 C++ and POSIX shell interfaces used to write test programs.
* Added a pkg-config file, useful to get the flags to build against the
 C++ library or to easily detect the presence of ATF.
* Added a way for test cases to require a specific architecture and/or
 machine type through the new 'require.arch' and 'require.machine'
 meta-data properties, respectively.
* Added the 'timeout' property to test cases, useful to set an upper-bound
 limit for the test's run time and thus prevent global test program stalls
 due to the test case'


text:
Vision and Values
Working For The Poor
Courses and Training
The Alpha Course
The Marriage Course
The CAP Money Course
Foundations and Advanced
Impact Training is a year given over full time to God, to learn to think and live biblically. It is a mix of theological training, church based project work, personal discipleship and skills based training.
Spanning an academic year there are monthly training blocks in Bristol, and a residential week away in January. Projects are tailored to individuals, and are designed to stretch and develop students in their gifting.
The training block syllabus covers a wide range of topics including systematic theology and doctrine, working with the disadvantaged, kids and youth work, and building good foundations for the rest of your life. It is taught by church leaders from across Commission and further afield, in an interactive and informal style. There are a variety of assignments set after each training block to reinforce what has been taught. There is also a mission trip towards the end of the year, either in the UK or overseas, as part of the course.
There are also potential opportunities for undertaking an Impact year in India for those that would like to study in a cross cultural context and serve in a local church there. Please contact the Commission office if you would like to pursue this.
Impact is for anyone over the age of 18 (there's no upper age limit) who wants to take a year to serve the church, and see themselves grow and change in God.
If you've got any questions, please contact the Bristol Impact training base on
Or if you would like to download an application form,
Tuesday 16 July
Wednesday 17 July
Saturday 20 July
@ Westham Bridge
Sunday 21 July
Bethany Hall, Westham Road, Weymouth


text:
The Ronald Lee Sterner Trust Fund
Ronald Lee Sterner was adopted through Covenant Children's Home by the Sterner family in the 1950's. Tragically Ronald died as a young child. In 1957 the Sterner family established the Ronald Lee Sterner Trust in his memory. The Board of Covenant Children's Home was named as the Administrator of the trust. The purpose of the trust to was to encourage and enable other vulnerable children to pursue a post-high school education through scholarship grants.
Today Covenant Children's Ministries continues to administer funds generated by the trust in accordance with the wishes of the Sterner family. Special consideration is given to "orphaned children" as defined by the trust, and to former residents and clients of Covenant Children's Home. Other factors considered are students from "broken homes," those attending schools of Christian emphasis, and students pursuing careers in Christian service or one of the helping professions. Over the years, as the trust fund has grown, Covenant Children's Ministries has helped hundreds of worthy students achieve their educational goals, and it continues to do so today.
If you have any questions about the Ronald Lee Sterner Grant or are in need of additional information, please direct all inquiries to _EMAIL_


text: With the growing popularity of autonomous unmanned aerial vehicles (UAVs), the improvement of safety for UAV operations has become increasingly important. In this paper, a landing trajectory optimization scheme is proposed to generate reference landing trajectories for a fixed-wing UAV with accidental engine failure. For a specific landing objective, two types of landing trajectory optimization algorithms are investigated: i) trajectory optimization algorithm with nonlinear UAV dynamics, and ii) trajectory optimization algorithm with linearized UAV dynamics. An initialization procedure that generates an initial guess is introduced to accelerate the convergence of the optimization algorithms. The effectiveness of the proposed scheme is verified in a high-fidelity UAV simulation environment, where the optimized landing trajectories are tracked by a UAV equipped with an L1 adaptive altitude controller in both the offline and online modes.


Ask Questions, Get Answers
Want to ask us a question? Click here
Browse Questions
Home >> CBSE XI >> Math >> Probability
0 votes
In a non-leap year,the probability of having 53 tuesdays or 53 wednesdays is
$\begin{array}{1 1}(A)\;\large\frac{1}{7}\\(B)\;\large\frac{2}{7}\\(C)\;\large\frac{3}{7}\\(D)\;\text{None of these}\end{array} $
Can you answer this question?
1 Answer
0 votes
Step 1:
Given a non-leap year
$\therefore$ A non leap year has 365 days
Which includes 52 whole weeks
$\therefore 52\times 7=364$
Step 2:
$\therefore$ Remaining is 1 day which could be either of the day out of 7 days.
$\therefore$ Probability of having 53 tuesdays or 53 wednesdays =$\large\frac{1}{7}$
Hence (A) is the correct answer.
answered Jul 8, 2014 by sreemathi.v
Related questions
Ask Question
student study plans
JEE MAIN, CBSE, NEET Mobile and Tablet App
The ultimate mobile app to help you crack your examinations
Get the Android App


text:
On 24th August (2014) students of class
I – V had a Guest lecture by Dr. Basanth Kumar who is Chief Anesthetist, in Indo American Cancer Hospital. He gave a lecture on personal hygiene and good manners to the students. Personal hygiene is a set of practices performed for the prevention of health. Good manners are a set of patterns of behavior which mark a person as a civilized and cultured member of a society. Students asked him questions and got their doubts clarified. They learnt the causes of hiccups, chickenpox, typhoid, throat infections and many more. Mr. Basanth answered all questions very patiently.


Create the HBase target table
Before you can ingest data into Apache HBase in CDP Public Cloud, ensure that you have an HBase target table. These steps walk you through creating a simple table with one column family. Modify these instructions based on your ingest target table needs.
Your CDP user has the necessary Ranger permissions to create an HBase table.
 1. Ssh into one of your HBase nodes, entering your CDP user name and password when prompted.
 ssh <cdp-user.name><HBase.node.name>
 2. Use klist to verify your Kerberos ticket, to ensure that the Ranger permissions you have setup to create HBase tables will work with your CDP user.
 3. Open the HBase shell.
 hbase shell
 4. Create a new table.
 For example, to create a new table called customer, with one column family called customer_data, enter:
 create 'customer', 'customer_data'
 5. Verify that you have created your table.
 list

 TABLE
 customer
 1 row(s)
 6. Create a Ranger policy that allows the CDP user to ingest data into this HBase table. You will use this CDP user later, when specifying credentials for your NiFi data flow.


text:
Cobalamin C deficiency presenting with diffuse alveolar hemorrhage and pulmonary microangiopathy.
Summary: This case report describes patients with diffuse alveolar hemorrhage and pulmonary microangiopathy with cobalamin C deficiency.
Conclusion: The report states that after corticosteroids alone did not improve their condition, MMACHC led to significant improvements after the deficiency was also treated.
Objective: Combined methylmalonic acidemia and homocysteinemia is a genetically heterogeneous disorder of cobalamin (cbl; vitamin B12) metabolism, which consists of five subtypes including cblC, cblD, cblF, cblJ, and cblX deficiencies. The purpose of this study is to summarize new clinical features mainly diffuse alveolar hemorrhage (DAH) in cblC deficiency.
Methods: We made a retrospective analysis of four pediatric patients diagnosed with DAH and pulmonary microangiopathy due to cblC deficiency between January 2017 and December 2018 in Beijing Children's Hospital.
Results: This study describes four patients with their ages ranging from 4 years 2 months to 7 years 6 months with cblC deficiency who developed late-onset diffuse lung disease (DLD). Of these, the first three patients presented predominantly with DAH, and the last patient with pulmonary microangiopathy confirmed by thoracoscopic lung biopsy. All patients were accompanied by pulmonary arterial hypertension (PAH), two accompanied by respiratory failure, and two accompanied by moderate megaloblastic anemia. Diffuse ground-glass opacification and poorly defined ground-glass centrilobular nodules were seen on high-resolution computed tomography in one patient and three patients, respectively. All patients were suspected of having idiopathic pulmonary hemosiderosis or interstitial lung disease at other hospitals. All of them received treatment with corticosteroid before admission, but the symptoms did not improve. Moreover, all patients carried compound heterozygous mutations (c.80A>G, c.609G>A) in MMACHC and improved significantly after being treated for cblC deficiency and PAH.
Conclusions: CblC deficiency should be considered in the differential diagnosis of DAH especially with PAH, and pulmonary microangiopathy be the main reason of DLD in these patients.


El enlace fue enviado a su email.
No se pudo enviar el enlace a su email. Por favor, verificar su correo electrónico.
Ayuda en línea
GEO5
Tree
Settings
Producto:
Programa:
Idioma:
Activity of Regions Below GWT
There are two cases to be considered when deactivating a region below the GWT.
1) The soil subjected to excavation is completely enclosed by active beam elements. The beam is then considered to be impermeable and both the soil and water are removed (removing total stresses - inactive region is free of water). Owing to impermeability of the beam elements, the pore pressure distribution remains unchanged, see the figure.
Pore pressure distribution after removing soil from region enclosed by active beams
2) The removed soil is not enclosed by beam elements. In such case we assume that water in the excavated region is still active. This state is evident from the pore pressure distribution in the figure.
Pore pressure distribution after removing soil
Its effect can be removed by changing the ground water table.
Pore pressure distribution after modifying the ground water table
Pruebe GEO5.
Gratis y sin restricciones en el análisis.


text:
"Be spontaneous!" Paradoxes
A vexing communication block occurs when one person requests or demands something from another that can only be given sponta-neously - like trust, love, interest, acceptance, appreciation, desire, and respect. If the second person tries to comply, the first person may then say - "You're just doing that because I asked you to, not because you really mean it." Examples: "You never say 'I love you'"; "You must honor my wishes!"; "You need to respect the sacrifices I make for you"; and "Why won't you initiate sex more often?"
The solution: (a) mutual knowledge of this concept and process awareness, and the second person (b) asserting something like "You're asking me to (want to) give you something that has to be spontaneous," and (c) both people digging down to identify the under-lying relationship needs that are causing this situation.] Lesson 2 is about learning to communicate effectively


text:
Numbers, such as 84, have two digits. Each digit is a different
The first digit is the tens' place.
It tells you that there are 8 tens in the number 84.
The right digit is the ones' place which is 4 in this example.
Therefore, there are 8 sets of 10, plus 4 ones in the number 84.
| |__ones' place


text:
3. Mr. L'ESTRANGE MALONE
asked the Secretary of State for Foreign Affairs whether any negotiations are in progress with Persia as regards the capitulatory régime; whether other countries besides Russia and Turkey have renounced their capitulatory privileges; and which countries still exercise such rights?
§ Sir A. CHAMBERLAIN
The position of foreign nationals in Persia after the termination of the so-called capitulatory régime is naturally the subject of discussion between the Persian Government and the other Governments concerned. The countries still entitled to exercise capitulatory rights are, I believe, the Argentine Republic, Belgium, Brazil, Chile, Denmark, France, Germany, Great Britain, Italy, Mexico, the Netherlands, 1950 Norway, Spain, Sweden, Switzerland, United States and Uruguay. So far as I am aware, no countries other than Russia and Turkey have hitherto renounced their rights.


DataStage – How to add or subtract from a date in a transformer stage
DataStage – How to add or subtract from a date in a transformer stage
From time to time there is a need to adjust a date within a DataStage transformer. It could be as small subtracting a day to set a batch processing date to yesterday or something bigger. If you need to adjust a date by a year, month and/or day the DateOffsetByComponents function is the method. The DateOffsetByComponents function can work with a fixed value or input from the job either; an input field, or a stage variable. The main thing is knowing what to put in which position in the offset values with the understanding that offsets values can be positive or negative, thereby, allowing the addition and subtraction of different part of a date in a dataStage transformer.
Purpose of DateOffsetByComponents Function
 - This function is used to obtain a specific required date by applying offset to a given date.
Syntax
DateOffsetByComponents(<<Input Date>>, year offset, month offset, day of month offset)
How to subtract a year
DateOffsetByComponents(dsjobstartdate,-1, 0, 0)
How to add a year
DateOffsetByComponents(dsjobstartdate ,1, 0, 0)
How to subtract a month
DateOffsetByComponents(dsjobstartdate, 0, -1, 0)
How to add a month
DateOffsetByComponents(dsjobstartdate, 0, 1, 0)
How to subtract a day
DateOffsetByComponents(dsjobstartdate, 0, 0, -1)
How to add a day
DateOffsetByComponents(dsjobstartdate, 0, 0, 1)
%d bloggers like this:


text:
- Use the cleaning rod and a cloth to clean the inside tubing directly when you are finished playing.
- Wipe the outside of the flute to remove fingerprints, being careful to avoid touching the edges of the pads.
- Cigarette papers can be used to eliminate sticky pads. Slip a sheet (not the sticky part) under the open pad, depress the key, and pull the paper away. If this doesn't work after two or three tries, bring the problem to a repair shop. Too many tries can tear the pads. We also sell "powder paper" that works even better than cigarette paper.
- A soft brush (a clean paint brush) is good for removing dust and other debris that accumulates under the keys. Do this gently so you don't knock any springs.
- Never use any type of silver polish as it will ruin the pads.
- Don't attempt any screw adjustments. This is a delicate job needing experience.
- It is important to keep all of the accessories properly stored in your case. Loose accessories can damage the instrument. It is also important not to put music in your case as forcing it inside can damage the instrument.
- Once a year, your instrument should be checked by a repair technician to ensure that there are no leaks and that the corks are in good condition.
Suggested Maintenance Supplies: Polishing Cloth, Cleaning Rod, Powder paper.


text:
JEFFERSON CITY, MO, NOV. 16, 2021 - The Missouri Department of Natural Resources is extending the deadline for Missouri communities to submit information on their water infrastructure funding needs.
Drinking water, wastewater and stormwater infrastructure projects in Missouri are critical to providing essential service to Missouri citizens and businesses, but are largely underfunded.
The American Rescue Plan Act (ARPA) provides funds that may be used to make necessary investments in water and sewer infrastructure to state, local and tribal governments. However, most communities have water funding needs that far exceed the amount of ARPA grant funds they were directly allocated.
Governor Mike Parson has announced a commitment to offer grants from the state's ARPA allocation for water infrastructure improvements. He will present his plan to the General Assembly at his State of the State address in January 2022.
To better understand the scope of Missouri infrastructure needs associated with wastewater, drinking water and stormwater utilities, the department is asking Missouri communities to complete a brief survey. The information gleaned from survey responses will help identify water infrastructure funding needs across the state and be used to develop state grant programs to help meet those needs.
The survey is intended to identify prospective projects that could be funded if grant funds were made available. The department is particularly interested in water infrastructure projects for which an engineering report has already been prepared, as well as projects that are difficult to finance with existing resources. Communities are encouraged to complete the survey with details about their projects, including estimated costs, available local cost share funding and the community's demographic information.
Grant programs will favor applicants who propose projects that are necessary for compliance and public health protection, demonstrate financial need and that provide local cost share funds to complete the work. Communities should consider retaining their local ARPA allocations to offer as cost share funds for state ARPA grant programs, likely increasing the community's chances of being awarded state ARPA grant funding.
To submit water infrastructure projects, visit _URL_. Surveys may now be submitted until 5 p.m. Nov. 30, 2021.
For more information, please contact the Water Protection Program's Financial Assistance Center at _EMAIL_ or _PHONE_.
To learn more about using ARPA funds for water infrastructure, visit State of Missouri's Local Fiscal Recovery Fund Toolkit for Water, Wastewater and Stormwater at oa2.mo.gov/ARPAtoolkits/water-infrastructure.


text: This week we have been learning about the men who signed up to fight on the Frontline between _PHONE_. We met a few people along the way. Soldiers such as Henry, Jack and Arthur. Children looked at historical documents and conducted some research to build a picture about who these men were, where they lived and where they fought. The children then looked at a WW1 trench map and marked on the places that these soldiers fought. We all loved learning about these individuals and the children were extremely proud to hear about the brave men that took part in the war who were from Farlsey.


text:
Sending Data from Splunk To Database Using DB Connect ( DBX – Part 3)
In this post we are covering how to to create an output in the "Splunk DB Connect" application and get the most out of your database with Splunk.
Creating an "Output" in "Splunk DB Connect" application
Step-1: Navigate to the "Outputs" page, and click on the "New output" button.
Step-2: Set up Search,
Search/Saved Search : Select whether you want to write a new search or you want to use a saved search.
Run the search to check the output of your search/saved search.
Once you are satisfied with the output, click on the "Next" button.
Step-3: Choose Table,
Connection : Select the connection you want to use
for this input.
Catalog : Select the Catalog (if available).
Schema : Select the Schema from your database.
Table : Search for the table/click on the table
name where you want to push the data
Here, we are using a table "METHOD_INFO",
Verify the "Table Schema"and click on the "Next" button.
Step-4: Fields Mapping
Fields Mapping Section:
Here, you map the data fields from Splunk to the database table. You just need to click on the "Search fields" and the corresponding "Table Contents".
You can add multiple search fields by clicking on the "Add Search Field" button.
Enabling this behavior overrides any rows with the same values, you need to choose a column that can be used as a "key".
Click on the "Next" button to move further into the configuration.
Step-5: Set properties,
Name : Provide a unique name for this output.
Description (Optional): Add a description about what
this output does.
Application: Select the app context.
Query Timeout : Specify how long to wait for the query to
Scheduling : Click on the box to enable scheduling for
this output, otherwise the output behaves as
a single shot query.
Execution Frequency : Set the time interval(s) at which
this query should run (CRON Expression).
Click on the "Finish" button to finish the configuration.
You should get the "Done" screen as shown below.
Step-5: Now you will be to see the data in the database. You can check with Database Team to verify whether data has been stored into the database or not. See the below screenshot for our database.
Additionally, you can use the "SQL Explorer" to test/experiment with your SQL queries before you use them to create inputs/outputs etc.
Hope, this post was worth a read. If you want to know more about the DB connect configuration and operations please visit the below links.


text:
WITHDRAWN, NO REPLACEMENT
1.1 This guide establishes the minimum training standard for the secondary assessment of ill or injured patients of all ages.
1.2 Frequently repeated primary surveys are an essential and integral part of the complete care of the acutely ill or injured patient.
1.3 This guide identifies the components of patient secondary assessment.
1.4 This guide is one of a series which together describe the minimum training standard for the emergency medical technician (basic).
1.5 This standard may involve hazardous materials, operations, and equipment. This standard does not purport to address all of the safety problems associated with its use. It is the responsibility of the user of this standard to establish appropriate safety and health practices and determine the applicability of regulatory limitations prior to use.


the wildcard characters that are supported in the destination pattern.
Table 3
Wildcard Symbols Used in Destination Patterns
Symbol
Description
.
Indicates a single-digit placeholder. For example,
555.... matches any dialed string beginning with
555, plus at least four additional digits.
[]
Indicates a range of digits. A consecutive range is
indicated with a hyphen (-); for example, [5-7]. A
nonconsecutive range is indicated with a comma (,);
for example, [5,8]. Hyphens and commas can be
used in combination; for example, [5-7,9].
Note Only single-digit ranges are supported. For
example, [98-102] is invalid.
Dial Peer Configuration on Voice Gateway Routers, Cisco IOS Release 12.4T
20
Dial Peer Features and Configuration
Wildcards
Symbol
Description
()
Indicates a pattern; for example, 408(555). It is
used in conjunction with the symbol ?, %, or +.
?
Indicates that the preceding digit occurred zero or
one time. Enter ctrl-v before entering ? from your
keyboard.
%
Indicates that the preceding digit occurred zero or
more times. This functions the same as the "*" used
in regular expression.
+
Indicates that the preceding digit occurred one or
more times.
T
Indicates the interdigit timeout. The router pauses
to collect additional dialed digits.
The table below shows some examples of how these wildcard symbols are applied to the destination pattern
and the dial string that results when dial string _PHONE_ is matched to an outbound POTS dial peer. The
wildcard symbols follow regular expression rules.
Table 4
Dial Peer Matching Examples Using Wildcard Symbols
Destination Pattern
Dial String Translation
String After Stripping3
408555.+
408555, followed by one or more
wildcard digits. This pattern
implies that the string must
contain at least 7 digits starting
with 408555.
1234
408555.%
408555, followed by zero or more 1234
wildcard digits. This pattern
implies that the string must
contain at least 408555.
408555+
40855, followed by 5 repeated
one or more times.
408555%
40855, followed by 5 repeated
51234
one or more times. Any explicitly
matching digit before the %
symbol is not stripped off.
408555?
40855, followed by 5. Any
explicitly matching digit before
the ? symbol is not stripped off.
1234
51234
3 These examples apply only to one-stage dialing, where direct inward dialing (DID) is enabled on the inbound POTS dial peer. If the router is using
two-stage dialing and collecting digits one at a time as dialed, then the call is routed immediately after a dial peer is matched and any subsequent
dialed digits are lost.
Dial Peer Configuration on Voice Gateway Routers, Cisco IOS Release 12.4T
21
Dial Peer Features and Configuration
Digit Stripping and Prefixes
Destination Pattern
Dial String Translation
String After Stripping3
40855[5-7].+
40855, followed by 5, 6, or 7,
plus any digit repeated one or
more times.
51234
40855[5-7].%
40855, followed by 5, 6, or 7,
plus any digit repeated one or
more times.
51234
40855[5-7]+1234
40855, followed by 5, 6, or 7
repeated one or more times,
followed by 1234.
51234
408(555)+1234
408, followed by 555, which may _PHONE_
repeat one or more times,
followed by 1234.
In addition to wildcard characters, the following characters can be used in the destination pattern:
-
-
-
Asterisk (*) and pound sign (#)--These characters on standard touch-tone dial pads can be used
anywhere in the pattern. They can be used as the leading character (for example, *650), except on the
Cisco 3600 series.
Dollar sign ($)--Disables variable-length matching. It must be used at the end of the dial string.
Circumflex symbol (^)--When used within brackets, allows you to eliminate a digit from consideration
for dial peer matching purposes. For example, a destination pattern including [^7] would not match
any string beginning with 7.
Multiple digits can also be called out within brackets to eliminate more than one initial digit from dial peer
matching. For example, a destination pattern including [^4^6^8] would not match any digit string
beginning with 4, 6, or 8.
Note
A destination pattern including [^752] would allow matching only for digit strings beginning with 5 or 2,
but would not match any digit strings beginning with 7. This destination pattern entry essentially behaves
the same way as if you had simply included [52] in the destination pattern.
To eliminate a multiple digit string from dial peer matching consideration, you must represent each digit in
the string as a succession of individual exceptions. For example, if you wanted to eliminate matching any
digit string beginning with 537 from consideration for dial peer matching, you must ensure that your
destination pattern includes [^5][^3][^7].
The same destination pattern can be shared across multiple dial peers to form hunt groups.
Digit Stripping and Prefixes
When a terminating router receives a voice call, it selects an outbound POTS dial peer by comparing the
called number (the full E.164 telephone number) in the call information with the number configured as the
destination pattern in the POTS dial peer. The access server or router then strips off the left-justified digits
that match the destination pattern. If you have configured a prefix, the prefix is added to the front of the
3 These examples apply only to one-stage dialing, where direct inward dialing (DID) is enabled on the inbound POTS dial peer. If the router is using
two-stage dialing and collecting digits one at a time as dialed, then the call is routed immediately after a dial peer is matched and any subsequent
dialed digits are lost.
Dial Peer Configuration on Voice Gateway Routers, Cisco IOS Release 12.4T
22
Dial Peer Features and Configuration
Digit Stripping and Prefixes
remaining digits, creating a dial string, which the router then dials. If all numbers in the destination pattern
are stripped out, the user receives a dial tone.
For example, consider a voice call whose E.164 called number is _PHONE_. If you configure a
destination-pattern of "_PHONE_" and a prefix of "9," the router strips off "_PHONE_" from the E.164
telephone number, leaving the extension number of "2222." It then appends the prefix, "9," to the front of
the remaining numbers, so that the actual numbers dialed are "9, 2222." The comma in this example means
that the router will pause for 1 second between dialing the "9" and dialing the "2" to allow for a secondary
dial tone.
When the terminating router matches a dial string to an outbound POTS dial peer, by default the router
strips off the left-justified digits that explicitly match the destination pattern. Any remaining digits, called>
excess digits, are forwarded to the telephony interface, such as a PBX or the PSTN.
Some telephony interfaces require that any digits stripped from the dial string be recovered to support a
particular dial plan. You can strip these digits either by using the no digit-strip dial-peer voice
configuration command to disable the default digit-stripping behavior or by using the prefix dial-peer voice
configuration command to add digits to the beginning of the dial string before it is forwarded to the
telephony interface. These commands are supported only in POTS dial peers.
The no digit-strip command disables the automatic digit-stripping function so that matching digits are not
stripped from the dialed string before it is passed to the telephony interface. For example, in the following
dial peer configuration, the entire seven-digit dialed string is passed to the telephony interface:
dial-peer voice 100 pots
destination-pattern 555....
no digit-strip
port 1/0:1
Disabling digit stripping is useful when the telephony interface requires the full dialed string. With some
dial plans, however, the dialed digits must be manipulated according to specific rules. The prefix command
can be used to add specific digits to the beginning of the dialed string before it is forwarded to the
telephony interface.
For example, consider a telephone whose E.164 called number is _PHONE_. This telephone can be
reached within the company by dialing its extension number, 51234. If you configure a destination pattern
of "_PHONE_...." (the periods represent wildcards) for the associated outbound POTS dial peer, the
terminating gateway will strip off the digits "_PHONE_" when it receives a call for _PHONE_. For the
terminating gateway to forward the call to the appropriate destination, the digit "5" needs to be prepended
to the remaining digits. In this case, you would configure a prefix of 5, as shown in the following dial peer
configuration.
dial-peer voice 100 pots
destination-pattern _PHONE_....
prefix 5
port 1/0:1
A prefix can also include commas (,). Each comma indicates a 1-second pause in dialing. For example,
consider a telephone whose E.164 called number is _PHONE_; to reach this device, you must dial
"


Export (0) Print
Expand All
2 out of 2 rated this helpful - Rate this topic
When TCP/IP is enabled for SQL Server, the Database Engine will listen for incoming connections on a connection point consisting of an IP address and TCP port number. The following procedures create a tabular data stream (TDS) endpoint, so that SQL Server will listen on an additional TCP port.
Possible reasons to create a second TDS endpoint include:
 - Increase security by configuring the firewall to restrict access to the default endpoint to local client computers on a specific subnet. Maintain Internet access to SQL Server for your support team by creating a new endpoint that the firewall exposes to the Internet, and restricting connection rights to this endpoint to your server support team.
 - Affinitizing connections to specific processors when using Non-Uniform Memory Access (NUMA). For more information about how to configure a TCP/IP port to a NUMA node, see How SQL Server Supports NUMA.
Configuring a TDS endpoint consists of the following steps, which can be done in any order:
 - Create the TDS endpoint for the TCP port, and restore access to the default endpoint if appropriate.
 - Grant access to the endpoint to the desired server principals.
 - Specify the TCP port number for the selected IP address.
To create a TDS endpoint
 - Issue the following statement to create an endpoint named CustomConnection for port 1500 for all available TCP addresses on the server.
 USE master
 CREATE ENDPOINT [CustomConnection]
 AS TCP
 FOR TSQL() ;
To grant access to the endpoint
 - Issue the following statement to grant access to the CustomConnection endpoint to the SQLSupport group in the corp domain.
 GRANT CONNECT ON ENDPOINT::[CustomConnection] to [corp\SQLSupport] ;
To configure the SQL Server Database Engine to listen on an additional TCP port
 1. In SQL Server Configuration Manager, expand SQL Server Network Configuration, and then click Protocols for .
 2. Expand Protocols for , and then click TCP/IP.
 3. In the right pane, right-click each disabled IP address that you want to enable, and then click Enable.
 4. Right-click IPAll, and then click Properties.
 5. In the TCP Port box, type the ports that you want the Database Engine to listen on, separated by commas. In our example, if the default port 1433 is listed, type,1500 so the box reads 1433,1500, and then click OK.
 If you are not enabling the port on all IP addresses, configure the additional port in the property box for only for the desired address. Then, in the console pane, right-click TCP/IP, click Properties, and in the Listen All box, select No.
 6. In the left pane, click SQL Server Services.
 7. In the right pane, right-click SQL Server , and then click Restart.
 When the Database Engine restarts, the Error log will list the ports on which SQL Server is listening.
To connect to the new endpoint
 - Issue the following statement to connect to the CustomConnection endpoint of the default instance of SQL Server on the server named ACCT, using a trusted connection, and assuming the user is a member of the [corp\SQLSupport] group.
 sqlcmd -SACCT,1500
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Community Additions
© 2014 Microsoft. All rights reserved.