Saturday, May 29, 2010
Friday, May 28, 2010
How to learn SSIS / SSAS / SSRS / Data Warehousing and start a career in Microsoft Business IntelligenceI'm reading: How to learn SSIS / SSAS / SSRS / Data Warehousing and start a career in Microsoft Business IntelligenceTweet this !
1) How to start a career in MS BI and what to learn - SSIS / SSAS / SSRS ?
2) Where to find books or training material to learn SSIS / SSAS / SSRS ?
3) Which certifications to take up for MS BI and why to get certified ?
4) How to pass an interview for a MS BI work profile, when one has got no experience in MS BI ?
5) How should I prepare for MS BI i.e. SSIS / SSAS / SSRS Interview and where can I get interview questions ?
6) Where can I get training on MS BI / SSIS / SSAS / SSRS ?
Thursday, May 27, 2010
Monday, May 24, 2010
I am not a very popular, big or well connected name in the industry, but I am trying to be at least a respected name :) I am well respected among my friends and colleagues at Capgemini for my work in my technical area, and now I am trying to put my knowledge to test and use for the entire technical community by the medium of my blog and other community websites. I am always up for sharing something new, that has not been published a million times on blogs, books and websites. Today my article on how to achieve spatial data support in ssis got published on sql-server-performance.com, and on this day I thought of summarizing a list of all the major articles that I have authored till date. Four of these articles also got featured on MSDN SSIS Community Buzz, and a few of them on multiple community websites. Below is the list is no specific order.
In case if you have read any of my articles, and have any feedback for me, please feel free to share it with me.
- Different Ways to Search for SQL Server Database Objects
- Using Microsoft Quadrant for data analysis and modeling
- Create a Simple SQL Server Database Server Object Report with Minimum Effort
- Decouple context specific logic from SSRS reports using facades in SQL Server
- How to enable SSIS as data source type on SQL Server Reporing Services SSRS 2008 R2
- How to use SSIS package as a data source for SQL Server Reporting Services 2008 R2
- How to connect to SQL Azure using SQL Server Reporting Services 2008 R2
- How to read and write data from SQL Azure using SQL Server Integration Services 2008 R2 (Featured on MSDN SSIS Community Buzz)
- How to make an SSIS Merge Join transformation fail-safe from sorting irregularities
- How to serialize error logging in SSIS
- Planning the SQL Server ETL implementation strategy using SSIS for Extracts
- Profiling SSIS packages for component level change tracking (Featured on MSDN SSIS Community Buzz)
- Trick to search a SQL Server SSIS package for tasks and transforms
- Achieve Spatial Data Support in SSIS
- Working with Spatial Data Part IV - Developing a Geospatial Dashboard (GIS)
- Working with Spatial Data Part III - Reporting Spatial data using Reports Builder 3.0
- Working with Spatial Data Part II - Plotting Shapes and Storing Geocoded Data (Featured on MSDN SSIS Community Buzz)
- Working with Spatial Data Part I - Geocoding Text-Based Spatial Data for Use In SSIS Packages (Featured on MSDN SSIS Community Buzz)
- Microsoft Business Intelligence Project Booster Kit
Saturday, May 22, 2010
Wednesday, May 19, 2010
1) Measuring and Understanding the Performance of Your SSIS Packages in the Enterprise
2) Tuning Your SSIS Package Data Flow in the Enterprise
Monday, May 17, 2010
Sunday, May 16, 2010
Thursday, May 13, 2010
Wednesday, May 12, 2010
1) Download Microsoft SQL Server Report Builder 3.0 for Microsoft SQL Server 2008 R2: This is top highlight as it brings the Map control and Bing Maps capabilities, Sparklines, Databars, and Report Parts Gallery.
2) Download Microsoft SQL Server PowerPivot for Microsoft Excel: Business users would not want to wait and download it ASAP and try out the potential of Powerpivot.
3) Download Microsoft SQL Server 2008 R2 Books On-line: My personal favourite. It's always advantageous to stay up-to-date with the latest reference material.
4) Download Microsoft SQL Server 2008 R2 Best Practices Analyzer: This latest best practice analyzer is available now. So stop playing with the old 2000 / 2005 version analyzer and get this shiny new analyzer for your shiny new R2 version of SQL Server.
5) This is not a part of the Feature pack, but I thought of mentioning it as it's a very valuable resource. It's a introductory level " Free SQL Server 2008 R2 Ebook ".
Above list is not the exhaustive list. Entire feature pack can be downloaded from here.