Browse by Tags

All Tags » General (RSS)

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: , ,

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

Very forgiving T-SQL parser behaviour

One of the thinks I like about working with SQL Server is that there's always something new to learn. Sometimes, as in this case it doesn't have much of a practical benefit. Whilst running a trace on a database application to troubleshoot why...
Posted by sqldbatips | 1 comment(s)
Filed under:

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: ,

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:
More Posts Next page »