Monthly Archives: February 2015

Using MS SQL Server to work with assemblies (CLR)

A brand new video uploaded on YouTube on how to use CLR assemblies in MS SQL Server. Please share and like and we look forward to comments.

https://www.youtube.com/watch?v=5sOlIIC-UXg

Oops !!! we forgot the link last time

BTW Did you check out our new website !!! built in 24 hours it reflects our new design philosophy

Helpful post on changing wordpress site file upload limit

Recently while migrating a client’s wordpress site from wordpress.com to Amazon AWS we encountered a peculiar problem which should not happen in the real wolrd. The client blog has been around for about a year and had a lot of content on it. When trying to import the content into the WordPress application we encountered the issues where it said the files size exceeded 2 MB ( which is very small for a blog) . In order to overcome this issue we need to change a setting in the php.ini file the details of which are available in the below link.

https://wordpress.org/support/topic/change-maximum-upload-size-and-find-phpini

Training DBA from other countries

Technology is a universal language so training DBAs from other countries is not really a challenge when covering technical aspects. But here are a few things to keep in mind.

Time zones- lunch breaks are different for different people.

Office hours – Availability of daylight usually impacts office hours and typically there is a difference between winters and summers.

Cultural sensitivity – while technical trainings usually don’t have a lot of off topic discussions it’s important to use the right examples or analogies

Hands on – when doing trainings online it makes sense to test the lab setup from the participants point of view since they are located elsewhere and network connectivity and the availability of toll free numbers play a crucial role

Make it interactive – Classroom trainings have the advantage of keeping the participants in the room so there is more opportunities to bring back attention if a few people drift off. In online trainings its important to make sure nobody drifts off in the first place.

Share your webcam – Seeing the trainer allows participant to connect better and relate with the trainer, additionally the best trainers usually use a lot of hand movements which are lost when webcam is not shared

Stick to timings- structure is important since it’s easy to lose track of time and convert the training into a meeting without knowing it

These are just a few basic things I noticed over time and probably could be useful for others too.