New Upgrade Assistant resource for Application Compatibility & Upgrade testing
Hi all,
On behalf of Scalability Experts, I'm excited to announce additional resources you can use to perform a tool-assisted upgrade testing process. This tool and process will hopefully enhance your results when upgrading your SQL Server 2005/2000 databases to SQL Server 2008. The tools work on upgrade to the CTP, and after the RTM is released they will work with RTM.
- Introducing both versions of the SQL Server Upgrade Assistant tool and methodology
Scalability Experts are stewards of the Upgrade Assistant tool and methodology. There exists two versions of the tool: the older version supports upgrades from SQL Server 2000 or 7.0 to SQL Server 2005. The newer version supports upgrades from SQL Server 2005 or 2000 to SQL Server 2008. The tool exercises the relational engine portions of your upgrade testing; you will still want to use other approaches to test upgrade of your Client Application Connectivity, Replication, Integration Services, Analysis Services, and Reporting Services based capabilities.
My colleagues and I from Scalability Experts participate in this forum and will help you the best we can to get your application compatibility and upgrade testing questions answered. We have been working with Microsoft SQL Dev closely for multiple releases and possess deep knowledge of SQL Server upgrade and application compatibility testing. Collectively, we have assisted hundreds of companies around the world – helping software vendors and customers upgrade their databases to SQL Server 2005 in the last release cycle, and helping dozens test their application upgrades to SQL Server 2008 CTP during the current release cycle. We will maintain an ongoing presence on this forum, looking to discuss questions and issues related to application compatibility testing and upgrade. We also welcome feedback and suggestions via Connect.
Our names are:
· Keith Nicholson, Derek Comingore, Don Vilen, Rohit Sharma and Joe Yong
TIPS FOR QUICKEST QUESTION RESPONSE: To ensure your upgrade and application compatibility testing related questions are easily identifiable, we recommend:
1. Prefix your post subject/tile with "APPCOMPAT:" followed by the specific question you have. This helps ensure the most expedient response from Scalability Experts SMEs.
2. If you experienced an install/uninstall/upgrade or repair failure, include your logs (ALL OF THEM if possible but zip/rar them up first).
We hope this new Upgrade Assistant tool and methodology will help you in your upgrade testing efforts and improve your overall upgrade experience with SQL Server 2008.
The following are additional resources that may be useful to you in your upgrade and application compatibility testing.
· Upgrade and Application Compatibility Blog
URL: (http://blog.scalabilityexperts.com/category/upgrade/)
· SQL Server 2008 (Katmai) Setup and Upgrade Forum
URL: (http://forums.microsoft.com/MSDN/ShowForum.aspx?siteid=1&ForumID=1627&SiteID=1)
· SQL Server (released versions) Setup & Upgrade Forum
URL: (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1)
Regards,
Joe Yong
Scalability Experts
Reply:
This Forum is probably an ideal place to discuss Application Compatibility issues, in addition to Setup & Upgrade issues. And if the outcome of the discussion causes you to desire an App Compat related product enhancement, you can visit the Microsoft Connect site to provide product suggestions.
There are many programs, events and resources available to different audiences to assist with upgrade efforts, including this Scalability Experts Upgrade Assistant tool and methodology just mentioned. There are several people at Microsoft who own various program aspects related to SQL Server Upgrade and Application Compatibility. These people are:
- Roger Doherty, Zach Owens, Kuleen Bharadwaj, Amy Lewis, Tamara Tan and Rebecca Laszlo
Roger, Zach, Kuleen, Amy, Tamara and I will periodically provide guidance on both technical and business related queries so you may leverage programs and resources you would find helpful. We are essentially subject matter experts about Microsoft-sponsored programs and activities and will do our best to highlight those which might interest you most.
-Rebecca Laszlo [MSFT]
------------------------------------
Portuguese(Portugal) Version Select All (Ctrl+T) don't work
But don't work in 6000, neither 6001.X neither this last build 6001.18000
Reply:
Using 6001.18000
------------------------------------
Reply:
------------------------------------
BizTalk Adapter Pack Released
BizTalk® Adapter Pack Launches at Office Developers Conference
On Monday February 11th, we announced availability of the BizTalk® Adapter Pack at the Office Developer Conference. The BizTalk® Adapter Pack provides a single solution to easily and securely connect to Line of Business (LOB) data from any custom-developed .NET application, SQL Server-based business intelligence solution, or an Office Business Application (OBA). The three adapters available in this release are Siebel, SAP and Oracle DB.
The BizTalk Adapter Pack will be generally available on March 1st. Please contact your Microsoft representative for the pricing details. The Adapter Pack license is also included with BizTalk Server 2006 R2 Developer, Standard, and Enterprise editions. It is not included in the Branch edition. Customers that have already purchased BizTalk Server 2006 R2 with Software Assurance will also have access to the BizTalk Adapter Pack through the Software Assurance program.
We also announced the BizTalk Adapter Pack: Office Developer Program. This program provides participants with access to code, support and direct access to the product team for bug fixes and change requests. By working with Office developers directly we will be validate additional Office/SharePoint scenarios. If you are interested in validating your SharePoint and Office scenarios, please visit the following site to register (note that you mean need to log in using Windows Live ID to access this site).
Key Benefits
· Single infrastructure for connectivity. Whether connecting to LOB systems from custom-developed applications, SQL Server, or rich Office applications, customers can use a consistent approach to connectivity. This enables a simplified approach to interoperability that lowers total cost of ownership and reduces training requirements.
· Simple to learn. Built on top of the WCF programming model, the BizTalk® Adapter Pack is easy for .NET trained developer to begin using and building connected applications. The BizTalk Adapter Pack provides enhanced extensions to WCF that enable dynamic metadata discovery and generation – making it fast and easy to access data in corporate systems.
· Secure and reliable. The BizTalk Adapter Pack tightly integrates with the security models provided by the individual business applications, ensuring that users have access only to data which they are permitted to see.
· Improves real-time visibility to your business data. The BizTalk® Adapter Pack allows customers to access valuable corporate information when and where they can use it most productively, increasing visibility and enabling faster, better informed decision making.
- The BizTalk Adapter Pack Team
Reply:
Does anyone knows when the candidate scenarios (especially MOSS 2007) will be released?
Thanks,
Roger
------------------------------------
Imaging
Reply:
Hi,
I am not quiet sure what the word "image desktops using it" means? What the function of SCE you want to have on desktops?
------------------------------------
Reply:
Hi,
As this thread has been quiet for a while we will be changing the issue type to 'Comment'.
If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.
If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.
Thanks!
-----------------------------
Sincerely,
Guozhen Wang
Microsoft Online Community Support
------------------------------------
Out-Of-Box Drivers not Show Drivers
Reply:
I don't think there is enough information there to determine the cause. What are you doing when Workbench crashes?
-Michael Niehaus
Microsoft Deployment Toolkit 2008/BDD 2007 dev lead
------------------------------------
Reply:
Hi
As this thread has been quiet for a while we will be changing the issue type to 'Comment'.
If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.
If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.
Thanks!
Tim Quan - MSFT
------------------------------------
Windows Vista Power Management
Hi All,
I recently bought Vista Home Premium. My initial install was utilizing the Upgrade option and that didn't fare too well. But, to be honest, I'm a power user, my program files were practically filling the screen on the start menu.
In any event, I recouped and went with a clean install. Installation time was much less and the results much better.
Actually, I'm a pretty happy camper, the video and sound are just mind boggling. And the clean install has my Visual Studio 2008 Pro humming.
One snafu, sleep mode. It was causing the system to reboot when it emerged. Today I came home and all was well. I had adjusted the power settings to Performance Mode. And now all appears well.
I don't know if this is a question or a comment, but I'm a programmer, and I rarely use sleep mode, because it interferes with utilizing the scheduled tasks.
In any event, The OS has a lot going for it. This Aereo is really something. I look forward to delving under the hood and seeing what I can find in the future.
Thanks,
John.
Flawed - SP1 a failure for the ordinary PC user
You can remove SP1 by using either Programs and Features or the command line. Note, however, that you cannot uninstall SP1 offline using any method
So did the genius who released to auto update have any idea of what ordinary, non software/computer savvy people are going to do when the upgrade nukes their internet connection?
If so would it be to much trouble for that genius to tell Microsofts own technical people how to fix it.
Because after over 8 hours on the phone to both MS tech support and my ISP tech support (costing £1 a minute) I still have no internet access. It took over 3 hours of arguing before MS support would even recognise thet SP1 had mistakenly nuked my copy of Vista home premium tagging it non-genuine and not allowing me to validate.
Now all you on here may be technical bods, and a small issue like losing your prime source of income for a day due to an unprofessionaly released flawed update may be a bit of an adventure, sorting out the glitches may even be a source of fun. But for the vast majority of PC users we have no knowledge of what happens behind the keyboard, and trust the manufacturer to only automaticaly download to our PC's stuff that isnt broken.
Of course we do have system restore, but there is the mnor issue in that you cannot restore back past the instalation of SP1, Another great brainwave..
so we cant uninstall, cant roll back, cant use our PC's ....
Good service pack MS great job if your going to screw something up do it well and make sure that it cant be simply undone</ends sarcasm mode>
This release isnt just flawed, it is for the ordinary computer user a complete and utter nightmare.
Sp1
I hate to sound like a sycophant but I've just installed Sp1 on two very different machines and the result was the same. An apparent speed boost of around 50%.
Now this might just be my imagination, running away with me, but everything seems more responsive and I can't click quickly enough to keep up with the system. Have Microsoft got it right?
Ok I'll shut up now (waits for flames...)
Prv Bld for new known issue with correlating Batch with AS2 with EDI with BizMetaData
In BTS2006 R2, while attempting to send AS2 session with EDI content via Batch mode of o/b transmission, using underlying BAM architecture for end-to-end message tracking, realized that records inserted into standard MS activities / views in DB BAMPrimaryImport were insufficient for correlating Batch with AS2 session with EDI envelope with BizMetaData (eg: PO# for EDI 850 o/b, Invoice# for EDI 810 o/b, etc...). This is because of a missing record in table bam_AS2InterchangeActivity_Completed in batch mode of o/b transmission whereas a record is in fact inserted in real-time mode of o/b transmission. MS has sent us a Prv Bld which resolved this issue, and could release a official hot fix soon (after completing their internal approval process).
Pre-Requisites for being a Moderator
Are there any?
I ask because I was just in the Vista Setup section of the forums and noticed a moderator telling a poster that if they do not want to enter passwords when they switch users they should blank the passwords out for the 2 affected users.
Do you have any idea how counter-productive that is?
In a day and age where ID Theft is becoming more and more frequent, that moderator needs to excercise a little better judgement when dealing with situations like this...
Microsoft user research study requesting participants!
Microsoft User Research is inviting IT professionals in the contiguous US to participate in a user research study. We are looking to learn from those who perform IT services for their company; such as routine server maintenance tasks, various levels of troubleshooting, daily server, network or desktop management, and the planning and implementation of technology. We want to meet at your office to learn from you, the experts, so that we can determine what needs to be improved in our software. This gives you the chance to tell us what your needs are and meet with some members of our product team. We highly value your feedback and will be offering Microsoft software in appreciation of your time and participation. If this is something that you or others at your company would be interested in, please reply to ms_sitev@microsoft.com at your earliest convenience. We are scheduling site visits to start in mid-April.
SP1- Fails spectactularly
downloaded the service pack last night booted up this morning to find my legit version of Vista home premium was considered dodgy, 3 hours of phone calls , a lot of quite hard pushing to get passed the customer service reps and actually get to talk to a tech support and then a lot of keyboard pressing by this complete computer dunce, at the direction of Microsoft tech support and we finally get the activation to rework.
Then I cant get on-line Vista will not identify a network or connection, 5 hours later after long calls to my ISP tech support (at a £1 a minute) and another 3 hours with microsoft technical support, I am being refered to Microsoft research team, who will try to call tomorrow.
You cant uninstall SP1 off line, and SP1 removes all restore points created before its installation, so you cant roll back when it screws up your ability to connect to the web
So I am using my laptop, who would have thought in the early days of XP we would be grateful for its stability
Query Performance Tuning topic in BOL, is there a mistake?
(1) Topic referred http://msdn2.microsoft.com/en-us/library/ms172984(SQL.100).aspx,
A tried out the next Index sample showed above:
Code SnippetCREATE INDEX Emp_Name ON Employees ("Last Name" ASC, "First Name" ASC)
With northdwind.sdf (3.5) sample database. After created, I've executed the follow selects:
Code Snippet-- SELECT ASELECT DISTINCT [Last Name], [First Name] FROM Employees;-- SELECT B
SELECT DISTINCT [First Name], [Last Name] FROM Employees;-- SELECT C
SELECT DISTINCT [Last Name] FROM Employees;-- SELECT D
SELECT DISTINCT [First Name] FROM Employees;
Including actual execution plan in SQL Server Management Studio. I noticed that Select A,B,C begins with index scan on Emp_Name and Select D doesn't.
(I screenshoted it)
This topic (1) say:
For a DISTINCT operation to consider a multiple-column index, the projection list must match all index columns, although they do not have to be in the exact order. The previous index can help optimize the following queries:
... DISTINCT "Last Name", "First Name" ...
... DISTINCT "First Name", "Last Name" ...
It will not help optimize:
... DISTINCT "First Name" ...
... DISTINCT "Last Name" ...
It should say:
For a DISTINCT operation to consider a multiple-column index, the projection list must match all index columns, although they do not have to be in the exact order, or could match the first one. The previous index can help optimize the following queries:
... DISTINCT "Last Name", "First Name" ...
... DISTINCT "First Name", "Last Name" ...
... DISTINCT "Last Name" ...
It will not help optimize:
... DISTINCT "First Name" ...
Am I wrong?? or actually is there a mistake in BOL, Query Performance Tuning topic (1)??
regards,,,
Transfer Binary Data (image data type) with XML
Transfer Binary Data (image data type) with XML
I try to transfer binary data ( it's Image data type) with XML but in destination when I convert xml into my table every data type is fine except of image (image data type).
please look at below T-SQL code , I try to convert Data into XML then again convert xml into a table as normal data and it works fine for every thing except of image data type.
-- a sample for transfer binary data with XML
declare @Source as table ( ID int
, myDate smallDateTime
, Credit decimal(10, 3)
, name varchar(20)
, myData image
)
insert into @Source
(ID , myDate , Credit , name , myData )
values (25 , getdate() , 28.258 , 'Farzad Jalali' , 0x00ffee2345 )
insert into @Source
(ID , myDate , Credit , name , myData )
values (26 , getdate() , 35.671 , 'Chris Evans' , 0x004575F4B212EBA3467E43A376EC3)
declare @XMLString as xml
-- select * from @source
set @XMLString = (select * from @source for xml path('Customer') , root('myList') )
-- select @XMLString
-- we are going to convert xml to normal data and insert into a table
declare @Destination as table ( ID int
, myDate smallDateTime
, Credit decimal(10, 3)
, name varchar(20)
, myData image
)
DECLARE @idoc INT
EXEC sp_xml_preparedocument @idoc OUTPUT, @XMLString
insert into @Destination
SELECT ID
, myDate
, Credit
, name
, myData
FROM OPENXML (@idoc, '/myList/Customer', 2)
WITH ( ID int
, myDate smallDateTime
, Credit decimal(10, 3)
, name varchar(20)
, myData image
)
-- select * from @Destination
select * from @source
select * from @Destination
Reply:
See this http://www.xml.com/pub/a/98/07/binary/binary.html that talks about workaround on using Binary data with XML.
http://www.topxml.com/xml/articles/binary/XML%20and%20Binary%20Data2.asp one too
------------------------------------
Reply:
Hi Satya SKJ ,
Thanks for links , I read them and they are close but Can you fix the above T-SQL code to works fine in SQL 2005 (or 2008) ?
* I look at database ( in this case SQL Server but what ever SQL server or Oracle or DB2 or mySQL) as a black box that should deal with my data and return same data that I passed into it. In my case as veiw of my application when my application send a recored like (25 , getdate() , 28.258 , 'Farzad Jalali' , 0x00ffee2345 )
into database then when database try to transfer data as xml (via biztalk server or any thing else) to another server , it suppose to return same data exactly like (25 , getdate() , 28.258 , 'Farzad Jalali' , 0x00ffee2345 ) to my application.
* Do you think maybe microsoft provide an special way for transfer image data type with XML ? ( I mean something except of that way that I used in above code)
* if SQL Server can't keep data safe in duration of a simple operation like dealing with xml ( inside of SQL server) , I really really affraid to call it database 
Thanks again for link , they don't have a solution for this problem of SQL Server but I really enjoyed to read them.
frzJalali------------------------------------
Everbody before installing Windows Vista Sp1
Before installing windows vista sp1 everbody just do a clean install of vista before installing vista sp1 it could work or not work but try that first before posting on here it could help and reformat the pc not just delete OS and call that reformat do a clean install everbody.
P.S.
If anybody is using nvidia video cards vista is not going to work for them ATI video card work on vista i have no problems with it when i am using my ATI card so what ever MS did for ATI is a good job. I also have a nvidia video card and it calls a lot problems for me it half to be the drivers for it thats calling the problems for nvidia because i was always getting bsod all the time for it.
Reply:
------------------------------------
Reply:
------------------------------------
bluetooth
My bluetooth is not woking and its made by .......wait .....wait
Microsoft haha Vista is *** and microsoft the game is up
Reply:
Hello,
If you're still looking for a solution for this issue, let me know the model of your Bluetooth device and more details about the problem.
Lionel Chen
Microsoft Online Community Support
------------------------------------
Reply:
Hi,
As this thread has been quiet for a while we will be changing the issue type to 'Comment'.
If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.
If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.
Thanks!
Regards,
Lionel Chen
Microsoft Online Community Support
------------------------------------
Vista SP1 error 80041315
With McAffee security centre (virus and firewall) Error 80014315 when installing Vista SP1 (100% complete and then roll back) including remaining error with miniport. After removing McAffee completely, SP1 installed flawlessly and the miniport was gone as well. Hence uninstall (remove) McAffee security centre prior to installing SP1.
Warning if You Have Creative X-Fi
I tried to install SP1 via Win update today. The system blue-screened everytime it attempted to reboot. I started it in Safe mode, but that only allowed SP1 to continue running. Finally when it was done, Windows reported that SP1 was not installed and attempted to revert to the old code. After watching it churn for a while, I became bored with the whole thing and loaded a clean Ghost image. I visited Creative's web site and discovered they recently posted a new X_Fi driver dated 3-14-08. The first fix it mentioned was a correction of issues with 4GB of memory -- which I have. I read no further and updated the driver. I revisted Win Update and installed SP1 in about 20 minutes with absolutely no problems.
I frequently check for new sound and video drivers and checked Creative last week. I guess the moral of this story is I should check five minutes before I attempt to load a Service Pack. By the way, Creative has a driver for XP to correct the same 4GB issue.
Microsoft spokesperson gives info about Win Xp SP3 Build 5503 : Don't use it!!!
Here's an excerpt from this article about Win XP Sp3 Build 5503 which is said to be from an actual Microsoft person
http://www.crn.com/software/206904757 :
"A Microsoft spokesperson, perhaps weary from the months-long barrage of Vista SP1 related inquiries, said the final version of XP SP3 is still on target to be released the first half of calendar year 2008, and the XP SP3 5503 build was a minor interim build released to address one specific issue for a subset of private beta testers.
"This build was not intended for public release, and anyone who has that build and is not part of the private beta is working with bits that Microsoft can't verify the integrity -- it's possible the bits may have been modified with malware or other bad code that Microsoft hasn't tested," the spokesperson said in an email." "
Reply:
| WinUser42 wrote: | |
|
WinUser42,
You're unlikely to get a confirmation or official words from SP3 developers/Microsoft regarding leak versions of SP3 later builds. What the spokesperson said is correct though, "it's possible the bits may have been modified with malware or other bad code that Microsoft hasn't tested".
Regards,
Thomas
------------------------------------
Multi-platform migrations to Exchange
Find out more at http://www.gem-si.com. Thank you.
No comments:
Post a Comment