Browse by Tags

All Tags » General (RSS)

Processadmin server role broken by SQL2005 Cumulative Update 3

After you apply SQL 2005 Cumulative Update 3 (3186), members of the processadmin fixed server role can no longer kill spids (which since that is all that role allows you to do effectively makes it useless). This is supposedly fixed in Cumulative Update...
Posted by sqldbatips | with no comments
Filed under: ,

Latest version of SQL 2005 BOL now available for download

The SQL 2005 September 2007 BOL update is now (finally since it's almost December!) available for download. You can download it from the link below Download SQL 2005 BOL September 2007 Update
Posted by sqldbatips | 1 comment(s)
Filed under: ,

SQL 2008 November CTP now available

The November CTP of SQL Server 2008 is now available for download at the link below Download SQL 2008 November CTP There's a lot of new functionality and features in this latest CTP including (but not limited to) Backup Compression Resource Governor TSQL...
Posted by sqldbatips | with no comments
Filed under: ,

sqldbatips.com tools and source code now available on Codeplex

I'm happy to announce that 2 of the most popular tools on sqldbatips.com are now available on Codeplex including full source code . I've set up projects for SQL 2005 Service Manager and for Expressmaint. Downloads will still be available on both sqldbatips...
Posted by sqldbatips | with no comments
Filed under: ,

Registration for UK SQLBits Conference 2007 now open

On the 6th October 2007 there will be a FREE UK SQL Server conference held at Microsoft HQ in Reading . Details of the proposed sessions and speakers are now up on the SQLBits.com site and you can now register on the site as well. Places are limited to...
Posted by sqldbatips | with no comments
Filed under:

SQL Server 2008 ("Katmai") June CTP now available for download

You can now download the June CTP of SQL Server 2008 ("Katmai") from the Microsoft Connect site . Downloads are available in executable or iso format and x86 and x64 versions. The June CTP of SQL Books Online (BOL) is also available. Note that you do...
Posted by sqldbatips | 1 comment(s)
Filed under: ,

SQL Server 2005 Virtual Labs

The SQL 2005 Virtual labs , available for free on MSDN, are a great resource for learning about SQL Server 2005. Whilst everyone pretty much has a copy of SQL Server 2005 Developer Edition or Express Edition to learn on, not everyone has the time or resource...
Posted by sqldbatips | with no comments
Filed under:

SQL Server Samples and Community Projects on CodePlex

Microsoft SQL Server Samples & Community Projects Codeplex is the project hosting site for Microsoft SQL Server Samples and Community Projects. The portal page for SQL Server on Codeplex catalogs samples included with Product Releases, samples from...
Posted by sqldbatips | with no comments
Filed under: ,

Submitting SQL Server Feedback on Connect

If you're not already aware, you can submit bug reports and suggestions for product improvements on the SQL Server Connect Website . You can also vote on and validate other users bugs and suggestions. One thing I've noticed is that a lot of people are...
Posted by sqldbatips | with no comments
Filed under:

SQL Server 2005 Service Pack 2 Rereleased

As a response to the bug introduced in SP2 with regard to maintenance plan cleanup tasks ( KB 933508 ) Microsoft have released an updated build of SQL Server 2005 SP2 which replaces the originally released service pack. The updated release is available...
Posted by sqldbatips | 2 comment(s)
Filed under: ,

SQL Product Team blogs

Paul Randal has compiled a list of over 40 blogs from the SQL Server product team. It's great to see and there's a lot of extremely useful and informative content available, in fact it's pretty hard keeping upto date with them all!
Posted by sqldbatips | 1 comment(s)
Filed under:

Estimating vardecimal storage savings in all databases

One of the new features in SQL Server SP2 is the vardecimal storage format which can be used to significantly reduce the space required by decimal and numeric columns in a table at the cost of a small CPU overhead. The storage savings must be balanced...
Posted by sqldbatips | with no comments

SQL 2005 Service Pack 2 now available

Get it while it's hot! Download SQL 2005 Service Pack 2 Readme for Microsoft SQL Server 2005 Service Pack 2 What's New in SQL Server 2005 SP2 A list of the bugs that are fixed in SQL Server 2005 Service Pack 2 Download SQL 2005 Books Online Feb 2007 ...

Welcome to my ramblings!

Well I've finally conceded to peer pressure and started writing a blog. For info about me see the About section of the blog but in short my name is Jasper Smith, I'm a SQL Server MVP and I also run sqldbatips.com . Thanks to Tony for hosting and Simon...
Posted by sqldbatips | 1 comment(s)
Filed under: