Beyondrelational - Microsoft SQL Server blogs, articles and discussion forums - TSQL, XML, FILESTREAM, Business Intelligence

Got a SQL Server or .NET question? Discuss it in the forums. (SQL Server Forums | Dot NET Forums)

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Are you a TSQL Expert? Prove it by solving this challenge!

TSQL Challenge 37 - Calculate the downtime and duration of servers based on the monitoring log

Or a TSQL Beginner? Train yourself by attempting this challenge!

TSQL Beginners Challenge 15 - Reverse the order of words within a sentence

Top Blogs

	Jacob's Blog
	Madhivanan's TSQL Blog
	White Papers
	Blogs from the Experts
	Some Random Thoughts
	Siddharth Mehta's Blog
	Dinesh Asanka

Create your own blog

Recent Forum Posts

View all discussions

Business Intelligence

SQL Server XML

Subscribe in a reader or by Email

White Papers

Popular SQL Server Tools

Most Active Users

Name	Points

murugan	0
Neeraj Mathur	0
Nihas	0
Syed Mehroz Alam	33
Michael Coles	5
Murali	0
Praveen	0
Sid Guevara	0
Puja	30
Patel Akhilkumar	0
PeterNeo	5
poratips	175
meflyboy	0
Kavitha	0
krkansara11	0

Performing a Right Outer Join with a Left Outer Join clause

Most of the interviewers I have seen tend to prefer people with better problem solving skills rather than better knowledge on a particular technology. No wonder considering the fact that technologies change with each fleeting moment, while a good problem...

by Jason Thomas on 08-24-2010 | 575 Views
Using Let Keyword in Linq

I am using Linq-To-Object in my current project to remove some extra loops and I have found one of the great keyword in Linq called ‘Let’. Let keyword provides facility to declare a temporary variable inside the Linq Query.We can assign the...

by Jalpesh on 08-24-2010 | 95 Views
Event Handling in Silverlight

In the previous article I described what are the different Layout Management Panels in Silverlight and how and when they are used. In this article I will try to describe how to add/manage events in Silverlight. What is an Event An event is a message sent...

by Dinesh Sodani on 08-24-2010 | 341 Views
Select and SelectMany: LINQ projection operator

Projection helps us developer to retrieve desired result from the collection . LINQ provides two projection operator. Select and SelectMany. Select works with one collection whereas SelectMany works with more than one collection....

by Dhananjay Kumar on 08-24-2010 | 368 Views
SqlCeCmd tutorial part two – Creating database objects and adding data

This is the second part of a 3 part series with some examples of sqlcecmd usage. The first part is here. This second part deals with creation of database objects and adding data. To create a table sqlcecmd -d "Data Source=C:\test2.sdf" -q "CREATE...

by Erik Ejlskov Jensen on 08-24-2010 | 359 Views
SQL Server - Understanding full power of CASE Expressions

Many programming languages like VB6 support IIF function which is used to return a value based on a particular expression/condition. In SQL Server the equivalent is to make use of CASE Expression, which is used to evaluate many conditions and return a...

by Madhivanan on 08-24-2010 | 633 Views
Layout Management Panels in Silverlight

In the previous article I described how to create a simple Silverlight application in Microsoft Visual Studio 2010. In this article I will describe what are the different Layout Management Panels in Silverlight and how and when they are used. When you...

by Dinesh Sodani on 08-23-2010 | 258 Views
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 is a monitoring application that keeps checking the status of several servers at 5 minute intervals. When the monitoring application...

by JacobSebastian on 08-23-2010 | 1,825 Views
How to Create Silverlight Application in Visual Studio 2010

In the previous article I attempted to explain What Silverlight is and how it is being used more and more to develop business applications. In this article I will demonstrate how to create a simple Silverlight application using Microsoft Visual Studio...

by Dinesh Sodani on 08-20-2010 | 1,003 Views
SqlCeCmd tutorial part one – Managing database files

This tutorial will show various samples of using SqlCeCmd, which is available at http://sqlcecmd.codeplex.com – sqlcecmd is the “equivalent” of sqlcmd for the full SQL Server product. The series will be in three parts, the first one demonstrates how to...

by Erik Ejlskov Jensen on 08-19-2010 | 418 Views
SILVERLIGHT Tutorial - What is XAML?

In the previous article I attempted to explain What is XAP file in Silverlight . In this article I will try to explain what is XAML and how it is used in Silverlight. Extensible Application Markup Language (XAML, pronounced zammel) is a declarative XML...

by Dinesh Sodani on 08-19-2010 | 468 Views
SQL Server - Understanding the behavior of @@TRANCOUNT when querying from a client application

As you know, @@TRANCOUNT is used to inform you about the number of live transactions active at point. If you want to retrieve it's value using an application, you should be careful about the behaviour of the returned value. Let us consider the procedure...

by Madhivanan on 08-19-2010 | 718 Views

1 2 3 4 5 Next > ... Last »