13 Jun 2007
MSSQL Resources
Web Sites
- SQL Server Central, especially the links section
- SQL Junkies. Good article on Troubleshooting Endpoints
- SQL Skills.com (Kimberley Tripp) – especially the Resources section – whitepapers, articles, etc
User Groups
- SQL Down Under
- Australian SQL Server User Group – especially the Resources section
- Sydney .NET Users Group
- sql@informare.com.au (email list)
Podcasts/Webcasts
Useful addins
- AnkhSVN – Subversion source code control plugin for Visual Studio
- Log PI and Log Explorer – both allow manipulation of SQL Server logs eg remove a single transaction
- PromptSQL – provides SQL Intellisense style word completion for various Microsoft SQL editors, and UltraEdit
- ReSharper – features such as intelligent coding assistance, on-the-fly error highlighting and quick error correction, support for code refactoring
- Reflector – allows you to view, navigate, search, decompile and analyze .NET assemblies. Other tools also on the same site.
- Quest Spotlight – “Spotlight on SQL Server Enterprise provides an agent-less easy-to-use database issue discovery solution that enables you to identify and resolve SQL Server performance problems within your SQL Server environment.“
XML Tools
- xsd, xslt, etc tools in MS Visual Studio 2005
- oXygen XML editor
- Altova xmlspy
- tools in UltraEdit
Blogs
- CLR Integration
- SQL Server Engine Tips
- Microsoft SQL Server Development Customer Advisory Team
- SQL Protocols
- SQL Server Relational Engine Manageability Team Blog
- Tips, Tricks, and Advice from the SQL Server Query Optimization Team
- Ian Jose’s WebLog
- Slava Oks’s WebLog
- Ken Henderson’s WebLog
- Engine Watch
- Mandar’s WebLog