text:
How Breastfeeding WorksAfter you give birth, hormones are released in your body. These hormones cause the alveoli, the tiny sacs deep in your breast tissue, to produce more colostrum, and in about three days, milk. Colostrum is very concentrated and helps protect the baby against illness because it is high in antibodies. The alveoli are connected to milk ducts, which lead to several openings in the nipples. When your baby sucks, she triggers the release of the hormone oxytocin, which stimulates milk flow. This is called the let-down reflex. The let-down response feels like pins and needles, or fullness from as high as the shoulders down to the nipples. Don't be concerned if you don't feel the let-down the first few days after birth; this is normal. Even though you might be feeling tired or stressed, just find as quiet and comfortable a place as you can to nurse - take a deep breath and relax as your baby latches on. Your baby is getting enough breast milk if she produces about six to eight wet/dirty diapers a day (more if you use cloth diapers). You have probably learned about breastfeeding from your health care provider or childbirth educator. In addition, almost all birth settings have lactation consultants (breastfeeding specialists) on staff to answer any questions you may have about infant feeding and help you get a good start. And if you choose to have a doula after the baby is born, she can also help you with any questions or concerns that may come up about breastfeeding. Finally, organizations such as La Leche League or Women, Infants and Children (WIC) offer breastfeeding support groups and can direct you to lactation consultants in your community. Most recent page update: 8/6/2012
© 2013 Childbirth Connection. All rights reserved.
Childbirth Connection is a national not-for-profit organization founded in 1918 as Maternity Center Association. Our mission is to improve the quality and value of maternity care through consumer engagement and health system transformation. Childbirth Connection promotes safe, effective and satisfying evidence-based maternity care and is a voice for the needs and interests of childbearing families. |
News and Features
Listening to MothersSM III: New Mothers Speak Out (June 2013) reports on new national surveys about issues women face in the postpartum period and their views about maternity care.
Access the full report and supplementary materials Listening to MothersSM III (May 2013) is the third national survey exploring women's experiences in pregnancy and childbirth. Commissioned by Childbirth Connection, conducted by Harris Interactive, and funded by the W.K. Kellogg Foundation, the survey polled 2,400 women who gave birth in U.S. hospitals from 2011 to 2012. Results show that medically intensive experiences are typical, and evidence-based practices are underutilized. Childbearing women need better support and knowledge to navigate their maternity care. Access the full report and supplementary materials New Report: Maternity Care and Liability Go to report and supporting materials New Report: The Cost of Having a Baby in the United States Go to report and supporting materials New Cesarean Resources: Go to Best Evidence Report Go to web pages and booklet for women
For 95 years, Childbirth Connection has been dedicated to improving the
quality and value of maternity care for all women and their families. Learn
more about our rich history through our interactive
timeline and give
$95 for 95 in honor of
our 95th birthday.
Childbirth Connection works to ensure that all women and babies get the best
possible maternity care. We have the collective vision and we know how to get
there, but we can't do it alone. Join the transformation
The Transforming
Maternity Care website focuses on maternity care
system improvements designed to engage diverse stakeholders in quality
improvement efforts. The site offers full access to the landmark reports 2020 Vision and
Blueprint for
Action, features a Blog, and other
resources such as an Action Center, a
database of
quality improvement projects, an interactive data
center, and many more tools
for advocates and stakeholders.
Help Transform Maternity Care! |


text:
Prices shown in currencies other than USA Dollars are estimates based on current exchange rates. We will charge your credit card in USA Dollars on the day your order is shipped, and the conversion to your local currency will be done at the prevailing rate by your credit card issuer.
Shipments outside the USA are declared as "bike parts" for customs purposes and will include the actual amount paid for merchandise and shipping. Jenson USA will not mark your parcel as a "gift", declare a value lower than the actual price paid, or otherwise prepare false customs information.
Tell a friend! We'll send your friends the page and your message.
Note: You and your friend's email addresses are only used once as a referral. We will not collect or store the email addresses.
Reviewed by 1 customer
Displaying review 1
Best Uses
Comments about Nokian Gazza Extreme 29" Studded Tire:
I'm really happy with these tires. I have a commute that includes some single track up/downhill. I figured I needed lots of spikes to handle the tough stuff and I could live with more rolling resistance and rolling slower on the paved paths. These tires are exactly what I expected. The price is WAY better than any LBS here in Calgary. I have lost no studs whatsoever and the grip is astounding. The only comment is that while running the tires at mid-point of their pressure range, clear pavement gives you one hell of a vibration with any speed. It's a little disconcerting at first but not really a big deal.
Displaying review 1
Jenson USA ships worldwide, including APO/FPO addresses. For a quote, simply add the items you are interested in to your shopping cart and look for the "Shipping Options" box. You don't have to login or create an account to see shipping charges.
Some manufacturers restrict where we can ship their products. If this item has shipping restrictions, they are listed below. If you'd like to buy an item that we cannot ship to your preferred address, we can accept your foreign credit card and ship to a USA address for you.
Get free shipping with your $50 purchase today when you choose Standard Shipping at checkout. Please note this offer is only available to physical shipping addresses in the 48 continental United States (no PO Boxes), and oversize charges still apply on some heavy/large items
Get free Standard Shipping with your $50 purchase today! Just choose Standard Shipping during checkout.
Please note this offer is only available to physical shipping addresses in the 48 continental United States (no PO Boxes), and oversize charges still apply on some heavy/large items.

subset: commoncrawl


text:
Posted 3:56 PM 1/4/2013 : Are red light cameras safer?
TUCSON - We now have video from red light cameras throughout Arizona over the past year. In it you can see multiple near misses.
ATS says at Tanque Verde and Rrant crashes have dropped 67%. There were 46 accidents in 2005 and only 15 in 2011.
This is also the case throughout Arizona. Collisions decreased about 24% at ten intersections in Scottsdale and 36% at Mesa's 31 red light camera locations.
Drivers in Tucson say this appears to be a good thing.
"It keeps the speed down and cops aren't everywhere so it's always good to know they're always there to make sure everyone does what they need to do."
"I think as long as it reduces accidents than it's good," says a bicyclist.
"If they stop accidents it's a good thing," says another driver.
The other seven intersections in Tucson with photo enforcement show similar reductions. ATS says it shows the need for intersection enforcement and how important it is for drivers to pay attention.
Click here to submit a news tip to us!
Become a Facebook Fan!
Follow us!
Help those in need this holiday season
Win! Win! Win!
Wise Local Marketing!
Get news, weather and more on your smartphone and tablet!
Get texts for news, traffic, deals and more!
Sign up on KVOA.com for newsletters, exclusive deals, and more!
What's happening?
What's happening on News 4 @ 4
Stories and videos with Kristi's Kids
Check out the latest events FC Tucson has scheduled.
Let us help grow your business
Digital Channel 4.2
What's on KVOA and when!
Contact info for our department heads
KVOA's on air personalities!
Work at News 4 Tucson
Complete feeds of all KVOA.com stories
FCC Public File of Records, Reports, and More


text:
April 16, 2012
Kevin Stewart ArizonaVarsity.com
One of the top performers at the recent Five-Star Future Pro Combine in Phoenix was Chandler (Ariz.) Hamilton's Devon Finai. ...More... To continue reading this article you must be a member. Sign Up Now for a FREE Trial
Already a member? Click here to sign in


text:
- Musician's Friend Best Selection, Price & Service. Guaranteed.
Need Help? Ask our Experts or call 800-449-9128
Asistencia en Español 866-226-2919
Need Help? Ask our Experts or call 800-449-9128
Results 1 - 2 of 2 matches
Now economically priced, this CD Master is a one-to-one 52X CD duplication system designed for the office or...
1 Reader, (10) 52x Writers, Standalone CD Tracer Tower Series from Condre, Inc., provides users with the...
Our product catalog varies by country due to manufacturer restrictions. If you change the Ship-To country, some or all of the items in your cart may not ship to the new destination.


text:
Help the Philippines Typhoon Relief effort
Note: Select a region before finding a country.
A little wintry mix late Wednesday night Details >
Dec 9, 2013; 5:00 AM ET Tropical cyclone Madi is expected to weaken off the eastern coast of India. Heavy showers to Tokyo by Tuesday.
12:20am MSK


