Posted by scmay on September 24, 2013
Link to online library copy. You must be a member of IIBA in order to access this material.
The Quest for Software Requirements
by Roxanne E. Miller
MavenMark Books (c) 2009
Chapter 1 – Requirements in Context
Posted in Uncategorized | Tagged: ebook, IIBA, requirements | Leave a Comment »
Posted by scmay on September 9, 2013
IIBA has drew up a business analyst career road map [map1][map2], along with competency skillsets highlighted in their competency model, and you can take an assessment too.
Posted in business analysis | Tagged: ba, business analysis, Business analyst, career, IIBA, road map | Leave a Comment »
Posted by scmay on September 9, 2013
Documented in a simple Word document
BABOK Guide v3 – What impacts will it have on a BA’s career? (Kevin Brennan)
How Do I know What Questions to Ask (Roxanne Miller)
Agile Business Analysis (Kevin Brennan)
Posted in Uncategorized | Tagged: agile, BABOK, business analysis | Leave a Comment »
Posted by scmay on April 28, 2013
1 zettabyte = 1 bil TB
Big Data – Volume, variety, velocity
Hadoop - Pig, Hive, Sqoop
- Integration services – ETL
- Master data services – data management
- Data Quality Services – knowledge drive data cleansing
- versioning is for model, not for row/attribute.
- can only load from Excel if data is no more than 1,048,576 rows
- Data quality service – program > data quality client
- DB must be CLR enabled
Understanding SQL Server Indexing – Greg Low
- index type: clustered, non-clustered, XML, spatial
- composite index column order : ColA+ColB is different from ColB+ColA
- UNIQUE: Country name is unique too!
- RID/Clustered index lookups are costly.
- Basic design
- candidate keys must be unique, non null
- index is created internally. SQL creates index as clustered by default.
- TODO: Revisit system database and analyse the indexes.
- Foreign key: no index is automatically created, causes performance issues
- Data types – bit: can be indexed, filtered index will give you only the data you need.
- Data types – GUID: newid() does not make a good clustering key. newsequentialid() – pointless. is the next sequential id unique? nope.
- Data type – Identity columns: INT or BIGINT?
- Reasonable Design Strategy
- Appropriate clustering strategy
- PK declared
- Unique constraints declared
- FK declared & indexed
- Consider expected usage, actual usage.
Agile BI with SQL Server 2012- Mohamed Kabiruddin
Visualising with PowerPivot - Install Hive ODBC Driver. PowerView
GeoFlow for Excel
Programming with Visual Studio > Project type Analysis services tabular
Posted in Uncategorized | Tagged: brisbane, sql, sqlsaturday | Leave a Comment »
Posted by scmay on January 28, 2013
This might be useful to some. iMacro script to remove all photos that have tagged you.
Click here for script.
* Depending on how long it takes to load, might have to modify line 7 to wait longer. I have written to wait 10 seconds.
Posted in Uncategorized | Tagged: delete, facebook, imacro, photos, script, tagged | Leave a Comment »
Posted by scmay on January 27, 2013
This script is not perfect and has flaws.
It cannot delete posts which are links for some reason. You will have to modify line 8 Pos=13 to Pos=14 to skip that particular status.
This is to delete particular year, line 6 highlights the year 2011. This is because I wanted to keep my statuses for 2012 and 2013. Therefore I need to manually specify which year to select once all the post for 2011 has been successfully deleted.
This is using iMacro iOpus Pro version and not the bookmarklet (free) version. I am not sure if this works in the free version.
This script only deletes your own post on the wall, and not other types of post such as being tagged and etc.
Download script here
Posted in Uncategorized | Tagged: delete, facebook, imacro, iopus, post, script | Leave a Comment »
Posted by scmay on November 3, 2012
Work’s been busy. I thought it would be less work with so many changes, but instead its ramping up. We’ve decided to do BDDfy style, invented by Mehdi Khalili.
Mind boggling stuff, I’m still trying to get it right.
Running on parallel, I’ve been drawing high level process maps. Collapsing the entire operation process into one single A4 is tough. My eyes are wide open looking at all the processes. It’s been fun dabbling with process maps. I use Bizagi & Visio interchangably
Posted in Uncategorized | Tagged: .net, BDDfy, BPM, BPMN, process maps, programming | Leave a Comment »
Posted by scmay on October 15, 2012
Simple jquery Ajax withdatabase sample
Ill write more later
Posted in Uncategorized | Leave a Comment »
Posted by scmay on October 8, 2012
Cross-thread operation not valid: Control ‘btnNextVideo’ accessed from a > thread other than the thread it was created on
I have a PLAY button that is attached to an event handler that plays a video and disables several buttons. Upon finishing the last frame, it should enable the buttons again. This is where the error occurs, because I am in an event handler
Referring to here
I followed the Official Pattern by Microsoft
private SynchronizationContext synchronizationContext ;
this.synchronizationContext = SynchronizationContext.Current;
//the rest of your code
and then, when you need to do some thread-unsafe form actualizations you should use something like this:
textBoxOut.Text = "New text";
Posted in .net, C# | Tagged: error | 3 Comments »