text:
General Hospital Comings And Goings.Friday, March 07 2014 |
Just spoke with @valentinifrank 💗Very excited to return to work next week. 😊 I wonder what Maxie has been up to on her vacation....
— Kirsten Storms (@teenystweeting) February 25, 2014
Catch up on Dallas spoilers, Grey's Anatomy spoilers, Pretty Little Liars spoilers, Revenge Spoilers, and Venice The Series recaps.
Follow Soaps.com on Soaps.com on Twitter, "like" Soaps.com on Facebook.
- Christine Fix


text:
Google finds 52,000,000 matches for ain't but non-natives simply can't look up this word. Wiktionary isn't helpful.
Is it some kind of 'wildcard' for "am/is/are not"?
Google finds 52,000,000 matches for ain't but non-natives simply can't look up this word. Wiktionary isn't helpful. Is it some kind of 'wildcard' for "am/is/are not"? |
The common bit of schoolyard wisdom that "ain't ain't in the dictionary, so ain't ain't a word" turns out to be untrue. Every online dictionary that I've ever looked in contained an entry for ain't. Collins English Dictionary - Complete & Unabridged 10th Edition Dictionary of American Slang and Colloquial Expressions: Cambridge Advanced Learner's Dictionary: Webster's New World College Dictionary: American Heritage Dictionary, 4th edition: Longman Dictionary of Contemporary English Advanced Learner's Dictionary: Other dictionaries available to me at my desk include The New Oxford American Dictionary that ships with Mac OS X, which also has an entry for ain't: So, clearly, non-natives (and natives too) can look up this word. |
Part of the reason it doesn't make the cut is because it is considered nonstandard (why it never earns a status as a valid alternative form is tough to say). But if your dictionary is robust enough, you'll find it in there. The Oxford English Dictionary says the following: |
Basically, yes. It's almost the definitive colloquial word: every native speaker knows perfectly well what it means, but no one admits it in formal or even semi-formal usage. It's not (as far as I know) a contraction of actual words; rather, it is a slurring of several different possibilities, which are as you listed. |
Actually, it is listed in various dictionaries. Some quotations about its usage: Finally, the definition of ain't in Merriam-Webster Dictionary: Etymology: contraction of are not
ain't is reported in the NOAD (New Oxford American Dictionary). |
This question is protected to prevent "thanks!", "me too!", or spam answers by new users. To answer it, you must have earned at least 10 reputation on this site.

subset: commoncrawl


text:
NCH Homepage
Contact Us
Sign In
Our Vision, Mission & Values
Physician Opportunities
Find an NCH Physician Group Doctor
Colonial Square Building
Commons Building
Creekside Building
Eagleview Building
Edison Village Building
Florida Coastal Professional Center
Neapolitan Way Plaza
Paragon Professional Building
Pavilion Plaza
South Naples Professional Center
Stonegate Bank Building
Veterans Park Building
Briggs Health Pavilion
Retina Center Building
Brennan Building
Marco Island
Med Plaza
Health Park
Bonita Community Health Center
Piper Building
Primary Care
Family Medicine
Internal Medicine
Geriatric Medicine
Specialty Care
Gastroenterology and Hepatology
Infectious Diseases
Physical Medicine and Rehabilitation
Pulmonary Medicine
Naples Sleep Center
Naples Orthopaedic Surgery
Urgent Care
General Surgery
Ancillary Services
Anticoagulation Clinic
Hyperbaric Oxygen Therapy
Physical Therapy
Sleep Studies
Travel Medicine
Diagnostic Imaging Services
Breast Specific Gamma Imaging (BSGI)
Ultrafast Coronary Artery Calcium Score
Computed Tomography (CT) Scan
Digital Mammography
Magnetic Resonance Imaging (MRI)
Ultrasound Imaging
Diagnostic Radiology (X-Ray)
Bone Density Test - DEXA
Vascular Ultrasound
Privacy Rights
Patient Navigator Service
Patient Forms
Financial Policies
Insurances Accepted
NCH Physician Group
Our Services
Specialty Care
Infectious Diseases
Commons Building
800 Goodlette Rd N., Suite 370
Naples Florida 34102
(239) 643-8760 Phone
(239) 643-9062 Fax
Dr. Mark Brown
Dr. Gary Bergen
Dr. Vakhtang Bochorishvili
lead our integral multifaceted Infectious Disease department.
They are highly trained board certified physicians
They are qualified experts in the diagnosis and treatment of infectious disease of any type and cause.
They are continually kept abreast of all current events and potentially concerning situations in the infectious disease area through publications, journals, seminars, symposiums and roundtable discussions.
The doctors receive constant updates from the Center for Disease Control (CDC) and the World Health Organization (WHO). They must also be highly knowledgeable about the most current antibiotic and medication use.
Some interesting facts that you should know about Infectious Diseases:
It has been noted that infectious diseases kill more people worldwide than any other single cause.
Germs are tiny living things found everywhere; in the air, soil, water, plants, food and just about every other surface including your body.
Infection can come by touching, eating or breathing something containing a germ. Germs are also spread through animal bites, kissing and sexual contact.
Your immune system works very hard to protect the body against a multitude of infectious agents. However, germs are constantly changing and mutating. These mutated germs then try to breach your immune systems.
To make an appointment with one of our infectious disease physicians, please call (239) 643-8760.
Related Pages
Commons Building
Family Medicine
Related NCH Physicians
Gary A. Bergen, MD
Infectious Disease
Miguel Gerardo Madariaga, MD
Infectious Disease
Vakhtang Bochorishvili, MD
Infectious Disease
Mark A Brown, MD
Infectious Disease
Related Health Library Content
Common Infectious Diseases
Home Page - Infectious Disease...
Topic Index - Infectious Disea...
The Immune System
Immune Disorders
Prevention of Infectious Disea...
All About the Immune System
Prevention of Infectious Disea...
Statistics of Infectious Disea...
Pets and Infectious Diseases
All About the Immune System
Pets and Infectious Diseases
Related Videos


text:
NEWSLETTERS Free Newsletters Archive My Subscriptions NEWS News by Subject News by Disease News by Date PLoS Search News Post Your News JoVE CAREER NETWORK Job Seeker Login Most Recent Jobs Browse Biotech Jobs Search Jobs Post Resume Career Fairs Career Resources For Employers HOTBEDS Regional News US & Canada Biotech Bay Biotech Beach Genetown Pharm Country BioCapital BioMidwest Bio NC BioForest Southern Pharm BioCanada East US Device Europe Asia DIVERSITY INVESTOR Market Summary News IPOs PROFILES Company Profiles START UPS Companies Events INTELLIGENCE Research Store INDUSTRY EVENTS Biotech Events Post an Event RESOURCES Real Estate Business Opportunities
CONCORD, MA and HOUSTON, TX--(Marketwire - March 20, 2013) - Alcyone Lifesciences, Inc., a privately held biopharmaceutical medical device company focusing on developing products for the treatment of difficult neuropathological conditions, and DNAtrix, Inc., a privately held biotechnology company developing virus-based immunotherapy products for cancer, today announced a collaboration to investigate Alcyone's Microcatheter System for delivery of therapeutics for brain tumor. Under the collaboration, Alcyone and DNAtrix will establish proof of concept for a proprietary direct delivery device in a preclinical setting.
"We are pleased to announce this collaboration between Alcyone's platform technology and a promising experimental brain cancer therapy from DNAtrix," said Rich Upton, General Partner, Harbor Light Capital Partners and a Board of Director at Alcyone Lifesciences, Inc.
A prerequisite for the efficacy of any cancer drug is that it reaches the tumor in therapeutic concentrations. For brain tumors, it is often desirable and more effective to deliver anti-cancer agents such as DNAtrix's oncolytic immunotherapy, directly to the tumor mass using catheters or needles. Alycone's Microcatheter System is specifically designed to provide enhanced reliability for direct intratumoral delivery.
"We are excited to be working with Alcyone on the development of a unique delivery system for direct intratumoral delivery," said Frank Tufaro, Ph.D., CEO of DNAtrix. "We feel this could provide an important option for neurosurgeons as we develop additional products for treating a variety of brain tumors, including brain metastases."
"We look forward to working with the DNAtrix team to improve treatment for a disease where little options exist for patients," said David Donabedian, Ph.D., Independent Board Director of Alcyone Lifesciences. Dr. Donabedian adds, "Targeted delivery to the brain, particularly to brain tumors, is an important challenge, and Alcyone's platform technology may greatly enhance the PK profile of a variety of active molecules."
About Glioblastoma
Glioblastoma is the most common and most aggressive malignant primary brain tumor in humans that is resistant to conventional therapies. It accounts for 52% of all functional tissue brain tumor cases and 20% of all intracranial tumors. The current standard of care -- surgery, radiotherapy and chemotherapy -- has extended the overall median survival to only 14.6 months. Treatment of glioblastoma remains an unmet medical need wherein new therapeutic modalities are essential requisites for impacting the course of this disease.
About Alcyone LifeSciences
Alcyone Lifesciences is a Concord, MA based private biopharmaceutical medical device company focused on development of novel treatment modalities for difficult neurological conditions. Alcyone Lifesciences was founded in 2010 by PJ Anand, CEO of Alcyone Lifesciences, Adam Fleisher, MD., Associate Professor of Neuroscience, UCSD, Banner Alzheimer's Institute and William Olbricht, PhD, Professor of Biomedical Engineering, Cornell University. For more information about Alcyone, please visit www.alcyonels.com.
About DNATrix
DNAtrix is a Houston-based, private biotechnology company focused on the development of oncolytic immunotherapy for the treatment of cancer. For more information about DNAtrix, please visit www.dnatrix.com.


text:
It's Hatched! 33 Bought
Deal Over
"Kick back and relax" takes on a whole new meaning after a good foot massage! During this 45-minute foot massage with reflexology treatment, certified reflexologist and certified massage therapist Cynthia DiRaimondo will use gentle pressure and the ancient techniques of reflexology to soothe stress, restore balance and increase relaxation throughout your entire body. The soothing scents of aromatherapy permeate the air to further aid in total relaxation. Your 15-minute chi treatment focuses on improving circulation and centering your body. This treatment can aid in detoxification which can bring a whole new level of relaxation.
'Don't Let Gravity Get you Down' is the motto of City Park Chiropractic. Dr. Michael DiRaimondo and his wife Cynthia are committed to helping their clients feel their best with a gentle, holistic approach. City Park Chiropractic care can help poor posture, neck or back pain, headache or sciatica.
$29 for a 45 Minute Reflexology Foot Massage & 15 Minute Chi Treatment at City Park Chiropractic
The Merchant, not DealChicken, is solely responsible for this Deal. This Deal is subject to the Terms of Service and HOW DEALCHICKEN WORKS.
City Park Chiropractic
Subscribe below and we'll send you a daily deal alert for Northern Colorado.
MontgomeryPhoenixPhoenix - East Valley Phoenix - West ValleyLittle RockMountain HomePalm SpringsSacramentoSalinasVisaliaDenverNorthern ColoradoDelawareWashingtonFort Myers/Cape CoralFSUJacksonvillePensacolaSpace CoastTallahasseeTampa BayUCF / East Seminole CountyAtlantaMaconGuamChicagoEast Central Indiana / RichmondIndianapolisLafayetteMuncieDes MoinesIowa CityLouisvilleAcadianaCentral LouisianaMonroe/West MonroeOpelousasShreveportBangorPortlandMontgomery CountySalisbury/Ocean CityBattle Creek / KalamazooDetroitGrand RapidsLansingLivingston CountyPort HuronCentral MinnesotaTwin CitiesHattiesburgJacksonOzarksSt. LouisGreat FallsRenoCentral JerseyCumberland CountyMonmouth CountyNorth JerseyOcean CountySouth JerseyBinghamtonBuffaloElmiraIthacaPoughkeepsieRochesterWestchesterAshevilleThe TriadCincinnatiClevelandCoshocton / Holmes CountyFairfield CountyLicking CountyMarion CountyMuskingum ValleyNorth Central OhioNorth CoastScioto ValleySalemColumbiaGreenvilleSioux FallsClarksvilleJacksonKnoxvilleMurfreesboroNashvilleSouthern UtahNorthern VermontNorthern VirginiaStauntonCentral WisconsinFond du Lac / OshkoshFox CitiesGreen BaySheboygan / Manitowoc
There's one last thing we need from you to create your account.


