Skip to main content

Tips 'n' Tricks

Go Search
Home
Tips 'n' Tricks
eBis
MAC
Microsoft Business Architecture
BPR
IIBA Prep
  

Rose Solutions > Tips 'n' Tricks
Technical tips and tricks our staff have fallen over, stored centrally so we can find them again.
data matching
EXACT
Decimal, Integer - % or +- difference [always cover rounding]
date - range of days
string - ???
DQS does similarity comparisons based on multiple influences, including known values, and synonyms you have added into the knowledge base on the Domain Values tab, and besides the similarities of the spelling of the words.
Instead of writing much more, I am not sure if you have seen Matching in action, but these videos show it to help illustrate the feature:
2. http://msdn.microsoft.com/en-us/sqlserver/hh323803.aspx
==================================

I want date to consider when the year is wrong, or the day and month are reversed, or a digit is omiited
I want string to consider a digit skipped or added, or a single digit being incorrect
Lets also have phonetic (sounds like) and synonyms
==================================

Source: the SharePoint 2010 list of phonetics and synonyms of each word are held in a text file, about 25MB in size in the following location;
C:\Program Files\Microsoft Office Servers\14.0\Bin\languageresources.txt

Watch for regional english settings
Khara notes
L10 - Dungeon Master [II, R2C]
- Red Rackuf Name Tag
- Broken Trident
- Bell Collar
- Ged. Necklace
- Large Insect Jawbone
Held: Burnt
Done: Gold, Steel, Cry, Wood
------------------------
L45 Ripped Cape
Held: Burn, Woodt
Done:
------------------------
L?? [II, R1T3]
- Ripped Frej Rove
- Bell Collar Ornament
- Ungoliant Jawbone
- Leviathan's Heart
Held: Darken and Wood
Done: Gold, Steel, Chry
------------------------
L41 [R3,T4]
- Ripped Captains Hat
- 6 Pirate Tokens
Held: Wood
Done: Gold, Steel, Cry
------------------------
L??
3 Shabby Bags
Held: Darken has 2
Done:
------------------------
L??
Deviruchi PB I-IV
Held: Gold
Done:
------------------------
Wiz Elix with Pale
Str Elix with Gold
------------------------
L?? 30 Cards [I, R2,B4]
Held: Pale
Done: Steel
------------------------
L?? 3 cards [II, L1B3]
- Leviathan
- Moonlight Flower
- Gedenhard
- Ungoliant
Held: -
Done: -
------------------------
L46 - Masks
III L4, T4
III R2, B3
 
Held: Gold
Done:
------------------------
4 sets of goblin masks Held: Steel
 Beastmaster
4   3   5
1   5   1
5   1   1
5   5   1
5   5   5
Ranger
1   3   1
     3
1   5   1
     3
1   1   1
5   5   1
     1
1   1   1
     5
5   1   5
Either the 2 bold ones, or the 2 italics
Wizard
1   5   1
     1
1        1
     1
1   5    1
 
1   5    3
     5
1   5    0
     5
     5
1   0    3
Rogue
1   5   1
     3
0        0
     5
0   5   5
 
3   3   5
0   5   0
     1
0   5   5
Cresentia
5   2   1
1   1   3
1   5   0
1   5   5
1   5   0
1   0   0
5   3
3   3
Tracking mats
Alchemist
- Master Red requires Radiant Firm Cry
- Master Str and Expert Int require Dazzling Trace Cry
- can convert powder to cry to piece (both oridecon and elenium)
 
Blacksmith
- Punches require Radiant Cry
 
Artisan
- Vit Rune: Dazzling Trace Cry and Radiant Cry
- Int Rune: Et Life Cry and Radiant Cry
- Str Rune: Radiant Firm Cry and Radiant Cry
Accelerated Levelling
 
- Have crafters provide gear
- Ignore Kharas
- Use Battle Order scrolls - the timer only runs while the character is logged in
- At level 10, get the Dungeon Master achievement, and equip the title
- At level 41, Pirate Hat and Tokens, or Aye Captain
- At level 45, Avenger (ripped cape)
 
- Get to 98 pets to get the improved timeout
 
SQL for SharePoint

http://thomasvochten.com/archive/2012/06/sql-server-for-sharepoint-geeks-and-other-involuntary-dbas/

In case that link fails:

Key Takeaways from my session

References

During my session, I made a reference to several resources:

1 - 10 Next

 ‭(Hidden)‬ Admin Links