text:
A Cold Red SunriseOne Dead Commissar At an icebound naval weather station in far Siberia, the young daughter of an exiled dies under suspicious circumstances. The high-ranking Commissar sent to investigate the mystery suffers a similar fate: he is murdered by an icicle thrust into his skull. One Live Cop Inspector Porfiry Rostnikov is dispatched to solve the Commissar's murder, with one caveat: he is not to investigate the girl's death. Even if all the clues tell him that the two cases are linked. One Cold Killer In a single, fateful day, Rostnikov will hear two confessions, watch someone die, conspire against the government, and nearly meet his own death. All under the watchful eye of the KGB -- and someone much closer and infinitely more terrifying. |
What people are saying - Write a review
User ratings
5 stars |
| ||
4 stars |
| ||
3 stars |
| ||
2 stars |
| ||
1 star |
Review: A Cold Red Sunrise (Inspector Rostnikov #4)
User Review - Eric_W - GoodreadsThe old saying "red sky at night, sailor's delight; red sky in morning, sailors take warning," apparently has some scientific validity. It even appears in the Bible (Matthew XVI:2-3) Something to do ... Read full review
Review: A Cold Red Sunrise (Inspector Rostnikov #4)
User Review - Vic - GoodreadsA Cold Red Sunrise represents my first adventure with Russian Police Inspector, Porfiry Rostnikov, one of several of Stuart Kaminsky's on going characters. Rostnikov is a fifty plus year old cop with ... Read full review
Other editions - View all
A Cold Red Sunrise: An Inspector Porfiry Rostnikov Mystery Stuart M. Kaminsky No preview available - 2000 |
Common terms and phrases
Arbat Street asked Rostnikov baby Boris chair child coat Colonel Comrade Inspector dark death desk Dimitri Galich Emil Karpo Ermak Evenk eyes face Famfanoff former priest glasnost glasses hair Hall of Justice hand head hear Igarka Illya Rutkin Inspector Rostnikov investigation Justice and Solidarity kill Commissar Rutkin killer knew knocked Kola Krasnikov Kuchum Kurmu Liana Ludmilla Samsonov Lydia Major Zhenya Maya Mongol morning Moscow murder old woman Olga Yegeneva opened Pankov paused People's Hall Perhaps policeman Porfiry Petrovich Rostnikov Pulcharia pulled reached Rostnikov asked Rostnikov looked Rostnikov nodded Saperavi Sarah Sasha Tkach Sergei Mirasnikov shaman shouted Siberia slope smile Snitkonoy snow softly Sokolov someone Soviet square stepped stood stop taiga talk tell thought Tumsk turned Viktor vodka Volovkatin waiting watch weather station whispered wife window Wolfhound wooden Yuri Zelach


text:
People often ask how to donate to the site.
For things like games you wish to have anonymously released,
contact me and I will set up an ftp for you.
To donate hardware PM me.
To donate financially, the site's paypal account is
We are member supported through content and financial contributions,
this is only possible thanks to you.


text:
Volunteer Information Session
- When:
- 05:30pm - 06:30pm, Wednesday, 07 November 2012
- Where:
- Biodiversity Conservation Centre - Kings Park, West Perth
Information session for Naturescaper volunteersJoin us to learn about great new volunteer roles in Rio Tinto Naturescape Kings Park. Meet the team and find out about other volunteer roles on offer in our beautiful Kings Park. Naturescaper volunteers share a sense of fun, discovery and appreciation for the natural environment with children and their families. They are also involved in education and hands-on care of the environment in this area. |
Cost |
Free |
Registrations |
Registrations are essential by contacting the Volunteer Coordinator or phoning Reception on (08) 9480 3609. |
More information |
Rio Tinto Naturescape Kings Park officially opened to the West Australian public in October 2011. |


text:
Loading streams...
Now Playing
Connect with Us
Podcasts & RSS Feeds
All Content |
View all podcasts & RSS feeds |
Tri States Public Radio Staff
General Manager
News Director
Southeast Iowa Correspondent
Music Director
Director of Development
Operations Manager
Web Design/Content Production
Membership Marketing Manager
Director, Audio Information Services
Audio Information Services Program Director
4:22 pm
Tue February 26, 2013
Investigator: BP Wasn't Prepared For Disasters At Deepwater Oil Wells
By Jeff Brady
Originally published on Tue February 26, 2013 6:05 pm
Tuesday marked the second day of a civil trial connected to the 2010 Deepwater Horizon explosion and oil spill in New Orleans. With opening statements over, plaintiffs began calling witnesses. Melissa Block talks to Jeff Brady.


text:
'Rise up, pick up your mat and walk'
Friday, 16 March 2012 00:00
The African American Catholic Center for Evangelization celebrated its 10th Black History Month Liturgy recently at the Cathedral of Our Lady of the Angels with more than 1,000 in attendance.
'Without the donors, there would be no CEF'
Friday, 09 March 2012 00:00
CEF honors supporters' commitment to changing lives, bringing hope to youth and families.
L.A. Catholic lawyers urged to actively participate in Church life
Friday, 09 March 2012 00:00
Catholic lawyers have a responsibility to actively participate in the Church and society, and to live their faith in their work as well as on Sunday, Archbishop José Gomez told a gathering of more than 100 lawyers at a recent "get-acquainted" dinner in downtown Los Angeles.
Grace Rinaldi, ACCW and Catholic Daughters leader, dies
Friday, 09 March 2012 00:00
Funeral Mass will be held March 10, 10 a.m., at St. Joseph Church in Hawthorne for Grace Marie Rinaldi, 95, who died March 1 following a legacy of service to the Catholic Church that included leadership roles in the Archdiocesan Council of Catholic Women and the Catholic Daughters of the Americas.
Death penalty initiative signatures complete
Friday, 09 March 2012 00:00
Organizers of an initiative to end the use of the death penalty in California announced last week that they have obtained enough signatures to qualify the measure for the ballot, the California Catholic Conference reported last week.
Member Login
Latest Events
- Sainte Therese
December 13, 2013 (6:30 PM)
- Prepare Ye the Way of the Lord!
December 13, 2013 (7:00 PM - 9:00 PM)
- Joys of the Arts, Joy of the Season
December 13, 2013 (7:00 PM)
Prayer of the Month
Papal intentions for November: That priests who experience difficulties may find comfort in their suffering, support in their doubts, and confirmation in their fidelity. That as fruit of the continental mission, Latin American Churches may send missionaries to other Churches.Papal intentions for December: That children who are victims of abandonment or violence may find the love and protection they need. That Christians, enlightened by the Word incarnate, may prepare humanity for the Savior's coming.


text:
Monitor Adapters |
Lenovo USB-to-DVI Monitor Adapter (45K5296) - Attach an analog or digital HD (1920 x 1200 resolution) monitor to a USB port. | |
Lenovo ADD2 DVI-D Monitor Connection Adapter (43R1985) |
ThinkCentre Graphic Cards |
Additional Information |
Lenovo Support: DisplayPort Monitor Cables - Information on DisplayPort monitor cables which are used with graphic cards offering DisplayPort connectors | |
www.lenovo.com/psref - Personal Systems Reference (PSREF): Comprehensive information on features and technical specifications of Lenovo products | |
www.lenovo.com/support/accessories - Additional Lenovo Support information on options and accessories | |
www.lenovo.com/accessoriesguide - Additional information on options and accessories. Includes the Graphic Card Compatibility Matrix, ThinkCentre Graphics Card brochure and Option Compatibility Matrix (OCM). | |
www.lenovo.com/thinkvision - Lenovo ThinkVision monitors | |
Lenovo Support: Flat Panel Monitors - Reference Guide - A list of Lenovo Flat Panel Monitors | |
Lenovo Support: Accessories - Reference Guide - A list of Lenovo accessories for notebooks, desktops, workstations and servers. | |
www.lenovoquickpick.com - A web-based, accessories compatibility configurator |
For more information on NVIDIA Quadro professional graphic cards:
Discontined, No longer available |


text:
Posted: Jan 28, 2013 8:58 AM by Tara Oster - MTN News
Updated: Jan 28, 2013 10:09 AM
WHITEFISH - The world skijoring championships wrapped up this weekend at the Whitefish Municipal Airport. The unique extreme winter sport is held each year as part of the Whitefish Winter Carnival.
Most of the skiers landed all three of the jumps, but what would a skijoring even be without a fall or two and a wayward horse now and again? That's skijoring in Montana.
"I grew up in Virginia and moved out here, and this is nothing that I would've ever seen back home," Brandom Price told us.
Skijoring in Whitefish started in the 1960s, but the so-called modern era started in 2003. Whitefish started hosting the World Skijoring Championships in 2009.
Casey's Bar in Whitefish is one of the event sponsors this year.
"It's the Whitefish Winter Carnival. We like to be a part of everything and we thought, what better year to be the presenting sponsor than our first year back in Whitefish," explained Casey's Bar manager Keven Guercio.
The object of the event is to get through the course with the fastest time and avoid penalties. And just to make sure the horses don't have all the fun, there's a special classification for mules.
"I mean the mules are pretty cool because I wouldn't expect this out of them, but you know they're doing it, and they're great," Price said.
Skijoring is said to have originated as a form of winter travel
"Where else do you get cowboys and skiers together to all have a good time in one day?" Guercio asked.
The fun event also helped out two non-profits, Human Therapy on Horseback and Wings Regional Cancer Support.


text:
Gay Pride
Georgia Cities Gear Up for Gay Pride Celebrations
Georgia is gearing up for fall Gay Pride celebrations throughout the state!
A Las Vegas Twofer!
Talk about the perfect weekend for a visit to Vegas... it's a two-for-one weekend of fun, featuring Las Vegas Pride and Fabulous Las Vegas!
Oakland Celebrates Gay Pride
Oakland, California, showed off their true colors at the city's Pride Festival. KPIX-5's John Ramos reports.
Pride Puts DJs in Spotlight
We march & we dance: Pride celebrations put the spotlight on gay DJs, from the legends to local favorites.
Out-and-Proud: Gay Headliners
Pride celebrations provide valuable venues for out-gay artists to connect with their audience & the range of gay talent.
Legendary Ladies
We love our dance divas, so it's only appropriate that during Pride season, they come back to, in Lady Gaga's words, "the home of the gay."
22 Held in Montenegro for Attacking Country's 1st Gay Pride
Montenegrin police say they have detained 22 people over the clashes that erupted during the first ever gay pride event in the staunchly conservative Balkan country.
ACT UP Acts Up at NYC Pride with Provocative Message
Unhampered by political obligations or fears of losing funding, ACT UP New York can do things like start an AIDS education campaign whose official message is to "Fuck Smarter! Fight Harder! FIGHT AIDS!"
Opponents Attack Montenegro's First Gay Pride
Several hundred people shouting "Kill the gays" attacked gay activists and clashed with police on Wednesday in a bid to disrupt the first ever pride event in staunchly conservative Montenegro.
Scenes from NYC's gay pride celebration
New York gay pride revelers celebrate at this years Gay Pride March after the Supreme Court's recent decision granting gay couples federal marriage benefits.


text:
The apt we had overlooks the golf course, unfortunately it is separated by a road! Traffic very busy late afternoon evening and noisy! Just along the road is the marina and opposite the golf course - very pretty. There is a nice swimming pool on the complex and the apt is comfy. The few negatives would be: pull out beds... More
- Reservation Options:
- TripAdvisor is proud to partner with Expedia, Booking.com, Priceline, Hotels.com and Tingo so you can book your Residence Hoteliere Du Golf reservations with confidence. We help millions of travellers each month to find the perfect hotel for both holiday and business trips, always with the best discounts and special offers.


text:
Damon Salvatore
Damon Salvatore is a deadly (but sexy!) piece of work. A blood-sucking playboy, he's the rebel to his brother Stefan's saint. Witty, charming, and oh-so-fine, the elder Salvatore brother is a regular people person. Erm, except for the fact he's got this nasty habit of feeding on them...
Damon loved his vamp maker Katherine with a fierce devotion and he has spent the last century trying to find her. It was this search that brought him back to Mystic Falls, where he met his little brother's girlfriend, Elena — who happens to be Katherine's doppelganger.
Though he hides his soft side under a layer of snark and a few swills of bourbon, Damon definitely fell for Elena. Hard. But he reacts to her rejection with violence or by acting out. Luckily for Damon, not everyone he kills stays dead. Elena's little brother, Jeremy, would've been a goner if he hadn't been wearing his magic ring when Damon snapped his neck.
Damon's main objectives are keeping Elena safe, no matter the cost, and looking out for Stefan — except when he's kissing Elena. Despite the moments she and Damon have shared, Elena chose Stefan, once again devastating the elder Salvatore.
Fast Facts:
1. In 1864, Damon became a vampire, making him over 165 years old.
2. Damon's vampire powers include creating and controlling fog, jumping to some stellar heights, and controlling minds.
3. Until Alaric's death, the history teacher was Damon's best (drinking) buddy.
4. The secret to Damon's success with the ladies? His unflinching ability to listen to Taylor Swift.
Elena is in trouble, and once again, it's the Salvatore brothers to the rescue! When The Vampire Diaries returns for its mid-season finale — Season 5, Episode 10 ("Fifty… more »
Damon Salvatore just can't catch a break on The Vampire Diaries. First a psycho witch tells him that doppelgangers are destined to be together… more »
The Vampire Diaries Season 5, Episode 9 Spoiler Roundup — Everything to Know About "The Cell"
The Vampire Diaries is back after a week-long Thanksgiving hiatus, and it looks like the show is diving back into the Augustine Society's dark past and Damon'… more »
The return of The Vampire Diaries on Thursday will also mark the introduction of a new character, Enzo (Michael Malarkey). What will Enzo's role be in Season 5, Episode 9 ("… more »
We unfortunately have to wait until December 5 for a new episode of The Vampire Diaries, but prepare to be floored when TVD does return for Season 5, Episode 9 ("The… more »
Though The Vampire Diaries will probably run through at least a sixth season, it will eventually have to come to an end. Executive producers Julie Plec and Kevin… more »


text:
General Yi
Location: The Observatorie
Joined Jun 30, 2012 at 12:38AM EDT
| |
- About
Hello! If you're reading this, you don't have to. If you having something better to do than read my boring information, feel free to ignore this and move on! I don't mind. But if you're still here, allow me to indulge you. Feel free to call me by any name you see fit; although most will refer to me simply as, "that Brony that posts Dragon Ball Z gifs too much". And that's just what I do. If you want a specific Dragon Ball Z gif or image, feel free to ask! I'm certain I can get it for you. Oh, and if I ever, ever get too annoying with my DBZ related stuff, feel free to let me know. I'll be glad to tone it down a bit (or completely stop if that's what people want). My Steam username and PlayStation Network username is generalyi (no caps, no spaces).
Every Sunday, I go to each member's wall and post a Bible Verse, and we discuss it all on my wall, so there's no hassle in jumping from wall to wall for a discussion. Any person is welcome, Christian or not, we welcome all who are curious. If you want to join, let me know and i'll make it so, and lurking is just as fine.
Current members
Mr. Scratch
Free Cake
Nox Lucis
Sir Genry
Flare BoostFeel free to let me know if you need anything prayed for! Any and all requests will be posted in this box, unless they wish to remain anonymous.
Caro: Taking medicine for bi-polar disorder, uncle's alcoholism
Mack: New girlfriend, brother needs prayer, aiming to apply at an outreach ministry (Reformed University Fellowship) and really wants to be a part of it, wishes to glorify God's work in his life.
Verbose: General well-being, having a hard time staying focused with prayer, stressed with maintaining multiple friendships and looking to develop stronger ones
Free Cake: College philosophy class is moving into Christian studies
ImmaHeMan: Wishes to witness to Evolutionist friend,
Nox Lucis: A new sense of direction in his life after major changes occurred, a couple he knows lost their two year old daughter to cancer
Sir Genry: Purity maintaing in relationship with girlfriend, kid at his school needs to be witnessed to, works to pray continually
Myself: Seeks to maintain foothold against pornography addiction, waiting for acceptance letter into Miami University, working on writing my book, feeling very unwell at the moment, Grandparents on both sides of family are going through various health issues
Itayl1: School term nearing a close but struggling to get there
Vinyltavia: Needing a career change in life to give new direction as a Christian and a person, plans for moving out with his friend are on hold due to his friend becoming unemployed, prays for better days
NoLifeProphet: Mother and Brother have Bi-Polar disorder, interested in girl at work but can't find time to talk to her, looking for inspiration for writing, seeks to maintain his focus on Christ
HK-47: seeks God's help in personal issues
[Loli]amnyancat: seeks more hope in his life and to keep old friendships strong while building onto new ones
Thatswhynot: Praying on whether to search for a new job or go back to school
Flare Boost: Safe recovery for his cousin who recently beat Pancreatic Cancer
Misc: Prayer for those who have passed on, those in the Philippines devastated by the storm, those less fortunate during the Holidays, Paul Walker's daughter and the loss of her fatherIsaiah 9:2
"The people walking in darkness have seen a great light; on those living in the land of the shadow of death a light has dawned."
Context: The prophet Isaiah foretells the coming of Christ."If anyone has questions or just wants to discuss matters of Christianity or topics related, feel free to send me a message! I just want to help and provide plain and simple answers to anyone that's curious.


text:
March 2, 2013, 03:15 PM | #1 |
Join Date: July 5, 2006
Location: central Cal.
Posts: 20
Flare gun pistols?
Hi Guys, Not sure what caterory to put this in but: I've heard/read the idea of buying "inserts" for old(WW2 I think) 25.6mm flare guns in 410ga/45LC and
22LR.Any thoughts/facts or experience with this.A friend at the marine supply store said that 12ga flare guns went flying off his shelves when the gun up- roar started,but the only way he would try it would be with the flare gun tied to a big tree and a long string to pull the trigger. I'm sure our members have thoughts,opinions & most of all experience on this. Thanks all, Psychobilly |
March 2, 2013, 05:39 PM | #2 |
Senior Member
Join Date: September 28, 2008
Posts: 3,666
Isn't a flare gun, used with a regular flare round, a good enough short range weapon as-is?
Preferably outdoors, though.
Lock the doors, they're coming in the windows. |
March 2, 2013, 07:20 PM | #3 |
Join Date: October 17, 2010
Posts: 92
Flare gun pistols?
All the flares I've seen anymore are much longer than could be put in a regular shotgun.
March 3, 2013, 05:35 AM | #4 |
Senior Member
Join Date: June 16, 2005
Location: AZ
Posts: 2,320
The inserts need to be rifled or else you end up with an AOW.
March 4, 2013, 05:09 PM | #5 |
Senior Member
Join Date: June 15, 2009
Location: Minnesota CZ fan
Posts: 867
12 gauge inserts for the old Czech flare guns are full length and rifled. Only ones I have actually seen.
March 5, 2013, 05:21 AM | #6 |
Senior Member
Join Date: June 16, 2005
Location: AZ
Posts: 2,320
The economics don't really work out, either. A sturdy metal flare pistol and and an insert gets you into Hi Point range. Or, you might as well save a little more and get a milsurp or police trade in.
March 5, 2013, 07:13 AM | #7 | |
Senior Member
Join Date: May 25, 1999
Location: Too close to Houston
Posts: 4,012
We used to use them to light flare stacks. You'd have to saw the barrel off short of the choke to get them to work. Oddly enough, they were more accurate out of the little plastic flare pistol.
Proud member of the NRA and Texas State Rifle Association. Registered and active voter. |
March 5, 2013, 08:09 AM | #8 |
Senior Member
Join Date: April 4, 2012
Location: South Jersey
Posts: 1,180
I have several new style flare guns, when the flare kit goes out of date its cheaper to buy the kit than replace the individual flares. I would never consider putting the lightest of shotgun loads in them. I have never pulled a flare apart, but i dont think they have a charge in them just a primer.
The old mil-surp flare guns I have seen would probably handle a light charge load. They have also been more expensive than many low end pistols. As a bit of a side note. I heard of someone trying to shoot a seagull at about 5 yards with one. Apparently they are only accurate enough to hit the sky.
Concentrated power is not rendered harmless by the good intentions of those who create it. Milton Freidman |
March 5, 2013, 09:15 PM | #9 |
Join Date: January 3, 2013
Location: S.E. Alaska
Posts: 68
12 Ga flares are very corrosive so avoid shooting them out of your shotgun unless its an actual emergency. Living on an island as I do and since the Coast Guard requires all watercraft to carry flares, I have handled quite a few. I usually just buy the bright orange plastic Orion flare pistol kits. I know the Kennesaw Cannon Co. sells flare inserts for the 25.6 mm flare guns and I have always been curious to see how they worked. I have been thinking myself about buying a 12 ga insert and cutting it down to fit into a standard 12 Ga flare gun. if its in .22 I doubt you would have any problems, even with a plastic gun, since the insert is metal. Accuracy will be terrible I am sure, but thats not the point. For me, the point is a virtually disposable handgun that I can pop halibut with or take trapping. If it gets dropped overboard or lost...oh well.
March 5, 2013, 09:27 PM | #10 |
Join Date: October 17, 2010
Posts: 92
Flare gun pistols?
Flares used to e little stubby thing like those Aquila mini shells now they are much longer perhaps to prevent use in a shotgun?
March 5, 2013, 10:01 PM | #11 |
Join Date: January 3, 2013
Location: S.E. Alaska
Posts: 68
The Orion flares I buy are the short little ones, I have never seen any longer than a shotshell.
March 6, 2013, 02:55 AM | #12 |
Senior Member
Join Date: November 25, 2008
Location: California
Posts: 1,870
Olin makes a flare longer than2 1/2". I have a 26.5" all steel flare gun with a 6" barrel, meteortype 26.5 rounds are 3 1/4"long. Smoke are 5 1/4"long and the 12ga conversion barrel is aluminum alloy bored 12ga 4 3/4" with a step in it to prevent putting a 2 3/4" shell in it, but a colibri mini 12ga shell will fit I will let you hold it to test fire it with live 12ga ammo
http://www.armsmaster.net-a.googlepages.com http://s239.photobucket.com/albums/f...aster270/Guns/ Retired LE, M.P., Sr. M.P. Investigator F.B.I. Trained Rangemaster/Firearms Instructor & Armorer, Presently Forensic Document Examiner for D.H.S. Last edited by armsmaster270; March 6, 2013 at 03:00 AM. |
Thread Tools | |


text:
Now that you've seen the teams in action, what remaining game are you most worried about?
Well if it isn't my lunch link buddy... Nutty here!
Purdue defense has looked mighty stout and stymied most of their opponents. With Kawann Short on their line, their front four and defensive line has look the best I've seen in years and should keep them in most games. I hope we find a way to beat Purdue after going to West Lafayette and watching us lose last year :(
I finding it shocking Wisconsin doesn't get a pity vote... Not sure if this means people are confident in a win over the badgers or they just are no longer a threat.... Nothing like some home cooking in Madison to make one think otherwise.
Insert witty remark
I didn't vote. Not my place to impose my fears on the Buckeyes. To be honest, I think the MSU defense is the only scary thing in the conference right now. ND's 20 points notwithstanding. It hurts to say it about the conference's single most dirty team, but Pat Narduzzi is the best DC in the B1G.
Agree M Man, I think if Braxton can't get help around him MSU will shut him down. On the flip side, I'm not sure Sparty can score points. Shut down Bell and they can't do anything else. It's amazing how big of an impact losing a QB and a few WR's has on some teams. If Cousins and Cunningham were on this team, I could see them making a title run. Maxwell has a way to go before that defense can truly shine.
Dustin Fox was our leading tackler as a corner.... because his guy always caught the ball.
Not scared of MSU b/c that's the "big" non-UM game everyone's worried about and has circled on their calendar. The guys will show up big time for that one I'm sure, as they will for UMich. More worried about one of those random fluke games against a dangerous but very flawed team that could totally explode on us if a bunch of things just happen to fall their way. So I voted Nebraska, esp once they get Burkhead back and if they get their ground game going early - we could be in trouble.
I voted for Nebraska as well tough team explosive runnin backs in abdullah and burkhead. I think that will be our test to protect our home turf. Its a prime time game so the shoe will be rockin it will be a crazy night hopefully we can get the ball in the air lil more. As the rest of the games really there all gonna be tough MSU,Purdue,Wisconsin,Michigan,Indiana. All could be potential losses if we cant stay consistent on offence.. Im lookin forward to conference play. Lets take down UAB and its On.. Go Bucks
Tough call. I mean MSU just crapped in the bed & will be awful eager to prove something & tsun is.....tsun...I gotta think Nebraska is gonna be pretty tough - but we win that one on the home field & that Purdue could end up being legitimately tough this year.
The world is full of kings & queens who'll blind your eyes & steal your dreams - it's heaven & hell - Ronnie James Dio.


text:
A site by graduates of The Landmark Forum and
Landmark's Communication Curriculum
Today's Headline
Leaving Apple, Pursuing a Dream
There are few people who leave a solid, productive career at Apple to start their own company. Todd Beauchamp is one of the few, leaving Apple to fulfill the … [Continue Reading]
Creating Happiness for Sick Children
By Dr. Parijat N. Goswami, Gujarat Cancer and Research Institute, Team India Dr. Parijat N Goswami, Professor and Head of Microbiology has taken up a project … [Continue Reading]
Featured Business
Good to Green – Healthy People, Happy Planet
September 14, 2013 By TMLP Newsletter Leave a Comment
Micro Funding for Creative Women: "FunderWoman"
February 15, 2013 By TMLP
Micro Financiamiento para Mujeres Creativas: "FunderWoman"
February 15, 2013 By TMLP
Featured Community
Climb Any Mountain
November 16, 2013 By TJList Leave a Comment
Good to Green – Healthy People, Happy Planet
September 14, 2013 By TMLP Newsletter Leave a Comment
Africa Redefined
July 8, 2013 By TMLP Newsletter Leave a Comment
Latest Lifestyle Stories
Creating a Legacy for the Team, Management, and Leadership Program
November 16, 2013 By TJList
Heather Gollyhorn Team San Diego, Team 1, Quarter 4 Team San Diego is the possibility of "Passionate Partnership and Unstoppable Leadership with an outcome of Ever-Expanding Contribution". Interviewed … [Read More...]
Back to Living-Peanut Game
November 16, 2013 By TJList Leave a Comment
Dan Clarke Team Rocky Mountain Region The Possibility of this game is to provide affordable and effective lower back pain relief to the world. Dan was a hockey player and in 2004, he found himself … [Read More...]
Barista Sings the Blues: Making the Dream of a Blues Band Real
June 8, 2012 By TMLP
Envision having a promising career moving up the corporate ladder at Starbucks. Then the coffee conglomerate decides to hold an employee wide contest; NOT about coffee, but rather a search for soloists or bands … [Read More...]


text:
Agra Forum
Forums and message boards for Agra, OK
Search Forum
Email me when the Agra Forum is updated.
Learn more
Could you pass a US citizenship test?
If you think this short quiz is hard, then you'd be in trouble with the real citizenship test, which contains 100 questions and isn't multiple choice. 1 in 3 actual Americans can't pass it.
Take Now - 14,153 completed
Should government buildings be allowed to display religious symbols?
Vote Now
2930 votes
Want to talk about something else? Start your own discussion!
Ask a question, start a debate, post a tip, or just say what's on your mind.
Please note by clicking on "Post Comment" you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.


text:
This book is a collection of over 50 pre-generated characters, complete with Skills, Vital Stats, Character Types and more, all ready to go (die). The characters are perfect for use as PC's, NPC's, Cast, Walk-Ons, Bad Guys or even just for dressing up in paper outfits, tacking up on the wall and tossing darts at. Intended for use with Horror Rules, The Simp... [click here for more]
You'll laugh, you'll cry, you'll scream, you'll jump... okay, you'll die - a lot. Based on your favorite contemporary horror movies and books, Horror Rules recreates those classic moments of creepiness that make you squeal like a little girl, but with a decidedly tongue-in-cheek twist. The rules are light and flexible and expertly tweaked to bring out the... [click here for more]
Q: What happens when a character runs out of health?A: He dies
Q: What happens when a character runs out of mental health?A: He becomes more interesting...
Or at least, he should. Any decent roleplayer can manage to get himself shot, stabbed, torn apart, crushed or devoured by zombies, but it takes a lot mo... [click here for more]
Working the night shift at the neighborhood 24/7, Carson Dudley has seen his share of weird - but never the kind that tries to kill you, drain all your blood and stuff your body in a dumpster. Something has moved into the neighborhood and is turning latenight snackers into latenight snacks, leaving a bloody trail of bodies through the quiet, peaceful seaside cit... [click here for more]
When you want a midnight snack in Las Calamas, there's only one place to go - the good ol' 24/7. This popular corner mini-mart has been the target of countless late-night munchy runs for over twenty years, drawing hungry customers with the promise of quick food and constant variety. Unfortunately, something else has gotten wise to the wonders of stop-and-go snac... [click here for more]
The city of Los Diablos, Nevada is a thriving community of crime and vice. The Lucky Devil Casino is the oldest establishment in town, not to mention the hottest spot for night life. Built by reputed mob boss Vincenzo Reno and left to his eldest son, Santino "Sonny" Reno after Vinnie's brutal gangland murder, the casino has seen its share of viole... [click here for more]
For years, the trail to Napawekka Lake has been a well kept secret. Snaking off into the dense, lonely expanse of the Canadian wilderness, it holds a powerful allure to those in search of adventure. Some take the trail to experience the wonders and beauty of nature. Some take it for exercise. Others take it to escape the busy hectic pace of the modern world. But this time, ... [click here for more]
The vampires have always been, lurking quietly in the darkened streets, killing only when they had to, their existence a carefully guarded secret. Then something happened... no one knows exactly what, but now the bloodsuckers have lost control and unleashed their wrath on the defenseless and terrified city. So grab your stakes and holy water and get rea... [click here for more]
There's something rotten in the woods tonight - and it ain't your franks and beans! The dead are on the move, and it's up to you to put a stop to it. So grab your shotgun, fire up the chainsaw and get ready for some good old-fashioned zombie-hunting... Horror Rules style! Horror Rules Mini-Games provide all the fun and mayhem of Horror Rules without the rule cru... [click here for more]
The prestigious Boogie Champ award handed out by Club Ikimasho is a mark of distinction earned by few and coveted by all. That is, until the Boogie Champs start dying. It seems that one of the past dance floor legends is determined to be the one and only, and is systematically bumping off the competition in a gruesome and bloody display of bad sportsmanship. The police are ... [click here for more]
Time to cowboy up and throw down against the forces of supernatural evil! Ghostowns & Gunsmoke takes the frights and chills of Horror Rules, the Simply Horrible Roleplaying Game back to the lawless, reckless, gunslinging days of the American Wild West. Relive those days of adventure, hard work and rugged outdoorsmanshi... [click here for more]
Admit it ? it's happened to you too. You're right in the thick of the Horror Rules action: the 8ft tall nightmare just jumped out of the woods, people are screaming, bullets flying, claws slicing, someone pees their pants and passes out... and then BAM! It happens ? the Bad Guy rolls a ?1? (or heck, with this thing even a 2, 3, 4, 5, 6 or 7), you miss a dodge a... [click here for more]
Ever wanted to battle the forces of supernatural evil in chain mail armor or blast 'em with mutant superhero powers? Well, now you're in luck! The first rules expansion for Horror Rules, the Simply Horrible Roleplaying Game, is here, and it's putting a new face on terror! Horror Worlds takes the madness, mirth and mayhem of the basic game and ... [click here for more]
Finally, the roleplaying game that makes you DIE laughing brings you a supplement that helps you do just that! Introducing "Script Crypt, Vol 1: Psychos and Sickos", a collection of adventure scripts for Horror Rules, the Simply Horrible Roleplaying Game. Originally released in electronic format as part of the Horror Rules Sea... [click here for more]
When you receive a call from your old friend Dr. Green asking for a favor, you immediately agree. After all, nothing could be wrong with spending a weekend in the British countryside, right? Unless, of course, it happens to involve a dilapidated old insane asylum plagued by strange disappearances and freakish events. And that's just the beginning... [click here for more]
Legend speaks of a grotesque, monstrous miner stalking the frozen wastes of Alaska, seeking the precious gold which slowly drove him insane. Most people just chuckle and shake their heads. But when the grand opening of the mining museum in White Landing, Alaska is crashed by a hulking figure in a glowing headlamp, folks quickly change their tune. As the bodies start to pil... [click here for more]
What more could a kid ask for than a fun-filled summer at good ol' Camp Fusketotulee? After all, Camp Fusko has everything you could ever want for an adventure packed vacation - a private lake, diving dock, canoes, archery, ropes course, volleyball pit, weenie roasts, endless hiking trails and the best s'mores in all of Minnesota. Oh sure, there's the mosquitos, but besides t... [click here for more]
When legendary adventurer and treasure-seeker Victor Greenwood calls with an offer you can't refuse, you don't refuse. After all, who could say no to a week-long trek through the steaming, danger-infested Amazon jungle in search of an ancient, priceless relic rumored to hold supernatural powers? Well, you MIGHT have said no if you'd known about the walkin... [click here for more]
What do you get when you mix a rundown retirement home, disappearing old folks, malevolent orderlies, too much meat on the menu and a mysterious, eccentric groundskeeper? We're not telling, but with a title like "The Recyclers," it's bound to be bad. Before they get to the bottom of things, the characters will face extradimensional terrors, ruthless cultists and som... [click here for more]
Returning to your childhood home for the annual fall festival should be a time of happiness, fond memories and loads of nostalgia... but Rotanoga is not as you left it. This sleepy Maine fishing town has undergone a transformation - people wander the streets in a daze, ominous shadows flit at the edge of vision, dark whispers fill your mind with terrible urges and feel... [click here for more]
When the anonymous letter arrives announcing the characters have won an all expenses paid vacation to the remote, exotic, tropical island of Tihi, everyone is too excited to think twice. Maybe no one remembers entering any contests, or even hearing the name before... but it's FREE! Who can say no?! Of course, after the demon spider-crabs attack, the jellyfi... [click here for more]
A misty night, a darkened wood, a group of strangers travelling through the lonely English countryside on a moonlit ride... if this ain't the perfect setting for a tale of ghostly scares and frights, what is?! When the bus breaks down and the sinister glowing shape of the Wraith Hound bounds from the woods, the characters are chased through the door of Whistler House and t... [click here for more]
Life in quaint, lazy Daytonville, Ohio used to be fairly tame - a night at the bowling alley, catching a movie, driving out to lookout point or taking a dip in the lake usually made for a full week. Then someone bought up all the slaughterhouses, meteors started falling from the sky and the green lightning showed up. After that, things got a little more compli... [click here for more]
by Chris Weedin ~ What do a perfectly ordinary and normal insane asylum, a secret, subterranean cavern infested by evil spirits and the gateway to Hell have in common? They're all in this book! And they're all lined up, ready and waiting to scare the living bejabbers out of your Players. "Script Crypt Volume 4: Very Bad Places" is a collection of four adventure scripts for "Horror Rules,... [click here for more]
Sure you love to terrorize and destroy your players (who doesn't?!). But sometimes do you find that the zip of mass mayhem isn't quite as zippy? Well, fear not! We know EXACTLY what you need - BRAND NEW BAD GUYS!!
The first installment in a long-awaited line of supplements for Horror Rules, the Simply Horrible Roleplaying Game, the Book of Bad ... [click here for more]
So you got the Horror Rules Book of Bad Guys #1 and it was great for awhile - people were screaming, dying and losing their minds right and left... everything was back to normal and Horror Rules was Horror Rules again. Then the screaming started to fade and your players began to feel safe again. The magic was gone. Well, no prob! We STILL know EXAC... [click here for more]
We know what you're thinking. "They already gave us Horror Rules Books of Bad Guys #1-2... my players are still traumatized by the horrific and terrifying creatures I've unleashed on them. How can things get any better?!" Well, they can't. This stuff is just too darn good! But, as long as you've got your players reeling and are tossing... [click here for more]
The worn oak door swings wide, spilling the warm light of the inn onto the cluster of travelers outside. Some are cautious, others wounded, but all are weary and in need of rest. As the innkeeper welcomes them and keys and coins change hands, the wisest know, however, that they dare not let the comforts of civilization lower their guard too much. For t... [click here for more]
The tavern is full tonight. Amid the clink of crockery and the slosh of ale, travelers meet and mingle, the buzz of their voices a comforting murmur. The flickering light of oil lanterns dances on the weathered oak tabletops and chases shadows into the corners, where hooded strangers huddle, conducting quiet business of their own... As a gamemaster, yo... [click here for more]
Here they are, Horror Rules fans - four brand new adventure Scripts for you favorite little five-star horror-comedy RPG! The four Damned Scripts in this Damned book represent a fiendish collection of Damned tales dealing with the powers of ultimate Damned evil. All the Bad Guys in this supplement are of the "really really bad" variety (aka "D... [click here for more]
Haven't had your bellyfull of Horror Rules madness?! You're in luck! We're serving up four brand new adventure Scripts for you favorite little five-star horror-comedy RPG! The premise behind this supplement is simple: everything in it is trying to eat you. As you flip through the book, you'll quickly discover that the title "The B... [click here for more]
The vampires have always been, lurking quietly in the darkened streets, killing only when they had to, their existence a carefully guard... [click here for more]


text:
Updating Data In SQL Server With Power Query
As of the November update of Power Query, it's now possible to write your own SQL query when you're moving data out of SQL Server into Excel using Power Query. So I got thinking… if you can write your own SQL query, can you execute any other SQL statement? Can you use Power Query to move data out of Excel and into SQL Server? Well, it turns out you can… with some limitations. This blog post details what I found out while researching this problem.
I started with a simple table in a SQL Server database with two columns, Fruit and Sales, and some data:
I then created a new function in Power Query with the following definition:
UpdateFunction = (Fruit, Sales) =>
[Query="UPDATE [FruitSales] SET [Sales]=" & Number.ToText(Sales)
& " WHERE Fruit='" & Fruit & "'"])
As you can see, it takes the name of a fruit and a sales value and updates the appropriate row in the SQL Server table. I then created a new table in Excel with some new fruit sales values:
Used this table as the source for another Power Query query, and for each row in this table called the function above:
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
InsertedCustom = Table.AddColumn(Source, "Custom", each UpdateFunction([Fruit],[Sales])),
#"Expand Custom" = Table.ExpandTableColumn(InsertedCustom, "Custom"
, {"Records Affected"}, {"Custom.Records Affected"})
#"Expand Custom"
I ran this query, and lo! My table in SQL Server was updated:
There are some interesting things to note here though. First, for each row in my Excel table, and each time an UPDATE statement was run, Power Query showed a prompt warning me that it was about to make a change to my database:
Probably the safe thing to do here, I think.
Furthermore, running a Profiler trace showed that each UPDATE statement was run at least twice. In fact, I originally started my tests with an INSERT INTO rather than an UPDATE, and found that since the INSERT INTO was run multiple times I ended up with duplicate rows in my table.
None of the code I've showed here should be used in a real application of course, but with some thought (and maybe a few changes to the way Power Query behaves), in the future it might be possible to use Power Query to move data out of Excel as well as in.
My Online MDX Training Course Is Now Live!
Recently I spent a few days with Rafal Lukawiecki recording videos of my MDX training course for Project Botticelli. I'm now pleased to announce that the first two videos (to add to the free video I recorded last year) from the course are now live with more to follow soon. You can find the main course page here; the two videos available as of today are:
This video covers writing simple MDX queries and looks at the SELECT clause, the FROM clause and the WHERE clause. The cool thing is that it's free to view – although you will need to register on the site first.
This video covers the basics of creating calculated members in MDX in the WITH clause and using the CREATE MEMBER statement. It's available to subscribers only.
Apart from my course there's a lot of other great Microsoft BI video training available via Project Botticelli, including several DAX videos by my old friends Marco Russo and Alberto Ferrari. Subscriptions to the site are very reasonably priced, but if you register before the end of December 2013 you can get a 20% discount by using the following promotion code:
Of course, if you prefer your training in a classroom, you can always attend one of my Technitrain courses in London next year.
BI Survey 13 Results
As in previous years, in return for promoting their survey the people at BARC have given me a free copy of the latest BI Survey – always an interesting read. I saw a story in the press last week about adoption of mobile BI slowing based on research from the BI Survey, but what does it have to say about Analysis Services? To be honest, much the same as in previous years: it's a good, cheap, reliable, mature solution. A few points that caught my eye:
- 11% of SSAS users are still using Proclarity as their front-end. That's down from 22% two years ago, but still… I guess that the likes of Pyramid Analytics, which specialises in Proclarity migration, will be pleased to hear that.
- 29% of SSAS users are using Power View. That's a big surprise for me – I haven't seen it at any of my customers yet. Presumably this must be the Sharepoint version of Power View going against SSAS Tabular.
- I found the 'cost per seat' (calculated as license fees plus external implementation cost divided by number of deployed seats) table particularly interesting: SSAS comes out with a score of $1111, about a quarter of the way from the bottom; Qliktech comes in at $1499, Tableau at $1039. In general self-service BI tools don't appear to cost any less to implement overall than traditional corporate BI tools.
- SSAS has a very respectable win-rate in competitive evaluations of 64%, although this is declining over time (it has to be said that almost all other large vendors are showing a decline too). Again, compare this with a win-rate of 34% for Tableau and 37% for Qliktech.
- Sadly there's no mention of PowerPivot anywhere. It would have been good to know how it's doing…
Pivoting Data In Power Query
One of the features I've loved right from the start in Power Query is the ability to UnPivot data right from the UI (I'm not alone – Ken Puls has written a good blog post summing up this functionality and is equally impressed). However earlier this year when I was trying to implement Life in Power Query, I found that I needed to do the opposite: I needed to pivot data. I was able to do this with some pretty complex M, but since then the nice people on the Power query team have added a new Table.Pivot() function to allow this to be done easily. Unfortunately pivoting is not something that can be done using the UI alone (at least not at the time of writing), but it's pretty straightforward to write your own M expression to use this new function.
Let's take the following table as a starting point:
You can see, in the Measure column, we have values Sales Units and Sales Value that tell us what the numbers in each row in the Value column represent. For most purposes, it's better to pivot this data so that we have two columns, one for Sales Units and one for Sales Value. You can do this pivot operation in a single step using Table.Pivot(). Here's an example script that loads the data from the table above and pivots it:
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Pivot = Table.Pivot(Source, {"Sales Units", "Sales Value"}, "Measure", "Value")
Here's the output:
It's worth pointing out that if you don't include each distinct value from your chosen column in the second parameter, those rows will be lost after the pivot takes place. So
= Table.Pivot(Source, {"Sales Units"}, "Measure", "Value")
Returns just:
Listing out all the column names in that second parameter is a bit of a pain, so we can get a list with all the distinct values in that column and improve our expression as follows:
= Table.Pivot(Source, List.Distinct(Table.Column(Source, "Measure")), "Measure", "Value")
This returns the same result as our first query – it uses Table.Column() to get a list of all the values in the Measure column, then List.Distinct() to return only the distinct values from that list.
Finally, there is an optional fifth parameter that can be used to aggregate data. The following source table has two rows for Sales Value for March:
If I use my original expression the pivot will work but I'll get an error value in the cell for Sales Value for March:
Specifying a function to aggregate the data in these scenarios, where two cells need to be pivoted to one, solves the problem:
= Table.Pivot(Source, {"Sales Units", "Sales Value"}, "Measure", "Value", List.Sum)
In this case I'm passing the function List.Sum() to get the value 10+15=25 in the cell for Sales Value for March.
Generating A Date Dimension Table In Power Query
There are hundreds of different methods for generating a Date dimension table for use in Power Pivot: you can use TSQL, Excel formulas, import from the DateStream table in the Windows Azure Marketplace, and there's even an app for it. Nevertheless I thought it would be a good idea to solve this problem in Power Query because:
- It seems like the natural tool to use, and a date table is one of the first tables a data steward will want to share with his/her users.
- It's a very good way to learn about and demonstrate all the date functionality in M and Power Query. The more M code examples that there are out there, the better, right?
- Having just signed the contract to write a whole book on Power Query I need to master M very quickly!
Here's how I did it. First of all, I decided to implement a function to create the table rather than a regular query; this function takes two parameters: the start date and the end date of the range of dates to appear in the table. Here's the function I came up with:
CreateDateTable = (StartDate, EndDate) =>
//Create lists of month and day names for use later on
MonthList = {"January", "February", "March", "April", "May", "June"
, "July", "August", "September", "October", "November", "December"},
DayList = {"Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"},
//Find the number of days between the end date and the start date
NumberOfDates = Duration.Days(EndDate-StartDate),
//Generate a continuous list of dates from the start date to the end date
DateList = List.Dates(StartDate, NumberOfDates, #duration(1, 0, 0, 0)),
//Turn this list into a table
TableFromList = Table.FromList(DateList, Splitter.SplitByNothing(), {"Date"}
, null, ExtraValues.Error),
//Caste the single column in the table to type date
ChangedType = Table.TransformColumnTypes(TableFromList,{{"Date", type date}}),
//Add custom columns for day of month, month number, year
DayOfMonth = Table.AddColumn(ChangedType, "DayOfMonth", each Date.Day([Date])),
MonthNumber = Table.AddColumn(DayOfMonth, "MonthNumberOfYear", each Date.Month([Date])),
Year = Table.AddColumn(MonthNumber, "Year", each Date.Year([Date])),
DayOfWeekNumber = Table.AddColumn(Year, "DayOfWeekNumber", each Date.DayOfWeek([Date])+1),
//Since Power Query doesn't have functions to return day or month names,
//use the lists created earlier for this
MonthName = Table.AddColumn(DayOfWeekNumber, "MonthName", each MonthList{[MonthNumberOfYear]-1}),
DayName = Table.AddColumn(MonthName, "DayName", each DayList{[DayOfWeekNumber]-1}),
//Add a column that returns true if the date on rows is the current date
IsToday = Table.AddColumn(DayName, "IsToday", each Date.IsInCurrentDay([Date]))
Some things to point out:
- Look – comments! Both multi-line /* */ and single line //. Adding comments to complex Power Query queries and functions is of course a Good Thing and something we should all be doing.
- The way I created the table from the start and end date is quite interesting: the List.Dates() function allows you to generate a list of dates from one date to another; I was then able to take this list and turn it into a table with Table.FromList().
- Adding extra columns to the table for the year and month number and so on is fairly straightforward. However, as far as I can see, Power Query does not have the ability to return month or day names (as opposed to numbers) from a date, so to get round this I created two lists called MonthList and DayList containing the months of the year and the days of the week, in order, took the day and month numbers and used these to find the name at the nth position in the list (see the MonthName and DayName steps).
- Date.IsInCurrentDay() compares a date with the current system date and allows you to see if a date is today's date. There are a whole bunch of other interesting functions like this such as Date.IsInPreviousWeek(), Date.IsInCurrentYear() and so on, useful for creating relative date dimension tables like the one I describe here.
With the function created it's very easy to generate a table using it. For example, I created a parameter table with start date and end date columns like so:
I then used this table as the starting point for a new query that called my function:
Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
ChangedType = Table.TransformColumnTypes(Source,{{"Start Date", type date}
, {"End Date", type date}}),
CallCreateDateTable = CreateDateTable(ChangedType[Start Date]{0}
,ChangedType[End Date]{0})
Here's the output:
You can download my demo workbook with all the code in from here.
PS If you haven't downloaded the November update for Power Query already, I recommend you do so – the UI has been improved a lot.
Now(), The Formula Engine Cache And The Where Clause
Back in 2009 I blogged about how the use of the Now() function inside calculated members prevents the results of those calculations being cached for longer than the lifetime of a query. It might be worth rereading that post before you carry on to get some background on the problem here:
Today I had an interesting email from a customer (thank you, Per!) showing me something I didn't know: that using the Now() function in the Where clause of a query has the same effect.
Here's the repro. On the MDX Script of the Adventure Works cube, I created the following calculated measure:
CREATE MEMBER CURRENTCUBE.MEASURES.TEST AS [Measures].[Internet Sales Amount] + 1;
Now consider the following query:
{[Date].[Day Name].&[1]}
FROM [Adventure Works]
STRTOMEMBER("[Date].[Calendar Year].&[" + "2003" + "]")
The first time the query is run you can see in Profiler the SSAS Storage Engine retrieving values; the second time it's run you can see the values for MEASURES.TEST being returned from the Formula Engine cache.
Now consider this second query:
{[Date].[Day Name].&[1]}
FROM [Adventure Works]
STRTOMEMBER("[Date].[Calendar Year].&[" + cstr(Year(Now())-10) + "]")
It returns the same result as the previous query (at least so long as the current year is 2013), but you can see in Profiler that the second time the query is run, once again the Storage Engine cache is queried and the Formula Engine cache is not used:
So clearly the use of the Now() function in the Where clause is enough to prevent the use of global scope by the Formula Engine cache, and some limited testing suggests the same applies for other non-deterministic functions like Username() – which is hardly surprising. Something to watch out for, then…
Caching The Rows Returned By An MDX Query
Here's another tip for those of you struggling with the performance of SSRS reports that run on top of an Analysis Services Multidimensional cube. Quite often, SSRS reports require quite complex set expressions to be used on the rows axis of an MDX query, and one of the weaknesses of SSAS is that while it can (usually) cache the values of cells returned by a query it can't cache the structure of the cellset returned by the query. What does this mean exactly? Well, consider the following query:
{[Measures].[Internet Sales Amount]} ON 0,
[Measures].[Internet Sales Amount],
[Measures].[Internet Sales Amount])
FROM [Adventure Works]
Here I'm taking every month on the Calendar hierarchy of the Date dimension and finding the top two customers by Internet Sales Amount for each Month; notice also that I'm slicing the query by a Product Category. The results look like this:
On my laptop this query takes just over three seconds to run however many times you run it (and yes, I know there are other ways this query can be optimised, but let's imagine this is a query that can't be optimised). The reason it is consistently slow is because the vast majority of the time taken for the query is to evaluate the set used on rows – even when the Storage Engine has cached the values for Internet Sales Amount for all combinations of month and customer, it still takes the Formula Engine a long time to find the top two customers for each month. Unfortunately, once the set of rows has been found it is discarded, and the next time the query is run it has to be re-evaluated.
How can we improve this? SSAS can't cache the results of a set used on an axis in a query, but SSAS can cache the result of a calculated measure and calculated measures can return strings, and these strings can contain representations of sets. Therefore, if you go into Visual Studio and add the following calculated measure onto the MDX Script of the cube on the Calculations tab of the Cube Editor:
[Measures].[Internet Sales Amount],
[Measures].[Internet Sales Amount])
You can then use this calculated measure in your query as follows:
{[Measures].[Internet Sales Amount]} ON 0,
FROM [Adventure Works]
Having done this, on my laptop the query is just as slow as before the first time it is run but on subsequent executions it returns almost instantly. This is because the first time the query is run the set expression used on rows is evaluated inside the calculated measure ReportRows and it is then turned into a string using the SetToStr() function; this string is then returned on the rows axis of the query and converted back to a set using the StrToSet() function. The second time the query is run the string returned by the ReportRows measure has already been cached by the Formula Engine, which explains why it is so fast.
Couldn't I have used a static named set declared on the cube to do this instead? I could, if I knew that the Where clause of the query would never change, but if I wanted to change the slice and look at a different Product Category I would expect to see a different set of rows displayed. While in theory I could create one gigantic named set containing every set of rows that ever might need to be displayed and then display the appropriate subset based on what's present in the Where clause, this set could take a very long time to evaluate and thus cause performance problems elsewhere. The beauty of the calculated measure approach is that if you change the Where clause the calculated measure will cache a new result for the new context.
There are some things to watch out for if you use this technique, however:
- It relies on Formula Engine caching to work. That's why I declared the calculated measure on the cube – it won't work if the calculated measure is declared in the WITH clause. There are a lot of other things that you can do that will prevent the Formula Engine cache from working too, such as declaring any other calculated members in the WITH clause, using subselects in your query (unless you have SSAS 2012 SP1 CU4), using non-deterministic functions and so on.
- Remember also that users who are members of different roles can't share formula engine caches, so if you have a lot of roles then the effectiveness of this technique will be reduced.
- There is a limit to the size of strings that SSAS calculated measures can return, and you may hit that limit if your set is large. In my opinion an SSRS report should never return more than a few hundred rows at most for the sake of usability, but I know that in the real world customers do love to run gigantic reports…
- There is also a limit to the size of the Formula Engine flat cache (the cache that is being used here), which is 10% of the TotalMemoryLimit. I guess it is possible that if you run a lot of different queries you could hit this limit, and if you do then the flat cache is completely emptied.


