text:
Search Suggestions
Hello,Welcome to Play.com. . (Not youSign in?) | Create an account You've earned Save with SuperPoints
View Basket
Released on 20 June 2013
Author: Corey Taylor | Format: Hardback
Write a review
New from £11.10
Also available used from £19.75
Results 1-5 of 17
Sold by: AphroheadBooks | visit our store
Condition: New
In stock | Shipping now
Comment: BRAND NEW - Delivery usually within 2 - 3 working days.
Available Delivery Options (find out more)
12 SuperPoints
RRP £16.99 Save £5.89
Free Delivery
Sold by: Wordery | visit our store
Comment: This copy of "A Funny Thing Happened On The Way To Heaven" is brand new and waiting for you in our UK warehouse. Order before 1.30pm and we'll send it today and it should be with you within 4 working days for UK or 10 working days for EU.
RRP £16.99 Save £5.65
Sold by: pbshopatplay | visit our store
Comment: New Book. Delivered from our UK warehouse in 3 to 4 business days. Established seller since 2000
RRP £16.99 Save £5.64
Sold by: Speedyhen | visit our store
Comment: Same day despatch from the UK when ordered before 3pm - All our items are brand new and sent out by Royal Mail or courier service - over 1 million items already sold since we started trading.
Sold by: Rarewaves | visit our store
Comment: All items dispatched within 2 Days. Shipped from mainland UK
13 SuperPoints
RRP £16.99 Save £4.53
Average rating (0 reviews)
Help our customers make the best choices by telling everyone what you think about this product.
Rakuten's Play.com is an online trading platform which enables third party sellers and buyers to negotiate and complete transactions via its Website. Rakuten's Play.com is neither the buyer nor the seller of any items sold via its Website. Accordingly, Rakuten's Play.com is not a party to the contract for sale between a buyer and seller and is not responsible for fulfilling and delivering orders, handling returns or processing refunds for purchases made.
The relevant seller's terms and conditions apply to delivery, refunds and returns of any items sold via Rakuten's Play.com. If you have specific questions, about a sellers delivery policy, returns policy or the return or refund of an item you should contact the relevant seller directly. You must comply with the seller's return policy in order to be eligible for any possible refund from the seller.
Whilst we have no obligation to mediate or to enforce or execute fulfilment of any contract, we want you to have a safe shopping experience and may intervene in certain circumstances to resolve an issue, in line with our FairPlay Guarantee. Please see our User Agreement for details.
Important Warning: It is your responsibility to check a seller's delivery and returns policy prior to confirming an order.


text:
View gallery
Below are pictures and videos. Select what you want to view below.
Popular Hotels
Shawnee Peak House-Bridgton
Grady's West Shore Motel
Highland Lake Resort
Tarry-A-While Resort
Pleasant Mountain Inn
Noble House Bed & Breakfast
Popular Attractions
Popular Cities
Ogunquit, ME
Portland, ME
Portsmouth, NH
North Conway, NH
Hampton Beach, NH
Old Orchard Beach, ME
York, ME
Salem, MA
Gloucester, MA
Freeport, ME
York Beach, ME

subset: commoncrawl


text:
How the Victorians Revelled in Death and Detection and Created Modern Crime
By Judith Flanders
Members read and review books ahead
of publication. See what they think
in First Impressions!
Visitors can view a lot of BookBrowse for free. Full access is for members only
Books thatinspire you.Handpicked.
Books you'll stay up all night reading; books that will whisk you to faraway places and times, books that will expand your mind and inspire you -- the kinds of books you just can't wait to tell your friends about.


text:
Quick View Smart Ass Booster Card Game Tin by University Games In Stock $11.95 Who's the Smart Ass among your friends and family? Find out with this outrageous, fast-paced party game. Each Who, What and Where am I? Card has ten clues. And guess what? You never have to wait for your turn in Smart Ass. Just yell out the answer as soon as you know it! Cards can be played alone… See Details $11.95 was
Quick View World War Z: The Game by University Games In Stock $29.95 Are YOU Ready to Save the World from Zombies? A pandemic is sweeping across the globe and is threatening humanity's survival. Playing as Elite Military or CIA personnel, you must race against time and around the world with one mission: Survive and Prevent the Zombie Apocalypse. Begin the action on… See Details $29.95 was
Quick View The Very Hungry Caterpillar Cardgame Tin by University Games In Stock $11.95 Players of all ages will enjoy this intriguing game which follows the caterpillar as he eats his way through the week and turns into a beautiful butterfly! Each player is The Very Hungry Caterpillar. As the caterpillar eats different food items each day, players learn the days of the week as they… See Details $11.95 was
Quick View 20 Questions For Kids Tin by University Games In Stock $11.95 20 Questions is now available in a convenient tin for those who want an award winning travel game from National Parenting Publication. Sample Question: I am a thing. – 1. I can be as big as a turkey. 2. My crest has nothing to do with waves. 3. My males don't care for their young. 4. My feathers… See Details $11.95 was


text:
Access the Global Review here:
Welcome, guest
Thu Apr 1, 2004
Cantillon, the hedge fund outfit set up by William von Mueffling and the team that walked out of Lazards last year, is close to starting a U.S equity market neutral fund. The new vehicle will be managed by Jay Genzer, a former Lazards colleague who joined Cantillon on February 6 after the expiry of his one-year-no-compete clause.
He had worked with von Mueffling at Lazards since...
Subscribers have unlimited access to all current and archive content. Start your subscription today - click on the button below.
Subscribe now
Sorry, you are not allowed to print this article.
Please contact us if you have any enquiry:Email: firstname.lastname@example.com
Call: UK & EMEA +44 (0) 20 7779 7339Americas +1 212 224 3067 Asia-Pacific +852 2842 6953


text:
Hang tight!
Recipe by JENNAMARAL
"This is a old family recipe that I have been making for years. Serve with homemade apple sauce."
Watch video tips and tricks
1 pork tenderloin
3 slices bread, torn into small pieces
1/4 cup butter, melted
3 tablespoons poultry seasoning
1 medium onion, chopped fine
1 stalk celery, chopped fine
salt and ground black pepper to taste
6 slices bacon
Tenderloin was very good, reminiscent of dark turkey meat, albeit with a much smokier flavour. It evokes memories of traditional holiday meals, while requiring much less preparation than a stuffed bird. I had hoped for the meat to be a bit moister, but I did not serve it with the suggested applesauce, electing instead to have broccoli and sweet potato sides. Perhaps the omission of a sauce was a poor decision. I also found it to be slightly salty for my taste, and do not recommend adding any additional salt as the bacon provided plenty. Would certainly try this recipe again.
I found it had way too much Poultry seasoning. I don't think it was suppose to be 3 Tablespoons. maybe teaspoons at most.
9 Ratings
I used 1/2 onion, 3/4 red apple, and celery. I diced them all and sauteed them to warm it through then added two slices cubed bread. I seasoned it with salt, pepper, 1 teaspoon chicken seasoning. I butterflied the tenderloin and pounded it to about 1/2 inch and then stuffed and rolled it. My tenderloin was pretty small so I didn't add extra bread. No bacon but but rolled prosciutto ham around the tenderloin. It also looked much better since all the stuffing was rolled inside and looked nice when sliced. The prosciutto ham might have been good in the stuffing instead.
I used this recipe with two butterfly pork chops and it came out AMAZING. I knocked it down to 4 stars instead of five because of the amount of poultry seasonig. I only used half of what the recipe called for and it was still way too much. Had to add more bread to even it out. I also skipped the salt. Between the poultry seasoning and the bacon, I thought the salt might be over kill. Came out perfect! I will definitely make this again!
This was really good and very easy to make. Think I will cut back on the poultry seasoning next time, maybe add some apples to the stuffing. Was a big hit in house!
I thought this recipe was very good. I found it took longer than 45 minutes to cook though. I would certainly make it again.
It was very good. Will certainly try this or a variation of this again.
* Percent Daily Values are based on a 2,000 calorie diet.
Bacon Wrapped Stuffed Pork Tenderloin
Serving Size: 1/4 of a recipe Servings Per Recipe: 4 Amount Per Serving Calories: 330 Calories from Fat: 176
Everything you need to party like a leprechaun.
New for spring! Good-for-you food you'll love to eat.
Delicious recipes, party ideas, and helpful cooking tips! Get a year of Allrecipes magazine for just $9.99!
Watch how to prepare a succulent herb-crusted pork tenderloin.
See how to make an incredibly easy pork tenderloin with black cherry sauce.
See how to use jerk spices to make perfect jerk pork tenderloin.


text:
Year of publication
Document Type
- Working Paper (421)
- Doctoral Thesis (53)
- Article (43)
- Other (35)
- Periodical Parts (32)
- Diplom Thesis (10)
- Book (8)
- Preprint (7)
- Report (7)
- Conference Proceeding (6)
Has Fulltext
- yes (630) (remove)
- Deutschland (10)
- Evaluation (8)
- corporate governance (7)
- Corporate Governance (6)
- Social Interaction (6)
- financial transaction data (6)
- monetary policy (6)
- Contagion (5)
- Geldpolitik (5)
- Liikanen-Kommission (5)
- Wirtschaftswissenschaften (630) (remove)
- SAFE Newsletter : 2014, Q1 (2014)
- SAFE Newsletter : 2013, Q4 (2013)
- Asset prices in general equilibrium with recursive utility and illiquidity induced by transactions costs (2014)
- In this paper, we study the effect of proportional transaction costs on consumption-portfolio decisions and asset prices in a dynamic general equilibrium economy with a financial market that has a single-period bond and two risky stocks, one of which incurs the transaction cost. Our model has multiple investors with stochastic labor income, heterogeneous beliefs, and heterogeneous Epstein-Zin-Weil utility functions. The transaction cost gives rise to endogenous variations in liquidity. We show how equilibrium in this incomplete-markets economy can be characterized and solved for in a recursive fashion. We have three main findings. One, costs for trading a stock lead to a substantial reduction in the trading volume of that stock, but have only a small effect on the trading volume of the other stock and the bond. Two, even in the presence of stochastic labor income and heterogeneous beliefs, transaction costs have only a small effect on the consumption decisions of investors, and hence, on equity risk premia and the liquidity premium. Three, the effects of transaction costs on quantities such as the liquidity premium are overestimated in partial equilibrium relative to general equilibrium.
- Life insurance demand under health shock risk (2014)
- This paper studies the life cycle consumption-investment-insurance problem of a family. The wage earner faces the risk of a health shock that significantly increases his probability of dying. The family can buy term life insurance with realistic features. In particular, the available contracts are long term so that decisions are sticky and can only be revised at significant costs. Furthermore, a revision is only possible as long as the insured person is healthy. A second important and realistic feature of our model is that the labor income of the wage earner is unspanned. We document that the combination of unspanned labor income and the stickiness of insurance decisions reduces the insurance demand significantly. This is because an income shock induces the need to reduce the insurance coverage, since premia become less affordable. Since such a reduction is costly and families anticipate these potential costs, they buy less protection at all ages. In particular, young families stay away from life insurance markets altogether.
- Banks' financial distress, lending supply and consumption expenditure (2014)
- The paper employs a unique identification strategy that links survey data on household consumption expenditure to bank level data in order to estimate the effects of bank financial distress on consumer credit and consumption expenditures. Specifically, we show that households whose banks were more exposed to funding shocks report significantly lower levels of non-mortgage liabilities compared to a matched sample of households. The reduced access to credit, however, does not result in lower levels of consumption. Instead, we show that households compensate by drawing down liquid assets. Only households without the ability to draw on liquid assets reduce consumption. The results are consistent with consumption smoothing in the face of a temporary adverse lending supply shock. The results contrast with recent evidence on the real effects of finance on firms' investment, where even temporary adverse credit supply shocks are associated with significant real effects.
- How do insured deposits affect bank risk? Evidence from the 2008 Emergency Economic Stabilization Act (2013)
- This paper tests whether an increase in insured deposits causes banks to become more risky. We use variation introduced by the U.S. Emergency Economic Stabilization Act in October 2008, which increased the deposit insurance coverage from $100,000 to $250,000 per depositor and bank. For some banks, the amount of insured deposits increased significantly; for others, it was a minor change. Our analysis shows that the more affected banks increase their investments in risky commercial real estate loans and become more risky relative to unaffected banks following the change. This effect is most distinct for affected banks that are low capitalized.


