DavidOverton.com
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  
David Overton's Blog » All Tags » SQL Server » Support and Tools (RSS)

Browse by Tags

  • 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

  • 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

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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 [email protected] . 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).

  • 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...

  • 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...

  • 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...

  • 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
1 2 Next >

(c)David Overton 2006-23