Wednesday, 30 December 2009

Useful Webistes for SQL BI Guys

Hi,
I have collected some of useful SQL BI websites......
http://arcanecode.com/2009/11/18/populating-a-kimball-date-dimension/
http://www.sqllion.com/category/ssis/

SSIS Calling a WebService


http://pedrocgd.blogspot.com/2009/11/bi-stepbystep-ssis-calling-webservice.html
SQL SERVER Reporting Services FAQ's
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/48de91f9-1844-40c1-9614-5ead0b4b69a5
http://blogs.msdn.com/sqlrsteamblog/

DATA MODELLING
http://www.agiledata.org/essays/dataModeling101.html

SQL BI EVENTS AND WEB CASTS
http://www.microsoft.com/events/series/msdnsqlserver2008.aspx

SQL SERVER ANALYSIS SERVICES WEBSITES
http://www.sqlserveranalysisservices.com/default.htm
Top 10 SQL Server Integration Services Best Practices
http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx
SQL BI
http://www.learnitfirst.com/blogs/NewVideos/2008
http://www.ssistalk.com/
http://www.sqlservercentral.com/
http://www.pragmaticworks.com/
http://www.1keydata.com/sql
http://www.sql-tutorial.net/
http://www.sqlmag.com/
http://www.sqlsaturday.com/
http://blog.sqlauthority.com/2007/11/04/sqlauthority-news-best-articles-on-sqlauthoritycom/
http://blog.sqlauthority.com/
http://www.simple-talk.com/
www.sqlmag.com/
http://www.dtsxchange.com/
http://www.sql-tutorial.com/
http://www.ssw.com.au/Ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx
http://www.sqltraining.org/
http://technet.microsoft.com/hi-in/library/cc917721(en-us).aspx
http://www.jumpstarttv.com/
SSIS
http://blogs.conchango.com/
www.learnintegrationservices.com/
http://www.ssistalk.com/
SSIS Vedios
http://msdn.microsoft.com/en-us/library/dd299421.aspx
http://www.pragmaticworks.com/
http://www.jumpstarttv.com/channels/SQL.aspx
http://www.sqlservercentral.com/
www.learnintegrationservices.com/
http://msdn.microsoft.com/en-us/library/dd299413.aspx

PPS
http://technet.microsoft.com/en-us/office/performancepoint/default.aspx

SQLBI BOOKS
http://books.google.co.in/books?id=N7tzbajkNccC&pg=PA201&dq=SSIS+2005#PPA1,M1

Microsoft Virtual Labs:

http://www.microsoft.com/events/vlabs/default.mspx
http://msdn.microsoft.com/en-us/virtuallabs/cc138238.aspx
http://www.beansoftware.com/ASP.NET-Tutorials/Control-Template.aspx
http://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-data-validation-workbench/
http://www.sommarskog.se/arrays-in-sql-2005.html
http://www.msevents.microsoft.com/
http://www.microsoft.com/events/series/bi.aspx?tab=virtuallabs
http://www.microsoft.com/sqlserver/2008/en/us/white-papers.aspx

Hide/show property in SSRS:

URL=http://theruntime.com/blogs/thomasswilliams/archive/2008/09/29/hiding-and-showing-columns-based-on-a-parameter-in-reporting.aspx

MOSS
Downloading Excel files from SharePoint using SSIS
http://sqlblogcasts.com/blogs/drjohn/archive/2007/11/04/downloading-excel-files-from-sharepoint-using-ssis.aspx

WHITE PAPER: Scorecards and Dashboards for IT http://download.microsoft.com/download/3/5/8/35802290-a7f6-4976-8855-74c8b3b7f035/ITOperationsScorecardsandDashboards_whitepaper.doc
Thanks,
Narasimha

No comments:

Post a comment