text:
MacFixIt Answers
MacFixIt Answers is a feature in which we answer questions e-mailed from our readers. This week we have questions on boot camp drivers not installing on MacBook systems, how to undo the Terminal command to disable DNS prefetching in Safari, black rectangles appearing over Finder items, and how many CPU settings are recommended for use with Windows XP in Parallels Desktop.
Question: Boot Camp drivers not installing on MacBook
MacFixIt reader "Michelle" asks:
I have a Core duo first-generation MacBook (one of the black ones). I have recently decided to put Windows on my Mac for software incompatibility … Read more


text:
Cold Sores (cont.) Medical Author:
Mohamad El Mortada, MD
Medical Author:
MaryAnn Tran, MD
Medical Author:
Corrine Young, PharmD
Medical Author:
Mary Nettleman, MD, MS, MACP
Mary Nettleman, MD, MS, MACPMary D. Nettleman, MD, MS, MACP is the Chair of the Department of Medicine at Michigan State University. She is a graduate of Vanderbilt Medical School, and completed her residency in Internal Medicine and a fellowship in Infectious Diseases at Indiana University. Medical Editor:
Melissa Conrad Stöppler, MD, Chief Medical Editor
Melissa Conrad Stöppler, MD, Chief Medical EditorMelissa Conrad Stöppler, MD, is a U.S. board-certified Anatomic Pathologist with subspecialty training in the fields of Experimental and Molecular Pathology. Dr. Stöppler's educational background includes a BA with Highest Distinction from the University of Virginia and an MD from the University of North Carolina. She completed residency training in Anatomic Pathology at Georgetown University followed by subspecialty fellowship training in molecular diagnostics and experimental pathology. IN THIS ARTICLE
Cold Sore CausesThe virus that causes cold sores is known as the herpes simplex virus (HSV). There are two types of HSV, type I and type II. Cold sores are usually caused by type I. Herpes simplex is caused by a contagious oral virus. The virus is spread from person to person by kissing or other close contact with sores or even from contact with apparently normal skin that is shedding the virus. Infected saliva is also a means of spreading the virus. The most contagious period is when a person has active blister-like sores. Once the blisters have dried and crusted over (within a few days), the risk of contagion is significantly lessened. However, a person infected with HSV can pass it on to another person even when a cold sore is not present. This is because the virus is sometimes shed in saliva even when sores are not present. Despite popular myth, it is almost impossible to catch herpes (cold sores) from contaminated surfaces, towels, or washcloths. After the first infection, the virus enters the nerve cells and travels up the nerve until it comes to a place called a ganglion, which is a collection of nerve cells. There, it resides quietly in a stage that is called a "dormant" or "latent" period. In more active stages, the virus starts multiplying again and travels down the nerve to the skin, causing blisters on the lips known as cold sores. The exact way this happens is not clear, but it is known that some conditions seem to be associated with recurrences, including
Sometimes there is no apparent cause of the recurrence. Colds sores have a tendency to recur in more or less the same place each time. Such recurrences may happen often (for example, once a month) or only occasionally (for example, once or twice a year). Next Page: Must Read Articles Related to Cold Sores
The cold is the most commonly occurring illness in the entire world, with more than 1 billion colds per year reported in the United States alone. Symptoms and s...learn more >>
Sunburn is a burn on the skin caused by UV radiation. Mild sunburn symptoms include skin redness and pain. Severe cases of sunburn (sun poisoning) are complicat...learn more >>
Patient Comments & ReviewsThe eMedicineHealth doctors ask about Cold Sores:Herpes Simplex Infections - Describe Your ExperiencePlease describe your experience with herpes simplex infections (cold sores, non-genital). |
Women's Health
Find out what women really need.
From WebMD
Skin Problems and Treatments Resources
Featured Centers
Health Solutions From Our Sponsors
Read What Your Physician is Reading on Medscape
Herpes Simplex »
Herpes simplex viruses (HSVs) are DNA viruses that cause acute skin infections and present as grouped vesicles on an erythematous base.


text:
24 10 / 2012
Pre-Season Coaching Blunders
It's the Pre-Season. Wins are meaningless, Health is Meaningful. What is D-Wade, Haslem and Lewis doing on the court in the 4th Quarter? This should be the time to evaluate players 13-18
15 6 / 2012
"The Team that shoots the LEAST amount of 3 pointers will win the NBA FINALS…."


text:
Unemployment Insurance:
Better Data Needed to Assess Reemployment Services to Claimants
GAO-05-413: Published: Jun 24, 2005. Publicly Released: Jun 24, 2005.
Additional Materials:
- Highlights Page:
- Accessible Text:
(202) 512-7003
Office of Public Affairs
(202) 512-4800
With unemployed workers at a greater risk of long-term unemployment than in the past, it is increasingly important to quickly connect Unemployment Insurance (UI) claimants with reemployment activities. However, the shift to remote claims filing in many states has raised concerns about maintaining a connection between the UI program and reemployment services. This report examines (1) the extent to which states have shifted to remote claims filing and how they are making claimants aware of program requirements and services, (2) what states are doing to facilitate reemployment of UI claimants, and (3) what is known about the extent to which UI claimants receive reemployment services and about their outcomes.
Nearly all states accept most initial UI claims remotely by telephone, the Internet, or both. Even though claimants filing remotely no longer have face-to-face contact with UI staff at the time the claim is filed, all states told us they have found ways to provide information on eligibility requirements and reemployment services to individuals filing claims, such as by including this information in the scripts used by claims takers at UI call centers or as documents on Web pages. Officials from most states told us the shift to remote claims has not diminished their ability to provide information or deliver services to claimants. In fact, some report that this shift may have improved their ability to serve their customers. cross states, claimants have access to a variety of reemployment services, and states make use of UI program requirements to connect claimants with available services at various points in their claim. All federally approved state UI programs require that claimants be able and available to work, and in many states these requirements also serve to link claimants to reemployment services. States also engage some claimants in reemployment services through programs that identify certain groups for more targeted assistance. States primarily target reemployment services to claimants identified as most likely to exhaust their UI benefits before finding work, through federally required claimant profiling programs. Little is known about the extent to which claimants receive services from the broad array of programs designed to assist them or about the outcomes they achieve. States must meet a number of federal reporting requirements for their UI and employment and training programs, but none of these reports provides a complete picture of the services received or the outcomes obtained by UI claimants. GAO also found that few states monitor the extent to which claimants are receiving these services, and even fewer monitor outcomes for these claimants, largely due to limited information systems capabilities. Labor has some initiatives that may begin to shed light on claimant services and outcomes, but none will provide a complete picture.
Status Legend:
- Review Pending
- Open
- Closed - implemented
- Closed - not implemented
Recommendation for Executive Action
Recommendation: As Labor develops the Employment and Training Administration Management Information and Longitudinal Evaluation, the Secretary of Labor should work with states to develop a plan for considering the feasibility of requiring states to collect more comprehensive information on UI claimants' use of reemployment services and the outcomes achieved by claimants, including the length of time claimants receive UI before they are reemployed.
Agency Affected: Department of Labor
Status: Closed - Not Implemented
Comments: The Department of Labor took some steps to supplement the data currently collected on Unemployment Insurance (UI) claimants' use of reemployment services and the outcomes achieved by claimants. Since GAO's report was issued, the UI program implemented a performance measure to track the rate at which UI beneficiaries become reemployed. Another data collection effort that Labor implemented is the Reemployment and Eligibility Assessment (REA) Initiative. Under REA, Labor provided funding to 21 states in FY05 and 20 states in FY06 to conduct in-person interviews with UI claimants to assure that they meet continuing eligibility requirements--including their responsibilities to find reemployment--and to assess their needs for reemployment services. Some information from FY05 assessments was collected from 9 states and all 20 states participating in FY06. In FY 2008, the Department provided about $15.8 million to 19 states to conduct the REA Initiative. The final REA study was published in March 2008 and posted on ETA's web site. The data includes the length of time claimants receive UI benefits before they are reemployed. States are expected to use the National Directory of New Hires cross-match data to obtain this information. In addition, in FY 2009, an additional $40 million was appropriated to expand REA to additional states and to additional locations within currently participating states. Proposals have been received from states that wish to implement REAs and from currently participating states that wish to expand their initiatives. These proposals are currently under review. Finally, ETA began another effort recently in response to the American Recovery and Reinvestment Act of 2009 (ARRA), which provided targeted funding to support Reemployment Services to UI claimants. To obtain more information about the reemployment services accessed by UI claimants, states submit a monthly report to Labor about services that UI claimants receive through the Reemployment Services Grants-funded staff assisted services. States will report on the same data elements that are collected for the Wagner-Peyser Act Employment Service report, with one additional data element: referral to training, including WIA-funded training. Two key factors that led to this new Reemployment Services report are that ARRA clearly distinguishes between general Wagner-Peyser Act funds and Reemployment Services funds to support targeted services to UI claimants and oversight bodies, including Congress, need to understand the impact of the $250 million dedicated to UI claimants; and that the Employment Service serves over 16 million individuals each year. While these efforts help address the recommendation, however, extending this effort to all claimants would fully address our concerns, as we recommended.
Mar 5, 2014
Workforce Investment Act:
Strategies Needed to Improve Certain Training Outcome DataGAO-14-137: Published: Jan 31, 2014. Publicly Released: Mar 5, 2014.
Jan 23, 2014
Fair Labor Standards Act:
The Department of Labor Should Adopt a More Systematic Approach to Developing Its GuidanceGAO-14-69: Published: Dec 18, 2013. Publicly Released: Jan 23, 2014.
Dec 20, 2013
Workforce Investment Act:
DOL Should Do More to Improve the Quality of Participant DataGAO-14-4: Published: Dec 2, 2013. Publicly Released: Dec 20, 2013.
Dec 6, 2013
Workforce Investment Act:
Results for Survey of Workforce Investment Boards (GAO-14-20SP, December 2013), an E-supplement to GAO-14-19 [Reissued on December 6, 2013]GAO-14-20SP: Published: Dec 2, 2013. Publicly Released: Dec 2, 2013.
Dec 2, 2013
Workforce Investment Act:
Local Areas Face Challenges Helping Employers Fill Some Types of Skilled JobsGAO-14-19: Published: Dec 2, 2013. Publicly Released: Dec 2, 2013.
Nov 4, 2013
Native American Veterans:
DOL Needs a Clear Plan to Improve Employment and Training Services on Tribal LandsGAO-13-664: Published: Sep 26, 2013. Publicly Released: Nov 4, 2013.
Jul 19, 2013
Employment and Training:
Labor's Green Jobs Efforts Highlight Challenges of Targeted Training Programs for Emerging IndustriesGAO-13-555: Published: Jun 19, 2013. Publicly Released: Jul 19, 2013.
Jul 2, 2013
Actions Needed to Improve the Transparency and Reliability of Labor's Data on the H-2A ProgramGAO-13-144R: Published: Jul 2, 2013. Publicly Released: Jul 2, 2013.
May 30, 2013
Employing People With Blindness or Severe Disabilities:
Enhanced Oversight of the AbilityOne Program NeededGAO-13-457: Published: May 30, 2013. Publicly Released: May 30, 2013.
May 29, 2013
Worker Safety and Health at Department of Energy SitesGAO-13-497R: Published: May 29, 2013. Publicly Released: May 29, 2013.
Looking for more? Browse all our products here


text:
5 Ways to Re-think Land Grabs | Related |
Our conception of land-grabs and global discussions on the phenomenon are a bit too 'Africanized.' They are informed too much by contentious, large-scale land deals in Africa and too little by examples from other regions (such as Latin America). This has led to many unfounded assumptions about the nature of land-grab. For example, we tend to focus mostly on foreign businesses as the perpetrators, while Latin America is rife with examples of regional/ national companies engaging in such deals. Examples from the region also demonstrate the role of multi-use 'flex-crops' in drawing up policy-level justifications for such deals. In this short interview, Dr. Saturnino (Jun) Borras fleshes out 5 such perspectives from which land-grabbing could be viewed afresh. And perhaps understood better.
More info: Land and Rights in Troubled Waters (Blog) Category: Food Security
Tags: TWCprod, CoCoon, FIAN, Utecht University, land, grab, deals, rights, based, deals, land, use, latin, america, africa, global, TWCpolicy
Rating: 2.8 (194 Votes)
6525 Views |
1690 Views
4668 Views
2917 Views
Download this video (if available) Embed Code Permalink Send to a friend |
Video Comments |


text:
I haven't added this to my profile yet
There is nothing to display yet, check back soon.
On Tue, Dec 27, 2011 at 7:43 AM, m!$$ gaNg$ta raPper said:
HeY'! thanks for the coment...take care bbY ?'!
wode wc for life is a man from g tonw . He has been member of this site for 2 years.
So far wode wc for life has earned 204pts and has 546 views!


text:
Grand Rapids MI Apartment Rentals Offered by Cambridge Partners Inc
Choose from Dozens of Floor Plans in Six apartment Rental Communities in the Grand Rapids area. One Source. With affordable pricing starting at under $500 and locations throughout West Michigan, you will discover the perfect apartment home to lease.
Visit our File Library to view property brochures as well as handy Property Comparison Worksheets!
Furnished Rentals Grand Rapids, MI
Furnished Corporate & Guest Suites Apartment Rentals, Grand Rapids, Michigan
Cambridge Partners offers fully furnished apartments for business or leisure! We offer the perfect home away from home!
Click here to view our options!
Relax, Unwind, Welcome Home to Woodland Creek Furnished Apartments!
Our professionally decorated Guest Suites provide you with everything you need to feel at home.
Resident Services
Work order
Click here to submit a work orderGive 'em the pickle
employee recognition
When an employee goes above and beyond the call of duty. Click here to Give 'em a Pickle!
Are you a current resident?
Pay your rent online, submit a service request, or read and participate on our blog.
Click here to access your resident services!


text:
270 herlaai data
This is a discussion on 270 herlaai data within the Reloading forums, part of the Firearms & Ammunition category; Middag almal, kan julle my dalk help? Ek soek bietjie herlaai data vir my 270 win ek het 140 grein ...
07-16-2013, 07:48 AM #1New Member
- Joined
- Nov 2012
- Posts
- 5
- Hunted RSA, Botswana
- Dirty Harry has no Articles
- Dirty Harry has no Photos
270 herlaai data
Middag almal, kan julle my dalk help? Ek soek bietjie herlaai data vir my 270 win ek het 140 grein Barnes tsx bt punte en 140 grein sierra bt punte. S335, S365, of S355 kruit? Watse primers en ook Tpl asb?
Hi DH. I use a 270 Win as well but have settled on 150g bullets. I used 140g many years ago but no longer have the reloading data. Actually, reloading data for 140g bullets with Somchem powders was unavailable at the time - I interpolated between the 130 & 150g loads to come up with a 140g load. I use S365 & standard primers. Cases are either Remington or Winchester.
Perhaps give Koos Barnard a call at Magnum magazine for a suggested load.
07-17-2013, 01:20 AM #3New Member
- Joined
- Nov 2012
- Posts
- 5
- Hunted RSA, Botswana
- Dirty Harry has no Articles
- Dirty Harry has no Photos
Morning all, it think I will get more replies when I post in another language! Im looking for reloading data for my .270 win with 140 grains barnes tsx bt and sierra 140 grains bt the only powder we have available here in SA is somchem. I use S335, S355 and S365 at the moment with my other rifles. Some suggestions please?
Similar Threads
303 reloading data
By Raptor in forum ReloadingReplies: 10Last Post: 07-17-2013, 08:06 AM -
.375 Ruger herlaai info vit barnes tipped TSX 250 grains
By Bertus in forum ReloadingReplies: 18Last Post: 05-13-2013, 01:56 PM -
505 Gibbs 600 grain load data? And 525 grain data?
By MrGibbs. in forum ReloadingReplies: 6Last Post: 01-11-2012, 05:31 AM -
Load Data For .375 H&H (P.O. Ackley Improved)
By bohemian in forum ReloadingReplies: 4Last Post: 06-05-2011, 01:06 PM -
reduced load data for .458 Lott and .375 H&H?
By FFemt5287 in forum ReloadingReplies: 8Last Post: 10-10-2010, 05:30 PM


text:
Pineapple tarts, bite-sized morsels of buttery tangy goodness. A Lunar New Year delicacy!
Rempah Udang Chili Sauce- this homemade chili sauce made with dried shrimps and readily available spices is so good, I can polish off a bowl of rice with this alone!
my annual leftover Christmas turkey rescue mission-simmered roast turkey bits, salted mustard cabbage, tomatoes, ginger and pickled plums make good soup!
prawns, fresh pineapple chunks, onions, chillies, shrimp paste, lemongrass and galangal add up to south east asian curry heaven
an essay on culinary creative licence and the singaporean foodie plus a recipe for mee siam - rice vermicelli in a spicy sour gravy
Sambal Okra... oh so yummy
Amsterdam city guide: BioMarkt & why I love Amsterdam, the greatest little city in world
nasi goreng ikan bilis-leftover rice fried with salted anchovies, roast chicken and chillies. hot, smoky and spicy, from wok to plate in minutes!
nasi goreng ikan bilis-leftover rice fried with salted anchovies, diced roast chicken and chilli. hot, smoky and spicy from wok to plate in minutes!
sambal belacan - a sharp, pungent and tongue tingling relish of fresh chillies, toasted shrimp paste and lime juice. goes with everything, but dessert!
an easy delicious, sweet and sour cucumber and pineapple pickle that will make your tastebuds sing!
Malaysian Nyonya Captain's Chicken Curry
Kuih Seri Muka - a traditional Malay steamed glutinous rice and custard dessert, naturally green with pandan leaves!
Malaysian Nyonya Kerabu Bee Hoon - a spicy, sweet, and sour noodle salad dish
Nyonya Chap Chye - Stewed Mixed Vegetables & Fungus
Ayam Pongteh - Nyonya stewed chicken.
This Nyonya style curry or kari kapitan dish is a unique style of cooking with Chinese, Malay and Thai influences.
A vibrant Singaporean soup with tofu, pork, and prawn dumplings in a prawn and pork stock with bamboo shoots and pork belly.
Chicken Curry with Kaffir Lime Leaves
Nonya Curry Laksa ~ Noodles serves in thick creamy 'curry' like broth.
Try this classic Malaysian dish of Nyonya style spicy tamarind fish or Assam fish.
Rainbow Kueh Lapis- Steamed 9 Layer Cake. A heritage delicacy in South East Asia...
Nyonya Style Fried Chicken/Inchi Kabin
Glutinous Rice dumplings for Dragon Boat Festival... one of Chinese Festivals in the Lunar calender
Inche Kabin is a Nyonya style fried chicken infused with rich spices, coconut milk and are deep fried twice.
Ayam Sioh is a Malaysian Nyonya dish ~ chicken cooked in yellow beanpaste and roasted coriander.
Dried shrimp sambal is a spicy and aromatic Chinese-Nyonya condiment. It's so good that you will want more!
Nyonya Laksa - Malaysian traditional Nyonya style shrimp & rice noodle.
Recipe for the king of Malaysian dishes - Assam Laksa
Pulut inti - a Nyonya kuih (sweet cake)
Angku Kueh/Steamed Glutinous Rice Cake with Mung Bean Filling
Vegetable Curry
Nyonya Cincalok Omelette.
Nyonya-Style Rice Dumplings. Savory rice dumplings from the state of Malacca. A must on the Dragon Boat Festival, especially when you are from Malaysia and Singapore.


text:
Pizza Place Search
Traditional Crust Pizza
The crust is not too thick and not too thin. Usually it is created by rolling the dough into a round circle then topping it with sauce and cheese.
Deep Dish Pizza
A think crust and dense toppings usually characterize deep-dish pizza, also known as pan pizza. Baking time tends to take longer however one slice might make a meal for many people.
New York Style Pizza
Pizzas from neighborhood pizza parlors in New York tend to be much thinner than its Chicago cousin. Typically the thin crust allow for faster cooking but less dense toppings. The crust is also usually prepared by tossing it up in the air and twirling it.
This is basically a stuffed pizza crust. The uncooked crust is filled with traditional topping then folded and baked. An easy to manage snack, these have gained in popularity across the country in the last few years.
Bagel Pizza
Made much like the French bread pizza but with bagel slices instead.
Pizza Bread
Also known as French bread pizza, it is perhaps one of the easiest to make. The French bread loaf is usually sliced down the center into two halved. The sauce, cheese and topping are then placed on the flat, sliced surface.
Frozen Pizza
Popular because of its ease to prepare, this is perfect for the person that hates to cook but want a cheap and inexpensive pizza. Open the box and put it in the oven. We are starting to see some of the big named brands turning out to be not all that bad.
Toppings are usually a matter of preference, but typically consist of a tomato based sauce and mozzarella cheese. In truth, there is no limit to how you can prepare your pizza and the topping you use.
Related Pages
Co-Branding Sponsorship | Business Relations | Submit Press Releases | Advertise


text:
A helping hand Harry and his wife are having hard financial times, so they decide that shell become a hooker. S...read more 9/7/2010 12:00:00 AM 5,453
Cock in the air Two hookers were on a street corner. They started discussing business, and one of the hookers said, ...read more 3/22/2010 12:00:00 AM 5,412


text:
800.298.4TEA (4832) Contact Us
Open 24 hours a day, 7 days a week
Free Shipping on all U.S. tea orders over $100
This herbal blend has about the same amount of caffeine as a cup of coffee. More about caffeine.
Steeping herbal tea is easy. Simply heat fresh, filtered water to a rolling boil. Then pour water over tea and steep for 5-7 minutes.
Currently no Tea Leaf Readings. Be the first to submit one!


text:
SKU: 70835 Weight: 0.03
In stock
List Price:$6.97 Your Price:$2.29 You Save: $4.68 (67%) International customers, please view our shipping page for information on additional shipping fees. CLICK HERE
EDMUNDS-Wood Embroidery Hoop. Embroidery hoops are great for working all kinds of crafts-- from needle arts to fabric painting. Once the project is finished; embellish the edges with lace; paint; gems or other such materials and use it as a display frame. This package contains one round-edged wood hoop that measures 3 inches in diameter and 3/8 inch thick. Imported.


text:
Spray my graffiti from my vintage gallant tongue
*Thish one'sh called "Shtella Wash a Diver And She Wash Alwaysh Down"* A creature is a creature, though I wish I were the wind. Instead - a student and delicate child of life with a blog. Daughter and heiress of a shyness that is criminally vulgar. I exist on the best terms I can. Atheist. I know I believe in nothing, but it is my nothing. PBA (Paul Banks Anonymous). INTJ. A well-tailored person suit. Anglophile, possibly anglomaniac. Lover of words. Reader of books. One day I am gonna grow wings, a chemical reaction, hysterical and useless. I suffered a strange musical accident when I was little. I obsess over band members and a single line of a song can keep me awake for years. I have a thing for detective sergeants. Flogging one-legged turkeys from a three-wheeled van since 1993. Out of my league, I have birds in my sleeves, and I want to rush in with the fools. "Everyone is broken-hearted except for the drastically unimaginative." - Paul Banks Currently reading: I'm reading stuff. Things. "Can we waste some more time just colliding in space? No matter how high we set the bar…we win" 02.02.2013 :') Cobwebs long since overrun
Morse code for trumpet quintets
Four Things and a Lizard
You say to me set black fires Fancy summer's stall, a time to be so small
I should have been a pair of ragged claws, scuttling across the floors of silent seas
Throw yourself into the road, darling! You haven't got a chance!
We might die from medication, but we sure killed all the pain
Video Post Mon,
May. 13, 2013 13 notes This episode has such a strong cast of guest stars.
#Inspector Morse#John Thaw#love life#Sue Johnston#06x04#Absolute Conviction#this one's my own work#GPOY


text:
You are Here
Bar Recycling Program
by Glass City, Window Shopper
- Created: May 9, 2012, 10:00 pm
- Updated: May 10, 2012, 9:45 am
Hello, I am joining the SBA community from Perrysburg, OH. I am looking for
guidance on how to pursue a bar recycling program here in the Toledo area.
The amount of glass and aluminum thrown out at area bars and bowling alleys
is huge and it needs to be changed. Owens Illinois Is located in Perrysburg
and one of their initiatives is to expand their green footprint. I would like
to partner with OI to collect glass around the city and supply back to OI to
help increase their green initiative. My hang up is transportation of the
glass to OI, is their anyone familiar with this process or a group who can
advise on how to pursue this? I appreciate any feedback - Glass City
kmurray | Community Moderator | 5/17/2012 - 9:42 am
Have you tried contacting your local government representatives in Perrysburg? Getting in touch with someone in the office of city adminstration could help you coordinate your effort. Best of luck!
SBA Community


text:
Share your comments
What other readers are saying about this title:
Ben said:
I thought it was an awesome book and a great adventure when he had to climb up the mountian to save Rin ( his town). It was ok at the beginning but then got better and better. I really enjoyed it and it was pretty hard to put down once you got into it. I also loved all the action when he had to fight spiders and the swamp to get to the top. He must also face the fierce dragon at the top. I thought it was a great book! [Sequel: Rowan and the Travelers]
posted Jun 26, 2005 at 10:01AM
| |
Erica said:
I loved it. It was very cool to think a boy my age did such great things.
posted May 9, 2006 at 11:08AM
Add a Comment |
Submission Guidelines |


text:
Found December 03, 2012 on
Fox Sports Carolinas:
LaMarcus Aldridge,
Luke Babbitt,
Damian Lillard,
Nicolas Batum,
Ben Gordon,
Kemba Walker,
Byron Mullens,
J.J. Hickson,
Michael Kidd-Gilchrist,
Gerald Henderson
TEAMS: Portland Trail Blazers, Charlotte Bobcats
TEAMS: Portland Trail Blazers, Charlotte Bobcats
CHARLOTTE, N.C. (AP) -- LaMarcus Aldridge had 25 points and 13 rebounds, Luke Babbitt hit a pair of clutch 3-pointers and the Portland Trail Blazers overcame an 18-point fourth-quarter deficit to beat the Charlotte Bobcats 118-112 in overtime Monday night.
The Blazers trailed 97-79 with 5:17 left in regulation, but stormed back to tie the score and sent it into overtime on Babbitt's 3 with 22 seconds left.
Portland never trailed in overtime.
Damian Lillard scored 24 points and Nicolas Batum added 17 points and 13 rebounds for the Blazers, who finished a road trip with two straight wins.
Ben Gordon set a franchise record with eight 3-pointers -- all after halftime -- for the Bobcats, who dropped their fourth straight game. Gordon finished with 29 points to surpass 10,000 for his NBA career.
Charlotte had a chance to win at the end of regulation but Kemba Walker's drive and fallaway jumper from the baseline didn't fall. The Bobcats wanted to get the ball to Gordon for the last shot, but he was well covered.
Walker penetrated, pump-faked and got a good shot off that didn't go down.
Walker finished with 22 points and 17 assists for the Bobcats. Byron Mullens added 12 points and 12 rebounds.
Charlotte led most of the game before J.J. Hickson gave the Blazers their first lead at 63-61 on a fast-break layup with 4:17 left in the third quarter.
But it was short-lived as Gordon began to heat up.
Gordon, who came in shooting 45 percent from 3-point range, made two 3s -- drawing a foul on one for a four-point play -- to give the Bobcats a 75-70 lead at the end of the third.
Charlotte carried the momentum into the fourth quarter opening with a flurry, scoring the first 12 points with Michael Kidd-Gilchrist adding six during the stretch and Gordon hitting two more 3s.
But the Blazers began chipping away as Lillard scored 16 points after halftime.
Charlotte shot 58 percent from the field in the first half, but only led 54-51 lead at the break. The Bobcats hit 13 of their first 18 shots from the field.
The run included a pair of highlight reel plays, including Mullens driving down the lane and leaping over Aldridge for a one-handed dunk. A short time later, Kidd-Gilchrist drove in from the right wing and slammed one home with two hands with authority.
Walker had 17 points in the first half with five assists, but was fairly quiet the rest of the way.
The Blazers stayed close behind Aldridge's strong play in the paint where he scored 11 points on 5-of-5 shooting.
Charlotte's Gerald Henderson returned after missing 13 games with a foot injury, but did not start. Henderson played only 15 minutes and scored five points.
Original Story:
B.J. Mullens Owns LaMarcus Aldridge (Video)
Boston blows out Portland in 78-96 Blazer's loss
Dunk of the night: BJ Mullens bangs on LaMarcus Aldridge
Byron Mullens Flying Dunk on LaMarcus Aldridge's Face (Video)
Byron Mullens Dunks All Over LaMarcus Aldridge, But Bobcats Still Lose (Video)
Byron Mullens Dunks All Over LaMarcus Aldridge
Byron Mullens dunks on LaMarcus Aldridge (Video)
Byron Mullens Gives LaMarcus Aldridge Something To Think About
Byron Mullens Posterizes LaMarcus Aldridge With Early Dunk Of The Year Candidate
Why Blake Griffin Should Not Be An All-Star
Trail Blazers 118, Bobcats 112 (OT)
Trail Blazers-Pacers Preview
Blazers' sizzling finish produces OT win at Charlotte
NBA Forum Discussions
1 replies,
4 days ago
Latest Rumors | The Backyard | |||
Today's Best Stuff |
For BloggersJoin the Yardbarker Network for more promotion, traffic, and money. |
Company Info |
Help |
What is Yardbarker?Yardbarker is the largest network of sports blogs and pro athlete blogs on the web. This site is the hub of the Yardbarker Network, where our editors and algorithms curate the best sports content from our network and beyond. |


