Technical/Business Aspects in IT

A mix of SQL, VB6, .NET, business process modelling articles

Review of Reboot Technologies at Springfield Lakes for Microsoft certification

Posted by scmay on February 12, 2014

I recently took a Microsoft certification at Reboot Technologies and was not impressed with the location.

Cons

- 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.

Pros

- 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: , , , , | Leave a Comment »

The Quest for Software Requirements by Roxanne Miller

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
9781595980670

Chapter 1 – Requirements in Context
http://www.books24x7.com/toc.aspx?bookid=36578&chunkid=125925066&rowid=43&refid=DD5I6&gc=iiba

Posted in Uncategorized | Tagged: , , | Leave a Comment »

IIBA – Business Analyst Career Road Map

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: , , , , , | Leave a Comment »

IIBA Professional Day

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: , , | Leave a Comment »

SQL Saturday Brisbane

Posted by scmay on April 28, 2013

http://www.sqlsaturday.com/210/eventhome.aspx

1 zettabyte = 1 bil TB

Big Data – Volume, variety, velocity

MapReduce

Hadoop - Pig,  Hive, Sqoop

Introduction to SQL Server 2012 MDS and DQS - Peter Myers

  • Integration services – ETL
  • Master data services – data management
  • Data Quality Services – knowledge drive data cleansing
  • Image
  • 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
  1. candidate keys must be unique, non null
  2. index is created internally. SQL creates index as clustered by default.
  3. 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
  1. Appropriate clustering strategy
  2. PK declared
  3. Unique constraints declared
  4. FK declared & indexed
  5. 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: , , | Leave a Comment »

Control Privacy on Facebook Graph

Posted by scmay on February 16, 2013

I think Facebook Graph opens up the possibility of exposing photos of you, even those that you’ve successfully hidden on your timeline but still has that tag of you on the photo. There are several ways you can reduce your risk:-

  • Set your profile to searchable only by friends, and by people who know your friends. Hit the Settings icon on the far top right and click ‘Privacy Settings’
  • If you are not on Privacy, hit ‘Privacy’ on the far left.
  • Under ‘Who can look me up?’ you have 3 options
    • Beside ‘Who can look you up using the email address or phone number you provided?’ Select ‘Friends’ or ‘Friends of friends’.
    • Beside ‘Who can look up your timeline by name?’ Select ‘Friends’ or ‘Friends of friends’.
    • Beside ‘Do you want other search engines to link to your timeline? Uncheck this option.’ Facebook does not explicitly explain which search engine, so I will be pessimistic and say, it will be all the search engines you can think of. e.g. Google, yahoo, Bing, etc.
  • Next, on the far left hit ‘Timeline and Tagging’
  • Beside ‘How can I manage tags people add and tagging suggestions?’
    • Beside ‘Review tags people add to your own posts before the tags appear on Facebook?’ Click ‘Edit’
    • Select ‘Enabled’
    • This means that whoever tags you on a photo, Facebook will send you a notification to ask for approval.

What about photos that have you tagged especially the old photos? When you make your profile non-searchable by the public, they cannot use Facebook Graph and go ‘Photos of [name]‘. If you have set your settings to ‘Friends of Friends’, people who are friends of your friend can still search via ‘Photos of [name]‘. This brings up photos tagged of you by friends, even if you have selected ‘Hidden from Timeline’.

My advise to you is to remove/untag the photo. If you are smart, you will set all your photo albums settings to ‘Friends’ too, and stop tagging all your friends on the picture to avoid them the hassle of untagging. While I understand the idea of tagging, Facebook’s indiscretion has brought more pain than joy to the users. Not to mention their ever-changing layout means that you have to re-learn where that ‘Privacy’ button has disappeared to, or risk your details being exposed.

I hope this post has shed some light and help you with your Facebook privacy settings. If you liked this post, please hit ‘Like’ or even better, share this with your friends & relatives. You never know, you might save someone’s life.

Any comments about my post, incorrect information in this post, please let me know.

Posted in Uncategorized | Tagged: , , , , , | Leave a Comment »

iMacro iOpus Facebook Remove All Photos Tagged of You

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: , , , , , | Leave a Comment »

iMacro iOpus Delete Facebook Own Post

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: , , , , , | Leave a Comment »

Update.

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: , , , , , | Leave a Comment »

Simple jQuery Ajax with database

Posted by scmay on October 15, 2012

Http://nareshkamuni.blogspot.com.au/2012/06/sample-example-of-jquery-autocomplete.html

 

Simple jquery Ajax withdatabase sample

Ill write more later 

Posted in Uncategorized | Leave a Comment »

 
Follow

Get every new post delivered to your Inbox.