text:
Items Tagged with 'retro'
Narragansett Beer brings back retro 1975 can
Narragansett Beer reintroduced its 1975 can, made famous in the "Jaws" movie during the scene in which Captain Sam Quint, played by Robert Shaw, crushes a can of Narragansett Lager to intimidate Richard Dreyfuss' character, Hooper.
Adult Strawberry Milk
Adult Beverage Co., part of Deutsch Family Wine & Spirits, added Adult Strawberry Milk to its pour-and-serve portfolio.
Adult Limeade
Adult Beverage Co. extended its nostalgic spirits portfolio with the release of Adult Limeade, made with 100 percent blue agave reposado tequila.


text:
Country Guide - India
Welcome to the Exodus Travel Guide to India.
Our country guide to India will provide you with all the travel information you need to prepare for your holiday.
Full Name
Republic of India
Capital City
New Delhi
Indian Rupee
Plug Types
Voltage: 230-240V
Frequency (Hz): 50Hz
For the latest travel advice on visiting India:
>> Foreign & Commonwealth Office advice for travelling to India
>> BBC Country Profile on India
To purchase guidebooks and maps for your visit to India:


text: REPLACED: We will no longer take orders for this item.We offer a 15-pack of Remanufactured Replacements for Epson ink cartridges for the Stylus Photo 2100 & 2200 that includes 3 Photo Black T034120 (T0341), and 2 each of: Light Black T034720 (T0347), Cyan T034220 (T0342), Light Cyan T034520 (T0345), Magenta T034320 (T0343), Light Magenta T034620 (T0346) and Yellow T034420 (T0344) inkjet cartridges. These remanufactured inkjet cartridges replace OEM Epson ink cartridges without sacrificing quality and performance. With our 100% Satisfaction Guarantee, our Replacements for Epson cartridges are an excellent alternative to OEM Epson cartridges, delivering beautifully clear, crisp printouts you can depend on.


text:
Ed Miliband is due to highlight his own education at a London comprehensive school as he promises a shake-up of vocational qualifications to help the "forgotten 50%" of children who do not go to university.
In his keynote speech to Labour's annual conference in Manchester, Mr Miliband will propose a new Technical Baccalaureate offering work experience, school-based vocational training and academic courses in English and Maths up to the age of 18, coupled with a boost to apprenticeships which could see 100,000 extra entry-level posts created.
Aides said the TechBacc represented the biggest change to vocational education in England in decades, creating a "gold standard" qualification to stand alongside A-levels.
Under the TechBacc system, even teenagers who have failed English and maths at 16 would continue to study the subject to 18. Unlike current vocational courses, a young person studying to be - for example - a hairdresser would learn not only how to do a trim but how to keep the salon's books and communicate with customers.
Association of Colleges chief executive Martin Doel said: "We watch with interest the Labour leader's proposals for a technical baccalaureate and welcome the concept. It is important that all young people have an opportunity to succeed in a way that best suits their ambitions and learning styles. We particularly welcome his recognition that many young people do not go to university and seek other avenues.
"Many students who attend colleges to study vocational qualifications gain high-quality positions or progress to higher education already. In order to meet Ed Miliband's aims of building a country where vocational qualifications are not seen as second-class certificates - a view we would refute - the further education sector is ideally placed and can offer substantial experience and success."
Professor Alison Wolf, who conducted a review of vocational education for the Government last year, welcomed an "emerging consensus" on the need for maths and English teaching to 18. She said: "I was very pleased when the coalition Government accepted all the recommendations of my review. I have also been delighted and impressed by the speed with which they are being implemented, including specifically those relating to English and maths for 16 to 18-year-olds, which have now gone into effect.
"I was, therefore, also pleased to learn, from the reports on the Labour Conference, that there is finally an emerging consensus in this country on the critical importance of maths and English in the modern labour market, and for the whole population."
Chris Keates, general secretary of teaching union NASUWT, said: "The NASUWT welcomes the fact that this announcement has not only opened up the important debate about the future of the qualifications system, it has the potential to address the scandal of over one million unemployed young people.
"Ed Miliband's proposals are seeking to give greater status to vocational qualifications, which the Secretary of State has condemned as second-class. Labour will need to ensure that the Technical Baccalaureate has parity of esteem with academic qualifications. Labour should be bold and radical in developing proposals for reform in order to develop a coherent national qualifications framework that values equally all forms of learning, both academic and vocational."


text:
(CNN) -- Rapper Tone Loc pleaded no contest Monday to domestic violence and other charges, about three and a half months after a fight with the mother of his child, the Los Angeles County district attorney's office announced.
Tone Loc, whose real name is Anthony Smith, entered the plea in open court of single counts of corporal injury to a spouse, cohabitant or child's parent and possession of an assault weapon, the office said in a press release. The weapon -- a Colt AR-15 Sporter -- was found by investigators, but was not used in the domestic assault.
There was no negotiated settlement, according to the district attorney.
After the rapper addressed the court, Burbank Superior Court Judge Patrick Hegarty sentenced him to one day in county jail, three years of probation, 52 weeks of anger management counseling and 30 days of community service.
He was arrested in June, following what Burbank Police Sgt. Tracy Sanchez then described as "a physical altercation with the mother of his child."
The entertainer then spent less than three hours in custody before posting a $50,000 bond, according to Sanchez.
The 45-year-old rapper rose to stardom in 1988 with his hit singles "Wild Thing" and "Funky Cold Medina."
His deep, raspy voice made him famous not just in the music world, but also helped him as he scored acting roles on television and doing voice work. He has been cast in several sitcoms and reality TV shows, according to the Internet Movie Database.
CNN's Alan Duke and Denise Quan contributed to this report.
Loading weather data ...


text:
Paul Liuzzo of Eagle Sales Realty and Sharon Lisciandro of Century 21 Turner Brokers have been named 2012 Realtor and Realtor-Associated of the Year, respectively, by Chautauqua County Board of Realtors Inc. Recipients are selected by their peers based on involvement in the real estate industry at local, state and national levels, civic activity, and business accomplishments, conduct and service to clients.
Liuzzo has been a member for 25 years, dedicated to his career and community service beginning with real estate sales and became a broker to start running the family business. Liuzzo pursued his appraisal certification and soon became a real estate appraiser. He has served as a director of the board as well as on the MLS committee and grievance committee. Currently Liuzzo is on the board of directors and the MLS committee. Liuzzo is active in the community as well. He serves on the tax grievance panel and is a founding instructor for the Infinity music program.
Lisciandro has been a member of Chautauqua County Board of Realtors since March 2006. She has been a member of the membership committee and currently serving as 2012 co-chair. In addition to her real estate service, Sharon has been involved in Creche, Lakewood Women's Club, youth soccer as a coach, Aids community service, Chautauqua Yacht Club and active volunteer at the Ss. Peter & Paul Church.
Article Photos
Paul Liuzzo


