DavidOverton.com
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  

David Overton's Blog

  • SQL 2005 - BI, Search, Samples, Tuning and Virtual Labs

    Extending Enterprise Search Capabilities to your BI Applications Quickly get up and running on the key concepts of delivering business intelligence search using features in Microsoft Office SharePoint Server 2007 and SQL Server 2005. As an added bonus download the sample content below and walk through the process step-by-step with the whitepaper. http://www.microsoft.com/bi/resources/whitepapers.aspx http://download.microsoft.com/download/7/2/a/72ae11fe-564d-4756-a878-eccb2e0692d7/BI%20Search%20Technical%20White%20Paper.doc ETL Performance: Unisys and Microsoft SQL Server 2005 Speed Up the Process Unisys and Microsoft prove SQL Server 2005 supports 64-bit parallel processing and delivers high levels of Extraction, Transformation and Loading (ETL) performance on Unisys ES7000 servers. This white paper summarizes the results of collaborative testing between Microsoft and Unisys running ETL processes on Intel® Xeon® (32-bit) and Intel® Itanium® 2 (64-bit) based ES7000 servers. http://www.unisys.com/eprise/main/admin...
  • test post - ignore as it will be deleted

    foo bar baz - now to be entered as HTML foo bar baz ttfn David
  • SQL Development with LINQ and .Net

    MSDN Webcast: Framework Masterclass: LINQ to SQL (Level 200) – Recorded Microsoft .NET Language Integrated Query (LINQ) provides a common way to work with data in your applications. In this session, we dive into how LINQ provides methods to work with Structured Query Language (SQL) databases, including how to query, insert, and manage data using the LINQ framework. MSDN Webcast: Framework Masterclass: LINQ to SQL (Level 200) MSDN Webcast: Framework Masterclass: LINQ to XML (Level 200) – Monday, September 17, 2007 12:00 PM Pacific Time (US & Canada) In other sessions, we have already seen how Microsoft .NET Language Integrated Query (LINQ) works with relational databases. In this webcast, we explore how LINQ can help you develop XML applications. We cover the basics of the XML helper functions, and we also dive into deeper topics. MSDN Webcast: Framework Masterclass: LINQ to XML (Level 200) MSDN Webcast: Programming SQL Server 2008 (Level 300) – Monday, September 17, 2007 1:00 PM Pacific Time (US & Canada...
  • Is Google evil and so what if they are?

    I saw these two web pages and just found them too compelling. I can tell you more than you might imagine about people who come to my site, but it pales into comparison when you see what Google can store and some of the conditions. Anyone who says "they won't use it" needs to rethink the demands of shareholders to maximise revenue and profit. I would suggest looking at: Google Docs and Spreadsheets clause gives pause For a company whose motto is "Do no evil," it's interesting how often Google's customers suspect them of it http://www.infoworld.com/article/07/09/14/Google-clause-gives-pause_1.html and then the "story" at Radar Fiction - "Scroogled" Google controls your e-mail, your videos, your calendar, your searches… What if it controlled your life? By Cory Doctorow http://www.radaronline.com/from-the-magazine/2007/09/google_fiction_evil_dangerous_surveillance_control_1.php I then clicked on the I-Spy link on the last page of the Radaronline fiction and was able...
    Filed under:
  • Windows Server 2008 Information on Branch Office solutions, Management, Security and Performance

    Managing Distributed Branch Office Environments with System Center and Windows Server 2008 Distributed branch office configurations within many enterprise organizations are increasing in number and growing in complexity. In this webcast, we highlight the Microsoft System Center portfolio of IT management solutions and Windows Server 2008. We discuss various IT solutions and architectures that can help you deliver quality IT service management for branch environments. http://go.microsoft.com/?linkid=7280989 Windows Server 2008: Management, Security and Improved Performance for Your Remote Infrastructure Join us for a Q&A on the new features in Windows Server 2008 that will help you manage and secure your remote infrastructure as well as WAN performance improvements included in the new TCP and SMB protocols. Ask our experts about Windows BitLocker Drive Encryption, improvements in Active Directory, Server Core, the Next Generation TCP stack and SMB 2.0. http://go.microsoft.com/?linkid=7280990 ttfn David Technorati...
  • SQL 2000 Performance Tuning and Optimization Datasheet

    SQL Server 2000: Performance Tuning and Optimization Datasheet This 4-day workshop provides information on SQL 2000 index and page structures, performance troubleshooting tools, memory architecture, programming efficiency, and optimization techniques. http://www.microsoft.com/downloads/details.aspx?FamilyID=0556317d-66c3-4a6d-a128-4d6f873a28b3&DisplayLang=en ttfn David Technorati Tags: SQL 2000 Performance Tuning
  • Want to know what one of my accounts looks like - have a look at Microsoft Case Studies: Corporate Modelling

    I'm enjoying being an ISV PAM (Independent Software Vendor Partner Account Manager) and while I miss my small business role, the new job has me looking after accounts that are small and big. One such account already has a case study up. To improve ease of use for its business customers, Corporate Modelling decided to develop its business process management solutions using Microsoft® products. The company also joined the Microsoft Partner Program, which has not only provided guidance for long-term development but also strategic sales leads and connections with other vendors. Corporate Modelling expects to double its revenue every nine months. Microsoft Case Studies: Corporate Modelling This is not my work, I'm just carrying on the great work of others, but it is nice to work with such people. ttfn David Technorati Tags: ISVs , Corporate Modelling
    Filed under:
  • Windows Server 2003 Information updates (Group Policy, Federation, Virtual Machine Manager, Physical Security, Improving Performance)

    Group Policy Diagnostic Best Practice Analyzer for Windows Server 2003 x64 Edition (KB940122) The Microsoft Group Policy Diagnostic Best Practice Analyzer (GPDBPA) for Windows XP and Windows Server 2003 is designed to help you identify Group Policy configuration errors or other dependency failures that may prevent settings or features from functioning as expected. http://www.microsoft.com/downloads/details.aspx?FamilyID=70e0edec-66f7-4499-83b7-4f2009df2314&DisplayLang=en Group Policy Diagnostic Best Practice Analyzer for Windows Server 2003 (KB940122) The Microsoft Group Policy Diagnostic Best Practice Analyzer (GPDBPA) for Windows XP and Windows Server 2003 is designed to help you identify Group Policy configuration errors or other dependency failures that may prevent settings or features from functioning as expected. http://www.microsoft.com/downloads/info.aspx?na=22&p=3&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d47f11b02-8ee4-450b-bf13-880b91ba4566...
  • Things they said would never happen - Sun becoming a Windows OEM and Microsoft and Novell open Windows and Linux interop Labs

    I saw this and thought I would publish this to show that businesses will always put differences behind them if they think there is a buck to be made: Sun to Install Windows Server on Its Hardware Sun Microsystems will start selling its lineup of 64-bit, x86-based servers preinstalled with the Windows Server operating system within 90 days. and Microsoft/Novell Open Windows/Linux Interop Lab The initial focus will be around three projects involving virtualization, management, and identity federation. This just proves that all firms are commercial! Don't believe the religious hype! Of course, competition will still be just as fierce. ttfn David Technorati Tags: Sun , Windows , Novell
  • Replying to Vijay's "Who understands Microsoft Licensing?" blog - why I think he is right and wrong

    Nothing like a blog entry on licensing to stir the people into action. Vijay posted a "small" post - Who understands Microsoft Licensing? . I'm now going to respond to both the main blog post and also some of the comments. I highly recommend you read the entry, the comments (some are included below, also for comment) and the linked blogs, especially the entry by Adam at Sorting out the complexity of Microsoft Volume Licensing as well as the others My conclusion to this question is that hardly anyone understands Microsoft Licensing. I’ve been to quite a few Microsoft Partner events and when the above question above is asked there is usually a very low number of businesses who say they understand it. This feedback is given time and time again but nothing really changes. The solution isn’t explaining it over and over again or writing Licensing Reseller Handbooks. If you can't explain something to a customer in a very succint way, then it’s just a waste of time and if as an organisation you have...
  • Licensing with Microsoft could be easier, but the need for everyone to make money and provide options is also key

    I saw Vijay's posting on MS licensing and I have to admit I was quite amazed. 1st off it was a huge rant, it seemed to fail to understand the basics of how businesses make money and finally there was not a good suggestion on how to make it better, except to remove the ways to pay. I will do a reply to the blog later, but first I thought I would offer some insight on licensing. Why does Microsoft sell licenses Microsoft uses licensing to get paid for our products. Customers buy the license if they see the value in the products. If the customer does not see the value, they would not buy. People who say Microsoft should give it away or reduce the price seem to not understand the basic economics of supply and demand - every business, while it may have many goals, ultimately has a responsibility to the investors and this is nearly always to make money. Even when I was treasurer for a charity we needed to make money - it was probably the biggest problem we had, followed by how we deliver the services the charity...
  • Updating to Windows Media Connector V2 and Windows Media Player 11 on Windows Home Server (not supported)

    I've seen a few people asking how to do things like add MP4 support, WM Connector V2 support or even just the media management features of Windows Media V11 to Home Server. Some 3rd party devices only support WM Connector V2 and some people want to do things like stream MP4 files to their Xbox 360. From two articles on the connect forum come the details: I've done some fiddling today and managed to get this working, albeit in a completely unsupported and at-your-own-risk way. Ready for some tinkering? After reading up on various workarounds online, here's what I did: To install Media Player 11: Download wmp11-windowsxp-x86-enu.exe Open this file in an extraction program such as WinZip or 7-Zip (I used 7-Zip ) Extract the wmfdist11.exe and wmp11.exe and place them in separate folders on the C: drive of your WHS (not on a share). (this step was adapted from instructions I was following elsewhere - I'm not certain of the separate folders requirement, but I did it anyway) From the WHS admin desktop...
  • David and others, slightly drunk, speaking poetry on the South Bank

    This is just a silly post, but thought I would share: Of course, not wanting to do it alone, many others also joined in. Did I mention that we were standing on our chairs at a bar under the bridge with a lot of confused people around us? - Matt Brady was very animated in his performance - Stephie shows us that the Scottish have romantic hearts - Danny picked the shortest poem. but picked on people as "characters" - Steve Clayton decided to do a duet with Stephanie who found it all a bit too much
    Filed under: ,
  • re-iterate - Action Pack Office 2007 licenses will not work with Terminal Server and at the moment this will not change

    I'm sorry to be so blunt. I get asked about this quite often, so thought I would write it down. The problem is that the Office 2007 applications will only run in a Terminal Server environment if volume licensing media and a volume license keys are used. Unfortunately the MAPS kit does not include volume licensing media, which means that the Office 2007 can not be used in a TS environment. There are some options on how to move this forward, which are: Acquire the Premium edition of MSDN via the Microsoft Open License Program. http://msdn2.microsoft.com/en-us/subscriptions/aa700832.aspx or For their own business use, Partners could purchase Office 2007 via the Microsoft Open License Program or one of the other volume licensing programs. Some people have commented that the same restrictions were not in place for the beta of Office 2007. It is worth noting that the beta code for Office 2007 software was created without regard to the channels that it will later be sold or distributed in. For this reason, Office...
  • How to read UKSBSGUY (or any other web site) in another language (German, French, Spanish, Italian, Japanese, Chinese, Portuguese and Arabic)

    I saw this and think it is amazing - I know there are already lots of translation services out there, but I like the way things are presented at this site. If you want to do free text or web site translation, have a look at http://translator.live.com/ . Once I'd tested translating a phrase or two (why do I always translate to Arabic??) I thought I would run UKSBSGUY through it. To see the site with just a toolbar to select the language - go to http://translator.start.com//BV.aspx?&MKT=en-GB#http://uksbsguy.com/ . You have a choice of several views - side by side top and bottom original with tooltip translation translated with original text in a tooltip I really like the last option, but play around with them yourself. - translated with English tooltips - English with translated tooltips - Top and bottom - Side by side ttfn David Technorati Tags: Translation , Live
    Filed under: ,
  • VoIP and Unified Communications may be the future, but it has plenty of pitfalls for networks, phone systems and vendors alike

    In many ways I am a traditionalist. I wasn't the 1st to embrace the UC/VoIP and I have to admit that my personal commercial foray into this has so far left me turning off this technology as the sound quality was not there. Apparently my 20mb/768kb line is not good enough with my website on the same line :-( So that is me, but what about others. Information Week showed that network congestion is a growing problem - most of us don't carefully budget network traffic and while we are aware of "slow" internet connections etc, the impact on internal and external network connection is sometime something left to experimentation rather than science. A survey of 576 unified communications users found that 75% said one-quarter of their network traffic in the last three months consisted of UC applications like VoIP, unified messaging, and instant messaging. The survey was conducted by Network General Corp., which polled its worldwide customers. "The ramp-up in unified communications is already taking...
  • Microsoft code name "Acropolis" - Build WPF enabled applications simply with reusable modules, workflow and theming of your application

    I saw this and had to share.  In the samples on the site it includes a RSS reader, Outlook tool and more! Welcome to Acropolis The Microsoft code name “Acropolis” Community Technology Preview is a set of components and tools that make it easier for developers to build and manage modular, business focused, client .NET applications. Acropolis is part of the “.NET Client Futures” wave of releases, our preview of upcoming technologies for Windows client development. Acropolis builds on the rich capabilities of Microsoft Windows and the .NET Framework, including Windows Presentation Foundation (WPF), by providing tools and pre-built components that help developers quickly assemble applications from loosely-coupled parts and services. With Acropolis you will be able to: Quickly create WPF enabled user experiences for your client applications. Build client applications from reusable, connectable, modules that allow you to easily create complex, business-focused applications...
  • New Windows Live suite live - and this is how to install on Windows x64

    I am sure many of you have seen that we launched a new wave of the Live suite (Windows Live Writer - which I am using right now, Messenger, Sign-in Assistant, Family Safety, Mail, Toolbar and Photo Gallery - which also uploaded videos to MSN Soapbox). If you want to more about these cool product, go to http://get.live.com/wl/all where it tells you that this is what you get: Connect Hotmail: Next-generation e-mail on the Web Mail: Multiple e-mail accounts on your desktop Messenger: Connect, share, and make every conversation count Find Search: Say hello to the next generation of search Toolbar: Think outside the search box Gallery: Personalize your Windows Live experience Share Spaces: Your blog, your photos, your social network SkyDrive: Password-protected online storage and sharing Photo Gallery: Edit and share photos and videos Writer: Easily publish pictures, videos, and other rich content to your blog Protect OneCare Family Safety: Help keep your kids safe online Get it together Windows Live Home: Start here...
  • What to do when you get the error "This modification is not allowed because the selection is locked" in Word 2007

    I was contacted by Gerald who had this problem and after a bit of research I found the answer. The text explaining how to do this can be found at http://www.word07.com/locking.htm , however to explain a bit more, here are a few pictures and words. The problem arises when you "group" some text in the developer tab, so the answer is to ungroup it. 1st off, ensure the developer tab is showing by going to the file (round pearl menu button in the top left corner) and selecting the button on the bottom of the menu called "Word Options". This will bring you up a screen as below Now ensure the developer toolbar is enabled with a tick as in the picture Go to the document and find the text that you can't modify Ensure the developer toolbar is displayed and click in the document where the text is and then press the Group button in the toolbar and press the Ungroup option as below That is it - you should now be able to modify the text without any problems. If this does not solve your problem, please...
  • Finding out where something is in Office 2007 and where it was in Office 2003 (Outlook, Word, Excel, PowerPoint and Access)

    I saw this recently and thought I had to blog it - if you know something was there in Office 2003 and now can't find it in Office 2007 then look at these spreadsheets to get some advice. The 1st set of links (ms-help:) will work on a machine with Office 2007 installed and the 2nd set pull the data from the Microsoft Office web site. From the installed help files Outlook ms-help://MS.RIBBON.12.1033/RIBBON/outlookmap.xls Word ms-help://MS.RIBBON.12.1033/RIBBON/wordmap.xls Excel ms-help://MS.RIBBON.12.1033/RIBBON/excelmap.xls PowerPoint ms-help://MS.RIBBON.12.1033/RIBBON/powerpointmap.xls Access ms-help://MS.RIBBON.12.1033/RIBBON/accessmap.xls From the Internet Outlook http://office.microsoft.com/search/redir.aspx?AssetID=AM101954661033&CTT=5&Origin=HA101934281033 Word http://office.microsoft.com/search/redir.aspx?AssetID=AM101938681033&CTT=5&Origin=HA100625841033 Excel http://office.microsoft.com/search/redir.aspx?AssetID=AM101864291033&CTT=5&Origin=HA100860481033 PowerPoint http://office...
  • The Open XML Vote (OOXML) and why I hate politics

    This is a rant and it is my opinion and does not reflect that of Microsoft or others - It is my Opinion! From 1992 to 1995 I had to write document converters - I had to pick apart binary file formats and translate them to another format. It was hard work and I JUST WISHED people would create a largely encompassing standard for documents that was documented so I did not have to do all the work myself. Role forward to today, Office is still the prominent document format (which is now documented on http://msdn.microsoft.com ), but there is a new kid in town that encompass everything that an Office document is and more. This is the Open XML document format. People have cried for years that they wanted the Office Document standard to become more than a defacto standard, they wanted it to become a format an open standard. It was always going to be large, but to cover all the features and functions available in Office, it would have to be. There is no point in the standard being something different to that used in Office...
  • If you want to deploy Exchange 2007 with SBS 2003, how do you remove the Exchange component?

    I posted the other day on adding Exchange 2007 to an SBS 2003 environment , but for some, there is also the desire on how to remove the Exchange component on SBS 2003. Obviously there are the install / uninstall options from the SBS setup screens that can be accessed through add/remove programs, however because SBS has the 1st Exchange server in a group you need to go a bit further. More information can be found on how to remove the first server via http://support.microsoft.com/default.aspx?scid=kb;EN-US;822931 which discusses "How to remove the first Exchange Server 2003 computer from the administrative group". In this KB article it tells you how to: Replicate all public folders to another server Rehome the Offline Address Book folder Change the server that is responsible for generating the Offline Address List Rehome the Schedule+ Free Busy folder Rehome the Organization Forms folder Rehome the Recipient Update Service (RUS) Designate another server to be the routing group master Create another Site...
  • Bad anniversary - 25 years of viruses and malware

    According to the article at MSNBC, 25 years ago a 9th grader let loose a virus on his friends because they didn't like his practical jokes. It was the 1st wild boot sector virus and started a whole industry of security watching. The whole article is worth reading as it discusses the whole business and how it has moved from people wanting to be discovered as the malware was originally designed for notoriety, while now it is more for stealing cash or launching attacks and the writers would rather remain unknown. School prank starts 25 years of security woes First person to ever let loose a personal computer virus was a ninth grader Marcio Jose Sanchez / AP Rich Skrenta poses for a portrait in front of his first personal computer, the Apple II Plus, at home in San Carlos, Calif. Skrenta set loose the first computer virus in 1982 — when he was in ninth grade. NEW YORK - What began as a ninth-grade prank, a way to trick already-suspicious friends who had fallen for his earlier practical jokes, has earned Rich Skrenta...
  • SharePoint User Group Meetings in UK (Newcastle and Reading) in September

    I got this e-mail today from the UK SharePoint User Group. They have two meetings coming up, one in Reading and one in Newcastle. Since SBS includes WSS and you can easily load WSS v3 onto it too, here are the details: Newcastle - 10th September MOSS MVP and general all round nice guy Spencer Harbar will be presenting an evening of goodness for all that attend. Arrive 6:30 for a 7pm start 1st Presentation: MOSS Server Farm Architecture & Design. This session introduces the fundamentals of MOSS Farm design including server roles, topology constraints and design goals which are paramount for delivery of a secure, available and scalable MOSS hosting platform. Each server roles’ unique characteristics will be covered with their associated trade-offs. In addition, three common models will be presented with a discussion of their strengths and weaknesses. 20 minute food and drinks break 2nd Presentatoin: Top 10 Tips for your SharePoint Development Environment. This session will present 10 essential tips, tricks,...
  • Adding Exchange 2007 to an SBS 2003 / Exchange 2003 network

    This question has come up lots of times and the general statement is that it is not trivial. In fact the normal question is can Exchange 2007 be run on an SBS 2003 box. The answer to this is a resounding NO. Exchange 2007 is 64-bit and SBS 2003 is 32-bit and never the twain shall meet. The closest you can get is installing a Windows Server 2003 64-bit system and putting Exchange on it. You will have to buy a Windows Server license, Exchange 2007 license and CALs for each client that uses it. (note if you want Outlook Voice Access then you need Enterprise CALs even if you are only installing Exchange 2007 Standard edition). Once this is done you need to decide if you are going to keep your Exchange 2003 box or forward ports to the new system. If you are keeping both then you also need to be aware of (note this comes from an e-mail from Karan in our support team and should not be considered complete, but a pointer in the right direction): Please note that Exchange 2007 would appear in a different administrative...
« First ... < Previous 20 21 22 23 24 Next > ... Last »

(c)David Overton 2006-23