text:
Visit the world through the magic of great reads. You can go from the hottest places on earth to the coldest, all from the comfort of your living room.
Are you wondering what to read next? Try our NextReads e-newsletter service and get great book suggestions by email. We'll send you a reading list every two months with links to our catalogue so you can see what's available. You'll find something old and something new.
If you click on Archived newsletters, you can take a look at some of the newsletters that we have sent out to our customers over the past year.
We have newsletters in many other reading genres as well as armchair travel. Check out our NextReads newsletters to find your next great reads.


text:
Le Creuset Caribbean Blue 10-oz. Stoneware Mortar and Pestle by Le Creuset
Maximize flavor by grinding spices and herbs with this invaluable kitchen tool. Unglazed interior and pestle tip create the perfect surface for efficiency. Easy to clean and dishwasher safe.
The Le Creuset Tri-Ply Stainless-Steel 5-Qt. Braiser is a professional-grade classic for braising, roasting, searing and sauteing ...meats and vegetables infused with moist, delicious flavor. The tri-ply stainless-steel construction with full base-to-rim aluminum core equips the covered stainless-steel braiser to heat all over quickly and evenly. With the dry-heat browning or searing, then moist-heat simmering, your creamy risottos, coq au vin and spicy pork ribs cook faster and without hot spots or scorching. The magnetic 18/10 stainless-steel exterior's brushed finish helps hide fingerprints and an 18/10 stainless-steel interior fully sears even on lower heat. Whether you're right- or left-handed, the precision-pour rim conveniently pours gravies, sauces and liquids without messy spills and splashes. The Le Creuset stainless-steel braiser's wide yet low profile accommodates larger meats and liquids all in one pan and flawlessly finishes dishes in the oven. The ergonomic, polished stainless-steel handles stay cool and a mirror-finish lid fits tightly to lock in nutrients and flavors. Secure stainless-steel rivets add to the Le Creuset tri-ply stainless-steel 5-qt. braiser's long-lasting durability for cooking on any stove top or inside the oven to 425 F. The covered stainless-steel braiser's cleans easily in the dishwasher or by hand. The mainstay of French chefs for nearly a century, Le Creuset is synonymous with both exceptional craftsmanship and brilliant style. A trendsetter in high-quality, indispensable cookware, Le Creuset designs each culinary piece for both gourmets and novice home chefs. Product Features ? Commercial tri-ply stainless-steel construction with full base-to-rim aluminum core for all-over heat conductivity ? Le Creuset stainless-steel braiser all-around heat distribution prevents hot spots and scorching ? Signature precision-pour rim conveniently prevents pouring splashes and spills ? Non-drip rim works equally well for right- or left-handed pouring ? 18/10 stainless-steel interior efficiently sears and braises foods even on lower heat ? Brushed 18/10 stainless-steel exterior with a polished band helps hide fingerprints ? Capacity markings help with quick and easy liquid measurements ? Mirror-finish lid fits tightly to lock in nutrients and flavors ? Stay-cool, polished stainless-steel handles are designed for ergonomic comfort ? Secure stainless-steel rivets provide extra durability ? Magnetic base is etched with covered stainless-steel braiser's size for quick reference ? Use with nonmetal utensils to better protect the cookware surface ? Suited for all stovetops including electric, gas, ceramic, halogen and induction ? Oven-safe to 425 F (220 C, Gas Mark 7) and broiler-safe ? Dishwasher-safe; hand washing recommended ? Limited lifetime warranty read more
at Cooking.com
Le Creuset enamel on steel kettles are crafted of high-quality materials and built to last. Made with sturdy carbon steel and fini...shed with a vibrant porcelain enamel finish, each model combines precise craftsmanship with the colorful style and beauty that only Le Creuset can offer. With a variety of unique designs and sizes, there?s a kettle for any kitchen ? from compact to large, from traditional to modern. Useful for preparing French press coffee, oatmeal and much more in addition to tea, Le Creuset Kettles make excellent gifts and are a simple yet effective way to add a touch of color to the kitchen. Features: Single-tone whistle alerts when water has reached a rolling boil A generous base size for greater contact with heating element so water boils quickly Convenient quick heating with superior heat distribution Fixed whistle can be easily flipped open for pouring Heat-resistant, ergonomic handle for safe pouring Kettle capacity marked on the base for quick reference Can be used on any heat source (gas, electric, ceramic, halogen, induction) read more
Theres no need for guesswork when it comes to measuring ingredients with this 4-piece measuring cup set. This brushed stainless st...eel set is durable and easy to use. Plus, the cups are dishwasher safe, making for quick and easy cleanup. includes �, ?, � and 1-cup measuring cupsallows for precise measuringpolished and brushed finish Stainless steel. Dishwasher safe. Imported. read more
No kitchen is complete without a full set of measuring spoons. Whether youre baking treats or preparing a meal, you need accurate ...measurements of ingredients, and this stainless steel measuring spoon set ensures you use the exact amount of ingredients necessary. includes ? tsp, � tsp, � tsp, 1 tsp and 1 TBSPlabeled measurementsunique shape allows spoons to sit flat on countertop Stainless steel. Dishwasher safe. Imported. read more
Porcelain enamel on stainless steel Single-tone whistle Safe for all cooktops, including induction 1.6-quart capacity Heat-resista...nt handle Hand wash Whats Included Teakettle, lidDescription Ease your kitchens path to enlightenment with the Le Creuset Zen 1.6-qt. Stainless Steel Whistling Teakettle - Cherry. Beautiful Asian-inspired design meets practicality in this low-profile whistling teakettle. The strong enamel finish resists chips, stains, and odor absorption. Safe for electric, gas, ceramic, and induction heat surfaces, this kettles wide base makes better contact with the heat, leaving you more time to meditate on your perfect cup of tea. About Le Creuset of America Inc. From its cast iron cookware to its teakettles and mugs, Le Creuset is a global standard of inimitable color and quality. Founded in 1925 in the northern French town of Fresnoy-Le-Grand, Le Creuset still produces enameled cast iron in its original foundry. Its signature color, Flame, was modeled after the intense orange hue of molten cast iron within a cauldron (or creuset in French), and has been a Le Creuset bestseller from the companys first year to the present day. Though best known for its vibrantly colored cookware and original inventions such as the Dutch oven, Le Creuset has also forged a name as a creator of stoneware mugs and enamel-coated stainless steel teakettles. The style and performance of Le Creusets Cafe Collection and tea accessories are rooted in classic French cookware: bold colors, cylindrical loop handles, unmatched thermal resistance and heat distribution, and of course the iconic Le Creuset three-ring accent. Through its consistent qualities of authenticity, originality, and innovation, Le Creuset maintains a connection to both heritage and modernity. read more
at Cooking.com
Le Creuset enamel on steel kettles are crafted of high-quality materials and built to last. Made with sturdy carbon steel and fini...shed with a vibrant porcelain enamel finish, each model combines precise craftsmanship with the colorful style and beauty that only Le Creuset can offer. With a variety of unique designs and sizes, there?s a kettle for any kitchen ? from compact to large, from traditional to modern. Useful for preparing French press coffee, oatmeal and much more in addition to tea, Le Creuset kettles make excellent gifts and are a simple yet effective way to add a touch of color to the kitchen. Features: Single-tone whistle alerts when water has reached a rolling boil Generous base size for greater contact with heating element so water boils quickly Convenient quick heating with superior heat distribution Fixed whistle can be easily flipped open for pouring Stainless steel handle brackets for secure handling Heat-resistant ergonomic handle for safe pouring Kettle capacity marked on the base for quick reference Can be used on any heat source (gas, electric, induction, ceramic) read more
Make perfect pasta every single time with this stainless steel pot from Le Creuset. The included insert makes for easy draining an...d convenient transportation from the pot to the serving dish, and the 7�-quart size is perfect for boiling enough pasta to serve an entire family. aluminum core between 2 layers of professional-grade stainless steelbalances heat conduction and heat distributionstay-cool handles provide better controldraining insert allows easy movement of pasta from the pot to a serving dishprecision-pour rim for clean, convenient pouring Stainless steel. Dishwasher safe. Imported. read more
Beautiful and practical, Le Creuset enamel-on-steel stock pots are truly the perfect addition to any kitchen. made of heavy gauge ...carbon steeltight-fitting lid seals in every precious drop of flavorenamel-on-steel construction provides even heat distribution for slow simmering or cookingsteel rim prevents chipping of enamelsuitable for gas, electric, radiant and ceramic stove tops. Dishwasher safe. 13�x11�x11�" high. Lifetime manufacturers guarantee. Imported. read more
Le Creusets light, but durable, stoneware pie dish is ideal for baking pies and quiche and the classic scallop edging makes for a ...beautiful presentation at your table. The smooth interior glaze and even-heating design cook more uniformly than traditional bakeware, which results in perfect golden brown pastry crust. high-quality enamel protects against marks and damagesafe for temperatures from -65�F to 500�Fvirtually nonstick, glazed interior easily releases foodsoven, microwave, freezer and dishwasher safeacts as both baking and serving dish Stoneware. Dishwasher safe. Imported. read more
at Cooking.com
Enjoy coffee, espresso and cappuccino in color with Le Creuset?s new Cafe Collection. Some say coffee prepared in a French press i...s the way every cup should be savored. Coarsely ground coffee beans are steeped in boiling water, and then filtered away by plunging the mesh sieve through the press. Direct contact between the beans and the water means a stronger flavor. Loose tea leaves can also be steeped in a French press. Features: 27-ounce capacity High-quality exterior enamel protects against metal marks and other damage Less than 1% porosity, blocking moisture absorption which can lead to cracking, crazing and rippling Resistant to staining and flavor/odor absorption read more
at Cooking.com
Make Pizza, flatbreads, calzones and more with the Pizza Stone and Peel Set. This set includes: A cheese grater with interchangea...ble blades; fine shredder, medium shredder and slicing blade. Pizza wheel Professional pizza cutter Origins is a celebration of food and flavor, and freedom to explore the multicutural world in which we live. With Origins, the World is at your table. read more
at Cooking.com
- editors' notes
- product details
Add some color to your cookware arsenal! This set contains the essentials in an eye-catching color.
Stylish two-tone gradient exterior adds color and style to any kitchen. Plus, this cookware heats quickly and evenly, reducing "ho...t spots" that can burn foods. Set Includes: 1-qt. Covered Sauce Pan 2-qt. Covered Sauce Pan 6-qt. Covered Stockpot 3-qt. Covered Saute Pan 8.5-in. Skillet 10-in. Skillet Features: A long-lasting nonstick interior allows food to slide off and makes cleanup quick and easy. The rubberized dual-riveted handles are comfortable and oven safe to 350�F. Watch your foods cook without having to remove the lid to keep moisture locked in. read more
at Cooking.com
Simply Calphalon Enamel Nonstick cookware is designed for everyday use, with a durable nonstick interior for easy food release. Th...e aluminum core evenly conducts heat along the bottom and sides of the pan for consistent results meal after meal, while the porcelain enamel exterior resists chipping and scratching. Features: Multi Layer nonstick with etched fill marks. Tight fitting glass lids with straining holes and silicone rims. Hard anodized aluminum construction with pour spouts, oven safe to 450 degrees Full lifetime warranty. read more
at Cooking.com
"My beautiful stoneware collection is essential for some of my favorite recipes, like sweet savory pies, quick breads and meatloaf..., and of course casseroles galore. I like how they look and feel, and the raised hobnail design makes my heart sing!" - Paula Deen Featured: Crafted in a unique hobnail design, this stoneware au gratin is designed to bake and entertain Southern style. Each stoneware au gratin is uniquely glazed so that no two pieces are alike. Ideal for prepping, baking, serving and reheating. Designed for oven, microwave, refrigerator and freezer use. Dishwasher safe and oven safe to 500�F. read more
at Cooking.com
Exceptionally even heating ensures optimum cooking performance. Calphalon AccuCore Stainless Steel cookware offers an exceptionall...y versatile cooking surface, and is the best choice for high-temperature techniques such as searing and deglazing. Made from 5 individual metal layers, Calphalon AccuCore Stainless Steel cookware offers a responsive copper core to maintain a consistent temperature, sandwiched between two layers of aluminum to efficiently conduct heat, while stainless steel outer layers create a beautiful, durable surface that is dishwasher safe. Features Five layers with copper core Dishwasher safe Induction capable Oven and broiler safe Stay-cool handles Full lifetime warranty read more
at Cooking.com
These handy stoneware bakers make cooking and entertaining a cinch because they can be used to bake cauliflower and ham au gratin,... prep a side dish like stuffed cherry peppers or serve a refreshing cucumber salad. The contemporary design and bold color make these Bubble and Brown� bakers pieces that are sure to be a talking point with guests because of their unique style. Stoneware from Rachael Ray? is an extension of the aesthetic she has already brought to cookware and dinnerware: bright colors, unique shapes and durable materials in versatile pieces that any home cook will appreciate. These round bakers are crafted from dependable stoneware that doesn?t react to food and is safe for use in the microwave, dishwasher, freezer and oven ? up to 500�F. The bright color is great for coordinating with other kitchen pieces and they are sure to be a hit when they make their way onto the table during a dinner party. Features: Includes 1.5-qt. and 2-qt. Bakers These oven-to-table pieces are great for dinner parties or quiet meals during the week. Shallow sides result in crunchy tops for your favorite baked recipes and the extra wide handles offer a confident grip. These round bakers are safe to use in the microwave, freezer, dishwasher and oven, up to 500 degrees Fahrenheit. read more
Rachael makes traveling to holiday parties easier with her new stoneware covered baker and matching bonus carrier! The 3.5-qt. cov...ered baker is perfect for cooking your favorite holiday sides and the large insulated carrier keeps it warm until you arrive at your destination. The roomy carrier features high density thermal insulation plus Therma-Flect� radiant barrier to keep food hot or cold for hours. There is an Ultra Safe? easy clean lining and comfortable, padded carry handle. Carrier folds flat for convenient storage until your next party. The 3.5-quart covered rectangular baker is crafted from dependable stoneware that doesn?t react to food and is safe for use in the microwave, dishwasher, freezer and oven ? up to 500�F. The securely fitting lid is perfect for sealing in heat and flavors, and the wide and comfortable handles mean it?s easy to transfer the casserole around the kitchen, dining room and now right into the insulated carrier. Great for holidays, potlucks, bbq?s, picnics, office parties and more... Includes: 3-1/2-Quart Covered Rectangular Casserole Bonus Large Insulated Carrier - comfortably fits a 9 x 13? baking dish and can hold up to a 10 x 15? baker! read more
at Cooking.com
This cookware set is an exceptional value, including all of the pans needed to equip your kitchen with the most used cooking piece...s. As the set contains only basic pieces, you'll really use each and every pan. It includes saucepans for whisking a homemade sauce or cooking your morning oatmeal, a dutch oven for chilli, soups, and stews, and skillets (probably the most used pan in any kitchen) that will help you turn out perfect crepes or a simple grilled cheese sandwich. It even has three must have Prestige�Kitchen Tools. Set Includes: 1-qt. Covered Sauce Pan 2-qt. Covered Sauce Pan 2.75-qt. Covered Saute Pan 5-qt. Covered Dutch Oven 10-in. Skillet Slotted Turner Slotted Spoon Solid Spoon Features: Dishwasher-safe convenience makes cleanup quick and easy. Heavy-gauge construction distributes heat evenly throughout the pan and reduces hot spots. Glass lids allow you to monitor cooking without losing heat, flavor or nutrients. Comfortable Phenolic Handles - oven-safe to 350�F. read more
Exclusively ours from Rachael Ray! This 3-pc. Lasagna Lovers Set offers a savings versus buying these pieces individually. Excite ...your dinner guests by bringing this vibrant, fun rectangular stoneware baker to the table. Melt cheesy lasagna, crisp a cobbler, serve a tray of tacos or use it as your fruit bowl, it's just that good looking. Features: Multiple Use Stoneware - Dishwasher, microwave, freezer safe and oven safe to 500�F for convenience and versatility. The glazed interior is nonporous so foods won't interact. Contemporary Design - Contemporary, playful shape in a vibrant and fun color goes directly from oven to table. Wide Handles - Extra wide handle holes allow you to get a good grip from any angle. 9"x13" - Generously sized, this large LASAGNA LOVER is great for baking just about everything. Whatever you decide, your favorite foods will arrive to the table in style Exterior Dimensions: Length: handle to handle 13.380-in. Width: measured from the center of the pan 10.313-in. Height- from bottom surface to top of handle 9.854-in. Height- from bottom surface to top of center pan 2.882-in. Rachael's colorful, flexible nylon turners won't scratch your nonstick cookware and feel great in your hand. The long flexible heads on these turners can flip everything from delicate eggs to juicy steaks. The open design lets grease fall back into the pan instead of landing on your plate. Heat resistant to 400�F. Durable, lightweight handles are heat safe to 350�F. Caution: handles may melt if rested on the side of a hot pan. Includes 10-in. and 12-in. turners. In a short time, Rachael Ray has radically changed the way America cooks dinner. Her perky girl-next-door swagger, her catchphrases for techniques, and her dinner ideology of simpler, less expensive and just-in-time have sold billions of books and made her one of the top personalities in food television. read more
at Cooking.com
Caffeine: you have to have it. To enjoy the perfect brew without leaving your kitchen, take a look at the DeLonghi 57-oz. Magnific...a Digital Espresso Machine. You're going to see mornings in a whole new light when you have this caffeine machine waiting patiently on the counter for your every command. It's small enough to fit on your countertop, but it offers the full functionality of bigger machines, so you're not sacrificing anything for the sake of space. Use pre-ground coffee or whole coffee beans -- Magnifica will perfectly grind them for you instantly with its patented Direct-to-Brew system. Just add milk to the integrated tank, and Magnifica will froth it for you, allowing you to create your very own cappuccino, too. Maintenance is minimal: a water filtration system helps purify your water to ensure your espresso always tastes its best, and the decalcification system cuts down on how often you need to manually clean buildup from the tank. Maybe its best feature, though, is the programmable timer. Set everything up before bed, set a time, and Magnifica will have your caffeine ready and waiting for you as soon as you wake up in the morning -- just add milk and sugar. Best Used For: Best used for brewing that high-octane espresso you crave and for frothing milk to help you prepare the perfect cappuccino right at home. Features: Milk tank can be removed and stored in the refrigerator 1250 watts 15-bar pressure pump read more