text:
Line breaks: shyPronunciation: /ʃʌɪ
( shyer, shyest)
- 1Nervous or timid in the company of other people: I was pretty shy at school a shy smileMore example sentences
- Jayalalitha, a once shy, timid, tiny introvert, was so outstanding in her studies that her portrait hangs in her school as a star alumnus with academic excellence as her only passion.
- His smile is shy, almost gentle, and his eyes dart nervously around him.
- I've gone from being shy and timid, to being quietly confident and assured.
bashful, diffident, timid, sheepish, reserved, reticent, introverted, retiring, self-effacing, shrinking, withdrawn, timorous, mousy, fearful, apprehensive, nervous, hesitant, reluctant, doubting, insecure, wary, suspicious, chary, unconfident, inhibited, constrained, repressed, self-conscious, embarrassed, coy, demure, abashed, modest, humble, meek - 1.1 (shy of/about) Slow or reluctant to do (something): the wealthy have become less shy of displaying their privilegeMore example sentences
- I wanted to take things slow, and was shy about being intimate.
- She has never been shy of expressing her feminist opinions.
- 1.3(Of a wild mammal or bird) reluctant to remain in sight of humans: otters are very shy animalsMore example sentences
- The Department of Conservation has been on the hunt for our national icon in the Western Bay since November - but so far the shy birds have remained out of reach.
- The shy birds were reluctant to cache when observed and often made fake deposits.
- Build a brush pile near your feeder to make sparrows, towhees, and other shy birds feel more at home, but be sure it won't harbor roaming cats.
- 2 (shy of) • informal Less than; short of: the shares are 29p shy of their flotation priceMore example sentences
- I had studied and put too much effort into this test to have achieved 150 points shy of a perfect score.
- The company's shares trade just shy of the level that analysts say the printer business is worth all on its own.
- It was he's 24th goal of the season, just one short of his all-time best and two shy of his record achieved many years ago at the other club.
- 2.1Before: he left school just shy of his fourteenth birthdayMore example sentences
- Days shy of the event's 15th anniversary, he was detained by authorities.
- Just shy of its 180th birthday, the oldest political party in the country voted itself out of existence in early December.
- He was just shy of his 60th birthday and certainly had much more to do in his life.
- 3(Of a plant) not bearing flowers or fruit well or prolifically.More example sentences
- A new work by Alan Bennett is like a shy plant that only flowers every now and then, but when it does gives enormous pleasure.
- Cyclamen Cyclamen are subtler and more elegant than poinsettia with delicate, silky, shy flowers and the dappled heart-shaped leaves.
( shies, shying, shied)
- 1(Especially of a horse) start suddenly aside in fright at an object, noise, or movement: their horses shied at the unfamiliar sightMore example sentences
- His horse shied to the right, making room on the path for the newcomer.
- Hoss jumped, and the horse shied, the twin jolts coming together in the agony of his jawbone.
- But the white horse shied away from her, his wild eyes showing their whites, ears laid back in fear.
- 1.1 (shy from) Avoid doing or becoming involved in (something) due to nervousness or a lack of confidence: don't shy away from saying what you thinkMore example sentences
- They avoided fighting whenever possible, yet did not shy from combat if it closed in.
- We are not shying from the responsibility but to put a three-year-old on the operating table when he's smiley and happy is not an option.
- To its credit, the picture doesn't shy from depicting the horrific reality of execution by electric chair, although it stops short of coming down firmly in an anti-death penalty stance.
flinch, demur, recoil, hang back; have scruples about, scruple about, have misgivings about, have qualms about, be averse to, be chary of, not be in favour of, be against, be opposed to, be diffident about, be bashful about, be shy about, fight shy of, be coy about; be loath to, scruple to, be reluctant to, be unwilling to, be disinclined to, not be in the mood to, be indisposed to, be sorry to, be slow to, be hesitant to, be ashamed to, be afraid to, hesitate to, hate to, not like to, not have the heart to, drag one's feet/heels over, waver about, vacillate about, think twice about, baulk at, quail at, mind doing something• informal be cagey about, boggle at• archaic disrelish
Back to topDerivatives
- More example sentences
- She didn't really fit in, she stood out from the rest, far more beautiful and a lot shyer.
- Calvin seemed a bit shyer now and he wasn't smiling quite so much.
- With room-mates, the shyer of the two tended to change more emotionally.
- More example sentences
- She smiled shyly, looking down at her bare feet in the cold mud.
- Pens and paper at the ready the kids shyly approached Micko, cautiously asking for his autograph.
- Standing shyly in worn jeans with a canvas bag, Yang looked like a student.
Old English scēoh '(of a horse) easily frightened', of Germanic origin; related to German scheuen 'shun', scheuchen 'scare'; compare with eschew. The verb dates from the mid 17th century.
More definitions of shy
Definition of shy in:- The US English dictionary
- The English Synonyms
- The US English Synonyms
Get more from Oxford Dictionaries
Subscribe to remove ads and access premium resources
Word of the day
Pronunciation: ˈkaZHo͞oist
a person who uses clever but unsound reasoning
Line breaks: shyPronunciation: /ʃʌɪ
• dated
( shies, shying, shied)
( plural shies)
Back to top
- An act of flinging or throwing something at a target.More example sentences
- Non-striker Gordon Webster, running to the danger end, would have been well short of safety had the shy at the stumps been on target.
- First class casters could reach way out to shy fish, and distant mangroves.
have a shy at
- Try to hit something, especially with a ball or stone.More example sentences
- So good was their dominance that they did not allow the Chandigarh team to have a shy at the goal at all.
- Pietersen has a shy at the stumps, but misses with the Australian just about making his ground.
- If they miss, the man backing up collects and has a shy at the next stump along the line.
- • archaic Attempt to do or obtain something: have a shy at putting the case to meMore example sentences
- Though he is well behind the leaders, another Finn who could have a shy at a medal at least will be hammer thrower Olli-Pekka Karjalainen.
- • archaic Jeer at: you are always having a shy at Lady Ann and her relationsMore example sentences
- 'There you go, Polly; you are always having a shy at Lady Anne and her relations,' says Mr. Newcome, good-naturedly.
late 18th century: of unknown origin.
More definitions of shy
Definition of shy in:- The US English dictionary
- The English Synonyms
- The US English Synonyms
Get more from Oxford Dictionaries
Subscribe to remove ads and access premium resources
Word of the day
Pronunciation: ˈkaZHo͞oist
a person who uses clever but unsound reasoning


text:
Georgia Cable Guy Buys Beautiful Murray Hill Brownstone [Pics]
How do you quadruple your money on a Manhattan brownstone? Make it the prettiest around.
Not only was 133 East 38th Street awarded the Murray Hill Architectural Award for best historic restoration–at least that's what its Corcoran listing declares–but rehabbers extraordinaire Nikola Webb and Paul J. Andersson just sold the place for $4.55 Read More


text:
Exquisite Real Leather Journals
Leather Journals are a beautiful way to document places and belongings to aid memories for years to come. Our selection of blank and lined leather journals are all exquisitely designed and handmade to the highest standards. These journals make fabulous gifts for any occasion, or just treat yourself!
Showing items 1 to 30 of 49 total


