Patio Furniture

May 26th, 2008 by Administrator

There is a variety of patio furniture available and you have to make a selection of the best that suits your patio. Various online stores are available and you are able to see various kinds of furniture. In this article I have outlined some of the furniture which you should consider to purchase and make your patio look majestic.

Victoria deep seating which is one of the best teak seating, will add your patio with big and deep soft cushion. Solarteck umbrella is ideal for your patio which will give a cool shade and protection from sunlight. Lagoon lights will make the place look tropical and these lights are made from hand-crafted wood plant vines. You can also include the infinity clocks which are suitable for both indoor and outdoor and these clocks are so beautiful ranging from the traditional antique styles to decorative styles. Having table lamps will also create a good atmosphere for your patio and making the place look executive. Generally when you are deciding to buy patio furniture you should take your valuable time selecting the best and it should match with all your items such as the floor and wall. I would recommend that you should place the best furniture in your patio and this place will make you experience the great comfort of your home.

Posted in Uncategorized | Comments Off

MousePads Can Do It.

May 25th, 2008 by Administrator

Mousepads: A promotional give-a-way is an article presented free of charge to the populace in an effort to facilate business or create interest in, or sales of, a product or service. Often given out at trade shows, used in direct mail as a marketing campaign. Promotional advertising items are also utilised in politics to further customers and different causes. custom promotional products are many times used by organisations, and schools often as a part of fund raising. Business concerns* are forever searching for a plausible way to grow their company’s brand in front of expected customers. One excellent way was used 1st in 1957. It was a tee shirt with an print on it. The advertisement space on a t-shirt is some 150 square inches which makes this a nifty walking billboard and one of the best ways to place the business content to the end user! Another great item that can be used is a mouse pad. This is an item that will be used by almost anyone and has the ability to get your advertising message right under your customer’s nose. We have mouse pads with vivid 4 color process imprint unlike any other company. Our color is continuous color image where as everyone else useses a dot pattern. The difference is the same as comparing a newspaper to a photo. So if you want state of the art color mouse pads give us a call. Sixty three square inches of billboard advertising space can be placed right under your customer’s nose. Just think how nice it would be to have your company name and your products as well as your phone number 15 inches from your customer 8 hours a day. You can with custom imprinted mouse pads.

.

Posted in Uncategorized | Comments Off

Gaming Houses Putting Up Wagering: A Word of Guidance

May 25th, 2008 by Administrator

The difficulties of going to a physical gaming establishment can be sufficient reason to forget about it altogether. Traffic jams, the difficulties, and task list required are too much to justify the distress only for the chance to test the odds at physical gaming establishment, still, provided you are the sort of gal who is totally taken in by bets then opting for virtual gaming establishments should be the more obvious solution.

You’re not required to leave your home to try your hand at online roulette etc for the reason that you’ll do everything from your own home if you have access to a functional computer and, obviously, a broadband Internet connection. Nonetheless, you’ll want to continue reading, as there’s a good number of hints which you must appreciate regarding online roulette etc, notably if you are a greenhorn in this area. So dampen your tizzy to consider what follows here. Here is my framework that elucidates what to pay attention to if you’re determining a reputable, secure online roulette etc web site.

The very first thing which a cagey virtual wagerer like you definitely should check out is an online roulette etc Web site of the category capable of promoting top odds. Establish for certain that the online roulette etc Web site has a tie-up with a reputable, secure certified public accountants firm so as to evaluate the specific casino games’ pay-out odds regularly. This is quite constructive to establish the pesos you plan to be betting during your planned amusement would actually justify the trouble.

You must take care to check that the virtual roulette etc Web site holds a valid license, for instance by exploring the operating permit as disclosed on the casino site’s webpage. If you are unable to unearth any operating permit on any given virtual roulette etc Web site, don’t try to lay your bets there.

