David Overton's Blog and Discussion Site
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. I specialise in Windows Intune and SBS 2008.
This blog is purely the personal opinions of David Overton. If you can't find the information you were looking for e-mail me at admin@davidoverton.com.

To find out more about my Windows Intune BOOK - Microsoft Windows Intune 2.0: Quickstart Administration click here

To find out more about my SBS 2008 BOOK - Small Business Server 2008, Installation, Migration and Configuration click here

Browse by Tags

David Overton's Blog

Buy my books

Windows Intune:Quickstart Administration


This is the RAW book (Read as Written).
Click here for more information
Buy or pre-order today

SBS 2008 - Installation, Migration and Configuration

Small Business Server 2008 – Installation, Migration, and Configuration

Buy today in book or e-book form

Request a Review Copy

Twitter

Syndication

  • Tech days 2010 – UK, covering Virtualisation, Office 2010, Windows 7, SQL Server 2008 R2, Visual Studio, the Essential Mix, Rich Client and Windows Phone

    Registration for UK Tech Days events from 12 th to 16 th April is open!. UK Tech Days 2010 is a week-long series of free events run by Microsoft and technical communities to celebrate and inspire developers, IT professionals and IT Managers to get more from Microsoft technology.  Our day events in London will cover the latest technology releases including Microsoft Visual Studio 2010, Microsoft Office 2010, Virtualisation, Silverlight, Microsoft Windows 7 and Microsoft SQL Server 2008 R2 plus events focusing on deployment and an IT Manager day. Please visit our website for full details: http://www.microsoft.com/uk/techdays and follow what’s happening @uktechdays   The agenda looks like this: Monday 12th April Tuesday 13th Wednesday 14th Thursday 15th Friday 16th IT Pro Days Virtualization Summit Office 2010 - the next wave Windows 7 - Deployment SQL Server 2008 R2 - The Platform Raising the profile of IT Dev Days Visual Studio 2010 Launch Visual Studio 2010 and .NET The Essential MIX Rich Client Windows Phone   ttfn David Technorati Tags: Virtualisation , Office 2010 , Windows 7 , SQL Server 2008 R2 , Visual Studio , the Essential Mix , Rich Client , Windows Phone
  • Two more SQL 2005 to SQL 2008 issues fixed - Provider=SQLNCLI – Provider cannot be found error and Property Owner is not available for database

    So these are really quick snippets.  I hit an error where my Gateway monitoring software could not connect to the database.  All the errors were along the lines of “Provider cannot be found” and when I looked in the Connection String it stated “Provider=SQLNCLI” which is the SQL Native Client connector software. The fix that worked for me was very simple, to change the “Provider=SQLNCLI …..” to “Provider=SQLNCLI10 …..”.   The second issue was nothing that came about from the SQL 2005 to SQL 2008 conversion, but became an issue when I could not see the properties for the database.  The error I would see was that “Property Owner is not available for database”.  The fix can be found here - http://blog.dampee.be/post/2008/06/22/MSSQL-2005-error-message-quot3bProperty-Owner-is-not-available-for-Database-databaseNamequot3b.aspx .   ttfn David Technorati Tags: Microsoft , SQL Server , SQL Server 2008 , Tips
  • SQL 2005 to SQL 2008 forklift upgrade resulted in 50% cpu utilisation (& resolution) – aka SBS 2003 to SBS 2008 SQL Application Move

    I’ve recently moved the database behind DavidOverton.com (also uksbsguy.com) from a Windows Server 2003 system with SQL 2005 to Windows Server 2008 with SQL 2008.  This would be the same process if you were potentially performing a migration from SBS 2003 with SQL 2005 to SBS 2008 Premium with SQL 2008 (or SQL 2005, but the performance issue only happens with SQL 2008). The process was amazingly simple: Stop the database on the Windows 2003 system Copy the datafiles, errorlogs, logs etc to the new system Install SQL 2008 on the new system, creating an instance by the same name Modify the registry to point to my new files (details here ) Start SQL 2008 Obviously I had to do some IIS stuff (create a new site) and install and redirect my logging software (WhosOn), but overall it went very well. Or so I thought until I noticed that my normally nominal CPU utilisation had gone bananas.  One of the SQL 2008 new and improved features is the Server Activity History which makes it very easy to pinpoint problems, along with the Activity Monitor.  To get the monitor you need to configure the SQL Data Collector (run it twice, once to configure the data warehouse and once to configure the collection process itself).  Then right click on the data collection and chose one of the reports.       Notice the Activity History above shows 50% cpu utilisation when less than 50 people are hitting the website.  This should be a snooze for the system.  I ended up disconnection the web site, my monitoring software and everything else and running a trace with every box ticked.  This gave me a trace output like this: I got around 200,000 lines like this when every process on the system that could access the system was stopped. Wow!  A quick search of the internet talked about corrupt msdb files and then it hit me.  I had lifted all the database files from my SQL 2005 system, including the MSDB files to the SQL 2008 system.  A quick checked showed that the SQL 2008 files were...
  • How to change where SQL Server looks for it’s master datafiles (master.mdf)

    I’ve found myself moving datafiles around or backing up to new locations before enough that I need to change SQL to point to the new locations before it will start for me to do further work.  The process to get it up and running is to find the SQL instance in the registry and change 3 values. The magical location is: “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10. <instance> \MSSQLServer\Parameters” Under here you will file 3 arguments.  Notice the double backslashes “\\” which is required for each single backslash you want.  For example, for my site, I have changed them from the default instance pointers to: "SQLArg0"="-dD:\\databases\\Community Server\\master.mdf" "SQLArg1"="-eD:\\databases\\Community Server\\ERRORLOG" "SQLArg2"="-lD:\\database_logs\\Community Server\\mastlog.ldf" Change these to the location of your datafiles.  The “-d” is for the master database datafile, “–e” for the Error Log and finally “-l” for the log for the master database.   ttfn David Technorati Tags: SQL 2008 , SQL , Microsoft , Microsoft SQL Server , Tips
  • SBS 2008 now available for download on MSDN

    Hi there folks, so following on from my recent post on the fact that SBS 2008 has released to manufacturing (which means it will be in the shops soon), I saw today that SBS 2008 is now available to download from MSDN : I did notice that there is currently a slight mis-print in that it appears there are two disks for the x86 Windows Server 2008 disk, where as the 2nd one is actually the x64 disk (as noted in the ISO number).   It is also worth stating that for SBS 2008, to remove any issues around “Compatibility”, for those applications that are fussy, simply run them on the premium server which is Server 2008, so runs anything that you could run on Server 2008.   Go grab if you can’t wait to get it any other way … note that you only need disk 1 to install, but the rest to understand recovery and Premium solutions.   Thanks David Technorati Tags: SBSC , SBS , Small Business Server 2008 , Small Business , Developer , MSDN , Partners , Microsoft , Download , SBS 2008
  • How long is the grace period on SBS 2008 (how long can you evaluate SBS 2008 without entering a product key)

    I saw this one come up internally and externally, so I thought I would share the answer.  Remember that SBS 2008 is built on Windows Server 2008, Exchange 2007 and SQL 2008 (for the premium edition).  This means that you are bound by the limits of those products.  For SBS Standard this is Windows Server 2008, which is 60 days that can be extended to up to 240 days using the rearm process documented in the KB article http://support.microsoft.com/kb/948472 . SQL2008 has a trial period of 180 days, so if your evaluating SBS 2008 Premium edition you are limited by that.   ttfn   David Technorati Tags: SQL 2008 , Windows Server 2008 , SBS 2008 , SBSC , Partners , Microsoft , Eval , Evaluation , Trial
  • New SQL 2008 training for UK partners

    Hi, I know I’ve been away a lot recently (closing the year end and then doing some travelling for work), but while cleaning my inbox (ohh, 2500 mails processed, replied too, filed and actioned – yee har!) I came across this and it is bang up to date. SQL 2008 is going to be the hot, hot, hot product for a few months, along with how it sits with other BI solutions, such as SharePoint and PerformancePoint. To help you get started, here are some training opportunities : SQL Server 2008 Database Infrastructure and Scalability This three-day training course will help database administrators understand how to exploit the new performance, scalability, manageability and high-availability enhancements introduced in SQL Server 2008. They will also learn how to exploit these capabilities, ensure application scalability and how to manage a database using the new features. Click here Introduction to SQL Server 2008 BI Solution Development This three day course is designed to give developers the confidence to tackle a BI project, and the content is equally relevant to SQL Server 2005 and SQL Server 2008 . This should be attended by developers who are new to the Microsoft BI platform, not those who are familiar with BI development but wish to update their knowledge to SQL Server 2008. Click here Essential SQL Server 2008 Business Intelligence for Developers This two day course is targeted at experienced BI developers (or those who have completed the Introduction to SQL Server 2008 BI Solution Development course above) and wish to learn how to exploit the new features of SQL Server 2008 in their BI applications. Click here Enjoy David Technorati Tags: SQL 2008 , Microsoft , Partners , BI , Business Intelligence , Developers , Training
  • Pricing for SBS 2008 and Essential Business Server 2008 released (US FPP) and public beta for EBS, with public beta for SBS 2008 to follow

    My blog has been quiet recently – think of it as a the quiet before the storm (or I’ve been maxed around quarter and year end business, family and partner visits to the US). Anyway, this has crept up on me before I re-installed my server, so I thought I would just share the love. Microsoft Announces Public Preview and Pricing for Windows Essential Server Solutions Today Microsoft announced the following prices for the Windows Essential Server Solutions family: Windows Small Business Server 2008 Standard Edition software, including five CALs, $1,089 (U.S.); additional CALs $77 each (U.S.) Windows Small Business Server 2008 Premium Edition software, including five CALs, $1,899 (U.S.); additional CALs $189 each (U.S.) Windows Essential Business Server 2008 Standard Edition software, including five CALs, $5,472 (U.S.); additional CALs $81 each (U.S.) Windows Essential Business Server 2008 Premium Edition software, including five CALs, $7,163 (U.S.); additional CALs $195 each (U.S.) We also announced availability of the public beta, which is available here: http://www.MultiplyYourPower.com Since I know this will raise some eyebrows I thought I would jump in early: Yes the price has gone up, but so has the value of what is in the box. In many scenarios, due to the single CAL purchases and reduction in Standard CAL prices, the solution will cost less for a customer than SBS 2003 today The Premium product now has a copy of Windows Server 2008 Standard Edition in it to enable SQL on a 2nd server, Terminal Server solutions and more. The Exchange and management components need to stay on the 1st server You ONLY need a Premium CAL for users who are accessing SQL, so if you don’t access SQL, then you can use the Premium product without having to move to Premium CALs, saving you money Happy to hear more about this – I will be discussing the product at the London and Liverpool group meetings over the next month. ttfn David Technorati Tags: Small Business Server 2008 , SBS 2008 , SBS , SBS 2003 , SBSC , Microsoft
  • We say that Heroes happen with the '2008 products - see what has been registered by heros so far

    I found this great web site where you can see 150 case studies that are presented in the form of a book with stories in it. Some are a bit slim on detail and others are good. You might enjoy reading it - http://www.microsoft.com/heroeshappenhere/portraitgallery/start.aspx ttfn David Technorati Tags: Windows Server 2008 , Visual Studio 2008 , SQL Server 2008 , heroes
  • Microsoft Windows Server 2008, Visual Studio 2008, SQL 2008 Launches - Heroes Are Happening Right {Here} Right {Now} in L.A. (well, it was when I went to the web page)

    The launch is finally upon us. 2 of the 3 products are ready, willing and able to work in your business and the 3rd has just delivered another CTP. In the UK we are looking at press events right now, but we have a customer event on the 19th March. To register you need to go to the virtual launch experience: On the Server blog David Lowe wrote about the event and gave some great pointers to more information on blogs Even if you couldn't make it to LA. yourself, or if you haven't been able to register for one of the other 200+ launch events around the world, check out the Virtual Launch Experience online for an incredibly rich and interactive experience that is almost as good as being here. I'll post further updates later today on some of the launch announcements and cool things that are happening here. In the meantime, you can read our full launch press release on the Server and Tools Business News Bytes blog , and you can read more detail on these announcements on the following blogs: http://blogs.msdn.com/somasegar/ http://blogs.technet.com/mapblog/ http://blogs.msdn.com/applicationplatform/ http://blogs.technet.com/dataplatforminsider/ http://blogs.msdn.com/stevemar/default.aspx ttfn David Technorati Tags: Windows Server 2008 , Visual Studio 2008 and .Net 3.5 , SQL 2008 , Launch
  • Small Business Server 2008 (formally known as Cougar) announcement

    Today is the start of the Server 2008 PR ramp up. I can today tell you a bit more about Cougar, as was, or SBS 2008 as it will be, the new "family" that SBS is part of and a bit more on Windows Essential Business Server 2008 (aka Centro). Hopefully there will be a couple of surprises and also confirmation of some of the rumours around there. I've sliced the press release made today into 3 sections. This blog entry is based on the SBS 2008 section of which there is an extract below of some key points. The whole press release can be found at http://www.microsoft.com/presspass/press/2008/feb08/02-20EBFamilyPR.mspx . Windows Small Business Server 2008 Multiplies Business Growth Windows Small Business Server 2008,previously known by the code name “Cougar,” is ideal for organizations with up to 50 PCs, helping them protect business data, expand business productivity and present a professional image to customers. The new version adds a range of features and capabilities to the current, award-winning Small Business Server 2003 R2 product, and is also an example of Microsoft’s “software plus services” vision. For small-business owners and employees, Small Business Server 2008 provides increased security and protection with one-year trial subscriptions to Microsoft Forefront Security for Exchange Server Small Business Edition and the new Windows Live OneCare for Server, and with dramatically simplified server and PC backup technologies. Small Business Server 2008 also integrates with Microsoft Office Live Small Business to simplify setup and management of professional Web sites and private online work spaces. Enhancements to Remote Web Workplace, integration of Windows SharePoint Services 3.0, and support for the latest Windows Mobile devices will help employees work remotely and collaborate effectively. For IT managers and technology consultants, Small Business Server 2008 deployment, setup and administration is greatly simplified and improved. A powerful administration console, new monitoring across servers...
  • Windows Essential Business Server announcement

    Today is the start of the Server 2008 PR ramp up. I can today tell you a bit more about Cougar, as was, or SBS 2008 as it will be, the new "family" that SBS is part of and a bit more on Windows Essential Business Server 2008 (aka Centro). Hopefully there will be a couple of surprises and also confirmation of some of the rumours around there. I've sliced the press release made today into 3 sections. This blog entry is based on the Essential Business Server 2008 section of which there is an extract below of some key points. The whole press release can be found at http://www.microsoft.com/presspass/press/2008/feb08/02-20EBFamilyPR.mspx . <snipped> Windows Essential Business Server 2008 for Midsize Companies Windows Essential Business Server 2008 is designed for the needs of midsize organizations with up to 250 desktops, helping IT professionals take control of their systems, reduce time spent “fighting fires” and focus more on strategic efforts to drive business growth. The solution includes built-in IT best practices and provides a unified console for management of key workloads and product licensing, which makes IT budgeting and purchase simpler and more predictable. Windows Essential Business Server combines the technologies of Windows Server 2008, Exchange Server 2007, Forefront Security for Exchange Server, System Center Essentials 2007, the next version of Internet Security and Acceleration Server and, in the Premium Edition, SQL Server 2008 technology. The product will be demonstrated on IBM BladeCenter S and HP BladeSystem c-Class c3000 hardware at the “Heroes Happen Here” launch on Feb. 27 in Los Angeles, and is slated for availability in the second half of 2008. <snipped> More information about Windows Essential Server Solutions is available at http://www.microsoft.com/essential and http://www.microsoft.com/presspass/presskits/serversolutions . Now much of this is a repeat of what we already know, but I felt I should share it: Based on x64 technology Capable from 25-250 users, so does...
  • "Windows Essential Server Solutions family of products" announcement

    Today is the start of the Server 2008 PR ramp up. I can today tell you a bit more about Cougar, as was, or SBS 2008 as it will be, the new "family" that SBS is part of and a bit more on Windows Essential Business Server 2008 (aka Centro). Hopefully there will be a couple of surprises and also confirmation of some of the rumours around there. I've sliced the press release made today into 3 sections. This blog entry is based on the "family" section of which there is an extract below of some key points. The whole press release can be found at http://www.microsoft.com/presspass/press/2008/feb08/02-20EBFamilyPR.mspx . To help small and midsize organizations improve business efficiency, increase productivity and drive growth, Microsoft Corp. introduced the Windows Essential Server Solutions family of products, built on Windows Server 2008 and the newest Microsoft server technologies and services. The company also unveiled details about the newly named Windows Small Business Server 2008. The Windows Essential Server Solutions family includes Windows Small Business Server 2008 and Windows Essential Business Server 2008 for midsize companies. Microsoft conducted extensive research and gathered in-depth feedback worldwide to design the solutions, in order to meet the unique needs of small and midsize customers and partners. The products integrate the technologies of Windows Server 2008, Microsoft Exchange Server 2007, and other Microsoft products and services into all-in-one solutions that are reliable, easy to manage and able to grow with customers. “There are 31.9 million small businesses and 1.2 million midsize companies worldwide in need of powerful IT solutions, * and they typically have very small IT staffs, or none at all,” said Bob Kelly, corporate vice president at Microsoft. “Windows Essential Server Solutions make the benefits of enterprise-class IT accessible, affordable and simpler for smaller organizations and their technology advisors.” Windows Small Business Server 2008 Multiplies Business...
  • Microsoft Gets Gartner's Business Intelligence Top Ranking -- Business Intelligence

    Remember that BI starts with data in Excel and then includes SQL and builds from there. One of the nice things is that BI is now accessible to any business that wants to analyse their business. Now all that is needed is the understanding of what questions do I want to ask and what data do I have that can help me!! Microsoft Gets Gartner's Business Intelligence Top Ranking The company makes a surprise leap ahead of Business Objects and Cognos in its ability to execute on BI products and pricing. Business Objects and Cognos have long been considered the leaders in business intelligence platforms. But in a surprising new report, Gartner ranks Microsoft ahead of those companies in its ability to execute. Gartner's "magic quadrants" are typically annual market evaluations that place software vendors in one of four quadrants within a square: niche players, visionaries, challengers, and leaders. Specific placement within a quadrant depends on a vendor's ability to execute, which moves them upward, and completeness of vision, which moves them to the right. Business Objects, Cognos, and Microsoft were placed among the leaders in Gartner's just-released Magic Quadrant for Business Intelligence Platforms, 2008. But the research firm placed Microsoft above the other two in its ability to execute, including the competitiveness and success of its BI goods and services, its viability and investment in BI, and the execution of its sales and pricing. In last year's BI platform report, Gartner put Microsoft in the challenger quadrant. Business Objects and Cognos slightly outranked Microsoft in completeness of vision, which includes such things as market understanding, sales strategy, and product development and delivery strategy. By placing the world's largest vendor of commodity software as one of the BI market leaders, Gartner is demonstrating how quickly BI is moving from a specialized, expensive technology into a commodity itself. The rapidly commoditizing BI market, many industry observers believe...
  • Register Now for the Windows Server 2008, Visual Studio 2008 and SQL Server 2008 UK Launch Event

    I saw this in the Technet newsletter and thought I would pass it on: The launch of Windows Server 2008, SQL Server 2008 and Visual Studio 2008 is drawing near and we are pleased to announce the three main launch activities to help you learn more: 1) The main launch event on 19 March at the ICC Birmingham - register now 2) The TechNet and MSDN Roadshows in April and May - pre-register now 3) The Virtual Launch Experience also on 19 March - pre register now ttfn David Technorati Tags: Events , Windows Server 2008 , SQL Server 2008 , Visual Studio 2008 , Launch
  • 2008 Pre-Launch event with Bill Gates - Scott Dodds and why Partners are important

    Technorati Tags: Events , Windows Server 2008 , SQL Server 2008 , Visual Studio 2008 , Launch , Scott Dodds I will try to publish information from each presenter as I noted it from the audience and then my scribbled notes. I can't guarantee 100% accuracy, but the virtual even should show more of this information and the Partner Portal will have the presentations on them in a weeks time. So... here goes: Microsoft rarely does a launch even for it's partners 2 months before the "big event". It is normally the night before. Scott re-iterated that partners are "extremely important" to Microsoft as they are the feet on the ground talking to customers. If partners have not seen / heard all the messages, technology, plans then how can they participate and recommend to customers? It is also worth noting that we do not have a "Bill Gates" for the customer events - his insight was reserved for our partners! Scott kicked off the day by suggesting that there were 4 areas we were concentrating on (more on these in coming posts): Secure Trusted Platform Virtualisation Next Generation Web Business Intelligence As far as participation goes - there are many ways a partner can participate as highlighted in another blog post, however it will include the new social network community work the UK Partner Team have put together where you can form your own communities as a partner. Scott showed the new roadmap information and forums / blogs / status information available. Scott also pointed out (scarily) that the BBC had access to the event as they were following Bill's last year. Sure enough three small business partners were caught and asked to comment!! ttfn David Technorati Tags: Events , Windows Server 2008 , SQL Server 2008 , Visual Studio 2008 , Launch , Scott Dodds
  • Heroes Happen Here - Where are you?

    If you don't know about the Heroes Happen Here :: Home campaign then you are very much behind the times. The Launch events for SQL Server 2008 (errrm), Visual Studio 2008 and Windows Server 2008 are fast approaching and so is your customers ability to buy and use them - do you understand what, why and when? If not, go to the website and see how your customers can benefit and why you should learn more about the product and what you can do to improve your business with these products. ttfn David Technorati Tags: Heroes happen here , Heroes happen {here} , Heroes , Windows Server 2008 , SQL Server 2008 , Visual Studio 2008
  • How to get Windows Desktop Search, SharePoint, Windows Home Server, Search Server, Exchange 2007 and SQL 2005/2008 to see Office 2007 documents in their search filters

    If you use Windows XP and need WDS to index Office 2007 files, or SharePoint, Search Server or any other product that used IFilters then this is the KB article and download for you. This obviously includes Windows Home Server which uses WDS to enable you to quickly search for a file on a file share from Vista This download will install and register IFilters with the Windows Indexing Service. These IFilters are used by Microsoft Search products to index the contents of specific document formats. This Filter Pack includes IFilters for the following formats: .docx, .docm, .pptx, .pptm, .xlsx, .xlsm, .xlsb, .zip, .one, .vdx, .vsd, .vss, .vst, .vdx, .vsx, and .vtx. Because Windows Desktop Search (WDS) consumes IFilters from Windows Indexing Service, the IFilters will be automatically registered and available for use by WDS. To register these IFilters with a specific Search product, please see the associated KB article below: Office SharePoint Server 2007 - Office SharePoint Server 2007 registration steps Search Server 2008 - Search Server 2008 registration steps SharePoint Portal Server 2003 - SharePoint Portal Server 2003 registration steps Windows SharePoint Services v3.0 - Windows SharePoint Services v3.0 registration steps Exchange Server 2007 - Exchange Server 2007 registration steps SQL Server 2005 - SQL Server 2005 registration steps SQL Server 2008 - SQL Server 2008 registration steps Download details: Microsoft Filter Pack ttfn David Technorati Tags: Windows Home Server , Windows Desktop Search , SharePoint , Windows SharePoint Services , SharePoint Portal Server 2007 , Exchange 2007 , SQL Server , SQL Server 2008 , SQL Server 2005 , Search Server Express Edition 2008
  • Want to make life easier developing databases apps against SQL, XML and other databases (Oracle, MySQL, PostgreSQL) - look at the Beginning LINQ development articles

    LINQ looks like another amazingly simple move for app developers (I've written a few DB apps myself over the years). While Microsoft provides support for Objects, SQL and XML, others provide for other platforms such as Oracle, MySQL and PostgreSQL ( http://code2code.net/DB_Linq/ ). The reason why it is so nice is because the gap between the process of writing SQL queries and then programming them into your code is considerably removed. For example, a query might now look like: var q = from p in db.Products where p.ProductName == "Pen" select p.ProductID; I think that looks very much like a SQL query, which is really good for developers and database peeps alike, especially since the underlying execution is very efficient. To make understanding all this easier there has been a number of articles written including... Beginning LINQ development, Part 1 Brian Eastwood, Site Editor The Language Integrated Query, or LINQ, is one of the most important of the new features afoot in VB 9.0 and C# 3.0.Developers can use LINQ to query to data sources like ADO.NET, SQL and XML. The idea, of course, is that data queries are now an integrated part of Visual Basic and C# and an immeasurable improvement over data integration in the days of preprocessors. LINQ first emerged at PDC 2005, and though it is intended for the next version of Visual Studio, code-named "Orcas," LINQ is available for use with Visual Studio 2005 . A good starting point for learning more about LINQ is Hooked on LINQ , a wiki for anyone interested in dipping his toe in the water. Among the site's resources are "five-minute overviews" of using LINQ with objects, SQL and XML. For more on LINQ-to-SQL queries, which were previously called DLINQ queries, check out the Scott Guthrie post Understanding LINQ to SQL Query Translations . (Guthrie is the head of ASP.NET development at Microsoft.) Here you can find hints for working with stored procedures, Where clauses and mathematics functions. Beginning LINQ development, Part 1 and...
  • SQL Server Web casts (Preparing for SQL Server 2008, New T-SQL features, migrating from Access, Policy based management framework, BI, certifications, reducing hardware and maintenance costs)

    From the TRM Blog at November 2007 - Technical Rollup Mail - SQL SQL 2005 Webcasts and Virtual Labs SQL Server 2005 is data management and analysis software that delivers enhanced security, availability, and scalability to mission-critical data applications—while making them easier to develop, deploy, and manage. Choose from a wide range of live and on-demand webcasts. Or take part in a virtual lab, which allows you to cut your teeth on the new platform by experimenting with its different capabilities. SQL Server 2005 Webcasts TechNet Webcast: Prepare Yourself for Windows Server 2008 (Part 1 of 8): Product Workload Scenarios (Level 300) – Monday, December 03, 2007 9:30 AM Pacific Time (US & Canada) In this first session of our series, we discuss how Windows Server 2008 addresses key deployment scenarios for customers. We start with an overview of the key product workload scenarios for Windows Server 2008. We cover as many as 10 different scenarios, and we discuss how each scenario can be categorized into one of three different design pillars. While examining the scenarios, we take a closer look at the specific technologies used within the scenario, describe how they are used, and explain why they are needed. We show which technologies comprise each scenario and the value propositions they deliver. Finally, we see how the scenario adds value to Windows Server 2008 and, in some cases, we provide real-world examples of usages for the scenario. TechNet Webcast: Prepare Yourself for Windows Server 2008 (Part 1 of 8): Product Workload Scenarios (Level 300) MSDN Webcast: New T-SQL Programmability Features in SQL Server 2008 (Level 300) – Tuesday, December 04, 2007 1:00 PM Pacific Time (US & Canada) Join this webcast on new T-SQL programmability features in Microsoft SQL Server 2008, an extension from last year's presentation on top Microsoft SQL Server 2005 T-SQL features. We cover exciting new features such as: New data types (i.e. date/time, filestream, HierarchyID, large UDT, sparse columns) Dependency management...
  • SQL Server Downloads (CTPs - Synchronization Services for ADO.NET, VS 2005 Support for SQL Server 2008, Configuration Manager config packs, Assessment packs for HIPPA, European Union Data Protection Directive (EUDPD), SOX, GLBA, FSMA, ReportViewer samples,

    From the TRM Blog at November 2007 - Technical Rollup Mail - SQL Microsoft Synchronization Services for ADO.NET v2.0 CTP1 Microsoft Synchronization Services for ADO.NET provides the ability to synchronize data from disparate sources over two-tier, N-tier, and service-based architectures. Rather than simply replicating a database and its schema, the Synchronization Services application programming interface (API) provides a set of components to synchronize data between data services and a local store. Applications are increasingly used on mobile clients, such as laptops and devices, that do not have a consistent or reliable network connection to a central server. It is crucial for these applications to work against a local copy of data on the client. Equally important is the need to synchronize the local copy of the data with a central server when a network connection is available. The Synchronization Services API, which is modeled after the ADO.NET data access APIs, gives you an intuitive way to synchronize data. It makes building applications for occasionally connected environments a logical extension of building applications where you can count on a consistent network connection. http://www.microsoft.com/downloads/details.aspx?FamilyID=147c41a9-69f0-496e-b095-dbc5cffd6285&DisplayLang=en Visual Studio 2005 Support for SQL Server 2008, Community Technology Preview This CTP resolves a problem that when you try to open a database connection to SQL Server 2008 by using Visual Studio 2005 design tools, you may receive the following error message: “This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.” This CTP addresses this issue, and enables the following Visual Studio functionality for SQL Server 2008 CTP5 : Server Explorer successfully connects to SQL Server 2008, and database objects such as stored procedures and table data can be viewed and edited. Note that table schemas still cannot be viewed or edited in this release. SQL CLR projects that target SQL Server 2008...
  • SQL Server documentation (Reporting Services, XML in 2008, Spatial Data, Security for DBAs, Consolidation, Synchronisation, Compact Edition books, Scale out Analysis Services)

    From the TRM Blog at November 2007 - Technical Rollup Mail - SQL Reporting Services in SQL Server 2008 Microsoft SQL Server 2008 Reporting Services provides a complete server-based platform that is designed to support a wide variety of reporting needs including managed enterprise reporting, ad-hoc reporting, embedded reporting, and web based reporting to enable organizations to deliver relevant information where needed across the entire enterprise. Reporting Services 2008 provides the tools and features necessary to author a variety of richly formatted reports from a wide range of data sources and provides a comprehensive set of familiar tools used to manage and secure an enterprise reporting solution. Reports are processed and delivered quickly and effectively, enabling users to either receive reports automatically through subscriptions, to access reports from a central report repository on an ad-hoc basis, or to consume reports in context of their business processes through reports directly embedded into their business or web applications. http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_ssrs.mspx What's New for XML in SQL Server 2008 Microsoft introduced XML-related capabilities in Microsoft SQL Server 2000 with the FOR XML and OPENXML Transact-SQL keywords, which enabled developers to write Transact-SQL code to retrieve a query result as a stream of XML, and to shred an XML document into a rowset. SQL Server 2005 extended these XML capabilities significantly with the introduction of a native xml data type that supports XSD schema validation, XQuery-based operations, and XML indexing. SQL Server 2008 builds on the XML capabilities of previous releases and provides enhancements to meet the challenges that customers have faced when storing and manipulating XML data in the database. http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_xml.mspx Managing Unstructured Data with SQL Server 2008 The proliferation of digital content has significant implications for the way in which organizations store...
  • MSDN Evaluation Center for Office system, Biztalk, SQL Server 2005/2008 and Windows Server 2008

    I just found the MSDN Evaluation Center online today to give you evaluation resources that you might develop against. These include BizTalk Server, Office Communication Server, Office Enterprise , SharePoint Server, SharePoint Designer, SQL Server 2005, 2008, Express 2005 SP2, Windows Server 2008. I've pasted much of the content, but all the download links etc are country specific, so I have removed those. Click on the link above to get to download this stuff! MSDN Evaluation Centre Welcome to the MSDN Evaluation Centre, the central location for all Microsoft developer product trials and beta evaluations. Try a product before you buy it or test the latest beta to see what is in store for the next release. Start at the beginning of the evaluation process and follow the new products as they go through to the final releases. Remember to check back often as new products will be added as they become available. As you evaluate your software, we'll provide you with comprehensive and relevant insights and information delivered to your inbox. Resources like: Webcasts | Virtual Labs | Community insight | White papers| E-Learning | Events Featured Evaluations BizTalk Server BizTalk 2006 R2 Regardless of the size of your organization, you need best-in class infrastructure. BizTalk Server 2006 R2 delivers enterprise-class infrastructure that enables you to connect .NET applications and infrastructure with your non .NET applications and platforms, as well as those of your partners. Office system Microsoft Office Communications Server 2007 Microsoft’s unified communications platform enables developers to efficiently build secure, productivity enhancing applications on top of an extensible software foundation. Microsoft Office Enterprise 2007 Microsoft Office Enterprise 2007 provides a comprehensive suite of applications that developers can extend to deliver solutions that make data and processes more accessible and relevant to users. With Office Enterprise 2007 you can build solutions that give users the power to collaborate...
  • Microsoft Releases Another SQL Server 2008 CTP

    I've seen plenty of blog entries saying this has not yet shipped, but I've just been to the download site and SQL Server 2008, November CTP is definitely there: http://www.microsoft.com/downloads/details.aspx?FamilyId=3BF4C5CA-B905-4EBC-8901-1D4C1D1DA884&displaylang=en There are several people talking about it, such as SQL 2008 CTP5 First Glance , however perhaps the best item I saw was from Steve Lamb who was offering " Would you like with free technical support to help you deploy Windows Server 2008, System Center ". I think that would be a yes :-) Microsoft Releases Another SQL Server 2008 CTP This third update includes compatibility with Windows Vista and the upcoming Windows Server 2008. "SQL Server 2008 running on Windows Server 2008 provides customers with trusted and secure access, high availability through revamped failover clustering, and simplified scripting through Powershell," Francois Ajenstat, director of product management for SQL Server, told eWEEK here at the TechEd IT Forum conference, which starts Nov. 12. This latest CTP, which Ajenstat likens to a traditional second beta, has a lot of substance and new features, he said, noting that the SQL team is targeting one more CTP prior to the product's launch in late February 2008. This latest update to the software also brings with it new features, such as a resource governor, which enables users to define resource limits and priorities for different workloads to ensure predictable performance, and backup compression, which requires less storage to keep backups online and which runs significantly faster since less disk I/O is required, he said. Another new feature, transparent data encryption, enables the encryption of an entire database, data files and log files without the need for application changes. "Encryption enables organizations to meet the demands of regulatory compliance and overall concern for data privacy," Ajenstat said. Also included are new cube design tools to help users streamline the development...
  • SQL Server 2008 info (Data Warehousing, magic quadrant positioning and SQL 2005 benchmarks)

    This is an extract from the TRM blog which can be found here http://blogs.technet.com/trm/ . I have removed the KB article list and some items which I don't think are relevant to small business / ISV partners, however the full info can be found on the blog page too News SQL Server 2008 Solutions – Your Data, Any Place, Any Time Microsoft SQL Server 2008 provides a trusted, productive, and intelligent data platform that enables you to run your most demanding mission critical applications, reduce time and cost of development and management of applications, and deliver actionable insight to your entire organization. http://www.microsoft.com/sql/2008/default.mspx http://download.microsoft.com/download/B/F/2/BF24C54E-5635-4C79-AFB4-0C3F840E79F4/SQLServer2008_Datasheet_Final.pdf SQL Server 2008 Solutions – Redefining Pervasive Insight SQL Server 2008 Business Intelligence platform provides a scalable BI platform optimized for data integration, reporting, and analysis enabling organizations to deliver intelligence where users want it. Delivering on the data platform vision, Microsoft continues to invest in and evolve pervasive insight which allows customers to deliver real-time insight broadly and deeply within their organizations, with rich and personalized data experiences. Spend 10 minutes with Tom Casey, General Manager, Microsoft SQL Server to learn about how SQL Server 2008 delivers pervasive insight across the organization. http://www.microsoft.com/sql/2008/solutions/bi.mspx http://www.microsoft.com/sql/2008/bi/index.html SQL Server 2008 Reporting Services – Delivering Relevant Information across the Enterprise Microsoft® SQL Server™ 2008 Reporting Services provides a complete server-based platform designed to support and the entire enterprise reporting lifecycle enabling organizations to deliver relevant information where needed across the entire enterprise. http://www.microsoft.com/sql/2008/technologies/reporting.mspx Microsoft Is Positioned in Leaders Quadrant of Latest Magic Quadrant for Data Warehousing ...
  • SQL Server November Events and Webcasts (Data mining, spatial applications, performance tuning, reporting, overview and troubleshooting)

    This is an extract from the TRM blog which can be found here http://blogs.technet.com/trm/ . I have removed the KB article list and some items which I don't think are relevant to small business / ISV partners, however the full info can be found on the blog page too Events / WebCasts SQL 2005 Webcasts and Virtual Labs SQL Server 2005 is data management and analysis software that delivers enhanced security, availability, and scalability to mission-critical data applications—while making them easier to develop, deploy, and manage. Choose from a wide range of live and on-demand webcasts. Or take part in a virtual lab, which allows you to cut your teeth on the new platform by experimenting with its different capabilities. SQL Server 2005 Webcasts TechNet Webcast: Deliver Actionable Insight Throughout Your Organization with Data Mining (Part 1 of 3): Your First Project with SQL Server Data Mining (Level 200) – Thursday, November 01, 2007 8:00 AM Pacific Time (US & Canada) Many users are intrigued and excited to see data mining available in the Microsoft SQL Server product, but many don't know how to start using these features. In this webcast, we lead you through the first steps to success for your data mining projects. We look at the overall architecture of data mining and the kinds of problems that can be solved. We also look at important points for your first project, such as choosing the right algorithms and testing your mining models. TechNet Webcast: Deliver Actionable Insight Throughout Your Organization with Data Mining (Part 1 of 3): Your First Project with SQL Server Data Mining (Level 200) MSDN Webcast: Building Spatial Applications with SQL Server 2008 (Level 300) – Thursday, November 01, 2007 9:00 AM Pacific Time (US & Canada) Microsoft SQL Server 2008 delivers new spatial data types that enable you to consume, use, and extend location-based data through spatial-enabled applications. Attend this webcast to learn how to use spatial functionality in next version of SQL Server to build and optimize...
  • SQL Server 2008 new documentation (Overviews, development, OLTP, tuning for 2000/2005, SOA, Oracle and Sybase migration) and downloads (JDBC, PHP)

    This is an extract from the TRM blog which can be found here http://blogs.technet.com/trm/ . I have removed the KB article list and some items which I don't think are relevant to small business / ISV partners, however the full info can be found on the blog page too Documents SQL Server 2008 Product Overview For organizations to be successful and thrive in today’s world of data, they need a vision that addresses key data trends. The data platform vision of Microsoft helps organizations meet these data explosion needs and the next generation of data-driven applications. Microsoft will continue to invest in and evolve the following key areas to support their data platform vision: mission-critical enterprise data platform, dynamic development, relational data, and business intelligence. Read this paper to learn about the Microsoft Data Platform Vision and how SQL Server 2008 meets the needs of the next generation of data-driven applications. http://www.microsoft.com/sql/techinfo/whitepapers/sql2008Overview.mspx Business Intelligence in SQL Server 2008 Microsoft SQL Server 2008 makes business intelligence (BI) available to everyone through deep integration with Microsoft Office, providing the right tool, to the right user, at the right price. The result is that employees at all levels of an organization can see and help to influence the performance of the business by working with tools that are both easy to use and powerful. Integration with the 2007 Microsoft Office System enables users to view business performance in a way that they understand and which feels comfortable; and the introduction of PerformancePoint Server 2007, helps customers to gain actionable insight into the entire organization so they can monitor, analyze, and plan their businesses, as well as drive alignment, accountability, and actionable insight across the entire organization. http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_bi.mspx Microsoft SQL Server 2008 and Microsoft Data Platform Development Microsoft SQL Server 2008 and the...
  • SQL 2008 Information, documents and more

    SQL Server 2008 Solutions – Your Data, Any Place, Any Time SQL Server 2008, the next release of Microsoft SQL Server, will provide a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications, while enabling developers to create new applications that can store and consume any type of data on any device, and enabling all your users to make informed decisions with relevant insights. http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx http://www.microsoft.com/sql/prodinfo/futureversion/bi/default.mspx SQL Server 2008 Books Online – Overview (SQL Server 2008) Microsoft SQL Server is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data integration, analysis, and reporting solutions. http://technet.microsoft.com/en-us/library/ms166352(SQL.100).aspx http://technet.microsoft.com/en-us/library/bb510421(SQL.100).aspx Online Transaction Processing in SQL Server 2008 Microsoft SQL Server 2008 provides a database platform that is optimized for today’s applications, and that can scale for any size of business. It drives cost-efficiencies by dramatically reducing downtime and enabling dynamic and proactive management that significantly reduces administrative overhead. Finally, SQL Server 2008 provides a highly secure platform that you can trust with your organization’s sensitive, business-critical data. http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_oltp.mspx Business Intelligence in SQL Server 2008 Microsoft SQL Server 2008 makes business intelligence available to everyone through deep integration with Microsoft Office, providing the right tool, to the right user, at the right price. The result is that employees at all levels of an organization can see and help to influence the performance of the business by working with tools that are both easy to use and powerful. Integration with the 2007 Microsoft Office System enables...

(c)David Overton 2006-13