text:
THE SQL Server Blog Spot on the Web
There's a very nifty feature of T-SQL that, in my experience, not everyone knows about but is handy for generating surrogate key values as part of an ETL routine. I myself had to ask on Twitter what the syntax was because I couldn't remember it (thanks to Matija Lah for reminding me) so I think its worth blogging in case I forget it again.
To summarize the feature, you can use a variable in the expression of the SET clause in an UPDATE statement while updating it at the same time. The syntax is:
@variable = column = expression
where expression can include @variable.
It will probably crystalise in your brain if you see it in action, so here is a little demo:
/*Create a table and populate with data*/ DROP TABLE [#DimProduct]; --will fail first time you run the script, so just run it again CREATE TABLE [#DimProduct] ([ProductId] INT, [ProductCode] VARCHAR(10)); DECLARE @i INT = 0; INSERT [#DimProduct]([ProductId],[ProductCode])VALUES(1,'qwerty'); /*Simulating an existing record*/ WHILE @i <10 BEGIN /*Simulating some new rows for which we want to generate a a surrogate key*/ INSERT [#DimProduct]([ProductCode])VALUES(REPLACE('qwerty@i','@i',@i)); SET @i += 1; END /*Take a look at the data*/ SELECT * FROM [#DimProduct] /*Generate surrogate keys using an UPDATE*/ DECLARE @MaxSurrogateKey INT = ( SELECT ISNULL(MAX([ProductId]),0) FROM [#DimProduct] ); UPDATE [#DimProduct] SET @MaxSurrogateKey = [ProductId] = @MaxSurrogateKey + 1 /****The clever bit****/ WHERE [ProductId] IS NULL; /*Take another look at the data*/ SELECT * FROM [#DimProduct]
Here's the output:
Notice that our UPDATE statement has generated contiguous surrogate key values for all rows that previously had a NULL surrogate key. Pretty neat huh? Well, I think so anyway!
In March 2012 I launched an initiative called AdventureWorks on Azure in which I hosted the AdventureWorks2012 sample database on Azure so that the SQL Server community at large could use it to get familiar with what SQL Azure Windows Azure SQL Database had to offer. I asked the SQL community to support the initiative by donating money to keep it afloat and that community responded in spades to the point where last month I was able to make a donation to the War Child charity on behalf of that community. In the interim period I added more sample data to the pot, made Northwind available, and also data related to Olympics medal tables down the years.
Today AdventureWorks on Azure takes on a new guise, Steve Jones of SQL Server Central fame announced via a press release that hosting of the database is now to be taken on by his employer Red Gate Software. Here's what Steve had to say in today's announcement:
One of the goals of Red Gate Software is that we not only sell products to the SQL Server community, but that we also participate in the community. In line with our goals of participating in the community, we have agreed to host the AdventureWorks 2012 sample database on the Azure platform. Red Gate has worked to transition this set of databases to our own subscription and will assume the financial responsibility for making this available for the community to use. http://www.sqlservercentral.com/articles/Adventureworks/99290/
This is great news. I no longer have to worry about finding the funds to keep the initiative afloat and the community can feel comfortable that this will be around for the foreseeable future, so thank you to Steve and red gate for this undertaking. Special thanks must also go to David Atkinson at Red Gate who first suggested that they take this on.
I have high hopes that Steve & Red Gate will build upon this with more offerings for the community and equally I also hope I can stay involved somehow. Watch this space!
Its been a couple of weeks since SQLBits XI happened in Nottingham and I thought I'd jot down a few thoughts for posterity.
First the venue. I think its fair to say that the overall consensus was that the East Midlands Conference Centre was the best SQLBits venue these has been so far – I've been to more than half of them and based on my experience I would agree with that sentiment. The hotel especially was top quality – I was pleased with my room and the breakfasts were way better than the Travelodge standards I've become accustomed to at such events. Perhaps the great weather over the weekend helped lift the spirits but I'd say the bar has been set high, I hope future SQLBits conferences are at similar standard venues.
You may have noticed that many of my blog posts over the past year have been related to SSDT and my SQLBits sessions this time around followed that trend. I delivered a session on the Friday, jointly with Craig Ottley-Thistlethwaite, entitled "Real World SDDT" and also delivered my first ever day-long pre-conference seminar on the Thursday entitled "SSDT Database Projects from the ground up". Delivering a pre-con was slightly petrifying and I spent a large part of the three months previous preparing for it; I hope it was worth it. I had 30 attendees which I was delighted with (especially given this was my first pre-con) and we established that the furthest anyone travelled was from Romania, though I'll assume it wasn't just so he could come to my pre-con . I had some pleasant feedback via Twitter afterwards from some of the attendees and I'm crossing my fingers that the official feedback is in a similar vein.
The session I did with Craig went fairly well I thought. I did the first 30minutes where I covered the basics of SSDT deployment from a high level before Craig ratcheted the complexity up a few notches by demoing some interaction between SSDT, MSBuild & Git – really great stuff for those who like to get into the nuts and bolts of this stuff. I was delighted that Craig was willing to do the session with me (in fact it was his idea) as this was his debut public speaking gig and I'm hoping its given him the desire to do more in the future.
On the Saturday my wife's uncle, John Milne, came to the conference. John has been working in customer service for years but of late has decided that he wants a change of career and to that end has been studying an Open University course in IT. He told me he had particularly enjoyed the database-focused modules of his course and hence I suggested he come to the free Saturday of SQLBits to try and get a flavour of what the industry is all about and perhaps learn about some real-world experiences to add to his academic travails. By the end of the day John told me he's had a fantastic time, learned a lot, and was hooked. Mission accomplished I'd say. John lives in Leeds so I introduced him to Chris Testa-O'Neill who helps to run the Leeds user group and John should be going along to some user group events in the near future – if you happen to meet him there please welcome him into the fold!
All that remains for me to say is a massive thank you to the SQLBits committee who do such an amazing job, all voluntarily, in putting this all together. Thank you Simon Sabin, James Rowland-Jones, Chris Webb, Darren Green, Allan Mitchell, Tim Kent, Chris Testa-O'Neill & Martin Bell. I also want to thank all of the volunteer SQLBits helpers that worked tirelessly on the weekend to make sure the whole thing ran smoothly.
Bring on SQLBits XII!
Regular readers of my blog might have realised that I am a huge advocate of subscribable calendars and the data format that underpins them – iCalendar. On 8th Feb 2012 I wrote a blog post entitled SQLBits now publishing all SQLBits agendas as an iCalendar where I told how the SQLBits committee had published the agenda of the forthcoming SQLBits conference in iCalendar format allow with instructions of how one could view the agenda on their phone. Back then I said:
…any changes to the SQLBits agenda (e.g. a room change) will automatically flow to your own calendar service and if you have that calendar service (e.g. Hotmail Calendar, Google Calendar) synced to your phone then the changes will automatically show up there too … That new SQLBits subscribable calendar lives at http://sqlbits.com/information/SQLBitsCalendar.ashx; note how it is not specific to a particular conference - subscribe to (don't import) that calendar and the agenda for future SQLBits conferences will automatically flow to you too.
Sure enough I took a look at the calendar on my phone today and saw this:
(That "Real world SSDT" session at 14:40 is being presented by Craig Ottley-Thistlethwaite and myself by the way. Hope to see you there!)
This is the value of subscribing as opposed to importing. The agenda for next week's conference has already flowed to my phone without my having to do anything. This isn't the same phone that I had a year ago either, by subscribing to it in my Outlook.com (nee Hotmail) Calendar those subscriptions are stored and flow onto any new phone as soon as I type in my credentials.
I have stated before that I believe subscribable calendars to be a transformative technology and this is why, I only had to subscribe to the calendar once and data that didn't even exist back then simply flows into my calendar and thus onto my phone. If this interests you then maybe read how I think the same technology could be used to deliver BI data too at Thinking differently about BI delivery. And if you want to subscribe to the calendar yourself go and read the aforementioned blog post, that link again: SQLBits now publishing all SQLBits agendas as an iCalendar.
SQL Server Data Tools (SSDT) has a neat feature where you can add snippets into your scripts via the right-click context menu:
I'm finding it very useful indeed. The same feature exists in SQL Server Management Studio (SSMS) as well by the way:
One thing I really wanted to be able to do was create my own snippets for SSDT and I ventured to the SSDT forum to ask if it was possible. Turns out the answer is "yes" and Gert Drapers replied to my thread by providing an excellent run through of how to do it. What Gert's post didn't quite clarify is that if you follow his instructions then you have to manually edit the .snippet file that you created so that the language is set to SQL_SSDT:
(well, I had to do that anyway)
Once you do that you'll be able to import the snippet into Visual Studio (Gert's post shows you how) and thereafter your snippets will show up in the snippets menu:
Very handy indeed.
Earlier today I posted the following question on Twitter:
Foreign keys in a data warehouse. Yes or no? This discussion is looming at work, i know my position but am interested in what others think. (https://twitter.com/jamiet/status/324215986729385986)
Specifically, I wanted to know if people were in favour of creating foreign keys from their fact to to their dimension tables or not.
To say it prompted a good response is a bit of an understatement, 38 responses so far and counting. Here are some of those responses:
It certainly seems to be an emotive subject and its clear (to me) that there's no correct answer, just lots of opinions. That's a good thing. The majority of responders appeared to be of the opinion that a data warehouse should contain foreign keys and that is my position too. In this blog post I want to outline why I believe that one should create foreign keys from a fact table to its dimension tables:
Of course, this is the main reason why foreign keys exist – to protect the integrity of your data. I see no reason not to use them for this purpose in a data warehouse. The main argument that I see going against is that with a sufficiently robust ETL solution it shouldn't be necessary. That is true but I would counter with "how do you know that your ETL solution is suitably robust?" I don't think its possible to anticipate every eventuality that may arise and for that reason I like the safety net that foreign keys provide. I liked Devin Knight's response here, foreign keys breed confidence.
When I join a project that has a database in place the first thing I do is try and understand the data model – to do that I go and look at the foreign keys in that database. Understanding the dependencies between entities is crucial in any data model and the best means of communicating those is via foreign keys. If I encounter a database that is bereft of foreign keys then my heart sinks a little.
Foreign keys can, in some circumstances, be beneficial in improving query performance. Take a read of A Check and Foreign Key Constraint Improves Query Performance by Sarvesh Singh or Do Foreign Key Constraints Help Performance? by Grant Fritchey.
I am a big fan of generating ETL code where possible and foreign keys can be invaluable when doing so.
As I said there is no correct answer here so if you have any opinions, either agreeing or disagreeing, I look forward to reading your thoughts in the comments below.
Mark Stacey's comment prompted an interesting digression into talking about surrogate keys for denoting unknown members and this is something I have strong opinions on too:
In short, I don't like the practice of using "–1" as the surrogate key for an unknown member. My reasoning is simple, I don't like giving meaning to something that is supposed to be meaningless. How then should we indicate which is the unknown member? I propose a single-row table that includes a column for each dimension table, each with a foreign key to the unknown member in the respective dimension table.
Moreover I don't like the practice of starting surrogate key counters from 1; the first value available for the integer datatype in SQL Server is –2147483648 so why not start from that?
I discuss both of these issues in much more depth at Considering surrogate keys for Unknown members.
Again if you have any thoughts on these subjects please put them in the comments. If nothing else I find it both fun and educational to debate this stuff.
Update, Chris Adkin posted a comment below that contained a link to Microsoft's own guidance on building datawarehouses where it is stated:
"Many physical designs for data warehouses follow the star schema but do not completely specify the relationships between the fact and dimension tables, as mentioned earlier for foreign key constraints, for instance. Without the foreign key constraints explicitly specified, SQL Server must depend on heuristics to detect star schema query patterns."
Chris' take on this:
"So, assuming we are talking about a Kimball DW, there is most definitely value in using foreign key contstraints as this provides a fail safe for the heuristics getting it wrong."
Thanks Chris.
I didn't travel to the SQL Pass Business Analytics conference this week but I keenly followed what was going on via the #passbac hashtag on Twitter. Seemingly the big announcement was Geoflow Preview for Excel 2013, an add-in for Excel that visualises data over space and time (read more at Public preview of project codename "GeoFlow" for Excel delivers 3D data visualization and storytelling). Geoflow certainly looks compelling at first glance though I must say I found it rather strange that it got top billing given that Microsoft were talking about it at some SharePoint conference five months ago but nonetheless the keynote demo was apparently very impressive indeed. Here's a screenshot of Geoflow:
I think Geoflow looks great, I really do; the questions I immediately had about it were:
So the big reveal from Microsoft at this conference was an Excel add-in that does something very very cool but had already been announced, is only a preview, doesn't fit with Microsoft's BI collaboration strategy, doesn't use their modern distribution platform and isn't part of their Excel-based data visualisation tool. Well thank god I didn't stump up the cost of travel, accommodation, loss of income and time away from the family for that! Doubtless there were a lot of other good reasons to go to the conference but I would have been going with high expectations of news from Microsoft that is going to be compelling and help me sell Microsoft's BI offering to my clients – Geoflow doesn't do that, not by a long chalk.
What I was hoping for, nay expecting, was a concrete announcement regarding Microsoft's mobile BI strategy. We first saw Power View demonstrated on an iPad at the PASS 2011 conference and I assumed that in the intervening eighteen months they might have built something we could actually install and play around with. Apparently not.
Microsoft are getting killed in this area. At my current client all the management folk walk around with iPads glued to their hands – this is the tool on which they consume information and Microsoft doesn't have anything for them. I was working for a client two years ago that had just invested in a product called RoamBI because it enabled them to view Reporting Services reports on an iPad. Two years ago for pity's sake, and Microsoft haven't released anything mobile-BI-related since!
I recently stumbled across a nuance of the SSIS expression language which, when you think about, kinda make sense – but it does help to be aware of it. Its concerned with casting of datetime values using the SSIS expression language
Take the following expression:
(DT_WSTR,30) @[System::ContainerStartTime]
That expression casts a datetime value into a string value. If I evaluate that with my OS Regional Settings set to English (United Kingdom) I see this:
If I set my OS Regional Settings to English (United States) I see this:
Note how that simple change to the regional settings has caused the result of my expression to change. This could have dangerous consequences; for example, if you are using the result of this expression in a dynamically built SQL statement (as I was) then one of two things will happen, either you will get the wrong result or you'll get an error. Observe how, n my dynamically built SQL statement, I'm CONVERTing a string literal (which is constructed using the above expression) to a datetime value:
however with a simple change of my regional settings to English (United States) I see this:
and when you run that particular SQL statement in SSMS:
it blows up!
Definitely one to be aware of! Watch those Regional Settings and their affect on casting of dates in the SSIS expression language!
If you need a failsafe way of constructing a date that doesn't rely on Regional settings then consider something like the following:
(DT_WSTR,4)YEAR( @[System::ContainerStartTime] ) + "-" + RIGHT("0" + (DT_WSTR,2)MONTH( @[System::ContainerStartTime] ), 2) + "-" + RIGHT("0" + (DT_WSTR,2)DAY(@[System::ContainerStartTime] ), 2)
That expression will build a date string with format YYYY-MM-DD (which is the ISO-ratified unambiguous way of representing a date) regardless of Regional Settings:
Just over 12 months ago I published a blog post entitled AdventureWorks2012 now available for all on SQL Azure. In it I explained that I had set up a Windows Azure SQL Database (then known as SQL Azure database) for the SQL Server community to use and hence familiarise themselves with the SQL Azure offering – I called this initiative "AdventureWorks on Azure". Judging by the comments that were left in the table that I set up for that very purpose it seems that a number of people were in favour and made use of it:
The credentials to enable you to connect up and leave your own comment are in that same blog post!
Running a SQL Azure database is of course not free hence I asked for the community to support the initiative by contributing via PayPal to its upkeep. I hoped that there might be enough left over to make a charitable donation and as you have probably gathered from the title of this blog post I'm delighted to be able to say that that did indeed happen. A few minutes ago I made a contribution to War Child (the same charity that the SQL Server MVP Deep Dives book donated to) of £351.49
What do War Child do? In their own words:
We look forward to a world in which children's lives aren't torn apart by war. There's 27 of us in an old false-teeth factory in north London. We're trying to change the world. You could say we're a small charity with big ambitions. We're directly transforming the lives of tens of thousands of children. And we're campaigning to improve the lives of millions more.
There's 27 of us in an old false-teeth factory in north London. We're trying to change the world.
You could say we're a small charity with big ambitions.
We're directly transforming the lives of tens of thousands of children. And we're campaigning to improve the lives of millions more.
Thank you to everyone that made a donation especially to the extremely generous person (who shall remain nameless – you know who you are) that contributed $105.
AdventureWorks on Azure is being provided for the SQL Server community to use and so I am hoping that that same community will rally around to support this effort by making a voluntary donation to support the upkeep which, going on current pricing, is going to be $119.88 per year. If you would like to contribute to keep AdventureWorks on Azure up and running for that full year please donate via PayPal to firstname.lastname@example.com: Any amount, no matter how small, will help.
AdventureWorks on Azure is being provided for the SQL Server community to use and so I am hoping that that same community will rally around to support this effort by making a voluntary donation to support the upkeep which, going on current pricing, is going to be $119.88 per year. If you would like to contribute to keep AdventureWorks on Azure up and running for that full year please donate via PayPal to firstname.lastname@example.com:
Any amount, no matter how small, will help.
Thank you once again to everyone that donated!
In the same way that a map is a natural choice for displaying data with a geography element to it I've long opined that a calendar is a natural choice for displaying data with a time element to it, my main output on this topic is at Thinking differently about BI delivery.
With that in mind I recently watched an interesting talk by James Whittaker entitled A New Era of Computing where he opined that that the era of searching and browsing for information is dying and we are now moving into an era of doing; its an interesting talk and if you have an hour to spare it might well be worth watching, you can find a video of the talk here: http://channel9.msdn.com/Events/ALM-Summit/ALM-Summit-3/A-New-Era-of-Computing
James gave an example of using a calendar as a canvas for booking a holiday and it really struck a chord with me. In this hypothetical example the steps of finding an appropriate time for a holiday, clearing the decks of all other appointments, finding flights and activities….they were all done within the context of a calendar. There were no 3rd party apps involved, no web pages – the calendar was the canvas upon which all of these tasks were done. To someone like me who strongly believes that calendars are massively underutilized as a means for displaying information the notion that a calendar could also be used to get stuff done was both liberating and illuminating.
If, like Scott Adams and I, you agree that calendars are criminally undervalued in an era of information discovery then you could do a lot worse than spend an hour watching James' presentation. Really thought-provoking stuff.
One of the nice things about doing user group presentations is that when you're putting the presentation together you invariably learn about features that were previously unbeknown to you; so it proved as I stumbled upon SSDT's database drift detection features while researching material for my forthcoming pre-conference seminar SSDT from the ground up.
You have probably experienced database drift, you just didn't happen to refer to it as that. More likely you might have spluttered the following, perhaps sprinkled with a few expletives:
In other words database drift can loosely be described as
stuff that appears, gets removed, or gets modified in your production databases that perhaps shouldn't be
If you're using SSDT to manage your database schema then you probably consider the source code in your SSDT projects to be "the truth" and hence anything that appears in your databases that is not in your source code would be considered database drift.
In order to detect database drift using SSDT you must ensure that your database is registered as a Data-Tier Application. This can be done when you publish your database project (i.e. dacpac) by selecting "Register as a Data-tier Application":
Thereafter you can check for database drift on subsequent publishes by selecting "Block publish when database has drifted from registered version":
If you check that box and database drift has occurred then the publish operation will fail and you see an appropriate message in the Data Tools Operations pane, "Publish stopped. The target database has drifted from the registered version.":
Clicking the View Report hyperlink displays the Drift Report which is represented in an XML file:
<?xml version="1.0" encoding="utf-8"?> <DriftReport xmlns="http://schemas.microsoft.com/sqlserver/dac/DriftReport/2012/02"> <Additions> <Object Name="[View_1]" Parent="[dbo]" Type="SqlView" /> <ExtendedProperty HostName="[View_1]" HostParent="[dbo]" HostType="SqlView" Count="2" /> </Additions> <Removals /> <Modifications /> </DriftReport>
In this case a view called [dbo].[View_1] has been added to the target database. That view did not exist in the dacpac that was most recently deployed against the database thus the publish operation fails. Keeping one's deployed databases as "clean" as possible is something that I am all in favour of so personally I think this is a pretty cool feature.
The drift report can be generated by the command-line tool sqlpackage.exe. To do so you need to define:
>SqlPackage.exe /A:DriftReport /tsn:"(localdb)\Projects" /tdn:"Database1" /op:DriftReport.xml
As far as I know there is no support for generating a drift report from SQL Server Management Studio (SSMS). I'm hoping that changes so that this feature gets more visibility.
If you have any comments stick them in the comments section below!
In March 2012 I published SSDT - What's in a name? where I lamented the mistakes that Microsoft made in the naming of SQL Server Data Tools.
…official documentation stating that SSDT includes all the stuff for building SSIS/SSAS/SSRS solutions (this is confirmed in the installer, remember) yet someone from Microsoft tells him "SSDT doesn't include any BIDs components". I have been close to this for a long time (all the way through the CTPs) so I can kind of understand where the confusion stems from. To my understanding SSDT was originally the name of the database dev stuff but eventually that got expanded to include all of the dev tools - I guess not everyone in Microsoft got the memo.
…official documentation stating that SSDT includes all the stuff for building SSIS/SSAS/SSRS solutions (this is confirmed in the installer, remember) yet someone from Microsoft tells him "SSDT doesn't include any BIDs components".
I have been close to this for a long time (all the way through the CTPs) so I can kind of understand where the confusion stems from. To my understanding SSDT was originally the name of the database dev stuff but eventually that got expanded to include all of the dev tools - I guess not everyone in Microsoft got the memo.
Since then I've seen lots of questions pertaining to SSIS/SSAS/SSRS being posted on the SSDT forum on MSDN which, frankly, is the wrong place for them.
With the release of the SSIS/SSAS/SSRS project templates for Visual Studio 2012 Microsoft have attempted to clear up the confusion. Matt Masson from the SSIS product team attempts to explain in his usual jovial way:
note that the component was renamed – we added "Business Intelligence" to the end to distinguish it from the SQL Server Data Tools (Juneau). We now refer to it as SSDTBI, rather than "SSDT, no, not that one, the other one – you know, the one that comes with the SQL installation media, not the one you download". http://www.mattmasson.com/2013/04/installing-ssis-for-visual-studio-2012/
So to clarify, its now:
Got it? Good!
That may all seem slightly confusing but its a darn sight clearer than it was SQL Server 2012 was released over a year ago. And if nothing else you have to be amused with Microsoft's penchant for ever-lengthening acronyms, the last six-letter-acronym I can remember seeing was BODMAS!!!
This is something I've been meaning to blog about for ages but it kept slipping my mind, sorry about that!
Wee Hyong Tok from the SSIS product team has built a slide deck that covers some of the deep secrets about SSIS2012 including:
The slide deck is available to view online at https://skydrive.live.com/redir?resid=BB8E1FF2CE0CD545!252&authkey=!AMFavRXK0aVq314.
As its a slide deck its not quite as good as hearing from the presenter himself however there's still some really useful information in here. If the internals of SSIS float your boat then click through and take a look (there are only 22 slides).
As you may have realised from much of my blogging over the past year or so I'm an advocate of using SSDT database projects for building database solutions on SQL Server. I have been using SSDT database projects a lot in that time and have come up with a checklist of things to consider when starting a new SSDT database project and I'll be detailing that checklist below. I strongly advise you to consider making decisions about these items before you even write a scrap of code as invariably it will be more difficult to change later, especially if you have already deployed your database.
In no particular order here is my checklist:
By default SSDT will not provide a folder structure for new projects in which to store all your script files so you might want to consider setting one up yourself. I recommend not trying to create a large hierarchy of folders to start with as this will evolve as you go about building your database. Here's a simple starter for ten:
If you don't understand the importance of filegroups then read Thomas Larock's recent blog post DATABASE FILEGROUPS: JUST LIKE SEATBELTS BUT WITH LESS CHAFING. Quite often your organisation will stipulate policies for what filegroups you should be using and I highly recommend that you set up filegroups in your database projects to match those policies sooner rather than later. If your organisation does not have any such policies then perhaps think about defining them yourself, Thomas lists a few considerations that may influence your decisions:
If you follow my suggested folder structure above then put your filegroups into the "Storage" folder:
Above all, specify your default filegroup especially as many DBAs won't be happy about you putting objects into the PRIMARY filegroup (which is the default). This is done by right-clicking on the project and selecting "Properties.." When there hit "Database Settings…" and set your default filegroup on the "Operational" tab:
If you intend to use the filestream feature of SQL Server then you can set the default filestream filegroup here too.
If you take only one piece of advice from this blog post make it this: set your collation before you write a single line of code (just trust me on this, OK). You'll find this in Project Properties->Project Settings->Database Settings->Common
Again, find out if your organisation has any guidance on database collation.
SSDT allows you to deploy a project to SQL Server 2005, 2008, 2012 or Azure so it stands to reason that you should specify which you are intending to deploy to. You'll find this in Project Properties->Project Settings:
If you follow the premise that "anything that SQL Server picks as the default is probably wrong" then you should probably think about changing the default schema which, by default, will be [dbo]. SSDT will create all new objects in the default schema (unless otherwise specified).
Generally I'm of the opinion that not accepting SQL Server's defaults is a good idea if only because it forces you to think about these things and be aware of them; in the case of schemas it forces you to think about security and who should have GRANT or DENY permissions and on what.
Specify the default schema in Project properties->Project Settings:
I've mentioned the most important database settings that you should look to change however you should also glance over the rest of the defaults that SSDT chooses for you to verify that they are valid for your project. Again, these are in Project Properties->Project Settings->Database Settings. a few I'd call out as being especially worthy of your attention are:
SSDT always checks the syntax of your database code, that's one of the main justifications for using SSDT database projects. However what it does not do (not by default anyway) is check whether the code you write might be considered good code. That's what Code Analysis is for, your code gets checked to see if it adheres to well-understood good practices for SQL Server database development. For example, Code Analysis will check for use of "SELECT*" which is generally regarded as a bad thing.
Code analysis is turned off by default. I recommend that you head into Project Properties->Code Analysis and turn it on. Moreover I recommend that you check all the boxes under "Treat Warning as Error" – this forces developers to address issues that get raised by Code Analysis.
Add a banner to your Pre-Deployment script as I describe in Big label generator. This may seem rather unnecessary but it takes about 30 seconds and believe me, at some point you'll be glad you did!
The demo project that I took some of the above screenshots from is downloadable from http://sdrv.ms/ZW0gNt and might provide a useful template for your own SSDT database projects.
If you have any more suggestions for my checklist please add them to the comments below!
When you install the database projects template of SSDT you get SQL Server Object Explorer (SSOX) installed as well. SSOX is a pane within Visual Studio and is the main enabler of the Connected Development experience that the SSDT team have attempted to provide.
SSOX provides some really cool capabilities that are not in SQL Server Management Studio (I hope to blog about them in the near future). In theory these capabilities make it possible for a database developer to spend all their time in SSDT (i.e. Visual Studio) thus making SSMS a pureplay DBA tool (this does of course depend on your definition of both a database developer and a DBA, but I'm not getting into that debate here).
With that in mind I have spent a few days trying to work without SSMS, preferring to live wholly inside Visual Studio instead. By and large I was able to do everything I needed to do from within Visual Studio however there were a few nuances about the experience that kept pushing me back to SSMS, I detail those nuances below.
SSOX combines the functions of SSMS's Object Explorer and Registered Servers pane. I don't mind either way of working but it does mean that there is no ability to group servers in SSOX like you can in the Registered Servers pane
In SSMS I regularly use the F6 keyboard shortcut to jump between the query, results & messages panes of a query window. No such keyboard shortcut exists in SSDT and they've already canned my request on Connect to get this fixed (even though it laughably has status "closed as fixed").
UPDATE: See the comments below where Brett Gerhardi informed me of a different keyboard shortcut that does the same thing as F6. Actually its not quite the same, if you have multiple resultsets in your results pane then the behaviour is slightly different to F6 in SSMS - but that's not an issue you'll hot frequently.
The context menu in SSMS provides the ability to change a connection as well as connect and disconnect:
SSDT doesn't have change connection and believe me, you don't know how much you use a feature until its not there:
There's also no hotkey to jump to "Connection" on the context menu like there is in SSMS ("C") and I find that annoying too.


text:
D-LED Backlit
Thin bezel design, high power efficiency and stunning image quality with enhanced contrast ratio
CrystalColor™ technology produces brilliant colors, sharp & vibrant images, and lifelike pictures for an unbelievable viewing experience.
2 HDMI ports supporting CEC allow you to take control of all HDMI connected devices* with one remote HDMI-1 supports ARC that simplifies TV and AV receiver connection** by eliminating optical cable
Manufacturer: |
Victor Company of Japan, Limited
Manufacturer Part Number: |
Manufacturer Website Address: |
Brand Name: |
Product Line: |
Product Model: |
Product Name: |
EM32T 32" Class, HD 720p, D-LED HDTV
Product Type: |
I didn't purchase this television through overstock, but through a local store with a 90-day return policy. 30 days after the 90-day return period, the television started acting up. This review goes more toward JVC's customer service than the television itself. While the TV worked, it was fine. However, if you have a problem, JVC makes it almost impossible to return. They have to mail you a label, then you have to ship the television out of state (unless you live in California; I live in the 5th largest city in the U.S. and there is no JVC authorized service dealer). In real time, you are talking about a month to fix your television. When you call JVC, you are transferred to a special department that handles this television. I think the department is staffed by two people for the entire country. I have yet to be able to reach a supervisor, who is either "not in the office yet" or dealing with what they call other "escalations" (I think this refers to customers who are at the end of their rope). This experience has cured me of EVER purchasing another JVC product.
The items must arrive at our warehouse within 30 days of purchase. You must return items in their original condition to qualify for a full refund. We will issue a partial refund of up to 70 percent if returned items have been opened, used, or returned late.
More details
Our standard shipping method is ground shipping. We also offer expedited shipping for most items. Your final shipping cost and estimated delivery timeframe will be available at checkout.
Standard shipping details
Expedited shipping details
* For your safety, some orders go through our loss prevention department. If we select your order for this process, we will immediately notify you that there may be up to a 3-day delay on your order.
** Most Oversize orders are delivered within 1-4 weeks. Some orders may take 6 weeks to be delivered.


text:
The Thorns
The greater Miami area, where I was born and raised, is one of the most developed regions in the entire state of Florida. There are hardly any wilderness areas left in the midst of the urban sprawl, but every so …Read More
Crossing the River
Charles Haddon Spurgeon said he had read Pilgrim's Progress one hundred times. Alexander Whyte said he had read it almost as often. These two giants of the British pulpit have been called the "last of the Puritans," so thoroughly immersed …Read More
Church Growth and the Sovereignty of God
It seems that every time I meet a pastor from another church, he asks me the common, unsolicited, ecclesiastical question of the twenty-first-century: "How big is your church?" Most pastors are usually a bit confounded when I respond: "I don't …Read More
Jesus and the Psalms
The Writings
"What do you think of the Christ?" In guiding the Jerusalem leaders to contemplate this question of eternal weight, Jesus turned to the authority of what is written "in the book of Psalms," specifically Psalm 110 (Matt 22:41–46; …Read More -
Will Man Rob God?
In the last book of the Old Testament, God spoke through the prophet Malachi. He raised a provocative question: "Will man rob God?" This is somewhat startling because it suggests something that on the surface would appear to be impossible. …Read More
Irresistible Grace
In reference to all the aspects from which God's saving grace may be viewed we must always reckon with the reality and gravity of sin. The salvation God has provided is more than salvation from sin and its consequences. Its …Read More
Comforting Eve
There are countless places in the Bible that will comfort Christians in their trials or encourage them in their obedience through reflection on the things that are to come. Perhaps it is too common (and unhelpful) to reduce these things, …Read More
The Great Exchange
"In the cross of Christ, as in a splendid theater, the incomparable goodness of God is set before the whole world. The glory of God shines, indeed, in all creatures on high and below, but never more brightly than in …Read More
Progress Redefined
The world measures success in terms of that which is tangible — by what is bigger, faster, and by what draws the most attention. For many people, success is defined solely by numbers and circumstantial outcomes. True success, however, cannot …Read More
The Fruit of Patience
The prophet Habakkuk was sorely distressed. His misery was provoked by the spectacle of the threat of the pagan nation of Babylon against Judah. To this prophet it was unthinkable that God would use an evil nation against His own …Read More
Browse select Tabletalk articles and columns exploring themes and topics across a spectrum of relevant issues.Topics
- All
- Angels and Demons
- Atonement
- Basic Reformed Theology
- Irresistible Grace
- Limited Atonement
- Perseverance of the Saints
- Total Depravity
- Unconditional Election
- The Church
- Church Discipline
- Church Leadership
- Creeds and Confessions
- God
- Holiness
- Sovereignty
- Heaven and Hell
- Heresies
- The Holy Spirit
- Jesus Christ
- Cross
- Incarnation
- Resurrection
- Justification
- Last Things
- Man and Sin
- Sacraments
- Salvation
- Faith
- Regeneration
- Scripture
- Systematic Theology
- Theological Views
- Roman Catholicism
- Music
- Apologetics
- False Teaching
- Atheism
- Book Reviews
- Children's Books
- Christian Classics
- Christianity and Culture
- Creation
- Ethics
- Fiction and Literature
- Philosophy
- Science
- Bible Figures
- Bible Interpretation
- Bibles
- Books of the Bible
- Gospels
- Covenants
- Introduction to the Bible
- Jesus' Ministry
- Life of Jesus
- New Testament
- Old Testament
- Parables
- Prophecy
- Sermon on the Mount
- Ten Commandments
- The Lord's Prayer
- Controversies in the Church
- Alcohol
- Arts
- Bible Translation
- Covenant Theology
- Creationism
- Education
- Gender-Neutral Language
- Law and Gospel
- Lordship Salvation
- New Perspective on Paul
- Politics
- Race
- Sabbath
- Spiritual Gifts
- Women in Ministry
- Marriage and Family
- Divorce
- Parenting
- Practical Theology
- Discipleship
- Evangelism and Missions
- Grief and Death
- Pastoral Ministry
- Preaching
- Worship
- Spiritual Growth
- Anxiety and Worry
- Assurance
- Conscience
- Depression
- Doubt
- Fellowship
- Godliness
- Guilt
- Humility
- Joy
- Knowing God's Will
- Legalism
- Love
- Money and Stewardship
- Oaths and Vows
- Prayer
- Pride
- Repentance and Forgiveness
- Sanctification and Growth
- Service
- Spiritual Fruit
- Suffering
- Thankfulness
- Vocation
- American Church History
- Ancient Church
- Biography
- Eighteenth Century
- Historical Theology
- Medieval Church
- Nineteenth Century
- Puritanism
- Reformation
- Seventeenth Century
- Twentieth Century


text:
Make a gift
Photo Gallery
Prospective Students
ABA Required Disclosures
Admission Information and How to Apply
Admitted Students
Campus Life Services
Contact Information
Learn About Our Students
Office of Financial Aid
Recruitment Events
Tours and Class Visits
Visit the Campus
Tuition and Fees
Student Services
Academic Calendar
Academic Standards
Academic Support
Courses and Curriculum Guide
Dean of Students Office
Student Journals and Organizations
Registrar/Records Office
Currently selected
All Faculty Profiles
Faculty by Area of Expertise
Recent Faculty Scholarship
Faculty Support Services
Alumni Services
Alumni E-mail Services
Alumni of the Year 2013
Alumni Spotlight
Campaign for UCLA School of Law
A Celebration of Legends
Class Gift Campaign
Class Notes
Contact Us
Law Advisory Boards
Law Alumni Association
Law Firm Challenge
Letter from Dean Rachel F. Moran
Loan Repayment Assistance Program
Make a Gift
Transcript Request
Ways to Give
News and Media
Recent News
Faculty Op-Ed Articles
Media Advisories
Press Releases
UCLA Law in the News
Faculty by Area of Expertise
Recent Faculty Scholarship
Contact Us
Academic Programs and Courses
Degree Programs
Clinical Program
Centers and Programs
Visiting Scholars and Researchers Program
Foreign Legal Study and Exchange Program
Career Services
Our Services
Current Students
Prospective Students
New Graduate Opportunity Program
Employment Statistics
UCLA Law Policies
Law Library
Library Hours
Access to the Law Library
Online Library Tour
General Policies
General Services
Recent Acquisitions
Library Research Guides
Library Services for UCLA Law Students
Library Services for UCLA Law Faculty
Library Staff Directory
Law Library on Facebook
Centers and Programs
Center for Law and Economics
Clinical Program
Critical Race Studies
David J. Epstein Program in Public Interest Law and Policy
Emmett Center on Climate Change and the Environment
Empirical Research Group
Entertainment, Media, and Intellectual Property Law Program
Environmental Law
Globalization and Labor Standards
Health and Human Rights Law Project
International and Comparative Law
International Human Rights Law Program
Law and Philosophy Program
Lowell Milken Institute for Business Law and Policy
Native Nations Law and Policy Center
Negotiation and Conflict Resolution
Office of Graduate Studies and International Programs
Office Of Public Interest Programs
PULSE - Program on Understanding Law, Science, and Evidence
Sanela Diana Jenkins Human Rights Project
UCLA Rand Center for Law and Public Policy
Resnick Program for Food Law and Policy
UCLA Sustainable Technology and Policy Program
Williams Institute on Sexual Orientation Law and Public Policy
Ziman Center for Real Estate
Workshops and Colloquia
Endowed Lectures
Legal Theory Workshop
Tax Policy and Public Finance Colloquium
Monday Colloquium
Entertainment, Media, and Intellectual Property Colloquium
Friday Colloquium
Negotiation and Conflict Resolution Colloquium
Poverty and the Bureaucratic State: A Symposium in Honor of Joel Handler
Sanela Diana Jenkins Health and Human Rights Series 2014
UCLA Law and Economics Workshop
All Faculty Profiles
Faculty by Area of Expertise
Recent Faculty Scholarship
Faculty Support Services
All Faculty Bibliographies
UCLA School of Law
All Faculty Bibliographies
Jonathan M. Zasloff
Professor of Law
B.A. Yale, 1987
J.D. Yale, 1993
M.Phil. International Relations, Cambridge, 1988
M.A. History, Harvard, 1990
Ph.D. Harvard, 2000
UCLA Law faculty since 1998
Articles and Chapters
Why No Parliaments in the United States?, 43
Rutgers Law Journal
(forthcoming 2013). Annual issue on state constitutional law.
Full Text
Courts in the Age of Dysfunction, 121
Yale Law Journal Online
479 (2012).
Full Text
India's Land Title Crisis: The Unanswered Questions, 3
Jindal Global Law Review
117 (2011).
Full Text
The Housing Market Effects of Discrete Land Use Regulations: Evidence from the California Coastal Boundary Zone (with Matthew Kahn & Ryan Vaughn), 19
Journal of Housing Economics
269-79 (2010).
Full Text
The Secret History of the Fair Housing Act,
UCLA School of Law Working Paper Series, Public Law & Legal Theory Working Paper No. 10-21
Full Text
Choose the Best Answer: Organizing Climate Change Negotiation in the Obama Administration, 103
Northwestern University Law Review: Colloquy
Full Text
Dean's List: Power, Institutions, and Achesonian Diplomacy, 103
American Journal of International Law
375 (2009). Review of
Dean Acheson: A Life in the Cold War
, by Robert L. Beisner.
Full Text
Cities, Land Use, and the Global Commons: Genesis and the Urban Politics of Climate Change (with Katherine A. Trisolini), in
Adjudicating Climate Change: State, National, and International Approaches
(edited by William Burns & Hari Osofsky, Cambridge University Press, 2009).
Full Text
International Decision:
Massachusetts v. E.P.A
., 102
American Journal of International Law
134 (2008).
The Judicial Carbon Tax: Reconstructing Public Nuisance and Climate Change, 55
UCLA Law Review
1827 (2008).
Full Text
Left and Right in the Middle East: Notes on the Social Construction of Race, 47
Virginia Journal of International Law
201 (2006-2007).
Full Text
Some More Realism About Realism: Dean Acheson and the Jurisprudence of Cold War Diplomacy,
UCLA School of Law Working Paper Series, Public Law & Legal Theory Working Paper No. 07-01
Full Text
Power and International Law (with Richard H. Steinberg), 100
American Journal of International Law
64-87 (2006).
Full Text
Roadblocks to the Road Map: A Negotiation Theory Perspective on the Israeli-Palestinian Conflict After Yasser Arafat (with Russell Korobkin), 30
Yale Journal of International Law
1 (2005).
Law and the Shaping of American Foreign Policy: The Twenty Years' Crisis, 77
Southern California Law Review
Full Text
Taking Politics Seriously: A Theory of California's Separation of Powers, 51
UCLA Law Review
1079-1150 (2004).
Full Text
Smart Growth,
Southern California Environmental Report Card
12-19 (2003).
Tiebout & Tax Revolts: Did Serrano Really Cause Proposition 13? (with Kirk J. Stark), 50
UCLA Law Review
801-58 (2003).
Full Text
Law and the Shaping of American Foreign Policy: From the Gilded Age to the New Era, 8
NYU Law Review
239-373 (2002).
Full Text
Environmental Justice (with Ann Carlson),
Southern California Environmental Report Card
22-31 (2001).
Children, Families, and Bureaucrats: A Prehistory of Welfare Reform, 14
Journal of Law and Politics
225-317 (1998).
The Tyranny of Madison, Review of South Africa's Crisis of Constitutional Democracy: Can the U.S. Constitution Help?, 44
UCLA Law Review
795-864 (1997).
Abolishing Coercion: The Jurisprudence of American Foreign Policy in the 1920's, 102
Yale Law Journal
1689-1719 (1993).
Commentary: The Legacy of Elihu Root, 100
Proceedings of the American Society of International Law
213 (2006).
Book Review, Max Lerner's Judicious Review,
The Boston Globe
(Aug. 9, 1994). Reviewing
Nine Scorpions in a Bottle: Great Judges and Cases of the Supreme Court
, by Max Lerner.
Book Review, The Varied Domain of Thurgood Marshall,
The Boston Sunday Globe
(June 19, 1994). Reviewing
Making Civil Rights Law: Thurgood Marshall and Supreme Court, 1936-1961
, by Mark Tushnet.
Book Review, The Judge's Judge,
Wall Street Journal
(Dec. 30, 1993). Reviewing
Justice Oliver Wendall Holmes: Law and the Inner Self,
by G. Edward White.


text:
I'll mention they charge $19 for a seat reservation. I don't know how that compares to other carriers. You can pick your seats on online check in before the flight for free.
I am trying to book a flight from Chicago to Berlin on May 30.
The price for this ticket with the return date of June 24 is $690.00. If you change the return date to July 8, the price goes up significantly. I am planning on returning in July but I cannot pay $1,500.00 for the return date in July. Here is what I discovered, though: I found a flight with Air Berlin to Copenhagen with a stop over in Berlin with the return date on July 10 for about $830.00. The flight from Chicago to Berlin is the exact same flight number as the flight from Chicago to Copenhagen with the stop over in Berlin. I am thinking of just buying the cheaper ticket and NOT taking the plane from Berlin to Copenhagen, and then I would like to do the same on the way back. It should not be a problem going from Chicago to Berlin but I am afraid that they will cancel my ticket on the way back since I will NOT show up at the airport in Copenhagen. Has anyone done this? Does the Airline care if I don't show up on one of the connecting flights? Any help will be appreciated. Thanks! |
Here's a money saving tip. Buy a Bahn Card. The short term trial card will save you 25% on all train rides. If you book far enough in advance you can get some crazy cheap prices. I've gone FRA-CGN for 19 euros roundtrip. That's before the 25% off with the bahn card. Even taking one trip can pay for the bahn card. |
Thread Tools | Search this Thread |
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Washington DC - Istanbul $399 RT w Taxes on Turkish Airlines | jreuschl | Deal Talk | 532 | 03-16-2013 06:47 PM |
Fantom Drives MD3U3000 Gforce3 MegaDisk 3TB USB 3.0/2.0 External Hard Drive - RAID (RAID 1, 0, JBOD, Spanning) - $159.99 + FS + (Tax in CA CT MA IL NY TN and WA) | janusman | Hot Deals | 5 | 11-04-2012 05:54 AM |
Canon EOS Rebel T3i Digital Camera Kit w/18-55 Lens Canon EOS Rebel T3i Digital Camera Kit w/18-55 Lens - $649 + FS + No Tax in Most States - ibuysonline | allyrocky | Hot Deals | 6 | 01-05-2012 05:09 PM |
Turkish Airlines Chicago - Istanbul RT $592 for Fall 2011 - $498 for Spring 2012 (Dec 10 - Jan 10 blackout) | demirhan13 | Hot Deals | 4 | 06-23-2011 12:35 PM |
JFK - Berlin, Germany (TXL) - $331+ RT - limited dates in April | theferryman | Hot Deals | 13 | 03-27-2011 08:36 PM |