Further advice would be to place your wager for beginners with lesser amounts in place of loosing so much it will hurt on the spot. Check, first of all, the stability of this particular virtual roulette etc framework prior to running any undue injury– notably money loss… Arguably the most substantial prompt regarding online video poker. It is bound to be this- always to bear in mind that online casino betting should be about enjoyment rather than big winnings. Wagering isn’t a job, but, instead, a diversion which intends to help you become jolly and your overall life gratifying. Tips and tricks for online casino online review.

Posted in Uncategorized | Comments Off

Replace Your Wedding DJ With An iPod

May 25th, 2008 by Administrator

Whether its true or not, most everyone agrees that wedding DJs are expensive. A popular tip circulating the net is to replace your wedding DJ with an iPod and DJ your reception yourself. While this may sound like a great idea, there are some things to consider. Just as with any do-it-yourself project, you must be aware of all facets before you start.

The first most important job for a good DJ is to play music that the crowd enjoys. A simple shuffle has no way of knowing who is dancing to what. A person does need to run things, but not just any person will do. Putting your 12 year old nephew won’t do you any good. The person in charge of the music needs a large amount of music knowledge. A good DJ should have this knowledge. A good DJ should be able to identify a song based on a few bars hummed out of tune or a snippet of lyrics that are slightly incorrect. Your DJ must not have a fear of speaking in front of a crowd, and this is not as easy as it sounds. One simply has to think of all the Best men who have hemmed and hawed their way through a wedding toast with the microphone held at waist level. Also, does he/she know how to auction off a garter or any of the other traditional reception activities? If not, will the bride and groom want to do these things while they should be enjoying their guests? Oh, and just like you would give your wedding singer or officiant a tip for performing your ceremony, don’t forget a gratuity for your impromptu DJ.

Unless you’re a music collector, chances are you don’t have a music library with waltzes, polkas, old country, new country, oldies, classic rock, new rock, soft rock, hard rock, hip hop, dance, etc. And, unless you want to subject your guests to your musical tastes, you should probably buy a selection of these songs. If you’re not up on popular waltzes and polkas, or don’t know which songs are currently topping the country Top 40, search the web. $25 dollars should buy you enough music on iTunes to cover enough various musical tastes that most guests will enjoy themselves.

Another task for a good wedding DJ is one who is covered by insurance. Sure, your homeowners policy *might* cover it, but I’d hate to see your premiums next year if an accident does occur. Don’t think accidents will happen to you? Are you serving alcohol at your reception? If you’re telling yourself, “All the drunk people I know never act like fools!”, stop and think about that again. Besides, many venues require proof of insurance because they don’t want to see their premiums raised because your grandma tripped on a speaker cable and broke her hip. Searching the web for “wedding event insurance” will yeild a whole crop of insurers who will give you a $1 million dollar policy for around $200.

Equipment is of course another important factor a good DJ brings to your reception. Do you know where to get speakers? Or mics? Or Mixer?? Larger cities will have rental companies that can provide these things. You can even find many such companies by searching the web for “dj equipment rental”. Most wedding sized systems rent for anywhere from $250 to $500 dollars per day. In most cases, you must provide a truck or van to transport the equipment. Now, do you know how to set these things up? If not, will the rental company give you a tutorial? Some rental companies will give you a tutorial when you pick the equipment up, but make sure to take notes, because if you have to call them later they will likely charge you for a service call. Some equipment rental companies will deliver, setup, and test their equipment as well as pick up later, but this is extra.

That being said, if you KNOW your group will interact without being prompted (or just don’t care if they interact or not), and if you’ve got a person with an encyclopedic knowledge of music that will run your iPod (instead of enjoying your reception), and you have adequate insurance to cover any accidents that occur due to your iPod setup, and you have a large enough music library to make sure everyone gets to hear the music they want, and you’re able to get your hands on adequate dance lights and speakers, and will be saving money by spending $550 to $700 then by all means use an iPod. You honestly have no need for a DJ.

If planning and organizing all this sounds like just one more hassle, you’d probably do better to hire a professional so that you can enjoy your reception and spend your first day as husband and wife doing something besides returning rental equipment. For a few dollars more you’ll get professional equipment, professional knowledge from someone who has planned and performed at hundreds of weddings, peace of mind that any glitches will be resolved quickly, no hassles about tearing down equipment when the reception is over, and no worries about getting it back before you owe another day’s worth of rental fees.

