August 2009 - Posts

Microsoft SQL Server 2008 Release 2 (R2), formerly known as SQL Server Code-Named “Kilimanjaro”, is the next release of Microsoft SQL Server. Books Online is the primary documentation for SQL Server. Download a pre-release preview of Books Online for SQL Server 2008 R2 here

Important Installing SQL Server 2008 R2 Books Online upgrades your existing SQL Server 2008 version of Books Online. If you upgrade, be aware that the content and help topics now describe tools and features of SQL Server 2008 R2. To reinstall SQL Server 2008 Books Online, you must first uninstall SQL Server 2008 R2 Books Online. Because SQL Server 2008 and SQL Server 2008 R2 share components, you cannot have side-by-side installations of Books Online on the same machine.

Note This pre-release version of SQL Server Books Online may contain topics that are empty, incomplete, or not up to date. Topics for new features may be missing and not all new or updated content has been reviewed for technical accuracy.

Posted by sqldbatips | with no comments
Filed under: ,

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

SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 to help your organization scale with confidence and improve IT and developer efficiency with new and enhanced tools for application and multi-server management, master data services and complex event processing. The new Self Service BI capabilities will empower end users to access, integrate, analyze and share information using business intelligence tools they already know – Microsoft Office.

The August Customer Technology Preview (CTP) includes Application and Multi-server Management which will help organizations manage database environments efficiently at scale with increased visibility and control across the application lifecycle. Microsoft SQL Server StreamInsight will also be made available for preview in the coming weeks. This new complex event processing technology will help businesses derive better insights by correlating event streams from multiple sources with near-zero latency.

The Fall 2009 CTP will include the remaining SQL Server 2008 R2 features including Master Data Services and Self Service Business Intelligence capabilities delivered in SQL Server Reporting Services and Project “Gemini”.

Posted by sqldbatips | 1 comment(s)
Filed under: , ,

If you install SQL 2005 Service Manager (Vista) on Windows 7 (the Vista version is required as it supports UAC) you will find that the system tray icon is hidden by default as part of the tidy up of the taskbar and notification/system tray area in Windows 7. You can customise the behaviour for a specific application by left clicking on the small triangle in the system tray area and clicking on the Customize... link as highlighted below

This will bring up the Notification Area Icons dialog and allow you to select the behaviour for SQL 2005 Service Manager which you can set to "Show icon and notifications" if you want the system tray icon for SQL 2005 Service Manager to remain in the system tray area at all times as shown below


Posted by sqldbatips | with no comments
Filed under:

I keep meaning to document these as I get quite a few emails asking about them so here are the possible return codes from the Expressmaint utility (and no, I don't know what happened to -1!)

 0      Success
-2      Error initialising log file
-3      Error connecting to SQL Server
-4      Error enumerating list of databases
-5      Error performing backup operation
-6      Error performing integrity check operation
-7      Error performing index operation
-8      Error performing stats operation
-9      Errors encountered but continue on error parameter set


Posted by sqldbatips | with no comments
Filed under: