2012 in review

The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.

Here’s an excerpt:

The new Boeing 787 Dreamliner can carry about 250 passengers. This blog was viewed about 1,600 times in 2012. If it were a Dreamliner, it would take about 6 trips to carry that many people.

Click here to see the complete report.

Issue: Length of LOB data to be replicated exceeds configured maximum 65536

Error:

Length of LOB data (78862) to be replicated exceeds configured maximum 65536

Scenario:

We published some articles that use varchar(max) and a lot of XML data types for the columns. When we enabled replication, we got the error Length of LOB data (78862) to be replicated exceeds configured maximum 65536

Solution:

Increase the size that can be replicated. This is applicable for transactional replication only.

T-SQL:  EXEC sp_configure ‘max text repl size’, 2147483647

SSMS (excerpt from BOL):

    1. In Object Explorer, right-click a server and select Properties.
    2. Click the Advanced node.
    3. Under Miscellaneous, change the Max Text Replication Size option to the desired value.

Reference:

BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/3056cf64-621d-4996-9162-3913f6bc6d5b.htm

Taken from: http://sqlmusings.wordpress.com/2008/09/22/issue-length-of-lob-data-to-be-replicated-exceeds-configured-maximum-65536/

70-480: Programming in HTML5 with JavaScript and CSS3 – Done

Hi,

Today, I took the 70-480: Programming in HTML5 with JavaScript and CSS3 – and cleared it. I thought it would be easy one, but it wasn’t – it had more than expected material coverage. As I can’t give specific details out, so I will make it short and general.

http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-480

  1. Study the Channel 9, Screencast from http://www.microsoftvirtualacademy.com/tracks/developing-html5-apps-jump-start
  2. Study HTML5 from Pluralsight
  3. JavaScript Inheritance, Anonymous methods
  4. Structuring JavaScript Code
  5. Exception Handling
  6. Ajax – JQuery
  7. Event Handling
  8. Binding Events
  9. CSS3, Padding
  10. Positioning in CSS
  11. Header, Aside, Semantics

I had very cool experience with the javascript, html and dhtml etc … so I got it through. But you should have some experience and had actually build some stuff with html/ html5/ javascript and jquery.

Having experience helps a lot.

Thanks,

Riz

JQueryUI – Showing New Menu Widget Horizontally

Showing JQuery menu Horizontally through CSS

I was trying the menu widget from JQuery UI. It looks good with lot of ability. But as usual i had to tweak it a little bit. You can check this at http://jqueryui.com/menu/#navigationmenu

Problem:

The menu on the demo site appears to be Vertical aligned – it grows vertically, and i would like it to be horizontal.

Like

Menu 1 – Menu 2 – Menu 3

Instead of

Menu 1

Menu 2

Menu 3

Solution:

So, for doing with minimal changes here is what you need to do, just define following css classes:

#menu li { display:inline-block; width: auto; }

#menu li.sub { display:block; width: auto;}

Where menu is the ul element for menu, and li (the sub menus, the second level) are marked with “sub” class. Here is the HTML markup for the reference.

display:inline-block; will render the li as inline – so they will appear in the same line side by side.

for Sub menu under each li you need to set them as “block”, so they appear vertically.

<ul id=”menu“>

<li><a href=”?Aberdeen”>Admin</a></li>

<li>

<a href=”?Ada”>Themes</a>

<ul>

<li class=”sub”><a href=”?Ada”>Default</a></li>

<li class=”sub”><a href=”?Saarland”>Test 2</a></li>

<li class=”sub”><a href=”?Salzburg”>Test 3</a></li>

</ul>

</li>

<li><a href=”?Adamsville”>Support</a></li>

<li><a href=”?Addyston”>Release Notes</a></li>

<li><a href=”?Addyston”>My Details</a></li>

</ul>

Hopefully, it will help people out.

UPDATED: http://jsbin.com/afepiz/31/edit (JSBIN)

Enjoy,

Thanks,

Riz

Updating JQuery 1.4+ (or older) to 1.7+ (“attr” replacement)

We were trying to update the Jquery from 1.4 to 1.7 to get new functions in and also to get better working with JQuery UI and with jqGrid.

Suddenly we hit a ROAD BLOCK! the Jquery decided to change the behaviour of method to soemthign different. We used attr function extensively in our app, so replacing it in 3000 location and than verifying it would mean lot of typos and QA effort. They changed it to prop !

So we just simply wrote and override to attr! and extended jQuery…

jQuery.fn.attr = function(a, b) {
if (a == null && a == undefined
&& b == null && b == undefined) {
return ;
}
if (a != null && b != null)
return $(this).prop(a, b);
if (a != null && (b == null || typeof (b) == “undefined”))
return $(this).prop(a);
}

copy this into your code and enjoy beauty of it…

New Module for FogBugz @ Time Management System

Time Management System

We have just built a new time management system for vanguard software group, that integrates seemlessly with fogbugz. http://www.fogcreek.com/fogbugz/

FogBugz is the world’s easiest bug tracking system, built for teams who are serious about shipping great software.

The effort was put to make time spent on case report easy for developers/ managers to report. Which will in turn help management see where we the load and how we can make it more happy place to work. With this simple goal, we developed and we are going to reep its benefits soon.

Technologies Used:

  • Asp.net
  • C#
  • Ajax
  • JQuery
  • HTML
  • DHTML
  • jQGrid

Riz

NOTE: FogBugz is trademark of “Fog Creek Software” http://www.fogcreek.com/contact.html