text:
SOURCE: Advanced Instruments
January 23, 2007 12:50 ET
Replacing Manual Testing With Instruments Will Deliver Results More Reliably & 6x Faster
NORWOOD, MA -- (MARKET WIRE) -- January 23, 2007 -- Ethanol fuel production plant managers can
streamline key control processes and dramatically cut the time to determine
Dextrose Equivalence of liquefaction samples by eliminating their manual
titrations with automated osmometry instrumentation.
Ethanol fuel production is growing fast in the U.S. Production doubled
between 2001 and 2005, and is expected to double again and reach 15 billion
gallons by 2008, according to published reports. Over 100 plants are
operating in the U.S., some 80 are under construction, and 200 more are
"Plant managers and engineers are being increasingly challenged to
continually improve plant productivity and efficiency. Introducing proven,
state-of-the-art osmometry technology to replace the standard
time-consuming and inconsistent manual testing procedures is one good step
forward," said Don Wiggin, Customer Relations Manager for Advanced
"Osmometers can, on the average, slash testing time six-fold by delivering
results in three minutes, rather than 20 and, on a consistent basis, the
readings will be more reliable and accurate than those taken by manual
titration, with a visual endpoint," said Wiggin.
Proven Solution in Corn Refining
Currently, Advanced Instruments' osmometers are widely used by corn
sweetener refiners and syrup users for Dextrose Equivalence. The
instruments, which measure osmolality by the freezing-point method, provide
fast, consistent, and reliable results to help monitor this critical
attribute during production.
Most ethanol labs now monitor their production processes by determining
dextrose equivalence (DE) to measure starch hydrolysis by manual Titration,
including Lane-Eynon and Schoorl methods. This confronts managers with
three major drawbacks: It is a lengthy test, requiring 20 minutes or more,
limiting its usefulness for process control. The test is performed
manually, and requires a visual endpoint, making accuracy and repeatability
questionable. And the test produces the waste byproducts of copper
sulphate and alkaline tartrate, which are regulated and costly to treat or
In contrast, corn refiners using Advanced Instruments' osmometers receive
accurate, and consistent instrument readouts of DE in three minutes. There
are no waste byproducts.
"Ethanol plant managers would do well to follow the lead of their
counterparts in the syrup industry and turn to the more advanced, proven
technology standard of osmometry," Wiggin said.
Advanced Instruments is a leading supplier of analytical instruments to the
agriculture industry. The company offers a wide range of osmometers, from
single sample models (such as its Model 3320) to multi-sample instruments
used in high volume testing (such as its Model 3900). The Advanced
Instruments Model 3320 is the industry's most accurate and reliable
instrument for osmolality measurement.
For more information, visit the Advanced Instruments Web site at
www.aicompanies.com or call 800-225-4034 or 1-781-320-9000.
About Advanced Instruments
Founded in 1955, Advanced Instruments, Inc. is a leading supplier of
analytical instruments and test kits for the food, dairy, and industrial
microbiology markets. Based in Norwood, Massachusetts, USA, the company
also produces Fiske® Associates brand diagnostic instruments and operates
Spiral Biotech, Inc., and Delta Instruments as wholly owned subsidiaries.
A worldwide network of direct sales people and independent distributors
supports Advanced Instruments' products. The company can be found online
at http://www.aicompanies.com/ or contact customer service at 800-225-4034
or +1-781-320-9000.
Press contact:Don GoncalvesEmail Contact781-793-9380
Brandie GerrishEmail Contact781-793-9380
Download high resolution photosImages of Model 3320, Model 3900 at: www.tizinc.com/aicompanies
See all RSS Newsfeeds


