THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2005   (RSS)
Showing page 2 of 6 (57 total posts)
  • Cumulative Update #8 available for SQL Server 2005 SP3

    Last week, Microsoft released Cumulative Update #8 for SQL Server 2005 SP3.  The build # is 9.00.4285.  You can read the blog post from the Release Services team here: the Knowledge Base article, #978915, is available ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 23, 2010
  • Convert binary value to string value

    With SQL Server 2008, we can easily useDECLARE @bin VARBINARY(MAX)SET     @bin = 0x5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8SELECT  CONVERT(VARCHAR(MAX), @bin, 2)But how can we do this in SQL Server 2005?You can't use a simple CAST or CONVERT, because you get the ASCII representation of the binary values.So, here is how you ...
    Posted to Peter Larsson (Weblog) by Peso on January 27, 2010
  • Mis-steps in the publication of Cumulative Updates

    It used to be very difficult to obtain hotfixes for SQL Server (sometimes even to learn about their existence), and they were often unsupported.  They have made extremely great strides in this area, and in general, I find the new procedure much more convenient : just go to the KB article, select the fix(es) you want, and you get an almost ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 20, 2010
  • Installing Service Packs / Cumulative Updates on a SQL 2005 cluster

    In our environment, we run the task scheduler as a cluster resource, so that scheduled tasks always run on the active node.  (In ancient history, we would have scheduled tasks that weren't cluster aware - in the event of a failover, we'd have to manually disable task scheduler on the now passive node, and manually enable it on the active ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 20, 2009
  • New Cumulative Updates for SQL Server 2005 SP2 / SP3

    Some new updates just posted by SQL Server Release Services: For SQL Server 2005 SP2, build 9.0.3355: For SQL Server 2005 SP3, build 9.00.4266: On first glance, it does not appear that the security updates last week were included in the hotfix for SP2.  (See ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 20, 2009
  • New cumulative updates available for SQL Server 2005 SP2/SP3

    Sleeping at the wheel again, I missed some big updates for SQL Server 2005 this past Monday. Cumulative Update #5 for SP3 brings you up to 9.00.4230 (the previous update was 9.00.4226). Cumulative Update #15 for SP2 brings you up to 9.00.3330 (the previous update was 9.00.3328). ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 19, 2009
  • [New England] Kalen Delaney Internals and Query Tuning - in the Boston area October 12-16

    In case you missed Kalen's post, we're excited to announce that she will be joining us here on the East Coast in October to deliver her SQL Server 2005/2008 Internals and Query Tuning seminar. This is, to my knowledge, the most advanced public SQL Server course to be offered in the Boston area in the last 5 years, and this is the first time that ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 23, 2009
  • SQL Server 2005 SP3 Cumulative Update 4 is available

    Microsoft quietly released another cumulative update for SQL Server 2005 Service Pack 3 this week.  So quietly, in fact, that it took me 5 days to notice.  As Chad Miller noted in his comment, this is the first build of SQL Server 2005 that supports the ''lock pages in memory'' setting on Standard Edition.  You can read about the ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on June 20, 2009
  • Automating SQL Server 2005/2000 Policy Evaluation

    The Enterprise Policy Management Framework version 3.0, a new version of the framework to support policy automated policy evaluation for SQL Server 2000 and 2005, has been posted to codeplex. For those who are not familiar with the tool, the Enterprise Policy Management Framework is a reporting solution on the state of the SQL Server enterprise ...
    Posted to Lara Rubbelke (Weblog) by Lara Rubbelke on June 13, 2009
  • UPDATE : SQL Server 2005 SP3 Cumulative Update 3 is available

    It seems this came out on April 20th, but I did not catch it at the time.  Better late than never, I guess.  As Sean Nolan pointed out in a previous post, CU#3 includes many of the fixes that were available in SP2 CU#13 and not in SP3 CU#2.  You can download the hotfix (which puts you to 9.0.4220) ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 14, 2009
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement