07.26.06
Posted in Programming at by chenty
Because I installed my first SQL Server 2005 copy co-existed with SQL Server 2000, I did not realize there was no SQL Server Service Manager (The tiny systray icon that allows you to start/stop SQL services) comes with SQL Server 2005. I then searched all SQL Server 2005 folders, but I could not find that utility anymore. After searching over the Internet, I found several solutions:
1. Just move on with the new tool — SQL Server Configuration Manager, which can be found under “Programs -> Microsoft SQL Server 2005 -> Configuration Tools”. In this tool, extends “SQL Server 2005 Services” and you can start/stop the server.
2. If you are on a development server and you really want a systray icon for your convenience, you can use a third-party tool called “SQL 2005 Service Manager”. The interface is almost identical to the original tool. Here is the link:
http://www.sqldbatips.com/showarticle.asp?ID=46
3. If you loves systray but cannot trust a third party tool. Do the following:
(1) Install SQL Server 2000
(2) Install SQL Server 2005
(3) Uninstall SQL Server 2000
You will find the unisntallation will not remove SQL Server Service Manager with SQL Server 2000. 
(I never say it is a good solution, but really up to you)
Permalink
07.07.06
Posted in Programming at by chenty
I have been learning SQL Server 2005 for the past several weeks. I started with basic by using free Microsoft e-learing courses, to get basic skills to administrative SQL Server 2005 and SSMS (SQL Server Management Stuidio). The reason I like SQL Server 2005 over 2000 is SSMS. It provides much better features than Query Analyzer and other tools in SQL Server 2000.
After deciding upgrade system to SQL Server 2005, there was one problem. We were using DTS to import/export business data, but SQL Server 2005 has upgraded DTS to SQL Server Integration Service (SSIS). Therefore, I have spent the past 2 weeks on SSIS. The bad news is there are not many books I can read at the moment. I picked up “Professional SQL Server 2005 Integration Services” By Brian Knight (Wrox). It is quite discouraging after I saw other readers post such negative comments on this book. I went through First 5 chapters and gave up at chapter 6 (very hard to follow after that chapter). However, the first 5 chapters are enough for me to understand SSIS and I finally finished the new import/export package this week.
I will start take on SQL Server 2005 Analysis Services (SSAS) now, and Reporting Services after I am done with SSAS. From my past few weeks experience, SQL Server 2005 is quite a powerful upgrade from SQL Server 2000. As a developer, SQL Server 2005 provides much more features and tools to me. It even motivates me to take on new Microsoft certifications on IT Professional and Developer. This may advance my career towards data warehousing and business intelligence (BI). I may not even have time to write my blog because there is so much to read and learn now!
Permalink
