We have a post on TechNet discuss our new on-premise solution for organizations that want to host Office Web apps on their own networks. If you read desire on a more technical discussion on our new server offering, see introduction of Office Web Apps Server.
Nick Simons
Senior Program Manager - Office Web apps
Guest blogger Juan Soto, an Access MVP and founder of IT Impact, Inc., shares five tips on upgrading Access to SQL. You can read more about Juan and his experiences and knowledge of Access knowledge in our Q&A with him.
Access works great with SQL Server but upgrading your data is not a slam dunk. There are all kinds of things that can go wrong if you're not careful, avoid these pitfalls when you do your first or next Access migration.
Pitfall #1: Relying on the SQL Server Migration Assistant for everything
I'll be the first one to endorse the SQL Server Migration Assistant. It does away with a lot of manual work, but it's not perfect. For example, if you have queries that use custom functions, the Assistant will not even try to create a SQL View, leaving it up to you to make it happen. You can download the Assistant here.
Pitfall #2: Not adding necessary foreign keys and indexing them
Access automatically adds a secondary index when you add a new field that ends in "ID", as in "CustomerID". When you create a relationship in Access, it also automatically creates an index with the relationship. Not so with SQL Server. You must manually add foreign keys to your SQL Server database and index them.
Pitfall #3: Not adding a rowversion field to all of your tables
In order to avoid problems with Access committing record changes to SQL Server, always add a rowversion field. Normally, the Assistant will add it only when it determines it's necessary; for example, a column on the table that uses floating numbers might be a good candidate for needing a rowversion, but I recommend that all of your tables have a rowversion column.
Note: In older SQL Server versions, rowversion data type is confusingly labeled as timestamp data type. It has nothing to do with timestamping but indicates relative order of when a row was updated in a table's life. If your copy of SQL Server shows only timestamp, please use it instead.
Pitfall #4: Leaving your bit fields nullable
Think of bit fields as Yes/No fields in Access. In order for them to work in Access, you need to make sure every bit field cannot be nullable, and so you need to set the default value to zero, e.g. false, in your SQL Server table design.
Pitfall #5: Not taking advantage of what SQL Server has to offer
Getting your Access tables into SQL Server is a great first step, but if you just stop there you're leaving a lot on the table: using Views, stored procedures and functions are a great way to turbo charge your Access app. Start with Views and work your way up to stored procedures. For more great tips on using these tools, I suggest browsing through all of my blog posts on SQL Server with Access at AccessExperts.net/blog/SQL-Server.
Microsoft Windows Home Server is great Software Media home management who will act as a media server, networking your compatible Windows PC, Mac, handheld devices and XBOX 360 to manage and distribute your digital media content. No, not only that it will also provide computers (Windows and Mac) backups, remote access devices in the home automation and much more. But since you have to buy a server with the software, it can become expensive, so he landed in second place on our list and WINS our toptenreviews Silver Award.
Ease of use:
There is Apple Mac OS X computers is more your speed running, there is perhaps a bit of a learning curve to master user interface. But Microsoft provides much assistance with their tech support options including direct contact (phone, email and live chat), user manual and the knowledge on their Web site FAQ page.
We strongly recommend to converse with others in the forums of official users and also do a search on the web for Windows Home Server and home media management software fansite dedicated to helping others with the establishment.
You can access compatible digital files (videos, music, etc.) with a number of devices such as computers (running Windows and Mac). an XBOX 360. some televisions, speakers, and Blu - ray or DVD drives mobile phones. handheld devices. and much more.
Backup of the files to the main server, including one with a lot of hard disk space, is easy, and Windows Home Server do so with Windows PC (running Windows 7 or earlier) and Apple computers (Mac OS X 10.6 Snow Leopard and earlier running). In addition, if something happens to your computers, it is not difficult to restore backed up files.
Remote access allows compatible computers, phones and handheld devices to access the content of digital media, such as a new video uploaded to the server. So even if you're away on vacation or a business trip, you can still access most of this content. If you use a computer, you can also access applications with Windows.
Using of software add-ins, you can also control the automation of certain electronic devices in your home, such as lights, thermostat and much more. Some D-Link cameras can also be implemented and followed by Windows Home Server, so you can have an additional level of security while also keeping an eye on babies and children playing around the swimming pool.
Another interesting complement is my films, which will be rip and convert legally full CD and DVD, with a digital content on a USB drive. From there, films and other content in all the streaming network is child's play. Windows Home Server has a list of all Microsoft Web site add-ins.
Video and sound quality:
purchase or rent content: 
There are a number of sites and services that provide purchases and rentals, Netflix, iTunes Store, CinemaNow, Amazon Video On Demand, and others. See our learning center for a look at these services call. If there is a compatibility issue, as if the server could not read or file streams, you can convert it to a different format.
Play digital media content: If you have pictures or home videos that you want to share, you can easily set up a special Web site, secure that friends and family can access. Once more, video and audio quality remain high, so there is no concern for any image or the loss of sound quality.
Internet content: & help: Summary: Windows Home Server screenshots
Technical Communication / FM Server 10 – More on Usageby Amit AgarwalAdobe (26)Adobe FrameMaker Server 10 (1)FrameMaker Integration (9)FrameMaker10 (6)RoboHelp 9 (4)
Home Blogs 
Windows Blogging Windows Windows Experience Blog Extreme Windows Blog Windows for your Business Developing for Windows Windows Security Blog Springboard Series Blog Windows Home Server Blog Windows Live Inside Windows Live Windows Live for Developers Windows Phone Windows Phone Blog Windows Phone Developer Blog Windows Mobile 6 Developer Blog Internet Explorer Exploring IE International El blog de Windows para América Latina O Blog do Windows para o Brasil ???? Windows ??? ?????? Videos Windows.com 
by Brandon LeBlanc 5 Back in January, Gavriella Schuster published a blog post introducing Windows MultiPoint Server 2011. Windows MultiPoint Server is designed to make technology access easier and more affordable for educational institutions. What Windows MultiPoint Server does is a PC’s excess capability to enable a single PC to support multiple users simultaneously. It can be used for in classrooms, labs and libraries. Today, we are happy to announce that the trial for Windows MultiPoint Server 2011 is now available on the Microsoft Download Center for download. Later this week, Windows MultiPoint Server 2011 will be available for TechNet and MSDN subscribers to download. Windows MultiPoint Server 2011 will be available in 2 editions: Standard and Premium. The difference between the two is that Standard will not support domain-joining and allow for only up 10 stations (or 10 sessions) while Premium is domain-joinable, supports up to 20 stations (or 20 sessions), and supports Hyper-V. Windows MultiPoint Server 2011 will be available for purchase by Volume License customers on March 1st with broader availability happening in mid-April.
Last week, I met up with Dean Paron from the Windows MultiPoint Server Team where we shot a video of him talking through Windows MultiPoint Server 2011 and its features. Give it a watch:
It was really exciting to see Windows MultiPoint Server 2011 in action for myself. It was great seeing the type of experience a student would have with Windows MultiPoint Server which provides a Windows 7 desktop experience - at the same time empathize with the realities of what teachers and instructors are up against with limited resources and tight budgets. I can easily see where Windows MultiPoint Server can make a difference. Here are a few features in Windows MultiPoint Server 2011 that I think really impact both student and teach productivity in the classroom:
Desktop Thumbnails –Through the Management Console, teachers can orchestrate activities across the classroom including sharing any specific desktop across all stations. Split Screen Capabilities – A single monitor can actually serve as 2 stations by splitting the screen. That means 2 students can share a single monitor. This can encourage collaboration between students. It also can be extremely helpful in places where budgets are tight and monitors aren’t easy to come by. Station Control –Teachers can lock any one or all stations if needed and can also open and close applications too. Teachers also have the ability to allow only certain websites in a “allowed list” through the Management Console.And there are features that make Windows MultiPoint Server 2011 easy to manage from the IT Professional perspective:
Network-connected Stations – Stations can be directly connected to host PC (directly or via USB with devices from partners such as HP) or through the network (wired or wireless!). This enables stations to be set up in a variety of configurations versus having to be clustered close to a host PC. Multiple Windows MultiPoint Servers – Administrators can connect multiple Windows MultiPoint Servers together into “pods” which can then be managed all together through the Management Console. They can make it super easy to manage Windows MultiPoint Servers in a single room or across a building. Domain-join – For places with an existing Windows Server infrastructure with Active Directory in place, Windows MultiPoint Server can be joined to a domain and managed through the same tools that are used to manage all the rest of the PCs on the network (and users).It was wonderful to get a first-hand look at Windows MultiPoint Server 2011 and its functionality. It was also awesome getting to speak to Dean to get insight on its features and functionality.
We’re on track to make Windows MultiPoint Server 2011 generally available next month. It will be available in Academic Volume License, Open Volume License, and OEM channels which is great as that means more people will have access to Windows MultiPoint Server! I also suggest reading Dean’s blog post on the Windows Small Business Server blog for more details on Windows MultiPoint Server 2011.
Tags: Windows 7, Education, Shared Resource Computing, Teachers, Students, Windows MultiPoint Server, School, Windows MultiPoint Server 2011, IT, Volume License, WMS, Trial 5 Comments TweetYou must be logged in to comment. Sign in or join now.Windows Blog - Comment and Trackbacks Comments (5)
limitedmage 
2 Posts Wow, WMS 2011 looks amazing!! Congrats to everyone in the WMS team :)
February 21, 2011 liviRose 1 Posts Yay! Congrats everyone! I'm super excited that I got to play with WMS 2011 when I was out there! It's awesome!
February 21, 2011 7flavor 
283 Posts Such technology would be useful in mainstream Windows or Windows Server as well but Microsoft is too restrictive IMHO about simultaneous Remote Desktop connections technology licensing which MultiPoint uses. It's like again producing a separate Terminal Server edition of Windows just to allow multiple users to connect simultaneously.
February 21, 2011 7flavor 283 Posts Btw the equivalent Linux-based offering from Userful does have a way to multi-user enable regular Linux distribution.
February 22, 2011 Pedro Feliciano 1 Posts Witcht client hardware was used in this presentation ?
March 25, 2011 Other Microsoft Team Blogs The Microsoft Office Blog Bing Community Major Nelson Zune Insider Support Microsoft Answers Windows Live Solution Center Windows 7 Help & How-to Windows 7 TechNet Forums Windows.com Windows 7 Upgrade Advisor Windows 7 Compatibility Center Windows PC Scout Windows Anytime Upgrade Quick Links Buy Windows 7 Download Windows Live Essentials Download Microsoft Security Essentials powered by Telligent © 2010 Microsoft. Windows 7 Disclaimer Send Feedback Terms of Use Trademarks Privacy Statement MicrosoftBrandon:
This article gives a good explanation of how to enable additional options for Disk Cleanup:
social.answers.microsoft.com/.../ed58c580-278b-48f7-949f-5f42be3c8f6e
HOWEVER - the Remove System Files option is not one of them I followed the articles instructions and enabled just about everything but the size of my WINSXS folder did not change.
There are several other articles that talk about the Remove System Files option, but for the life of me I can't find a way to make this option visible. (My system is WIn7-64 Home Premium.) I'd really like to know hot to do this this since the size of WINSXS is a major issue for everyone who uses an SSD boot drive.
Thanks for whatever help you can provide on this.
PS: adding an SSD boot drive was the single biggest performance booster I've ever done. I highly recommend making that upgrade for anyone who wants noticeably better overall system response time.
Microsoft’s Windows Home Server is terrific home media management software that will act as a media server, networking your compatible Windows PCs, Macs, handheld devices and XBOX 360 to manage and stream your digital media content. Not only that, it will also provide backups of computers (both Windows and Mac), remote access, automation of devices in the home and more. But since you have to buy a server bundled with the software, it can get expensive, so it lands in second place on our list and wins our TopTenREVIEWS Silver Award.
Ease of Use: If there are Apple computers running Mac OS X is more your speed, there may be a little bit of a learning curve to master the UI. But Microsoft provides plenty of help with their tech support options, including direct contact (phone, email and live chat), the user manual and the FAQs/Knowledge Base page on their website.
We highly recommend chatting with others in the official user forums, and also doing a web search for Windows Home Server and home media management software fan sites dedicated to helping others out with set-up.
You can access compatible digital files (videos, music, etc.) with a number of devices, such as computers (running both Windows and Mac); an XBOX 360; certain HDTVs, speakers and Blu-ray or DVD players; mobile phones; handheld devices; and more.
Backing up files to the main server, especially one with plenty of hard drive space, is easy, and Windows Home Server will do so with both Windows PCs (running Windows 7 or earlier) and Apple computers (running Mac OS X 10.6 Snow Leopard and earlier). Plus, if anything happens to your computers, it’s not difficult to restore the backed up files.
Remote access allows compatible computers, phones and handheld devices to access digital media content from afar, such as a new home video uploaded to the server. So even if you’re away on vacation or a business trip, you can still access much of that content. If you’re using a computer, you can also access applications with Windows.
Using software add-ins, you can also control the automation of certain electronic devices in your house, such as lights, the thermostat and more. Certain D-Link cameras can also be set-up and monitored from Windows Home Server, so you can have an extra level of security while also keeping an eye on the baby and kids playing around the pool.
Another interesting add-in is My Movies, which will rip and convert legally owned CDs and DVDs, along with digital content on a USB drive. From there, streaming movies and other content throughout the network is a cinch. Microsoft’s Windows Home Server’s website has a list of all the add-ins.
Video and Sound Quality: Purchase or Rent Content: There are a number of sites and services that provide purchases and rentals, including Netflix, the iTunes Store, CinemaNow, Amazon Video On Demand and others. See our learning center for a look at these services. If there’s a compatibility issue, such as if the server can’t read or stream the file, you can convert it to a different format.
Play Digital Media Content: If you have some photos or home videos you’d like to share, you can easily set up a special, secure website that friends and family can access. Again, video and audio quality remain high, so there is no worry of any image or sound quality loss.
Internet Content: Help & Support: Summary: Windows Home Server Screenshots