toddmcdermid.blogspot.com

ozziemedessql.blogspot.com

Ozziemedes on SQL Server: Data Infrastructure Architecture [2/2]

http://ozziemedessql.blogspot.com/2010/08/data-infrastructure-architecture-22.html

August 23, 2010. Data Infrastructure Architecture [2/2]. Yesterday I wrote a fairly long blog post which started to delve into some of the questions addressed by data infrastructure architecture. After writing more than 2000 words I decided it was time to give you all a break and for me to have some time away from the keyboard. So here’s the second instalment in which I’ll outline the remaining concerns for the data infrastructure components of data architecture. Data platform performance management.

ozziemedessql.blogspot.com

Ozziemedes on SQL Server: Data Architecture Defined

http://ozziemedessql.blogspot.com/2010/08/data-architecture-defined.html

August 22, 2010. The core concerns of IT architecture can be summarized using the acronym “BATOG”, defined as follows:. Business – Who is paying for the solution? 160; What is the total budget? 160; What is the expected ROI period? 160; What business efficiencies is the solution expected to deliver? Applications – What software packages is required to deliver the required outcomes? 160; Do they need to be customized? 160; Or are they being built from scratch? 160; How do you make them work together?

ozziemedessql.blogspot.com

Ozziemedes on SQL Server: Musings on Good Data Architecture

http://ozziemedessql.blogspot.com/2010/08/musings-on-good-data-architecture.html

Rel='image src'/ ' property='og:image'/. August 12, 2010. Musings on Good Data Architecture. I was at a user group meeting. So… how do we deal with these entrenched dependencies? 160; There are a few different approaches, each of which might be more appropriate on a case-by-case basis based on their cost of implementation, support and ongoing ownership. Outlined for me by Paul Stovell. At the recent CodeCampSA. Tactical” applications need to honour corporate standards for message format and data co...

bimonkey.com

IAPA 2014 Salary Survey | BI Monkey

http://www.bimonkey.com/2015/01/iapa-2014-salary-survey

Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. IAPA 2014 Salary Survey. January 13, 2015. The IAPA salary survey. Came out a couple of months back, and though it is Analytics focused it has some interesting results for those of us in the BI world. My key takeaways follow. Despite all the market enthusiasm, a significant proportion of respondents said there is an ongoing challenge reported that analysts struggle to get their organisation to value or act ...

bimonkey.com

Managing complex security in SSAS Tabular | BI Monkey

http://www.bimonkey.com/2015/03/managing-complex-security-in-ssas-tabular

Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. Managing complex security in SSAS Tabular – Yeah Nah edition. March 15, 2015. A couple of times recently I have come up against requirements which have required some fairly complex logic to apply security. One involved some fairly gnarly relationships coming from multiple directions, the other involved grinding through Hierarchies from parent nodes down to permitted viewable children. Do it in the Cube?

bimonkey.com

Migrating Package Connections to Project Connections in SSIS | BI Monkey

http://www.bimonkey.com/2015/04/migrating-package-connections-to-project-connections-in-ssis

Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. Migrating Package Connections to Project Connections in SSIS. April 27, 2015. However a recent task I got handed was to migrate a 2008 project to the 2012 project model. All very sensible, to ease maintenance, eliminate XML configurations and generally bolster security. Then I got to work…. Converting a Package Connection to a Project Connection. You have a project connection! Fortunately thanks to this post.

bimonkey.com

Agile | BI Monkey

http://www.bimonkey.com/tag/agile

Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. The fine art of starting to adopt Agile with a Zero sprint. March 18, 2015. Agile methodologies have a patchy track record in BI/DW projects. A lot of this is to do with adopting the methodologies themselves – as I’ve alluded to in prior posts there are a heap of obstacles in the way that are cultural, process and ability based. What is this Zero sprint anyway? How to structure and sell the Zero sprint.

bimonkey.com

Productivity issues for Agile in BI/DW - part 1: People | BI Monkey

http://www.bimonkey.com/2015/01/productivity-issues-for-agile-in-bidw-part-1-people

Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. Productivity issues for Agile in BI/DW – part 1: People. January 15, 2015. Productivity nirvana is hard to find. Meditations on the path. Once again its about people. A topic I like to hammer home is that most of your project concerns are not technical or process driven – it’s all about people, specifically people’s ability and willingness to adapt and learn. Picking team members who c...Required fields are...

bimonkey.com

Azure | BI Monkey

http://www.bimonkey.com/tag/azure

Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. Download data from a Hadoop on Azure cluster. August 29, 2012. January 18, 2013. So you’ve run a job on Hadoop on Azure, and now you want that data somewhere more useful, like in your Data Warehouse for some analytics. If the Hive ODBC Driver. Isn’t an option (perhaps because you used Pig), then FTP is the way – there isn’t a Javascript console fs.get() command available. As described in my Upload data.

rad.pasfu.com

Reza Rad's Technical blog

http://rad.pasfu.com/index.php?/categories/11-Publications

Reza Rad's Technical blog. My technical scripts on MS BI, SSIS, SSAS, MDS, DQS and Programming, and news about technical presentations and publications. Free Online MS BI Video Tutorials. Business Intelligence Developer 2008. SQL Server 2008, Business Intelligence Development and Maintenance. SQL Server 2008, Implementation and Maintenance. SQLBits is Awesome, But I cannot Attend! Referring SSIS Variables from SSIS Script Task. Introduction to Azure Data Factory. Power BI Now Available For Free! Comments...