Browse by Tags

All Tags » SQL 2008 (RSS)
07 November 2009 17:55

New version of Expressmaint now available (2.0.0.0)

A new version of the Expressmaint database maintenance utility is now available for download. This version adds the ability to specify a custom backup file name format. Please note there are specific version for SQL 2005 (2.0.0.0) and SQL 2008 (2.0.0...
Posted by sqldbatips | 1 comment(s)
Filed under: , ,
27 October 2009 16:24

SQL Server MVP Deep Dives book available for preorder

Along with 53 other MVP's I've contributed a chapter to the SQL Server MVP Deep Dives book which is now available for preorder. All author royalties, along with a contribution from Manning Publications, go to support War Child International (visit...
Posted by sqldbatips | with no comments
Filed under: , ,
13 September 2009 21:20

New version of Expressmaint now available (1.9.0.0)

A new version of the Expressmaint database maintenance utility is now available for download. This version fixes an issue with the timeout parameter (-TO) being treated as seconds instead of minutes for the REORG task. Please note there are specific version...
Posted by sqldbatips | 1 comment(s)
Filed under: , ,
13 August 2009 19:37

SQL 2008 R2 August CTP now available to all

It has been up on Technet and MSDN for a few days now for subscribers but the August CTP of SQL Server 2008 R2 is now available to all from Technet. Get it here http://technet.microsoft.com/en-us/evalcenter/ee315247.aspx SQL Server 2008 R2 expands on...
Posted by sqldbatips | 1 comment(s)
Filed under: , ,
29 July 2009 16:03

Keeping up with SQL Server KB articles

One of the most useful tools for anyone involved in day to day support of SQL Servers is being able to keep up with the latest Microsoft Knowledge Base articles for the products you support. There are RSS feeds available for each of the currently supported...
Posted by sqldbatips | 1 comment(s)
Filed under: , , ,
12 May 2009 16:44

Disk Partition Alignment Best Practices for SQL Server whitepaper

This paper documents performance for aligned and nonaligned storage and why nonaligned partitions can negatively impact I/O performance; it explains disk partition alignment for storage configured on Windows Server 2003, including analysis, diagnosis...
Posted by sqldbatips | with no comments
Filed under: , , ,
28 April 2009 21:09

Reporting Services Linked Report Generator updated for SQL 2008

A new release of Reporting Services Linked Report Generator is now available (1.0.0.8) confirming support for SQL 2008 Reporting Services. Reporting Services Linked Report Generator is a .NET Windows Forms application that enables automatic generation...
Posted by sqldbatips | with no comments
Filed under: , ,
16 April 2009 19:02

New Release of Reporting Services Scripter (2.0.0.15) confirms SQL 2008 support

Judging by the increasing volume of emails I have recieved over the last few months asking about SQL 2008 support in Reporting Services Scripter there is a definate increase in the uptake of SQL Server 2008 Reporting Services and so I'm happy to say...
Posted by sqldbatips | with no comments
Filed under: , ,
16 April 2009 07:33

Cumulative update package 1 for SQL Server 2008 Service Pack 1 now available

Cumulative update package 1 for SQL Server 2008 Service Pack 1 KB Article Cumulative Update 1 for SQL Server 2008 Service Pack 1 (SP1) contains only hotfixes that were released in Cumulative Update 4 for SQL Server 2008. These hotfixes are not included...
Posted by sqldbatips | with no comments
Filed under: ,
08 April 2009 16:19

SQL 2008 Service Pack 1 RTM now available

Service Pack 1 for SQL Sevrer 2008 is now available (download link below). Two of the key features in this are the ability to slipstream the service pack with the RTM media to provide a prepatched install (which I tested during the CTP and seems to work...
Posted by sqldbatips | 1 comment(s)
Filed under: ,
07 April 2009 21:39

Updated build of ExpressMaint now available (1.8.0.0)

An updated build of the ExpressMaint utility for SQL 2005/2008 is now available. This release contains the following changes Added support for SQL Authentication Fixed an issue with databases that have not started being filtered out in Express Edition...
Posted by sqldbatips | with no comments
Filed under: , ,
07 March 2009 17:47

Updated build of ExpressMaint utility is now available (1.7.0.0)

An updated version (1.7.0.0) of the ExpressMaint utility for automating database maintenance operations for SQL 2005/2008 Express Edition is now available. This new version includes the following fix Fixed error when backing up instance with user instances...
Posted by sqldbatips | with no comments
Filed under: , ,
04 November 2008 18:17

Updated build of ExpressMaint utility is now available

An updated version (1.6.0.0) of the ExpressMaint utility for automating database maintenance operations for SQL 2005/2008 Express Edition is now available. This new version includes the following fixes Fixed error when database name contains an apostrophe...
Posted by sqldbatips | with no comments
Filed under: , ,
20 October 2008 20:01

View plus Synonym plus Linked Server plus Table equals Trouble

Whilst synonyms can be a very useful tool for abstraction I am a firm believer that they shouldn't change the behaviour of queries that use them, they should simply be alternative names for objects (local or remote). Recently I came across an issue...
Posted by sqldbatips | 2 comment(s)
Filed under: , ,
15 September 2008 20:37

SQL 2008 Unleashed

In the UK we had a Technet event at Microsoft Reading last Wednesday to celebrate the RTM of SQL Server 2008 (see more here ). It was a great day with lots of interesting and fun sessions highlighting some of the benefits and new features of SQL Server...
Posted by sqldbatips | with no comments
Filed under: ,
More Posts Next page »