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 » Documentation » SQL Server 2005 (RSS)

Browse by Tags

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

  • 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 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 2005 - BI, Search, Samples, Tuning and Virtual Labs

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

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

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

(c)David Overton 2006-23