Tuesday, December 30, 2008

Design Faster Websites

From Y! Theater - "Nicole Sullivan : Design Faster Websites"


SQL Tip: Query to get Physical file size of a DB

SQL Query to get the Physical file size of a given Database:
select Name, size, maxsize, growth from sys.sysfiles

SQL Tip: Query to get Table Statistics

SQL Query to get the Table(s) Statistics like RowCount, CreatedDate, Page Size etc., on a given Database:

SELECT s.Name SchemaName
, o.Name TableName
, coalesce(i.Name, 'HEAP') IndexName
, p.used_page_count * 8 UsedPageCountInKB
, p.reserved_page_count * 8 ReservedPageCountInKB
, p.row_count RowsCount
, t.create_date CreatedDate
, t.modify_date ModifiedDate
, t.max_column_id_used Columns
FROM sys.dm_db_partition_stats p
INNER JOIN sys.objects as o
ON o.object_id = p.object_id
INNER JOIN sys.schemas as s
ON s.schema_id = o.schema_id
INNER JOIN
sys.tables t ON t.object_id = o.object_id
LEFT OUTER JOIN sys.indexes as i
on i.object_id = p.object_id and i.index_id = p.index_id
WHERE o.type_desc = 'USER_TABLE'
and o.is_ms_shipped = 0
ORDER BY
p.row_count DESC

Monday, December 29, 2008

Introducing jQuery

Check out this SlideShare Presentation:
Extending jQuery
View SlideShare presentation or Upload your own. (tags: extending jquery)

Unobtrusive JavaScript with jQuery

Check out this SlideShare Presentation:

Javascript : The Good Parts - Part Six: Ajax Performance

From YUI Theater, Javascript : The Good Parts - Part Six: Ajax Performance


Friday, December 19, 2008

Cooliris

Have you heard about Cooliris? It is Browser plugin which gives a 3D view of images and videos. The normal web pages with Media files can be viewed as 3D using this pugin. A Media RSS can be easily embedded with this Cooliris plugin to make it as a 3D Viewable.

In this below Embed, I have embedded the Flickr Feed for the Keyword 'Technology':

Wednesday, December 17, 2008

REST, JSON, RSS + WCF

REST, JSON and RSS with WCF 3.5
View SlideShare presentation or Upload your own. (tags: wcf rest)

Enterprise IT Systems with REST

Check out this SlideShare Presentation:

REST and Web 2.0

Check out this SlideShare Presentation:

Tuesday, December 16, 2008

Monday, December 15, 2008

Cloud Computing

Cloud Computing is clearly explained in this slideshow.

A pool of highly scalable,abstracted infrastructur, capable of hosting end-customer applications, that is billed by consumption.


SaaS Technical-Business Overview

SaaS Technical-Business Overview
View SlideShare presentation or Upload your own. (tags: saas)

Software-as-a-Service (SaaS) - a Slideshow

Friday, December 12, 2008

Monday, December 8, 2008

Todd Kloots: Developing Accessible Widgets with ARIA (Accessible Rich Internet Applications)

From Y!Theater- Todd Kloots: Developing Accessible Widgets with ARIA (Accessible Rich Internet Applications)

Thursday, December 4, 2008

All About Google

Good facts about Google.

All about Google
View SlideShare presentation or Upload your own. (tags: google technology)

ASP.NET Tip: Maintain Session in ASHX Handler class

When using ASHX handler files if you want to maintain the SessionState, inherit the ASHX class from System.Web.SessionState.IRequiresSessionState. Otherwise, the Session object will be NULL in ASHX context.

Moonlight

Moonlight is an open source implementation of Microsoft Silverlight for Unix systems.

Download here
Check the Roadmap here

Wednesday, December 3, 2008

SSRS Tip - Create your Own Style Template

While creating a New Report, I was using the Default Table/Matrix Styles built in with SSRS. By default it has 'Slate', 'Forest'... But for some reason, I am not satisfied with the Colors in those Styles. So After creating a Report with those Style, I had to manually change the color,font etc. So I thought of making a Custom Style/Theme with my own choice of Color, Font, Size etc. So I researched and found that we can create our own Style/Theme and add it to the Built in ones.
These are the steps:
1. Goto : C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles\en
2. See the 'StyleTemplates.xml', which contains all the Style definitions in XML format. You will see the styletemplates 'Slate', 'Forest' etc.
3. Add your own StyleTemplate with your styles to the Root tag.
4. Create a New Report, you will see this new StyleTemplate in the 'Report Wizard - Choose the Table Style'.

The modified StyleTemplates.xml can be downloaded here:

In this example I created my own custom StyleTemplate (the following) and added it.



<StyleTemplate Name="LightTheme"> <Label>LightTheme</Label> <Styles> <Style Name="Title"> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <FontSize>12pt</FontSize> </Style> <Style Name="Page Group Level 1"> <FontFamily>Tahoma</FontFamily> <FontSize>10pt</FontSize> </Style> <Style Name="Page Group Level 2"> <FontFamily>Tahoma</FontFamily> <FontSize>9pt</FontSize> </Style> <Style Name="Page Group Level 3+"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> </Style> <Style Name="Table"></Style> <Style Name="Matrix"></Style> <Style Name="Table Header"> <BackgroundColor>Gray</BackgroundColor> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <FontWeight>Bold</FontWeight> <Color>White</Color> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>DimGray</Default> </BorderColor> </Style> <Style Name="Group Level 1"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <BackgroundColor>DarkGray</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>DimGray</Default> </BorderColor> </Style> <Style Name="Group Level 1 Textbox"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <BackgroundColor>DarkGray</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>DimGray</Default> </BorderColor> </Style> <Style Name="Group Level 2"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <BackgroundColor>Gainsboro</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>LightGrey</Default> </BorderColor> </Style> <Style Name="Group Level 2 Textbox"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <BackgroundColor>Gainsboro</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>LightGrey</Default> </BorderColor> </Style> <Style Name="Group Level 3+"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <BackgroundColor>Gainsboro</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>LightGrey</Default> </BorderColor> </Style> <Style Name="Group Level 3+ Textbox"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <BackgroundColor>Gainsboro</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>LightGrey</Default> </BorderColor> </Style> <Style Name="Detail"> <FontFamily>Tahoma</FontFamily> <FontSize>8pt</FontSize> <BackgroundColor>Gainsboro</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <BorderColor> <Default>DimGray</Default> </BorderColor> <TextAlign>Right</TextAlign> </Style> </Styles> </StyleTemplate>