From Y! Theater - "Nicole Sullivan : Design Faster Websites"
Tuesday, December 30, 2008
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
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':
In this below Embed, I have embedded the Flickr Feed for the Keyword 'Technology':
Thursday, December 18, 2008
"Oracle in the Cloud" AWS Webinar
Check out this SlideShare Presentation:
Top 10 Web Apps 0f 2008
The Top 10 Web Apps of 2008, published by RWW (ReadWriteWeb):
Top 10 Semantic Web Products of 2008
Top 10 International Products of 2008
Top 10 Consumer Web Apps of 2008
Top 10 RSS and Syndication Products of 2008
Top 10 Mobile Web Products of 2008
Top 10 Enterprise Web Products of 2008
Top 10 Real World Apps of 2008
Top 10 Semantic Web Products of 2008
Top 10 International Products of 2008
Top 10 Consumer Web Apps of 2008
Top 10 RSS and Syndication Products of 2008
Top 10 Mobile Web Products of 2008
Top 10 Enterprise Web Products of 2008
Top 10 Real World Apps of 2008
Wednesday, December 17, 2008
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.
A pool of highly scalable,abstracted infrastructur, capable of hosting end-customer applications, that is billed by consumption.
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
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>
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>
Subscribe to:
Posts (Atom)
