In regards to SQL Server 2008 R2, I worked on some more options of the procedure to compress tables. The last version I released can be found here: http://blogs.msdn.com/saponsqlserver/archive/2009/10/11/version-2-3-of-sap-use-db-compression-released.aspx

One case I didn’t consider in that last version was the fact that there is a mix of tables being ROW compressed and Page Dictionary compressed. This was the situation on Microsoft’s ERP system. All our SAP Basis team wanted to do is to rebuild the clustered indexes with the same compression type as the index already had. As mentioned in earlier posts this would apply UCS2 compression to already existing data when running on SQL Server 2008 R2. Version 2.42 of the procedure as published in this article does contain such an option.

The new option is named @force_rebuild_same. The call of the procedure to execute a rebuild of the clustered indexes with their current compression type would look like:

sp_use_db_compression @maxdop=1,  @online= ‘ON’, @force_rebuild_same=1

In this case one CPU would be used to rebuild he indexes in an online manner. All the clustered indexes which are Row or Page Dictionary compressed will be rebuilt in their actual compression method. As such the procedure was used last weekend in Microsoft’s SAP ERP system. We by far didn’t do all tables, but cut another 400GB out of the database, which came down from 5.3 to 4.9TB in data volume. However the largest tables still need to be done and we expect another 600 GB of space savings. Happy space saving J

Another SAP customer of ours out of the Defense industry space used the @write_verbose_table option quite intensively. They simply used this procedure to get the alter table/index commands in the correct order (sorted from the smallest table to the largest table) and then copied the commands and formed batches of the commands which they executed in periods of low activities. Also a good way to use the procedure. Find the new version at the end of the blog article. I also got positive feedback on the usage of the procedure out of the non-SAP space. Thanks for using it and thanks for the feedback!

Hope this new procedure helps!  Juergen

いずれも各支店にあるセミナー ルームを利用しますので、会場はそんなに広くないです。ご興味ある方はお早めにお申し込み頂ければと。

2010年3月11日(木) 大阪 終了いたしました

2010年4月20日(火) 広島 詳細・お申し込み

2010年5月19日(水) 仙台 詳細・お申し込み

2010年5月20日(木) 福岡 詳細・お申し込み

2010年5月25日(火) 高崎 詳細・お申し込み

2010年5月31日(月) 札幌 詳細・お申し込み

2010年6月1日(火) 名古屋 詳細・お申し込み

時間は共通で、13:30～17:00（13:00受付開始）です。詳細はこちら。

This post originated from and is provided by the MSDN Blogs RSS feed. The original post of the article can be found here.

A bit late in posting this, as I just got back from MIX10, but here’s my local editorial for the MSDN Flash newsletter for Mid-Atlantic:

http://msdn.microsoft.com/en-us/ff458328.aspx

There’s info on our current MSDN Roadshow tour, upcoming Code Camps, this weekend’s Southern Maryland GiveCamp, and more.

You can subscribe to the MSDN Flash here:

http://msdn.microsoft.com/en-us/aa570311.aspx

This post originated from and is provided by the MSDN Blogs RSS feed. The original post of the article can be found here.

東京、名古屋ときて本日が大阪会場での開催です。タイトルが「今明かす、Windows Azure の全貌」と期待を持たせる感じではありますが、セッション時間は50分。この50分で機能概要、事例、インフラ説明、管理の概要的な話を混ぜつつ、価格とか購入の話とか入れ込んで全貌をご理解頂こうとやっておりますが、なかなか50分にはおさまりませんね。。。

消化不良の方がいらっしゃったら、すいません。そういう方は是非、Azure の製品サイトをご覧ください。

スライドはこちらです。

This post originated from and is provided by the MSDN Blogs RSS feed. The original post of the article can be found here.

Auckland 22 April 2010 + Wellington 23 April 2010

You are invited to the official NZ launch of Visual Studio 2010 and Windows Azure. We’ve lined up two international experts to deliver two keynotes. Plus, to mark the occasion, we’re producing a very cool retro t-shirt for all attendees, and there are also great prizes to be won! Best of all, this event is free to attend!

Click here for more information and to register!

Today, the Reporting Services team gave a series of presentations at an all day “airlift” event.  Here are the reports and database backup for the demo I gave.  In future posts, I will  walk through building this report.  Thank you for attending the event today!

This post originated from and is provided by the MSDN Blogs RSS feed. The original post of the article can be found here.

Syed Aslam Basha here. I am a tester on the Information Security Tools Team.

At times you would have to run applications say internet explorer (IE) or sql server management studio (SSMS) or command prompt with service account for that you would login in a machine with service account and launch the applications. But with Runas feature you can launch applications using service account credentials even though you have logged in with your credentials. In this blog post I will show the usage of “Run as” feature;

• Launch the command prompt in admin mode
• Type in Runas /user:domainname\serviceaccountname application
• Application can be command prompt, IE, SSMS or any other application

-Syed Aslam Basha (syedab@microsoft.com)

Microsoft Information Security Tools (IST) Team

Test Lead

This post originated from and is provided by the MSDN Blogs RSS feed. The original post of the article can be found here.

One of the Top Ten benefits of Office 2010 is the ability to have co-authoring allowing multiple people to edit and view Office documents simultaneously.

This capability is going to turn ordinary file sharing and authoring on it’s head – the implications of how it will affect the world of collaborative work will be profound.

Consider this scenario where a team needs to create and submit a document with a deadline – such as Business Case documents, Proposals, RFP documents, Tenders, Project Plans etc.  These kind of documents are the ones that are important for your business.   Traditionally these files have many authors for sections, and are emailed around, or perhaps shared in a Network File Share or Document Management system like SharePoint.

With any of these approaches there is a fundamental truth, and that is once one author opens the document, the entire document is locked from editing for other people.  You are probably familiar with this dialog below?

It’s a pain.  You’ve managed to carve 30 minutes out of your calendar to work on the “Important Document”, only to find it is locked.

With Office 2010 and the Co-authoring capabilities you won’t see this dialog.  Instead, the document will simply open up, and you’ll see that there is one or more other Authors Editing the Document.  We are using this right now for a large proposal for a customer, and there is 8 of us here at Microsoft contributing to the document.  In stead of managing versions and check in/out, we are keeping a single living document that we can all edit at any time in Word in a Wiki-style approach.  Importantly – none of us had to change anything we would normally do – we just open the document, edit, and save regardless if others are already editing.

And through your authoring you might see people appear and then leave when they’ve finished their updates.  You will see their updates once you Save the document.

I have put together 4 videos, each around 6 minutes long that demonstrates the Co-authoring capability in Office 2010 for PowerPoint, Word, Excel and also the most exciting application in all versions of Office – OneNote!

PowerPoint:

http://www.youtube.com/watch?v=fOTK9tIncVo

Word:

http://www.youtube.com/watch?v=RykvktiRmD4

Excel:

OneNote:

http://www.youtube.com/watch?v=SP1OEx_i4Fg

This post originated from and is provided by the MSDN Blogs RSS feed. The original post of the article can be found here.

	Vai começar a Copa Microsoft de Talentos! Tudo pronto? Seu talento pode fazer a diferença! A Copa Microsoft de Talentos é uma onda de eventos para a comunidade técnica, que visa apresentar conteúdo técnico de alto nível de diversos produtos e tecnologias. Durante a Copa Microsoft de Talentos, participe da competição que vai revelar os maiores craques do conhecimento e da tecnologia. A disputa será realizada em duas etapas: a primeira é classificatória por pontuação e a segunda é eliminatória, em um clássico “mata-mata”. Você pode colocar seu nome na história e ainda faturar a premiação. Os 60 melhores jogadores ganham prêmios incríveis! Tem MSDN ou TechNet Subscription, Camiseta oficial da seleção brasileira de futebol, Xbox 360, TV LED, Blu-ray e Home Theater! O pontapé inicial será dia 20 de março, no Community Launch 2010. Aproveite para sair na frente na busca pelo conhecimento. Afinal, o evento que conta tudo sobre os novos produtos é 100% promovido pela Microsoft Brasil, com organização da comunidade e abertura da equipe TechNet & MSDN!	E não perca a passagem do Road Show pela sua região, com muito material e conteúdo para você dar o show na Copa Microsoft de Talentos. Realizado pelos especialistas técnicos da Microsoft Brasil, ele traz uma abordagem completa dos cenários de implementação e atividades indispensáveis para quem quer ser campeão. Não perca estas oportunidades! Acesse http://www.talentosmicrosoft.com.br, confira o calendário com as programações e jogue pra ganhar!

This post originated from and is provided by the MSDN Blogs RSS feed. The original post of the article can be found here.

a wefit ( www.wefit.com.br )  trouxe 5 profissionais aqui pro MIX10 e participaram bastante do evento, fizeram networking, conheceram gente do mundo todo e tal. Hoje o Rogério me mandou o link pra esse testemunho super bacana da equipe deles. adorei, wefit!  foi bárbaro ter voces aqui em Vegas com a gente!…(read more)
This post originated from and is provided by the MSDN Blogs RSS feed. The original post of the article can be found here.