text:
Swiss watchmaker Montres Etoile announced the launch of its first complication, an automatic, tri-retrograde, Islamic Lunar and Gregorian Dual – calendar timepiece with moon face. This complicated wristwatch based on an automatic Swiss made movement is completed by a complication module made by Agenhor in Geneva and is housed in a steel watchcase. The watch is available through select retail partners across the UAE, Saudi Arabia, Oman & Kuwait in time for the Eid gifting season as well as at boutiques and POS in Switzerland, Korea, China and Ukraine. Watch enthusiasts and collectors from other markets can contact the brand through their website.
The Islamic calendar began in 622 AD and is still used in most Islamic countries. To integrate the Islamic calendar together with the conventional Gregorian calendar on a mechanical wristwatch is a unique feature worldwide. The Etoile dual-calendar wristwatch is housed in an octangular shaped watchcase measuring 42mm in diameters indicating hours and minutes with two large hands in the center of the dial.
The date of the Gregorian calendar is indicated by a retrograde – hand starting from the left at 10 O'clock and ending at the right at 2 O'clock with the 31st day of the month. The date of the 30 days of the Islamic calendar are indicated at 6 O'clock with Arabic numerals. At 4 0'clock the retrograde hand starts indicating the first month of the Hijri calendar and ends at the left side of the dial at 8 O'clock with the last month.
Creatively inspired design and untiring technique have been the driving forces behind the legendary Stefan Hafner's search for innovation in Etoile watches and jewelery since 1967. A collection in which there is play between volume and flexibility in a three dimensional game. Etoile launched its first watch and jewelery line in 1986. It is the famous Swiss Italian creator, Stefan Hafner who designed and manufactured the watches and jewelery of this first collection.
At that time, most watches were very traditional in concept. Etoile longed to free its design from conventional restraints and imposed its very own style by creating sumptuously worked wrist watches, blending the erudite geometry of Islamic aesthetics with flowing Art Déco designs. Thanks to its audacious and daring designs, Etoile has been introduced successfully in Europe, the Middle and Far-East. That same passion and philosophy inspires the brand today to create new models. By blending aesthetics of sober and pure lines with top quality Swiss movements, Etoile watches, created now created by Fulvio Borel, allow the brand Etoile to reaffirm its unique style.


text:
The material on this website is intended to provide a summary and general overview on matters of interest. It is not intended to be comprehensive.
The information on this website is liable to change. Although we attempt to ensure that the content is accurate, we do not guarantee its accuracy as there may be delays, errors or omissions.
Hunter Douglas Limited is not responsible to you or anyone else for any loss suffered in connection with the use of this website or any of the content. This includes, but is not limited to, the transmission of any computer virus. We recommend that prior to using any downloaded file, you carry out an appropriate virus check.
For your convenience and information, this site contains links to other sites, but Hunter Douglas Limited makes no representations or warranty as for the accuracy or any other aspect of the information on those linked sites. No link to another site should be construed as an endorsement or recommendation of any information, goods or services referred to.
All trade marks mentioned on this website belong to Hunter Douglas Limited. Unless otherwise indicated, Hunter Douglas Limited owns the copyright in the content on this website.
No material on this website can be reproduced, adapted, distributed or stored in a retrievable system or transmission without a prior written consent from Hunter Douglas Limited.
You may only access and use the content for non-commercial or personal uses unless you have prior written approval from Hunter Douglas Limited. You may print out any content on this website for your personal use. All other use, copying or reproduction of this website or any part of it is prohibited (except to the extent permitted by law). None of the content or any part of it may be reproduced on any other internet website.
By accessing or using this website, you agree to the terms of use of our website. The terms of use include our legal disclaimer and our privacy policy and any other terms and conditions on this website.
We may change the terms of use at our discretion and without notice. By continuing to use our website you accept the terms of use as they apply from time-to-time. A copy of our current terms of use is displayed on our website at all times. This disclaimer is in no way limited or altered by any other terms and conditions on this website.

subset: commoncrawl