text:
1. Re: DX79SI - Poor USB3.0 & LAN driver supportbbk5 Jan 18, 2012 1:47 AM (in response to bbk5)
I have determined that it is the latest Renesas USB 3.0 driver from the Intel driver page that is causing the following issues:
1. Windows 7 stall on boot-up
2. LAN device unable to start successfully.
After uninstalling the USB 3.0 driver, these two issues are resolved. The problem now is that I cannot use any of the USB 3.0 ports.
Intel, any response on when we can expect a driver that works correctly with your board? I've verified this on a fresh Windows 7 Ultimate x64 install as well.
2. Re: DX79SI - Poor USB3.0 & LAN driver supportChrisIntel Jan 25, 2012 4:39 PM (in response to bbk5)
I am a support engineer in the desktop group. I have been using this board the last couple of weeks and not run into this problem. Can you give me a little more information about your configuration? A copy of the msinfo32 would be useful, are you running RAID or non-RAID, information about the video card you are using.
Additionally, have you made any changes in BIOS? In particular the Fast boot options such as USB optimization or anything like that? I wonder because you said that the keyboard doesn't initialize fast enough and that would occur with USB optimization selected. I am also currently investigating issues with USB 3.0 not working correctly when USB optimization is enabled.
3. Re: DX79SI - Poor USB3.0 & LAN driver supportGreeno Jan 26, 2012 7:50 AM (in response to bbk5)
I've seen the USB 3.0 'quirk' a few times with the latest drivers (as of today)... every time i've removed them from Device Manager and rebooted it's found them again, after doing this twice it's usually fixed.
4. Re: DX79SI - Poor USB3.0 & LAN driver supportyuohta Jan 26, 2012 8:16 AM (in response to ChrisIntel)
I have same problem.
My configuration is below.
OS: Windows7 Ultimate 64bit
BIOS configuration: default
CPU: Core i7-3960X
Memory: G Skill F3-12800CL10-8GBZL x4 (8GBx4)
RSTe: RAID
Sagate ST3000DM001 x4
Intel SSD 510 250GB x1
Pioneer BDR-S06J x1
System Disk: Intel SSD 510 250GB
PSU: Seasonic SS-850KM
5. Re: DX79SI - Poor USB3.0 & LAN driver supportGreeno Jan 26, 2012 8:20 AM (in response to yuohta)
Have you tried to remove it from Device Manager and reboot twice?
I believe we're using driver :- USB3.0_allOS_188.8.131.52_PV when we're doing this.
6. Re: DX79SI - Poor USB3.0 & LAN driver supportChrisIntel Jan 26, 2012 12:02 PM (in response to Greeno)
Tom Green/yuohta,
Can you be a little more specific with regards to the 'quirk' you are referring? Does the USB 3.0 controller show up as an unknown device, a yellow bang, or are you seeing the same thing as bbk5 and the system stalls with no LAN? Any chance you can send me a screen capture of the device properties from device manager?
Additionally, do you have any USB 3.0 devices connected? If so can you give me some specific about them?
7. Re: DX79SI - Poor USB3.0 & LAN driver supportyuohta Jan 27, 2012 7:21 AM (in response to ChrisIntel)
1.The system frequently hangs when loading Windows 7.
2.The USB 3.0 controller show up as an unknown device.
3.Random BSOD
4.LAN seems to be satisfactory.
5.I have not any USB 3.0 devices connected.
6.My USB 3.0 driver is"USB3.0_allOS_184.108.40.206_PV"
Now USB 3.0 are disabled at BIOS.
8. Re: DX79SI - Poor USB3.0 & LAN driver supportChrisIntel Jan 27, 2012 1:16 PM (in response to yuohta)
Thanks for the response; I am currently investigating two issues on this board. They appear to be 2 unrelated issues, however similar to what you are reporting.
Issue 1 – when usb optimization is enabled in the BIOS, the USB 3.0 Host Controller shows up with a yellow bang, not an unknown device like you're seeing, but they could be related.
Can you provide me a screen print of what you're seeing, including the device status?
Issue #2 – We have had some reports of some instability when using the F6 driver. It isn't something we have been able to replicate as of yet. Can you provide me a copy of your msinfo32 and details about your install, how did you perform the install, USB, Optical, network etc, as well as your RAID/Drive configuration?
Please feel free to send me any details in a PM rather than posting them here.
9. Re: DX79SI - Poor USB3.0 & LAN driver supportbrunobr Jan 28, 2012 4:03 PM (in response to bbk5)
I'm having problems with DX79SI USB3.0 controller too. I don't have USB optimization turned on, but the Device Manager always says that "this device could not be started". I'm using Windows 7 x64. Sometimes the PC gives me a BSOD or just hangs... I tried everything, with no success. The only thing that really worked for me was disabling USB3.0 support from BIOS. So I'm running with no USB3.0 support!
Any ideas? I read in some foruns, related to other mobos, that people are updating Renesas uPD720200 Firmware. Some were successful, others not. But I don't know if this applies to DX79SI.
10. Re: DX79SI - Poor USB3.0 & LAN driver supportChrisIntel Jan 30, 2012 3:27 PM (in response to brunobr)
Are any of you using XMP memory with the XMP profiles enabled? If so please try and disable XMP profiles and see if that makes a difference. Additionally, for testing purposes, assuming your not already running overclocked, with XMP profiles enabled, make a slight increase to the memory voltage and see if that happens to make a difference.
11. Re: DX79SI - Poor USB3.0 & LAN driver supportjewellnf Feb 1, 2012 7:47 PM (in response to bbk5)
I am having a similar issue with my DX79SI. Whenever I have a usb 3.0 device connected to the internal usb3.0 header, the system seems to temporarily hang during boot (the code at the bottom right corner of the screen in 58). If I unplug this device, the system boots normally, but if it is plugged in the system hangs at code "58" for about a minute or so during boot. The USB 3.0 device I am using is an AFT PRO-37U internal USB3.0 media reader.
When I first built the system, I was able to remedy the problem by updating to the latest bios revision. But yesterday I installed blu-ray software for my Blu-ray drive and the problem poped up again.
Any suggestions?
12. Re: DX79SI - Poor USB3.0 & LAN driver supportyuohta Feb 5, 2012 12:58 AM (in response to jewellnf)
Pin assignments for the USB 3.0 header of DX79SI is special. Please check.
13. Re: DX79SI - Poor USB3.0 & LAN driver supportDigitalCop Feb 5, 2012 8:04 AM (in response to yuohta)
I am having the same issue. Renesas USB 3.0 HUB shows with an exclamation point in Device Manager or fails to start. Causes system hangs and no boot issues in Windows 7 x64.
Using 32GB of G.Skill Ripjaws RAM in XMP configuration and Intel Extreme processor.
RAM voltage is currently at 1.65 (can't go higher... safely)
System is otherwise not overclocked in any way.
Latest BIOS loaded from Intel website as of 2/3/2012.
Have tried with XMP on and XMP off... tried various voltages within RAM tolerance. No effect.
I am considering this to be a bad motherboard and have already RMA'd it. I have a new one on its way.
The bottom line guys (Intel) is that we are buying your motherboard because you wrote the reference design for the LGA 2011 chipset so we expect your product to be the most stable available.
This is a crappy experience.
I would hope that you figure out a solution as soon as possible. We shouldn't have to take our RAM out of XMP profile to use USB 3.0. That is like buying a car and only being able to use first gear.
Get your crap together. The more of us that RMA these boards the more it hurts your bottom line.
I have yet to post my review of this board on the largest seller of computer parts in the US, if the new board arrives with the same issues, I will not be kind.
14. Re: DX79SI - Poor USB3.0 & LAN driver supportyuohta Feb 5, 2012 8:20 AM (in response to DigitalCop)
I have tried two DX79SI board, but I have same problem...

subset: commoncrawl


text:
CHARDON, Ohio (AP) — Because "voluminous" new evidence has emerged, a judge agreed Monday to indefinitely delay the murder trial of an 18-year-old charged in the high school shooting deaths of three students.
The nature of the evidence wasn't disclosed as prosecutors and attorneys for T.J. Lane jointly asked Geauga County Common Pleas Judge David Fuhry to postpone next week's start of the trial.
The judge agreed during a brief hearing and said he would schedule another hearing in late January to discuss a new trial date for the case in this tight-knit community east of Cleveland.
Lane, dressed in a brown open-collar shirt and dark slacks, sat through the hearing with his hands folded on his lap amid tight courtroom security.
In view of the joint motion, the judge agreed it was in the best interests of justice to delay the trial. He said it was apparent there was "voluminous" new evidence to be reviewed.
Still, he said, "Nobody likes a continuance."
He said a pool of jurors who had been alerted in November to be ready for possible duty for a Jan. 14 trial lasting six weeks or more would be discharged, and a new pool selected. The judge it wouldn't be fair to ask the November pool to rearrange schedules again.
Both sides mentioned the new evidence in carefully couched terms.
Geauga County Prosecutor James Flaiz said the state needs time for forensic analysis of evidence, again without specifying what. An attorney for Lane, Ian Friedman, said the defense would be ready to discuss a new trial date in late January if it receives all materials that have emerged.
Prosecutors say Lane took a .22-caliber pistol and a knife to Chardon High School last Feb. 27 and fired 10 shots at a group of students in the cafeteria.
Lane was at the school waiting for a bus to his alternative school.
Investigators say Lane admitted to shooting at students and told them he didn't know why he did it.
He faces a maximum sentence of life in prison without parole if convicted of the shootings in the Chardon High School cafeteria last February.
Because he was 17 at the time of the crime, Lane isn't eligible for the death penalty. He is being tried as an adult and has filed an insanity plea.
The judge has put off a defense request to move the trial out of grief-stricken Chardon, where ribbons tied to trees remind people of the tragedy.


text:
Treasuries fell after the U.S. auctioned $13 billion of 30-year bonds amid signs the world's biggest economy is gathering strength.
Losses were tempered as yields at almost 11-month highs attracted buyers. The sale drew a yield of 3.248%, the highest since March 2012, compared with an average forecast of 3.243% in a Bloomberg News survey of seven of the Federal Reserve's 21 primary dealers. The bid-to-cover ratio, which gauges demand by comparing total bids with the amount of debt offered, was 2.43, the lowest since August, versus 2.74 last month. Treasuries fell earlier as U.S. jobless claims unexpectedly dropped, fueling risk appetite.
"There was less demand in general after yesterday's pretty strong auction, as we are still in somewhat of a bearish environment," said Paul Horrmann, a broker in New York at Tradition Asiel Securities Inc., an interdealer broker. "That said, we could be set up for a rally given these higher yields and how oversold the market."
The yield on benchmark 30-year bonds increased two basis points, or 0.02 percentage point, to 3.24% at 3:07 p.m. in New York, according to Bloomberg Bond Trader Prices. It touched 3.26% today after reaching 3.28% on March 8, the highest level since April 5.
Ten-year note yields rose one basis point to 2.03% and reached 2.07%. They touched 2.08% on March 8, the highest since April.
Foreign Banks
Indirect bidders, an investor class that includes foreign central banks, purchased 42% of the bonds sold today, compared with 36.4% at the Feb. 14 bond sale and an average of 35.8% for the past 10 offerings.
Direct bidders, non-primary-dealer investors that place their bids directly with the Treasury, purchased 4.9%, the least since September 2009, versus 14.5% at the previous sale and an average of 15.8% for the past 10.
Primary dealers bought 53.1% of the securities, the most since October.
Thirty-year bonds have lost 5.1% this year, compared with a 1% decline in the broader U.S. Treasuries market, according to Bank of America Merrill Lynch indexes.
The U.S. sold $21 billion of 10-year debt yesterday at a yield of 2.029%, compared with a forecast of 2.057% in a Bloomberg News survey of eight primary dealers. The government auctioned $32 billion of three-year notes on March 12 at a yield of 0.411%, below the 0.413% average forecast in a Bloomberg survey.


text:
This post is part of the monthly community event called T-SQL Tuesday started by Adam Machanic (blog|twitter) and hosted by someone else each month. This month the host is Sankar Reddy (blog|twitter) and the topic is Misconceptions in SQL Server. You can follow posts for this theme on Twitter by looking at #TSQL2sDay hashtag.
Let me start by saying: This code is a crazy hack that is to never be used unless you really, really have to. Really!
And I don't think there's a time when you would really have to use it for real. Because it's a hack there are number of things that can go wrong so play with it knowing that. I've managed to totally corrupt one database. :) Oh… and for those saying: yeah yeah.. you have a single table in a file group and you're restoring that, I say "nay nay" to you.
As we all know SQL Server can't do single table restores from backup. This is kind of a obvious thing due to different relational integrity (RI) concerns. Since we have to maintain that we have to restore all tables represented in a RI graph. For this exercise i say BAH! to those concerns. Note that this method "works" only for simple tables that don't have LOB and off rows data. The code can be expanded to include those but I've tried to leave things "simple". Note that for this to work our table needs to be relatively static data-wise. This doesn't work for OLTP table. Products are a perfect example of static data. They don't change much between backups, pretty much everything depends on them and their table is one of those tables that are relatively easy to accidentally delete everything from.
This only works if the database is in Full or Bulk-Logged recovery mode for tables where the contents have been deleted or truncated but NOT when a table was dropped.
Everything we'll talk about has to be done before the data pages are reused for other purposes. After deletion or truncation the pages are marked as reusable so you have to act fast. The best thing probably is to put the database into single user mode ASAP while you're performing this procedure and return it to multi user after you're done.
How do we do it?
We will be using an undocumented but known DBCC commands: DBCC PAGE, an undocumented function sys.fn_dblog and a little known DATABASE RESTORE PAGE option. All tests will be on a copy of Production.Product table in AdventureWorks database called Production.Product1 because the original table has FK constraints that prevent us from truncating it for testing.
-- create a duplicate table. This doesn't preserve indexes!SELECT *INTO AdventureWorks.Production.Product1FROM AdventureWorks.Production.Product
First let's see what the difference between DELETE and TRUNCATE is when it comes to logging. With DELETE every row deletion is logged in the transaction log. With TRUNCATE only whole data page deallocations are logged in the transaction log. Getting deleted data pages is simple. All we have to look for is row delete entry in the sys.fn_dblog output. But getting data pages that were truncated from the transaction log presents a bit of an interesting problem. I will not go into depths of IAM(Index Allocation Map) and PFS (Page Free Space) pages but suffice to say that every IAM page has intervals that tell us which data pages are allocated for a table and which aren't. If we deep dive into the sys.fn_dblog output we can see that once you truncate a table all the pages in all the intervals are deallocated and this is shown in the PFS page transaction log entry as deallocation of pages. For every 8 pages in the same extent there is one PFS page row in the transaction log. This row holds information about all 8 pages in CSV format which means we can get to this data with some parsing. A great help for parsing this stuff is Peter Debetta's handy function dbo.HexStrToVarBin that converts hexadecimal string into a varbinary value that can be easily converted to integer tus giving us a readable page number.
The shortened (columns removed) sys.fn_dblog output for a PFS page with CSV data for 1 extent (8 data pages) looks like this:
-- [Page ID] is displayed in hex format. -- To convert it to readable int we'll use dbo.HexStrToVarBin function found at -- http://sqlblog.com/blogs/peter_debetta/archive/2007/03/09/t-sql-convert-hex-string-to-varbinary.aspx -- This function must be installed in the master databaseSELECT Context, AllocUnitName, [Page ID], DescriptionFROM sys.fn_dblog(NULL, NULL)WHERE [Current LSN] = '00000031:00000a46:007d'
The pages at the end marked with 0x00—> are pages that are allocated in the extent but are not part of a table.
We can inspect the raw content of each data page with a DBCC PAGE command:
-- we need this trace flag to redirect output to the query window.DBCC TRACEON (3604); -- WITH TABLERESULTS gives us data in table format instead of message format-- we use format option 3 because it's the easiest to read and manipulate further onDBCC PAGE (AdventureWorks, 1, 613, 3) WITH TABLERESULTS
Since the DBACC PAGE output can be quite extensive I won't put it here. You can see an example of it in the link at the beginning of this section.
Getting deleted data back
When we run a delete statement every row to be deleted is marked as a ghost record. A background process periodically cleans up those rows. A huge misconception is that the data is actually removed. It's not. Only the pointers to the rows are removed while the data itself is still on the data page. We just can't access it with normal means. To get those pointers back we need to restore every deleted page using the RESTORE PAGE option mentioned above. This restore must be done from a full backup, followed by any differential and log backups that you may have. This is necessary to bring the pages up to the same point in time as the rest of the data. However the restore doesn't magically connect the restored page back to the original table. It simply replaces the current page with the one from the backup. After the restore we use the DBCC PAGE to read data directly from all data pages and insert that data into a temporary table. To finish the RESTORE PAGE procedure we finally have to take a tail log backup (simple backup of the transaction log) and restore it back. We can now insert data from the temporary table to our original table by hand.
Getting truncated data back
When we run a truncate the truncated data pages aren't touched at all. Even the pointers to rows stay unchanged. Because of this getting data back from truncated table is simple. we just have to find out which pages belonged to our table and use DBCC PAGE to read data off of them. No restore is necessary. Turns out that the problems we had with finding the data pages is alleviated by not having to do a RESTORE PAGE procedure.
Stop stalling… show me The Code!
This is the code for getting back deleted and truncated data back. It's commented in all the right places so don't be afraid to take a closer look. Make sure you have a full backup before trying this out. Also I suggest that the last step of backing and restoring the tail log is performed by hand.
USE masterGOIF OBJECT_ID('dbo.HexStrToVarBin') IS NULL RAISERROR ('No dbo.HexStrToVarBin installed. Go to http://sqlblog.com/blogs/peter_debetta/archive/2007/03/09/t-sql-convert-hex-string-to-varbinary.aspx and install it in master database' , 18, 1) SET NOCOUNT ONBEGIN TRY DECLARE @dbName VARCHAR(1000), @schemaName VARCHAR(1000), @tableName VARCHAR(1000), @fullBackupName VARCHAR(1000), @undeletedTableName VARCHAR(1000), @sql VARCHAR(MAX), @tableWasTruncated bit; /* THE FIRST LINE ARE OUR INPUT PARAMETERS In this case we're trying to recover Production.Product1 table in AdventureWorks database. My full backup of AdventureWorks database is at e:\AW.bak */ SELECT @dbName = 'AdventureWorks', @schemaName = 'Production', @tableName = 'Product1', @fullBackupName = 'e:\AW.bak', @undeletedTableName = '##' + @tableName + '_Undeleted', @tableWasTruncated = 0, -- copy the structure from original table to a temp table that we'll fill with restored data @sql = 'IF OBJECT_ID(''tempdb..' + @undeletedTableName + ''') IS NOT NULL DROP TABLE ' + @undeletedTableName + ' SELECT *' + ' INTO ' + @undeletedTableName + ' FROM [' + @dbName + '].[' + @schemaName + '].[' + @tableName + ']' + ' WHERE 1 = 0' EXEC (@sql) IF OBJECT_ID('tempdb..#PagesToRestore') IS NOT NULL DROP TABLE #PagesToRestore /* FIND DATA PAGES WE NEED TO RESTORE*/ CREATE TABLE #PagesToRestore ([ID] INT IDENTITY(1,1), [FileID] INT, [PageID] INT, [SQLtoExec] VARCHAR(1000)) -- DBCC PACE statement to run later RAISERROR ('Looking for deleted pages...', 10, 1) -- use T-LOG direct read to get deleted data pages INSERT INTO #PagesToRestore([FileID], [PageID], [SQLtoExec]) EXEC('USE [' + @dbName + '];SELECT FileID, PageID, ''DBCC TRACEON (3604); DBCC PAGE ([' + @dbName + '], '' + FileID + '', '' + PageID + '', 3) WITH TABLERESULTS'' as SQLToExecFROM (SELECT DISTINCT LEFT([Page ID], 4) AS FileID, CONVERT(VARCHAR(100), ' + 'CONVERT(INT, master.dbo.HexStrToVarBin(SUBSTRING([Page ID], 6, 20)))) AS PageIDFROM sys.fn_dblog(NULL, NULL)WHERE AllocUnitName LIKE ''%' + @schemaName + '.' + @tableName + '%'' ' + 'AND Context IN (''LCX_MARK_AS_GHOST'', ''LCX_HEAP'') AND Operation in (''LOP_DELETE_ROWS''))t');SELECT *FROM #PagesToRestore -- if upper EXEC returns 0 rows it means the table was truncated so find truncated pages IF (SELECT COUNT(*) FROM #PagesToRestore) = 0 BEGIN RAISERROR ('No deleted pages found. Looking for truncated pages...', 10, 1) -- use T-LOG read to get truncated data pages INSERT INTO #PagesToRestore([FileID], [PageID], [SQLtoExec]) -- dark magic happens here -- because truncation simply deallocates pages we have to find out which pages were deallocated. -- we can find this out by looking at the PFS page row's Description column. -- for every deallocated extent the Description has a CSV of 8 pages in that extent. -- then it's just a matter of parsing it. -- we also remove the pages in the extent that weren't allocated to the table itself -- marked with '0x00-->00' EXEC ('USE [' + @dbName + '];DECLARE @truncatedPages TABLE(DeallocatedPages VARCHAR(8000), IsMultipleDeallocs BIT);INSERT INTO @truncatedPagesSELECT REPLACE(REPLACE(Description, ''Deallocated '', ''Y''), ''0x00-->00 '', ''N'') + '';'' AS DeallocatedPages, CHARINDEX('';'', Description) AS IsMultipleDeallocsFROM (SELECT DISTINCT LEFT([Page ID], 4) AS FileID, CONVERT(VARCHAR(100), CONVERT(INT, master.dbo.HexStrToVarBin(SUBSTRING([Page ID], 6, 20)))) AS PageID, DescriptionFROM sys.fn_dblog(NULL, NULL)WHERE Context IN (''LCX_PFS'') AND Description LIKE ''Deallocated%'' AND AllocUnitName LIKE ''%' + @schemaName + '.' + @tableName + '%'') t;SELECT FileID, PageID , ''DBCC TRACEON (3604); DBCC PAGE ([' + @dbName + '], '' + FileID + '', '' + PageID + '', 3) WITH TABLERESULTS'' as SQLToExecFROM (SELECT LEFT(PageAndFile, 1) as WasPageAllocatedToTable , SUBSTRING(PageAndFile, 2, CHARINDEX('':'', PageAndFile) - 2 ) as FileID , CONVERT(VARCHAR(100), CONVERT(INT, master.dbo.HexStrToVarBin(SUBSTRING(PageAndFile, CHARINDEX('':'', PageAndFile) + 1, LEN(PageAndFile))))) as PageIDFROM ( SELECT SUBSTRING(DeallocatedPages, delimPosStart, delimPosEnd - delimPosStart) as PageAndFile, IsMultipleDeallocs FROM ( SELECT *, CHARINDEX('';'', DeallocatedPages)*(N-1) + 1 AS delimPosStart, CHARINDEX('';'', DeallocatedPages)*N AS delimPosEnd FROM @truncatedPages t1 CROSS APPLY (SELECT TOP (case when t1.IsMultipleDeallocs = 1 then 8 else 1 end) ROW_NUMBER() OVER(ORDER BY number) as N FROM master..spt_values) t2 )t)t)tWHERE WasPageAllocatedToTable = ''Y''') SELECT @tableWasTruncated = 1 END DECLARE @lastID INT, @pagesCount INT SELECT @lastID = 1, @pagesCount = COUNT(*) FROM #PagesToRestore SELECT @sql = 'Number of pages to restore: ' + CONVERT(VARCHAR(10), @pagesCount) IF @pagesCount = 0 RAISERROR ('No data pages to restore.', 18, 1) ELSE RAISERROR (@sql, 10, 1) -- If the table was truncated we'll read the data directly from data pages without restoring from backup IF @tableWasTruncated = 0 BEGIN -- RESTORE DATA PAGES FROM FULL BACKUP IN BATCHES OF 200 WHILE @lastID <= @pagesCount BEGIN -- create CSV string of pages to restore SELECT @sql = STUFF((SELECT ',' + CONVERT(VARCHAR(100), FileID) + ':' + CONVERT(VARCHAR(100), PageID) FROM #PagesToRestore WHERE ID BETWEEN @lastID AND @lastID + 200 ORDER BY ID FOR XML PATH('')), 1, 1, '') SELECT @sql = 'RESTORE DATABASE [' + @dbName + '] PAGE = ''' + @sql + ''' FROM DISK = ''' + @fullBackupName + '''' RAISERROR ('Starting RESTORE command:' , 10, 1) WITH NOWAIT; RAISERROR (@sql , 10, 1) WITH NOWAIT; EXEC(@sql); RAISERROR ('Restore DONE' , 10, 1) WITH NOWAIT; SELECT @lastID = @lastID + 200 END /* If you have any differential or transaction log backups you should restore them here to bring the previously restored data pages up to date */ END DECLARE @dbccSinglePage TABLE ( [ParentObject] NVARCHAR(500), [Object] NVARCHAR(500), [Field] NVARCHAR(500), [VALUE] NVARCHAR(MAX) ) DECLARE @cols NVARCHAR(MAX), @paramDefinition NVARCHAR(500), @SQLtoExec VARCHAR(1000), @FileID VARCHAR(100), @PageID VARCHAR(100), @i INT = 1 -- Get deleted table columns from information_schema view -- Need sp_executeSQL because database name can't be passed in as variable SELECT @cols = 'select @cols = STUFF((SELECT '', ['' + COLUMN_NAME + '']''FROM ' + @dbName + '.INFORMATION_SCHEMA.COLUMNSWHERE TABLE_NAME = ''' + @tableName + ''' AND TABLE_SCHEMA = ''' + @schemaName + '''ORDER BY ORDINAL_POSITIONFOR XML PATH('''')), 1, 2, '''')', @paramDefinition = N'@cols nvarchar(max) OUTPUT' EXECUTE sp_executesql @cols, @paramDefinition, @cols = @cols OUTPUT -- Loop through all the restored data pages, -- read data from them and insert them into temp table -- which you can then insert into the orignial deleted table DECLARE dbccPageCursor CURSOR GLOBAL FORWARD_ONLY FOR SELECT [FileID], [PageID], [SQLtoExec] FROM #PagesToRestore ORDER BY [FileID], [PageID] OPEN dbccPageCursor; FETCH NEXT FROM dbccPageCursor INTO @FileID, @PageID, @SQLtoExec; WHILE @@FETCH_STATUS = 0 BEGIN RAISERROR ('---------------------------------------------', 10, 1) WITH NOWAIT; SELECT @sql = 'Loop iteration: ' + CONVERT(VARCHAR(10), @i); RAISERROR (@sql, 10, 1) WITH NOWAIT; SELECT @sql = 'Running: ' + @SQLtoExec RAISERROR (@sql, 10, 1) WITH NOWAIT; -- if something goes wrong with DBCC execution or data gathering, skip it but print error BEGIN TRY INSERT INTO @dbccSinglePage EXEC (@SQLtoExec) -- make the data insert magic happen here IF (SELECT CONVERT(BIGINT, [VALUE]) FROM @dbccSinglePage WHERE [Field] LIKE '%Metadata: ObjectId%') = OBJECT_ID('['+@dbName+'].['+@schemaName +'].['+@tableName+']') BEGIN DELETE @dbccSinglePage WHERE NOT ([ParentObject] LIKE 'Slot % Offset %' AND [Object] LIKE 'Slot % Column %') SELECT @sql = 'USE tempdb; ' + 'IF (OBJECTPROPERTY(object_id(''' + @undeletedTableName + '''), ''TableHasIdentity'') = 1) ' + 'SET IDENTITY_INSERT ' + @undeletedTableName + ' ON; ' + 'INSERT INTO ' + @undeletedTableName + '(' + @cols + ') ' + STUFF((SELECT ' UNION ALL SELECT ' + STUFF((SELECT ', ' + CASE WHEN VALUE = '[NULL]' THEN 'NULL' ELSE '''' + [VALUE] + '''' END FROM ( -- the unicorn help here to correctly set ordinal numbers of columns in a data page -- it's turning STRING order into INT order (1,10,11,2,21 into 1,2,..10,11...21) SELECT [ParentObject], [Object], Field, VALUE, RIGHT('00000' + O1, 6) AS ParentObjectOrder, RIGHT('00000' + REVERSE(LEFT(O2, CHARINDEX(' ', O2)-1)), 6) AS ObjectOrder FROM ( SELECT [ParentObject], [Object], Field, VALUE, REPLACE(LEFT([ParentObject], CHARINDEX('Offset', [ParentObject])-1), 'Slot ', '') AS O1, REVERSE(LEFT([Object], CHARINDEX('Offset ', [Object])-2)) AS O2 FROM @dbccSinglePage WHERE t.ParentObject = ParentObject )t)t ORDER BY ParentObjectOrder, ObjectOrder FOR XML PATH('')), 1, 2, '') FROM @dbccSinglePage t GROUP BY ParentObject FOR XML PATH('') ), 1, 11, '') + ';' RAISERROR (@sql, 10, 1) WITH NOWAIT; EXEC (@sql) END END TRY BEGIN CATCH SELECT @sql = 'ERROR!!!' + CHAR(10) + CHAR(13) + 'ErrorNumber: ' + ERROR_NUMBER() + '; ErrorMessage' + ERROR_MESSAGE() + CHAR(10) + CHAR(13) + 'FileID: ' + @FileID + '; PageID: ' + @PageID RAISERROR (@sql, 10, 1) WITH NOWAIT; END CATCH DELETE @dbccSinglePage SELECT @sql = 'Pages left to process: ' + CONVERT(VARCHAR(10), @pagesCount - @i) + CHAR(10) + CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10) + CHAR(13), @i = @i+1 RAISERROR (@sql, 10, 1) WITH NOWAIT; FETCH NEXT FROM dbccPageCursor INTO @FileID, @PageID, @SQLtoExec; END CLOSE dbccPageCursor; DEALLOCATE dbccPageCursor; EXEC ('SELECT ''' + @undeletedTableName + ''' as TableName; SELECT * FROM ' + @undeletedTableName)END TRYBEGIN CATCH SELECT ERROR_NUMBER() AS ErrorNumber, ERROR_MESSAGE() AS ErrorMessage IF CURSOR_STATUS ('global', 'dbccPageCursor') >= 0 BEGIN CLOSE dbccPageCursor; DEALLOCATE dbccPageCursor; ENDEND CATCH-- if the table was deleted we need to finish the restore page sequenceIF @tableWasTruncated = 0BEGIN -- take a log tail backup and then restore it to complete page restore process DECLARE @currentDate VARCHAR(30) SELECT @currentDate = CONVERT(VARCHAR(30), GETDATE(), 112) RAISERROR ('Starting Log Tail backup to c:\Temp ...', 10, 1) WITH NOWAIT; PRINT ('BACKUP LOG [' + @dbName + '] TO DISK = ''c:\Temp\' + @dbName + '_TailLogBackup_' + @currentDate + '.trn''') EXEC ('BACKUP LOG [' + @dbName + '] TO DISK = ''c:\Temp\' + @dbName + '_TailLogBackup_' + @currentDate + '.trn''') RAISERROR ('Log Tail backup done.', 10, 1) WITH NOWAIT; RAISERROR ('Starting Log Tail restore from c:\Temp ...', 10, 1) WITH NOWAIT; PRINT ('RESTORE LOG [' + @dbName + '] FROM DISK = ''c:\Temp\' + @dbName + '_TailLogBackup_' + @currentDate + '.trn''') EXEC ('RESTORE LOG [' + @dbName + '] FROM DISK = ''c:\Temp\' + @dbName + '_TailLogBackup_' + @currentDate + '.trn''') RAISERROR ('Log Tail restore done.', 10, 1) WITH NOWAIT;END-- The last step is manual. Insert data from our temporary table to the original deleted table
The misconception here is that you can do a single table restore properly in SQL Server. You can't. But with little experimentation you can get pretty close to it.
One way to possible remove a dependency on a backup to retrieve deleted pages is to quickly run a similar script to the upper one that gets data directly from data pages while the rows are still marked as ghost records. It could be done if we could beat the ghost record cleanup task.
Print | posted on Tuesday, October 12, 2010 7:00 AM |
Powered by:
Copyright © Mladen Prajdić


