Posted by scmay on February 12, 2014
I recently took a Microsoft certification at Reboot Technologies and was not impressed with the location.
- No one at reception upon 30mins early arrival.
- PC could not load my record. Started the exam 20mins late from scheduled.
- PC monitor too small. Most of my questions had 3 frames, top, left and right and there was just not enough monitor space to accommodate all.
- PC too slow. The refresh rate was so slow that you could see the flicker each time you click something. That is pretty slow.
- Thin walls. You could hear any conversation going on outside. Not good for exam concentration.
- Ample free parking since it is in a shopping mall.
- The only place in Brisbane that lets you take the exam on a Saturday.
I am going to try another location for my future exams.
Posted in Uncategorized | Tagged: .net, certification, exam, microsoft, reboot technologies | Leave a Comment »
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 »