text:
THE SQL Server Blog Spot on the Web
This week a SharePoint conference took place somewhere and I took more than a passing interest because it clearly wasn't a SharePoint conference, it was a Office365/Yammer conference and as far as I can discern the big takeaways were:
It was interesting to me because Power BI is something that is on my radar and which is delivered via Office 365. This got me thinking about scenarios where Power BI & Yammer could play together more effectively.
The BI delivery team that I currently work for is trying find ways to make the information that we produce more discoverable, more accessible and to promote the use of the information that we provide throughout the company. The company is an Office365 customer however they pretty much use it only as an email & IM provider - none of the SharePoint-y stuff is used. The company is also a Yammer customer.
The confluence of Yammer and Power BI might make an interesting story here. Imagine, for example, the ability to build a Power View report using Power BI and then share that throughout the organisation using Yammer, perhaps via a Yammer group. Anyone viewing their Yammer feed would be able to view and interact with that Power View report without leaving Yammer. I'm not talking about simply viewing an image of a report either – I'd want to be able to slice'n'dice that report right within my Yammer feed.
I've long thought that we need to think of new ways of delivering BI to the masses and I believe social collaboration tools present a great opportunity to do that. I'm excited about what Yammer + Power BI could bring, let's hope Microsoft don't royally screw it up.
I still believe that Microsoft's Master Data Services (MDS) should be offered through Power BI and again the opportunity to collaboratively compile and discuss data that resides in MDS is compelling. I see no reason why people wouldn't want to change MDS data from within their Yammer feed – why would we force them to go elsewhere? Again I opine, bring the data to wherever your users are, don't make them go somewhere else.
Hidden away behind all of the announcements was the implicit assertion that Windows Azure Active Directory is critical to Microsoft's cloud efforts. Office 365 sits on top of Windows Azure Active Directory and I don't think many people realise the significance of that. Whoever manages your company's employees' identities has a huge opportunity for selling new stuff to you and that's why Windows Azure Active Directory is free. This is not a new play for Microsoft, over the past 20 years or so they've become a huge player in the corporate landscape and that's in no small way down to Active Directory – own the identity and you can sell them other stuff like SharePoint, Windows, SQL Server etc… By allowing you to extend your Active Directory into the cloud and have pervasive groups its not far off being a no-brainer for companies to use Windows Azure & Office 365.
Active Directory in the cloud, public and private groups, identity management, developer APIs … those are the big plays here and is very much like what I described in my blog post Windows Live Groups predictions and "Active directory in the cloud". The names and players have changed but the concepts I outlined there are now happening. Back then I said:
[This] gives rise to the idea of Groups becoming something analogous to an "active directory in the cloud". This is a disruptive idea partly because it could become the mechanism by which Microsoft grant access to their online properties in the future. Even more powerful is the idea that 3rd party websites that authenticate visitors … could use Groups to determine what each user can do on that site. Groups will become part of an authentication infrastructure that anyone in the world can leverage. This "active directory in the cloud" idea relies on a robust API that allows a 3rd party site to add and remove people from groups.
[This] gives rise to the idea of Groups becoming something analogous to an "active directory in the cloud". This is a disruptive idea partly because it could become the mechanism by which Microsoft grant access to their online properties in the future.
Even more powerful is the idea that 3rd party websites that authenticate visitors … could use Groups to determine what each user can do on that site. Groups will become part of an authentication infrastructure that anyone in the world can leverage.
This "active directory in the cloud" idea relies on a robust API that allows a 3rd party site to add and remove people from groups.
Believe it or not that was six years ago. Don't want to say I told you so, but…
The commands
return information about query executions and are very useful when doing performance tuning work as they inform how long a query took to execute and the amount of IO activity that occurred as a result of that query.
These are very effective features however to my mind they do have a drawback in that the information they provide is not accessible in the actual query window from which the query was executed. This means the results cannot be collected, stored in a table, and then queried – such information would have to be manually copied and pasted from the messages pane into (say) a spreadsheet for further analysis.
This is dumb. I'm a SQL Server developer, I want my data available so that I can bung it into a table in SQL Server and issue queries against it. That is why, a couple of weeks ago, I submitted a request to Microsoft Connect entitled Access to STATS TIME & STATS IO from my query in which I said:
I recently was doing some performance testing work where I was evaluating the affect of changing various settings on a particular query. I would have liked to simply run my query inside a couple of nested loops in order to test all permutations but I could not do that because every time I executed the query I had to pause so I could retrieve the stats returned from STATISTICS IO & STATISTCS TIME and manually copy and paste (yes, copy and paste) the information into a spreadsheet. This feels pretty dumb in this day and age. Why can we not simply have access to that same information within my query? After all, we have @@ROWCOUNT, ERROR_MESSAGE(), ERROR_NUMBER() etc... that provide very useful information about the previously executed statement, how about @@STATISTICS for returning all the IO & timing info? We can parse the text returned by that function to get all the info we need. Better still, provide individual functions e.g.: @@QUERYPARSETIME @@QUERYCOMPILETIME @@QUERYEXECUTIONTIME @@SCANCOUNT @@LOGICALREADS @@PHYSICALREADS @@READAHEADREADS
Ralph Kemperdick noticed my submission and correctly suggested that the same information could be accessed using Extended Events. Based on this I've written a script (below) that issues a series of queries against the AdventureWorks2012 sample database, captures similar stats that would be captured by SET STATISTICS then presents them back at the end of the query. Here are those results:
The information is not as comprehensive as what you would get from SET STATISTICS (no Read-Ahead Reads for example, and no breakdown of IO per table) but should be sufficient for most purposes.
You can adapt the script accordingly for whatever information you want to capture, the important part of the script is the creation of the XEvents session for capturing the queries, then reading and shredding the XML results thereafter.
Hope this is useful!
--Create the event session CREATE EVENT SESSION [queryperf] ON SERVER ADD EVENT sqlserver.sql_statement_completed ADD TARGET package0.event_file(SET filename=N'C:\temp\queryperf.xel',max_file_size=(2),max_rollover_files=(100)) WITH ( MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_MULTIPLE_EVENT_LOSS, MAX_DISPATCH_LATENCY=120 SECONDS,MAX_EVENT_SIZE=0 KB, MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=OFF,STARTUP_STATE=ON); --Set up some demo queries against AdventureWorks2012 in order to evaluate query time & IO USE AdventureWorks2012 DECLARE @SalesPersonID INT; DECLARE @salesTally INT; DECLARE mycursor CURSOR FOR SELECT soh.SalesPersonID FROM Sales.SalesOrderHeader soh GROUP BY soh.SalesPersonID; OPEN mycursor; FETCH NEXT FROM mycursor INTO @SalesPersonID; ALTER EVENT SESSION [queryperf] ON SERVER STATE = START; WHILE @@FETCH_STATUS = 0 BEGIN DBCC FREEPROCCACHE; DBCC DROPCLEANBUFFERS; CHECKPOINT; SELECT @salesTally = COUNT(*) FROM Sales.SalesOrderHeader soh INNER JOIN Sales.[SalesOrderDetail] sod ON soh.[SalesOrderID] = sod.[SalesOrderID] WHERE SalesPersonID = @SalesPersonID FETCH NEXT FROM mycursor INTO @SalesPersonID; END CLOSE mycursor; DEALLOCATE mycursor; DROP EVENT SESSION [queryperf] ON SERVER; --Extract query information from the XEvents target SELECT q.duration,q.cpu_time,q.physical_reads,q.logical_reads,q.writes--,event_data_XML,statement,timestamp FROM ( SELECT duration=e.event_data_XML.value('(//data[@name="duration"]/value)[1]','int') , cpu_time=e.event_data_XML.value('(//data[@name="cpu_time"]/value)[1]','int') , physical_reads=e.event_data_XML.value('(//data[@name="physical_reads"]/value)[1]','int') , logical_reads=e.event_data_XML.value('(//data[@name="logical_reads"]/value)[1]','int') , writes=e.event_data_XML.value('(//data[@name="writes"]/value)[1]','int') , statement=e.event_data_XML.value('(//data[@name="statement"]/value)[1]','nvarchar(max)') , TIMESTAMP=e.event_data_XML.value('(//@timestamp)[1]','datetime2(7)') , * FROM ( SELECT CAST(event_data AS XML) AS event_data_XML FROM sys.fn_xe_file_target_read_file('C:\temp\queryperf*.xel', NULL, NULL, NULL) )e )q WHERE q.[statement] LIKE 'select @salesTally = count(*)%' --Filters out all the detritus that we're not interested in! ORDER BY q.[timestamp] ASC ;
Accepted wisdom when one purchases an app from a business store is that one gets free updates for life. This is, quite obviously, an unsustainable business model and I suspect is the main reason why so many apps use advertising to generate income.
There is though, in the enterprise world at least, a move to a subscription-based business model (i.e. renting software) the most obvious examples of which are Office 365 and Adobe Creative Cloud and I'm left wondering why app stores don't offer a similar option.
Today I installed an app called Tweetium that offers a (paid for) premium option, here is why the premium option exists:
Again this strikes me as unsustainable. The customer pays once yet Tweetium has to pay TweetMarker every month. Forever. It doesn't take an expert mathematician to realise that eventually Tweetium's monthly outlay could exceed the income they have saved up from purchases.
It seems to me there is a simple solution to all this. App stores could offer an option for customers to rent apps rather than buy them. Its more sustainable for the app vendor and the app store provider gets a more predictable income stream (which CFOs seem to like). Why don't app stores not do this? Seems like a no-brainer to me
Just a random thought for a Sunday morning.
On 17th February 2014 (3 days ago) I visited an event called SQL Supper held at Microsoft's central London office, Cardinal Place. The event was basically a QnA session with Mark Souza, Conor Cunningham, Nigel Ellis, Hatay Tuna & Ewan Fairweather and one part of the evening was loosely termed the gripe session where the attendees were invited to stick their hand in the air and when asked have a good old whinge about something in SQL Server that, well, frankly pissed them off. Given the members of the panel this was inevitably focused on the database platform in SQL Server rather than the BI stuff and this is what I was only too happy to gripe about:
Microsoft seem to have dropped the ball on database developer productivity, both in the language and the tooling. A decade ago this is something that SQL Server was renowned for, I put it to you that this is no longer the case. SSDT came out with SQL Server 2012 and its a great tool, I love it, but in the two years since there have been various maintenance releases but hardly any new features. SSMS has hardly changed for years, extensibility is still not truly supported. Intellisense does not work properly 100% of the time. As far as I can recall T-SQL has had only two major features (TRY/CATCH & windowing functions) in the last ten years. Please fix this. Show database developers some love again.
Microsoft seem to have dropped the ball on database developer productivity, both in the language and the tooling. A decade ago this is something that SQL Server was renowned for, I put it to you that this is no longer the case. SSDT came out with SQL Server 2012 and its a great tool, I love it, but in the two years since there have been various maintenance releases but hardly any new features. SSMS has hardly changed for years, extensibility is still not truly supported. Intellisense does not work properly 100% of the time. As far as I can recall T-SQL has had only two major features (TRY/CATCH & windowing functions) in the last ten years.
Please fix this. Show database developers some love again.
I could write pages and pages of gripes just under the banner of developer productivity but I'll leave you with that concise summary. It is of course a matter of opinion, feel free to agree or disagree.
In this week's earlier blog post First release of my own personal T-SQL code library on Github I talked of how one could use a dacpac to distribute a bunch of code to different servers. Upon reading the blog post Jonathan Allen (of SQL Saturday Exeter fame), with whom I've been discussing dacpacs with on-and-off recently, sent me this email:
Hi Jamie, The DacPac thing I emailed about in December hasnt taken off yet but I have just downloaded your code library to take a look and I like the way the dacpac works. Should I be able to open that in VS or is the dacpac compiled/built in VS? The video you linked to didnt cover dapac at all so I am in the dark on how to create one/them. If I can build a database and create a dacpac simply then this could be really useful.
Hi Jamie,
The DacPac thing I emailed about in December hasnt taken off yet but I have just downloaded your code library to take a look and I like the way the dacpac works. Should I be able to open that in VS or is the dacpac compiled/built in VS? The video you linked to didnt cover dapac at all so I am in the dark on how to create one/them.
If I can build a database and create a dacpac simply then this could be really useful.
Jonathan's email made me realise that there is perhaps a lot of confusion about what dacpacs are, what they can be used for and how they can be used so I figured a braindump of what I know about them might be useful, that's what you're getting in this blog post.
A dacpac is a file with a .dacpac extension.
In that single file are a collection of definitions of objects that one could find in a SQL Server database such as tables, stored procedures, views plus some instance level objects such as logins too (the complete list of supported objects for SQL Server 2012 can be found at DAC Support For SQL Server Objects and Versions). The fact that a dacpac is a file means you can do anything you could do with any other file, store it, email it, share it on a file server etc… and this means that they are a great way of distributing the definition of many objects (perhaps even an entire database) in a single file. Or, as Microsoft puts it, a self-contained unit of SQL Server database deployment that enables data-tier developers and database administrators to package SQL Server objects into a portable artifact called a DAC package, also known as a DACPAC. That in itself is, I think, very powerful.
Ostensibly a dacpac is a binary file so you can't just open it up in your favourite text editor and look at the contents of it. However, what many people do not know is that the format of a dacpac is simply the common ZIP compression format and hence we can add .zip to the end of a dacpac filename:
and open it up like you would any other .zip file to have a look inside. If you do so you will see this:
The contents of that zip file conform to something called the Open Packaging Convention (OPC). OPC is a standard defined by Microsoft for, well, for zipping up files basically. You have likely used files conforming to OPC before without knowing it, docx, .xlsx, .pptx are the most common ones that you might recognise if you use Microsoft Office and there are some more obscure ones such as .ispac (SSIS2012 developers should recognise that). (For a more complete list of OPC-compliant file types see the wikipedia page).
Notice in the screenshot above showing the innards of TSQLCodeLibrary.dacpac the biggest file is model.xml. This is the file that contains the definition of all our SQL Server objects. I won't screenshot that here but I encourage you to get hold of a .dacpac file (here's one) and have a poke around to see what's in that model.xml file.
Dacpacs are used for deploying SQL Server objects to an instance of SQL Server. That's it. If your job does not ever involve doing that then you probably don't need to read any further.
A .docx file (i.e. A Microsoft Word document) isn't much use to someone if they don't have the software (i.e. Microsoft Word) to make use of it and so the analogy holds for dacpacs; in order to use them you need to have some software installed and that software is called the Data-tier Application Framework (or DAC Framework for short, or DacFx for even shorter).
Incidentally, you may be wondering what DAC stands for at this point. I think its "Data-Tier Application" in which case you may be thinking that the acronym DAC is a stupid one especially as DAC also stands for something else in SQL Server, I would agree!
DacFx is available to download for free however you'll probably never need to do that as installation of DacFX occurs whenever you install SQL Server, SQL Server client tools or SQL Server Data Tools (SSDT). If DacFX is installed you should be able to see it in Programs and Features:
In dacpac nomenclature the correct term for deploying a dacpac is publishing however the two generally get used interchangeably. There are two methods of publishing a dacpac which I'll cover below.
In SSMS's Object Explorer right-click on the databases node and select "Deploy Data-tier Application…" (told you they used those terms interchangeably):
This launches a wizard that prompts you to choose a dacpac, fill in some particulars (e.g. database name) and then deploy it for you by calling out to DacFx. Unfortunately this wizard is not very good because it doesn't (currently) support all features of dacpacs, namely if your dacpacs contain any sqlcmd variables (I won't cover those here but they are commonly used within dacpacs) a value needs to be supplied for them; the wizard doesn't prompt you for a value and hence the deployment fails.
This. Is. Stupid. Microsoft should be suitably lambasted for not providing this basic functionality. Anyway, due to this limitation you're most likely to be using the other method which is…
One component distributed in DacFx is a command-line tool called sqlpackage.exe which will quickly become your best friend if you use dacpacs a lot. sqlpackage.exe can do a lot of things and those "things" are referred to as actions, one of those actions is publishing a dacpac. Here's the syntax for publishing a dacpac using sqlpackage.exe:
"%ProgramFiles(x86)%\Microsoft SQL Server\110 \DAC\bin\SqlPackage.exe" /action:Publish /SourceFile:<path to your dacpac> /TargetServerName:<SQL instance you are deploying to> /TargetDatabaseName:<Name of either (a)the database to create or (b) the existing database to deploy into>
Notice from my comment above for TargetDatabaseName that you can deploy to an existing database. You might ask why you might want to publish into an existing database, after all, the objects you are publishing might already exist. This segues nicely into what I see as the biggest benefit of dacpacs and DacFx, the software interrogates the target database to determine whether or not the objects already exist or not and if they do not it will create them. If they do already exist it will determine whether the definition has changed or not and if it has, it will make those changes. DacFx will always protect your data so if it determines that an operation would cause data destruction (e.g. removing a column from a table) then it will (optionally) throw an error and fail. You never again need to write an ALTER statement or first check that an object exists in order to change an object definition, DacFx will do it for you. To put it another way, publishing using dacpacs and DacFx is idempotent.
Of course in order to publish a dacpac you're first going to have to create one and one of Jonathan's questions above pertained to exactly this. There are two distinct ways to do create a dacpac.
SQL Server Data Tools (SSDT) projects are basically a project type within Visual Studio that provide a way of building DDL for SQL Server databases. I'm not going to cover SSDT projects in any detail here except to say that when such a project is built the output is a dacpac. Note that SSDT can also publish the dacpac for you however I didn't mention that above as the publish operation is essentially another wrapper around the same DacFx functionality used by sqlpackage.exe.
One can right-click on a database in SSMS and click on "Extract Data-tier Application…" to create a dacpac containing the definition of all objects in that database:
Should you be using dacpacs? I can't answer that question for you but hopefully what I've done is given you enough information so that you can answer it for yourself. Some people might like the way dacpacs encapsulate many objects into a single file and their idempotent deployment, others may prefer good old simple, handcrafted T-SQL scripts which don't have any pre-requisites other than SQL Server itself. The choice is yours.
David Atkinson from Redgate has been in touch to tell me about another dacpac feature that I didn't know about. It is possible to right-click on a dacpac in Windows Explorer and choose to unpack it:
That essentially unzips it but what you also get is a file called Model.sql that will create all of the objects in the dacpac:
Very useful indeed! David tells me that Redgate use this functionality to enable comparison of a dacpac using their SQL Compare tool as you can read about at Using a DACPAC as a data source.
Like many (most???) T-SQL developers I keep a stash of useful code that I've garnered down the years because I know its all going to come in useful at some point in the future. It includes code I've written myself and also code that others have shared on their own blogs. For example my code library includes the following:
I've never seen the point of keeping one's code library to one's self, might as well share it in case anyone else might find it useful, so up to now I've kept my collection of scripts publicly available on SkyDrive (go see it if you like).
That's all fine and dandy but I figured this could be improved. SkyDrive is a file sharing site and whilst it includes a nice code viewer/editor it is not an ideal solution for storing code, code should be stored in a version control system (e.g. Git, TFS, Subversion, etc..). I opted to make my code library available on Github at https://github.com/jamiekt/TSQLCodeLibrary/ because it provides:
and moreover all the cool kids seem to be using Github so I figured I'd give it a bash as well.
The code library exists as a collection of views, functions and stored procedures in an SSDT project. I'm a massive fan of SSDT so there were many reasons for my choosing to do this but the overriding reason was that SSDT provides a single binary (i.e. a dacpac file) containing the entire code library that can be distributed as easily as emailing the file to someone. Deploying a dacpac is pretty simple and so is a great method for sharing T-SQL code.
What's in my T-SQL code library?
In this first release, not much. There are only nine objects though I hasten to add that this is only a first release and I have a backlog of stuff that I need to add in there. One of the many advantages of using SSDT is that it makes it easy to add extended properties to describe the objects and the code library includes a view that surfaces all of that extended property information:
SELECT schema_name,object_name,object_type,CodeLibraryDescription FROM jt.[vwCodeLibraryDescriptions]
How do you install the code library?
Download the two binaries:
and store them together in a folder. Open a command prompt at that folder and type:
"%ProgramFiles(x86)%\Microsoft SQL Server\110\DAC\bin\SqlPackage.exe" /action:Publish /SourceFile:TSQLCodeLibrary.dacpac /TargetServerName:"<your_sql_instance>" /TargetDatabaseName: <prefered_database_name> (replacing <your_sql_instance> with the name of the SQL Server instance where you want to create the code library and <prefered_database_name> with whatever you want the database to be called. Get rid of the line feeds as well, they are just used here for clarity)
This will create a SQL Server database containing my code library:
If any of the code in my code library proves useful to you then that's great however my wish here is that some of you other folk out there feel motivated to share your own code in a similar manner. If you do so please post a comment below and let me know.
Yesterday on Twitter Ryan Desmond asked Is there a good read for #SSDT regarding deploying changes via schema compare vs solution deployment?
I don't know of any article that covers this so in this blog post I offer my opinion on the subject.
First some background. When building databases offline using the database project type (.sqlproj) in SSDT you have two options for deploying the DDL code in your project into a physical database:
Under the covers both do the same basic operation; build a dacpac from your project, compare it to the target database, build a script that will make the requisite changes to the target database, execute that script.
Ryan was asking which of these one should use. I suggested that publishing was a better option and here are two reasons why:
Does anyone out there have a different opinion? Let me know in the comments.
I stumbled upon an interesting little nuance of SQL Server's behaviour over the past few days that I was not aware of and I figure its worth talking about it here so others are aware. It concerns the handling of the german character "ß" which I understand to be german shorthand for "ss" (I'm no expert on language or linguists so don't beat me up if I'm wrong about that).
In short, two NVARCHAR values that differ only by one using "ß" and the other using "ss" will be treated as the same. This is easily demonstrated using the following code snippet:
SELECT 'Oktoberstrasse' UNION SELECT 'Oktoberstraße'; SELECT N'Oktoberstrasse' UNION SELECT N'Oktoberstraße';
which returns:
(Collation on my database is set to 'SQL_Latin1_General_CP1_CI_AS')
Notice that casting the values as NVARCHAR (which is what the N'' notation does) causes SQL Server to treat them as the same. Obviously this is going to cause a problem if you need to treat those as distinct values (such as inserting into a column with a unique key upon it – which is the problem I encountered that caused me to stumble across this)
There is a bug submission to Connect regarding this issue at 'ß' and 'ss' are NOT equal in which a member of the SQL Server team says:
Our current behavior follows the SQL/ISO standard and unless those standards are updated with the latest changes we don't intend to change the behavior in SQL Server. Changing existing SQL Server behavior has lot of implications and today we rely on Windows for all of our windows collation sorting capabilities. If and when in the future Windows adopts these new rules / Unicode standard we will incorporate it in SQL Server.
In other words, SQL Server is merely following the behaviour as defined by the International Standards Organisation so its not a bug in SQL Server as such, just a nuance that one needs to be aware of. And now you are.
I love me a good keyboard shortcut and there's some I would like to use in Excel all the time if only I could darn well remember them.
CTRL+ Spacebar Select the entire column containing the currently selected cell(s) Shift + Spacebar Select the entire row containing the currently selected cell(s) CTRL + '+' Insert cells CTRL + '-' Delete cells
If you combine these you'll find they become really powerful. For example, CTRL+Spacebar followed by CTRL + '+' inserts a new column into a worksheet (which is what I wanted to do this morning when I began googling this).
I figured the only way I will ever ingrain these into my muscle memory is if I write them down somewhere, nowhere better than on my blog.
If you're a fellow keyboard shortcut fetishist and want to share any obscure ones that you know of then I'm all ears, please put them in the comments below.
One of my biggest laments about being a SQL Server developer is that the tools provided by Microsoft to do our thang compare woefully to the feature rich, (largely) bug-free, "it-just-works" impression that one gets from seeing the tools available to "other" developers in the Microsoft ecosystem (I'm thinking of our appdev brethren here, the ones that use C#, Javascript, and all that jazz). I could write a long blog post complaining about this (and perhaps one day I will) but in this blog post I want to shine a light on a tool called Linqpad.
Linqpad enables you to issues queries written in LINQ against a database and in that respect is an alternative to SQL Server Management Studio (SSMS). What is LINQ? It stands for Language Integrated Query and is a technology that Microsoft brought out a few years ago for writing queries inside .Net code. The great thing about Linqpad is that it enables one to write LINQ queries without having to know anything about .Net.
In the screenshots below I show a simple query against a database but written two ways, one using T-SQL that anyone reading this blog post will likely know, and one using LINQ:
Some things to notice here. The two queries look very similar in that they contain the same keywords {SELECT, FROM}. Second thing to notice is that the FROM clause comes before the SELECT clause and if you know anything about the logical order of execution of a SELECT query you'll realise that this intuitively makes sense. Lastly the table is called [dbo].[BulletinLine] but in the LINQ query its called [BulletinLines], its been pluralised (a convention that is common to .Net developers) and there's no [dbo] prefix. Other than those things its intuitively clear that these two queries are doing exactly the same thing and its worth pointing out that under the covers the LINQ query is converted into a T-SQL query.
So OK, if you accept that LINQ can do pretty much anything that a T-SQL SELECT query can do the next obvious question is "Why should I bother when T-SQL already does what I need?" The answer, in a word, is productivity. Or, to put it another way, intellisense works properly. Let's say for example I want to select a subset of all the columns, intellisense comes to our aid:
One might well retort "well that works in SSMS as well" but in my experience intellisense in SSMS is, at best, flaky. In some circumstances it simply doesn't work and the worst part of this is that its often inexplicable as to why. (In case you can't tell, intellisense in SSMS drives me up the wall and I'm sure I'm not the only one.)
Some other nice things about LINQ. Here's the equivalent of a WHERE clause to filter on [BulletinId]=6:
If you don't know LINQ then (in my opinion) its not intuitively obvious what's going on here. What the above query is doing can effectively be described as:
Take the collection of BulletinLines, filter in WHERE BulletinId equals 6
Where this gets really powerful is the ability to stack these things up like so:
Take the collection of BulletinLines, filter in WHERE BulletinId equals 6. From the resultant collection filter in WHERE Colour="White"
If we only want the top 3:
Take the collection of BulletinLines, filter in WHERE BulletinId equals 6. From the resultant collection filter in WHERE Colour="White". From the resultant collection take the first 3
I love how expressive this is and when you get fully conversant with LINQ its wonderfully intuitive too. If I haven't convinced then, well, that's OK. If you're not convinced but do want to be convinced then check out Why LINQ beats SQL. The overriding argument there is "LINQ is in most cases a significantly more productive querying language than SQL". Make sure you check out the section entitled "Associations" too which demonstrates how you can filter based on what is known about an entity in other tables, when you grok what's going on there you'll realise the power that LINQ brings.
If you want to give this a go then go and download Linqpad now from http://www.linqpad.net/. Its free however some of the more advanced features (such as intellisense) only light up when you pay for the pro or premium edition which are priced at $39 & $58 respectively for a perpetual license, a bit more than the app generation are used to paying but hardly bank-breaking either.
Are any other SQL developers out there using Linqpad? Please share your experiences in the comments below, I'd really like to read them.
Last Thursday I presented my session "Introduction to SSDT" at the SQL Supper event held at the offices of 7 Digital (loved the samosas, guys). I did my usual spiel, tour of the IDE, connected development, declarative database development yadda yadda yadda… and at the end asked if there were any questions. One gentleman in attendance (sorry, can't remember your name) raised his hand and stated that by attempting to evangelise all of the features I'd missed the single biggest benefit of SSDT, that it can tell you stuff about database that you didn't already know.
I realised that he was dead right. SSDT allows you to import your whole database schema into a new project and it will instantly give you a list of errors and/or warnings pertaining to the objects in your database. Invalid references (e.g a long-forgotten stored procedure that refers to a non-existent column), unnecessary 3-part naming, incorrect case usage, syntax errors…it'll tell you about all of 'em! Turn on static code analysis (this article shows you how) and you'll learn even more such as any stored procedures that begin with "sp_", WHERE clauses that will kill performance, use of @@IDENTITY instead of SCOPE_IDENTITY(), use of deprecated syntax, implicit casts etc…. the list goes on and on.
I urge you to download and install SSDT (takes a few minutes, its free and you don't need SQL Server or Visual Studio pre-installed), start a new project:
right-click on your new project and import from your database:
and see what happens:
You may be surprised what you discover. Let me know in the comments below what results you get, total number of objects, number of errors/warnings, I'd be interested to know!
In a few months time I will, in association with Technitrain, be running a training course entitled Introduction to SQL Server Data Tools. I am currently working on putting together some hands-on lab material for the course delegates and have decided that in order to save time in asking people to install software during the course I am simply going to prepare a virtual machine (VM) containing all the software and lab material for each delegate to use. Given that I am an MSDN subscriber it makes sense to use Windows Azure to host those VMs given that it will be close to, if not completely, free to do so.
What I don't want to do however is separately build a VM for each delegate, I would much rather build one VM and clone it for each delegate. I've spent a bit of time figuring out how to do this using Powershell and in this blog post I am sharing a script that will:
The script has one pre-requisite that you will need to install, Windows Azure Powershell. You also need to be a Windows Azure subscriber which, if you're reading this blog post, I'm assuming you already are.
Simply download the script and execute it within Powershell, assuming you have an Azure account it should take about 20minutes to execute (spinning up VMs and shutting the down isn't instantaneous). If you experience any issues please do let me know.
There are additional notes below.
Select 'Yes'
Fresh from a successful UK tour in June the SQL Relay team are at it again. This time there are ten venues all around the UK between 11th and 29th November.
Head to http://www.sqlrelay.co.uk/ to sign-up. I'll be at the London one, hope to see you there!
I discovered a little wrinkle in SSDT today that is worth knowing about if you are managing your database schemas using SSDT. In short, if a file is moved to a different folder in the project then any code analysis suppressions that reference that file will disappear from the suppression file. This makes sense if you think about it because the paths stored in the suppression file are no longer valid, but you probably won't be aware of it until it happens to you. If you don't know what code analysis is or you don't know what the suppression file is then you can probably stop reading now, otherwise read on for a simple short demo.
Let's create a new project and add a stored procedure to it called sp_dummy.
Naming stored procedures with a sp_ prefix is generally frowned upon and hence SSDT static code analysis will look for occurrences of this and flag them. So, the next thing we need to do is turn on static code analysis in the project properties:
A subsequent build causes a code analysis warning as we might expect:
Let's suppose we actually don't mind stored procedures with sp_ prefixes, we can just right-click on the message to suppress and get rid of it:
That causes a suppression file to get created in our project:
Notice that the suppression file contains a relative path to the file that has had the suppression placed upon it. Now if we simply move the file within our project to a new folder notice that the suppression that we just created gets removed from the suppression file:
As I alluded above this behaviour is intuitive because the path originally stored in the suppression file is no longer relevant but you're probably not going to be aware of it until it happens to you and messages that you thought you had suppressed start appearing again. Definitely one to be aware of.
A long long long time ago (in 2006 in fact) I published a blog post entitled Suggested Best Practises and naming conventions in which I suggested a bunch of acronyms that folks could use to prefix object names in their SSIS packages, thus allowing easier identification of those objects in log records, here is a sample of some of those suggestions:
If you have adopted these naming conventions (and I am led to believe that a bunch of people have) then you might like to know that you can now check for adherence to these conventions using a tool called BI-xPress from Pragmatic Works. BI-xPress includes a feature called the Best Practices Analyzer that scans your packages and assess them according to some rules that you specify. In addition Pragmatic Works have made available a collection of these rules that adhere to the naming conventions I specified in 2006
You can download this collection however I recommend you first read the accompanying article that demonstrates the capabilities of the Best Practices Analyzer. Pretty cool stuff.


text:
As of Tuesday, November 13, 2012
© Copyright 2014
Clayton News Daily
Jackie Nichols, of Jonesboro, passed away on Nov. 1, 2012; she was a member of the First Baptist Church of Jonesboro.
Jackie is survived by her children, Michael Nichols, Michelle Nichols Glaser and Marshall Nichols, two grandsons, Michael and Matthew Nichols, great-grandson, Caden Nichols, and her sister, Louise Jackson, and daughters-in-law, Gayla Nichols and Lauren Nichols. A memorial service will be held at 2 p.m. on Nov. 18, at The First Baptist Church of Jonesboro with Rev. W. Irvin Pearre and music accompaniments by Roy Pearre. She will be truly missed by her family and all of her very special friends. SouthCare Cremation and Funeral Society in Stockbridge. 770-692-1181.


text:
Cost-Free Flower Arrangements
Experts at The New York Botanical Garden give you the basics of making flower arrangements with materials gathered from your
own garden. » See Photos
- Loading comments...
More from MyHomeIdeas
Most Popular Features
Our 50 Favorite Built-In Storage Ideas
Browse these custom storage and organization ideas to find ways to maximize space in every room of your house. - 25 Ways to Create an Outdoor Oasis
- Creative Dorm Room Decorating Ideas
- Maximize Your Kitchen Storage
- 50 Beautiful Beach-Inspired Bedrooms


text:
Ear Infection They always ask at the doctors office why you are there, and you have to answer in front of others w...read more 2/26/2014 1:35:01 PM 2,565
A Wife and Husband Visit The Doctor A woman accompanied her husband to the doctor's office. After his checkup, the doctor called the wif...read more 7/17/2013 10:16:23 AM 10,169
The Dirty Doctor A beautiful woman walks into a doctor's office one day and the doctor is bowled over by her stunning...read more 1/2/2013 12:00:00 AM 20,001
Old Woman Wants To End It All A very old woman realizes that she's seen and done everything and the time has come to depart from t...read more 11/27/2012 12:00:00 AM 13,362
Old Man and Two Nymphomaniacs So this older guy goes to the doctor asking for a prescription for 'Viagra'. The guy asks for a larg...read more 10/16/2012 12:00:00 AM 14,401
Vasectomy - Redneck Style After having their 11th child, an Alabama couple decided that was enough, as they could not afford a...read more 8/19/2012 12:00:00 AM 21,684
I Want Bigger Boobies A flat-chested young lady went to Dr. Smith for advice about breast enlargements. He told her, "Ever...read more 6/21/2012 12:00:00 AM 17,336
7 Dollar Sex An Arizona couple, both well into their 80's, go to a sex therapist's office. The doctor asks, '...read more 5/14/2012 12:00:00 AM 23,158
Only 6 Weeks To Live An elderly man goes into his doctors office for an annual physical. After a while, the doctor comes ...read more 3/6/2012 12:00:00 AM 17,549
The Doctor and The Patient "I've got some good news and some bad news" the doctor says. "What's the bad news?" asks the pat...read more 1/17/2012 12:00:00 AM 18,097


text:
Malaysia Airlines Says It Lost Contact With Plane
By KEITH BRADSHER
A Boeing 777-200 that was carrying 239 people did not arrive in Beijing and had lost contact with air traffic control two hours after taking off from Kuala Lumpur.
Saturday, March 8, 2014 Last Update:
A Boeing 777-200 that was carrying 239 people did not arrive in Beijing and had lost contact with air traffic control two hours after taking off from Kuala Lumpur.
A dispute over a classified C.I.A. report has led to a bitter fight between the agency and the Senate Intelligence Committee, with each side accusing the other of spying.
If House Republican leaders have not yet killed an immigration measure, it may be because of the growing power of Latinos at the ballot box.
Leaders of both houses of Russia's Parliament said that they would support a vote by Crimeans to break away from Ukraine, ignoring sanctions threats and warnings.
Unlike the old Soviet Union, Russia has a stock market, and an economy heavily reliant on exports to Europe.
The American economy added 175,000 jobs in February, well above the anemic job gains in December and January.
For the middle-class town Lake of the Woods, the absence of rain is posing a fundamental threat to drinking water.
Turkey's president voiced resistance after Prime Minister Recep Tayyip Erdogan, who is facing a corruption inquiry, vowed to restrict sites like YouTube and Facebook.
With physical and virtual visits "off the charts," libraries across the country are thinking up innovative ways to keep users happy.
The employment rate will not improve on its own, but there is little help in sight from policy makers.
A bank in Chicago got publicity but little satisfaction after it identified a source of debit card theft and tried to stop it, Ron Lieber writes.
"The Grand Budapest Hotel" is both a caper and something more complex.
The Rendez-Vous With French Cinema festival spotlights rough-edged films.
A supersmart dog and his adopted human son set out for adventures in "Mr. Peabody & Sherman."
This week's homes include a rowhouse in Washington, D.C.; an adobe in New Mexico; and a 1902 home in Washington State.
Rising sales bring optimism to this year's Geneva Motor Show, even as a crisis erupts in an important auto market.
"I have an office, but most of the time I just walk around and try to determine if we've got any problems."
Find the best job in the New York metro area and beyond.
Opinion »Taking Note: Why Darrell Issa Turned Off the MicWhen politicians in the House majority resort to silencing their critics, you know they've lost the argument. |
Opinion »Editorial: A Smart Retreat on ImmigrationSouth Carolina moved closer to acknowledging the futility of oppressive immigration laws when it abandoned key parts of its harsh law. |


text:
Graduate Program Flyer
Paid Internship - Wikimedia (in San Francisco)
Advising begins the 2nd week of the Spring 2014 semester. Please watch this short video on how to select your major courses.
Graduation petitions are due 2 semesters in advance of your graduation. Please watch this short video on how to fill out your graduation petition.
Spring 2014 Syllabi
If for some reason you have to withdraw this semester - please read the instructions for withdrawing and deadlines for refunds here.
Positions at ADM Associates (ignore the March 30, 2012 deadline submission date). More information here.
Student position for Program and Operations Planning Group in Customer and Community Services Business Unit. Full job description can be accessed through smud.org
Work Full Time as an Energy Analyst at the CA State Energy Commission. How to apply - for details on Energy Commission and civil service exams - click here. For Current job opportunities and tips for applying for jobs at the Energy Commission, click here.
Need Help with your Graduation Petition?
Follow this video and find out how to fill out a correct graduation petition.
Need an Advisor NOW??
Watch this video and get a start on choosing your classes for the Econ Major.
Economics Department Mentor Program. For more information, please wait for an update coming in August 2013.
Fall 2012 Syllabi
Spring 2011 Syllabi
Fall 2011 Syllabi
Internships/Job Opportunities
USDA Forest Service Outreach Notice
Internship Opportunity at GoED - Governor's Office of Economic Development. - no deadline listed
Internship for Grad Student - PERS - no deadline listed
U.S. Economic Research Service (ERS) - Lists job openings requiring a Master's Degree or Ph.D.
Economics is a social science that examines the functioning of markets, the determination of prices and distribution of income, and the determination of the overall level of income and rates of unemployment and inflation. In addition, Economics deals with various social problems. The Economics major at Sacramento State is designed to provide students with a liberal education with special emphasis on the economic aspects of society; on familiarization with techniques for the analysis of contemporary economic problems; and on developing the ability to think critically, to conceptualize and to possess the communication and computer skills to evaluate private and public policy issues.
The Economics program is appealing to students due to the quality of its faculty, the breadth of its course offerings, and the amount of choice it offers the student in planning his or her course work. In addition to training in the traditional economics areas, the program offers such diverse courses as: The California Economy; State and Local Finance; Energy; Environmental and Resource Economics, and Urban Economics. Students find the Department of Economics congenial to their educational and career objectives.
The Economics Minor
A Minor in Economics may be especially attractive to students majoring in Mathematics, Business Administration, Government, Environmental Studies - or any of the other Social Science disciplines. The Economics minor adds both theoretical and analytical depth. In addition, it provides the historical and institutional background important to an understanding of contemporary economic issues. It offers students in other majors a broader-based undergraduate education while widening the choice of job possibilities. Employers view the minor in Economics favorably.
The Center for Economic Education
The Economic Education Certificate Program is designed to give participants a solid foundation in economics that will enable them to teach the subject in primary and secondary schools. Participants who are not enrolled at Sacramento State may take these courses through the College of Continuing Education. For more information about the program, please contact the Director for Economic Education: Dr. Tim Ford


text:
BOSTON (AP) — Tamerlan Tsarnaev was an amateur boxer with muscular arms and enough brio to arrive at a sparring session without protective gear. His younger brother Dzhokhar was popular in high school, won a city scholarship for college and liked to hang out with Russian friends off-campus.
Details of two lives, suddenly infamous, came to light Friday. Overnight, two men previously seen only in grainy camera images were revealed to be ethnic Chechen brothers suspected in a horrific act of terrorism. Tamerlan was dead; his 19-year-old brother would be captured after a furious manhunt that shut down much of Boston.
But the details of their lives shed precious little light on the most vexing question: Why would two brothers who came to America a decade ago turn on their adopted home with an attack on a cherished tradition, the Boston Marathon?
The Tsarnaev family arrived in the United States, seeking refuge from strife in their homeland. ''Why people go to America? You know why,'' the father, Anzor Tsarnaev, said in an interview from Russia, where he lives now. ''Our political system in Russia . Chechens were persecuted in Kyrgyzstan, they were problems.'' The family had moved from Kyrgyzstan to Dagestan, a predominantly Muslim republic in Russia's North Caucasus that has become an epicenter of the Islamic insurgency that spilled over from Chechnya.
The father set up as an auto mechanic, and the two boys (there were two sisters, too) went to school. Dzhokhar, at least, attended the Cambridge Rindge and Latin school, a prestigious public school just blocks from Harvard Yard.
From there, the boys' paths diverged somewhat — at least for a while.
Tamerlan, who was 26 when he was killed overnight in a shootout, dropped out after studying accounting at Bunker Hill Community College for just three semesters.
''I don't have a single American friend. I don't understand them,'' he was quoted as saying in a photo package that appeared in a Boston University student magazine in 2010.
He identified himself then as a Muslim and said he did not drink or smoke: ''God said no alcohol.'' He said he hoped to fight for the U.S. Olympic team and become a naturalized American.
As a boxer, he was known for his nerve. ''He's a real cocky guy,'' said one trainer who worked with him, Kendrick Ball. He said the young man came to his first sparring session with no protective gear. ''That's unheard of with boxing,'' Ball said. But he added: ''In this sport, you've got to be sure of yourself, you know what I mean?''
More recently, Tamerlan — married, with a young daughter — became a more devout Muslim, according to his aunt, Maret Tsarnaeva. She told reporters outside her Toronto home Friday that the older brother had taken to praying five times a day.
In 2011, the FBI interviewed Tamerlan at the behest of a foreign government, a federal law enforcement official said, speaking anonymously. The officials would not say what country made the request or why, but said that nothing derogatory was found.
Albrecht Ammon, 18, lived directly below the apartment of the two suspects. He said he recently saw Tamerlan in a pizzeria, where they argued about religion and U.S. foreign policy. He quoted Tsarnaev as saying that many U.S. wars are based on the Bible, which is used as ''an excuse for invading other countries.''
During the argument, Ammon said, Tsarnaev told him he had nothing against the American people, but he had something against the American government. ''The Bible was a cheap copy of the Koran,'' Ammon quoted Tsarnaev as saying.
Tamerlan traveled to Russia last year and returned to the U.S. six months later, government officials told The Associated Press. More wasn't known about his travels.
According to law enforcement records he was arrested, in 2009, for assault and battery on a girlfriend; the charges were dismissed. His father told The New York Times that the case thwarted Tamerlan's hopes for U.S. citizenship.
Meanwhile, the mother of the suspects, Zubeidat Tsarnaev, was heard from only in an audio interview broadcast on CNN, defending her sons and calling the accusations against them a setup. She said she had never heard a word from her older son about any thinking that would have led to such an attack. ''He never told me he would be on the side of jihad,'' she said.
Her younger son was described by friends as well-adjusted and well-liked in both high school and college, though at some point in college, his academic work reportedly suffered greatly.Continued...


text:
Create and manage categories in Labs General Feedback. Removing a category will not remove content.
Create and manage announcements in Labs General Feedback. Try to limit the announcements to keep them useful.
Subject | Author | Date | Actions |
Enter your announcement details below, including when you would like it to become active and expire. By default, announcements will become active immediately and expire in 7 days.
Please let us know what you think of the Adobe Labs site or let us know of any problems (broken links, etc.). Please be sure to direct technology-specific feedback to the appropriate top-level forum rather than here.
If you have feedback on the Adobe Labs Ideas site, please utilize the subform linked below.
There are no sub-forums.
A few tips to get answers quickly:
Use Google Custom Search on select Adobe and community help content.


text:
Carlisle Bay - Low Season Super Chill Out 2014 Book an all-inclusive stay at Carlisle Bay for a minimum of three nights between 24 April and 22 August and 18 October and 19 December 2014 to enjoy a super chill out package. Hot offer Applies to Carlisle Bay
Summer Getaway at Verdura - save 25% Book early to save 25% on bookings to Verdura this summer. Hot offer Applies to Verdura Golf & Spa Resort
2 for 1 at Azura Quilalea 2 for 1 offer at Azura Quilalea for stays of 7 nights. Hot offer Applies to Azura at Quilalea
Free Childcare in Courchevel 1850 this March Book a selected Scott Dunn chalet for a ski holiday in March 2014 in Courchevel 1850 and benefit from our renowned childcare free of charge. Hot offer Applies to7 properties
Inclusive 'Sporty Offer' at Les Sherpas in Courchevel Book an end of season stay at Les Sherpas hotel in Courchevel 1850 and enjoy some added benefits such as ski hire, massages & ski instruction included in your holiday. Hot offer Applies to Les Sherpas
Free Scott Dunn Explorers club spaces Enjoy free places in our exclusive Scott Dunn Explorers children's clubs at Sun Gardens, Daios Cove and Verdura for babies, toddlers and pre-school children. Hot offer Applies to3 properties
Book a 5 night stay and receive free daily spending credit Book a 5 night stay at Chalet Zannier in Megeve and get between 75 and 125 euros daily spending credit, depending on room category booked. Hot offer Applies to Le Chalet Zannier
Free nights and free ski at the W Verbier Save up to 30% with a special free nights' offer at the brand new W Verbier Hotel & Residences Hot offer Applies to W Hotel Verbier
Special offers on selected dates at the Portetta The Portetta Hotel is offering reduced rates for seven night stays on selected weeks during the season. Prices are based on two people sharing a room on a half board basis. Please contact us for details. Hot offer Applies to Le Portetta
2014 Summer Discounts at the Abama Golf & Spa Resort Receive a 15% early booking discount when you book before the 31st March for your Summer 2014 holiday to the Abama. This offer is valid on all room types and works on an accumulative basis, plus its combinable with the Abama Free nights offer. Hot offer Applies to ABAMA


text:
A look back at Mayor Michael Bloomberg and the fashion industry though the years.
Click Here to View a Slideshow of Bloomberg and the Fashion Industry >>
RELATED STORY: The Bloomberg Effect — Fashion and the Mayor >>
Sign in using your Facebook or Twitter account, or simply type your comment below as a guest by entering your email and name. Your email address will not be shared. Please note that WWD reserves the right to remove profane, distasteful or otherwise inappropriate language.Ads by Google


text:
Bangkok, Thailand
We have stayed in Sivarin Guesthouse only one night (pity) but it was our second guest house in Bangkok. Definitely I would choose this one for my next trip! Great atmosphere, good service, very helpful staff and great location.
Rooms were nice, and in room we could find a little booklet with useful information about traveling in Thailand/possible trips etc. Very practical if you are a first timer (like us).
Jodhpur, India
Nice place in the middle of the old city. The place is just correct and just clean. The roof top and the staff are very nice. The views from the top are very nice and the place has a garden inside on the main entrance. Wifi was correct.
Negombo, Sri Lanka
Expensive room but very near the bus stand in negombo. The room is not very clean. I think the price is not real to the service provided. Is possible to use the fridge and some kitchen items. If you need to stay there to take the bus the next day is a good alternative, if not, I would go to the beach to look for a more cheap place. The staff is nice.


text:
Archy is an assistant for Archaeologists that want information at their finger tips.
Translators: http:www.wowace.com/addons/archy/localization/
Bug reports/suggestions: WoWAce Tickets system
Bugs reported in comments will be deleted.
- Localized for English, French, German, Russian, Spanish, and Traditional Chinese users
- On-screen customizable and movable list for the dig sites on the continent you are current on
- On-screen customizable and movable list of the artifacts you are researching that can be filtered to display only the races for the continent you are on
- Racial fragment types are shown for each of the dig sites
- Solve artifacts with (left click) or without (right click) keystones by clicking on the racial crest icon in the on-screen artifacts list or bind a key for a one stop solve shop
- TomTom support to help you navigate between dig sites
- Able to display dig sites on the minimap (closest only or all dig sites)
- Able to display dig site boundaries on the battlefield mini map
- Blacklist dig sites in the on-screen digsite list by right clicking on the dig site name. Perfect for when you have a bugged node or a dig site that is in a zone that you dislike.
- Blacklist races so they do not appear in your artifacts on-screen list and won't be used when the artifact solve keybind is pressed
- Sound triggers for when you have enough fragments and/or keystones to solve an artifact
- A dig recorder to see where at a dig site you have successful dug
- LDB Tooltip showing missing rare artifacts per race and overall archaeology progress
- many more features
Minimap Button Frame and other similar addons
All Minimap based frames (such as nodes, dig sites and dig site boundaries) have been prefixed now with ArchyMinimap
To stop these addons from taking these frames from the minimap, add the following item to their protected items list: ArchyMinimap
Mini-Guide to Fewer Digs
In the deDE.lua there is at least one phrase missing:
L["Visit a trainer"] = "Besucht einen Lehrer"
You are stating that you support multiple languages, but instead you can only parse English clients.
This is because of Line 19 in ArchyDigsites.lua and similar places in the code
fragment_type, amount = strmatch(msg, "You receive currency: (.+) Archaeology Fragment x(%d+)")
I can help you to make it available for German also, I have done this for my local version of you Addon, but I'd like to contribute so other people here can also profit from this very nice addon.
Regards, Mattion
Date: 2010-12-18 09:20:20
Error occured in: Global
Count: 1
Message: ..\AddOns\Archy\Archy.lua line 963:
attempt to concatenate local 'y' (a nil value)
(tail call): ?
Archy\Archy.lua:963: CreateNodeMinimapIcon()
Archy\Archy.lua:929: AddNodeMinimapIcons()
Archy\Archy.lua:891: RefreshNodeMinimapIcons()
Archy\Archy.lua:886: RefreshMinimapIcons()
Archy\Archy.lua:790: UpdateDigsites()
Archy\Archy.lua:583: RefreshDigsites()
(tail call): ?
[string "safecall Dispatcher[2]"]:9:
[string "safecall Dispatcher[2]"]:5
(tail call): ?
...face\AddOns\Archy\Libs\AceTimer-3.0\AceTimer-3.0.lua:138 -
The problem madmike2 is talking about below is caused by these two lines in Archy.lua:
self.db.char.artifactReadyAnnounce = self.db.char.artifactReadyAnnounce or true; self.db.char.artifactReadyUsesKeystonesAnnounce = self.db.char.artifactReadyUsesKeystonesAnnounce or true;
You can remove them as a workaround until daihenka pushes a new version.
The state of the "Announce when an artifact can be solved" and the corresponding "Include keystones" options aren't saved between sessions so I have to turn them off every time I login. Is this intentional or a bug?
Please have a look at this topic: http://www.wowinterface.com/forums/showthread.php?t=37659
This error began to occur when I first hit a node in Dire Maul. It might be because the dig site in that zone exists off the regular zone map, and is marked on the world map instead, so the coordinates might be finicky.
Date: 2010-12-16 04:25:54
Error occured in: Global
Count: 1
Message: ..\AddOns\Archy\Archy.lua line 963:
attempt to concatenate local 'y' (a nil value)
(tail call): ?
Archy\Archy.lua:963 CreateNodeMinimapIcon()
Archy\Archy.lua:929 AddNodeMinimapIcons()
Archy\Archy.lua:891 RefreshNodeMinimapIcons()
Archy\Archy.lua:886 RefreshMinimapIcons()
Archy\Archy.lua:790 UpdateDigsites()
Archy\Archy.lua:583 RefreshDigsites()
(tail call): ?
[string "safecall Dispatcher[2]"]:9:
[string "safecall Dispatcher[2]"]:5
(tail call): ?
Ace3\AceTimer-3.0\AceTimer-3.0.lua:138 -
I am also getting same error happens when I first log in. if I disable archy and then re enable it the error goes away for a bit.
Message: ..\AddOns\Archy\Archy.lua line 963:attempt to concatenate local 'y' (a nil value)
Debug: (tail call): ? [C]: ? Archy\Archy.lua:963: CreateNodeMinimapIcon() Archy\Archy.lua:929: AddNodeMinimapIcons() Archy\Archy.lua:891: RefreshNodeMinimapIcons() Archy\ArchyDigsites.lua:44: Archy\ArchyDigsites.lua:12
Very nice addon. Is it possible to only show the digsites? I don't need to see the artifactinfos. Currently the addon won't keep track about previous digsites and found fragments. Is this because of the german client I'm using or is this worked on?
Please keep up the good work.
Message: ..\AddOns\Archy\Archy.lua line 963:attempt to concatenate local 'y' (a nil value)
Debug: (tail call): ? [C]: ? Archy\Archy.lua:963: CreateNodeMinimapIcon() Archy\Archy.lua:929: AddNodeMinimapIcons() Archy\Archy.lua:891: RefreshNodeMinimapIcons() Archy\ArchyDigsites.lua:44: Archy\ArchyDigsites.lua:12
Happened once, looting a archeology dig in the Thoradin's Wall digsite.
Edit: Also, going through the dark portal doesn't change the current digsites list to the outland ones, I had to reloadui.
Last edited Dec 13, 2010 by Shadowics
- Date created
- Oct 16, 2010
- Categories
- Last update
- Oct 09, 2013
- Development stage
- Release
- Language
- deDE
- enUS
- frFR
- ruRU
- License
- GNU Lesser General Public License version 2.1 (LGPLv2.1)
- Curse link
- Archy - Archaeology Assistant
- Downloads
- 5,860,920
- Recent files
- R: 1.8.43 for 5.4.0 Oct 09, 2013
- A: 1.8.42-2-gc354def for 5.4.0 Oct 09, 2013
- R: 1.8.42 for 5.3.0 May 22, 2013
- A: 1.8.41-5-geb61657 for 5.3.0 May 22, 2013
- A: 1.8.41-4-g1c159b9 for 5.3.0 May 22, 2013
- Tool used
- Astrolabe
- Optional dependency
- TomTom
- Embedded library
- Ace3
- AceGUI-3.0-SharedMediaWidgets
- CallbackHandler-1.0
- LibAboutPanel
- LibBabble-Artifacts-3.0
- LibBabble-DigSites-3.0
- LibDBIcon-1.0
- LibDialog-1.0
- LibQTip-1.0
- LibSharedMedia-3.0
- LibSink-2.0
- LibStub
- LibToast-1.0


text:
Financial Services
ShoreTel Sky Solutions for Financial Services
A better, less costly way of working
Financial services firms need to develop and manage client relationships, maximize resource utilization and improve operational efficiency. ShoreTel Sky offers a comprehensive set of solutions designed to meet these unique requirements.
The challenge is to find and embrace better, quicker, less costly, and more convenient ways of working. Successful firms will support effective work from any location. They will be able to expand or contract as conditions demand without damaging their market presence. And most importantly, they will provide an outstanding and consistent client experience.
- Call Coverage - Every call is important. Whether or not you require a complete contact center solution, with ShoreTel Sky you can utilize all of your resources with flexible teams and seamlessly distribute calls across offices or remote workers.
- Unity - Simplify and make your customer experience more consistent with four digit dialing between offices. Simplify the employee experience with hoteling. Just log in from any phone and go.
- Business Continuity - In the event of an emergency, easily re-route calls to another office, remote location or cell phones. Get voice mail alerts and transcriptions so you can return calls quickly.
- Integration - With voice application integration into your CRM application, client information becomes immediately available when the phone rings.
- Intelligence - Hello, Is anyone there? Do you know how often a client or prospect calls you, but it unable to reach a "real" person? With the Live Answer Service Metric, ShoreTel Sky business phone solution customers can tell exactly how many calls reach a person, regardless of which line is called or how many auto-attendants are used to direct the call.
Read These Resources
CM&F Group Story
CM&F was able to reduce costs, and improve customer care by utilizing metrics supplied by the ShoreTel Sky phone solution.
Fieldpoint Private Story
"ShoreTel helped us configure our phones to meet our exact requirements and have gone above and beyond what I expected from a technology partner."
John Carris Investments Story
"With ShoreTel Sky, you get the latest technology without continuously investing more dollars. But what makes it truly unique is the support we get from our ShoreTel Sky team, which is priceless."
National Holdings Corporation Story
"ShoreTel has helped keep our NYC Office up and running during the darkest days we have experienced."


text:
INDIANAPOLIS (AP) — The Indiana House has approved a plan to overhaul the state's specialty auto license plate system that requires all the groups with plates to sell 500 a year and undergo a financial review once a decade.
House members voted 92-6 in favor of the bill on Tuesday. A similar overhaul plan was derailed last year by some Republican legislators who sought to revoke the plate issued to a gay youth advocacy group.
A new bipartisan commission would review request for new plates and check reports about how the groups are spending their share of the money from the license plates.
The bill sets a limit of 150 specialty plates, while the state now has about 100 specialty plates.
The proposal now goes to the state Senate for consideration.
Copyright 2014 Associated Press. All rights reserved. This material may not be published, broadcast, rewritten or redistributed.
We welcome your thoughtful comments. Be the first to participate in the discussion. All comments will display your username and avatar.
Sign in or join now to post a comment. All comments will display your username and avatar.
Click the links below to get in touch with your elected officials.