text:
TITLE – Sated AUTHOR – Charity Parkerson GENRE – Dark Erotica PUBLICATION DATE – 10/3/14 LENGTH (Pages/# Words) – 193 pages/ 40,000 PUBLISHER – Punk & Sissy Publications COVER ARTIST – Charity Parkerson for Punk & Sissy's designs.
(Erotica, Dark Romance, F/M and M/M scenes, Rock Star Romance, Ménage, Sexy Detective, Alpha Male, Supernatural themes)
"Losing her mind wasn't an experience she enjoyed." After a steamy night of passion with a dark stranger, Arbor's life takes on a surreal edge. Disturbing dreams, lapses in memory, and entire buildings going missing are only a few of her problems. Her search for answers leads her to Detective Trey Murphy, the man in charge of investigating satanic and ritualistic crime for the New Orleans' area. Where do you turn when your mind is the enemy? Meeting Trey only adds to Arbor's confusion. By day, he keeps her captivated and gains her trust in a way no one else ever has. At night, Arbor's every fantasy is brought to life by two sexy men who steal away her inhibitions. Torn between what her heart knows is real and what her eyes show her, Arbor must find the truth before she loses herself completely. But then again, sometimes reality is more twisted than any dream and love is the cruelest form of insanity. **Author Note** Warning: This isn't your typical love story. It's dark with scenes some may find disturbing. Sometimes love is senseless, and the heart is so very stupid.
"I thought you were with the band," he said as he lifted his coffee to his lips. It was the only way he could think to open the topic for discussion. Not that he cared, of course. She'd called him. It was a start. If there was a line he wouldn't cross when it came to getting what he wanted—namely, her—he hadn't yet seen it. Deep longing for something out his reach was a familiar weight. Her eyes never left the dessert menu. He knew she wasn't really seeing it because her gaze remained fixed to one spot. "With the band," she repeated, sounding wry and making him wonder if he'd insulted her. "That would require knowing where they are," she added so quietly Trey assumed it was meant more for her than him. With a shake of her head, Arbor met his stare. For a split second, Trey was rendered mute. Everything around them disappeared. It punched him in the chest. She possessed something other people did not. "What about you?" Her question didn't make as much sense as it might have if she wasn't affecting his brain function. "I'm not with the band," he said automatically, pulling a ghost of a smile from her. "You're a cop," she said, helping him along. "Detective actually." He wasn't trying to be a dick. It was more that he'd worked hard to get where he was. She set her elbows on the table. A playful light entered her eyes. "What do you detect?" "Satanic and ritualistic homicides." Huh. She didn't even flinch. "I wasn't aware there was such a high number of those types of murders that it required a special title. Are you the only one or is there an entire division?" Against his will, Trey's lips twisted. "Unfortunately, there is a need for such a title. There're three of us. I'm not sure it counts as an entire division. Louisiana is a hotbed of all things satanic and ritualistic. You're likely to run across anything here." Her gaze moved over his face, but her expression remained blank. "You do look tired." Before he had time to react, she added, "I'll have to take your word on the matter. I only moved here two weeks ago." He opened his mouth to ask more. Instead, something entirely different popped out. "You're beautiful." She blinked. Her surprise evident. There was no way she was as shocked as he was. He hadn't meant to say it. It was true, of course, but it had still slipped past his lips without his permission. "Thank you." Arbor's response sounded more questioning than automatic. He snorted. She blushed. The sight fascinated him. Their knees brushed making Trey realize somehow, he'd moved his chair closer to hers.
Arbor Sinclair was born in Colorado where she lived until her early twenties. From there she moved to New Orleans to follow the two greatest loves of her life.
Killian Moore and Lyric Wynters are the front men for the popular grundge-rock band Excile. They spent several years tourning the country before meeting Arbor.
Trey Murphy lived with his grandparents for most of his life until he went off to college to earn his degree in forensic science. It's always been his dream to make detective.
Charity Parkerson is an award winning and multi-published author with Ellora's Cave Publishing. Born with no filter from her brain to her mouth, she decided to take this odd quirk and insert it in her characters.
*2013 Readers' Favorite Award Winner *2013 Reviewers' Choice Award Winner *2014 Readers' Favorite Award Finalist *2014 Ankh Award Nominee *ARRA Finalist for Favorite Paranormal Romance *Five-time winner of The Mistress of the DarkpathFOLLOW AUTHOR HERE
Amazon Author Page – Website/Blog – Facebook – Twitter Google+ - Pinterest – Tumblr – Networked Blogs Goodreads – Shelfari – Coffeetime Romance – Elloras Cave Passionate Ink
$10 Ellora's Cave gift card, 3-pack of autographed bookmarks
Tour Hosted & Organized by


text:
« Prev | 1 Chronicles 9 | Next » |
1 Chronicles 9
9 1So all Israel were reckoned by genealogies; and, behold, they are written in the book of the kings of Israel: and Judah was carried away captive to Babylon for their transgression. 2Now the first inhabitants that dwelt in their possessions in their cities were Israel, the priests, the Levites, and the Nethinim. 3And in Jerusalem dwelt of the children of Judah, and of the children of Benjamin, and of the children of Ephraim and Manasseh: 4Uthai the son of Ammihud, the son of Omri, the son of Imri, the son of Bani, of the children of Perez the son of Judah. 5And of the Shilonites: Asaiah the first-born, and his sons. 6And of the sons of Zerah: Jeuel, and their brethren, six hundred and ninety. 7And of the sons of Benjamin: Sallu the son of Meshullam, the son of Hodaviah, the son of Hassenuah, 8and Ibneiah the son of Jeroham, and Elah the son of Uzzi, the son of Michri, and Meshullam the son of Shephatiah, the son of Reuel, the son of Ibnijah; 9and their brethren, according to their generations, nine hundred and fifty and six. All these men were heads of fathers' houses by their fathers' houses.
10And of the priests: Jedaiah, and Jehoiarib, Jachin, 11and Azariah the son of Hilkiah, the son of Meshullam, the son of Zadok, the son of Meraioth, the son of Ahitub, the ruler of the house of God; 12and Adaiah the son of Jeroham, the son of Pashhur, the son of Malchijah, and Maasai the son of Adiel, the son of Jahzerah, the son of Meshullam, the son of Meshillemith, the son of Immer; 13and their brethren, heads of their fathers' houses, a thousand and seven hundred and threescore; very able men for the work of the service of the house of God.
14And of the Levites: Shemaiah the son of Hasshub, the son of Azrikam, the son of Hashabiah, of the sons of Merari; 15and Bakbakkar, Heresh, and Galal, and Mattaniah the son of Mica, the son of Zichri, the son of Asaph, 16and Obadiah the son of Shemaiah, the son of Galal, the son of Jeduthun, and Berechiah the son of Asa, the son of Elkanah, that dwelt in the villages of the Netophathites.
17And the porters: Shallum, and Akkub, and Talmon, and Ahiman, and their brethren (Shallum was the chief), 18who hitherto waited in the king's gate eastward: they were the porters for the camp of the children of Levi. 19And Shallum the son of Kore, the son of Ebiasaph, the son of Korah, and his brethren, of his father's house, the Korahites, were over the work of the service, keepers of the thresholds of the tent: and their fathers had been over the camp of Jehovah, keepers of the entry. 20And Phinehas the son of Eleazar was ruler over them in time past, and Jehovah was with him. 21Zechariah the son of Meshelemiah was porter of the door of the tent of meeting. 22All these that were chosen to be porters in the thresholds were two hundred and twelve. These were reckoned by genealogy in their villages, whom David and Samuel the seer did ordain in their office of trust. 23So they and their children had the oversight of the gates of the house of Jehovah, even the house of the tent, by wards. 24On the four sides were the porters, toward the east, west, north, and south. 25And their brethren, in their villages, were to come in every seven days from time to time to be with them: 26for the four chief porters, who were Levites, were in an office of trust, and were over the chambers and over the treasuries in the house of God. 27And they lodged round about the house of God, because the charge thereof was upon them; and to them pertained the opening thereof morning by morning.
28And certain of them had charge of the vessels of service; for by count were these brought in and by count were these taken out. 29Some of them also were appointed over the furniture, and over all the vessels of the sanctuary, and over the fine flour, and the wine, and the oil, and the frankincense, and the spices. 30And some of the sons of the priests prepared the confection of the spices. 31And Mattithiah, one of the Levites, who was the first-born of Shallum the Korahite, had the office of trust over the things that were baked in pans. 32And some of their brethren, of the sons of the Kohathites, were over the showbread, to prepare it every sabbath.
33And these are the singers, heads of fathers' houses of the Levites, who dwelt in the chambers and were free from other service; for they were employed in their work day and night. 34These were heads of fathers' houses of the Levites, throughout their generations, chief men: these dwelt at Jerusalem.
35And in Gibeon there dwelt the father of Gibeon, Jeiel, whose wife's name was Maacah: 36and his first-born son Abdon, and Zur, and Kish, and Baal, and Ner, and Nadab, 37and Gedor, and Ahio, and Zechariah, and Mikloth. 38And Mikloth begat Shimeam. And they also dwelt with their brethren in Jerusalem, over against their brethren. 39And Ner begat Kish; and Kish begat Saul; and Saul begat Jonathan, and Malchishua, and Abinadab, and Eshbaal. 40And the son of Jonathan was Merib-baal; and Merib-baal begat Micah. 41And the sons of Micah: Pithon, and Melech, and Tahrea, and Ahaz. 42And Ahaz begat Jarah; and Jarah begat Alemeth, and Azmaveth, and Zimri; and Zimri begat Moza; 43and Moza begat Binea; and Rephaiah his son, Eleasah his son, Azel his son. 44And Azel had six sons, whose names are these: Azrikam, Bocheru, and Ishmael, and Sheariah, and Obadiah, and Hanan: these were the sons of Azel.
« Prev | 1 Chronicles 9 | Next » |


text:
The UEL Heritage Centre and Park is a mixture of history, camping, and family fun, all in one location. It is made up of 72 acres, located on the scenic shores of the Bay of Quinte, along the Loyalist Parkway (Hwy #33) in the historic village of Adolphustown.
The park is the site of the original landing of the first group of United Empire Loyalists, under Major Peter Vanalstine, which took place on June 16, 1784. The first loyalists were settled on the grounds in tents, and spent their early days here before moving to their new homes. The UEL Heritage Centre and Park is dedicated to the preservation of this important location, which included the first Loyalist Cemetery, established in 1784, and the oldest monument to the Loyalists in Canada, erected in 1884 for the Loyalist Centennial Celebrations.
The park was established as a family campground and day-use facility by the Province of Ontario in 1956 and has served as such since that time. Some of our visiting families have been coming to this spot for generations. Campsites are available for overnight, weekly, or seasonal use. Our beach and day-use area is ideally suited for family picnics and outings, as well as for larger groups, such as family reunions or church picnics.
For those interested in history, we have a museum dedicated to the Loyalists and early Ontario history, as well as a large library research room. From time to time we host encampments by re-enactment groups to bring history to life on our grounds.
The UEL Heritage Centre & Park is owned and operated by the Bay of Quinte Branch of the United Empire Loyalists Association of Canada.
We are pleased to offer FAMILY CAMPING SINCE 1784!
We look forward to your visit.


text:
Ever want to frame or use a graphic in a special way but also wanted the option to change it out later? If so I think you are going to love this. Recently a client asked if we could create a store graphic that was easy for the store folks to update without adhesives or outside labor. Ordinarily we would think in terms of peel and stick graphics but when the sizes are large they can intimidating to put up. I am excited to announce our partnership Visual Magnetics for just this kind of thing.
It is a simple layered system that consists of a magnetic base and a digitally printed graphic that automatically attaches to the base. Since the graphic is magnetic there is no liner to remove, no worry about air bubbles, wrinkles or spoilage. Just take the graphic we provide and stick it on the base. How cool is that? What makes this really unique is you can affix the magnetic base to virtually any flat surface such as a custom wooden frame, retail fixtures, walls, metals, you name it. The graphic is then printed on a special media that attracts to the base. The graphic is not a magnet but instead it is a thin flexible print substrate that can be used with up to three layers. The ability to create a layered graphic is what really separates this from everything else. The print media is super thin so when you place the layered graphic you have to look super close to even notice it is a layer and not part of the original image.
This can be perfect for use in retail, office and even in-home decor. The versatility of this type of graphic makes it a perfect choice for writable surfaces, changeable menu boards, and flexible merchandising. With magnetic receptive graphics you can create professional decor with bold graphics that can be easily changed to reflect a mood or season. It is specially suited for retail, foodservice, trade show, event and educational environments with frequently changing messages and promotions. Now you have a way to provide simple cost-effective solutions for displays that are easy to use, quickly and easily changeable or re-positioned, reusable and extremely durable. Examples of applications include P.O.P. Displays, Full Wall Graphics Menu Boards, Message Boards, Exhibit Booths, Craft Displays, Retail Graphics and Instruction Boards.
You can see pricing for a sampling of a few common kit sizes here and here.


text:
It's been way too long since our last window shopping adventure. As most of you know, these aren't paid or perked or anything – we just walk through a store with a camera and take pics of whatever inspires us for you guys. This post is actually a few months overdue (woops) but now that I've uploaded the pics and sat down to write this post I'm all school-girl-ish again. See, I actually stepped foot into my first Jonathan Adler store ever a few months back (while we were in DC for a signing up the street) and I was OBSESSED.
Believe me, it's not a good look. I get all squealy and grinny and I probably look like I'm one minute away from rubbing my face on everything. But the employees were very nice and nobody escorted me out, so I consider it a win. Here's what was there to greet me when I casually sauntered in bounced my way around the store like a female non-tiger version of Tigger.
Pretty colors, right?
I loved every last mug design. Can't you picture a collection of these stacked on an open shelf in someone's kitchen? Heck a few of them even make for some awesome wall-stenciling inspiration.
And the lights.
Don't get me started on the lights.
They were amazing. And of course since I was trying to play it cool I didn't ask someone how much they were but my guess would be a million dollars each because they were that pretty. Probably overshot that a little (I'm a bad guesser) but as far as 100% free inspiration goes, this store was packed with it. And that, my friends, is why I love Mr. Adler.
Sidenote: if you guys haven't read his books, I highly recommend them all. He's real, hilarious, and inspirational. In fact this quote from his latest book (100 Ways To Happy Chic Your Life) was so awesome that I instagramed it a few months back…
Oh and speaking of loving what you love and all things happy-chic, how much fun are those two yellow and white ottomans? I petted them. I couldn't help myself.
This pillow even had John laughing. Gotta love a pillow with a sense of humor (remember this old Joan Crawford quote from Mommie Dearest?).
Couldn't you picture an entire kids room designed around one of these needlepoint map pillows? I'd do soft blue walls with pops of the brighter blue (from the pillow) in a ton of accessories along with hits of green and orange. And maybe a glossy yellow rocker? Me-ow.
This purty chair was sort of the cousin to our office chairs. So much happy, you just wanted to park your buns in it all day. The funniest thing is that a few years ago when we were in our super neutral phase of decorating (see our first house) I never would have described J-Ad as my style, but after having Clara and moving into our current place, we're down with all things happy, cheerful, and bright. It's like Sir Jonathan covertly wormed his way into my heart and I didn't even realize how much my preferences had changed until I was walking around his store thinking "yes, yes, yes!" instead of "scared, scared, scared." Haha.
These were my favorite. They were little faux zebra dishes in a few fun colors and I completely regret not buying the green one for my night table (wouldn't it be cute for a pair of earrings or a watch?).
This needlepoint pillow is full of so many colors (yellow, red, teal, navy, gray, black & pink!) but it still felt like it could layer into any room. And I loved the two other pillows with the colored piping that were paired with it. I know some of you out there could DIY your take on those neon-piped pillows, right?
This plate inspired me a lot too. How many old white plates from thrift stores have you seen like this? None with gold, but maybe that could be added with metallic paint or gold leaf. It totally made me want to try my hand at a homemade version.
Here are some other fun ottomans. If money were no object I'd snatch them up for Clara's big girl room. But even though they're not in the budget, they're awesome for inspiration. I love how there's white, pink, and bold red all layered together in a fun ikat-ish way.
Here's another example of sheer inspiration that I snagged while staring dreamily at one of the side tables. See that teal and gold egg? Well they sell wooden eggs like that at craft stores like Michaels for 99 cents each. So you could grab a bunch, spray them metallic gold, let 'em dry, then put some rubber bands around them at random angles and spray them bright teal. When you remove the rubber bands there should be bands of gold that show through just like the guy below.
And that side table was actually a cool white lacquered tray attached to an X base. So if you see any old table bases at a thrift store, painting them and adding a big lacquered tray to the top could be fun, right? You can whip something up like the tray-side-table that we made for our guest room thanks to some 3M command strips.
This was just a corner that I loved. See the art? Sorry about the glare, but it's a giant picture of a bird. Yeah, I'm into it.
Another bird. Because one large bird print is never enough. And I mean that without any hint of sarcasm. Seriously, I want two.
This bed was so cozy looking with the tufted velvet headboard in that pretty platinum color. And I love how they added those bright yellow poufs along with some colorful pillows to keep it from being too neutral.
I thought this wall was really retro and fun with the vintage looking wallpaper paired with the giant feathered wall hanging. And there's that lacquered tray side table again, so you can see the whole thing more clearly here (with a chesty vase on it to boot).
And since Teenage Mutant Ninja Turtles are my thing (Donatello's my favorite because my favorite weapon in karate class was the bo), I could totally get down with this guy on a buffet or a console. It could be my little decorating hero in a half-shell. Turtle power.
The kids section was fun too. How great is that wallpaper? I would totally use that inside of a nook or a closet. I think it came in pink too. And the needlepoint pillow with the giraffes on it? I might have hugged it to my chest while slowly twirling and whispering "this is the best day of my life." I told you I get excited.
Oh Jonathan Adler, I adore you. Let's be best friends and exchange ceramic animals for every holiday.
Hope you guys liked that little virtual window shopping spree. It's fun to duck into a purely-inspirational place every once in a while (we usually traipse through places like Target, World Market, Ikea, thrift stores, and smaller independent shops) but there's definitely truth to the whole "eye-candy is everywhere" sentiment. What stores have you been ogling lately? Are there any projects or updates that are now on the agenda after seeing them in a shop (or even in a restaurant or coffee house)?
PS: Want to hear an interview I did with Jonathan Adler himself! Check out that link for all of the details and the audio recording, or read a transcript here.


text:
Matrix and Vector Entry Extraction
The methods for extracting entries from a Matrix or a Vector are similar.
For both Matrices and Vectors, a selection index, L, is one of an integer, a range of integers, or a list of integers and/or ranges of integers. The integer values in L can be negative.
In the following sections, V is a Vector and A is a Matrix.
Vector Entries
Matrix Entries
Negative Indices
Errors and the Degenerate Case
Extract entries in V by using the command V[L]. The returned object is constructed from the specified selections in the following manner: if L is an integer, the returned object is a scalar; otherwise, it is a vector (even if the range or list provided in L indicates only one entry).
For example, to obtain a subvector consisting of the first, third, and fourth elements of a Vector V, use V[[1, 3, 4]] or V[[1, 3..4]], not V[1, 3, 4].
Extract entries in A by using the command A[L1, L2] where each Li is a selection index, L, as described above. The first index, L1, selects rows from A while the second index, L2, selects columns. The returned object is constructed from the intersection of the selected rows and columns.
If an Li is an integer, the corresponding dimension of the returned object is removed; otherwise, the corresponding dimension of the returned object is retained. For example, the result of A[1..1, 2..3] is a 1 x 2 Matrix, while the result of A[1, 2..3] is a row Vector, and that of A[1, 2] is a scalar.
If an Li is a list, the selected components (rows or columns) are returned in the same order given in Li. For example, A[[ 2, 1], 1..-1] is a new Matrix constructed from row 2 and row 1 of Matrix A, in that order.
In all index specifications, negative indices are interpreted as follows: -1 selects the last row (column) or element, -2 selects the second last row (column) or element, -3 selects the third last row (column) or element, etc. For example, V[2..-1] returns the subvector consisting of all entries of V except the first.
If Li is the range i..j with i=j+1 and 1≤i≤dim+1, where dim is the corresponding dimension value, then the result is degenerate in the corresponding dimension (the dimension value in that component is 0). This is not an error. Otherwise, if Li is either an empty set of indices or it includes indices outside the appropriate dimension range, it is an error.
See Also
LinearAlgebra Package Index
Download Help Document


text:
"Ask The Governor" Tonight At 7PM With Chris Christie
Governor Christie makes his first appearance of 2013 at the New Jersey 101.5 studios for "Ask The Governor."
As usual, the polarizing governor has had no problem dominating state headlines, while causing a stir on the national stage.
In the beginning of the month, Christie unleashed a rant at his own party - namely the House Republicans and Speaker John Boehner for delaying a vote on Sandy aid. The House has since passed the bill, which is expected to move easily through the Senate today.
The spirit of bi-partisanship has slowly waned since the weeks after Sandy. Christie and Democrats have gone back and forth on the issue of the state budget, which is expected to fall way short of projections.
Dems also bashed the Governor's State of the State Address, which focused almost solely on the Sandy rebuilding efforts.
However, outside of State Senator Barbara Buono, all would-be Democratic challengers have shied away from the 2013 Governor's Race. While some possible candidates could still surface, Buono remains the only Christie challenger.
The Governor had two notable accomplishments in January, holding his 100th Town Hall meeting last week in Manahawkin. Christie also made the cover of Time Magazine.
Governor Christie formed a task force last week to delve into the hot-button issue of violence control.
While it did not do much for the unemployment rate, state private sector job growth skyrocketed.
And the much-talked about fleece made its return this past weekend.
- Call 800-283-1015
- Join our live interactive blog below
- Text your question by texting "GOV" to 89000. You will receive a bounce back message asking for your question.
- Twitter: #AskGov
- You can SUBMIT your question for Governor Christie in advance via email.
During the show, there will be a live video stream and interactive blog online.
Check out a recap video below from December's show.


text:
Chaiten in Chile erupting in January 2009. Even after over a year of activity, Eruptions readers are still captivated by the volcano.
Thanks for sending me your questions about volcanoes and volcanism. I'll try to tackle some hear - but as always, keep the questions coming! Send them to
For those of you who have submitted a question but don't see the answer here, do not fret. Likely it just means that I needed to do a little more research into the question and will get to it in a later mailbag!
So, without further ado ...
Mark M.: Here in the Appalachians we have very dense crystalline rock (amongst everything else). I have no doubt in my mind that these mountains had a very explosive past. Is it correct that the more crystalline the igneous rock, the more powerful the eruption?
Erik: The Appalachians (the run up and down the eastern seaboard of North America) do indeed have a long record of magmatism and volcanism in them, so of which dates back over 300 million years. None of it is recent. Heck, none of it is younger than a few hundred million years, but they are there, telling us about volcanism and magmatism during formation of the Appalachians.
As for the crystallinity, the answer to that is "yes and no". If you are looking at a lava, the more crystalline a magma becomes, the more likely it is to erupt explosively, mostly because increasing the crystal content will increase the viscosity (stickiness) of the lava. The stickier the lava is, the more resistant to flow it becomes, and the more likely it will erupt explosive as gases dissolved in the magma try to escape during eruption (i.e., fragmentation). There are some exceptions as viscous lava domes can erupt passively and have high crystal contents, but many of those are from lavas that are already substantially degassed (like the 2004-08 domes at Mt. Saint Helens). So that's the "yes" part. The "no" part is that if the igneous rock cooled underground ("plutonic"), then it will tend to have lots of crystals - in fact, the whole rock should be crystals. This type of rock never erupted, but is, indeed, a crystal-rich igneous rock. Granite is the more familiar example - lots of crystals, but never erupted.
Simon E: What makes Chaiten such a unique eruption, what forces are driving the continuing dome building and what are the chances of major dome collapse leading to possible caldera forming eruption?
Erik: That is a doozy, Simon. The eruption of Chaiten is unique because it is one of the very few rhyolite eruptions that has occurred in the last 300 years (so, since the birth of modern geology). Combined with the fact that it was almost out-of-the-blue and is still going strong after over 14 months, it lands itself in my list of the top 5 eruptions in the last few hundred years. The dome building is being driven by the rhyolite magma under the vent continues to rise and extrude onto the domes. This magma is likely being driven by buoyant forces that work on any magma, things like the dissolved gases, the density difference between the surrounding crust and the magma, the heat of the magma (amongst a myriad of other factor that aren't well understood). Of course, the biggest factor might be that there is still eruptible magma in the system that wants to escape, and kind of getting off a busy bus, people will continue to come out until its empty (or at least until the magmatic system stagnates).
The dome collapses - the type that generate pyroclastic flows like we see at Soufriere Hills - are not likely to generate a "caldera collapse" eruption. However, if you look at the history of some other caldera collapses, there is precedent for large dome-building events that preceded the caldera-forming event. The best example is that of Crater Lake in Oregon, where rhyodacite eruptions of the Llao Rock dome and Cleetwood Cove flows preceded the climatic eruption by tens to hundreds of years. Now, the direct connection between these domes and the climactic eruption is not direct, but all the dome building at Chaiten could (and I stress could) be just the "throat clearing" before a larger event. Or, it could just be the main event, like what happened at the Mono/Inyo domes near Long Valley in California, Glass Mountain in Medicine Lake in California or the Big Obsidian Flow at Newberry Caldera in Oregon - rhyolite domes that didn't lead to a bigger event.
Guillermo E: In the case of Chaitén, after 14 months of continuous eruption, it is still possible that the dome "explode" because of pressure under the dome?
Erik: This follows up on Simon's questions. The threat of an explosion at the new domes at Chaiten is more dependent on a release of pressure rather than increasing pressure. Check out my post of the dome at Redoubt that describes the process of a "dome collapse" explosion. That is the real threat at Chaiten.
Guillermo E: The lahars at Chaiten are only related to ice molten by eruptions or the mudflows of ash by heavy rain are lahars too?
Erik: The line between lahars and mudflows is a little murky. Lahars formed by melting of ice during the eruption are clearing lahars - volcanically generated mass movements with a matrix of water and fine material (i.e., mud). However, you can also remobilize ashy deposits very easily with a heavy rain, and although these flows are not directly attributable to an eruption per se, they are made of dominantly volcanogenic (from the volcano/eruption) material. This was a major problem after the eruption of Mt. Pinatubo in the Philippines in 1991, when the ash from the eruption was remobilized into new flows, causing flooding and more destruction in areas far from the volcano. These flows were also called "lahars". However, the term "mudflow" would apply once the flows had made it far enough downstream where the component of the flow not derived from the volcanic products is greater than that of volcanic products.
Guillermo E: What happened to the earthquakes in Saudi Arabia?
Erik: Thanks to Eruptions readers who have sent me some info, we have some idea: Evacuees have yet to be allowed back to the Al-Ais region where the earthquakes have been centered. Even now they still have been registering earthquakes over M4 as recently as June 23. The source of the seimicity still not clear - it very well could be magma moving below Harrat Lunayyir, but there is still a chance it could be fault and fluid related instead. However, field teams are recording hundreds of earthquakes a day, even now in late June. That leaves the 30,000 evacuee waiting for the Saudi Geological Survey to decide when it might be safe to return.
Wayne C.: What is the story behind the ash and lava that comes spitting out of the volcano? From how deep in the Earth does the lava begin its journey to the surface, and how long does it take it to get there? Â Does the answer depend upon the type of volcano?
Erik: Ah yes, the proverbial $10,000,000 question. Well, questions. A lot of the answers you are seeking, Wayne, are not well constrained when it comes to all volcanoes. In general (and I mean general), most magma comes from the base of the crust or upper mantle, however, that depth can vary from a few kilometers to almost 100 kilometers, depending on the location and tectonic setting. Heck, some magma are sourced hundreds of kilometers below the surface (e.g., kimberlites). So, to pinpoint a specific depth is tough. To add to this, the magma that leaves the source can be very, very different than the magma that erupts at the surface. All sorts of things can happen during its journey. One group of processes that happens in the Andes is called "MASH", which stands for "Melting Assimilation Storage and Homogenization" (Hildreth and Moorbath, 1988). It sounds awfully Borg-like, but what it means is the magmas that are in the lower crust in the Andes experience a process where part of the crust in which they reside melts, assimilates with the magma (i.e., mixes), the magma is stored and crystallizes and during this process, the magmas with homogenize through time. To make a long story short, a lot can happen from the "source" of a magma to an eruption ... and the time it takes to do it is a hotly contest arena in igneous petrology (the study of igneous rocks).
Jodie M.: Do you know of any other streaming video cams aimed at active volcanoes, geysers, etc.?
Erik: How about it Eruptions readers? Got any great webcams of volcanoes we haven't mentioned so far? Post them here!
That is all for now. I'll be doing another mailbag in a few weeks where I will tackle some of the other great questions that you sent. Enjoy the weekend!
- Log in to post comments
More like this
Hi Erik,
Thanks for answering my questions, I know the last part makes me sound like some kind of panic merchant, I was a little curious, I do have a follow up, Generally speaking how long could the dome building phase continue? I know the answer is probably something along the lines of How long is a piece of string.
- Log in to post comments
Simon - Right now, your guess is as good as mine in terms of the duration of dome building at Chaiten. We know it is already in the "years" timeframe, so my guess is it will continue 3-5 years, off and on. That seems to be the idea at some other dome fields (like Mt. Tarawera in New Zealand), so that might be a safe bet.
- Log in to post comments
Wow super quick follow up thank you.
Im quite capitvated by Chaiten, I guess most of us are, as you said it was out of the blue. Would you happen to know how large the eruption is? Im guessing its firmly a VEI 5, curious as to how much has already been erupted, the Dome itself must be 2-3Km3 of material.
- Log in to post comments
Erik, Thank you for the $10,000,000 answer, and for not charging me full price. My grade school science book drew a simple pipe from the mantle to the surface and painted it red. I was pretty sure that the real answer would not be quite so simple, or well known.
I'm fascinated by the volcanoes that didn't make it to the surface, such as plutons like "Half Home", and by "Ship Rock", with its radiating dikes. If you think other readers would be interested, and the subject not too off topic, maybe these would be good topics for future articles.
- Log in to post comments
Amazing story. I am going to want a bit of time to examine the blog.
- Log in to post comments


text:
Plants perennial, sometimes appearing annual; cespitose. Culms 20-80 cm, geniculate to straight, not bulbous based; nodes glabrous. Sheaths glab-rous or pubescent; ligules to 0.8 mm; auricles absent; blades to 15 cm long, to 5 mm wide, scabrous, sometimes hairy. Spikes 3-15 cm, usually nodding, whitish green to light purplish. Glumes 15-85 mm long, conspicuous, bent, divergent to strongly divergent at maturity. Central spikelets: glumes (15)35-85 mm, setaceous throughout, strongly spreading at maturity; lemmas 4-8.5 mm, glabrous, awned, awns 11-90 mm, straight to ascending; paleas 5.5-8 mm; anthers 0.6-1.2 mm. Lateral spikelets staminate or sterile; glumes 17-83 mm, setaceous; lemmas 4-6.5 mm, awned; awns 2-15 mm, divergent; anthers 1-1.5 mm. 2n = 28.
Hordeum jubatum grows in meadows and prairies around riverbeds and seasonal lakes, often in saline habitats, and along roadsides and in other disturbed sites. It is native from eastern Siberia through most of North America to Mexico, growing at elevations of 0-3000 m. It has been introduced to South America, Europe, and central Asia. It is grown in Russia and other areas outside its native range as an ornamental. In its native range, it is a weedy species.
Hordeum jubatum shows a wide range of variation in almost all characters; most such variation is not taxonomically significant. Hordeum jubatum subsp. intermedium is considered to be a subspecies of H. jubatum because no clear-cut discontinuities exist in the characters used to distinguish it from H. jubatum subsp. jubatum. These plants are fertile.
Indiana Coefficient of Conservatism: C = null, non-native
Wetland Indicator Status: FACW
Indiana populations belong to subsp. jubatum.
Deam (1929): The stiff sharp parts of the spike enter the mouths and nostrils of grazing animals causing inflammation and ulceration. Cases are on record where the gums become diseased and the teeth fall out. Land owners should be on the alert and exterminate this grass before it becomes well established. This will require the cooperation of highway and city officials, the mowing of the right of way of railroads, and the vigilance of those in care of public land.


text:
If you have inflammation in your mouth or gums it may be time to consult with a Periodontist. Gum disease is one of the most common disease patients face today. This condition must be treated promptly to avoid receding gums, or even tooth loss. Attending regular visits to our office can help to prevent gum disease and get in front of any issues with your gums or teeth before they become worse. At Silverlake Dental Group, we provide many periodontal treatment services for our patients including scaling and root planing in Los Angeles, CA.
If you have had previous treatment for gum disease, you may have had great results, and your gums have improved or stopped bleeding. Once you have suffered from gum disease, it is important to keep up with your oral hygiene and gum treatments, because gum bleeding and disease can reoccur. Brushing and flossing around the gums carefully at home help continue to keep your teeth and gum free of disease.
How Do I Care for My Gums and Prevent Gum Disease from Returning?
Routine dental cleanings and periodontal treatment help to get rid of plaque and bacteria that cause gum disease to return or get worse. Scaling and root planing is a great technique to remove plaque and tarter, and also helps to smooth out the surface of your gums. This procedure shrinks periodontal pockets to prevent future bacteria from entering the area. Dr. Josh Barkhordar, our dentist in Los Angeles, CA recommend patients come in for their regular dental exams twice a year, and for periodontal treatment at least once a year.
Keeping up with good oral hygiene is the most important part of preventing gum disease. Dr. Barkhordar recommends patients brush twice a day, and floss once a day. If you keep up with your oral hygiene you can reverse gum disease, and never have to deal with painful bleeding gums again. Attending your regular dental exams can help keep an eye on any developing periodontal pockets, and stop gum disease in its tracks.
Staying on top of your general health is also important. This includes avoiding alcohol or smoking, and staying away from sugary drinks. Taking care of both your oral and general health is imperative, to ensure your teeth and gums will last you a lifetime.
Our team at Silverlake Dental Group provides a detailed consultation process to examine your teeth and gums and determine if you can benefit from periodontal treatment. Our creates a customized treatment plan to help restore your gums and teeth and keep any signs of inflammation or gum disease from progressing further.
Looking for Gum Disease Treatment Near You?
Choosing the best option is important, and our team at Silverlake Dental Group is here to help give you all of the options available to achieve that bright white smile. We welcome all patients, and strive to always provide quality service our patients can count on.
If you are interested in finding out more about gum disease treatments in Los Angeles, CA, please contact Dr. Barkhordar to schedule your consultation.


text:
Regular price
After decades of consistently raising the bar on expandable baton design, construction and performance, we've found a way to outdo ourselves. Like our original and proven Talon design, these batons open decisively with a quick upward or downward flick—or quietly, with fingertip extension—and close directly into the scabbard or hand, with a push of the end cap or button. But with the Infinity family, we've reduced moving parts for greater precision, strength and long-term dependability. We've incorporated exclusive materials and construction to ensure faster, smoother deployment and retraction, while eliminating the need for routine lubrication. And we've backed it all up with the unprecedented Infinity Warranty:
If your ASP Talon has the laser-engraved Infinity icon (∞) on its nose cone, we'll repair or replace the baton if it fails for any reason, at any time, forever.
The Infinity family also adds a stunning, extra corrosion-resistant electroless nickel finish option, and an aggressively-textured Vector grip option, so there are more choices than ever. And like all ASP batons, the Talon Infinity series is supported by a full range of scabbards, glass-shattering BreakAway Tips, cap options and other accessories.
ADD A BREAKAWAY TIP AND GET FREE FACTORY INSTALLATION: Our BreakAway Tip turns your Talon Baton into a glass breaking, lifesaving extrication tool. Add one to this order and select the appropriate "Factory Installed" option on the BreakAway product page, and we will pre-install and thread-lock it for you at our Wisconsin factory, so you will receive it ready-to use. This installation service is offered free of charge ($10 value), only when baton and tip are ordered at the same time. Allow 1-2 business days additional turnaround time.
ASP Snapshot - Talon Batons https://youtu.be/ITRHpnStCsoASP Quick Look - Infinity Batons https://youtu.be/-sKktAyQ00wASP Training Room - Selecting Your Baton https://youtu.be/Bc7k1xtgHVgASP Training Room - Talon Baton Opening and Closing https://youtu.be/B5q8Lz7hOCEASP Training Room - Talon Infinity Baton Disc Repair https://youtu.be/12Ppvj-WvioASP Training Room - Talon Baton Lubrication https://youtu.be/VtHaO9WQ8vM -
• Retracted Length: 7.06"• Weight (Steel): 16.3 ounces• Weight (Airweight): 8.8 ounces• 4140 Steel• 7075 T6 aluminum middle shaft (Airweight model only)• Diameter: 1.06" -
Customer Reviews


text:
I know I have a few submissions from 2013 I need to post. Sorry for the delay, I got delayed for too long. But I am going to post them. Just as soon as I finish this post.
I'm getting ready for ASDay 2014. It's on a Saturday this year, and I wanted to let people prepare in advance, to think about what they're going to do.
At the same time, there is something I think that is important that may or may not appeal to participants. But this is really important, important enough that I'm posting this on here and on No Stereotypes Here. I know that ASDay matters to a lot of you because it gathers many voices in a large event, as well as other reasons, but I'd like to take the opportunity to address another opportunity coming up soon that people may want to concentrate working on.
I'm going to have to disclose, of course, as I am Vice-President of the Autism Women's Network. But AWN is working to publish an anthology on Autism and Race, and is looking for submissions, due November 14, 2014. If you are autistic, and a person of colour, racialized, or non-white, I encourage you to look at the AWN submission guide and consider submitting something.
This is a project lead by Lydia Brown, aka Autistic Hoya, who I don't know about you, but is one of the people I'd immediately ask "how much do you want me to write, and when do you want it?" if not go scrambling to look for something I've already written.
But this is your choice. I understand either way.
What matters is you expressing yourself, your story, what you want to say about yourself as an autistic person and your life, what you want to tell other people, what you want to change about the world. This is about you communicating and gaining power through that, about providing an outlet, a starting point.
ASDay has been described as a blogging carnival, a festival of our "voices", our passions and dreams. It is a celebration of who we are, a memorial of our scars, a scream of our struggles, a rallying cry to continue on for our rights. Because of the most powerful words "I am not alone".
Intersectionality is how different aspects of our identities affect our experiences, sometimes in different ways in different situations. Like being a woman can be a privilege in one situation, or be a barrier in another, or being a person of colour, or being disabled, rich or poor, and so on.
The anthology matters because for too long has books and Autism materials about us been dominated by parents, professionals, and white people who do not represent all experiences of autistic people. I see it every time I walk into an Autism conference center and look at the book displays. How can we be "Nothing About Us, Without Us" without all of us being published, without all of us being represented?
It cannot happen.
Not without projects like the Autism and Race anthology.
Either way, I look forward to seeing your work!!


text:
Guest blog
By Steve Cowell
January 5, 2010
As our economy continues to sputter, one little-noticed industry has been booming for a while now: energy efficiency. The sector is hiring like crazy — a fact that speaks volumes about the close relationship between clean energy and the economic recovery that we're all waiting for. Energy efficiency could save us all.
My firm works with utilities, government agencies, housing authorities, and other groups to help increase energy efficiency. We started in 1984 with three employees and one office. Today, we have nearly two dozen offices nationwide and employ 700 staffers from coast to coast. Most strikingly, we've added more than 250 people and 12 offices in just the last two years. The reason is crystal clear: Energy-efficiency services are in great demand. We are continuing to expand rapidly as more groups turn to us for help.
But energy-services firms are not the only ones that can benefit from the demand for energy-efficiency services. With the right programs in place, reducing power consumption can improve the bottom line for many other types of companies. Case in point: The building infrastructure in this country is old and inefficient. Retrofitting these buildings requires an army of workers. These include heating/air conditioning installers, insulators, and building inspectors. Many of these trades people are out of work and these retrofitting jobs can get them back on their feet. Products like insulation, caulk, triple-paned windows and doors, and high-efficiency heating and cooling systems will also get a boost. And that's not all. The goods need to be made, inspected, shipped, and sold, widening the circle of employment opportunities for manufacturers, retailers, and distributors. This expanded workforce means people will have more money to spend.
Now that's what I call a "trickle down economy"!
Most importantly, jobs created to support energy efficiency are America's jobs. More than 90 percent of products and 100 percent of the labor used in residential energy work are American. If Home Star becomes law, weatherization products and equipment will fly off store shelves faster than you can say "retrofit." Most of these supplies are made domestically, so our factories will need to step up production. Home Star is expected to increase demand for retrofitting by a factor of 15, benefiting those hardest hit by this recession — manufacturing and construction workers. An estimated 168,000 jobs would be generated to carry out the program. Consumers who take advantage of Home Star would save our country an estimated $10 billion in energy costs by 2020. The program would jolt our economy by pumping in $6 billion over two years and cut down on carbon emissions. Supported by Republicans and Democrats, environmentalists and businesses, the bill was introduced exactly one year ago. Home Star has been stalled in the U.S. Senate for months after having passed the House last May. We hope the new Congress will put Home Star on the front burner.
New economic analysis shows that clean energy legislation will create up to 1.9 million new jobs, increase annual household income by up to $1,175, and boost the GDP by up to $111 billion. Over the years, study after study, from groups like the Center for American Progress and the American Council for an Energy-Efficient Economy, have supported the direct correlation between green industry growth and jobs. Eighteen months ago, findings from a study by the Pew Charitable Trust found that green jobs are growing at a national rate of 9.1 percent, while traditional jobs are growing by only 3.7 percent.
As someone who's been working in the industry for more than 30 years, I'm not surprised at all. Clean energy is job creation, hands down. Our time has come!
So what are we waiting for?
Stephen L. Cowell is chairman and chief executive officer of Conservation Services Group, based in Westborough, Mass. Mr. Cowell also co-founded Efficiency First, the Home Star Coalition and serves as president of the Northeast Energy Efficiency Council.


text:
Two weeks until A90 average speed cameras go live
A90 speed cameras will improve safety
The A90 Average Speed Camera (ASC) system between Dundee and Stonehaven will go live on 31 October.
ASCs aim to deter vehicles driving at excessive speeds, even out traffic flows, improve journey times and reduce offender numbers. The evidence from previously implemented systems across Scotland show that they reduce the number of people killed or seriously injured on the road.
With construction underway since May 2017, the system contains 30 sites across the 51.5 mile stretch of the A90 between Dundee and Stonehaven. Cameras are located 5-7km apart, with 15 cameras operating in each direction. The system has cost approximately £2m, which includes the design process, engineering and installation.
Transport Minister, Humza Yousaf said:
"We know that the A90 trunk road has the highest collision rates in Scotland. More than three in every five vehicles travelling between Dundee and Stonehaven are speeding. This system will help reduce that rate and save lives.
"The positive impact average speed camera systems have in improving road safety has been evidenced from other areas in Scotland. We remain committed through Scotland's Road Safety Framework to 2020 to making our roads safer, and we are working towards an ultimate vision of zero fatalities and reduced number of serious injuries on our roads."
"If you use the A90, remember that the average speed cameras will be activated on 31 October. Mobile enforcement will continue until then."
There is a problem
Thanks for your feedback


text:
Viewing entries tagged with 'rod hutchinson'
Natural ingredient bottom baits - Still catching in scorching conditions
I hadn't planned it this way at all but my last five sessions have been on totally different waters and all have been a great success in these awful carp catching weather conditions we have been enduring. With temperatures soaring, the carp have been no-where near the bottom where my baits have laid for much of any day. Now don't get me wrong, I used to love surface fishing, but these days the gulls simply drive me mad. They never used to be an issue during the 80's but now nature has changed tenfold and continues to do so with man's interference thinking they can just release a few of these and a few of those and continue to net tons of fish at sea with no changes.


text:
In this collection, you will find an abundance of resources that may appeal to elementary school teachers, school psychologists, principals, nurses, school librarians, and other administrators. You will also find publications that may appeal to middle school and high school teachers, guidance counselors, principals, district administrators, school nurses, and more.
Attn: Value Shoppers! Shop our overstock sale focusing on emergency response publications. Reduced prices reflect a 50% discount on all books featured in this collection. Quantities are limited, so take advantage of this special offer today. New titles may be added to this list, so be sure to check back often!
Are you looking for official information about America's policy on the topic of Energy & Fuels? In this official collection, you will find resoruces ranging from energy policy documents to include nuclear energy with resources about Three Mile Island, critical infrastructure planning in Latin America, Nuclear Regulatory Commission Information Digests, and print subscription, global oil market, nuclear power, oil spill reports, gas consumption and utilities, annual references relating to energy outlook, and regulations and procedures relating within 10 CFR Energy


text:
For Day 3, Week 1, BM #34, I had a brain storming session with my friends and was given a suggestion to make chaat with banana. Though they gave me the rough idea of what goes into it, I googled and found some interesting ingredients.
Traditionally, Chaat in the Indian sense, has a protein and carbohydrate component. In this, there are chickpeas and fruits and the spices marry very well with them to give a fantastic kick to the taste buds!
I was also thinking that a sprinkling of green chutney, tamarind-date chutney, beaten yogurt and sev would take it a notch higher. The older one wasn't ready to give up this taste for anything!
My older one virtually fell in love. Though it was a little spicy for her, she loved the spicy flavor and then the bite of banana and pom in every other bite. She gave up saying that I finally made her eat 'banana', her nemesis, so to say. :)
I was a little skeptical about the dad liking it but he had no problems finishing his bowl. :)
Recipe Source - Here
Ingredients -
Cooking Oil 1 Tbsp
Ginger, grated 1/2 tsp
Garlic grated 1/2 tsp
Green Chillies, finely chopped 1 tsp
Coriander Powder 1 tsp
Chaat Masala 1 tsp
Tamarind paste (Thick) 2 tsp
Water 1/4 cup
Chickpeas/Garbanzo Beans, soaked, drained and boiled 1 cup
Salt as needed
Banana, finely chopped 1 cup (1 medium size banana)
Pomegranate seeds handful
Spring Onions, finely chopped 1 Tbsp
Cucumber, finely chopped 1/2 cup
Coriander leaves, finely chopped or garnish (I skipped it)
Method Of Preparation -
In a heated pan, add oil and saute the ginger, garlic and green chillies for about 30 min.
Add in the Coriander powder and chaat masala.
Add the tamarind paste and pour in the water and mix well. Sprinkle salt and the boiled chickpeas as well.
Mix well and let the mixture become dry. Remove from fire and set aside to cool.
Upon cooling toss in the chopped spring onions, cucumber, banana and pomegranate seeds.
Sprinkle some chaat masala and garnish with coriander leaevs for a filling salad!
Check out the Blogging Marathon page for the other Blogging Marathoners doing BM# 34.
Preparation Time 20 min
Serves 2


text:
Faith Fellowship began with a simple idea…
Take the age-old truths of the Bible and present them through engaging messages, striking visuals, and great music. Moreover, we are authentic and passionate about presenting Christ in a way that is new and refreshing. The leaders of Faith Fellowship are intentional about creating an atmosphere that takes the stress out of going to church. Whether you have never been to church, been away for a while, or have attended your entire life, Faith Fellowship feels immediately comfortable. From the moment you pull into the parking lot, we will make you feel at home. Parking volunteers will help you find a place, and they are available to assist you in getting inside if needed.
Faith Fellowship is barely into the second decade of living out our mission: to lead people into a growing relationship with Jesus Christ. Come and see why so many people are making Faith Fellowship a part of their lives.
You will experience worship at Faith Fellowship in a casual, intuitive, high-tech atmosphere with today's culture in mind. The weekend service is creative, contemporary, and compelling with only one intent–to present the message of Jesus Christ in a way that is relevant and alive. The high-energy, cutting-edge worship, drama, and multimedia presentations highlight the worship experience. Pastor Dr. Daymond Talkington uses a no-holds-barred communication style in applying God's Word to life's complexities. This isn't church as you have known it; it is energetic, captivating, and never boring.
The band is styled after the timeless rock and roll lineup, complete with electric and acoustic guitars, bass, drums, and keyboard. The sounds you hear on your favorite radio stations can also be heard at Faith Fellowship–rock, soul, jazz, and blues. The band rivals any in the area (Christian or secular).
If you have children, rest assured that they will be in the best possible care. All members of the Children's Ministry Team undergo a criminal and civil background check to ensure complete safety. While parents are experiencing the creative, life-changing weekend service, children are participating in their own high-energy encounter in the new Kids Zone Building. They won't want to go home!
Worship This Week
Message This Week
Regular Rotation Songs @ Faith Fellowship


text:
The Greenfingers 1000W electronic ballast is suitable for use with both 1000W High Pressure Sodium (HPS) and Metal Halide (MH) bulbs. It has a 4-phase manual dimming that can help to prolong the lamp lifespan by at least 10% with up to 30% energy savings compared with magnetic ballasts. It also features several protective functions including short circuit, circuit, overheat and lamp failure protection. The bat wing reflector spreads and directs the light in a downward focus to cover small to medium-sized plant growth areas. The compatible wattage HPS grow bulb can be used outdoors or indoors and as a thick glass housing for extra durability, enhanced wavelengths and lumen output power. The bulb is ideal for blooming and flowering and mainly produces a red spectrum that is perfect for germinating, flowering, and fruiting stages. Likewise the MH grow bulb is also ideal for blooming and growing stages and produces a blue spectrum that is perfect for all plant growth. The grow light can be hung in vertical or horizontal positions. The lamp does not flicker and works quietly and effectively. A pair of reflector yoyos is included to secure the reflector quickly and easily. The yoyos are made of a special composite material that is rust-resistant and heat and cold-resistant.
Dimmable electronic ballast
Suitable for HPS and MH bulbs
4 Dimmable levels
Prolong lamp life span at least 10% and energy saving up to 30% compared with magnetic ballast
Protection function: short-circuit protection, circuit protection, overheat protection and lamp failure protection
Good regulation against supply voltage variation
Constant wattage output if the supply voltage varies
Quiet operation
Elimination lamp flickering
Input frequency: 50-60 Hz
Input voltage: 120-240 Vac
Output frequency: greater than 30 KHz
Output power: 1000W
Power factor: greater than 0.99
Matching wattage HPS grow bulb: 2100k
Matching wattage MH grow bulb: 4000-6400k daylight
Dimmable: 4 phase manual dimming: 600w, 750w, 1000w, super lumens
Maximum lighting distance: 15 meters
Usage temperature: -40 to 55°C, with built-in thermal protection device fitted to 105°C and restarting at 55°C
Assembly Required:Yes
Pls note:This item comes in 1 package
Package Content:
1 x Wing reflector
1 x 1000W HPS Grow Light Lamp
1 x 1000W MH Grow Light Lamp
1 x Dimmable Electronic Ballast
1 x Rope Ratchet


text:
BIRMINGHAM, Ala. (AP) — Joran van der Sloot, the chief suspect in Natalee Holloway's 2005 disappearance, pleaded not guilty Friday in Alabama to charges he tried to extort money from the missing teen's mother in exchange for revealing where to find her daughter's remains.
Although he's not on trial for harming Holloway, the extortion and wire fraud charges are the only alleged crimes that link the Dutch citizen to Holloway's unsolved disappearance on the Caribbean island of Aruba. The 18-year-old went missing during a high school graduation trip with classmates and was last seen leaving a bar with van der Sloot, a student at an international school on the island where he grew up.
Van der Sloot, now 35, walked shackled into the Alabama courtroom Friday as Holloway's parents looked on. He'd been extradited Thursday from Peru, where he's serving a 28-year sentence after confessing to killing a Peruvian woman in 2010 — five years to the day after Holloway went missing.
Natalee's mother, father and brother were in the courtroom Friday. Beth Holloway stared occasionally at van der Sloot but otherwise showed no obvious emotion.
"The wheels of justice have finally begun to turn for our family," she wrote in a statement. "It has been a very long and painful journey."
Van der Sloot, wearing jeans and a white T-shirt, declined to use a Dutch interpreter offered to him, saying "I don't think it's necessary." During the brief court preceding, he entered a not guilty plea through his attorney and answered "Yes" when asked if he understood his rights.
Afterward, Beth Holloway hugged friends who had come to offer support. She declined to comment outside the courthouse.
Her spokesperson, George Seymore, told reporters that seeing van der Sloot in court "was chilling but at the same time gratifying."
The mysterious disappearance sparked years of news coverage and countless true-crime podcasts. Van der Sloot was identified as a main suspect and was detained for questioning along with two Surinamese brothers, weeks after Holloway went missing. No charges were filed in the case.
A judge declared Holloway dead, but her body has never been found.
U.S. prosecutors say that in 2010, van der Sloot sought money from Beth Holloway to lead her to the young woman's body. A grand jury indicted him that year.
In 2012, van der Sloot pleaded guilty in Peru to killing 21-year-old Stephany Flores, a business student from a prominent family, in 2010.
Van der Sloot married a Peruvian woman in July 2014 in a ceremony at a maximum-security prison. He was shuffled between prisons in response to reports he enjoyed privileges like television, internet access and a cellphone, and accusations he threatened to kill a warden.
Peru will let van der Sloot remain in U.S. custody until the Alabama case is concluded, including any appeal if he's convicted, according to a resolution published in Peru's federal register. U.S. authorities agreed to return him to Peruvian custody after that, the resolution states.
Cindy Rysedorph, a friend of the Holloways, said the family is doing as well as can be expected.
"It's progress," she said. "I'm so grateful that he's here."
Source: Yahoo


text:
Armorlite Expands Product Line to Include Complete Floor Replacement Kit for Jeep Wrangler JK 2-Door
Southfield, Mich. – (November 12, 2020) – Armorlite – a complete replacement flooring system for the off-road vehicle market – has expanded its product line to include a full kit replacement system for Jeep Wrangler JK 2-door models. The new kit is available for pre-order at www.goarmorlite.com beginning November 12, 2020 and ending December 12, 2020.
Launched in January of this year for Jeep Wrangler JKU 4-door models, Armorlite goes where throw‑in mats and spray-in liners can't, providing an entirely new level of durability, style and performance in a complete replacement flooring system. It is easy to install, easy to clean, enables easy draining of the floor area, provides sure footing and substantially reduces cabin heat and noise.
"Armorlite is unlike anything else available in the off-road aftermarket and we are working diligently to make it available for as many vehicles as possible," said David Ladd, senior director, Auria Aftermarket, LLC. "The 2-door JK has long been in the pipeline, but shortly after launch of the 4-door JK model, we received numerous requests for it, so we moved it ahead in the schedule."
The new JK 2-door full vehicle kit will be available in two colors – Mesa Smoke, the original matte black, along with the new Desert Khaki, which pays homage to the original Willy's and the heritage of the early Jeep vehicles.
Armorlite is built with three unique layers. The first is a proprietary marine grade topcoat that provides grip, exceptional durability and water protection. The second layer provides structure and enables a perfect factory fit, while the third is a polyester insulating layer that provides substantial noise and heat reduction, while also preventing mold and mildew for instances when water finds its way in.
The new 2-door JK full kit will be priced at $729.00 and will include:
- Front floor replacement
- Rear floor and cargo area replacement
- 4 drain plugs
Customers who have already purchased the front flooring for their 2-door JK Jeep Wrangler, will now have the option to purchase a standalone set for the rear seat and cargo area. The rear set costs $388.00 and previous purchase of fronts will be verified to receive the discounted rate.
The pre-order program – accessible only via the Armorlite website (www.goarmorlite.com) – runs from November 12, 2020 until December 12, 2020. Armorlite only ships to addresses (excluded P.O. Boxes) within the 48 contiguous United States.
Product ordered during the pre-sale will be expected to ship during the week of December 14th, 2020, but could be shipped sooner if inventory allows. Refund requests will be accepted if requested by December 14, 2020 8:00am ET or before shipping, whichever comes first. After December 14, all orders will fall under the official Armorlite return policy. Return policy details found here.
Free standard ground shipping will be available only within the 48 contiguous United States. Customers who order during the pre-sale are eligible to take advantage of the discount listed on the website at the time of purchase.
Armorlite is a product of Auria Aftermarket, LLC. Auria (www.auriasolutions.com) – is a global Tier-1 supplier of automotive flooring, acoustics and fiber-based systems with more than a century of automotive flooring expertise. Many of Auria's interior and flooring products date back to the Ford Model T and can be found today in nameplates including Rolls Royce, Jaguar, Land Rover, BMW, Mercedes-Benz, Porsche, Ford, GM and FCA, RAM and Jeep.


text:
What methods of transport does China Southern Airlines provide for my pet?
China Southern Airlines does not allow animals in the cabin except guide dogs. However, China Southern Airlines allows registered pets to be shipped as cargo in a pressurized and temperature controlled area.
Does my pet qualify to be shipped as cargo?
In order to ship a pet as cargo, the following criteria must be met:
- You have to sign an agreement for undertaking the risk of animal death.
- The pet must be provided with effective health certificate and proof of rabies immunization, as well as the documents required in small animal transportation of countries along the way.
If you would like your pet to travel unaccompanied or have any questions regarding the transportation of pets, contact China Southern Airlines for more information.
What are the fees associated with pet transport?
Small animals will be charged as common overweight baggage. The small animal's container can not be counted into the baggage allowance.
As to the flight courses applying piece concept, the animal will be charged twice the rate of common overweight baggage.
Dogs trained to help the blind, mute, or deaf can be counted into the baggage allowance.
Transportation of small pets is not available for issuing the declared value.
What are the kennel requirements?
In addition to the size and weight maximums, the USDA and China Southern Airlines may require that kennels meet the following requirements:
- Be leak-proof and escape-proof.
- Be properly ventilated, but not allow any part of the animal from protruding outside of the container.
- Provide enough room for the animal to stand and turn around.
- Be made of metal, wood, or a hard plastic/composite.
- Contain absorbent material or litter.
- Have functional handles on the kennel's exterior to prevent tilting and any direct contact with the animals.
- Be closed securely, but not locked.
- Have labels with the words "Live Animal" in letters at least 1-inch tall on the crate's top and on at least one side.
- Have upright arrow labels indicating kennel's correct position.
What health documentation is required?
China Southern Airlines requires that the pet must have a health certificate, proof of rabies immunization, quarantine certificates, and if the pet is being taken abroad, animal import license and transfer license. Some States and Countries require additional health documents. As it is the passenger's responsibility to be aware of all regulations, you should consult your veterinarian and the Department of Agriculture to ensure that your animal will comply with all requirements.
Are there any other restrictions?
China Southern Airlines can refuse to transport an animal due to illness, aggressive behavior, poor kenneling, or extreme temperatures at origin, transfer, or destination airports.
For additional details and information on transporting your pet, please phone China Southern Airlines at 020-8613-8533.


text:
To be interchangable and testable, normally services with logic needs to have interface, e.g.
public class FooService: IFooService
{ ... }
Design-wise, I agree with this, but one of the things that bothers me with this approach is that for one service you will need to declare two things (the class and the interface), and in our team, normally two files (one for the class and one for the interface). Another discomfort is the difficulty in navigation because using "Go to definition" in IDE (VS2010) will point to the interface (since other classes refer to the interface), not the actual class.
I was thinking that writing IFooService in the same file as FooService will reduce the above weirdness. After all, IFooService and FooService are very related. Is this a good practice? Is there a good reason that IFooService must be located in its own file?


text:
Schwa Z, 2015
Exhibition at Galerie der Stadt Schwaz
Heinrich Dunst
Heinrich Dunst was born in 1955 in Hallein (Salzburg, Austria), He lives and works in Vienna. Dunst creates spatial interventions and performances that navigate the gap between what can be seen and what can be said, the untranslatability of one form into another, and the contextual nature of spatial presentations. Dunst's conceptual approach is rooted both in the work of artists like Marcel Broodthaers who scrutinize the systems underlying the perception of words and images, and in the Viennese scene of the 1980s and its characteristic ambition to extend abstract painting into the exhibition space. He lends these complex issues fresh interest by developing forms into correlations and pointedly questioning the seemingly unequivocal meaning of the elements through variation, superimposition, and changes of direction. Solo exhibitions include Halle für Kunst Steiermark, Graz (2023), Galerie der Stadt Schwaz (2015), Museum für angewandte Kunst, Vienna (1997) among others. His work has been included in group shows at Kestnergesellschaft, Hannover (2023), Belvedere 21, Vienna (2021), Neuer Kunstverein Wien, Vienna (2020), Halle für Kunst und Medien, Graz (2016), Ludwig Forum Aachen (2015) and many more.
- Anna Boghiguian
- Candice Breitz
- Marco A. Castillo
- Alice Creischer
- Chto Delat
- Clegg & Guttmann
- Eugenio Dittborn
- Heinrich Dunst
- Anna Ehrenstein
- Estate of León Ferrari
- Peter Friedl
- Sophie Gogl
- Estate of Barbara Hammer
- The Cabinet of Ramon Haze
- Hiwa K
- Simon Lehner
- Renzo Martens
- Chris Martin
- Frédéric Moser & Philippe Schwinger
- Oswald Oberhuber
- Mario Pfeifer
- Dierk Schmidt
- Tina Schulz
- Santiago Sierra
- Michael E. Smith
- Franz Erhard Walther
- Clemens von Wedemeyer
- Tobias Zielony


text:
1. What is DBMS?
A Database Management System (DBMS) is a program that controls creation, maintenance and use of a database. DBMS can be termed as File Manager that manages data in a database rather than saving it in file systems.
2. What is RDBMS?
RDBMS stands for Relational Database Management System. RDBMS store the data into the collection of tables, which is related by common fields between the columns of the table. It also provides relational operators to manipulate the data stored into the tables.
Example: SQL Server.
3. What is SQL?
SQL stands for Structured Query Language , and it is used to communicate with the Database. This is a standard language used to perform tasks such as retrieval, updation, insertion and deletion of data from a database.
Standard SQL Commands are Select.
4. What is a Database?
Database is nothing but an organized form of data for easy access, storing, retrieval and managing of data. This is also known as structured form of data which can be accessed in many ways.
Example: School Management Database, Bank Management Database.
5. What are tables and Fields?
A table is a set of data that are organized in a model with Columns and Rows. Columns can be categorized as vertical, and Rows are horizontal. A table has specified number of column called fields but can have any number of rows which is called record.
Table: Employee.
Field: Emp ID, Emp Name, Date of Birth.
Data: 201456, David, 11/15/1960.
6. What is a primary key?
A primary key is a combination of fields which uniquely specify a row. This is a special kind of unique key, and it has implicit NOT NULL constraint. It means, Primary key values cannot be NULL.
7. What is a unique key?
A Unique key constraint uniquely identified each record in the database. This provides uniqueness for the column or set of columns.
A Primary key constraint has automatic unique constraint defined on it. But not, in the case of Unique Key.
There can be many unique constraint defined per table, but only one Primary key constraint defined per table.
8. What is a foreign key?
A foreign key is one table which can be related to the primary key of another table. Relationship needs to be created between two tables by referencing foreign key with the primary key of another table.
9. What is a join?
This is a keyword used to query data from more tables based on the relationship between the fields of the tables. Keys play a major role when JOINs are used.
10. What are the types of join and explain each?
There are various types of join which can be used to retrieve data and it depends on the relationship between tables.
- Inner Join.
Inner join return rows when there is at least one match of rows between the tables.
- Right Join.
Right join return rows which are common between the tables and all rows of Right hand side table. Simply, it returns all the rows from the right hand side table even though there are no matches in the left hand side table.
- Left Join.
Left join return rows which are common between the tables and all rows of Left hand side table. Simply, it returns all the rows from Left hand side table even though there are no matches in the Right hand side table.
- Full Join.
Full join return rows when there are matching rows in any one of the tables. This means, it returns all the rows from the left hand side table and all the rows from the right hand side table.
11. What is normalization?
Normalization is the process of minimizing redundancy and dependency by organizing fields and table of a database. The main aim of Normalization is to add, delete or modify field that can be made in a single table.
12. What is Denormalization.
DeNormalization is a technique used to access the data from higher to lower normal forms of database. It is also process of introducing redundancy into a table by incorporating data from the related tables.
13. What are all the different normalizations?
The normal forms can be divided into 5 forms, and they are explained below -.
- First Normal Form (1NF):.
This should remove all the duplicate columns from the table. Creation of tables for the related data and identification of unique columns.
- Second Normal Form (2NF):.
Meeting all requirements of the first normal form. Placing the subsets of data in separate tables and Creation of relationships between the tables using primary keys.
- Third Normal Form (3NF):.
This should meet all requirements of 2NF. Removing the columns which are not dependent on primary key constraints.
- Fourth Normal Form (4NF):.
Meeting all the requirements of third normal form and it should not have multi- valued dependencies.
14. What is a View?
A view is a virtual table which consists of a subset of data contained in a table. Views are not virtually present, and it takes less space to store. View can have data of one or more tables combined, and it is depending on the relationship.
15. What is an Index?
An index is performance tuning method of allowing faster retrieval of records from the table. An index creates an entry for each value and it will be faster to retrieve data.
16. What are all the different types of indexes?
There are three types of indexes -.
- Unique Index.
This indexing does not allow the field to have duplicate values if the column is unique indexed. Unique index can be applied automatically when primary key is defined.
- Clustered Index.
This type of index reorders the physical order of the table and search based on the key values. Each table can have only one clustered index.
- NonClustered Index.
NonClustered Index does not alter the physical order of the table and maintains logical order of data. Each table can have 999 nonclustered indexes.
17. What is a Cursor?
A database Cursor is a control which enables traversal over the rows or records in the table. This can be viewed as a pointer to one row in a set of rows. Cursor is very much useful for traversing such as retrieval, addition and removal of database records.
18. What is a relationship and what are they?
Database Relationship is defined as the connection between the tables in a database. There are various data basing relationships, and they are as follows:.
- One to One Relationship.
- One to Many Relationship.
- Many to One Relationship.
- Self-Referencing Relationship.
19. What is a query?
A DB query is a code written in order to get the information back from the database. Query can be designed in such a way that it matched with our expectation of the result set. Simply, a question to the Database.
20. What is subquery?
A subquery is a query within another query. The outer query is called as main query, and inner query is called subquery. SubQuery is always executed first, and the result of subquery is passed on to the main query.
21. What are the types of subquery?
There are two types of subquery – Correlated and Non-Correlated.
A correlated subquery cannot be considered as independent query, but it can refer the column in a table listed in the FROM the list of the main query.
A Non-Correlated sub query can be considered as independent query and the output of subquery are substituted in the main query.
22. What is a stored procedure?
Stored Procedure is a function consists of many SQL statement to access the database system. Several SQL statements are consolidated into a stored procedure and execute them whenever and wherever required.
23. What is a trigger?
A DB trigger is a code or programs that automatically execute with response to some event on a table or view in a database. Mainly, trigger helps to maintain the integrity of the database.
Example: When a new student is added to the student database, new records should be created in the related tables like Exam, Score and Attendance tables.
24. What is the difference between DELETE and TRUNCATE commands?
DELETE command is used to remove rows from the table, and WHERE clause can be used for conditional set of parameters. Commit and Rollback can be performed after delete statement.
TRUNCATE removes all rows from the table. Truncate operation cannot be rolled back.
25. What are local and global variables and their differences?
Local variables are the variables which can be used or exist inside the function. They are not known to the other functions and those variables cannot be referred or used. Variables can be created whenever that function is called.
Global variables are the variables which can be used or exist throughout the program. Same variable declared in global cannot be used in functions. Global variables cannot be created whenever that function is called.
26. What is a constraint?
Constraint can be used to specify the limit on the data type of table. Constraint can be specified while creating or altering the table statement. Sample of constraint are.
27. What is data Integrity?
Data Integrity defines the accuracy and consistency of data stored in a database. It can also define integrity constraints to enforce business rules on the data when it is entered into the application or database.
28. What is Auto Increment?
Auto increment keyword allows the user to create a unique number to be generated when a new record is inserted into the table. AUTO INCREMENT keyword can be used in Oracle and IDENTITY keyword can be used in SQL SERVER.
Mostly this keyword can be used whenever PRIMARY KEY is used.
29. What is the difference between Cluster and Non-Cluster Index?
Clustered index is used for easy retrieval of data from the database by altering the way that the records are stored. Database sorts out rows by the column which is set to be clustered index.
A nonclustered index does not alter the way it was stored but creates a complete separate object within the table. It point back to the original table rows after searching.
30. What is Datawarehouse?
Datawarehouse is a central repository of data from multiple sources of information. Those data are consolidated, transformed and made available for the mining and online processing. Warehouse data have a subset of data called Data Marts.
31. What is Self-Join?
Self-join is set to be query used to compare to itself. This is used to compare values in a column with other values in the same column in the same table. ALIAS ES can be used for the same table comparison.
32. What is Cross-Join?
Cross join defines as Cartesian product where number of rows in the first table multiplied by number of rows in the second table. If suppose, WHERE clause is used in cross join then the query will work like an INNER JOIN.
33. What is user defined functions?
User defined functions are the functions written to use that logic whenever required. It is not necessary to write the same logic several times. Instead, function can be called or executed whenever needed.
34. What are all types of user defined functions?
Three types of user defined functions are.
- Scalar Functions.
- Inline Table valued functions.
- Multi statement valued functions.
Scalar returns unit, variant defined the return clause. Other two types return table as a return.
35. What is collation?
Collation is defined as set of rules that determine how character data can be sorted and compared. This can be used to compare A and, other language characters and also depends on the width of the characters.
ASCII value can be used to compare these character data.
36. What are all different types of collation sensitivity?
Following are different types of collation sensitivity -.
- Case Sensitivity – A and a and B and b.
- Accent Sensitivity.
- Kana Sensitivity – Japanese Kana characters.
- Width Sensitivity – Single byte character and double byte character.
37. Advantages and Disadvantages of Stored Procedure?
Stored procedure can be used as a modular programming – means create once, store and call for several times whenever required. This supports faster execution instead of executing multiple queries. This reduces network traffic and provides better security to the data.
Disadvantage is that it can be executed only in the Database and utilizes more memory in the database server.
38. What is Online Transaction Processing (OLTP)?
Online Transaction Processing (OLTP) manages transaction based applications which can be used for data entry, data retrieval and data processing. OLTP makes data management simple and efficient. Unlike OLAP systems goal of OLTP systems is serving real-time transactions.
Example – Bank Transactions on a daily basis.
39. What is CLAUSE?
SQL clause is defined to limit the result set by providing condition to the query. This usually filters some rows from the whole set of records.
Example – Query that has WHERE condition
Query that has HAVING condition.
40. What is recursive stored procedure?
A stored procedure which calls by itself until it reaches some boundary condition. This recursive function or procedure helps programmers to use the same set of code any number of times.
41. What is Union, minus and Interact commands?
UNION operator is used to combine the results of two tables, and it eliminates duplicate rows from the tables.
MINUS operator is used to return rows from the first query but not from the second query. Matching records of first and second query and other rows from the first query will be displayed as a result set.
INTERSECT operator is used to return rows returned by both the queries.
42. What is an ALIAS command?
ALIAS name can be given to a table or column. This alias name can be referred in WHERE clause to identify the table or column.
Select st.StudentID, Ex.Result from student st, Exam as Ex where st.studentID = Ex. StudentID
Here, st refers to alias name for student table and Ex refers to alias name for exam table.
43. What is the difference between TRUNCATE and DROP statements?
TRUNCATE removes all the rows from the table, and it cannot be rolled back. DROP command removes a table from the database and operation cannot be rolled back.
44. What are aggregate and scalar functions?
Aggregate functions are used to evaluate mathematical calculation and return single values. This can be calculated from the columns in a table. Scalar functions return a single value based on the input value.
Example -.
Aggregate – max(), count – Calculated with respect to numeric.
Scalar – UCASE(), NOW() – Calculated with respect to strings.
45. How can you create an empty table from an existing table?
Example will be -.
Select * into studentcopy from student where 1=2
Here, we are copying student table to another table with the same structure with no rows copied.
46. How to fetch common records from two tables?
Common records result set can be achieved by -.
Select studentID from student. <strong>INTERSECT </strong> Select StudentID from Exam
47. How to fetch alternate records from a table?
Records can be fetched for both Odd and Even row numbers -.
To display even numbers-.
Select studentId from (Select rowno, studentId from student) where mod(rowno,2)=0
To display odd numbers-.
Select studentId from (Select rowno, studentId from student) where mod(rowno,2)=1
from (Select rowno, studentId from student) where mod(rowno,2)=1.[/sql]
48. How to select unique records from a table?
Select unique records from a table by using DISTINCT keyword.
Select DISTINCT StudentID, StudentName from Student.
49. What is the command used to fetch first 5 characters of the string?
There are many ways to fetch first 5 characters of the string -.
Select SUBSTRING(StudentName,1,5) as studentname from student
Select LEFT(Studentname,5) as studentname from student
50. Which operator is used in query for pattern matching?
LIKE operator is used for pattern matching, and it can be used as -.
- % – Matches zero or more characters.
- _(Underscore) – Matching exactly one character.
Example -.
Select * from Student where studentname like 'a%'
Select * from Student where studentname like 'ami_'


text:
If you purchase a MacBook Air, newer MacBook Pro with Retina display or an ultrabook these days and chances are the storage is a solid-state drive (SSD). Compared to traditional magnetic drives that have spinning platters and floating heads, SSDs have no moving parts. Of course being a newer technology, SSDs have had a much higher cost per megabyte compared to standard hard drives, but with prices falling and their significant advantages, they may now be worth looking at for your storage needs.
Read more…AT CANOE TECH BLOG