text:
Full title reads: "London. Skyscraper 'Topped Out'."
Millbank, London. Vickers Building reaches top.
GV looking across River Thames at Vickers new building. SV base of building camera pan up to show whole length of building looking upwards towards sky. SV inside lift travelling up showing small group of builders on the ground showing the height of the building. SV inside lift looking out across tops of buildings. Lift is still travelling upwards. LV of ground below camera pans round showing roadway and cars travelling along appearing very small. SV of crane on top of building camera pan to leaded cement bucket on end of crane it moves in towards group of people on top of building group of people round platform. SV people watching around platform. SV of cement bucket now being lowered for topping out ceremony CU group of workers watching. They are holding glasses of drink in their hands. SV of large cement bucket now having its contents emptied onto topping up platform. CU of workers who are now raising their glasses and are drinking. CU of Viscount Knollys performing the topping out ceremony camera pans down to show him probing cement with a nozzle. LV looking across River Thames from top of building. LV of Vickers building looking across River Thames.
(Orig Neg)
Cataloguer's Note: This building is now known as Millbank Tower - MD.


text:
Who do you think looks best today? (5 photos)
The best street style from London Fashion Week: http://ow.ly/p48HS via @StyleCaster
It's not ideal to hit the treadmill with a pound of makeup on, but if you want just a hint of hue, here's a simple solution: First, give lips a wash of translucent color by swiping on a lightweight stain. "You'll appear fresh and alive," says Chanel makeup pro Kara Yoshimoto Bua. Next, if you feel naked without mascara, reach for a smear-proof formula.
Just Bitten Kissable balm stain, Revlon,$9; revlon.com.
Max Volume Flash waterproof mascara, Rimmel London, $7; at drugstores.Read MoreLess

subset: commoncrawl


text:
Easter! Waking up in the morning to see what treats and goodies the Easter Bunny has left behind. Can you unscramble Squigly's Easter words?
Unscramble each word and type it in the box provided. When you have done as many as you can, click on Check Answers and Squigly will let you know how you did.
Aced this one? Try another word scramble!
... more Easter fun.


text:
The Global Intelligence Files,
files released so far...
Index pages
by Date of Document
Our Partners
Al Akhbar - Lebanon
Al Masry Al Youm - Egypt
Asia Sentinel - Hong Kong
Bivol - Bulgaria
Carta Capital - Brazil
CIPER - Chile
Dawn Media - Pakistan
L'Espresso - Italy
La Repubblica - Italy
La Jornada - Mexico
La Nacion - Costa Rica
Malaysia Today - Malaysia
McClatchy - United States
Nawaat - Tunisia
NDR/ARD - Germany
Owni - France
Pagina 12 - Argentina
Philip Dorling - Fairfax media contributor - Australia
Plaza Publica - Guatemala
Publica - Brazil
Publico.es - Spain
Rolling Stone - United States
Russian Reporter - Russia
Ta Nea - Greece
Taraf - Turkey
The Hindu - India
The Yes Men - Bhopal Activists
Sunday Star-Times - New Zealand
Community resources
courage is contagious
The Global Intelligence Files
On Monday February 27th, 2012, WikiLeaks began publishing The Global Intelligence Files, over five million e-mails from the Texas headquartered "global intelligence" company Stratfor. The e-mails date between July 2004 and late December 2011. They reveal the inner workings of a company that fronts as an intelligence publisher, but provides confidential intelligence services to large corporations, such as Bhopal's Dow Chemical Co., Lockheed Martin, Northrop Grumman, Raytheon and government agencies, including the US Department of Homeland Security, the US Marines and the US Defence Intelligence Agency. The emails show Stratfor's web of informers, pay-off structure, payment laundering techniques and psychological methods.
[OS] YEMEN - Clashes, protests erupt in Yemen for second day
Released on 2012-10-10 17:00 GMT
Email-ID | 4630917 |
Date | 2011-11-12 17:01:23 |
From | email@example.com |
To | firstname.lastname@example.com |
List-Name | firstname.lastname@example.com |
AFP a** 14 hrs ago
Fierce clashes erupted in Yemen's second city Saturday as protesters in
the capital Sanaa condemned international silence in the face of a
government crackdown that left more than 15 dead the previous day.
"Oh world, the children and women of Taez are being killed...where is your
conscience?" chanted tens of thousands of protesters in Sanaa who for 10
months now have been calling for President Ali Abdullah Saleh to step
"To the world and the (UN) Security Council, don't you see Saleh is
shelling Taez?" they chanted.
On Friday, government forces shelled a protest site in the flashpoint city
of Taez, south of the capital, killing 15 civilians, including at least
three women and three children, medics said.
Friday's violence, which also left at least 40 people wounded, erupted
when security forces loyal to Saleh began shelling areas around Freedom
Square, the epicentre of the protest movement in Taez.
Witnesses blamed the violence on the Republican Guard, an elite unit
commanded by Saleh's son Ahmed, accusing it of firing tank and artillery
rounds into a crowd of protesting civilians.
The violence continued Saturday as armed tribesmen who have thrown their
support behind the protest movement clashed with government troops in the
Hassab district of Taez, witnesses said.
There were no immediate reports of casualties.
Youth activists called for a general strike in the city as thousands took
to the streets to condemn Friday's bloodshed. Residents said most
businesses were closed.
The escalation of violence came as UN envoy Jamal Benomar returned to
Yemen for a new push to end the 10-month crisis.
Benomar arrived in Sanaa on Thursday and began meeting with government and
opposition officials to discuss a roadmap for implementing a Gulf peace
plan which would see Saleh step down in return for a promise of immunity
from prosecution for himself and his family.
Saleh, who has been in power in Sanaa for 33 years, has so far failed to
sign up to the blueprint despite repeated promises that he would.
On Saturday, an opposition spokesman said the assault on Taez is "proof"
he has no intention to resign.
"Saleh totally rejects the initiative... and proof of this is what is
happening to the peaceful protesters in Taez," said Mohammed Qahtan,
spokesman for the Common Forum parliamentary opposition bloc.
The government's crackdown left hundreds dead and thousands wounded since


text:
Databases management is important. As SharePoint use a lot of databases, databases management is an important element. Because of this, a specific database is used for storing some specific group of data. Generally, the group of data is the site collection scope.
By default, user interface doesn't allow to create a site collection and use a specific database.
There is different ways to perform the operation depending on your needs:
STSADM createsiteinnewdb command
The createsiteinnewdb has the same objective than createsite command but there are some extra parameters. 4 of them concern database settings:
So you create a new database and use it to store your site collection data.
For more information about createsiteinnewdb, visit the following site: http://technet.microsoft.com/en-us/library/cc262407(office.12).aspx
New-SPSite Powershell command
Powershell is powerful in the SharePoint context. New-SPSite command can be used to create your site collection and store data in a specific existing database (ContentDatabase parameter). So if you want to create a new DB, you have to perform the operation before using New-SPSite.
Here is a sample of this command:
New-SPSite http://<sitecollectionUrl> -OwnerAlias "<domain>\<user>" -ContentDatabase <DB_Name> -Name "Demo"
For more information about New-SPSite, visit the following site: http://technet.microsoft.com/en-us/library/ff607937.aspx
User interface and database status
SharePoint databases have two statuses:
Offline seems to be "Not available" but exact meaning is "when the database status is set to Ready, the database is available for hosting new Site Collections. When the database status is set to Offline, no new Site Collections can be created". Offline DBs can still be used for the existing site collections.
So you can manage available databases. To perform this operation, go to the central administration and follow this path:
Central Administration > Application Management > Manage content databases
This last link points to: http://<SharePointCentralAdminUrl>/_admin/CNTDBADM.aspx
Set all databases statuses to Offline except for the one you want to use.
If all databases are set to Offline, you will receive the following error message when trying to create a new site collection:
The operation that you are attempting to perform cannot be completed successfully. No content databases in the web application were available to store your site collection. The existing content databases may have reached the maximum number of site collections, or be set to read-only, or be offline, or may already contain a copy of this site collection. Create another content database for the Web application and then try the operation again.
Go back to content databases management page and set a database as Ready.
Now you can plan backup for databases easily.
A number of people are willing to choose their brand Women Moncler Jackets wardrobe, and beyond that are likely to choose Women Moncler Coat as a Christmas gift to their friends. In spring and autumn, people would treat you the best clothes Women Moncler Vest. Men Moncler Jackets are all beautiful and elegant designs, which allows people to reveal their personalities gnocchi with T-shirts, sweaters and jackets www.moncler-jacketsforwomen.org .
The Moncler Jackets will probably softness wearer, comfort, and also feel elegant. Men and women are suitable for Moncler Coat for its beautiful designs. The Women Moncler are of great comfort and style. Use different colors running clothes in a fashion. As for the man who works outside, that's what they need more durability and heat, so it Moncler Down Jacket lot of emphasis on this point. But Moncler Jackets For Women tend to be wonderful colors and fantasy, women, jackets to long hair decorated with belt just to create a unique style of the wearer. The Moncler Down Jackets goes well with the other parties, such as a pair of boots, or a piece of collateral, if you're nice or not really depends on how you match your clothes. A good co-localization makes you great, even in public www.moncler-jacketsforwomen.org .
Fulfilling our needs for fast fashion means increased production and competition in clothing manufactured in countries with fashion trend.In order to meet the market's demands,Coach Outlet Store Online pay more attention on the fashion style with the latest material.In terms of luxury consumption, consumers in Western countries prefer traditional brands while consumers are wilder about the fashionable fad.In Coach Outlet there are many famous bags of the Coach Outlet Online.In USA,at least,each of the person have a Coach bags on the average.So,in the Amercian market,Coach bags get the people favourate.On that basic,manufacture take the chance to make the price very on the high side.Today,Coach Handbags Outlet USA do atmost to drop the price,with the same quality.In order to thanks for the public,Coach give a biggest discount to Forengn for the fastival.If U bag bags over $99,Coach Outlet Store Online can send the goods to Ur home without the fright.At the same time,the goods of coach bags can have a discount at 82% to meet the market's needs.So don't worry,Coach Outlet Online Store can give U the chance to owned your remembered bags with very lowest price.At the same time,Coach Outlet Store Online newly iaunched the latest fad bags which canused a ensation in the fashion world for U to make up in the winter.Is your heat moving very fast,quick, first come first get.More and More chance are waiting for U.
Coach Outlet Online and Coach Outlet Online Store offer you chance to purchase your ideal articles. Here login Coach Outlet Online or Coach Outlet to purchase your favourites, such as Coach Cristin Bags, Coach Crossbody bags.They are renowned for exquisite workmanship, skillful knitting and elegant design and sell very well both at home and abroad. In order to convenient our customers, we also offer you other platforms. They are Coach Outlet Online,Coach Outlet Online Store and Coach Factory Outlet. We not only provide you the superior goods but offer you the best after-sales serives. So, please login Coach Outlet Online.
The official declinedURL:[url=www.coachcoach-outlet.net]Coach Outlet[/url] to provide additional details about Bales, who is suspected
A标签带title跟H1:
Coach Outlet
 of walking off his base in southern Afghanistan on Sunday and gunning down A标签带title:Coach Factory Outletthe 16 villagers, including nine children and three women.Earlier, the soldier's attorney said the staff sergeant was scheduled to A标签带H1:
Coach Outlet Store
arrive on Friday at the Fort Leavenworth army base in Kansas, whereAA标签Coach Outlet he will beheld in maximum security. Fort Leavenworth has the U.S. Defense Department's onlymaximum-security facility.
Best authentic coach handbags On Sale. Welcome to our clearance coach handbags store. The latest & fashion style coach bags on sale are waiting for your select. discount coach handbags is based in New York, the leading men of the high-quality leather accessories and main gifts American enterprise. In our coach bags outlet clearance coach handbags store, you can get the best service, and gets the best quality coach purse discount. Once you cast a glance, you will be unable to resist the charm of them. They are amazing to be possessed. Welcome to the world of discount coach handbags New Style. In our coach purse, there are a wide range of Luggage waiting for you. coach outlet design beautiful and designer bags both for casual and business wear. The newest style of Cheap coach handbags sale are supply in our store,it will help you to follow the fashion tend. coach purse sale is a leading American designer of luxury goodies. coach bags become a symbol of elegance and luxury. It is a good choice to purchase discount coach bags, because all of the coach bags products that designed are in high quality, and the fashionable style all earn the coach handbags much attention. coach handbags have managed to reign supreme for a long time as the handbag of choice for most women.
firstname.lastname@example.com Welcome to buy Cheap Coach Purses for sale online if you want to get the best price for your dream coach on Coach Purses Outlet.Coach Online Outlet have various types for your choices in Coach Purses Outlet, you'll find selections to meet any budget from Coach Outlet Online. Here are some detailed of discount Coach Online Sale.Elegant and noble will be the distinctive characteristic of authentic Coach Outlet on sale 2012 at discount coach online store. The absolutely excellent craftsmanship and worldwide top level make discount Coach Purses Outlet Store for sale online comfort and durability. The Coach Outlet have quite a few fans around the world for many years, mainly because these Coach Outlet have a wide selection of colors, sizes and styles, earning him a solid reputation. The favorite price of Coach Purses Outlet with the durability, fancy styles and refined handwork give you ultimate comfort and fashion. Besides, the op art patters with unique figure captions, modern silver metal on the surface, authentic fabric lining and so on make them quite durability and practicality. So Coach Purses on sale are very convenient for daily life which can be worn either by your side or tucked under your arm. Everyone does want to have this style of Coach Outlet Store because of its unique design on Coach Purses Sale. Buy Coach Online now and enjoy the fashion world now.Shop Coach Outlet Store with free shipping!
adizero rose 2.5 www.adizeroroseshoes.com
cheap jordan shoes www.cheapjordan23shoes.com
cheap ray ban sunglasses www.raybansunglasses-mall.com
rose shoes www.rosebasketballshoes.com
kobe basketball shoes http://www.kobeshoesmart.com
cheap kobe 7 shoes www.cheapkobeviishoes.com
cheap gucci belts www.cheapguccibelts-mart.com
cheap oakley sunglasses www.shopcheapoakleysunglasses.com
cheap oakley sunglasses www.cheapoakleysunglasses-mart.com
fake oakley sunglasses www.fakeoakleys-sunglasses.com
lebron james shoes www.youthlebronjamesshoes.com
kobe shoes www.kobebasketballshoes-mall.com
james shoes www.lebronjamesshoes-mall.com
cheap gucci belts www.cheapguccibelts-malls.com
cheap calvinklein underwear www.cheapcalvinkleinunderwear.com
cheap puma shoes www.cheappumashoes-mall.com
adizero rose 2.5
derrick rose shoes
adidas adizero rose shoes
rose shoes 2.5
rose basketball shoes
rose shoes 2(ii)
cheap jordan shoes
air jordan shoes
nike air Jordan
nike air max jordan
jordan Retro shoes
Jordan Basketball Shoes
2012 jordan shoes
kids jordan shoes
womens jordan shoes
derrick rose shoes
adidas adizero rose
rose basketball shoes
rose shoes 2.5
kids basketball shoes
cheap oakley sunglasses
fake oakley sunglasses
discount oakley sunglasses
cheap ray ban sunglasses
replica oakley sunglasses
fake Ray ban Sunglasses
cheap oakley sunglasses
fake oakley sunglasses
Oakley Sunglasses for men
Oakley Sunglasses for women
designer oakley sunglasses
polarized oakley sunglasses
kobe basketball shoes
james basketball shoes
rose basketball shoes
mens basketball shoes
kids basketball shoes
kobe shoes
kobe bryant basketball shoes
kids kobe shoes
youth kobe shoes
kobe 7(vii) shoes
kobe 6(vi) shoes
cheap gucci belts
fake gucci belts
replica gucci belts
discount gucci belts
cheap hermes belts
cheap louis vuitton belts
Lebron James shoes
James basketball shoes
Lebron basketball shoes
Lebron James 9(x)
Lebron James 8(viii)
cheap lebron james shoes
cheap ray ban sunglasses
fake ray ban sunglasses
discount ray ban sunglasses
replica ray ban sunglasses
ray ban sunglasses wholesale
cheap oakley sunglasses
fake oakley sunglasses
replica oakley sunglasses
wholesale oakley sunglasses
dicount oakley sunglasses
Cheap Calvin Klein Underwear
Calvin Klein Boxers
Calvin Klein Briefs
Calvin Klein 365
Calvin Klein X
Calvin Klein Thong
cheap puma shoes
puma ferrari shoes
mes puma shoes
womens puma shoes
[url=www.adizeroroseshoes.com] adizero rose 2.5[/url]
[url=www.adizeroroseshoes.com] derrick rose shoes[/url]
[url=www.adizeroroseshoes.com] adidas adizero rose shoes[/url]
[url=www.adizeroroseshoes.com] rose shoes 2.5[/url]
[url=www.adizeroroseshoes.com] rose basketball shoes[/url]
[url=www.adizeroroseshoes.com] rose shoes 2(ii)[/url]
[url=www.cheapjordan23shoes.com] cheap jordan shoes[/url]
[url=www.cheapjordan23shoes.com] air jordan shoes[/url]
[url=www.cheapjordan23shoes.com] nike air Jordan[/url]
[url=www.cheapjordan23shoes.com] jordan Retro shoes[/url]
[url=www.cheapjordan23shoes.com] Jordan Basketball Shoes[/url]
[url=www.cheapjordan23shoes.com] 2012 jordan shoes[/url]
[url=www.cheapjordan23shoes.com] nike air max jordan[/url]
[url=www.cheapjordan23shoes.com] kids jordan shoes[/url]
[url=www.cheapjordan23shoes.com] womens jordan shoes[/url]
[url=www.cheapguccibelts-mart.com] cheap gucci belts[/url]
[url=www.cheapoakleysunglasses-mart.com] cheap oakley sunglasses[/url]
[url=www.cheapoakleysunglasses-mart.com] Cheap Calvin Klein Underwear[/url]
[url=http://www.kobeshoesmart.com] kobe basketball shoes[/url]
[url=www.rosebasketballshoes.com] rose basketball shoes[/url]
[url=www.cheapguccibelts-mart.com] fake gucci belts[/url]
[url=www.cheapguccibelts-mart.com] replica gucci belts[/url]
[url=www.cheapguccibelts-mart.com] discount gucci belts[/url]
[url=www.cheapguccibelts-mart.com] cheap hermes belts[/url]
[url=www.cheapguccibelts-mart.com] cheap louis vuitton belts[/url]
[url=www.cheapoakleysunglasses-mart.com] fake oakley sunglasses[/url]
[url=www.cheapoakleysunglasses-mart.com] dicount oakley sunglasses[/url]
[url=www.cheapoakleysunglasses-mart.com] cheap ray ban sunglasses[/url]
[url=www.cheapoakleysunglasses-mart.com] replica oakley sunglasses[/url]
[url=www.cheapoakleysunglasses-mart.com] Ray ban Sunglasses[/url]
[url=www.shopcheapoakleysunglasses.com] cheap oakley sunglasses[/url]
[url=www.shopcheapoakleysunglasses.com] fake oakley sunglasses[/url]
[url=www.shopcheapoakleysunglasses.com] Oakley Sunglasses for men[/url]
[url=www.shopcheapoakleysunglasses.com] Oakley Sunglasses for women[/url]
[url=www.shopcheapoakleysunglasses.com] designer oakley sunglasses[/url]
[url=www.shopcheapoakleysunglasses.com] polarized oakley sunglasses[/url]
[url=http://www.kobeshoesmart.com] james basketball shoes[/url]
[url=http://www.kobeshoesmart.com] rose basketball shoes[/url]
[url=http://www.kobeshoesmart.com] mens basketball shoes[/url]
[url=http://www.kobeshoesmart.com] kids basketball shoes[/url]
[url=www.rosebasketballshoes.com] derrick rose shoes[/url]
[url=www.rosebasketballshoes.com] adidas adizero rose[/url]
[url=www.rosebasketballshoes.com] rose shoes 2.5[/url]
[url=www.rosebasketballshoes.com] kids basketball shoes[/url]
[url=www.cheapkobeviishoes.com] kobe shoes[/url]
[url=www.cheapkobeviishoes.com] kobe bryant basketball shoes[/url]
[url=www.cheapkobeviishoes.com] kids kobe shoes[/url]
[url=www.cheapkobeviishoes.com] youth kobe shoes[/url]
[url=www.cheapkobeviishoes.com] kobe 7(vii) shoes[/url]
[url=www.cheapkobeviishoes.com] kobe 6(vi) shoes[/url]
[url=www.youthlebronjamesshoes.com] Lebron James shoes[/url]
[url=www.youthlebronjamesshoes.com] James basketball shoes[/url]
[url=www.youthlebronjamesshoes.com] Lebron basketball shoes[/url]
[url=www.youthlebronjamesshoes.com] Lebron James 9(x)[/url]
[url=www.youthlebronjamesshoes.com] Lebron James 8(viii)[/url]
[url=www.youthlebronjamesshoes.com] cheap lebron james shoes[/url]
[url=www.raybansunglasses-mall.com] cheap ray ban sunglasses[/url]
[url=www.raybansunglasses-mall.com] fake ray ban sunglasses[/url]
[url=www.raybansunglasses-mall.com] discount ray ban sunglasses[/url]
[url=www.raybansunglasses-mall.com] replica ray ban sunglasses[/url]
[url=www.raybansunglasses-mall.com] ray ban sunglasses wholesale[/url]
[url=www.fakeoakleys-sunglasses.com] cheap oakley sunglasses[/url]
[url=www.fakeoakleys-sunglasses.com] fake oakley sunglasses[/url]
[url=www.fakeoakleys-sunglasses.com] replica oakley sunglasses[/url]
[url=www.fakeoakleys-sunglasses.com] wholesale oakley sunglasses[/url]
[url=www.fakeoakleys-sunglasses.com] dicount oakley sunglasses[/url]
[url=www.cheappumashoes-mall.com] cheap puma shoes[/url]
[url=www.cheappumashoes-mall.com] puma ferrari shoes[/url]
[url=www.cheappumashoes-mall.com] mes puma shoes[/url]
[url=www.cheappumashoes-mall.com] womens basketball shoes[/url]
[url=www.cheapcalvinkleinunderwear.com] Cheap Calvin Klein Underwear[/url]
[url=www.cheapcalvinkleinunderwear.com] Calvin Klein Boxers[/url]
[url=www.cheapcalvinkleinunderwear.com] Calvin Klein Briefs[/url]
[url=www.cheapcalvinkleinunderwear.com] Calvin Klein 365[/url]
[url=www.cheapcalvinkleinunderwear.com] Calvin Klein X[/url]
[url=www.cheapcalvinkleinunderwear.com] Calvin Klein Thong[/url]
[url=www.cheapnewera-baseballhats.com] cheap new era caps wholesale[/url]
[url=www.wholesale-neweracaps.com] cheap new era caps [/url]
This is what I need to know very much and I appreciate you to sharing this with us and I hope you will always sharing useful information like this with us. Thanks for help!
On http://www.ahhermesbags.com ,you only use the discount coupon code"AHHERMES" to checkout will get 5% discount. How a amazing new, Let's do it!
fake oakley sunglasses wholesale
fake oakley sunglasses
fake Rayban sunglasses
fake D&G sunglasses
fake LV sunglasses
fake Gucci sunglasses
fake Cartier sunglasses
fake Prada sunglasses
fake Carrera sunglasses
fake Armani sunglasses
louis vuitton belt
louis vuitton belts
cheap louis vuitton belts
gucci belt
cheap gucci belts
cheap gucci belt
replica carrera sunglasses
fake carrera sunglasses
replica prada sunglasses
replica D&G sunglasses
replica police sunglasses
replica armani sunglasses
replica Carrera sunglasses
replica gucci sunglasses
replica Cartier sunglasses
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19222">
Omega Chronostop wrist watches are anotherseiko spc007p1
interesting line. I bought
mine, without knowing anything about this style of watch. As usual, after
studying the various watches available on eBay, it became apparent to me that
there are quite a few variations available. I started collecting some pictures
& basic information on these watches. Here's a brief overview of my
findings. I only own one of these watches. So can only authoratitively state
facts for that particular watch. The book burberry watches
"OMEGA SAGA" doesn't even acknowledge
the existance of this style of watch, listing only very brief movement details.
All other details I list have been "gleaned" from eBay auctions or from the
Omega Museum Catalogue.
These are watches with a SINGLE pusher to operate a
stop watch function. Press the pusher once to start the stopwatch hand. Press it
again (& KEEP it pressed) to stop the stopwatch hand (& read the time)
& release the pusher to reset the hand to zero.
There is NO minute
sub-dial. SO if you want to measure something for more than 60 seconds, you have
to count the minutes yourself !
There is no seiko spc007p1
continuous second hand on these
watches.
There are 2 movements that have been used in this watch series. The
865 & 920. Simply said, the 920 has a date & the 865 doesn't. Both
movements are manual wind.
The 865 movement was introduced in 1966 &
124,000 were made. The 920 movement was introduced 2 years later in 1968 &
61,000 were made. Both of these movements were only ever used in Chronostop
watches.
I always believe that where there is a will ,there is a way in our life,recently,i find one good things that created by so intelligent people on the internet,it is[url=www.cheapdesignerclothesonsale.com]cheap gucci shoes[/url],wowa,too seeing is to believing,so many kinds thought ways
www.nikeraidersjerseysshop.com Raiders Jerseys
www.nikeraidersjerseysshop.comnike-carson-palmer-jersey Carson Palmer Jersey
www.nikeraidersjerseysshop.comnike-darren-mcfadden-jersey Darren McFadden Jersey
www.nikeraidersjerseysshop.comnike-terrelle-pryor-jersey Terrelle Pryor Jersey
www.nikeraidersjerseysshop.comnike-richard-seymour-jersey Richard Seymour Jersey
www.nikeraidersjerseysshop.comnike-jacoby-ford-jersey Jacoby Ford Jersey
www.nikeraidersjerseysshop.comnike-rolando-mcclain-jersey Rolando McClain Jersey
www.nikeraidersjerseysshop.comnike-darrius-heyward-bey-jersey Darrius Heyward-Bey Jersey
www.nikeraidersjerseysshop.comnike-sebastian-janikowski-jersey Sebastian Janikowski Jersey
www.nikeraidersjerseysshop.comnike-denarius-moore-jersey Denarius Moore Jersey
www.nikeraidersjerseysshop.comnike-aaron-curry-jersey Aaron Curry Jersey
Keep functioning ,terrific job!
This paper is useful to me, say thanks to the actual writer's share 12 Very honored to be able to see this article
www.fashionredbottomshoes.com" >christian louboutin
www.oaklysunglassesshop.com" >oakly unglassess
www.hervelegervipclub.com" >herve leger
red bottom shoes
http://www.hermescolumn.com" >hermes bags
http://www.karenmillenbox.com" >karen millen
Louis">www.cheaplouisvuittonhandbagshop.com/">Louis Vuitton Handbags

Whether because of myopia or dress up, the Fake Oakley Sunglasses are can add fashionable index sheet is tasted. Makeup look, hair style, face shape, clothing, etc., are you choose various types of glasses to consider factors. Glasses can transmit your emotions, let friends to listen to your fashion whisper it. OAKLEY glasses to the concept of Fake Oakleys for Sale sunglasses products subversion, in that it took the glasses of comfortable sex, practical and artistic fusion. Whether the product design or the selection of material, after a series of advanced scientific experiment and testing, make sure it is comfortable and high quality, and makes function and fashion fusion. Sunglass popularity last year and this year window is not much different, but in more detail system for excellence. On the understanding of the popular direction, and on the basis of facial form, select the appropriate color sunglass is always the same principle. Welcome to the shop price of choose and buy fashion Charles Oakley Fake Oakleys sunglasses. Surprise many, many preferential.

bbcd Louis">louisvuittonoutlet-b.blogspot.com/">Louis Vuitton Outlet viewpo louisvuittonoutlet-b.blogspot.com acce cheap">cheapjordanshoes.yhqcwx.info/">cheap jordan shoes ufce Cheap">ajnewjordansinfo.weebly.com/">Cheap Jordans Online fouytt ajnewjordansinfo.weebly.com uccb Air">retrojordans7.iconosites.com">Air Jordans mopoyt retrojordans7.iconosites.com obcf Louis Vuitton Outlet oplkty  pplh Cheap jordans for sale mwabx  ppth Cheap">nikeshox-shoes-sale.weebly.com/">Cheap Nike Shox Shoes plhjke nikeshox-shoes-sale.weebly.com jkty Michael Kors bags wdfefg michael kors outlet weku Michael Kors Handbags wdfvnh Michael Kors Outlet qsde  ptable cheapjordanshoes.yhqcwx.info ybufe cheap">jordanconcord-forsales.blogspot.com/">cheap jordans bcforp jordanconcord-forsales.blogspot.com
The actual step) day holy cats leading store about "sandals carnival"
Is there a sense of summer season, as though just the couple of shoes upon his ft to understand the answer. Also to annually at the beginning, SKAP (SAN jia stage) day time kitty main store refreshing show up, the choice for your summer season fashion: a great unmatched "sandals carnival", allow you to sit as you're watching computer through clicking the mouse can appear the actual wind of constantly style, relaxed and comfortable!
Nice article.Always nice to read some tips concerning the appearance of our blogs.
Wonderful articles, let me have to this admiration
I've been looking for books of this nature for a way too long. I'm just glad that I found yours. Looking forward for your next post. Thanks !
Herve Leger outlet www.officialherveleger.com
Cheap Red Bottom Shoes for Women www.redbottomshoes1965.com
Cheap Louis Vuitton for Men www.cheaplouisvuittonhandbagsale.co.uk
Thanks for sharing your feedback! If your feedback doesn't appear right away, please be patient as it may take a few minutes to publish - or longer if the blogger is moderating comments.
Color matching is this year chun xia you cannot miss one of the popular key. Actress sensitive card kelly and Kitty? Perry loves this kind of Christian Louboutin black and white red color matching stilettos colour low-key do not make public, cater to the urban OL pursuit of elegant style, in the collocation of sedate and do not break under the fashionable feeling let you easily become the office of the leading fashion.
the reaction of the woman to let her know that she is safe now, just really is thrilling.
Here cheap Womens North Face Windstopper we also
cheap Womens North Face Realization offer Nike
cheap Womens North Face Gore Tex Kobe Kids
cheap Womens North Face Down Shoes, maybe you will
cheap Womens North Face Denali like it.The Nike Zoom
cheap Womens North Face Apex Bionic Hyperfuse XDR
cheap Womens North Face 3 In 1 Black White Red Basketball Shoes features lightweight cheap North Face Polyester Mcmurdo stability, an ultra-lightweight cheap North Face Pink Ribbon design for explosive power on the hardwood.Made cheap North Face Greenland Jackets with Nike Hyperfuse technology cheap North Face Jackets For Women for breathability, strength and toughness, nike cheap North Face Ski Jackets Zoom unit in the forefoot for low-profile, super-responsive cheap North Face Scythe Jackets cushioning Heel and forefoot cheap North Face Jacket Lovers outriggers for lateral stability during quick cheap North Face Jackets For Kids cuts and jumps.Solid rubber outsole with herringbone cheap North Face Jackets For Men pattern for traction. Foam collar cheap Mens North Face 3 In 1 for enhanced fit and comfort, Mesh half-innersleeve cheap Mens North Face Apex Bionic for breathability and a lockdown fit, forefoot cheap Mens North Face Downflex grooves
cheap Mens North Face Down for enhanced articulation and flexibility.It is so cheap Mens North Face Gore Tex comfortable and flexible that it will help you score cheap Mens North Face Realization on the court.This Nike Air Hypershox 2011 White Blue Basketball Shoes is made by Mesh, Leather and Rubber.It Breathes cheap Mens North Face Windstopper Freely, Comfortable and Lightweight.
Your blog write really having a unique style. It can reflect real life side and touching scene.For your own writing also to have the very big help.


text:
Results 1 to 4 of 4
Thread: 1987 Power Antenna Issue
- Join Date
- Mar 2002
- Location
- Stroudsburg, PA
- Posts
- 40
- Post Thanks / Like
- Corvette(s)
- 2004 Triple Black Convertible
1987 Power Antenna Issue
Hello! I have a 1987 with a power antenna issue.
The motor for the power antenna does not stop running, even when the ignition is off and the key is out. I would assume I need to replace the antenna. Ive heard that is quite an undertaking in itself
In the meantime does anyone know how to make the motor stop running so it does not kill my battery? I have tried pulling all sorts of fuses but cant seem to find the right one? Thanks in advance for any advice.
On a 1989, the radio fuse supplies power to the radio which is hot on acc or run. The courtesy/clock fuse supplies power to the clock in the radio and antenna relay. On the coupe, relay should be located in the left hand cargo compartment on the end panel. You will need to remove the rear hatch cover to access this relay which is located near the rear latch. The white, dark green, and gray antenna wires all feed to the antenna relay. Replacing the antenna is a royal pain. GM replacements are expensive and not the same quality. I decided to replace the radio and antenna with aftermarket parts and eliminated the need for this relay. Also installed a single pole switch to control the radio antenna signal when listening to CDs. The aftermarket radio works great even with the antenna down.
- Join Date
- Nov 2001
- Location
- Savannah, GA, USA
- Posts
- 279
- Post Thanks / Like
- Corvette(s)
- 87 Silver Coupe Way over 200k miles
The antenna unit comes out from inside the wheel well. The wiring is under the rear shade and plastic cover. The gromet in the fender un-screws from the top if I remember right.
The power antenna is fairly simple. Since your motor is running all the time you need a new weed eater string for want of a better word. Once you get it apart you'll see what I mean. The assy. is riveted from the factory. Look through the catalogs (Eckler's, Zip, whoever you like) for a repair kit. GM used to sell them, I think most are just reboxed GM. You'll get the plasitc part with a new end and a couple of bolts to replace the rivets. Have some good grease to lube the insides up when you start. Rebuilding the antenna is the easy part getting the thing in and out is kind of a a pain. I've had a couple of this style apart and the repair kit fixed both of them. Last one I got was about $20. If you take it anywhere they'll want to sell you a new unit for @$150
Make sure you get the right kit. The later antennas are different.
- Join Date
- Mar 2002
- Location
- Stroudsburg, PA
- Posts
- 40
- Post Thanks / Like
- Corvette(s)
- 2004 Triple Black Convertible
Thanks! Both of the posts were very helpful. I was able to disconnect the correct wires so the battery didn't die… the taillights were still working and the radio still played!
I took a look at what it was going to take to replace it… thought about the other little items that were starting to add up… took it in for an inspection today and ended up leaving with a 2004!
Thanks again for your help.
Similar Threads
81 Power Antenna Questions
By agildawg in forum C3 General DiscussionReplies: 15Last Post: 11-15-08, 09:43 AM -
C5 Convt power antenna shut-off accessory
By Greg C in forum C5 General DiscussionReplies: 3Last Post: 09-13-07, 09:13 AM -
81 Power steering issue
By email@example.com in forum C3 Technical and PerformanceReplies: 3Last Post: 01-11-04, 06:12 PM -
1986 power antenna problem
By radstad66 in forum C4 Technical and PerformanceReplies: 8Last Post: 08-07-01, 08:30 PM -
power antenna relay
By ike in forum C3 Technical and PerformanceReplies: 2Last Post: 06-14-01, 07:34 AM


text:
Another striker who could be well on his way to North London is on Arsene Wenger's radar. This shows that Wenger is really giving thoughts of adding up to his fire power upfront specially when an injury to Giroud can flush all the hard work which got Gunners the first berth in the Premier League top flight.
Arsenal's chief scout Steve Rowley is also expected to attend the Barcelona-Elche game to assess the long-term prospects of the highly-rated Juventus owned player.
"Boakye-Yiadom has a massive future," said the A-League agent told GHANASoccernet.com on condition of remaining anonymous.
"He made notice after scoring against Real Madrid. I was informed by somebody high up in the club [Real Madrid] that a senior scout has been designated to watch him against Barcelona. There is belief in La Liga that Richmond [Boakye-Yiadom] is a would-be great striker because he is quick, disciplined and a great goal scorer. My friend in the Emirates [Arsenal] told me that Rowley has been asked by the club to watch Atletico Madrid striker Diego Costa and Elche striker Boakye-Yiadom on Saturday and Sunday respectively.''
Boakye-Yiadom has scored three La Liga goals but the 20-year old is tipped to reach double numbers.


text:
Visit our other Wisconsin Historical Society websites!
Refine or narrow your results by clicking any term in the gray boxes below.
Expand your results by removing any breadcrumb in a gray outlined box above. Click on the blue "X" to remove the term.
Narrow your results by entering a keyword into the search box above. Then click the "Search Within" checkbox, then click on the orange "Search" button.
If you did not find what you are looking for or you did not get any results, try changing your search term(s). See our Search Help page for more tips.
Date: 1774
Description: A hand-drawn plat map of Elkcorn (Elkhorn?) Creek.
Date: 1785
Description: Map of part of North America engraved and hand-colored (the light brown design is a superposition of the map and cartouche derived from the oxidation of th...
Date: 1772
Description: Scale: about 180 miles to 1 in.
Date: 1745 ca.
Description: Zodiac as seen from the Southern Hemisphere.
Date: 1793-02-01
Description: Text in the upper right corner reads, "A Map of The Western Part of the Territories belonging to the United States of America. Drawn from the best authorit...
Date: 1755
Description: From "A map of the British and French dominions in North American with the roads, distances, limits, and extent of the settlements".
Date: 1798 ca.
Description: Engraved and hand-colored map of Egypt. Map title appears on bottom left as a carving in stone next...
Date: 1733
Description: From "A map of the British Empire in America with the French and Spanish settlements adjacent thereto". This is the Wisconsin and Minnesota section.
Date: 1769
Description: Manuscript map. Scale: about 80 British statue miles to 1 inch.
Date: 1778
Description: A map of the rapids in the River Ohio.
Date: 1712
Description: Engraved double-hemispherical world map by Moll, included in his atlas The world described, or, A new and correct sett of maps: shewing the kingdoms and st...
Description: Hand colored. London, 1778. Coordinates: W 99⁰--W 83⁰/N 49⁰--N 41⁰. Scale [ca. 1:3,500,000]
Date: 1761
Description: A plan of the Straits of St. Mary and Michilimakinac, to shew the situation and importance of the two westernmost settlements of Canada for the fur trade....
Date: 1776
Description: In French: "Partie Occidentale du Canada et septentrionale de la Louisiane avec une partie de la Pensilvanie". A map showing graticule and six European sca...
Date: 1790
Description: Contenant: New Hampshire, Massachusetsbaye, Rhode Island, Connecticut, La Nouvelle York, Nouvelle Jersey, La Pensilvanie, Les Comtes de Newcastle, Kent et...
Date: 1798
Description: Uncolored. No scale. One of the earliest maps to show the proposed division of the northwest territory into states.
Date: 1792 ca.
Description: Map of Washington D.C. Labeled on the map are all the main streets, the site of the Capitol and the President's House. The map also shows the relationship...
Description: Zodiac as seen from the Northern Hemisphere.
Date: 1740 ca.
Description: Engraved and hand-colored map of the Iberian peninsula as a theater of war during the War of the Spanish Succession (1701-1714). The map is dedicated to Ki...
Description: This drawing, based on an 1897 survey, appeared in the 1899 Proceedings of the State Historical Society of Wisconsin, accompanying Publius V. Lawson's arti...
If you didn't find the material you searched for, our Library Reference Staff can help.
Call our reference desk at 608-264-6535 or email us at:


text:
Thanksgiving Book Give Away Contests have started on the Ehell blog! Check it out and enter!
0 Members and 1 Guest are viewing this topic.
Plus my mom got surprised because her sister flew in from Arizona for the party and didn't tell my mom she was coming!!! My aunt even called my mom that morning to wish her a happy anniversary!!


text:
non-mobile version
DAYTONA BEACH, FL-The opportunity to acquire a recently redeveloped center with a long-term Publix lease on a barrier island is rare in Florida and made Ormond Beach Mall a highly sought after opportunity.
All GlobeSt.com articles are archived after seven days. Register now for unlimited access to all recently archived articles, as well as thousands of searchable stories since our launch thirteen years ago. Registered Members also gain access to GlobeSt.InterActive, GlobeSt.com AM/PM alerts and GlobeSt exclusives including white papers, webinars and videos.
To activate your GlobeSt.com Registration, Register Now for FREE.
Back to the Top 2015 ALM Media Properties, LLC. All rights reserved. Home | About Us | Privacy Policy | Terms of Service


text:
THE SQL Server Blog Spot on the Web
I'm increasingly recommending cloud based strategies to both drive down costs and simplify things. Cloud technology is now at a point there there are very clear guidelines and frameworks for addressing security concerns. Take a look at the Microsoft Azure Trust Center for a list of all of the security certifications Microsoft has earned.
Notice that Microsoft has a P-ATO (Provisional Authority to Operate) from FedRAMP, the United States federal government cloud computing watchdog agency. FedRAMP addresses IaaS, PaaS, and SaaS. Of particular interest to those in healthcare is Microsoft is the HIPAA Business Associate Agreement or BAA. The Microsoft HIPAA/HITECH Act Implementation Guidance whitepaper is found here. A list of FedRAMP compliant cloud providers is found here.
Small businesses can in many cases be better off by eliminating their server rooms and moving them off premises to the cloud. I did some consulting for a law firm a few years ago after a catastrophic failure of a SQL Server. SQL Azure wasn't available back then, but it would be my recommendation to that firm today.
While testing exports of SQL Server tables to files, one thing led to another and I started investigating the file server where the files are saved. Finding files on the server seemed slow. Further investigation revealed several MSDN and TechNet posts on how 8.3 file names adversely affect both file enumeration and creation performance. This post provides a detailed description of how slow file server performance was found to be caused by having 8.3 files names enabled. This post explains how 8.3 file names can be exploited to sneak a malicious exe onto your server by hiding it in safe file name such as a txt file.
This post explains how to check for and disable 8.3 file names. Pay particular attention to how you also need to do 8.3 name stripping to realize the maximum benefit of disabling 8.3 file names. I'm going to stop short of recommending that you do 8.3 name stripping. Here's some edited output from my desktop that might make you want to proceed with extreme caution:
C:\Windows\system32>fsutil 8dot3name set C: 1 Successfully disabled 8dot3name generation on C:
C:\Windows\system32>fsutil 8dot3name strip /s /v C:\
@C:\PROGRA~2\WIC4A1~1\Writer\WI68BE~1.DLL,-1001 HKU\S-1-5-18\Software\Classes\Local Settings\MuiCache\452\52C64B7E
Total affected registry keys: 2148
The operation failed because registry entries refer to 8dot3 names in the specified path. For details on the affected registry keys please see the log: "C:\Users\John\AppData\Local\Temp\8dot3_removal_log @(GMT 2014-04-05 02-42-36).log"
Let's take a look at the log file.
Registry Data Registry Key Path ------------------------------------------------------------------------------- ------------------------------------------ C:\PROGRA~1\MICROS~2\Office15\1033\ACCESS12.ACC HKCR\.accdb\Access.Application.15\ShellNew C:\PROGRA~1\MICROS~2\Office15\MSACCESS.EXE,0 HKCR\Access\DefaultIcon C:\PROGRA~1\MICROS~2\Office15\PROTOC~1.EXE "%1" HKCR\Access\shell\open\command C:\PROGRA~1\MICROS~2\Office15\MSACCESS.EXE /NOSTARTUP "%1" HKCR\Access.ACCDAExtension.15\shell\open\command "C:\PROGRA~1\MICROS~2\Office15\MSOHTMED.EXE" "%1" HKCR\Access.Application.15\HTML Handler "C:\PROGRA~1\MICROS~2\Office15\MSOHTMED.EXE" /o3 "%1" HKCR\Access.Application.15\HTML Handler\shell\edit\command "C:\PROGRA~1\MICROS~2\Office15\EXCEL.EXE" /dde HKCR\Access.Application.15\search\AnalyzeInExcel\command C:\PROGRA~1\MICROS~2\Office15\MSACCESS.EXE /NOSTARTUP "%1" HKCR\Access.Extension.15\shell\open\command C:\PROGRA~1\MICROS~2\Office15\MSACCESS.EXE,42 HKCR\Access.LockFile.15\DefaultIcon C:\PROGRA~1\MICROS~2\Office15\MSACCESS.EXE /NOSTARTUP /SHELLSYSTEM [PrintTo "%1"][ShellQuit] HKCR\Access.Shortcut.Form.1\shell\print\command C:\PROGRA~1\MICROS~2\Office15\MSACCESS.EXE /NOSTARTUP /SHELLSYSTEM [PrintTo "%1","%2","%3","%4"][ShellQuit] HKCR\Access.Shortcut.Form.1\shell\printto\command C:\PROGRA~1\MICROS~2\Office15\MSACCESS.EXE /NOSTARTUP /SHELLSYSTEM [OpenQuery "%1"] HKCR\Access.Shortcut.Query.1\shell\open\command C:\PROGRA~1\MICROS~2\Office15\MSACCESS.EXE /NOSTARTUP /SHELLSYSTEM [PrintTo "%1"][ShellQuit] HKCR\Access.Shortcut.Query.1\shell\print\command C:\PROGRA~1\MICROS~2\Office15\MSACCESS.EXE /NOSTARTUP /SHELLSYSTEM [PrintTo "%1","%2","%3","%4"][ShellQuit] HKCR\Access.Shortcut.Query.1\shell\printto\command C:\PROGRA~1\MICROS~2\Office15\MSACCESS.EXE /NOSTARTUP /SHELLSYSTEM [PrintTo "%1"][ShellQuit] HKCR\Access.Shortcut.Report.1\shell\print\command C:\PROGRA~1\MICROS~2\Office15\MSACCESS.EXE /NOSTARTUP /SHELLSYSTEM [PrintTo "%1","%2","%3","%4"][ShellQuit] HKCR\Access.Shortcut.Report.1\shell\printto\command C:\PROGRA~1\MICROS~2\Office15\MSACCESS.EXE /NOSTARTUP /SHELLSYSTEM [OpenTable "%1"] HKCR\Access.Shortcut.Table.1\shell\open\command C:\PROGRA~1\MICROS~2\Office15\MSACCESS.EXE /NOSTARTUP /SHELLSYSTEM [PrintTo "%1"][ShellQuit] HKCR\Access.Shortcut.Table.1\shell\print\command C:\PROGRA~1\MICROS~2\Office15\MSACCESS.EXE /NOSTARTUP /SHELLSYSTEM [PrintTo "%1","%2","%3","%4"][ShellQuit] HKCR\Access.Shortcut.Table.1\shell\printto\command C:\PROGRA~1\MICROS~2\Office15\MSACCESS.EXE,0 HKCR\Access.UriLink.15\DefaultIcon C:\PROGRA~1\MICROS~2\Office15\PROTOC~1.EXE "%1" HKCR\Access.UriLink.15\shell\open\command C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE15\MSOICONS.EXE,6 HKCR\ACLFile\DefaultIcon C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE15\MSOICONS.EXE,6 HKCR\AWFile\DefaultIcon C:\PROGRA~1\MICROS~2\Office15\Lync.exe,0 HKCR\callto\DefaultIcon "C:\PROGRA~1\MICROS~2\Office15\Lync.exe" "%1" HKCR\callto\shell\open\command C:\PROGRA~1\MICROS~2\Office15\OUTLRPC.DLL HKCR\CLSID\{0002034C-0000-0000-C000-000000000046}\InprocServer32
C:\Program Files\WindowsApps\Microsoft.BingFinance_2014.221.1803.4346_neutral_~_8wekyb3d8bbwe\AppxMetadata\AppxBundleManifest.xml HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Appx\AppxAllUserStore\Applications\Microsoft.BingFinance_2014.221.1803.4346_neutral_~_8wekyb3d8bbwe C:\Program Files\WindowsApps\Microsoft.BingFoodAndDrink_2014.228.447.1992_neutral_~_8wekyb3d8bbwe\AppxMetadata\AppxBundleManifest.xml HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Appx\AppxAllUserStore\Applications\Microsoft.BingFoodAndDrink_2014.228.447.1992_neutral_~_8wekyb3d8bbwe C:\Program Files\WindowsApps\Microsoft.BingHealthAndFitness_2014.221.713.446_neutral_~_8wekyb3d8bbwe\AppxMetadata\AppxBundleManifest.xml HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Appx\AppxAllUserStore\Applications\Microsoft.BingHealthAndFitness_2014.221.713.446_neutral_~_8wekyb3d8bbwe C:\Program Files\WindowsApps\Microsoft.BingMaps_2014.130.2132.1189_neutral_~_8wekyb3d8bbwe\AppxMetadata\AppxBundleManifest.xml HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Appx\AppxAllUserStore\Applications\Microsoft.BingMaps_2014.130.2132.1189_neutral_~_8wekyb3d8bbwe
@C:\PROGRA~2\MICROS~3.0\VC\bin\vcmui.dll,-101 HKU\S-1-5-18\Software\Classes\Local Settings\MuiCache\452\52C64B7E @C:\PROGRA~2\WI3CF2~1\8.1\WINDOW~1\WINDOW~1.DLL,-101 HKU\S-1-5-18\Software\Classes\Local Settings\MuiCache\452\52C64B7E @C:\PROGRA~2\WIC4A1~1\Writer\WI68BE~1.DLL,-1001 HKU\S-1-5-18\Software\Classes\Local Settings\MuiCache\452\52C64B7E
Things were much simpler on my E drive and didn't cause me to worry or wonder if there were unintended consequences.
C:\Windows\system32>fsutil 8dot3name strip /s /v E:\ Scanning registry... Registry Data Registry Key Path ------------------------------------------------------ ------------------------------------------
Total affected registry keys: 0
Stripping 8dot3 names...
8dot3 Name FileId Full Path ------------- ------------------- -------------------------------------------------------------
Total files and directories scanned: 4936 Total 8dot3 names found: 0 Total 8dot3 names stripped: 0
For details on the operations performed please see the log: "C:\Users\John\AppData\Local\Temp\8dot3_removal_log @(GMT 2014-04-05 02-58-52).log"
My recommendations:
1. On installation of a new volume, disable 8.3 file name creation before putting any files on it.
2. On a new server build, disable 8.3 file name creation in the registry.
3. Don't trust my recommendations. Educate yourself and test thoroughly. Then test some more.
If you think this might only be a file server issue, think again. I'm preparing a SQL Server for FILESTREAM access. I can see a FILESTREAM enabled SQL Server having enough files that 8.3 file names might affect performance.
I've observed that not very many data professionals are familiar with OData. It's an open data access protocol built on AtomPub and JSON. It provides a RESTful means of retrieving data, which is what this post is about.
One of the things that makes OData important is that it is recommended by the Open Government Data Initiative. Although this post uses the familiar SQL Server AdventureWorks database, remember, OData is open. It's not limited to SQL Server or even SQL databases in general.
A small subset of AdventureWorks is published at http://services.odata.org/AdventureWorksV3/AdventureWorks.svc
Figure 1. AdventureWorks subset published at OData.org
Open Excel that has the Power Query add-in installed and select the POWER QUERY tab. Select From Other Sources and then choose From OData Feed.
Figure 2. Selecting From OData Feed.
Enter the URL for the AdventureWorks OData source and click OK.
Figure 3. Specifying an OData source.
Notice that the Power Query Navigator has a popup for peeking at the data.
Figure 4. Peeking at the data.
Double-click CompanySales to open the Query Editor. You can rename and delete columns as well as several other changes you might want to check out.
Figure 5. Query Editor
After clicking Apply & Close, the data was loaded into the spreadsheet.
Figure 6. CompanySales from OData loaded into Excel.
Notice how the query indicates when it was last updated. It's important to understand this isn't just a static one time download. This is a data model in Excel that is connected to a live data source. Go to the DATA tab and select Refresh All.
Figure 7. Notice that the last updated time has changed to reflect the update.
By taking advantage of new data management features in Excel, you're no longer stuck with static, stale spreadsheets.
We've all seen data on a web page and wished we had it in Excel. Copying a table from a web page and pasting it into Excel often leads to disappointing results. Power Query makes it easy to import data from a web page into Excel. As a nurse, I'm particularly interested in analyzing public health data for research purposes. I found some good data on tuberculosis treatment success rates at the World Bank's website. You can find the data here. The screen captures in this post were made on a Windows 8.1 desktop with Office 2013. Power Query was downloaded from here.
Figure 1. World Bank tuberculosis data.
On the POWER QUERY tab in Excel, click From Web to bring up a dialog box for entering the web page's URL. Enter the URL for your web page and click OK.
Figure 2. Enter the web page URL into the Power Query dialog box and click OK.
After a few seconds, Excel presents the DOM in the Power Query Navigator. Use the Peek feature to examines the contents of the items in the Navigator list.
Figure 3. Mouseover on Table 0 invokes the Peek feature to show a preview of the table on the World Bank's web page.
Double-clicking Table 0 in the Navigator brings up the Query Editor.
Figure 4. Table imported from web page ready for editing.
Edit the data as needed before completing the import process. I deleted the two rightmost columns and named the table TB Treatment Success Rates.
Figure 5. Editing the imported table.
Click Apply & Close to close the Query Editor and complete the import process.
Figure 6. Data imported from World Bank web page table into Excel.
Power Query is a very useful addition to Excel that makes it easy to conveniently and quickly bring data from just about any data source into Excel. I find it a valuable tool to use both at work and at school.
Either SQL Server Management Studio (SSMS) or Visual Studio can be used for database development. I put them side by side into a single composite screen capture where you literally see the gaps between the products. SQL Server 2012 was installed with all features selected and default settings. The only modifications to the SQL Server installation were the additions of the AdventureWorks2012 and AdventureWorks2012DW databases.
Using Visual Studio instead of SSMS for database application development gives you the advantage of integration with Team Foundation Server for source code control. Additionally, localdb gives you a way to debug stored procedures locally in case your DBA won't grant you sufficient rights to debug on the database server. You can copy your production schema to your localdb and debug from within Visual Studio.
Figure 1. SQL Server 2012 Management Studio on the left, Visual Studio 2013 on the right. Screen captures made on Windows 8.1.
Regular expressions can easily and quickly remove trailing spaces from every line in your query window as well as a few other tasks I'll explain. To get started, you need to know how to specify the end of a line. There are two ways to specify the end of a line. You can use the " \n" escape sequence or the end of line metacharacter "$". Figure 1 shows how to remove a single trailing space from however many lines end that way. A more robust regular expression is shown in Figure 2. And a reader offers a keyboard shortcut to do the same thing without using regular expressions – see the comments section at the bottom. Removing extra blank lines is also described at the end of the post.
Figure 1. Replace space newline " \n" with newline "\n" to remove one trailing space.
The problem with the syntax shown in Figure 1 is that you'll have to iteratively click Replace All multiple times if you have more than one trailing space on some lines.
There is an easy fix that will remove all trailing spaces from all lines with a single Replace All. Add a "+" sign after the space and before the "\n" escape sequence. In other words, you want to use " +\n" as your search string.
Figure 2. Replace space plus newline " +\n" with newline "\n" to remove all trailing spaces.
Alternatively, you can use the end of line metacharacter expression " +$" as your search string and have no replacement string.
Figure 3. Replace space plus dollar " +$" with nothing to remove all trailing spaces.
Notice that I used " and " to delimit my find and replace strings. As the screen captures show, there aren't any quotes around the find and replace strings.
Once you understand the pattern of using the "+" metacharacter, you can extend it to other edits such as normalizing inline comments to be exactly two consecutive dashes. Sometime you will see inline comments with more than two consecutive dashes. Use "--+" as your search string and "--" as your replacement string. Don't use "-+" as your search string because it would change a single dash to two consecutive dashes. That's why you should use use "--+" to find all occurrences of two or more dashes.
Figure 4. Replace dash dash plus "--+" with dash dash "--" to normalize inline comments at two dashes.
Once you understand the "\n" escape sequence for the end of a line, you can use this knowledge to remove superfluous blank lines. Sometimes when copy and pasting from a web page or email, you end up with a blank line inserted after each line in the source. This is easy to fix using regular expressions. When a blank line follows a line of text, you have two consecutive newline characters. Use "\n\n" as your search string and "\n" as your replacement string to remove the superfluous blank lines as shown in Figure 5.
Figure 4. Regular expression to remove superfluous lines when every other line is blank.
SQL Server 2012 introduces new windowing functions beyond the basic ranking functions of RANK, DENSE_RANK, NTILE, and ROW_NUMBER. The LAG function is particularly useful when comparing data in the current time period to the previous period. Period to period changes in sales, nosocomial infection rates, and manufacturing defects are just some examples of where a LAG function can simplify your code. The purpose of this post is to provide a basic introduction. Subsequent posts will discuss more advanced queries.
The traditional approach to comparing a previous period to a current period is to use a self-join, which is illustrated in the first SELECT statement shown below. Notice that the condition on the Tempus column reduces the 12 months (rows) of data to 11 rows. This is expected for the data and logic in the complete example shown further down the page. Also notice that the logic for matching data in the Tempus column with the previous time period works only within the same year when using dates formatted as shown. For example, 201212 + 1 won't match with 201301. This could be fixed by using date formatting functions including DATEADD. The point here is that dates typically require additional work if you want a robust, generic solution.
SELECT c.Employee , c.Tempus , p.Quantity AS PreviousQuantity , c.Quantity AS CurrentQuantity FROM #Sales p INNER JOIN #Sales c ON c.Employee = p.Employee WHERE c.Tempus = p.Tempus + 1;
Employee Tempus PreviousQuantity CurrentQuantity -------- ------ ---------------- --------------- 1 201302 100 200 1 201303 200 150 1 201304 150 175 1 201305 175 200 1 201306 200 250 1 201307 250 275 1 201308 275 300 1 201309 300 350 1 201310 350 400 1 201311 400 200 1 201312 200 300
(11 row(s) affected)
Now look at the output from using the LAG function. Notice that 12 rows are returned. This is important when you want to add aggregations to your result set, but this is a topic for a future post on more advanced techniques. The logic for processing the Tempus column is intrinsically more robust and simpler when using the LAG function.
Employee Tempus PreviousQuantity CurrentQuantity -------- ------ ---------------- ---------------- 1 201301 NULL 100 1 201302 100 200 1 201303 200 150 1 201304 150 175 1 201305 175 200 1 201306 200 250 1 201307 250 275 1 201308 275 300 1 201309 300 350 1 201310 350 400 1 201311 400 200 1 201312 200 300
(12 row(s) affected)
Now that you can see the quantities for each time period and its immediate predecessor, you're probably going to want to compute percentage changes from one time period to another.
Employee Tempus PreviousQuantity CurrentQuantity PercentageChange -------- ------ ---------------- --------------- ------------------- 1 201301 NULL 100 NULL 1 201302 100 200 100.000000000000000 1 201303 200 150 -25.000000000000000 1 201304 150 175 16.666666666666667 1 201305 175 200 14.285714285714286 1 201306 200 250 25.000000000000000 1 201307 250 275 10.000000000000000 1 201308 275 300 9.090909090909091 1 201309 300 350 16.666666666666667 1 201310 350 400 14.285714285714286 1 201311 400 200 -50.000000000000000 1 201312 200 300 50.000000000000000
I highly recommend that you purchase Itzik Ben Gan's book Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions to acquire an in-depth knowledge of windowing functions. Itzik reviewed my code and suggested the addition of the index commented out in the code sample shown below. I recommend running the queries with and without the index to see how the index causes the SORT operator to drop out of the query plan.
CREATE TABLE #Sales ( Employee NVARCHAR(30) ,Tempus DECIMAL ,Quantity DECIMAL );
INSERT INTO #Sales (Employee, Tempus, Quantity) VALUES (1, 201301, 100) ,(1, 201302, 200) ,(1, 201303, 150) ,(1, 201304, 175) ,(1, 201305, 200) ,(1, 201306, 250) ,(1, 201307, 275) ,(1, 201308, 300) ,(1, 201309, 350) ,(1, 201310, 400) ,(1, 201311, 200) ,(1, 201312, 300) ; --Suggestion from Itzik Ben-Gan to eliminate the sort operation shown in the query plan. --CREATE INDEX IDX_Sales_Employee_tempus ON #Sales(Employee, Tempus) INCLUDE (Quantity);
-- traditional solution using a self-join -- notice a different approach is required if Tempus data included other years SELECT c.Employee , c.Tempus , p.Quantity AS PreviousQuantity , c.Quantity AS CurrentQuantity FROM #Sales p INNER JOIN #Sales c ON c.Employee = p.Employee WHERE c.Tempus = p.Tempus + 1;
-- LAG function used to get date from the previous period -- easier and more robust logic for handling the Tempus column SELECT Employee ,Tempus ,LAG(Quantity) OVER (PARTITION BY Employee ORDER BY Tempus ASC) AS PreviousQuantity ,Quantity AS CurrentQuantity FROM #Sales;
-- Create an alias for the previous query and computer percentage change SELECT Employee ,Tempus ,PreviousQuantity ,CurrentQuantity ,(CurrentQuantity - PreviousQuantity) / PreviousQuantity * 100.0 AS PercentageChange FROM (SELECT Employee ,Tempus ,LAG(Quantity) OVER (PARTITION BY Employee ORDER BY Tempus ASC) AS PreviousQuantity ,Quantity AS CurrentQuantity FROM #Sales) AS Sales;
DROP TABLE #Sales;
Windowing functions provide a layer of abstraction that can simplify many coding tasks. Complicated tasks become simple tasks, often with a significant performance improvement.
It's not possible to directly make a shortcut for a modern UI app like you do for a conventional application, but there is a workaround. You can add the shortcut to the desktop, the taskbar, or a custom toolbar menu. After my previous post on adding a toolbar menu for SQL Server, I have additional suggestions on making custom toolbar menus.
Skype on Windows 8.1 is a modern UI app that I wanted on my taskbar. That requires creating a shortcut, which isn't as simple as right-clicking the exe and selecting Create shortcut.
Figure 1. This approach doesn't work for modern UI apps.
Here are the properties for my modern UI Skype shortcut:
Figure 2. Notice the shortcut uses explorer.exe to invoke Skype.
Creating the shortcut isn't difficult, provided you know what string to use for the modern UI application. Use Control Panel to begin the process of finding the application's URL. Within Control Panel, use associate as your search string.
Figure 3. Search using associate as the search string and then select Change the file type associated with a file extension.
You won't be changing any file extensions. It is necessary to scroll down past the file extensions until you see Protocols. Within the Protocols section, scroll down to find the URL for the Skype application.
Figure 4. The URL for Skype is URL:skype
Once you find the URL for a modern UI app, you'll use just the string value to create a target for your shortcut that follows the pattern shown in the this example:
C:\Windows\explorer.exe skype://
At this point, you have a working shortcut that will invoke your modern UI app. If you want a transparent icon to go with your shortcut, there's more work to do. Most of the modern UI apps that come with Windows 8 are found in C:\Program Files\WindowsApps, which you don't have access to by default even if you are an administrator.
Figure 5. Default permissions for C:\Program Files\WindowsApps
You can either give yourself permissions if you are an administrator or use a command window. I decided to avoid changing security settings and used a command window and DOS commands instead.
C:\Program Files\WindowsApps>dir Volume in drive C has no label. Volume Serial Number is 5614-4F17
Directory of C:\Program Files\WindowsApps
01/03/2014 05:50 PM <DIR> 4DF9E0F8.Netflix_184.108.40.206_x64__mcm4njqhnhss8 01/04/2014 11:52 AM <DIR> Deleted 12/15/2013 09:56 PM <DIR> Microsoft.BingFinance_2013.1119.716.4094_neutral_~_8wekyb3d8bbwe 12/15/2013 07:59 PM <DIR> Microsoft.BingFinance_188.8.131.52_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.BingFinance_184.108.40.2069_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.BingFinance_220.127.116.119_x64__8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.BingFoodAndDrink_2013.1009.24.3213_neutral_~_8wekyb3d8bbwe 12/15/2013 07:59 PM <DIR> Microsoft.BingFoodAndDrink_188.8.131.52_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.BingFoodAndDrink_188.8.131.52_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.BingFoodAndDrink_184.108.40.206_x64__8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.BingHealthAndFitness_2013.1202.919.1616_neutral_~_8wekyb3d8bbwe 12/15/2013 07:59 PM <DIR> Microsoft.BingHealthAndFitness_220.127.116.11_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.BingHealthAndFitness_188.8.131.525_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.BingHealthAndFitness_22.214.171.1245_x64__8wekyb3d8bbwe 12/15/2013 07:59 PM <DIR> Microsoft.BingMaps_2.0.2009.2356_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.BingMaps_2.0.2210.2401_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.BingMaps_2.0.2210.2401_x64__8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.BingMaps_2013.1010.2301.1978_neutral_~_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.BingNews_2013.1123.1312.1382_neutral_~_8wekyb3d8bbwe 12/15/2013 07:59 PM <DIR> Microsoft.BingNews_18.104.22.168_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.BingNews_22.214.171.1241_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.BingNews_22.214.171.1241_x64__8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.BingSports_2013.1010.2028.5997_neutral_~_8wekyb3d8bbwe 12/15/2013 07:59 PM <DIR> Microsoft.BingSports_188.8.131.52_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.BingSports_220.127.116.11_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.BingSports_188.8.131.52_x64__8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.BingTravel_2013.1010.223.1706_neutral_~_8wekyb3d8bbwe 12/15/2013 07:59 PM <DIR> Microsoft.BingTravel_126.96.36.199_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.BingTravel_220.127.116.11_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.BingTravel_18.104.22.168_x64__8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.BingWeather_2013.1010.2033.469_neutral_~_8wekyb3d8bbwe 12/15/2013 07:59 PM <DIR> Microsoft.BingWeather_188.8.131.52_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.BingWeather_22.214.171.124_neutral_split.scale-140_8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.BingWeather_220.127.116.11_x64__8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.HelpAndTips_2013.1004.255.5080_neutral_~_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.HelpAndTips_6.3.9600.20274_neutral_HelpAndTips.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.HelpAndTips_6.3.9600.20274_x64__8wekyb3d8bbwe 12/15/2013 09:36 PM <DIR> Microsoft.Internal.Media.PlayReadyClient_2.3.1678.1_x86__8wekyb3d8bbwe 09/29/2013 10:08 PM <DIR> Microsoft.Media.PlayReadyClient.2_2.8.1947.0_x64__8wekyb3d8bbwe 09/29/2013 10:08 PM <DIR> Microsoft.Media.PlayReadyClient.2_2.8.1947.0_x86__8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.Reader_2013.1007.1759.4672_neutral_~_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.Reader_6.3.9600.16422_neutral_glcnd.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.Reader_6.3.9600.16422_x64__8wekyb3d8bbwe 12/15/2013 07:59 PM <DIR> Microsoft.SkypeApp_22.214.171.12411_neutral_split.scale-140_kzf8qxf38zg5c 12/15/2013 09:56 PM <DIR> Microsoft.SkypeApp_22.214.171.1248_neutral_split.scale-140_kzf8qxf38zg5c 12/15/2013 09:56 PM <DIR> Microsoft.SkypeApp_22.214.171.1248_x86__kzf8qxf38zg5c 12/15/2013 09:56 PM <DIR> Microsoft.SkypeApp_2013.1112.1630.458_neutral_~_kzf8qxf38zg5c 12/15/2013 09:36 PM <DIR> Microsoft.VCLibs.120.00.Preview.Internal_12.0.20222.2_x64__8wekyb3d8bbwe 12/15/2013 09:36 PM <DIR> Microsoft.VCLibs.120.00.Preview.Internal_12.0.20222.2_x86__8wekyb3d8bbwe 12/15/2013 09:36 PM <DIR> Microsoft.VCLibs.120.00_12.0.21005.1_x64__8wekyb3d8bbwe 12/15/2013 09:36 PM <DIR> Microsoft.VCLibs.120.00_12.0.21005.1_x86__8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.WindowsAlarms_2013.1204.852.3011_neutral_~_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.WindowsAlarms_6.3.9654.20335_neutral_Time.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.WindowsAlarms_6.3.9654.20335_x64__8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.WindowsCalculator_2013.1007.1950.2960_neutral_~_8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.WindowsCalculator_6.3.9600.20278_neutral_Numbers.scale-140_8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.WindowsCalculator_6.3.9600.20278_x64__8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> microsoft.windowscommunicationsapps_17.5.9600.20315_neutral_comm.scale-140_8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> microsoft.windowscommunicationsapps_17.5.9600.20315_x64__8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> microsoft.windowscommunicationsapps_2013.1113.2124.1473_neutral_~_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.WindowsReadingList_2013.1119.2112.818_neutral_~_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.WindowsReadingList_6.3.9654.20321_neutral_Stash.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.WindowsReadingList_6.3.9654.20321_x64__8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.WindowsScan_2013.1007.2015.3834_neutral_~_8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.WindowsScan_6.3.9600.16422_neutral_ScanApp.scale-140_8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.WindowsScan_6.3.9600.16422_x64__8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.WindowsSoundRecorder_2013.1010.500.2928_neutral_~_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.WindowsSoundRecorder_6.3.9600.20280_neutral_SoundRecorder.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.WindowsSoundRecorder_6.3.9600.20280_x64__8wekyb3d8bbwe 12/15/2013 09:36 PM <DIR> Microsoft.WinJS.2.0.Preview.Internal_1.0.9385.3_neutral__8wekyb3d8bbwe 12/15/2013 09:36 PM <DIR> Microsoft.WinJS.2.0.Preview_1.0.9431.0_neutral__8wekyb3d8bbwe 12/15/2013 09:35 PM <DIR> Microsoft.WinJS.2.0_1.0.9600.16408_neutral__8wekyb3d8bbwe 12/15/2013 09:34 PM <DIR> Microsoft.WinJS.Preview.1_1.0.9345.0_neutral__8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.XboxLIVEGames_126.96.36.199_x64__8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.XboxLIVEGames_2013.1011.10.5965_neutral_~_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.ZuneMusic_2.2.299.0_neutral_resources.scale-140_8wekyb3d8bbwe 12/15/2013 09:56 PM <DIR> Microsoft.ZuneMusic_2.2.299.0_x64__8wekyb3d8bbwe 12/15/2013 07:59 PM <DIR> Microsoft.ZuneMusic_188.8.131.52_neutral_resources.scale-140_8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.ZuneMusic_2013.1116.205.2878_neutral_~_8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.ZuneVideo_2.2.299.0_neutral_resources.scale-140_8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.ZuneVideo_2.2.299.0_x64__8wekyb3d8bbwe 12/15/2013 07:59 PM <DIR> Microsoft.ZuneVideo_126.96.36.199_neutral_resources.scale-140_8wekyb3d8bbwe 12/15/2013 09:55 PM <DIR> Microsoft.ZuneVideo_2013.1116.205.5085_neutral_~_8wekyb3d8bbwe 0 File(s) 0 bytes 83 Dir(s) 437,786,386,432 bytes free
Notice there are four directories for Skype:
The full path to the third directory is C:\Program Files\WindowsApps\Microsoft.SkypeApp_22.214.171.1248_x86__kzf8qxf38zg5c
You can navigate directly to that folder in Windows Explorer even though you can't navigate to the parent folder as shown previously.
Figure 6. The color icons for Skype are in subfolders of the images folder.
I decided to use skypeSmall.png in C:\Program Files\WindowsApps\Microsoft.SkypeApp_184.108.40.2068_x86__kzf8qxf38zg5c\images\targetsize-32 for creating my transparent icon.
Figure 7. skypeSmall.png must be converted into a transparent icon.
Although Paint can be used to save a graphics file as an icon file, it won't have any transparency. An icon editor is needed to perform the task efficiently. I used a portable version of IcoFx because it is free and I didn't want to install anything extra on my machine. Open the png in IcoFx to create an ico file with transparency.
Figure 8. Use True Color + Alpha Channel (32 bits) to create a transparent icon in IcoFx.
Figure 9. Click File and select Save As to complete the process of creating your ico file.
After creating your icon file, use the Change Icon button on the Properties pages for your shortcut.
Figure 10. Click the Change Icon button.
Select your new icon and click OK and OK to update your shortcut.
Figure 11. Select your new icon file.
I copied the icon file to C:\ProgramData\Microsoft\Windows\Start Menu\Programs and made a custom toolbar which worked, but not quite as intended as I later discovered. What I should have done is create a copy of the C:\ProgramData\Microsoft\Windows\Start Menu\Programs folder, modify the copy, and make a custom toolbar pointing to the copy. That's what I eventually did.
Figure 12. Creating a custom toolbar.
The problem with adding the new Skype shortcut to C:\ProgramData\Microsoft\Windows\Start Menu\Programs is that it will also appear under Apps in the modern UI – not what is desired. It's a good idea not to make any changes to that folder.
Here is what I recommend. Copy the entire C:\ProgramData\Microsoft\Windows\Start Menu\Programs folder to another location. I choose the my Documents folder to store the copy. Add the Skype shortcut to your copy. Make any further customizations to the copy. Create a custom toolbar pointing to the copy.
Figure 13. Point your custom toolbar to a customized copy of C:\ProgramData\Microsoft\Windows\Start Menu\Programs
Figure 14. Custom toolbar showing cascading menus. Notice that the shortcut for Skype was added.
If you want to add your new Skype shortcut to your taskbar, go to the copy of the Programs folder and right-click the shortcut and select Pin to Taskbar.
Figure 15. Pinning the shortcut to the taskbar.
Figure 16. Shortcut pinned to taskbar.
Windows 8.1 has a very capable modern UI mail program simply called Mail. Installing Outlook 2013 does not fully replace it because one default remains with Mail, the mailto association. To change the association to Outlook, go to Control Panel, select Default Programs, and then select Set your default programs.
Figure 1. Default Programs. Select Set your default program.
Figure 2. Notice that not all of the defaults are associated with Outlook 2013.
Figure 3. Notice that mailto is not associated with Outlook 2013.
Figure 4. Select Set this program as default to make Outlook 2013 the default for all mail related actions.
If you do most of your work with SQL Server, you're going to be working primarily in the desktop experience. You can easily take the modern UI menu and expose it on the desktop as a series of Windows 7 style cascading menus.
Figure 1. Modern UI menu for SQL Server.
The first thing you need to know is find out where the SQL Server menu items are stored. Go to the Apps page and right click on SQL Server Management Studio.
Figure 2. Right click on SQL Server Management Studio and then click or touch Open file location.
Windows Explorer will open in the desktop with the selected shortcut highlighted. Go to the address bar and select the path. Copy to your paste buffer. In this example, since the installation defaults were chosen, the path is C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2012
Figure 3. Select the path in the address bar and copy it to your paste buffer.
The next step is to right click the taskbar and create a new toolbar.
Figure 4. Right click the taskbar, select Toolbars, then select New toolbar.
Paste the previously saved path into the New Toolbar – Choose a folder dialog box or you can navigate to the location.
Figure 5. Paste the path into the Folder textbox and click Select Folder.
You now have a new toolbar that looks like a standard Windows 7 cascading menu.
Figure 6. SQL Server cascading menu added to the taskbar.
After installing Windows 8.1, there are several tricks and customizations worth considering if you develop software or want a user experience more like Windows 7. One neat feature is the popup menu shown below that appears after pressing the X key while holding down the Windows key (thank you Matthew Roche for that tip).
Figure 1. When in desktop mode, Windows key plus the X key displays this helpful menu.
Enabling Administrative Tools on the Apps part of the modern UI is easy to do. Bring up the charms bar and select Settings and then select Tiles.
Figure 2. Select Settings on the charms bar.
Figure 3. Select Tiles to see the option for displaying Administrative Tools.
After selecting Yes under Show administrative tools, you'll be able to see a new Administrative Tools section on the Apps part of your modern UI. If you have a particularly large screen (mine is a 2560x1600 30" monitor), you might want to also select Yes underneath Show more tiles.
Figure 4. Tiles options.
Figure 5. Administrative Tools appearing on Apps menu.
Windows 8.1 has essentially two Internet Explorers, one for the modern UI and one for the desktop that works like IE in Windows 7. This creates an inconsistency in the browsing experience for people who use IE both from the modern UI and also from the desktop. By changing the settings in the desktop version of IE, you can have it appear when browsing from the modern UI. By doing this, you'll have the same open windows regardless of where you start giving you a consistent, uniform browsing experience throughout Windows 8.1.
From the desktop experience, open Internet Explorer. Left mouse click the Tools menu, which is the icon that looks like a gear. Select Internet options.
Figure 6. Desktop version of IE, Tools menu.
On the Internet Options dialog box, select the Programs tab. Under Choose how you open links, select Always in Internet Explorer on the desktop and check Open Internet Explorer tiles on the desktop.
Figure 7. Internet Options, Program tab.
When you go back to the modern UI, web pages will now open in the desktop experience Internet Explorer.
I installed Windows 8.1 on a solid state drive (SSD) on my desktop. Whether you have a desktop, laptop, or tablet, SSDs provide excellent performance but tend to be lacking on capacity because of the cost. My desktop has a 512 MB SSD and multiple spinning hard drives with larger capacities. My Surface 2 tablet has a 32 GB SSD and a 64 GB micro SDXC card. I want to save the SSD for programs and offload large files (e.g., installation media, video) and Office files elsewhere. By changing properties of key folders, I can redirect the storage of files from one device to another.
My desktop presents an interesting case. It was a Windows 7 machine with all kinds of files large and small stored on the C drive, a spinning disk. Windows 8.1 was installed on a new SSD as the C drive. On Windows 8.1, that spinning drive containing Windows 7 is mapped to drive letter X. By repointing the Documents folder from C to X on Windows 8.1, I'll keep the SSD from getting cluttered with my files and I'll automatically be pointing to the existing files I was using under Windows 7. If I edit the files under Windows 8.1, the latest versions will be available on Windows 7 when I choose to boot into 7 instead of 8.1. By default, your profile is protected from access by others. Although I have a profile named John on both Windows 7 and Windows 8.1, John on Windows 7 is protected from access by John on Windows 8.1. That's why I used Windows Explorer to navigate to the Users folder on the hard drive (drive letter X on my machine) containing the Windows 7 installation. Then I selected the folder named John. A dialog box appeared telling me that I didn't have permission. I clicked Continue to get access to the folder. There are other approaches I could have taken, but I took this specific approach because it provided a nice visual representation of the progress, which was quite slow, taking about half an hour.
Figure 8. No permission to folder on the Windows 7 hard drive.
Figure 9. Green bar showing progress in obtaining permission to access files in the selected folder.
To move the Documents folder to a new location, go to Windows Explorer and select Documents. Select Properties. Select the Location tab. Specify the new location and click OK.
Figure 10. Selecting the Properties dialog box for Documents.
Figure 11. Moving Windows 8.1 Documents to a new location. Specify a new location and click OK.
Figure 12. Click Yes to complete the move.
If you have files in the old location that match file names in the new location, you'll see a warning dialog.
Figure 13. Warning dialog to prevent files from being overwritten.
After these steps, files under the Documents folder under my profile are no longer on my SSD and instead are on the much larger hard disk where Windows 7 is installed. On my Surface 2 tablet, the secure micro SDXC card is drive letter D. A D:\Users\John\Documents folder hierarchy was created and the Documents folder was relocated to that location.
Another handy trick is something that comes from Windows 7. You can create a folder on your desktop to access all of the settings on your machine. After creating the folder, rename it to something of this format: anyNameYouWant.{ED7BA470-8E54-465E-825C-99712043E01C}
Figure 14. Renaming a desktop folder to settings.{ED7BA470-8E54-465E-825C-99712043E01C}
After renaming the folder, it will have a different icon signifying its special purpose.
Figure 15. settings folder icon
Double-click the settings folder on your desktop to see a list of all of the administrative applets on your computer.
Figure 16. Windows 8.1 settings all in one convenient place.
Windows 8.1 has a screen capture keyboard shortcut that was used to make some of the screen captures in this blog post. If you press the print screen key while holding down the Windows key, your entire screen or screens will be automatically saved into the Screenshots folder found in your Pictures folder. If you're using a tablet, you won't have a print screen key, so you should hold down the Windows key and press the volume down button to capture the screen into your Screenshots folder.
Figure 17. Screenshots folder.
This blog post was written using Windows Live Writer, which is part of Windows Essentials.
Figure 18. Windows Essentials download page.
I recommend only installing the Writer program because Windows 8.1 comes with newer or alternate versions of the other programs.
Figure 19. Selecting only Windows Live Writer.
Figure 20. Windows Live Writer has a dependency on earlier versions of the .NET Framework.
This week's massive security breach of Target's database caused me to pay extra attention to my credit card purchases. I found fraudulent charges, but I don't know if the root cause is the Target breach or something else. If your company accepts credit card payments online, there is a lesson for you in how you should treat your customers. If you accept credit cards for automatic monthly payments, what happens when a card is denied? Do you help the customer or punish the customer?
I have been inconvenienced in two ways today. My time has been wasted. First, I had to spend time with American Express getting charges removed from my bill. Every Saturday I use Quicken to check all of my balances, which were $1,000 over my expectations. I had fraudulent charges of $499.95 from steampowered.com and $498.98 from steamgames.com, which appear to be the same company. I have no evidence good or bad about that company's antifraud procedures and they are not the subject of this post. There were also three temporary authorizations of $1.06 each to McAfee in Plano, TX which I reported as fraud.
The real inconvenience began after reporting the fraudulent charges to American Express. I have seven preauthorized payments linked to my American Express card. That's where your company comes in. Credit card fraud is a fact of life. So are preauthorized automatic monthly payments made by credit card. Sooner or later, your customers are going to have to change the credit card number because of fraud. Think through this carefully. Your company isn't in any way responsible for the credit card fraud. The customer chose to use a particular card number to pay you. If the customer ends up having to change the payment method through absolutely no fault whatsoever of your company, is it your problem? It is because whenever your customer has a problem, so do you.
Let's begin with my insurance company, Amica. I have three insurance policies with them, all billed to my credit card. I wasn't able to change the payment method once. I had to change the payment method for each policy. Sure, it's not Amica's fault that my credit card was stolen, but they made me do extra work to fully change payment methods. Comcast accepted my change of credit card, but informed me that it would apply to the next bill and that I needed to pay the current bill (due in about 2 weeks) if I wanted a different payment method. So, I had to enter the new credit card number twice. AT&T's bill is due about the same time, but the change I made at AT&T's website went into effect immediately. I didn't have to do the extra work that Comcast requires. But AT&T, although deserving of an honorable mention, isn't the customer service winner. The clear winner is the Harris County Toll Road Authority. Although I did login to my account and change the method of payment, I didn't actually have to. I could have done nothing and been fine, which is why they are the clear winner head and shoulders above the rest. If I am on vacation, I'd like to have the luxury of time to deal with the problem upon my return home.
The reason I could have done nothing is because the Harris County Toll Road Authority provides a means to enter a second payment method. If I had done nothing, the next month's charge would have been denied on the AMEX card, which would then cause the system to try the second card on file for the payment. Why is this so important? Because we're talking about charges levied by insurance companies, utilities, and government agencies. If your card is denied and you are on vacation, in the hospital, deployed in the military fighting terrorists, or your spam filter is a little too aggressive, you might miss the notice that your payment was denied. Credit card fraud can begin a cascade of steps resulting in you paying late fees or in a worst case scenario, having your utilities cut off, your insurance terminated, or your car impounded. When I shop for an electric service provider, my current provider, Reliant, goes to the bottom of the list because they don't offer a backup payment method. They aren't obligated to do so, they are meeting levels of service that are the norm today and they are within their rights not to provide a backup payment mechanism. But I want to minimize the risk of my electric service being terminated after my credit card is cancelled because of fraud. Depending on the nature of the fraud, the credit card company may terminate the card on their initiative and you might not know this immediately. That's why backup payment plans matter.
If you manage databases for your company, good security practices can help minimize risks. If you are storing credit card data in SQL Server, you need to implement strong security procedures and policies. Use BitLocker for drive level encryption. Use Transparent Data Encryption for database level protection. Configure your SQL Server 2008 or SQL Server 2012 for FIPS 140-2 certification. Run the SQL Server Best Practice Analyzer for 2012 or 2008 R2.
If you are in the United States and use credit cards, you can get a free credit report once a year. Visit the Federal Trade Commission website for the facts http://www.consumer.ftc.gov/articles/0155-free-credit-reports. You can get one free credit report per vendor per year and there are three vendors. I recommend getting a free report from one vendor, wait 4 months and get a free report from another vendor, wait 4 months and get a free report from the remaining vendor. By staggering your requests in this manner, you can end up with a free credit report every 4 months. It seems like a better idea than requesting from all three vendors at the same time. Married couples can alternate between spouses if credit is being reported jointly. In that case, married couples can get a free credit report every 2 months.
Quite by accident, I discovered a really nice free software product from Microsoft called Microsoft Mathematics. You can download the standalone version from here. There is also a Microsoft Mathematics add-in for Microsoft Word and OneNote with the 2010 version found here and the 2013 version found here.
Figure 1. Standalone version of Microsoft Math showing the Formula and Equations dropdown menu selections.
Figure 2. Gravitational formula with Plot this equation menu option selected.
Figure 3. Graph clearly showing that the force of gravity declines with increasing distance.
The add-in for Word and OneNote adds the Mathematics tab to the ribbon, which builds upon existing features for entering equations. The add-in provides computational and graphing features.
Figure 4. Mathematics tab selected with the mouse over the Equation menu.
After selecting an equation, the DESIGN tab is added to the ribbon.
Figure 5. Microsoft Mathematics DESIGN tab in Word.
Figure 6. 3D graph showing how the area is a function of the square of the radius.
The add-in provides an option to insert a graph into Word or OneNote.
Figure 7. Graph embedded into Word document.
I found Microsoft Mathematics to be easy to use.
Learn to program. It only takes an hour and it's free. You can learn how to code at an Apple store on December 11, 2014 or the entire week at a Microsoft retail store. Learn more about this project here.
Do you already know how to code? Teach someone who doesn't. You can spare an hour to empower someone else.
If your machine doesn't have a DVD drive, you'll either need to do a network boot or boot from USB. Fortunately making bootable USB media from an iso file is much easier. Microsoft has a free utility shown below that does it painlessly.
When installing Windows 8.1 or any operating system, you want to be thorough and get as much right the first time as you can. Since I wanted a clean, fresh install, I knew I'd be reinstalling all of my applications from scratch. This was a great opportunity to install an SSD. Whenever you get a new motherboard, you want the latest BIOS and whenever you get a new SSD, you want the latest firmware. That means you need to know what firmware you have. Update your firmware and BIOS before installing the operating system.
There's a lot of bad advice on the internet for finding the firmware version of your SSD. You can reboot your machine and watch the POST process and hopefully see the firmware version in the instant before it disappears. There's a more relaxed way of finding the firmware version. Some people advise you to install a program that will show you the firmware version, but that's not necessary. You should be able to get the information you need from Device Manager.
Figure 1. Open Disk drive in the Device Manager, select your SSD, right-click, select Properties.
Figure 2. Select the Details tab and then select Hardware Ids.
Figure 3. The firmware version of this SSD is 1.04
I updated the firmware of my SSD to 1.05. I was very disappointed in Plextor's firmware update utility. It displayed three identical messages about failing to "re-IDENTIFY", whatever that is. I assumed that the upgrade didn't work, so I ran the update utility again. It said I was at 1.05. Plextor should write a better utility.
Since I have an iso file instead of media, I wanted a way to copy the iso to a USB device and boot from it. Fortunately Microsoft has a free utility for doing this here. Don't worry about it saying Windows 7.
Figure 4. Microsoft ISO to bootable USB utility.
Figure 5. Pick your USB device.
Figure 6. Your USB device will be wiped clean.
Figure 7. Do you really have a choice if you want to do this?
Figure 8. How long this takes depends on the quality of the USB device.
Figure 9. All done!
I did notice a significant performance difference between an old USB device and a new, high quality USB device in terms of I/O performance.
Since Windows 8.1 is going onto a new drive, I decided to keep my Windows 7 installation. I'll probably dual boot with a default for Windows 7. One OS will have SQL Server 2012, the other SQL Server 2014. Storage is affordable and I feel better being able to revert back to the Windows 7 system if necessary.