Archive for January, 2009

create function getDayOfWeek
    (@date datetime)
returns varchar(10)
as
    begin
        declare @retVal varchar(10)
        select @retVal=
            case datepart(dw,@date)
                when 1 then 'Sun'
                when 2 then 'Mon'
                when 3 then 'Tue'
                when 4 then 'Wed'
                when 5 then 'Thu'
                when 6 then 'Fri'
                when 7 then 'Sat'
            end
        return @retVal
    end

Then you can just call it as any other function in a select (or however you need it):

select dbo.getDayOfWeek(getdate())

USE [dbName]
GO
CREATE TABLE #temp (
table_name sysname ,
row_count INT,
reserved_size VARCHAR(50),
data_size VARCHAR(50),
index_size VARCHAR(50),
unused_size VARCHAR(50))
SET NOCOUNT ON
INSERT #temp
EXEC sp_msforeachtable 'sp_spaceused ''?'''
SELECT a.table_name,
a.row_count,
COUNT(*) AS col_count,
a.data_size
FROM #temp a
INNER JOIN information_schema.columns b
ON a.table_name collate database_default
= b.table_name collate database_default
GROUP BY a.table_name, a.row_count, a.data_size
ORDER BY CAST(REPLACE(a.data_size, ' KB', '') AS integer) DESC
DROP TABLE #temp

Reference articles:

• Tip/Trick: Url Rewriting with ASP.NET by Scott Guthrie – Examines four approaches: 1) Use Request.PathInfo Parameters Instead of QueryStrings; 2) Using an HttpModule to Perform URL Rewriting; 3) Using an HttpModule to Perform Extension-Less URL Rewriting with IIS7; 4) ISAPIRewrite to enable Extension-less URL Rewriting for IIS5 and IIS6; also discusses how to handle ASP.NET postbacks correctly with URL rewriting.

• URL Rewriting by Salman (CSharpFriends) – simple implementation of URL rewriting logic within the Application_BeginRequest() method of the Global.asax file.

