Showing posts with label online. Show all posts
Showing posts with label online. Show all posts

Wednesday, March 28, 2012

Help on Reporting services

Hi, I am new to reporting services 2005 express. Is there a website, SDK, or any other source for help (online and offline) on reporting services so that it can be used for help while creating reports or for learning purposes?

Regards, Sandy

When you install reporting services it asks you whether to install books online, samples etc.

If you mark that option, you will have installed some sample reports which some of them are deployed on the sql server - they will appear on the 'Microsoft Sql Server 2005' tab as a new sub-tab 'Reporting services'

There is also some source code illustrating how to access deployed reports.

Cheers,

Yani

Monday, March 26, 2012

help on learning stored procedures

Can anyone tell me about some good online tutorials for learning stored procedures in SQL Server 2000?

Any help will be greatly appreciated.

Thank You.it's not a matter of learnign 'stored procedures' as learning SQL, or more specifically T-SQL

try www.sqlteam.com

Friday, March 23, 2012

Help on ETL

Hi,
I'm still new to datawarehousing and right now I'm stuck on ETL. So can
anybody give me some links to a good online resurces about ETL technics.
Thanks,
Marius
Marius,
I have publushed the C (and cobol) code you need to emulate to load large
star schema DWs on my personal web page www.peternolan.com. Can't do much
more for free than publish the code you need to emulate..;-)
I have also published a lot of other materials there...
If you are using SQL Server you might want to use DTS.
Best Regards
Peter
"Mark00" <mstoncius@.hotmail.com> wrote in message
news:O%23yTWoydFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I'm still new to datawarehousing and right now I'm stuck on ETL. So can
> anybody give me some links to a good online resurces about ETL technics.
> Thanks,
> Marius
>
|||Hello Mark,
Check out the following links. These will help you get started using
DTS as an ETL development platform.
The link below is a great overview of DTS designer
http://www.sqldts.com/default.aspx?278
DTS white papers
DTS Programming Techniques Used in Microsoft SQL Server Accelerator for
Business Intelligence
http://msdn.microsoft.com/library/de..._dts_ssabi.asp
Best Practices for Using DTS for Business Intelligence Solutions
(updated web version)
http://msdn.microsoft.com/library/de...tbpwithdts.asp
Hope this helps
Myles Matheson
Data Warehouse Architect
|||C and COBOL? Are the comments written in King James english?
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:e5%23ano0dFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Marius,
> I have publushed the C (and cobol) code you need to emulate to load large
> star schema DWs on my personal web page www.peternolan.com. Can't do much
> more for free than publish the code you need to emulate..;-)
> I have also published a lot of other materials there...
> If you are using SQL Server you might want to use DTS.
> Best Regards
> Peter
> "Mark00" <mstoncius@.hotmail.com> wrote in message
> news:O%23yTWoydFHA.3808@.TK2MSFTNGP14.phx.gbl...
>
|||Hi JT,
That's the 'free' stuff that includes many of the features needed to
build a DW...we used it in many clients in the 90s.....(I've been
doing DWs since 1991 when C++ was a novelty and Java was a long time
from being invented...and cobol was still lingua franka of all
computing....) I published it because I am often asked how to build
the ETL code to load type1/2 dimensions, facts, summaries etc....my
answer was..."here is the code you need to replicate the functionality
of for free." I can't do much more than that for
free...(LOL)....also, because there are so many ETL tools, and they
have collapsed their processing and data structures, it's almost
pointless to publish code that loads DWs in any particular tool. I
released templates for loading Sybase IWS in DataStage and Informatica
and got absolutely no interest in them at all...which surprised me....
The advanced C++/ODBC current version of our software that runs across
a variety of platforms, is not free so it's not published...;-) Though
I have published a lot of the source code for the free utilities my
company has released.....email me if you want the address of our
company. my personal email is peter@.peternolan.com. I don't want to be
putting my company address here...to much like advertising and I don't
want to do that here...
You might not believe this, but I believe there is still more cobol
code out there than C++/Java/VB etc put together.....all speaking King
James english... (LOL)!!!
Peter

Help on ETL

Hi,
I'm still new to datawarehousing and right now I'm stuck on ETL. So can
anybody give me some links to a good online resurces about ETL technics.
Thanks,
MariusMarius,
I have publushed the C (and cobol) code you need to emulate to load large
star schema DWs on my personal web page www.peternolan.com. Can't do much
more for free than publish the code you need to emulate..;-)
I have also published a lot of other materials there...
If you are using SQL Server you might want to use DTS.
Best Regards
Peter
"Mark00" <mstoncius@.hotmail.com> wrote in message
news:O%23yTWoydFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I'm still new to datawarehousing and right now I'm stuck on ETL. So can
> anybody give me some links to a good online resurces about ETL technics.
> Thanks,
> Marius
>|||Hello Mark,
Check out the following links. These will help you get started using
DTS as an ETL development platform.
The link below is a great overview of DTS designer
http://www.sqldts.com/default.aspx?278
DTS white papers
DTS programming Techniques Used in Microsoft SQL Server Accelerator for
Business Intelligence
http://msdn.microsoft.com/library/d...
dts_ssabi.asp
Best Practices for Using DTS for Business Intelligence Solutions
(updated web version)
http://msdn.microsoft.com/library/d...ntbpwithdts.asp
Hope this helps
Myles Matheson
Data Warehouse Architect|||C and COBOL? Are the comments written in King James english?
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:e5%23ano0dFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Marius,
> I have publushed the C (and cobol) code you need to emulate to load large
> star schema DWs on my personal web page www.peternolan.com. Can't do much
> more for free than publish the code you need to emulate..;-)
> I have also published a lot of other materials there...
> If you are using SQL Server you might want to use DTS.
> Best Regards
> Peter
> "Mark00" <mstoncius@.hotmail.com> wrote in message
> news:O%23yTWoydFHA.3808@.TK2MSFTNGP14.phx.gbl...
>|||Hi JT,
That's the 'free' stuff that includes many of the features needed to
build a DW...we used it in many clients in the 90s.....(I've been
doing DWs since 1991 when C++ was a novelty and Java was a long time
from being invented...and cobol was still lingua franka of all
computing....) I published it because I am often asked how to build
the ETL code to load type1/2 dimensions, facts, summaries etc....my
answer was..."here is the code you need to replicate the functionality
of for free." I can't do much more than that for
free...(LOL)....also, because there are so many ETL tools, and they
have collapsed their processing and data structures, it's almost
pointless to publish code that loads DWs in any particular tool. I
released templates for loading Sybase IWS in DataStage and Informatica
and got absolutely no interest in them at all...which surprised me....
The advanced C++/ODBC current version of our software that runs across
a variety of platforms, is not free so it's not published...;-) Though
I have published a lot of the source code for the free utilities my
company has released.....email me if you want the address of our
company. my personal email is peter@.peternolan.com. I don't want to be
putting my company address here...to much like advertising and I don't
want to do that here...
You might not believe this, but I believe there is still more cobol
code out there than C++/Java/VB etc put together.....all speaking King
James english... (LOL)!!!
Peter