text:
925 Sterling Silver Rectangle Drop Earrings
This 925 sterling silver Rectangle hook fitting earrings has a simple clean and elegant look,
which would make it a great present.for a special person or a lovely treat for yourself .
Approximate Dimensions
Total length (including Hook) is 32 mm
Come with a jewellery gift box.
Please feel free to contact us if you would like more information or you have a question regarding the item.
Please note that earrings are Non refundable nor returnable Due to HYGIENE Reasons


text:
See all AMG Sponsorship & Support Opportunities
Featured people, organizations and/or projects that are in need of your support are listed below.
See all AMG Sponsorship & Support Opportunities
Featured people, organizations and/or projects that are in need of your support are listed below.
"Lord, God of Abraham, Isaac, and Israel, let it be known this day that You are God in Israel and I am Your servant, and I have done all these things at Your word." (I Kings 18:36)
What Elijah prayed on Carmel, I pray. It is entirely in order for the Lord's messenger to pray that the people to whom he was sent will recognize that God is God and in charge, and that he himself is the Lord's servant, on mission from Him. I prayed that prayer during the worst time of my life when a little group of self-righteous and mean-spirited members clamored for my resignation. I was going through the fire, being tried as I rarely had.
The prayer felt like the dying gasp of the weakest child in God's family. Did God hear the prayer? Did He answer? He did.
He heard and answered in His own way, and to the extent that pleased Him.
That's always the way. And it's how we would want it if we knew all the facts, all the hearts of everyone involved, and all the plans He has for each of us. It's a general enough prayer–that God will show Himself to be Lord to these people, and that He will make it plain to those who get these things that the messenger is His, on an errand for Him, doing His will. Surely that's not too much to ask.
At one time or other, every pastor–if he is blessed–will have people questioning his calling, doubting his message, disagreeing with his leadership. Blessed? We recall Jesus saying, "Blessed are you when men shall revile you and persecute you and say all manner of evil against you falsely for My sake…for so persecuted they the prophets who were before you" (Matthew 5:11-12).
Now, being vilified is no fun, to be sure, and I'm not suggesting otherwise. I'm just saying the Lord's messenger should expect it and not think God has thrown him a curve when He allows it.
Pastors, missionaries, and ministers of all varieties would do well to read Matthew 10:16ff regularly to keep their bearings and to answer the unrealistic expectation that everything is always going to go smoothly. Servants of God who do their work well may expect opposition.
Buck Knight, the founder of Nike, Inc., says in his autobiography "Shoe Dog" that entrepreneurs will have targets on their backs. And the more successful one is, the bigger the target will be. That is true of anyone who steps out from the masses to give leadership and direction to them. Let the pastor take note.
You will have opposition. You will receive criticism. You will become the target of rumors and accusations. It goes with the territory.
So, when that happens, drop to your knees and give thanks. After all, the pastor who is never questioned and never targeted for fiery arrows is probably not taking a strong-enough stand.
"All who desire to live Godly in Christ Jesus will suffer persecution" (2 Timothy 3:12).
Expect it, whether you are a lay person or the preacher, a missionary or a denominational leader.
So, go ahead and pray that prayer. "Lord, let these people know You are God. And while You're at it, let them know I'm your servant and that what I'm doing is in obedience to Thy command."
Then, go do your job. Do not flinch, do not back down, and do not fear. You are serving the living God. Act like it.
Joe McKeever is a retired pastor from New Orleans. He blogs regularly at www.joemckeever.com.
© 9/15/2016 Disciple Magazine, published by AMG International. www.disciplemagazine.com. Used by permission.
AMG International has multiple support opportunities that will align with your heart in touching the world with God's love. Check out these opportunities today!
AMG's Bridge to Life childcare projects are administered by national workers, to give children a model of following Christ in their own culture.
God didn't intend for you to fight life's battles alone. Would you like to know how you can have a personal relationship with Jesus Christ?
It is because of God's love that He desires a relationship with mankind whom He has created. Yet because of His holiness, He can have no dealings with sin. That presents a problem...
Each of us has committed acts that are sinful. But more than that, because we are born with a sinful nature, we fall short of God's standard of perfection.
Because God is holy, He cannot look upon sin or accept sinful man into His presence. Yet because of His great love, He has made provision for man's sin...
Jesus is not just a good man, moral teacher or historical figure. He is God in a human body.
The death of Christ demonstrated the love of God and satisfied the demands of His holiness. His perfect sacrifice paid for our sins and took them away.
We cannot come to God on our own terms. God, who created us, has provided a way for us to know Him, but that way is only through His Son, Jesus.
It is not enough to believe intellectually that there is a God, or that Jesus existed as an historical figure, nor is it enough to have an emotional experience. Each of us must respond to God through an act of the will.
Salvation is turning from our old way of living, independent from God, and turning to Him and the new life He offers.
"...if you confess with your mouth Jesus as Lord, and believe in your heart that God raised Him from the dead, you will be saved; for with the heart a person believes, resulting in righteousness, and with the mouth he confesses, resulting in salvation." - Romans 10:9-10
Salvation is a result not just of intellectually believing or of having an emotional experience. Salvation comes when we are ready to surrender our wills to Him. It is not just the words we say, but the attitude of our hearts. If you would like to receive Christ, this is the attitude He is looking for...
"Lord Jesus, I need you. I recognize that I am a sinner and I need your forgiveness. Thank you for dying on the cross for my sins. Come into my life as my Savior and Lord. Take control of the throne of my life and make me the kind of person you want me to be."
If you have given your life to Christ, He wants you to grow in that relationship. Here are some things that will help...
One-Click Donate allows you to quickly given one-time donations to causes that interest you by using the billing methods you have saved to your account on AMG Online.
In order to use begin using One-Click Donate, you will need to:
To begin using One-Click Donate, select from one of the options below:
There are two ways to financially give to AMG International: personalized and general. Choose which option works best for you.
In order personalize your giving, you will need to add people, projects, organizations and other causes to your giving cart. To add opportunities to your giving cart, simply click the "+" button located right beside the opportunity you want to add.
List below are the most common questions that we receive concerning child sponsorships. As always, if you have additional questions, please feel free to contact us directly at 800.251.7206, ext. 421.
Child sponsorship includes prayer and financial support for your child. It costs $32 dollars a month, or $384 a year to sponsor a child. But equally important is the prayer support that your child receives from you. This is the advantage of pairing children with sponsors - the individual attention.
Yes! We encourage you to write to your child . The letters that you write will help build a valuable relationship that your child will never forget. Usually twice a year your child will write to you.
You can write a traditional letter and mail it to AMG, or you can create an account online and write to your child, as well as your child's development center, from your account page. (Please note that all communications to and from donors come to the home office for processing. No direct communication is permitted for the security and safety of children, donors, and field staff.)
Yes! We receive gifts for sponsored children around the world – from toys to books to clothing. You may not know, however,
that once shipping, duties, and other expenses are included, even something as small as a box of crayons and a coloring
book could cost over $50 to send to the field!
If you plan to give a special gift:
We recommend a minimum of $15 but a good average is $25 to $50 by most sponsors. You may go up to $100 if you so desire. We request that you do not exceed the $100 amount on any single special occasion. If you have a unique situation you may contact the sponsorship department at 1-800-251-7206 and a staff member will discuss this with you.
AMG's mission is to advance the gospel with compassion. Impacting a child and a family with the gospel includes an awareness of the children's needs and a purposeful participation in helping those in our sponsorship program. Our child development centers are designed to impact a child mentally, physically, emotionally and most of all spiritually. There is no end to the needs and difficult circumstances every child brings to AMG and this is why our sponsorship program helps each child with nutrition, medical care, personal development, Bible study and spiritual training. AMG does not facilitate the building of homes or major lifestyle changes for the families connected to AMG. This type of involvement from outside sources very often creates serious problems for the family and the local community the child and family live within. Please see FAQ "How Much is Appropriate To Give For Special Gifts".
Children under the care of AMG receive a hot, nutritious meal and a snack each day along with access to medical care if needed. Children are provided educational opportunities and are tutored if necessary. Childcare center staff members encourage children to take advantage of every opportunity they have to learn new skills. Children are given new outfits of clothing and shoes once or twice a year. Each child is given a clear presentation of the gospel, with the hope that they will become a Christian, and reach his or her world for Christ.
AMG has always approached the care of children with a holistic emphasis...daily food, education, access to medical care and most of all, the gospel. Every child receives more benefits and access to services than any one sponsorship could provide therefore all sponsorship funds are pooled for the maximum benefit of your child and all of those attending their center. Your sponsorship dollars are combined with your fellow sponsors so that every child receives uninterrupted care regardless of the possibility that a sponsor misses sending their sponsorship donation on any given month. Your faithfulness and that of every sponsor giving regularly will ensure the maximum benefits for your child as well as all the children in the Child Sponsorship program.
We understand that circumstances change and sometimes it may be necessary for you to give up your sponsorship. In this situation, notify us and we will begin looking for another sponsor for your child.
While we ask that your sponsorship commitment last at least one year, the length of time during which you sponsor a child is up to you. Sponsorship programs help AMG provide food, clothing, medical care and education to children until they reach age 18 or complete their final year of education and leave the sponsorship program. Most of the children AMG serves rely on these programs for their wellbeing. When a sponsorship lapses or is discontinued, AMG will seek out another sponsor rather than discontinue or interrupt the care for that child. Sponsors wishing to extend their relationship with a sponsored child beyond age 18 may do so if the child continues their affiliation with AMG either as a Bible student or National Worker.
AMG sponsors short-term mission trips around the world. Frequently, we will go to countries where childcare centers are located. When we go to the country where your child lives, we encourage you to participate in that trip. Short-term trips are a great way to share the love of Jesus and meet the child that you have chosen to sponsor.
Currently AMG is providing childcare to children in Bangladesh, Guatemala, Haiti, India, Indonesia, Peru, Philippines, Thailand and Uganda.
If you are ready to sponsor a child now, write, call, or click here to select a particular child. Or, if you would like us to assign you the child in greatest need, simply write to or call us. As soon as we receive your first donation of $32, we will send you a photograph and biographical and family information about your child. If you are interested, but have more questions, click here to email your questions or call 1-800-251-7206, ext. 421 and we will be glad to assist you.
Listed below are the most common questions that we receive concerning national worker sponsorships. As always, if you have additional questions, please feel free to contact us directly at 800.251.7206.
National worker sponsorship includes prayer and financial support for your national worker. It costs $50 dollars a month, or $600 a year to sponsor a national worker. But equally important is the prayer support that your national worker receives from you. This unique partnership is an important part of a national worker's ministry.
Yes! We encourage you to write to your national worker. The letters that you write will help build a valuable relationship as you come alongside your national worker to encourage them in their ministry. Your national worker partner will send personal letters and ministry updates to you at least twice a year.
Yes. We do ask that you send money and not gifts-in-kind because of the difficulties involved in shipping packages. The money that is sent for the national worker will go 100% to them. Other gifts that are designated for family birthdays, specific ministry projects or personal needs are welcome as well.
Your support is intended to supplement the income and ministry needs of your sponsored national worker. For some national workers, sponsorship funds enable them to acquire basic necessities like food staples and clothing or to pay their children's school fees. Other national workers may be amply provided for personally, but welcome the sponsorship assistance to print materials, equip facilities, hold special ministry events, or purchase supplies. In either case, your support is a significant contribution to the effectiveness of a national worker's ministry.
Not necessarily. Many factors help define a meaningful support level for each national worker, including the cost of living for the country in which they serve; therefore some national workers are assigned more sponsorships than others. We work closely with our field directors to assess the needs of each national worker.
We welcome regular sponsorship as well as one-time ministry gifts for all of the national workers who partner with AMG. Each and every gift is a valuable contribution to the effectiveness of a national worker's ministry.
We understand that circumstances change and sometimes it may be necessary for you to give up your sponsorship. In this situation, please notify us and we will begin looking for another sponsor for your national worker.
While we ask that your sponsorship commitment last at least one year, the length of time during which you sponsor a national worker is up to you. Sponsorship programs help AMG provide support to national workers until their ministry reaches a self-sustaining point or the national worker has completed their term of service. Many of our sponsors have enjoyed lengthy, fruitful relationships with the same national worker; others have had the opportunity to assist multiple successors.
AMG sponsors short-term mission trips around the world. Frequently, we will go to places where sponsored national workers are serving. When we go to the country where your national worker partner serves, we encourage you to participate in that trip. Short-term trips are a great way to share the love of Jesus and minister alongside the national worker you have chosen to sponsor in a whole new way.
Currently AMG partners with national workers in 26 countries. You can click here to view the majority of national workers that are available for sponsorship. However, for security reasons, not all of our national workers are individually represented on the site. If you do not see a particular country or ministry represented in which you are interested, please feel free to contact us at 800.251.7206 for further information.
If you are ready to sponsor a national worker now, please write, call, or click here to select a particular national worker. Or, if you would like us to assign you the national worker in greatest need, simply contact us. As soon as we receive your first donation of $50, we will send you the photograph, biographical information, and ministry testimony of your national worker. If you are interested, but have more questions, click here to email your questions or call 800.251.7206 and ask for Meredith.
There are no age requirements for MA team members. All applicants are subject to approval by the MA Team Leader. Minors (under 18 years old) who apply to participate must have a guardian that is at least 21 years old who will also be a participant on the trip. The type of ministry of certain trips on the field may preclude a minor's participation on the trip. Families are encouraged to participate on MA Teams.
Yes. Appropriate training is provided covering areas of cultural training, support development, spiritual preparation, etc.
Immunizations vary from field to field. The CDC (Center for Disease Control) has recommendations for all fields. The basic immunizations recommended are Tetanus and Hepatitis A. However, some fields require additional immunizations and medications.
AMG will provide assistance in writing support letters and developing a Biblical understanding of support raising.
The trip cost covers all related travel and in-country expenses (i.e. air transportation, housing, food, insurance, in-country travel, etc.) You would be responsible for transportation to and from the originating airport, meals in the airport, and any personal items you would purchase on the field (i.e. snacks, souvenirs, etc.).
Typically a $100 deposit is due at the time of registration for the trip. One half of the balance of the trip is due 60 days prior to departure and the remaining balance is due 30 days prior to departure. All documents should be submitted 90 days prior to departure.
Yes. Each Mission Adventure has its own designated page where you can give to support a team. To find a specific Mission Adventure, go to the Mission Adventure Trip Schedule Page and click on your trip. Then click the "Click Here to Support Trip" button to begin the payment process.
If a trip is organized for a specific church, school, or other group, it is typically not "open" for registrations outside that group. These designations are reflected on the trip schedule. However, if you have a particular interest in joining one of these teams, you can contact us as some teams are open to additional team members.
First-time trip registrations begin with an Online Missions Profile. Log in or create a new account, then click "Account" to access your Online Missions Profile under the "Mission Adventures" heading. Once the six sections of your profile are completed, find the trip of your choice on the Mission Adventure Trip Schedule and register for the trip. AMG will then approve your registration, and you will receive an email explaining how to upload the documents needed for the trip. You will be able to pay more toward your trip from the same page where you upload documents. Upon uploading all documents and paying the rest of your trip balance, the registration process will be complete.
An Online Missions Profile (OMP) serves as your application for a trip and contains personal information such as contact information, your personal testimony, passport information, etc. You only have to complete an OMP once; after that the OMP can be updated at any time. With second and subsequent trip registrations, you can simply check to make sure all of your information is current.
Log in to your account and click "Account". Under the "Mission Adventures" heading, click "Your Enrolled Trips." There you will see the trips that you are registered for and where to upload your documents. Download the documents needed by clicking the blue text, complete the documents, scan them to your computer, then use the "Submit Now" buttons to upload your documents.
You can still begin the registration process for a Mission Adventure, even if have applied for but have not yet received your passport. On your Online Missions Profile under "Update Your Primary Information," check "I Have Applied for My Passport and Have Not Received It Back." When you do receive your passport, you will need to go back and update your Online Missions Profile with your passport information. If you are considering going on a Mission Adventure and do not have a passport, be sure to apply for your passport well in advance of the registration deadline of your chosen trip. Also, if your passport expires within the next 6 months, you will need to renew your passport before registering for a trip.
Log in to your account and click "Account". Under the "Mission Adventures" heading, click "Your Enrolled Trips." There you will see the trips that you are registered for and the button to pay more toward your trip.
To share a trip on Social Media, go to AMG's Home Page and go to "Click Here to see all AMG Countries, Sponsorship & Support Opportunities." Use the "Narrow By" tool to the left to find your trip. Open the trip page you are looking for and use the Social Media icons on the trip page to share the trip with your friends and family.
During the process of registration, you will be asked to choose between the options of paying for your deposit or of notifying AMG that your church/school/group is paying for your deposit. Type the name of your church/school/group in the text box when completing the next step of registration.
Log in on the website and then click "Account". Under Mission Adventures, click "View Trip Reports." This will allow you to see applicant information including Registration Status and which documents team members have submitted to AMG.
Most likely, you are typing in the wrong password. To reset your password, click "I Forgot My Password" on the login screen. Type in your email and then click "Reset Password." You will be sent an email with a link to reset your password. It is also possible that you are attempting to log in with an email address other than the one that was used to create the account. If you do not remember the email address associated with the website account, please give us a call at 800.251.7206.
The pencil icons beside each section indicate whether a section has been completed or not. If there is a + sign beside a section, that section is not complete and needs more information. When you attempt to save that particular section, anything that needs to be corrected will be highlighted in red.
If you see that your trip registration has been declined, this can mean that your Online Mission Profile is lacking important information or contains obvious errors OR that you have registered for a trip for which you do not qualify. You will receive a follow-up email that will give you further instructions or explain why your registration has been denied.
Once you receive the approval email notification, log in to the website and click "Account." Under the "Mission Adventures" heading, click "Your Enrolled Trips." This page contains the next steps in the registration process, which are to upload your documents and pay the remaining balance for your trip.
If you are not able to upload your documents, the second option is to mail the documents to our Home Office in Chattanooga, TN. Send your document copies to AMG International, ATTN: Mission Adventures, P.O. Box 182200, Chattanooga, TN 37422.
Thank you for being a part of our growing online community.
You have successfully logged out of your account.
For the security of your account, due to inactivity, you have been logged out.
To access your private information on your account, simply logged back in when you are ready.
AMG International
For the security of your account, you will be automatically logged out in 5 minutes due to inactivity.
If you want to prevent this, simply reload this page or navigate to another page on the site.
AMG International


