Beyond Relational - News Letters

Silverlight Architecture (beyondrelational.com - 30 August 2010)

August 30, 2010 [Volume 2, Issue 21] TSQL Beginners Challenge 15 - Reverse the order of words within a sentence This challenge is to reverse the order of words within a sentence. Most of us must be familiar with reversing the order of letters within a...

by Dhara on 08-30-2010 | 21 Views

LINQ Query against IIS? (beyondrelational.com - 23 August 2010)

August 23, 2010 [Volume 2, Issue 20] TSQL Challenge 37 - Calculate the downtime and duration of servers based on the monitoring log. This is a challenge to identify the downtime of servers from the log data generated by a monitoring application. There...

by JacobSebastian on 08-23-2010 | 38 Views

What is Silverlight? (beyondrelational.com - 16 August 2010)

August 16, 2010 [Volume 2, Issue 19] TSQL Beginners Challenge 14 - Count the number of occurrence of characters in the string This challenge is all about counting the number of occurrence of characters in a string using a SET based query. The task is...

by JacobSebastian on 08-16-2010 | 38 Views

Count(*) or Count(1) ? - Which is better? (beyondrelational.com 09 Aug 2010)

August 09, 2010 [Volume 2, Issue 18] TSQL Challenge 36 - Create a graph/Chart with TSQL This challenge involves generating a graph in TSQL. Your job is to write a query that generates the required graph representation of the data provided in an input...

by JacobSebastian on 08-09-2010 | 57 Views

Difference between TSQL Functions CAST and CONVERT (beyondrelational.com 02 Aug 2010)

August 02, 2010 [Volume 2, Issue 17] TSQL Beginners Challenge 13 - Validate GUID values and perform a horizontal and vertical count of characters The challenge involves validating the GUID values and perform horizontal and vertical count of the characters...

by JacobSebastian on 08-02-2010 | 65 Views

Support for Paging Queries in SQL Server CE 4.0 (beyondrelational.com 26 July 2010)

July 26, 2010 [Volume 2, Issue 16] TSQL Challenge 35 - Find the total number of 'Full Attendees' in each 24 HOP Session The recent 24-hours-of-pass or more widely known as #24HOP on twitter and other social media was one of the most exciting SQL...

by JacobSebastian on 07-26-2010 | 93 Views

Introduction : LINQ to SQL (beyondrelational.com 19 July 2010)

July 19, 2010 [Volume 2, Issue 15] TSQL Challenge 34 - Search for two keywords within the maximum distance of one word between them This challenge is all about searching for two keywords in a string with a maximum distance of 'one word' between...

by JacobSebastian on 07-19-2010 | 74 Views

Beyond Relational Newsletter - Getting Started with Bing Map in Silverlight

July 05, 2010 [Volume 2, Issue 14] TSQL Challenge 33 - Calculate list of bookings fully paid on the booking date Here is an interesting problem which deals with the amount of data to be excluded rather than included. This problem is related to a reservation...

by JacobSebastian on 07-05-2010 | 113 Views

Connection Pooling in ADO.NET (Beyondrelational.com newsletter 21 June 2010)

June 21, 2010 [Volume 2, Issue 13] TSQL Challenge 32 - Clean up phrases by removing noise words The idea of this challenge is to clean up the phrase from the words identified as 'noise' words, but only when these words appear at the begining or...

by JacobSebastian on 06-21-2010 | 80 Views

Beyond Relational Newsletter - SELECT * FROM XML

June 7, 2010 [Volume 2, Issue 12] TSQL Challenge 31 - Managing multiple overlapping date intervals This challenge is adapted from a budgeting system used in a large company to perform quarterly analysis of what kind of work will be done and where it will...

by JacobSebastian on 06-07-2010 | 90 Views

Beyond Relational Newsletter - 24 May 2010

May 24, 2010 [Volume 2, Issue 11] TSQL Challenge 30 - A Matrix Transposition challenge in TSQL This is a matrix transposition challenge and your job is to change the position of the numbres in a 5x5 matrix. Transposition includes converting rows to columns...

by JacobSebastian on 05-24-2010 | 91 Views

Beyondrelational Newsletter - What is your favorite SQL Server 3rd Party Tool?

May 10, 2010 [Volume 2, Issue 10] TSQL Challenge 29 - Reorganize sales data by sales amount This challenge presents a tough task of reorganizing the data in a sales table. The table is not normalized correctly and the sales detail data of three items...

by JacobSebastian on 05-10-2010 | 128 Views

More Business Intelligence Resources (beyondrelational.com newsletter 26 April 2010)

April 26, 2010 [Volume 2, Issue 9] TSQL Challenge 28 - SELECT TOP N articles from each category from a SQL Server 2000 database A website that runs on SQL Server 2000 needs to identify the most recent articles from each category to display on its home...

by JacobSebastian on 04-26-2010 | 149 Views

Congratulations to new SQL Server MVPs - Brad Schulz and David Barbarin (Newsletter - 12 April 2010)

Join me to congratulate new SQL Server MVPs: Brad Schulz and David Barbarin....

by JacobSebastian on 04-12-2010 | 196 Views

Why LEFT JOIN doesn't bring all records from the LEFT table?

This issue of Beyond Relational Newsletter (29 March 2010) presents a summary of last two weeks' activities at beyondrelational.com....

by Jacob Sebastian on 03-29-2010 | 248 Views