Tim and Tammy Smith own and operate By Request DJ & Karaoke Company in Fargo, ND. They have performed at over 1000 wedding receptions in their 15 years of business. Visit their site at http://www.byrequest.dj

Posted in Uncategorized | Comments Off

Presenting for People Starting out in Business

May 25th, 2008 by Administrator

In some ways, the time when you’re setting up your business is just like any other point in the life-cycle: what you want to do is concentrate upon your ‘core’ activity (making widgets) but what you’ve got to do is spend half your time on irrelevant fripperies (selling widgets). Once your company is up and running you’ll be dealing with actual widgets; up until that point you’ll be selling the just the idea of the widget factory… that means you’ll be making presentations. Like it or not, at some point you’ll be doing at least one or two of this list:

  • outright competitive pitches to Venture Capitalists or Business Angels
  • presentations to bank managers
  • meetings with business partners (or potential business partners)
  • selling the concept to organisations like Business Link
  • doing a one-minute ‘elevator pitch’ at networking meetings
  • talking to colleagues, superiors and subordinates.

    In short, presenting yourself and your idea is a basic fact of business life and setting up a business, so you’ll need to be good enough at it. The words are carefully chosen there – you don’t need to be “good”, just “good enough”. That’s a useful thing to remember because it makes the job of training yourself that much easier. So the story so far is that you’ve got to make presentations but that they’re not as difficult as you might suppose – we’re not looking for great orators here, just people with enough about them for the audience (think of whoever you’re talking to as an audience and you won’t go far wrong) to get the picture.

    I’m going to break down the process of making the presentation into three parts: the first is the obvious one of what you say. The second is the corollary of that – how you say it. The third part is what’s referred to as the meta-language of how you look (and dress and so on) while you say it.

    To be honest, the first is outside the scope of an article like this: there are other articles on this site that should help you with that.

    The second part, how you say it, is absolutely critical. The last one is also important (but not as important as you’ll be told by many NLP trainers who base their work on a mis-understanding of some good, experimental psychology).

    So, back to business.

    It’s likely that when you’re making some kind of pitch for your business you’re likely to be nervous. I know I always am. When you’re under stress, the body has a set of physiological responses designed to deal with the emergency: it’s called the “fight or flight syndrome” and you’ve probably heard of it. It’s very good at what it does, but unfortunately ‘what it does’ is designed to work in a much more primitive environment than today’s business one – one where you were literally going to have to fight for your life or run away. One of the things your body does is start to use your upper chest for breathing with, in order to get oxygen into your lungs faster, which is great for fighting but no good for talking. To talk you need to try and remember to use your diaphragm to breathe in (and therefore breathe out). The diaphragm is the big sheath of muscle underneath your lungs and above your stomach area. If you can use that when you’re making your pitch lots of good things will happen.

    The first, and most important is that your voice will firm up. It might go deeper, but it might not. Generally though, what it will do is sound richer and fuller – in short, you’ll sound more interesting and more credible. When you’re making a pitch, credibility is important. The second thing it will do is begin to calm your nerves. This is because there’s a part of your brain that is fooled into thinking that, because you’re breathing like there’s no threat, there really is no threat. The consequence is that your body chemistry is altered towards a relaxed, almost sleepy state. Don’t worry about becoming too drowsy, there’s no chance of that, but it should make your whole voice and demeanour a lot more relaxed and confident. The third thing that will happen is that you’ll actually have more stamina and a better oxygen flow over the longer term. That in turn means that you’ll be more tuned in to what’s going on around you: basically, you’re likely to start thinking faster.

    Moving up from your lungs, the next part of your “speaking system” is your throat. This is where the actual sounds of your voice are made, as airflows between your vocal folds. Again, when your body is under stress, you’ll probably react like the vast majority of the population and tense up your shoulders and your throat. That’s bad. This constricts your throat and stops the vibrations of your voice being made so easily – or so well. The consequence is that horrible “nervous voice” sound that everyone has heard (coming from other people as well as themselves, usually). The solution is pretty straight-forward. Breathing from your diaphragm is going to help but you’ll need also to make sure that your shoulders, head and body are positioned in the right relationship to each other.

    If your neck (and hence your throat) is twisted you’re reducing the amount of vibration your vocal folds can achieve, so make sure that you’re facing forwards when you speak. If that means you’ve got to turn slightly, in order to face whoever you’re talking to, then do so. What’s more, once we’re stressed we all have an instinct to tip our heads back – to raise our eyes – but once again this constricts the throat and makes your voice sound thinner and less mature. It’s important to make sure that you’re not tipping back: it’ll probably feel awkward difficult at first because most people are accustomed to raising their head too far, but once you’ve got the hang of it you should find it becomes second nature.

    The balance point for your head that you’re looking for is the position where your head is resting on your neck in as “effort free” way as it can possibly be. Stand for a few minutes checking out your head position, making a conscious note of how much effort you’re putting into holding it in one particular position compared to others. I want to give you a word of warning here – be careful not to get confused between the position in which you’re actually doing the minimum amount of work and the position where it feels like you’re doing the minimum; this position is almost certainly related to having become habituated to standing in a certain way, and so your muscles are used to doing that particular amount of work.

    Keep at it – little and often – because it’s quite a subtle thing.

    Make sure that while you’re doing this a few other things are also taken care off. For a start, make a point of remembering to breathe: you’d be amazed at the number of people who concentrate so hard on the position of their heads that they hold their breath. Secondly, drop your shoulders. Now drop them again, because almost no one drops them fully the first time: make very sure that no tension creeps back into them (or your arms, or your hands) while you’re working. Don’t assume that you’re relaxed, check. Thirdly, make sure your breathing is from your diaphragm, not your upper chest. (I actually put my hands on my diaphragm and my chest to make sure when I’m doing this.)

    Lastly, relax the muscles of your bottom. It’s impossible to relax your body if your bottom is tight. It might make you feel like you’re slouching, but it’s worth it in terms of how much better you’ll sound.

    The last part of your “talking system” I want to mention here is where the sounds you make in your throat are converted into words – your mouth.

    The key thing to remember is to warm up your muscles here. Almost everyone lets these muscles atrophy a little, and under-uses them. What you think of as you doing an over-the-top impression of Noel Coward or the Queen is probably just clear speaking to someone else. Make very sure that your lips are working very hard as you talk.

    The key to warming them up, by the way, is a simple one. There are lots of exercises I give people to get them doing this when I’m giving courses and classes, but the key things to do are to yawn and to rub your face.

    When you yawn make sure it’s not a polite, behind-the-hand, stifled thing. I’m talking about the kind of thing your cat does that looks like it’s going to dislocate it’s jaw. This has the added advantage, by the way, of clearing out build-ups of carbon dioxide from the lower parts of your lungs and thus making you feel more awake. When you rub your face, use the same kind of motion you use when you’re giving yourself a vigorous wash in the morning. The area to cover is the area of your beard (if you’re a man) or the area where you would be rubbing a beard if you had one (if you’re a woman smile ).

    Pay particular attention to the top lip. This isn’t because it needs more warming up than the other parts but simply because it’s very easily overlooked as people put their hands to their faces.

    Put all this together and you should have a much, much better chance of making your pitch sounding cool, collected, mature, credible and relaxed. You never know, you might even end up enjoying it!

    The things that go with how you sound are pretty straight-forward, common sense type things. The basic rule is to be ever so slightly more formal than you need to be (how formal you “need” to be is taken here as meaning “as the other person expects you to be”). Don’t over do it – and tend towards the conservative.

    Things to avoid are gimmicks such as dangly ear-rings, picture ties, plunge neck-lines and so on. The focus of what you’re trying to do is get your audience listening to what you’re saying, not seeing how far up your skirt they can see (consciously or sub-consciously) or watching the flashes from your gold watch as it catches the light or whatever. Patterns are generally a no-no.

    Colours are a matter of personal style but a few tips to bear in mind are that black looks severe and robust (but few people suit it) while red is generally interpreted as a physical colour; blue as an intellectual one and green as a balancing one (and few people suit green either!). Golden-yellow is often interpreted as a power colour. One combination I particularly favour when I’m making a pitch therefore is: black trousers, mid-blue (corporate) shirt and a rich, deep yellow tie.

    And that’s it!

    I’ve simplified and skipped things, but you should have got a reasonable idea about the basics from this article. If so, I’m pleased; why not drop me a line and say so. If you’ve not got anything out of it, why not drop me a line in any case and I’ll try and help. Enquiries should be to me by email at sme@curved-vision.co.uk

    Above all, remember that your voice is unique to you and that the most important thing is to have fun. No one will be as critical of you as you are of yourself, ever, so just enjoy!

    Dr Simon Raybould is a trainer and author specialising in business presentation skills. His latest business presentations ebook is available now and his training courses are available for people living in the UK.

  • Posted in Uncategorized | Comments Off

    Weight Loss vs. Fat Loss

    May 24th, 2008 by Administrator

    In order to lose weight, your body must burn more calories than
    it takes in, but keep in mind that your body needs calories for
    energy and when you exercise; your body needs even more calories.
    Before I talk about energy, the first thing you must understand
    is that losing weight and losing fat is not the same thing.
    Just because you lose weight, does not mean you lose fat, and
    just because you lose fat, does not mean you lose weight. When
    people talk about losing weight, what the really want to do is
    lose the excess fat on their body and obtain an attractive
    figure.

    When you eat, the body uses most of the calories for
    energy. If you eat more calories than the body uses, it will
    get stored as fat. If you do not consume enough calories per
    day you will lose weight, but you will also lose energy. When
    you do not consume enough energy (calories) for your body, it
    will start using up your energy stores to make up for the energy
    deficiency. Unfortunately, the energy stores used is not your
    stored fat, but instead it’s protein and carbohydrates (carbs)
    that will supply most of the energy (stored fat makes up a very
    small percentage). Your body will take the protein and
    carbohydrates from your muscle cells; causing your muscle mass
    to reduce (say goodby to that toned attractive look) which
    forces your metabolism to decrease (a low metabolism = slow or
    no fat burning). When this happens your body requires less
    energy to maintain its new lower body weight (remember the body
    weight is lower because you loss muscle), which is why your
    body conserves energy by slowing down the metabolism. In other
    words, the body has adapted to the new lower energy (calorie)
    intake which means that you will no longer continue to lose
    weight.

    Keep in mind that the weight you had lost in the first place
    was mostly water weight and you will eventually gain it back
    in the form of fat, not muscle (in order to get your muscle
    mass back to the way it was before, you have to work on
    rebuilding it). When carbohydrates and protein that are already
    in your body are used as the energy source, your body will lose
    water weight because both carbohydrates and protein hold water
    in the cells. In essence, you are dehydrating yourself to lose
    weight. So yes the scale will go down, but approximately 75%
    (if not more) of it is water instead of fat. And just so you
    know, exercising while consuming a small calorie intake just
    makes the situation worse. This is because when you exercise,
    you start burning off more energy and the more you workout, the
    more energy your body needs. I already told you above where
    the energy comes from, and if you do not give your body the
    energy it needs, it will just feed on your muscles even quicker
    now that you are exercising. So eat more food! In addition
    to this, when you cut down too much on your calorie intake,
    your body will start storing calories because it doesn’t know
    when you will eat again. The calories that are stored will be
    stored as fat. So in other words, when your body is storing
    energy, it’s basically storing more fat.

    To summarize my point: Not eating enough calories results in
    muscle loss, dehydration, slower fat burning, and your body
    will always adapt to a lower calorie intake.

    Bottom Line: if you can’t maintain that lower calorie intake
    for the rest of your life, you will gain your weight back
    when you get tired of starving yourself!

    To lose weight properly (burning fat) you must increase your
    metabolism (weight training) and your need for oxygen (aerobics)
    while eating enough calories each day (nutritious diet) to
    give you energy and maintain the protein in your muscles because
    protein helps build muscles, which indirectly burns fat. This
    brings up another good point: When you build muscle your weight
    will increase because your muscles are made up of mostly water,
    but your body fat percentage will decrease because building
    muscles increase your metabolism (in other words, muscles way
    more than fat, but take up less space than fat). So keep in mind
    that losing body fat can’t be measured by a scale; use a
    measuring tape and also look at yourself in the mirror, and then
    you will see the true results. One of the best ways to know if
    you are losing more body fat than water is by using a body fat
    analyzer.

    Make sure that you focus on fat loss not weight loss. Your goal
    should be to lose weight by burning fat, not losing water from
    your muscles. Remember this when you choose your weight loss
    program.

    This article was written by Vernita Sherman
    of Ultimate Fat Burning Secrets. Ultimate Fat Burning
    Secrets is an online resource dedicated to exposing
    fat burning secrets that weight loss companies are
    keeping from you. Vernita focuses on teaching you
    the truth about how to permanently lose weight the healthy
    way at http://www.ultimatefatburningsecrets.com

    Posted in Uncategorized | Comments Off

    So Many Affiliate Programs! Which One Do I Choose?

    May 24th, 2008 by Administrator

    Ask questions first before you join an affiliate program. Do a
    little research about the choices of program that you intend to
    join into. Get some answers because they will be the deciding
    point of what you will be achieving later on.

    Will it cost you anything to join? Most affiliate programs being
    offered today are absolutely free of charge. So why settle for
    those that charge you some dollars before joining.

    When do they issue the commission checks? Every program is
    different. Some issue their checks once a month, every quarter,
    etc. Select the one that is suited to your payment time choice.
    Many affiliate programs are setting a minimum earned commission
    amount that an affiliate must meet or exceed in order for their
    checks to be issued.

    What is the hit per sale ratio? This is the average number of
    hits to a banner or text link it takes to generate a sale based
    on all affiliate statistics. This factor is extremely important
    because this will tell you how much traffic you must generate
    before you can earn a commission from the sale.

    How are referrals from an affiliate’s site tracked and for how
    long do they remain in the system? You need to be confident on
    the program enough to track those people you refer from your
    site. This is the only way that you can credit for a sale. The
    period of time that those people stay in the system is also
    important. This is because some visitors do not buy initially
    but may want to return later to make the purchase. Know if you
    will still get credit for the sale if it is done some months
    from a certain day.

    What are the kinds of affiliate stats available? Your choice of
    affiliate program should be capable of offering detailed stats.
    They should be available online anytime you decide to check them
    out. Constantly checking your individual stats is important to
    know how many impressions, hits and sales are already generated
    from your site. Impressions are the number of times the banner
    or text link was viewed by a visitor of your site. A hit is the
    one clicking on the banner or text links.

    Does the affiliate program also pay for the hits and impressions
    besides the commissions on sales? It is important that
    impressions and hits are also paid, as this will add to the
    earnings you get from the sales commission. This is especially
    important if the program you are in offers low sales to be able
    to hit ratio.

    Who is the online retailer? Find out whom you are doing business
    with to know if it is really a solid company. Know the products
    they are selling and the average amount they are achieving. The
    more you know about the retailer offering you the affiliate
    program, the easier it will be for you to know if that program
    is really for you and your site.

    Is the affiliate a one tier or two tier program? A single tier
    program pays you only for the business you yourself have
    generated. A two tier program pays you for the business, plus it
    also pays you a commission on the on the sales generated by any
    affiliate you sponsor in your program. Some two-tier programs
    are even paying small fees on each new affiliate you sponsor.
    More like a recruitment fee.

    Lastly, what is the amount of commission paid? 5% – 20% is the
    commission paid by most programs. .01% – .05% is the amount paid
    for each hit. If you find a program that also pays for
    impressions, the amount paid is not much at all. As you can see
    from the figures, you will now understand why the average sales
    amount and hit to sale ratio is important.

    These are just some of the questions that needed answering first
    before you enter into an affiliate program. You should be
    familiar with the many important aspects that your chosen
    program should have before incorporating them into your website.
    Try to ask your affiliate program choices these questions. These
    can help you select the right program for you site from among
    the many available.

    Posted in Uncategorized | Comments Off

    SQL Administrator Skills Required to Support Microsoft Great Plains

    May 24th, 2008 by Administrator

    Microsoft Great Plains is becoming more and more popular and we see new purchases among midsize and large corporations, where, in our opinion, Microsoft SQL Server DB administrator position is a must. If you are database administrator and you are part of the decision making team, purchasing Microsoft Business Solutions Great Plains for your corporation, we would like to set your expectation on the level of SQL knowledge, skills and experience needed to support Microsoft Great Plains in-house

    • Data querying. Microsoft Great Plains has decent ReportWriter, which allows users to create and modify existing reports, however the recommended tool, and you will soon understand that if you need really challenging reports (Sales Commissions, Bill of Lading, Sales Order Status with Purchasing info, Regional Sales, etc.) – you need to deploy Crystal Reports or Crystal Enterprise. Crystal Report itself is usually based on the view or stored procedure. So – you should expect to be familiar with Great Plains tables architecture and be capable to create select statement with multiple joins and unions

    • Data Repair. You should be ready to save GP table prior to data repair: select * into SOP10100_Copy from SOP10100 and then use update statement to fix incorrect values. If you need to load SOP10100 back from the backup table – first drop DEX_ROW_ID column and then use: insert into SOP10100 select * from SOP10100_Copy.

    • Backup and Restore. Great Plains has DYNAMICS database which stores system info, such as users, security, companies, etc. and each company has its own database. You should be able to restore mostly company databases from the backup. This seems to be trivial routine.

    • Technical Support. When you have issues with posting or need help from Microsoft Business Solutions Technical Support, you place case through customer source and you should expect the technician provide you with SQL scripts to fix your data.

    • Some Useful Scripts. You need to be able to delete locked user: delete activity where userid=’TOM’, also very popular is batch recovery script, you need to unlock the batch in SY00500 table: Posting Definition Master

    • Do not expect. Replications (except probably snapshot) – it adds GUID column and then Great Plains Dexterity runtime can not upgrade the modified tables. Referential Integrity is not used, Varchar or NVarchar are not used – the reason is – Dexterity architecture, which was initially designed with database independence in mind. Logins and access management – Great Plains uses its own security, which is translated into SQL logins with encrypted password.

    • Moving Great Plains on the new SQL Server. It is often confusing for the DB Admin. Besides physical move through backups or detach/attach DB you need special scripts to transfer GP security and users logins, these scripts are available through MBS tech support or feel free to call you MBS partner.

    • Advanced Techniques. If you need to notify your GP users on the specific event in GP – such as invoice was paid, you can deploy SQL emailing: xp_send_mail. This procedure could be called in the trigger for the apply payments table.

    • Data Integration. XML inbound and outbound streams for the integration stored procedures is becoming defacto standard. Also you should be familiar with heterogeneous SQL queries: OPENROWSET and linked server conceptions.

    Happy implementing! You can always appeal to us to help you with your system. Give as a call 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com

    Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ( http://www.albaspectrum.com ), Microsoft Business Solutions Great Plains, Microsoft CRM, Navision, Microsoft RMS, Microsoft Business Portal customization company, serving clients in Chicago, Boston, New York, Miami, Atlanta, Houston, Dallas, Denver, Los Angeles, San Francisco, San Diego, Seattle, Minneapolis, Phoenix, Toronto, Montreal, Brazil, Mexico, UK, Australia, Canada, UK, Europe, Russia an having small offices in multiple states and internationally.

    Posted in Uncategorized | Comments Off

    Tupperware and Rubbermade Thank you

    May 24th, 2008 by Administrator

    There are many reasons we in the United States are so fortunate not to have the horrible diseases they do in other countries, especially in Asia and Africa. We have modern sewer systems, fresh water, refrigeration and good health care. But we should also consider some of our habits as Americans and some of the companies, which have bought us products, which help us keep our food fresh.

    Tupperware is one of the reasons we as Americans are so healthy, since its inception, it has brought quality products to market to seal in freshness, prevent bacteria growth and allow people to save portions for a later date without risking contamination. Rubbermade another company, which emulated the Tupperware type products has also helped immensely by using its mass marketing abilities in major retail outlets.

    Some would say, yes, this is all true; so what is the point? The point is we all to often forget those things that are right in front of us. Go to your refrigerator right now and your cupboard and look at all the Tupperware type products? You see and these same types of products are in the households of 300 million Americans protecting our food supplies.

    In some countries the mortality rates are five deaths for every child who reaches 8 years old. In the United States we have fresh water, sewer systems, refrigeration, protection of food supplies with laws and thank god we have Tupperware type products. Think on this.

    “Lance Winslow” – Online Think Tank forum board. If you have innovative thoughts and unique perspectives, come think with Lance; www.WorldThinkTank.net/wttbbs/

    Posted in Uncategorized | Comments Off

    What is a sleep disorder?

    May 24th, 2008 by Administrator

    A sleep disorder as any difficulties related to sleeping,
    including: * difficulty falling or staying asleep, * falling
    asleep at inappropriate times, * excessive total sleep time, or
    * abnormal behaviors associated with sleep.

    The value of a good night’s sleep can hardly be overestimated.
    Quality sleep enables your body and mind to perform optimally
    each day. Sleep helps to restore and rejuvenate your memory
    processes, energize your nervous and immune systems, and
    stimulate overall growth and development. Without enough sleep
    you will likely: * experience increased difficulty
    concentrating, learning, and remembering things * become less
    able to perform simple tasks and complex tasks may become
    seemingly impossible * become anxious, moody, and impatient, and
    notice increased difficulties during interaction and cooperation
    with others. Sleep problems may already be interfering with your
    daily life. If so it is time to find out what is keeping you
    from getting the sleep you need, whether it be poor sleep
    hygiene, insomnia or a more serious sleep disorder. To help you
    on your way to getting a good night’s sleep, there are many
    things you can do to reduce your risk of developing a sleep
    disorder. By making small changes, you can greatly improve the
    quality of your sleep and thereby the overall quality of your
    mental and physical well-being. If you find that you currently
    practice or experience one or more of the following risk
    factors, you may want to consider making changes to your
    lifestyle or consulting with your doctor to learn how you can
    improve your health: * poor sleep environment (i.e., noisy or
    brightly lit) * excessive caffeine or alcohol intake * use of
    certain medications and drugs * smoking or chewing tobacco *
    anxiety, depression, or other mood disorder * stressful
    situation such as death of a loved one or job pressure *
    counter-productive sleep routine * daytime napping * early or
    late-night bed times * traveling between time zones * shift
    workers with rotating schedules * physical illness * obesity

    Tips for a better sleep environment * Make sure your bed is
    large enough and comfortable. If you are disturbed by a restless
    bedmate, switch to a queen- or king-size bed. Test different
    types of mattresses. Try therapeutic shaped foam pillows that
    cradle your neck or extra pillows that help you sleep on your
    side. Get comfortable cotton sheets. * Make your bedroom
    primarily a place for sleeping. It is not a good idea to use
    your bed for paying bills, doing work, etc. Help your body
    recognize that this is a place for rest or intimacy. * Keep your
    bedroom peaceful and comfortable. Make sure your room is well
    ventilated and the temperature consistent. And try to keep it
    quiet. * Hide your clock. A big, illuminated digital clock may
    cause you to focus on the time and make you feel stressed and
    anxious. Place your clock so you can’t see the time when you are
    in bed.

    http://www.homeherb.com/brand.asp?vid=1

    Posted in Uncategorized | Comments Off

    « Previous Entries