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)