adsense

Sunday, April 27, 2014

Sql server Extended Events (video)

Sql server  Extended Events  replaces Server Side Traces and its very lightweight.

watch video
http://www.brentozar.com/archive/2014/04/introduction-extended-events/

Friday, April 11, 2014

Colorize Crystal reports Controls

If you have ever come across a situation where you need to colorize Crystal reports controls using Hex color values, there are few options you can choose between.
1) Convert the color code to Hex in the sql using a funtion
2) Convert the color code to Hex using a Crystal Reports custom function

Following post provided step-by-step instructions on colorizing crystal report controls using a Crystal Reports custom function.

http://www.paulspatterson.com/crystal-report-functions-to-colorize-background-using-html-hex-color-value/

Cheers
Samitha