top 3 tools beside VS

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&gid=43315&discussionID=6280586&split_page=1

Adomdclient dll

For SQL 2008, you will get ADOMD client installer here...
http://www.microsoft.com/downloads/thankyou.aspx?familyId=228de03f-3b5a-428a-923f-58a033d316e1&displayLang=en

once you install the above installer you will get
Microsoft.AnalysisServices.AdomdClient.dll
at under the below location
C:\Program Files\Microsoft.NET\ADOMD.NET\100

documentation tool for SQL Analysis Services

http://bidocumenter.com/Public/Default.aspx


http://www.ssas-info.com/VidasMatelisBlog/144_using-ssrs-to-report-ssas-2008-database-structure-using-dmvs

http://www.elsasoft.org/download.htm

Multiple Update in SQL 2008

Problem:
1) Table AAA with null ID and other info
2) Table BBB with ID and other info
3) get the matching data with ID from table BBB to AAA

Solution
1) SQL cursor approch -- I'd avoid
2) SQL Temp table approch -- good & quick

Here is the SQL script for (2) approch:

(1)
create table #tempdata (
firstname varchar(50),
lastname varchar(50),
dob datetime,
id uniqueidentifier
)

insert into #tempdata
select b.FirstName,b.LastName,b.BirthDate, b.id
from
AAA a,BBB b
where
a.FirstName = b.FirstName
and a.LastName = b.LastName
and a.DOB = b.birthDate

select * from #tempdata

--update statement

update AAA
set id = #tempdata.id from #tempdata where
AAA.FirstName = #tempdata.FirstName
and AAA.LastName = #tempdata.LastName
and AAA.DOB = #tempdata.dob


enjoy

ted

http://thirteen23.com/experiences/desktop/ted/

XML notepad

good tool...

http://www.codeplex.com/xmlnotepad