• Search Engine Friendly URLs using ASP.NET (C#.NET) by Maziar Aflatoun (The UK Web Design Company) – similar to the above, but regular expression is used to match URLs.

• Rewrite.NET – A URL Rewriting Engine for .NET by Robert Chartier (15Seconds.com). Solution steps:
  • Create the HttpModule to process the web request and rewrite the URL
  • Add the handler in Web.config
  • Create a configuration section in Web.config to define URL mapping rules
  • Add extensibility by creating a rules engine interface
  • Write class or classes to implement rules engine interface
  • Add code to the HttpModule to dynamically load the desired rules from Web.config

• URL Rewriting in ASP.NET by Scott Mitchell (MSDN) – examines how to implement URL rewriting in a HTTP module; also explains how to handle postbacks.

• URL Rewriting with ASP.NET by Richard Birkby (CodeProject) – shows how legacy ASP sites can be upgraded to ASP.NET, while maintaining links from search engines. Solution steps:
  • Create the configuration section in Web.config for defining URL mapping rules
  • Write the configuration section handler class, incorporating the URL rewriting logic
  • Create a call to handler in Global.asax in Application_BeginRequest() method
  • Compile the code and install the rewriter assembly in the Global Assembly Cache (GAC)
  • Configure IIS to map non- .aspx files to the ASP.NET ISAPI extension

Related Resources

• Making Sense of ASP.NET Paths by Rick Strahl
• Fixing Microsoft’s Bugs: URL Rewriting by Jesse Ezell
• Regular Expressions with .NET by Dan Appleman and Daniel Appleman
• UrlRewritingNet.UrlRewrite – an Open Source Component which allows you certainly to rewrite URLs with ASP.NET 2.0.
• Open Source URL Rewriter for .NET / IIS / ASP.NET

On May 12th & 13th 2008 some of the West-End’s greatest leads took to the stage at the Royal Albert Hall in Sir Tim Rice’s musical concert production of ‘Chess’. Rice has declared that this will be the definitive version of the musical, taking from both branches of the production and taking the show back to it’s original intended storylines.

* photos from icethesite http://www.icethesite.com/

Aoife Mulholland in Chess, Royal Albert Hall 12th May 2008

Aoife On Stage With Adam Pascal as Freddie

The Chess Company (soloists). Grant Anthony, Christopher Colley, Tiffany Graves, Leila Benn Harris, David Michael Johnson, Debbie Kurup, Aoife Mulholland, Andrew Playfoot, Jon Robyns and Tabitha Webb

Part of the Chess Company Singers

CAST

Introduced: by Sir Tim Rice

Principle Cast:
Josh Groban as Anatoly Sergievsky
Idina Menzel as Florence
Adam Pascal as Frederick Trumper
David Bedella as Molokov
Kerry Ellis as Svetlana
Clarke Peters as Walter
Marti Pellow as The Arbiter

Chess in Concert Company:
Grant Anthony
Christopher Colley
Tiffany Graves
Leila Benn Harris
David Michael Johnson
Debbie Kurup
Aoife Mulholland
Andrew Playfoot
Jon Robyns
Tabitha Webb

Cantabile – [London Quartet]
Choir – 100 Strong – ‘The West End Chorus’
Orchestra – 50 Piece – ‘City Of London Philharmonic’
RAH Organ – played by Stephen Disley

Artistic Direction: Lyrics by Tim Rice and music by Björn Ulvaeus and Benny Andersson. Conductor, David Firman. Musical Director, Mark Warman. Choral Director, Stuart Morley. Choreographers, Kevan Allen and Andrew Wright. Animation, Rehana Khan. Director & Adaptation, Hugh Wooldridge.

VIDEOS OF THE NIGHT - From YouTube (LQ Audience Cams)

Endgame

*
I Know Him So Well


Nobody Is On Nobody’s Side


Somebody Else’s Story

Where I Belong

PHOTOS OF THE NIGHT - From icethesite http://www.icethesite.com/

*
***** Josh Groban as Anatoloy ************ Kerry Ellis as Svetlana

*
**** Idina Menzel as Florence **************** Josh and Idina Kiss

*
** Josh and Kerry – End Game ************ Sir Tim Rice – Introduction

*
** Davide Badella as Molokov ************* Adam Pascal as Freddie

_________________________________________

Official London Theatre Guide

Stars line up to play Chess

03 Mar 2008

Marti Pellow, David Bedella and Clarke Peters have been added to the star-studded line up of Chess In Concert, a two-night concert performance of Tim Rice, Björn Ulvaeus and Benny Andersson’s musical at the Royal Albert Hall on 12-13 May. The trio joins a cast that already contains Wicked leading ladies Idina Menzel and Kerry Ellis, recording artist Josh Groban and Broadway star Adam Pascal. Also now confirmed in the cast are Tiffany Graves, Debbie Kurup, Leila Benn Harris and Aoife Mulholland.

Pellow (who plays The Arbiter) is the lead singer of pop band Wet Wet Wet, whose string of hits came predominantly in the 1980s and 90s. Among those chart-toppers, the band’s 1994 hit Love Is All Around spent 15 weeks at number one in the UK singles charts, after which Pellow allegedly asked for it to be removed from sale. Bedella (Molokov) is best known in the West End for playing Satan in the National Theatre production of Jerry Springer – The Opera in 2003, for which he won the 2004 Best Actor in a Musical Laurence Olivier Award, and Frank N Furter in the 2006 revival of The Rocky Horror Show. Bedella is also known to Holby City viewers for playing short and sexy surgeon Carlos Fashola in the hospital soap.

Peters (Walter) was last in the West End playing Porgy in Trevor Nunn’s production of Porgy And Bess at the Savoy in 2006. His extensive list of previous West End credits includes The Witches Of Eastwick, Chicago, Simply Heavenly, The Iceman Cometh and Five Guys Named Moe, which he also wrote, winning the 1991 Laurence Olivier Award for Best Entertainment.

Among their many London stage credits Graves and Kurup have both played the role of Velma in Chicago in the West End. Mulholland is also a Chicago veteran, having played Roxie in December 2006. The actress first became known for taking part in the reality television programme How Do You Solve A Problem Like Maria? and is currently playing Maria in The Sound Of Music for two performances a week. Benn Harris is the current Christine in The Phantom Of The Opera and has previous London stage credits including Fame and Evita.

_____________________________________

See This Link For A Stunning 360 Degree Virtual Tour Of The Royal Albert Hall
Link - http://www.sphericalimages.com/royalalbert/virtual_tour.htm

*