text:
VALDOSTA — Valdosta State University inducted eight individuals into its Athletic Hall of Fame during a luncheon Saturday afternoon in Valdosta. The inductees included (from left to right): Don Reason, Andre Hampton, John Hanson representing Annika Biro, Jerry and Kay Jennett, Jon Good, Jim Madaleno, and Robert Morgan.
Blazers Blog
- Blazers Blog
Kirkwood named AVCA All-Region Honorable Mention
Jenna Kirkwood has been named All-Region honorable mention by the American Volleyball Coaches Association in recognition of her efforts during her first season as a Lady Blazer.
Chris Pope named All-Super Region 2
Valdosta State senior linebacker Chris Pope was selected to the Daktronics Super Region 2 All-Region team in a vote of the Super Region 2 Sports Information Directors, as announced by the organization Friday.
Next Up for Lady Blazer Basketball: West Florida
Competition heats up soon for the Lady Blazers when Gulf South Conference rival West Florida comes to town to open up league play on Saturday, Dec. 14 at 6 p.m. in The Complex.
Volleyball Upset 1-3 by North Alabama in First Round of GSC Tournament
A host of attack errors plagued the No. 2 Valdosta State volleyball team in the first round of the Gulf South Conference Tournament on Friday night in Pensacola, Fla., and the No. 7 North Alabama Lions took full advantage of the opportunity, as they knocked off Valdosta State with a 3-1 victory.
VSU Basketball doubleheader at P.E. Complex on Saturday
The VSU Lady Blazers (2-0) take the floor Saturday in a battle of undefeated teams as they host the 2-0 Georgia Southwestern Lady Hurricanes. Valdosta State men's team will look to move to 4-0 as they host the 5-0 Johnson C. Smith Golden Bulls.
Ten Blazers named All-Gulf South Conference
Ten Valdosta State football players have been named All-Gulf South Conference, as announced by the league office on Wednesday.
Swan named GSC Coach of the Year; two Blazers named All-GSC
The Gulf South Conference released on Tuesday morning the All-GSC picks for the 2013 season, and the Blazer Volleyball program was well represented, as both Jessica Codato and Jenna Kirkwood were honored as selections to the All-GSC First Team. In addition, Head Coach Mike Swan has been named the Gulf South Conference Coach of the Year.
Blazer Basketball moves to 3-0
The Men's Blazer basketball team won their third in a row to open the season.
Lady Blazers light up the Complex with 96-50 win
In front of a crowd of nearly 1200 rowdy Blazer fans who turned out for Monday night's home opener at the Complex, the Lady Blazers delivered an offensive performance for the ages with a 96-50 win over the Eagles of Trinity Baptist.
Men's Basketball rolls to 97-58 victory over Trinity Baptist
Valdosta State overcame a slow shooting start to defeat Trinity Baptist 97-58 in non-conference men's basketball action at The Complex Monday evening.
- More Blazers Blog Headlines
Kirkwood named AVCA All-Region Honorable Mention


