Thursday, October 14, 2010
How to apply Conditional Split in a SSIS package without using Conditional Split transform
I'm reading: How to apply Conditional Split in a SSIS package without using Conditional Split transformTweet this !Monday, May 24, 2010
List of my articles published on community websites till 24 May 2010
I'm reading: List of my articles published on community websites till 24 May 2010Tweet this !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
Monday, November 23, 2009
My first article on SQLServerCentral.com - Microsoft Business Intelligence Project Booster Kit
I'm reading: My first article on SQLServerCentral.com - Microsoft Business Intelligence Project Booster KitTweet this !It's not always that one himself / herself needs to be a super expert. Knowledge is always power and there's no doubt in it, but when you work in a team, you can't expect each and every team member having same level of expertise and the same speed of execution of development. So remaining within the boundaries of costs, as a team lead one needs to educate as well as facilitate oneself and team with tools and stuff that can boost up the development process and reduce time in tackling known challenges.
Microsoft Business Intelligence Project Booster Kit is my first attempt to share my experiences about a basic set of tools and documents / documenting methods which I term as "Booster Kit" that can help any development team with stuff they can use in their day to day work to help them gear their project faster directly / indirectly in the shorter / longer term at one / another phase of the project life-cycle.
If you came across my blog through my article on SQLServerCentral.com, please feel free to drop your valuable feedback a comment on this post. Also feel free to reach out to me on siddhumehta_brain@yahoo.co.in.
