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

  • 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
  • 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
  • Microsoft SQL Server Data Services - more online services announced this week

    This is one big week for developers (as Mix was always going to be). We now also have data services in the cloud ( http://www.microsoft.com/sql/dataservices/default.mspx ) On-demand Scalability SQL Server Data Services (SSDS) are highly scalable, on-demand data storage and query processing web services. Businesses use storage resources as needed transforming large upfront capital and operations expenditures into much smaller on-demand costs. On-demand storage and access Store and query your data virtually any time, anywhere on the web. Use and pay for storage resources as you go. Scales easily as your data grows Take advantage of virtually no restriction on the amount of data stored. Use the same service interfaces for your storage needs at any scale. Easy to manage Easy to use web-based service for provisioning, deployment, and monitoring. Lights-out manageability and commodity hardware for lowest service cost. Business-ready SLA SQL Server Data Services are built using robust Microsoft SQL Server database technologies and will provide strong service level agreement (SLA) covering high availability, performance, and protection against data loss. Built using enterprise-class SQL Server Database technology as a storage node Industry Standard SQL Server and Windows server technologies. Years of experience running these technologies in-house. Novel distributed data fabric for massive scale out operation. Richer functionality exposed over time based on feedback from business customers. High availability, security, and performance Store and manage multiple copies of the data for reliability. Back up data stored in each data cluster. Geo-redundant data copies to ensure business continuity. Secure data access to help provide business confidentiality and privacy. Input/output (I/O) are optimized for high throughput. Application Agility SQL Server Data Services supports simple web-programming interfaces like SOAP and REST for quick provisioning of web applications. Developers can focus on innovating with data while reducing...
  • 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
  • Answers to some of the questions about SBS 2008 (32-bit 2nd server, SCE, beta upgrades, migrating users

    [updated 23rd Feb 2008] After posting on SBS 2008 the other day I've had a few questions, so here are some answers Can the 2nd server be x64 or x86 (32-bit) and can it be used for Terminal Services / Hyper-V / a.n.other purpose The 2nd server can be 32 or 64-bit. It is essentially Windows Server 2008 Standard edition, however it does check it is part of a SBS domain. Therefore it can be used for almost anything a Windows Server can be used for (and SQL can be loaded on it too) Why was System Center Essentials removed from SBS 2008 The short answer is that this was not the right product for SBS owners, however SBS can be used / works with SCE. For this reason SCE can, for example, be loaded on the the 2nd server Can I install SBS 2008 beta (cougar) in my production environment and upgrade to RTM when it releases The answer here is one about the fact that betas are betas and have bugs, so there are risks. Officially the answer is “don’t consider using Cougar beta in your production environment unless you are on the TAP as any problems / migration / upgrades will be unsupported. Should you do so, your only access to any support and guidance will be via the newsgroups” If someone has recently purchased hardware for SBS 2003, can they move to SBS 2008 SBS 2008 has migration wizards that will enable the move from one machine to another. For those where they wish to use existing hardware there is NO in-place upgrade, however you should be able to do the following (assuming the hardware is x64 capable): 1) Copy their existing setup to a virtual machine 2) Install SBS 2008 onto the original hardware and use the migration tools to move SBS to the same box or 1) Backup their SBS 2003 system 2) Install SBS 2008 on the existing hardware 3) Add data back from backup (this is a manual process) Can SBS 2008 be used with Hyper-V Yes, we’re in the process of testing which virtualization scenarios SBS 2008 and EBS 2008 will support, and will provide more information in the future. Can SBS 2003 CALs be used with SBS 2008 No, SBS...
  • Microsoft Windows Essential Server Solutions - Which one is right for you?

    There is lots of information on how to choose the right Essential solution for you (SBS Std, Premium, EBS Std or Premium. A quick sample can be seen below (there is much more on the web site): Which Solution Is Right for You? Learn how the Windows Essential Server Solutions are designed to fit specific needs for small and midsize business. Find which solution will be the right choice for you and your company’s needs. Remember, each business is unique – consult your Microsoft Certified Partner to help determine the best solution for you. Your Need Windows Small Business Server 2008 Windows Essential Business Server 2008 Standard Edition Premium Edition Standard Edition Premium Edition Company Size and Growth Our company needs a secure network for 250 or fewer users today Microsoft Windows Small Business Server 2008 supports up to 50 users or devices. Microsoft Windows Essential Business Server 2008 supports up to 250 users or devices. Our business is growing at a fast pace and our IT needs are expanding. As your business needs change, these products provide a “technology building block” for additional servers and a seamless transition to the full line of Microsoft Server products, using Transition Packs. We recommend you decide based on your 1-yr and 2-yr growth plans, as well as on your current and future application and performance needs. We are acquiring other companies and need to connect with their data and email immediately until we can incorporate everything into our server network. The Windows Essential Server Solutions products are meant to be the primary network and email system and not a down-level branch office or subsidiary solution. ttfn David Technorati Tags: Small Business , Small Business Server 2008 , SBS 2008 , Windows Small Business Server 2008 , SBSC , Microsoft , Partner , Community
  • 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 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 Security and SQL on Vista / Windows Server 2008

    Security Tip of the Month: User Account Control and SQL Server http://go.microsoft.com/?linkid=7243604 By Devendra Tiwari, Microsoft SQL Server Product Team User Account Control (UAC), a new feature in Windows Vista that helps administrators manage their use of elevated privileges, affects Microsoft SQL Server in terms of connectivity (SQL Server login) and in limiting access to resources on the administrators' access control list (ACL). This article discusses the impact of UAC on SQL Server and presents tips on how to run SQL Server applications securely in Windows Vista and Windows Server 2008. SQL Server 2005 Security Overview for Database Administrators http://go.microsoft.com/?linkid=7243606 This paper covers some of the most important new security features in SQL Server 2005. It tells you how, as an administrator, you can install SQL Server securely and keep it that way even as applications and users make use of the data stored within. Security Considerations for SQL Server http://go.microsoft.com/?linkid=7243607 SQL Server 2005 includes a variety of highly precise, configurable security features that can empower administrators to implement defense-in-depth that is optimized for the specific security risks of their environment. Access guidance about password policy, surface-area configuration, credentials, authenticators, and more. Security Considerations for Databases and Database Applications http://go.microsoft.com/?linkid=7243608 The SQL Server 2005 Database Engine helps you protect data from unauthorized disclosure and tampering. Learn about highly granular authentication, authorization, and validation mechanisms; strong encryption; security context switching and impersonation; and integrated key management. SQL Server 2005 Security Best Practices: Operational and Administrative Tasks http://go.microsoft.com/?linkid=7243609 This white paper covers some of the operational and administrative tasks associated with SQL Server 2005 security and lists best practices and operational and administrative tasks...
  • 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...
  • 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) Microsoft SQL Server 2008, code name "Katmai," introduces a significant amount of new or improved functionality, including new data types, in addition to performance and security enhancements. In this webcast, we discuss how you can easily take advantage of the new functionality available in SQL Server 2008 within your application development. MSDN Webcast: Programming SQL Server 2008 (Level 300) MSDN Webcast: Framework Masterclass: LINQ to Entities (Level 200) – Monday, September 24, 2007 12:00 PM Pacific Time (US & Canada) In other sessions, we explored how Microsoft .NET Language Integrated Query (LINQ) is used for Structured Query Language (SQL) databases and working with XML. In this webcast, we connect to the data access layer, the business objects that provide the functionality of working with enterprise data. Join us to learn how you can make your LINQ applications really sing when working with entities. MSDN Webcast: Framework Masterclass: LINQ to Entities (Level 200) 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
  • SQL 2005 & 2008 webcasts, recovery tips, developer tools, best practices, Silverlight development and more

    As you know SQL 2005 has been released and we are already seeing SQL 2008 on the horizon. To keep up to date and step into the future the following should be able to help with understand the products, finding information about solutions using them and developing solutions using them, SQL Server 2005 SQL Server Premier Field Engineers Deliver SoundBytes The UK SQL Server PFE team is preparing a series of SQL Server SoundBytes aimed to deliver proactive content to our Premier customers via LiveMeeting. Premier SoundByte sessions will be ideal for customers who need proactive information, for whom it may not be convenient to leave the office to come to a workshop. These sessions are set to run from the beginning of September 2007 through to the end of December 2007 and will range from Clustering a SQL Server 2005 Database System, to Database Mirroring, Configuration Best Practices through to SQL Server in a SAN Environment, Corruption / Detection and Recovery of a SQL Server 2005 System. Please contact your TAM if you are interested in attending a SoundByte Session and they will arrange your attendance for the specific topic, agenda and date / time. For more information regarding these SQL Server 2005 SoundBytes, checkout the UK SQL Server Premier Blogsite : http://sqlblogcasts.com/blogs/thepremiers/ SQL Server 2005 Books Online (May 2007) Download an updated version of Books Online for Microsoft SQL Server 2005. Books Online is the primary documentation for SQL Server 2005. The May 2007 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to "New and Updated Books Online Topics" for a list of topics that are new or updated in this version. Topics with significant updates have a Change History table at the bottom of the topic that summarizes the changes. Beginning with the February 2007 update, SQL Server 2005 Books Online reflects product upgrades included in SQL Server 2005 Service Pack 2 (SP2). http://www.microsoft...
  • MicrosoftBlog.com » Windows Server 2008, Visual Studio 2008 and SQL Server 2008 to Launch on February 27, 2008

    Just a FYI, 6 days after my birthday Microsoft launch another storming set of products. Microsoft announced at its partner conference on July 10 that it will launch Windows Server 2008, Visual Studio 2008 and SQL Server 2008 together in a single launch on February 27, 2008, in Los Angeles. MicrosoftBlog.com » Windows Server 2008, Visual Studio 2008 and SQL Server 2008 to Launch on February 27, 2008 ttfn David Technorati Tags: Windows Server 2008 , Visual Studio , SQL Server 2008 , release date
  • SBS 2003 R2 Premium Edition, Downgrade options, including SQL 2005 to SQL 2000 - for a limited time only

    In a recent announcement we now offer the ability to downgrade the Premium technologies in R2. More information can be found at http://www.microsoft.com/windowsserver2003/sbs/downgrade/default.mspx with a FAQ at http://www.microsoft.com/windowsserver2003/sbs/evaluation/faq/bizsolutions.mspx . Please note that this is a time limited capability due to the End of standard support of SQL 2000. If you have licensed a copy of Windows Small Business Server 2003 R2 Premium Edition (which includes Microsoft SQL Server 2005 Workgroup Edition), but your line of business applications are not yet available on the Microsoft SQL Server 2005 platform, you may be able to request downgrade rights to SBS 2003 SP1 Premium (which includes Microsoft SQL Server 2000 Standard Edition the version of Microsoft SQL Server that shipped with Small Business Server 2003 and SP1), and use the downgraded SQL Server in your SBS 2003 R2 environment. You may exercise this downgrade through the channel in which you licensed your original version of Windows Small Business Server R2 Premium Edition. This downgrade offer is available only through April 30, 2008 . The downgrade from SBS 2003 R2 Premium (which includes Microsoft SQL Server 2005 Workgroup Edition) to SBS 2003 SP1 Premium (which includes Microsoft SQL Server 2000 Standard Edition) should be for new data installs only. This is not recommended as a migration path for data already ported to Microsoft SQL Server 2005 Workgroup Edition. Product Support Update How to Downgrade Downgrading for OEM Customers Downgrading for Volume Licensing Customers Downgrading for Retail or Systems Builder Channel Customers Product Support Update When you use Microsoft SQL Server 2000 Standard Edition (included in SBS 2003 SP1 Premium) in your SBS 2003 R2 Premium Edition environment, the product support policies for the downgraded version of SQL Server will follow the Microsoft SQL Server 2000 lifecycle. Mainstream support for Microsoft SQL Server 2000 will retire on April 8, 2008. After this time, Microsoft SQL...
  • SQL 2000/2005 June Downloads including Management Pack, JDBC Drivers, Virtual Hard Disks and Access Migration Assistant

    Microsoft SQL Server 2000 / 2005 Management Pack The SQL Server Management Pack monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems. Availability and performance monitoring is done using synthetic transactions. In addition, the Management Pack collects Event Log alerts and provides associated knowledge articles with additional user details, possible causes, and suggested resolutions. The Management Pack discovers Database Engines, Database Instances, and Databases and can optionally discover Database File and Database File Group objects. http://www.microsoft.com/downloads/details.aspx?FamilyID=8c0f970e-c653-4c15-9e51-6a6cadfca363&DisplayLang=en Microsoft SQL Server 2005 JDBC Driver 1.2 Community Technology Preview April 2007 In its continued commitment to interoperability, Microsoft has released a new Java Database Connectivity (JDBC) driver with SQL Server 2005. The SQL Server 2005 JDBC Driver 1.2 CTP April 2007 download is available to all SQL Server users at no additional charge, and provides access to SQL Server 2000 and SQL Server 2005 from any Java application, application server, or Java-enabled applet. This is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in J2EE (Java2 Enterprise Edition). This release of the JDBC Driver is JDBC 3.0 compliant and runs on the Java Development Kit (JDK) version 1.4 and higher. It has been tested against all major application servers including BEA WebLogic, IBM WebSphere, JBoss, and Sun. http://www.microsoft.com/downloads/details.aspx?FamilyID=f914793a-6fb4-475f-9537-b8fcb776befd&DisplayLang=en SQL Server Tables and Exchange Web Services The SQL Server Tables and Exchange Web Services sample demonstrates a powerful integration of Microsoft® Exchange Server 2007 and Microsoft SQL Server™ 2005 features. This integration enables you to provide data from both Microsoft Exchange and SQL Server to client applications so that...
  • SQL 2005 Webcasts for June

    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 Momentum Webcast: Selecting the Right SQL Server 2005 Edition to Fit Your Business (Level 200) – Monday, June 25, 2007. 11:00 AM Pacific Time (US & Canada) Microsoft SQL Server 2005 is available in a variety of editions to best match the demands of your business applications. Attend this session to learn about the differences between editions of SQL Server, especially Microsoft SQL Server 2005 Enterprise Edition and Standard Edition, so you can avoid the common mistake of choosing the wrong edition to run your mission-critical applications. In this webcast, we present the value of SQL Server 2005 Enterprise Edition by describing its exclusive features and benefits, and by demonstrating practical usage scenarios. Join this presentation as we compare the capabilities of SQL Server 2005 Enterprise Edition with those available in SQL Server 2005 Standard Edition. Momentum Webcast: Selecting the Right SQL Server 2005 Edition to Fit Your Business (Level 200) Support WebCast: How to use custom assemblies in SQL Server 2005 Reporting Services This Support WebCast describes how you can use custom code in a Microsoft SQL Server 2005 Reporting Services report. We will cover a typical scenario where you would want to use a custom assembly in a report. The presentation simplifies and outlines all the steps to create, deploy, and troubleshoot custom assemblies that are used with Reporting Services. This presentation discusses how to use embedded code instead of a custom assembly and also discusses the pros and cons of using embedded code compared to using a custom...
  • Next version of SQL announced "Katmai"

    Microsoft SQL Server Code Name “Katmai” SQL Server code name "Katmai," the next release of Microsoft SQL Server, provides 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/presspass/press/2007/may07/05-09KatmaiPR.mspx Technorati Tags: Katmai
  • SQL Server 2005 KB (Knowledge Base or Support) Articles (note the CRM one)

    SQL Server 2005 Standard Edition FIX: Failed assertion message in the Errorlog file when you perform various operations in SQL Server 2005: "Failed Assertion = 'fFalse' Attempt to access expired blob handle (3)" http://support.microsoft.com/?kbid=933766 FIX: SQL Server 2005 does not reclaim the disk space that is allocated to the temporary table if the stored procedure is stopped http://support.microsoft.com/?kbid=931843 The Batch Requests/sec counter of the SQL Statistics performance object increases one time for each RPC in SQL Server 2005 Service Pack 2 http://support.microsoft.com/?kbid=936637 List of known issues when you install SQL Server 2005 on Windows Server Code Name "Longhorn" http://support.microsoft.com/?kbid=936302 How to use Windows Management Instrumentation in SQL Server 2005 to change the account of the SQL Server service or the password of the SQL Server service programmatically http://support.microsoft.com/?kbid=936492 A user who is not a member of a required role can still connect to a SQL Server 2005 database after you set the user access option for the database to RESTRICTED_USER http://support.microsoft.com/?kbid=935997 After you install a 64-bit version of SQL Server 2005 on a 64-bit version of Windows, the 32-bit entries for SQL Native Client Configuration and for SQL Server 2005 Network Configuration appear in SQL Server Configuration Manager http://support.microsoft.com/?kbid=936491 FIX: The query performance is slow when you run a query that uses a user-defined scalar function against an instance of SQL Server 2005 http://support.microsoft.com/?kbid=933724 FIX: High CPU utilization by SQL Server 2005 may occur when you use NUMA architecture on a computer that has an x64-based version of SQL Server 2005 installed http://support.microsoft.com/?kbid=931821 FIX: Event ID: 1 may be logged when you use a Volume Shadow Copy Service (VSS) writer to back up a snapshot in SQL Server 2005 http://support.microsoft.com/?kbid=934396 FIX: When you run the "dbcc dbreindex"...
  • SQL Server 2000 KB (Knowledge Base or Support) Articles

    SQL Server 2000 Standard Edition FIX: You may receive an assertion or database corruption may occur when you use the bcp utility or the "Bulk Insert" Transact-SQL command to import data in SQL Server 2000 http://support.microsoft.com/?kbid=933573 FIX: Error message when you use the sp_addarticle stored procedure to add articles to an existing transactional replication publication in SQL Server 2000: “Cannot create a file when that file already exists” http://support.microsoft.com/?kbid=932686 FIX: The Sqldumper.exe utility cannot generate a filtered SQL Server dump file when you use the Remote Desktop Connection service or Terminal Services to connect to a Windows 2000 Server-based computer in SQL Server 2000 http://support.microsoft.com/?kbid=928079 FIX: The sp_droparticle stored procedure performs very slowly if the @immediate_sync property is set to TRUE in SQL Server 2000 Service Pack 4 http://support.microsoft.com/?kbid=932674 SQL Server 2000 Analysis Services FIX: An access violation may occur in SQL Server 2000 Analysis Services when you try to use a 2007 Office system program to open an offline local cube http://support.microsoft.com/?kbid=925000 Technorati Tags: SQL Server 2000
  • How to configure SQL Server 2005 to allow remote connections on Windows Server 2008 (Longhorn) / Windows Vista

    Just a quick one - I was playing around with SQL2005 on my Longhorn server and I could not connect from a remote machine - Ahh I thought, the firewall is in the way, but it turned out I had to do 3 or 4 things to get things working. The Microsoft KB article that pointed to the light was How to configure SQL Server 2005 to allow remote connections which covers how to enable the firewall for the 2 programs you need and so on. When you try to connect to an instance of Microsoft SQL Server 2005 from a remote computer, you may receive an error message. This problem may occur when you use any program to connect to SQL Server. For example, you receive the following error message when you use the SQLCMD utility to connect to SQL Server: Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. This problem may occur when SQL Server 2005 is not configured to accept remote connections. By default, SQL Server 2005 Express Edition and SQL Server 2005 Developer Edition do not allow remote connections. To configure SQL Server 2005 to allow remote connections, complete all the following steps: Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer. Turn on the SQL Server Browser service. Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service. Well, the above is all well and good, but we also need to remember that in a Vista and Longhorn setup the "admin" accounts do not have admin control over the database, so you may well also need to run the SQL 2005 Surface Area tool that enables you to add administrators I also found I had to enable network connections by going to the SQL Server Configuration Manager and enabling TCP connections on my IP v4 network. ttfn David Technorati tags: SQL , Vista , Longhorn...
  • New downloads for Business Contact Manager for Office 2007 (and 2003) to provide Pocket PC / Windows Mobile 5 & 6 support, Admin a database on a SBS box, setup a database on a SBS box and offer Office Live Maps for contacts

    I have just got my new mobile phone and I thought I would update the BCM client - a quick trip to http://download.microsoft.com (link takes you to these results) led me to these results below. I think the ones shown are key for many people. Results for - "business contact manager" Title Release Date Popularity Outlook 2007 with Business Contact Manager: Prevent error message about version mismatch when certain Office 2007 applications are launched Prevents error message about version mismatch when you start certain Office 2007 applications on a computer that is running Microsoft Office Outlook 2007 with Business Contact Manager 5/1/2007 #963 Outlook 2007 or 2003 with Business Contact Manager Add-in: Business Contacts for Pocket PC This release is an add-in that allows you to synchronize your business contacts and a subset of your communication history to your Microsoft Windows Mobile 5.0 Pocket PC. 4/25/2007 #536 Business Contact Manager Database Admin Tool Users of Business Contact Manager for Outlook 2007 may want to install the Business Contact Manager database on a remote server which is not running Office 2007. This tool, when run on a server, allows users to create, share and administer databases for use with Business Contact Manager. 3/29/2007 #1705 Outlook 2007 Document: Deploying Outlook 2007 with Business Contact Manager in a Remote Database Configuration Learn about installing and configuring a Business Contact Manager for Outlook database by using Microsoft SQL Server 2005. 3/21/2007 #2390 Service Pack 4 for Outlook 2003 with Business Contact Manager Update and Small Business Accounting This service pack provides the latest updates to Microsoft Office Outlook 2003 with Business Contact Manager Update to enable application compatibility with Windows Vista, and to allow compatibility with Office Accounting 2007. 3/5/2007 #124 Office Live Contact Map This download will install a sample code mashup for Microsoft Office Live which is designed to map the addresses of all contacts included in an Office...
  • Channel Expo Show presentations - Windows Vista, Office 2007 and Windows Server (SBS, Naked, Home Server and Longhorn) sales slides

    If you visited the Channel Expo show this year then you probably saw one or two Microsoft presentations on desktop and server solutions. James Akrigg and Matt McSpirit provided the desktop entertainment while I covered off what servers we have out there and what is coming in the near future. We promised the slides and here they are: Desktop (Windows Vista and Office 2007)- Office 2007 PowerPoint Desktop (Windows Vista and Office 2007)- PDF Server (SBS, Windows Server 2003 R2, Longhorn and Home Server) - Office 2007 PowerPoint Server (SBS, Windows Server 2003 R2, Longhorn and Home Server) - PDF James has an amazing blog (Out of Office) at http://blogs.technet.com/outofoffice Matt touches many aspects of desktop technology including that for small business at http://blogs.technet.com/mattmcspirit Have a look at the blogs and enjoy the presentations. ttfn David Technorati tags: Channel Expo , Vista , Office 2007 , SBS 2003 , Nakes Servers , Home Server , Longhorn
  • Help us to shape next-generation 64-bit technology - from Microsoft Partner Newsletter

    Help us to shape next-generation 64-bit technology We are shipping a private beta of our upcoming 64-bit server for medium-size businesses, codenamed 'Centro', and we're looking for partners to test the technology and give us feedback. The server, which is an x64-only version of Longhorn targeted at smaller enterprises, will integrate Exchange 2007, System Centre Essentials, SQL Server 2005 and ISA Server. To sign up to the beta programme, go to http://connect.microsoft.com/ , click on 'Invitations' (in the left-hand navigation) and sign in with your Windows Live ID (Passport ID). Then enter the following invite ID; Extr-GHBC-JCJM. You will be asked to take a short survey. When you have completed the survey you will receive an email from MsftConn@microsoft.com . If you don't already trust this address, please add it to your trusted email addresses. More information on the beta programme More information on Centro Technorati tags: Centro , Beta , Exchange 2007 , System Center Essentials , SQL Server 2005
  • SQL 2005 Events in UK from Technet team and others

    SQL Server 24 April 2007, Manchester: Introduction to SQL Server 2005 Reporting Services At this event we'll look at SQL Server 2005 Business Intelligence and the components and features that make up the Reporting Services platform. At the end of the session you should be able to create and publish reports to enhance your organisation's business knowledge. 31 May 2007, Reading: Advanced SQL Server 2005 Reporting Services Find out about the advanced techniques for building reports with Microsoft SQL Server 2005 Reporting Services and the Microsoft Visual Studio-based Report Designer. Other topics at this event include using the built-in expression language, report parameterisation and supporting multiple data sources. Receive a walk-through of sample reports and discover tips and tricks for using the Report Definition Language (RDL).
  • If you don't know what OBA is, then you might want to watch the Partner TV episode: Ben Tamblyn on Office Business Applications

    OBA is not the nicest sounding acronyms, but we still seem to use it. Oh well. If you want to know more about performance management and business intelligence, or these terms mean nothing to you and you are now getting worried, then watch Partner TV at http://blogs.msdn.com/ptstv/archive/2006/11/28/partner-tv-ben-tamblyn-on-office-business-applications.aspx ttfn David
  • Exchange 2007, Cougar and Centro for small (and larger) businesses

    So there I am being a good citizen and not releasing confidential information and then I read about Cougar on the web. I then find that my fellow bloggers are also talking about these products in some form or another. Finally, to top it off, I am challenged by Susan Bradley to answer why Small Businesses need Exchange 2007 . Enough is enough, so I decided to finally start the conversation on these products. 1st up, lets examine Exchange 2007. You can NOT run it on an existing SBS 2003 server as it requires Windows Server x64. The various features and licensing of Exchange 2007 are discussed on my post here . To get Exchange 2007 today, before the launch of Cougar, you will need to buy a 2nd server, Exchange 2007, Windows 2003 Standard x64, Exchange 2007 CALs. This is NOT something for most small businesses. So who is it for? If you want: People who need LOTS of Exchange storage People who like the idea of a continious backup of their Exchange store Unified messaging (including phoning and talking to youe Exchange Server) Hosted message filtering before it reaches your server Forefront security (Anti-Virus/Anti-Malware/Anti-Spam) The last 3 require an Enterprise CAL, but can still be delivered with Exchange 2007 Standard. If these, along with the newer OWA, clustering support and Windows Crossbow additional support are of interest, then your customer may well be too. If not, then many small businesses, for the price point and the simplified support using the wizards, will enjoy SBS 2003 R2 today until Cougar ships. What is in Cougar, well it is a very simple statement today - based on Windows Server Longhorn, with Exchange 2007, latest Windows SharePoint Services and almost certainly some / all of System Center / ISA / SQL and more. If it helps, I am part of the limited beta of Cougar - and it is nice. The newer technologies are great and again more will be revealed in the future, but Cougar is slated for 2008, so not something to get super excited about just yet. Centro is SBS grown up for businesses of 50-250 CALs...
  • SQL Server 2005 SP2 for Vista and Longhorn

    If you have SQL based apps, they will have to upgrade to SQL 2005 SP2 (that includes the MSDE replacement SQL Express). e-Week noted ( SQL Server 2005 SP1 Users Face Vista, Longhorn Glitches ): These two operating systems will only support SQL Server 2005 SP2 "or later when it becomes available," according to Microsoft's SQL Server support Web pages. But there is no indication on these sites of how soon it will deliver SP2 or whether it will deliver the service pack at about the same time Vista and Longhorn are released. the CTP of SP2 is available at http://www.microsoft.com/sql/ctp.mspx More information on the problems users experience when not running SP2 is available at http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx with support information at http://www.microsoft.com/sql/howtobuy/windowsvistasupport.mspx which notes: Known Issues This section describes known issues that relate to installing and running SQL Server 2005 on Windows Vista and Windows Server "Longhorn." Issues Related to User Account Control Microsoft Windows Vista includes a new feature, User Account Control (UAC), which helps administrators manage their use of elevated privileges. Administrator rights inherited from Windows Windows Vista users that are members of BUILTIN\Administrators are not automatically added to the sysadmin fixed server role when they connect to SQL Server. Only Windows Vista users that have been explicitly added to a server-level administrator role can administer SQL Server. Administrator Access to a Report Server Deployment User Access Controls can prevent administrative access to a Report Server deployment. To gain administrative access, connect to SQL Server using one of the workarounds described above and create role assignments on Home and at the system-level for your account. Administrator Access to SQL Express The UAC behavior described above prevents administrator access to SQL Express. Application Compatibility Message May Display Multiple Times During Setup Incorrect IIS Configuration Prevents Installation...
  • E-Bitz - SBS MVP the Official Blog of the SBS &quot;Diva&quot; : Upgrading to SQL 2005 workgroup from SQL 2000

    Upgrading to SQL 2005 workgroup from SQL 2000 When upgrading from SQL 2000 to SQL 2005 workgroup there's a couple of things you should read up ahead of time... the first being the "official" upgrade guide . the second is the "Susan" version of the document that just covers the needed steps for upgrading SQL 2000 to SQL 2005. For more information, go to E-Bitz - SBS MVP the Official Blog of the SBS "Diva" : Upgrading to SQL 2005 workgroup from SQL 2000
  • Compatibility Chart for Windows Small Business Server 2003 (Product, Server applications and desktop)

    A great new set of pages that shows what works and does not work with SBS 2003. using a simple traffic light system = The product is an integrated component of Windows SBS, or it is known to be compatible with Windows SBS. The product was tested and you can obtain support for this configuration. = The product has not been fully tested on Windows SBS and support for this configuration is not available from the Windows SBS product support team. Other groups may offer support for this configuration; contact the appropriate group for information. Some product features may not be fully functional in a Windows SBS environment. = Not compatible. The product is known not to work and you should not install the product in a Windows SBS environment. Product Technologies Compatibility Chart for Windows Small Business Server 2003 An at-a-glance compatibility chart for installing and running standalone versions of SBS 2003 technology on a server running Windows Small Business Server 2003. Server Application Compatibility Chart for Windows Small Business Server 2003 An at-a-glance compatibility chart for installing and running Microsoft collaboration and line-of-business applications on your SBS 2003 server. Desktop Technology Compatibility Chart for Windows Small Business Server 2003 An at-a-glance compatibility chart for installing and running Microsoft desktop technology on your SBS 2003 network. ttfn David
  • Installing the Windows SBS 2003 R2 Premium Technologies

    This simple guide covers what you need to know to install the Premium Technologies. Installing SQL Server 2005 Workgroup Edition You can install SQL Server 2005 Workgroup Edition as your database for a business application. Additionally, you can upgrade the instance of Microsoft SQL Server Desktop Engine (Windows) (MSDE) that is used by Microsoft Windows SharePoint Services if you want to be able to search document libraries in your company's internal Web site. For step-by-step instructions about how to install SQL Server 2005, download the file sqlinstallsteps.htm below. Installing ISA Server 2004 You can install ISA Server 2004 as the firewall for your local network. For step-by-step instructions about how to install ISA Server 2004 with Service Pack 1, download the file isainstallsteps.htm below. Installing FrontPage 2003 You can install FrontPage 2003 on one computer in your Windows SBS network and then use FrontPage to create or modify your Internet Web site. Note It is recommended that you do not install FrontPage on your computer that is running Windows SBS 2003 R2. You should install it on another computer in your network instead. Download details: Installing the Windows SBS 2003 R2 Premium Technologies ttfn David
  • Running SQL Server on Microsoft Windows Server Longhorn or Microsoft Windows Vista

    Most people do not run SQL on their Windows client PCs, with the exception of MSDE. Windows Vista will not support MSDE (aka SQL 2000), so applications dependant on SQL will need to be moved to SQL Express, which in simple terms is SQL 2005 MSDE on steroids. I have checked and Microsoft will be releasing updates to it's packages that are supported on Vista to move them to SQL Express. Obviously, if you are looking at Vista, check with other 3rd parties to ensure they are doing the same. More details can be found at Running SQL Server on "Microsoft Windows Server Longhorn" or Microsoft Windows Vista . ttfn David
  • What is the Demo Showcase and how do you use it?

    I have a mate at work, Chris, who has always been a good and clever egg the whole time I have known him. He is also very passionate about partners getting the right level of support as well as liking Stoke City, but something's just have to be forgiven. One thing he has got a bee in his bonnet about this year is the Demo Showcase, which we will be using for all our demos going forward for a while. If you have been to an ignite tour, that was based on an early version of the Showcase DVD set. Chris has been a prolific blogger on the subject - this is a great tool for you to use, so look at: Whoever heard of the Demo Showcase for the People Ready Business? The Demo Showcase Line Up What Does the Demo Showcase Look Like (Physically)? What Does the Demo Showcase Look Like (in Reality?) The Demo Showcase Team Tactics ttfn David
  • Exchange 2007, Office 2007, Collaboration, Business Intelligence and Unified Communications - More PTS-TV Videos

    So, having written about the Vista messages on the PTS TV Channel, I realised that there were a number of Information Worker related TV sessions, so here they are. These cover the areas in the titles, so here they are - this is about meeting the team too: PTS: Collaboration using Exchange and SharePoint Stream this video Download video (right-click/save as) Comment on this video View John Westworth's Blog PTS: Exchange Server 2007 Stream this video Download video (right-click/save as) Comment on this video PTS: Business Intelligence - Business Score Card Manager / Excel / SQL (BSCM Demo) with Chris Parkes Stream this video Download video (right-click/save as) Comment on this video View Chris Parkes' Blog PTS: Information Worker - how to get skilled up in IW and Office 2007 Stream this video Download video (right-click/save as) Comment on this video PTS: Information Worker - How important Search can be to your business Stream this video Download video (right-click/save as) Comment on this video PTS: Unified Communication Stream this video Download video (right-click/save as) Comment on this video View Mark Deakin's Blog
  • David Overton moving to a solution / revenue based role (it means I need to help partners sell)

    Many people ask me what I do and sometimes they are amazed with the answer "I help Microsoft Partners build solutions that deliver value to their small business partners – for free". This is a great job and part of it is to engage with as many partners as possible to improve the quality and knowledge around the solutions that can be built upon Microsoft technology. This year my role has a slightly different focus, but the way I achieve it will have many similarities. It has becoming important for me to ensure that partners are not just technically capable, but also selling solutions, sometimes even offering their customers alternative licensing options to suit their business needs. Some may see this as me selling out in some way, but while I love technology, if it is not applied correctly and you and I can't make money out of it, then there is a limit to the business value of the technology. I will still be blogging, posting on both business and technical ideas, but also be discussing how to sell solutions, what the licensing options truly mean, what extras you can add to a sale to add value for you and the customer. I'll even be discussing how online services are an opportunity for you, but more on this later. On this note, is there more I should do to help you sell more, have more customers and make more money? If so, let me know what is needed, whether it is something from Microsoft or David. Comments are open on this one, so fire a comment onto the blog. Expect to see a post on the work we are doing with the Technet team to get you even more technical resources and the process for access to all those nice betas, hosted services and where they fit as part of a solution and the options on licensing to make it easier for your customer to understand the value of technology and even buy earlier. Ttfn David
  • Off to Partner Conference in Boston - see you blogging from there

    Hello, just a quick note to say that I am due to fly today @ 11am to Boston for the Partner Conference - if you are going then I will see you there, if not, you can read about it here. ttfn David
  • UK Managing Director Leaves the UK bound for Microsoft Corp - welcome to Gordon Frazer from South Africa

    Today we had a bit of a kick of for FY07 (Financial Year 07 in Microsoft) and a review of FY 06. We had a healthy year with excellent growth (this is no way a prediction of the MS Company results) and we also did a bit of sweeping a few things out. It has been speculated for a little while that Alistair Baker would be moving on and today we had it confirmed. As of 31st July, the new MD of MS UK will be Gordon Frazer from the South African Sub. He did seem like a very positive and fired up person, so I think this will be nothing but goodness, as will having another Brit in the power halls at MS in the States. For the press release, have a look at http://www.microsoft.com/uk/press/content/presscentre/releases/2006/07/PR03662.mspx ttfn David
  • July SQL 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. http://www.microsoft.com/sql/eval/webcast.mspx?wt.mc_id=sql.ad.01037 Free SQL Server 2005 Training Whether you are interested in database administration, database development, or business intelligence, you can access the E-Learning topic you want, when you want it, and learn at your own pace. Each lesson includes hands-on virtual labs and offline functionality. In addition, you may consider taking a free Microsoft Skills Assessment to help you meet your Microsoft SQL Server 2005 training goals. You'll receive a learning roadmap with additional skills resources including instructor-led classroom training and books. https://www.microsoftelearning.com/sqlserver2005/default.aspx TechNet Webcast: Introduction to SQL Server 2005 Reporting Services (Level 200) Wednesday, July 05, 2006 11:30 AM Pacific Time (US & Canada) This webcast introduces Microsoft SQL Server 2005 Reporting Services. We discuss its place in the Microsoft business intelligence solutions strategy, and explore the components and features that comprise the Reporting Services platform. Find out about the many new and exciting features that have been added to Reporting Services since Microsoft SQL Server 2000. Gain an understanding of the report lifecycle, and see how to create, publish, manage, and deliver reports using the new tools and features in SQL Server 2005 Reporting Services. At the end of the session, you should be ready to create and publish reports that can enhance your organization's business knowledge. http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032301587&EventCategory=4&culture...
  • 70-282 Exam - what has changed, what has not and how it stands now after all the feedback

    Howdy. There has been a lot of discussion recently about the huge changes to the 70-282 exam, especially following people helping us with the 71-282 beta exam work. Having worked many hours as an investagtive reporter (at least 2) and searched many a rubbish bin, I now have a pretty good answer to what happened. I managed to get this statement from the "right people" inside Microsoft. In short - 71-282 was a beta which had some things in it that did not make it into the final revised 70-282 exam. "70-282 Clarification around the introduction of a new version of the exam In Early 2006 Microsoft felt that exam "70-282 Designing, Deploying and Managing Network Solutions for Small and Medium-Sized Businesses" had not been performing at the Microsoft standard. Microsoft constantly reviews customer feedback and exam statistics, and determines if exam item changes or additions are required. To keep this exam current and valued by our customers and partners, Microsoft revised the questions and carried out testing of the new exam with a cross-section of Microsoft Partners and internal staff. This group was made up of people who had sat the previous 70-282 exam and of people who had not yet sat the exam all coming from the Small Business Specialist Community or SBS MVPs. The beta exam was coded 71-282. Candidates who sat and passed 71-282 will be given credit for the 70-282 exam. In March 2006, once testing was complete, the revised 70-282 exam was launched. The exam format has changed slightly, but the content continues to reflect the required knowledge for designing, deploying and managing network solutions for the small and mid-sized business. To be successful, you will need adequate knowledge of Microsoft Small Business Server, Microsoft Windows Server and Active Directory. All existing training and prep materials contain information to prepare candidates for the current exam questions. There are several preparation options available depending on your experience and current knowledge levels. Details of training courses...
  • Bad links now fixed

    Sooo many of you clicked the links in the posts from the last two days, but got an OWA screen that I had to go back and edit about 16 posts. All fixed now - thanks to Rob for pointing it out. ttfn David
  • Draft release of my web log analyser tool (using IIS Log files)

    People have asked for my tools I use to produce my site statistics, so I have released a draft cut. It should all work. To get the best out of it you need a $20 subscription to http://www.maxmind.com/app/web_services_guide#city and MapPoint , but otherwise it works - without both these it is fully functional, but no maps. The source can be found at http://uksbsguy.com/files/11/files/entry735.aspx and the exes at http://uksbsguy.com/files/11/files/entry736.aspx . ttfn David
  • SQL 2005 updates - SP1 - worth having for the new management console

    SQL 2005 only seems like it poped out the door a week ago and already we have SP1. Having said that, it arrived in November 2005 and there were a couple of things that people wanted, but we could not ship in time. One was a management console for the repalcement to the free MSDE - this is now part of SP1. Details on how to impletment SP1 can be found at http://www.microsoft.com/sql/sp1.mspx . The press release with all the details is located at http://www.microsoft.com/presspass/press/2006/apr06/04-19SQLExpands06PR.mspx , but the key points are: SP1 delivers on this vision in the following ways: SP1 delivers production-ready Database Mirroring functionality for continuous availability. This complements the existing Always On Technologies in SQL Server 2005 such as failover clustering, database snapshots, snapshot isolation and log shipping. Since launch, Database Mirroring has been extensively tested by Microsoft and its thriving customer community to help ensure that it provides the high availability necessary for the largest customer deployments. Today more than 20 SQL Server customers have deployed Database Mirroring into production. “Due to the nature of our shipping business, we needed a system that could support us around the clock, and that means high availability,” said Fabio Catassi, chief technology officer of Mediterranean Shipping Co. “Since SQL Server 2005’s launch, we’ve been involved with the Database Mirroring testing, and we are so confident in the feature that we’ve already deployed it into our production. We have a large global company and need a reliable, scalable solution, and SQL Server 2005 delivers that for us.” SP1 extends business insight to smaller-scale customers and ISVs using the free SQL Server 2005 Express Edition, which includes SQL Server Reporting Services (SSRS) functionality, Full Text Search and the newly released SQL Server Management Studio Express. This optional set of capabilities is already receiving positive feedback from Microsoft’s ISV partners. “By leveraging SQL Server...
  • Upgrading SQL 2000 and MSDE 2000 to SQL 2005 - in SBS R2 - this could be the sharepoint or WSUS database

    Upgrading MSDE 2000 to SQL Server 2005 Express This white paper discusses the new SQL Server 2005 Express Edition features that are important to MSDE users. It covers how to upgrade your existing MSDE installation to SQL Server 2005 Express and presents criteria to help you decide when to upgrade your MSDE installation to other editions of SQL Server 2005. http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx SQL Server 2005 Upgrade Handbook Preparing for a SQL Server 2005 upgrade involves understanding some basic principles that will help you make appropriate decisions and ensure your success. Each SQL Server 2005 component has a unique architecture and life cycle—the two primary areas that will affect your upgrade path. Some SQL Server 2005 components build on a solid foundation to augment, optimize, and stabilize existing functionality. Microsoft has performed extensive, under-the-hood rework of other features to give SQL Server the horsepower and programmability features that your applications need. The new release also provides complete component overhauls and additions to meet a new generation of data-management needs. http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx ttfn David
  • Getting SBS, Windows SharePoint Services (WSS), indexing and PDFs all working together

    While browsing Sean's Blog I came across this article on how to get PDFs to have a PDF icon in [WSS] and how to re-index the companyweb site to ensure they are properly indexed (as in the content too). I know some of the links go to older versions of tools, but I am sure you are all very clever, so can work out what to do. Bear in mind that for this to work, you need to be running SBS Premium so the SharePoint database is stored in SQL. I have not blogged on this yet, but will do so next week. ttfn David

(c)David Overton 2006-13