text: SPAM! stems from the desire to take advantage of an inexpensive, lightweight and somewhat poetic, involving a series of artists 'neighbors' association, which have been handed the cards 10×15 cm (just like the postcards type) to customize to their own tastes and sensitivity. The postcards in total freedom during the summer, wherever the artist he was, were shipped at the Association for contemporary look, and finally exhibited at the Spazio Cerere.


text:
A gene set analysis function for one-sided test (OLS) and two-sided test (multivariate analysis of variance). If the experimental conditions are equal to 2, the p-value for Hotelling's t^2 test is calculated. If the experimental conditions are great than 2, the p-value for Wilks' Lambda is deterimined and post-hoc test is reported too. Three multiple comparison procedures, Dunnett, Tukey, and sequential pairwise comparison, are implemented. The program computes the p-values and FDR (false discovery rate) q-values for all gene sets. The p-values for individual genes in a significant gene set are also listed. MAVTgsa generates two visualization output: a p-value plot of gene sets (GSA plot) and a GST-plot of the empirical distribution function of the ranked test statistics of a given gene set.
Version: | 1.2 |
Depends: | R (≥ 2.13.2), MASS, corpcor (≥ 1.6.0), multcomp (≥ 1.2-7) |
Published: | 2012-10-11 |
Author: | Chih-Yi Chien, Chen-An Tsai, Ching-Wei Chang, and James J. Chen |
Maintainer: | Chih-Yi Chien <chihyi.chien at fda.hhs.gov> |
License: | GPL-2 |
NeedsCompilation: | no |
CRAN checks: | MAVTgsa results |
Reference manual: | MAVTgsa.pdf |
Package source: | MAVTgsa_1.2.tar.gz |
MacOS X binary: | MAVTgsa_1.2.tgz |
Windows binary: | MAVTgsa_1.2.zip |
Old sources: | MAVTgsa archive |


text:
You limited your search to:
UNT Libraries
Serial/Series Title:
Tunza environmental series for children
Environmental Policy Collection
- Ting and the Possible Futures
- This is a children's book where the characters build a time machine that lets them visit alternate futures based on the decisions they make in the present. The story provides a glimpse of a post-apocalyptic dystopia as a result of severe global climate change, as well as a future utopian ideal that comes as a result of implementing massive changes to land use and food and energy production. digital.library.unt.edu/ark:/67531/metadc28542/


text:
Renewable Choice Blog Archives
Sustainable Business
- Happy Holidays from Renewable Choice and Mosaic Labs! (12/09/2013)
- Green Power Partnership Publishes its Top Partners Lists (11/15/2013)
- New York State to Open Green Bank (10/31/2013)
- The Rising Current of Green Gyms Around the World (07/23/2013)
- CDP Supply Chain Program Deadline Approaches (07/12/2013)
LEED Green Building
Industry News
- Approaching the Renewable Energy Tipping Point (12/19/2013)
- Renewable Energy Finance Tactic Changes the Game (12/04/2013)
- We Are Thankful 2013 (11/18/2013)
- The Little Engines That Could: How Grassroots Stopped Oil & Gas Encroachment in Colorado (11/13/2013)
- Carbon-Neutral Energy Attainable Through Gasification System (11/06/2013)
- The Intersection of Environmental and Social Justice (12/17/2013)
- Climate Change Comes Home (10/21/2013)
- 3 Apps to Help You Use Less Energy in Your Home (10/15/2013)
- How to Ride 4700 Miles on a Bamboo Bike without Flipping on a Light Switch (08/26/2013)
- The Connection between Climate and Waste (08/01/2013)
Showing: June 2009
Green Meetings & Events Free Webinar
by Heather Philipp on 06/26/2009
Tags: Green Meetings, Lana Malone, RECs, Renewable Energy Credits, Sustainability, Verified Emission Reductinos, VERs, Webinar
Join us for the Green Your Event webinar Tuesday, June 30, 11 am MST/1 pm EST
Did you know that most of the greenhouse gas emissions associated with events originate from travel to and from the event? Green meetings are fast becoming the norm. Now, you can add... [more]
Next Renewable Energy Credit & Carbon Offset Webinar
by Heather Philipp on 06/26/2009
Tags: Jason Wykoff, RECs, Renewable Energy Credits, Sustainability, Verified Emission Reductinos, VERs, Webinar
A webinar to help you support your corporate responsibility goals with RECs and carbon offsets.
Our first webinar on renewable energy credits (RECs) and verified emission reductions (VERs), aka carbon offsets, was such a success, we're doing another one! Renewable energy is... [more]
Showing 1 - 2 of 2 Articles | Page 1 of 1