text:
Saturday Night Live Recap: Jennifer Lawrence Grasps for Silver Lining
To salvage what was otherwise a rusty, unfocused episode.
Coming off an unexpectedly great episode with Martin Short to close out the year, this return after over a month off felt like a layer of rust had developed. Jennifer Lawrence isn't known as a great comedienne, but she's charismatic and seems like a good sport. Unfortunately, the show around her was unfocused and short on laughs. The beauty of SNL is that even the lamest episode will yield a memorable sketch or two. I'm just not sure what those would be in this case. Maybe Bill Hader as Tommy Lee Jones doing this.
Headline Skimmer of the Week
You knew this week's show would include takes on Lance Armstrong, Manti Te'o, and possibly even Jodie Foster at the Globes. The fact that all three were thrown into the same pot for a Piers Morgan sketch felt like there was no one great idea for any of the three. Taran Killam did a good job as Morgan, "the British Mario Lopez," nailing his contempt for his guests. And each of the three headline-makers had a cute line or two (Jason Sudekis's unapologetic Armstrong: "Am I sorry I did it? Yes. Ish."; Kate McKinnon's uncanny Jodie Foster: "... the voices of reason in my life, Robert Downey Jr. and Mel Gibson"). It just felt like a poor man's Weekend Update rather than a sketch that stood on its own two feet. I did appreciate the egg-within-an-egg nature of McKinnon as Foster referencing the old Molly Shannon "I'm 50!" sketches, as Foster herself did at the Globes.
Mildest Burn of the Week
Jennifer Lawrence's monologue was an odd beast. At some point on Saturday evening I became convinced that they'd reference Lawrence's First Wives Club moment at the Golden Globes, and that would then lead into her performing "You Don't Own Me" with two cast members (feels like a Nasim Pedrad and Cecily Strong moment), possibly in matching white pantsuits. Instead, the idea was Jennifer Throws Shade at Her Fellow Oscar nominees, which was intriguing in theory, though Lawrence never seemed to fully commit to it. The jokes were (purposefully?) toothless and were all followed up by some sincere "You are my light and inspiration" praise, none of which ever jelled into a solid concept. I did enjoy those cutaways to Tommy Lee Jones in the audience, though.
"Been There" Moment of the Week
Solid commercial parody this week, with the Starbucks home latte maker that gets your name wrong and screws up your order, then acts indignant about it afterwards. Replicating the service-industry experience in the comfort of your own kitchen!
Thora Birch Comeback of the Week
I was happy to see Girlfriends Talk Show return, if only as a vote of confidence for Aidy Bryant. Her poor, sheltered, guinea-pig-loving tween still can't deal with her BFF hanging out with a cooler girl. This time, we got Lawrence as a painfully cool New York City visitor who dresses like Thora Birch or perhaps Alison Lohman in the later stages of White Oleander. "Our band is called Vag Hat, does that scare anyone?" was the first real laugh of the night, and Lawrence ended up delivering a few more in this sketch. ("Everyone in New York is bi because they're in such a rush.") I really love Bryant's escalating mania as she tries to defend herself against the cool girl's guinea-pig-related put-downs. "Do these human fingers look like paws???"
Short Joke of the Week
I don't know what the idea behind the Hunger Games post-game press conference sketch was, beyond an obligatory referencing of Lawrence's billion-dollar franchise. It was just a series of half-formed jokes about how boring sporting event press conferences are, plus more half-formed jokes about how the reporters are starving. I did enjoy all the Sad Peeta stuff, with some great reaction-shot work from Taran Killam. Still, another in a string of sketches that should have been sketched a bit further.
Surprising Non-Short-Joke of the Week
It's not that the jabs at The Hobbit for being overlong, boring, and stretched thin into endless sequels weren't warranted, or even funny (I particularly enjoyed the bickering between Sudekis's Bilbo and Lawrence's Galadriel: "We are gonna be so late"; "NO WE'RE NOT!"). It's just astoundingly dated. This is a month-old movie that was forgotten almost the minute it hit theaters. It's a bummer that the culture churns through things that quickly, but that's the way it goes.
Harshest Burn of the Week
I'm not really familiar with the genre of theme restaurants where the waitresses act like low-level insult comedians to you, but the "Johnny Two-Tones" sketch sold the concept to me quickly enough. And that was just the setup for the night's most successful character: Brenda, whose malevolence is not close to theatrical. Loved how her brand of insult includes vicious, cutting insights into your weak spots. ("You peaked in high school and now you'll sleep with anyone who will ask.") And I really loved the revelation that Brenda is perfectly lovely to other patrons, just not Bayer and Moynihan.
Missed Opportunity of the Week
Seth Meyers brought some of the week's funnier bits this week, including a line about the Mississippi State Legislature being 30 hissing possums in a barn that killed me. But I couldn't get past the part where they actually referenced Ann Romney and yet somehow didn't think to bring back Kate McKinnon to play her at the Update desk. They couldn't have gotten any mileage out of McKinnon's Romney talking about turning down Dancing With the Stars? Instead, we got Secondhand News Correspondent Anthony Crispino, who is kind of a poor man's Drunk Uncle. It's always fun to see Seth and Bobby enjoy each other's company, but by this point, I was crestfallen.
Lutz-Penned Sketch of the Week
"Top Dog Chef" was straight-up an overflow idea from 30 Rock, and nobody will be able to convince me of anything different. That is a TGS sketch that's being rehearsed in the background while Pete grouses to Liz about Jenna locking herself in her dressing room again. Not even one that Tracy Jordan deigns to star in. That is a Danny Baker TGS sketch idea. There was a moment there — when Lawrence, Sudekis, and all the other dogs were all freaking out at the doorbell — that I thought this would at least devolve into anarchy, and they'd hit some absurdist heights, but beyond "Mario Barktali" with crocs on his paws, the sketch didn't have much else to offer.
Vanessa Bayer Quiet Dignity of the Week
Lord knows I love Vanessa Bayer's more outwardly performative characters (bring back "The Miley Cyrus Show," y'all!), but she also has a real gift for playing the beleaguered straight woman amid anarchy. Thus her role on the Early-Morning Minnesota Fake-Thug Shock Jocks sketch as newsreader Karen, a.k.a. MC JiggleButt. She was the highlight of a recurring sketch that features Taran Killam and Bobby Moynihan showing admirable commitment to obnoxiousness but which always wears out its welcome with me. I did like Jennifer Lawrence's awful rap skills, though.
Non-Digital Un-Short Update
I was intrigued by the idea of the "Cinemax Classic" late-night movie, "Danielle: A Free European Woman." The English-dubbed-over-English conceit was weird and cool and the vaguely French seventies erotica concept felt committed. This is basically the realization of "Rochelle, Rochelle: A Young Woman's Erotic Journey from Milan to Minsk." It just didn't really go anywhere. Still, I tend to be more forgiving with these experimental shorts. Good effort, I guess?
Tim Robinson Update
I'm pretty sure the Civil War Letters sketch is the most we've seen Tim Robinson do all season. He was solid in a cute sketch that would have benefited from being a bit shorter. I did kind of love the absurdist tag at the end with Hader as Abraham Lincoln, weeping at the bedside of a fallen soldier who died without ever getting his tit-pic. Kind of half a joke, but that pretty well sums up the entire show this week, so it felt appropriate.


text:
Justice refuses probe into murder trial jurors
A SUPREME Court justice, who feared the time-honoured jury system would be in jeopardy, has refused to allow lawyers to probe jurors involved in a Rockhampton murder trial.
Justice Roslyn Atkinson was asked to consider whether she should allow a Queensland sheriff to put questions to jurors involved in convicting three men of the death of Robert James Buckley at the old Etna Creek Prison.
Justice Atkinson, during the application in Brisbane Supreme Court, said the legislation giving her discretion to make the order was born after the now infamous Joh Bjelke-Petersen jury saga.
Mark Dempsey Knight, Wesley Robert Williams and Wayne Thomas Robertson were found guilty after a trial in April of murdering the 23-year-old in 1999.
Buckley was found dead, hanging by a towel from a window in a shower block at the prison.
It was the second trial the men had faced, after the Court of Appeal set aside initial guilty verdicts and ordered a retrial.
The court heard during the application that a juror had commented to his barber that the men were serving life sentences or long-term jail terms anyway so the jury's verdicts made no difference.
The barber served a lawyer for one of the accused men later that same day and passed on the conversation.
The trio's lawyers argued the comment meant the juror could have read newspaper articles "already in the public arena" during the trial and had therefore performed illegal "external" investigations while he was on jury duty.
He said jurors could be approached under section 70 (7) of the Jury Act if the court suspected a juror was guilty of bias, fraud or an offence related to the person's involvement in the jury's performance.
Justice Atkinson said she was concerned enlivening the subsection could drive "a highway" through the confidentiality of the jury system and "then I don't see how we could continue the jury system".
But when she dismissed the application on Monday, she agreed not to publish her reasons on the Queensland courts website until the appeal process had expired.
The trio's lawyers said they would most likely appeal Justice Atkinson's decision on questioning the juror and indicated they would likely go to the Court of Appeal over the murder convictions.
The Bjelke-Petersen 1991 perjury trial, which was deadlocked with a hung jury, became infamous when it was revealed the jury foreman was a member of the Young Nationals and was identified with the Friends of Joh movement.


