Tarik さんのプロフィールTour In Developer Lifeブログリストつながり ツール ヘルプ

ブログ


Upgrade From SQL Server 2000 To SQL Server 2005


Upgrade Always Is Painful Decision For Both Managers and Developers , For Managers It Is About The Cost and , Technical Need and Support
For Developers It Is a Little Fear From Change And Starting Over Again To Learn New Technology , New Start Is Always Difficult But The Wisdom Says "Journey Of 1000 Mile Starts With a Single Step"
When I Was Looking At Some Articles I Got This Link To Help Upgrade From MS SQL Server 2000 To MS SQL Server 2005 (Yokon)
SQL Server 2005 Upgrade : Technical Reference Guide

Also You Can Use Another Helper Guide For The Upgrade
Microsoft SQL Server 2005 Upgrade Advisor


Automated Testing Software and SQL Server Source Control

Through My Search Today, I Found Strange Ad Aasking For ASP.NET Testing For 5000$ , Yes You Read The Number Right , That Made Me Surprise For That And Let Me Search For The Automated Search Tool Mentioned In The Ad , I Found a Nice Site Automated Testing Specialists Has Many Links To Testing Tools,White Papers and Articles About Testing
Also I Was Searching For Search Control Software To Integrate It With MS SQL Server 2000 , I Got Some Sites Talking Or Demonstrating Solutions

Related Articles:

Related Software :

Enjoy Your Time and Send Your Comments

SQL Mail Experiment Failed

Today Mornning me and my cousin began to try SQL Mail , First he made me an account on MS Exchange (MS Mail Server) on his PC , i tried to join the domain(On my cousin PC) so i can use the SQL Mail when doing other steps descriped in microsoft article

we failed to do so , my pc (Which holds the MS SQL Server) could not feel the domain and i could even use the exchange account from the url http://MailServerName/Exchange

my cousin thinks that the problem from the DNS , it may be corrupted , i think i may late trying this feature later

References Installing and Configuring SQL Mail

How to set up SQL Mail with an Internet Mail Server by using Outlook 2002

INF: How to Configure SQL Mail

SQL MAIL and SQL Agent Mail using POP3 and SMTP

I do not think some one may ask me why using SQL Mail , why do you think i shall use SQL Mail ?

T-SQL (Transact SQL) Coding Guidelines

Most developers know that T-SQL is microsoft SQL implementation in MS SQL Server, it is the backbone programming language to develop server side database and database objects (stored provedures,views ,triggers and UDFs)
Each developer provides some coding guideline when writting his code , this is and important point in development , we can notice it specially with those developers work in team or in company where the company obligy them to meet its coding guideline to ease code maintainance for any devloper would complete the work later

What is the suitation here ?
ok T-SQL is not an exception , as DB developer you have to take care of coding guidelines, Best practice introduced from microsoft , if you annoy with rules so please do not read T-SQL Coding Guideliness
T-SQL Coding Standards

Microsoft did not leave you withou support in this case , as usual microsoft has introduced a nice tool to verify the implementation of common Best Practices on your servers.
Best Practices Analyzer Tool for Microsoft SQL Server 2000 1.0

Ok now i'd like to sleep or get little rest , Big kisses fo you people