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 2005 » Support and Tools (RSS)

Browse by Tags

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

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

  • SQL SP2 updates to support Vista and Office 2007

    With support for Vista and Office 2007 being key for people inside and outside of Microsoft we have had two updates recently to support this. This entry relates to SQL 2005 SP2 and another will relate to Virtual PC 2007. Microsoft announced the release the web of SQL Server 2005 Service Pack 2. SP2 is an important deliverable for SQL Server, providing support for Windows Vista and the 2007 Office System in addition to delivering important enhancements for customers. It can be downloaded from http://www.microsoft.com/sql/sp2.mspx . For me, the performance of my reports on my reporting server went up significantly. Ttfn David Technorati tags: SQL Server 2005 , SQL 2005 , SQL SP2 , Vista Published with BlogMailr

(c)David Overton 2006-23