text:
How to remove Clktrak.com Pop-up Ads & Redirects
What is Clktrak.com:
Threat Classification: Adware
Clktrak.com is a just another nasty browser hijacker/ search redirect, capable of taking over your browser, modifying its settings and injecting various malicious code, like fake pop-up messages, ads and/or banners, offering some very cool games or or other cool features, on almost every web page, you visit. If you have already seen some of the Clktrak.com pop-ups or redirects, we recommend you to consider your PC compromised and our security experts advise you to clean it as soon as possible, before further damage occur or even data loss. Our malware researchers and security experts concluded that the best way of cleaning your computer is by performing a full system scan using our latest award winning anti-malware product called SpyHunter 4. After a thorough reveiw, our malware researchers are pretty sure, that these annoying Redirects & Fake Pop-ups by Clktrak.com are generated by a malicious browser extension, that has been installed on your system by some active infection or (what they consider is more likely) by some questionable or even dangerous software bundle, that was installed by the user, because of some popular, freeware software product. Furthermore, our security experts came to the conclusion, that the rogue browser extension is capable of infiltrating computer systems without users' permission or their consent – usually hidden into the Custom/Advance part of these software bundles. When activated, the malware will start collecting various private browsing data including usernames, email addresses, SSNs, Real Names, Postal Addresses, Birthdays, passwords, Credit Card Information and/or other financial data or online bank account information, which later will be either sold to some 3rd party company, which then will use it for their own marketing purposes. Our security researchers warned us that the Clktrak.com is a malicious website, often used by hackers, attackers or cyber criminals from everywhere, just to redirect traffic to their sponsor links and/or ads and to earn some revenue or to spread other infections. Our security experts found out that once activated, the malware will modify browsers' settings and/or windows registry database, which will make the recovery much harder! The adware is capable of displaying ads on random web pages, which could lead to websites design alterations, however it seems that the infection is compatible with all the well-known web browsers like Internet Explorer, Mozilla Firefox, Edge and Google Chrome.
Generally, users that have this particular adware and/or PUP installed on their systems might see various pop-up & pop-under browser windows, informing the victim that a Video Player is Ready for Download, Install Media Downloader, Infection was Detected, Please Install The New Java Update or Important Software Update, New Driver Updates are Released etc.. The Clktrak.com is set to display FAKE POP-UP ALERTS on the victim's computer. Please note, that all these web alerts are FAKE! Actually, the main purpose of the Clktrak.com is to drive as much traffic as possible to certain domains, which then is converted to cash via one of the many online marketing platforms.
Clktrak.com is usually bundled with other free software products and is being installed by default when the user accepts the EULA while performing an express/recommended installation. That's why, you should be very careful what you agree to install and always opt-out for a custom installation and skip or deselect the software you don't want to install or you are not familiar with. The possible distribution of Clktrak.com bundle varies but is not limited to – installing third-party toolbars, free PDF software, free Video editors or other free software products or downloading e-mail attachments etc..
The purpose of Clktrak.com is to attract more users to certain domains, so that the creators of such or similar adware could generate income from the online traffic, using one of the many online marketing platforms. Clktrak.com may use tracking cookies and other relevant techniques to steal your personal data such as account information, usernames & passwords, bank account data etc. That's why this malware infection should not be left unattended and needs to be terminated immediately, as it seems to be a serious threat to your online security.
!!! Please note that these infections could potentially bring up other malware to your computer and even cause a loss of data. Please do not underestimate such threats.
Removal Process:
There are two ways to remove this infection. It is totally up to you to decide which way you want to go:
1. Automatic Removal Method (recommended for all users) using the SpyHunter Malware Security Suite.
2. Manual Removal Method (recommended ONLY for PC Experts or Enthusiasts).
Automatic Clktrak.com Removal:
We recommend using SpyHunter Malware Security Suite.
You can download and install SpyHunter to detect Clktrak.com and remove it, by clicking the button below. Once installed, SpyHunter will automatically scan and detect all threats present on your system, but to use it as a removal tool, you need to buy a subscription.
SpyHunter will automatically scan and detect all threats present on your system.
Learn more about SpyHunter and please, review the End User License Agreement – EULA. Furthermore, we strongly encourage you to read the SpyHunter Installation Instructions. SpyHunter's free diagnosis offers unlimited free scans and detection. You can remove the detected files, processes and registry entries manually, by yourself, or purchase a subscription, which will allow you to use the automatic removal feature and to receive unlimited one-on-one professional help for any malware related issue by an expert technician.
Manual Clktrak.com Removal:
!!! Please note: You can remove Clktrak.com manually, however, you should proceed at your own risk, as any of the interventions might render your system inoperable. Therefore this Manual removal method is highly recommended for PC Experts or Enthusiasts. For regular users, MalwareKillers.com recommends using SpyHunter.
1. Remove Clktrak.com Uninstall Entry:
First, you can try to go to Control panel and click on Programs and Features (Windows Vista/7/8/10) or Add/Remove Programs (Windows XP) and check the Uninstall Programs` List for any entry related to Clktrak.com, Algovid.com, SafeSurfs.com, Jyhjyy.top, Trafliesb-ph.ru, Chum Search, N121adserv.com, BazzSearch.com, Feed.BazzSearch.com, Searchguide.level3.com, TTwifi, Quick Swipe, YeaBests.cc, PC Backup 360, SafeBrowsing.biz, Ps4ux.com, FixIt, WinFlix 10, MySites123.com, Hohosearch.com, Ads by Albireo, MPC Cleaner, Ads by Advertise, Flirchi.com Pop-ups & Redirects, Smartsputnik.ru, FunDay24.ru, Liveadexchanger.com, Vofiles.com, Woruanjian.com, S.admathhd.com, Gangnamgame.net, Searchinterneat-a.akamaihd.net, Vaudix, Diet Runner, YoutubeAdBlocker, BuyNSave, Freemake Video Converter or any other third-party add-ons, extensions and toolbars. You should also look for all kinds of suspicious programs, installed on the same date as the infection. If you find such, double-click on it and try to remove it. Although, please mind, that this is an actual infection and you might not be able to remove it directly from the list.
*(Start -> Control Panel -> Programs and Features or Add/Remove Programs) or "Win + R" keys to open "Run" and type in "control", then hit Enter.
2. Remove Clktrak.com from your browser:
Internet Explorer:
Go to Tools -> Internet options -> Advanced Tab and click the Reset button (make sure to select the Delete Personal Settings checkbox).
*please note that in order to save your favorites, you need to export them before resetting the browser as you will lose all personal settings.
After IE completes the operation, click the close button and then start again the IE in order for the changes to take effect.
Google Chrome:
Go to the following path (you can copy-paste it) and delete the entire folder "Chrome" with all the folders and files that are in it.
For Windows XP: %USERPROFILE%\Local Settings\Application Data\Google\
For Windows Vista/7/8/10: %USERPROFILE%\AppData\Local\Google\
Alternatively, you can navigate to these folders by following these steps:
For Windows XP:
1. Click on "Start" in the bottom-left part of the screen.
2. Choose "Run".
3. Type %USERPROFILE%\Local Settings\Application Data\Google\ and hit Enter.
For Windows Vista/7/8/10:
1. Click on the Windows logo in the bottom-left part of the screen.
2. Type %USERPROFILE%\AppData\Local\Google\ and hit Enter.
Mozilla Firefox:
1. At the top of the Firefox window (top-right corner), click the Firefox Menu button (3 horizontal lines), go over to the Help sub-menu and select Troubleshooting Information.
2. Click the Reset / Refresh Firefox button in the top-right corner of the Troubleshooting Information page.
3. To continue, click Reset / Refresh Firefox in the confirmation window that opens.
4. Firefox will close and be reset. When it's done, a window will list the information that was imported. Click Finish and Firefox will soon reopen.
3. Check for arguments added by Clktrak.com in any Browser shortcuts or links to web pages:
Clktrak.com might also hijack your web browser shortcuts to force-load its home page. This causes the Clktrak.com`s web page to open up when you launch a hijacked shortcut.
The argument that Clktrak.com uses to hijack shortcuts should look like (or is similar) to the one below:
You can remove it manually by editing the shortcut's target line.
4. Delete any folders or files related to Clktrak.com by checking the following locations:


text:
HORIBA decided to partner with Qwest Scientific to increase sales coverage in the West, Southwest, and Pacific Northwest regions and to take advantage of the 'full service' customer focused approach offered by their multiple sales representative organization throughout the region.
The Qwest Scientific team of experienced problem solvers works closely with industrial and laboratory users to supply them with cost-effective instrumentation as well as complementary product lines. With over 17 years experience in the industry, Qwest Scientific provides a customer-centric approach, offering extended personalized after-sales technical support services. With a database of over 12,000 customers and prospects in the West, Southwest, and Pacific Northwest regions of the U.S., Qwest Scientific is an ideal partner for HORIBA.
For more information, visit www.horibalab.com.


text:
Artwork Groupings in the Kitchen
Whether it's one enormous painting, a grouping of smaller similarly styled drawings, or an eclectic assemblage of paintings taking up a whole wall, artwork in the kitchen really makes a difference. We've been particularly drawn to artwork groupings lately, as seen in these inspiring examples.
Related: Look! Enormous Painting in the Kitchen
(Images: 1. Marie Claire Maison; 2. Elle Decor via Design Darling; 3. Southern Living via My Home Ideas; 4. Bruce Hemming via The Daily Mail; 5. Australian Harper's Bazaar via Wilona + Me; 6. DigsDigs; 7. Lonny Mag)


text:
MOSCOW (AP) — The artistic director of the Bolshoi ballet said the dancer arrested on suspicion of giving the go-ahead to an acid attack that badly burned his eyes and face had long threatened him.
Dressed in black and wearing shades, Sergei Filin told Russian state television in remarks broadcast Tuesday that someone whom he wouldn't name might have pushed leading soloist Pavel Dmitrichenko into staging the attack.
"It appears that someone had worked really well on that and pushed him into doing it, since every time, every moment, my every meeting with Pavel Dmitrichenko meant another threat, another show of dislike," Filin said.
He added that Dmitrichenko, who has recently starred in the title part of "Ivan the Terrible," was part of a "narrow circle of people who openly disliked me and threatened me and many other people."
Filin, 42, spoke energetically and skin on his face no longer looked red and swollen as in early February, when he was last seen in public before flying to Germany for continuing treatment.
Dmitrichenko told a Moscow court last week that he gave his blessing to the Jan. 17 attack, but never expected that the assailant would go as far as to throw acid in Filin's face. He said he was angry at Filin for what he described as corruption and favoritism at the theater.
Dmitrichenko was arrested by police along with the alleged perpetrator of the attack and another man accused of serving as a getaway driver.
On Thursday, 300 Bolshoi employees, including some of the leading dancers, issued an open letter defending 29-year-old Dmitrichenko. They said that police failed to produce any evidence of Dmitrichenko's guilt and argued that Dmitrichenko had been pressured into slandering himself by police.
"We think that the conclusions drawn by investigators look hasty to us, their proof unconvincing and Pavel's confession ... was a result of crude pressure on him," the letter said.
"Regrettably, the history of our country saw many occasions when investigators used unlawful and sometimes illegal means to obtain the results they needed," it added.
Rights groups say Russian police routinely use torture to extract false confessions from those they have arbitrarily rounded up, brutality that long has caused public outrage and drawn calls for an overhaul of the force.
Dmitrichenko's lawyer, Alexander Barkanov, didn't make any allegations of police abuse in the case when he attended a court session last week. Moscow police insisted in Tuesday's statement that they have been honestly doing their job and pledged to conduct a fair probe.
Reacting to the open letter by Bolshoi artists, Bolshoi general director Anatoly Iksanov called a news conference to say that Dmitrichenko won't be fired unless found guilty.
"If the court proves his innocence, then, sure, we will have no legal grounds to fire Dmitrichenko," he said.
Iksanov said he shares the ballet troupe's concern that the "investigation could be biased" and said he believes Dmitrichenko when the dancer says he was plotting the attack, but not the violent form that it took.
The Bolshoi's director pledged to keep Dmitrichenko on payroll for the time being, but added that it is virtually impossible for a dancer to return to work after a year's break. It is unclear when his trial could start and how long it could last.


text:
As stated in the other thread (http://community.jboss.org/thread/155681?tstart=0), we plan of rearchitecting the internals of the STS to be the generic token generator.
Toward this, I created the first stab at an architecture diagram for the STS.
The DIA image source is available in the picketlink workspace: http://anonsvn.jboss.org/repos/picketlink/picketlink-docs/trunk/images/
Retrieving data ...


text:
Hi. After much saving up and research I bought a top-of-the-range x220 four months ago in the US ($1,200). A couple of days ago a crack (see picture) appeared in the casing on the right side. Now, I can state with absolute confidence that the laptop has never been misused, dropped, bumped, or anything like that. I also have a super-padded crumpler laptop bag for it when I take it anywhere.
I called Lenovo support here in the Netherlands and after struggling for a while to get them to respond to my emails, an agent told me over the phone that the crack was not covered by the warranty. I protested but to no avail.
Now, call me crazy, but - if Lenovo sells you a top of the range laptop with promises of "military" durability,; you treat it like a baby (seriously, they could just inspect the thing and see there's been no accidental damage); and the casing cracks - then, shouldn't they be apologising as well as repairing it under warranty? Instead you get a blank wall and the off-hand claim that you automagically damaged your laptop and have to shell out to have it repaired... Well, if you're like me, you'd be getting pretty hot under the collar.
ps: when you hold the laptop by the palmrest area the crack widens. It seems like that spot above the corner of the hard drive panel is simply too weak by design.
It is so sad to know that your new notebook got issue.
I can understand your concern. However, I would like to share with you any physical damage (crack) does not cover into standard warranty policy.
You may send the picture to the support center and they can also have a look on this. After looking to the picture they may decide if the crack developed itself or they can reply you accordingly.
Did someone help you today? Press the star on the left to thank them with a Kudo!
If you find a post helpful and it answers your question, please mark it as an "Accepted Solution".! This will help the rest of the Community with similar issues identify the verified solution and benefit from it.
Follow @LenovoForums on Twitter!
Dear Tanujhanda,
The relevant terms of the Lenovo warranty (Lenovo Limited Warranty, L505-0010-01 04/2008) are:
"Lenovo warrants that each hardware product that you purchase is free from defects in materials and workmanship under normal use during the warranty period."
"This warranty does not cover: [...] failure or damage resulting from misuse, accident, modification, unsuitable physical or operating environment, natural disasters, power surges, or improper maintenance by you."
Yes it is sad: Lenovo sold me a defective product, namely an x220 whose casing developed a crack during normal use and not because of accidental or intended damage.
If I am not mistaken, it is Lenovo's duty to show that the physical defect arose from the kind of use or environment that the warranty does not cover. I am absolutely confident that there is no evidence of such misuse or accident, because:
1/ I have never subjected the laptop or allowed the laptop to be subjected to the kinds of use, accident, or environment that the warranty does not cover, and;
2/ I have inspected the laptop and see no evidence whatsoever of such misuse, accident or environment.
I have now sent three emails about this issue to firstname.lastname@example.com (the address given by the support agent here in Amsterdam), and still do not have a single reply.
Dear Wimute,
I can understand your concern and suggest you to wait for the support team reply.
There is a suggestion if you have time you can visit to the service center also and ask them inspect the notebook.
Best Regards,
Did someone help you today? Press the star on the left to thank them with a Kudo!
If you find a post helpful and it answers your question, please mark it as an "Accepted Solution".! This will help the rest of the Community with similar issues identify the verified solution and benefit from it.
Follow @LenovoForums on Twitter!
I see your point - I think you understand the general policy regarding physical damage and the optional accidental damage coverage that can be purchased as an upgrade which covers these types of things.
That said, it is possible there are circumstances where we should take a closer look at the individual system.
Can you send me a private message with your contact information, and the model type / serial number of this system, and any service case numbers from your prior calls on this topic?
Let's see what can be done.
Best regards,
02-08-2012 07:56 AM - last edited on 02-08-2012 08:14 AM by zoltanthegypsy
(here another picture of the crack that shows a little better how it goes clean through the casing)
Well, Mark kindly filed a complaint on my behalf, but I received the unhelpful reply from a customer service agent below.
Like all the previous reactions from Lenovo, this contradicts a/ the terms of the Lenovo warranty, and b/ Dutch law, which states that if a product manifests a fault within 6 months, the assumption is that the product is faulty unless the manufacturer can prove that the customer dropped or otherwise misused the product. Also, how is this crack in the "bezel"? It goes straight through the casing, and is a structural fault. Last time I checked, a bezel was a superficial panel in front of e.g. the rim of the LCD, or in front of the DVD player.
This is so exasperating... frankly it feels like Lenovo sees itself in a legal wild west with regard to warranties, since they are simply ignoring the terms of their warranty as well as the legal regulations! They act like their arbitrary (or self-serving) internal policies have some kind of legal or moral weight!
Dear Mr. [redacted]
I have checked your complaint and have to confirm what our agents told you.
Bezel faults are considered as customer damage and are not supported by base warranty of lenovo product.
I'm sorry, but you are not entitled for the repair.
Customer Complaints Management Team
Lenovo WE Services
Moderator Note: name of Lenovo employee removed per Lenovo Community Participation Rules
Man oh man, this case is so clear-cut. It's outrageous. I work at the computer science department at the university here and about a dozen seasoned computer experts/academics I've shown this x220 with its casing crack to, have all said without hesitation, that this is a product fault which the Lenovo warranty as stated, covers. It is not cosmetic, and it's very obviously not the result of misuse! Instead of acknowledging the glaringly obvious, Lenovo's customer support is behaving like something out of a Kafka novel!
As soon as I saw the pic i had a pretty good idea what caused this.
Excessively tightened internal vertical screws. No doubt about it.
So I got another unhelpful reply:
Dear Mr. Stork
To be clear, the base warranty doesn't cover the cracks on the plastic parts of the computers.
You may check below the list of issues not covered by base warranty.
Unfortunately, we cannot accept your complaint.
|Kudos Count


text:
Reading the forum on your cell phone? There's an easier way. We've enabled a Tapatalk app that makes browsing the forum a whole lot easier. Check it out in the iPhone or Android store if you don't own it already.
Recomendation for a decent, not too pricey hotel in or around N. Conway? The missus will join me for Ice Fest. Joe Dodge is full.
Page created in 0.183 seconds with 31 queries.


text:
(Some interesting looking men walked in and asked if it was the Sewing Olympics.)
As I mentioned in my previously cranky post,
(Skip it if you haven't already been bored to tears by it)
I went to my first-ever Quilt Retreat!
(Well, I went to about 15% of it.)
This was a 3-day, 2-night retreat at a hotel in Provo, Utah.
I couldn't pull-off attending the whole thing, but because I have an in
(the retreat was hosted by American Quilting where I work occasionally)
they let me horn my way in for an afternoon/evening of sewing and socializing.
Lots of neat women there.
(Quilters are just fun people, you know?)
Including 4 other Amy's (or Aimee's).
Other talented folks with blogs you may read like Kim, Rae Ann, and Lori Holt.
Nanette Merrill of Freda's Hive was doing a trunk show.It was so much fun for me to see Nanette's quilts in real life
-many of which I'd admired from afar on her blog.
A few more of my Union Jack blocks.
And I finally pieced the top for my own daughter's pink, red, and turquoise quilt.
All it needs now is the borders sewn on and it's ready to quilt!Here is what I didn't get done.
My little purse.
I did go to the class and purchase the clasp.
I spent the rest of that time pouring through Lori Holt's stack of quilts.
WOW. They are amazing. I've never seen detail like hers.
Many thanks for all the kind wishes and blogger-editor commiseration.
(And helpful suggestions too!)
It's nice to be among friends when you're not having your finest moment.


text: Showcasing your aquarium does not have to be complicated or costly. That's why we recommend Titan Eze Metal Aquarium Double Stands. Bi-level, powder-coated steel aquarium stands double your dollar by safely holding two aquariums. Display two aquariums or showcase a single aquarium on top and store equipment and supplies below.


text:
You are here: Home ‹ Board index ‹ Movie Discussion ‹ All Other/Older Movies ‹ (2005) Fun With Dick And Jane
New pics of Jim and Tea on the Set of FwDaJ
Discuss this movie. Available on DVD and PSP.
He was entrappedthe guy, his car and left him in their dust.
It's part of the movie isn't it????
The original Dick & Jane movie was about a couple who were desperate for money so they decide to rob a bank. But because they are not criminals, they constantly bungle every attempt. This definitely is a scene of another botched job...
LOVE the pictures! Thanks.
Jim's not married... and i think he is just grabbing the guy not kissing him... it just looks like it from the angle.... but whatever he has kissed guys in movies before... its all in fun.... i cant wait to see the movie
awsome...lol i like the first one...lol, li like how that women is about to have a fit! hahaha. awsome... thanx
Who is online
Users browsing this forum: No registered users and 2 guests


text:
|Birth Date:
|February 6, 1991
|Cincinnati, Ohio
|High School:
|Previous College:
|Interdisciplinary Studies
Bud Golden joined the Golden Eagle roster in September of 2012, a transfer from the University of Illinois. He has two years of eligibility remaining with TTU...has the potential to add great depth to the runningback position.
AT TECH (In 2011): Golden rushed for 20 yards on 11 carries over the course of nine games in his debut season with the Golden Eagles...top performance came against UT Martin with 15 yards on six carries...logged 198 yards on 10 kick returns, including a 33-yard return against TSU on Oct. 15...put up 218 yards of total offense on the year...
BEFORE TECH: Golden is a redshirt sophomore runningback who sat out one season and played one season for the Fighting Illini. A standout from Cincinnati, he played in all 13 games for the Fighting Illini in 2010, primarily on special teams. He finished with 32 yards on eight carries, a reception for 12 yards and returned four kicks for 52 yards. His career-high game was six carries for 29 yards and a catch for 12 yards in Illinois' 44-10 win over Purdue.
HIGH SCHOOL: Golden posted impressive high school credentials at Sycamore High School, which also gave Tech current Golden Eagles Dwight Evans, Marty Jones and Alden Olverson. Golden was a four-star recruit by Rivals.com, listed as the 19th-highest rated tailback by the website. Some sources had him listed as the eighth-best high school player in Ohio. In his senior campaign, Golden rushed for 1,513 yards with 19 touchdowns, and rushed in his career for a school-record 3,000 yards and 40 touchdowns. Golden went to Illinois after being recruited by Pittsburgh, Minnesota, Cincinnati and Purdue.
PERSONAL: The son of Annie and Bud Golden...full name is Bud Lee Golden...birthdate is February 6, 1991...majoring in interdisciplinary studies.