Contents tagged with SQL 2005

  • Microsoft SQL Services is now Microsoft SQL Azure

    Posted by bink on July 9 2009, 7:06 PM. Posted in SQL 2005.

    SQL-Azure_rgb Microsoft is updating the branding for SQL Services and SQL Data Services. Effective immediately, SQL Services will be called Microsoft SQL Azure, and SQL Data Services will be Microsoft SQL Azure Database.  This name change doesn’t reflect a change in the products themselves; we will still be providing a powerful relational database foundation to the Azure Services Platform.  By standardizing our naming conventions, we’re demonstrating the tight integration between the components of the services platform.  More intuitive names also help to reinforce the relationships between our on-premises and cloud solutions. Ultimately, the goal is to drive simplicity and clarity for customers as they consider on-premises and cloud computing approaches for solving their IT needs.


    There will be more news and updates related to our Software + Services strategy next week at Microsoft’s Worldwide Partner Conference in New Orleans.  For those of you not attending in person, all the news and information can be found at: .  Check back often starting next Monday, July 13, for daily updates.

  • SQL Server 2008 Service Pack 1 - CTP

    Posted by bink on February 24 2009, 7:29 PM. Posted in SQL 2005.

    The CTP version of SQL Server 2008 Service Pack 1 (SP1) is now available. You can use these packages to upgrade any SQL Server 2008 edition.These packages have been made available for general testing purposes only. Do not deploy the CTP software in production. Peer-to-peer support is available in the SQL Server 2008 forums.
    Download At Source
  • SQL Server 2005 Service Pack 3 Released

    Posted by bink on December 16 2008, 4:43 PM. Posted in SQL 2005.

    Service Pack 3 for Microsoft SQL Server 2005 is now available. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP3. You can use these packages to upgrade any of the following SQL Server 2005 editions:
    • Enterprise
    • Enterprise Evaluation
    • Developer
    • Standard
    • Workgroup

    Note: To upgrade SQL Server 2005 Express Edition, obtain the SP3 version of Express Edition or Express Edition with Advanced Services.For a list of new features and improvements that are included in SQL Server 2005 SP3, review the What's New document.

     Download At Source

  • Microsoft SQL Server 2008 RTM on 31. July?

    Posted by bink on July 25 2008, 8:06 PM. Posted in SQL 2005.

    Odd Kristoffersen: When will SQL Server 2008 ship? “When it’s ready,” which has been Microsoft’s standard answer for the release to manufacturing (RTM) date of pretty much every Microsoft product, and certainly for all its SQL Server products. But I was talking to a Microsoft representative the other day regarding implementation of Dynamics AX 2009 and we are eager to use SQL 2008 in this deployment to take advantage of the database compression that will give great improvments regarding throughput, scalability and response time. I was then told that the scheduled release date now is 31. July.Any followp up questions regarding the release date of SQL 2008 was answered with the usual; "I don't know, I can not say"So anyway we can wait 6 more days to see if this will come true, because the benefits of deploying on 2008 plattform will be so great that it's worth the while.

    Full Story At Source

  • Issue with Security Update for SQL Server 2005 Service Pack 2 (KB948108)

    Posted by bink on July 10 2008, 4:36 PM. Posted in SQL 2005.

    I have never seen such a huge patch!

    Download Size: 137.3 MB - 220.2 MB


    Anyway this patch arrived through automatic updates on the webserver, when the install was initiated together with the other July patches it failed. After reboot the database was in recovery mode! That is why was offline last night for over 2 hours. After this two hours we decided to stop the recovery, we also tried to install the patch again, but it failed again.

    I'm still investigating the issue.

    I also have issues with the exchange 2007 sp1 update rollup 3, which causes to break my OWA, so uninstalled that too.

    Happy patching!


    More info on SQL patch at source

  • Microsoft to deliver SQL Server 2008 in August

    Posted by bink on July 9 2008, 10:26 PM. Posted in SQL 2005.

    The long wait for SQL Server 2008 is nearly over.

    At its Worldwide Partner Conference in Houston on July 9, Bob Kelly, Microsoft Corporate Vice President of Infrastructure Server Marketing, told attendees that SQL Server 2008 will be on the August price list. He said that Microsoft will keep pricing the same for the new release as it is for SQL Server 2005.

    Microsoft released the near-final Release Candidate (RC) 0 test build of SQL Server 2008 in early June.

    Microsoft officially “launched” SQL Server 2008 in February, alongside Visual Studio 2008 and Windows Server 2008. Earlier this year, Microsoft officials said they were planning to deliver SQL Server 2008 by mid-2008. Company officials changed their guidance a couple of months ago, noting that Microsoft was planning to deliver the final SQL Server 2008 release in the third calendar quarter of 2008.

     Continue At Source

  • SQL Server and the Windows Server 2008 Firewall

    Posted by bink on July 3 2008, 8:35 PM. Posted in SQL 2005.

    We've long recommended that customers use the Windows Firewall to protect SQL Server installations. Starting with Windows XP/SP2, and continuing with Windows Vista, the firewall has been enabled by default on Windows client operating systems. Windows Server 2008 marks the first time this protection has been extended to a Windows Server OS.

    For those of you migrating from Windows Server 2003 or earlier to Windows Server 2008, if you have not previously heeded the advice to enable the firewall, you may be surprised by connectivity failures caused by the firewall (for any version of SQL) and you will need to take action to enable the connectivity you want.

    Don't panic! J Choosing the right firewall strategy isn't as hard as it may seem, and it will pay dividends over the long run.  We have a books online entry that has lots of good information on how to use the firewall. That document is available at

    We strongly recommend you read that before making changes to your firewall strategy.  For detailed information about the firewall, see

    I use the term "firewall strategy" intentionally, because there are some tradeoffs that only you can make. You might want to simply "configure the firewall" to make it all "just work," and you could do that, but it might expose you in ways you don't intend. To highlight that point, I will refer you to a recent survey by David Litchfield of NGS Software. Quoting from the executive summary:

    The survey found that there are approximately 368,000 Microsoft SQL Servers directly accessible on the Internet and around 124,000 Oracle database servers directly accessible on the Internet.

    That's a lot of servers directly exposed to the Internet, and I doubt strongly that level of exposure is intended. So we're hopeful that you will spend some time making choices you are comfortable with, and that the change to enable the firewall on Windows Server 2008 will lead to a level of exposure that more closely matches your real business needs. And only you can determine your real business needs.

    I should note that exposure by itself does not imply that there is any particular vulnerability. Indeed, only 4% of the exposed SQL servers were running a vulnerable version of SQL Server, and those few vulnerable servers appear to have gone unpatched for many years now (our competitors fared much worse in this regard, candidly). But in the event of a newly-discovered vulnerability in SQL Server those 368,000 servers could become 368,000 targets overnight (or faster), and we all want to avoid that.

    So, our first piece of advice: review your existing firewall strategy, including your host and network firewalls, to ensure that none of your servers are unintentionally exposed to the internet or to untrustworthy insiders.

    Continue at source for the steps

  • Microsoft SQL Server Compact 3.5 SP1 Beta and Synchronization Services for ADO.Net v1.0 SP1 Beta

    Posted by sumeethevans on May 15 2008, 9:30 PM. Posted in SQL 2005, .NET.

    SQL Server Compact 3.5 SP1 Beta is the service pack release for SQL Server Compact 3.5 and it also installs with SQL Server 2008 CTP and Visual Studio 2008 SP1 Beta. The Beta release has the following new features:
    • Support for the ADO.NET Entity Framework for creating flexible, strongly typed queries by using LINQ. Install Visual Studio 2008 SP1 Beta for developing ADO.Net Entity Framework applications with SQL Server Compact 3.5 SP1 Beta
    • Case-sensitive collations at the database level
    • SSMS in SQL Server 2008 can be used for administering a SQL Server Compact database
    • Ability to replicate the new data types in SQL Server 2008 such as date, time, datetime2, datetimeoffset, geography, and geometry. The new data types in SQL Server 2008 are mapped to nchar, nvarchar, image, etc.
    • Data replication with SQL Server 2000, SQL Server 2005 and SQL Server 2008 by using Synchronization Services for ADO.NET v1.0 SP1 Beta for both desktop and mobile devices
    • Data replication with SQL Server 2005 and SQL Server 2008 using merge replication and Remote Data Access (RDA) and enhanced version compatibility for merge replication

    Download At Source


  • SQL Server 2005 SP3 - coming soon

    Posted by sumeethevans on April 22 2008, 8:54 PM. Posted in SQL 2005.

    Over the last year we have successfully established the Incremental Servicing Model (ISM), which has to date delivered 7 cumulative updates (CU) to our customers, in regular 8 week intervals. We’ve heard feedback from customers of the need for a third service pack for SQL Server 2005. I’m happy to inform you that we will in fact deliver an SP3 following the release to manufacturing of SQL Server 2008. Our goal is to get SP3 released in the market in CY2008.

    The Incremental Servicing Model has been very effective ensuring that customers receive the latest updates for SQL Server on a regular predictable schedule. We are hearing positive comments from customers, who like the ease and predictability the ISM provides. Customers rely on the predictable time frame to pre-select the day that the fix will go into production, which eliminates any downtime for its servers.

    Continue At Source

  • Microsoft SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3

    Posted by sumeethevans on April 14 2008, 6:46 PM. Posted in SQL 2005.

    SQL Server Compact 3.5 SP1 Beta release for the ADO.Net Entity Framework Beta 3 enables the following scenarios:
    • Applications can work in terms of a more application-centric conceptual model, including types with inheritance, complex members, and relationships
    • Applications are freed from hard-coded dependencies on a particular data engine or storage schema
    • Mappings between the conceptual application model and the storage-specific schema can change without changing the application code
    • Developers can work with a consistent application object model that can be mapped to various storage schemas, possibly implemented in different database management systems
    • Multiple application models can be mapped to a single storage schema
    • Language-integrated query support provides compile-time syntax validation for queries against a conceptual modelFor more information please see the ADO.NET Entity Framework Beta 3 Documentation and ADO.NET Entity Framework Samples Post feedback and questions to SQL Server Compact 3.5 MSDN Forum and ADO.NET MSDN Forum

    Download At Source