Browse by Tags

All Tags » SQLServer 2008 (RSS)

TSQL Quiz 2011 on beyondrelational.com by Jalpesh P. Vadgama

One of the my friend Jacob Sebastian running a SQL Server TSQL quiz on his site beyondrelational.com. This is a great opportunity to learn TSQL and win great price Like Apple IPad and other lots of cool stuff. So if you are expert and if you learning...

GUID Vs Int data type as primary key by Jalpesh P. Vadgama

Recently one of my friend ask me when I should go for GUID and When I should go for Int as primary key in table. So decided to write a blog post for it. Here are advantages and disadvantage of the GUID and INT. INT Data Type: Advantages: Its required...

Binding A Custom Entity Class to stored procedure using Linq-To-SQL by Jalpesh P. Vadgama

I have already written several post about Linq its a great ORM that we can use in various way. The purpose of this post to demonstrate How we can bind custom entity to stored procedure result with use of Linq-To-SQL. Let’s go through it and you will realize...

Visual Studio –>Add Database –> Named pipe Provider Error for SQL Server by Jalpesh P. Vadgama

Recently I have been working on a article for my blog for that I just tried to add a database file on my solution with visual studio and I have received following error. An error has occurred while establishing a connection to the server. (provider: Named...

TSQL Challenges on beyondrelational.com by Jalpesh P. Vadgama

My friend and Guide Jacob Sebastian who is an Microsoft SQL Server MVP running a very popular series of TSQL on his site beyondrelational.com. If you know something about SQL Server then this challenge is for you. And if you are master of SQL then this...

Reboot require check fails while installing SQL Server 2008 R2 Express by Jalpesh P. Vadgama

Before some days I was installing SQL Server 2008 R2 Express edition on my machine and every time when it runs checks for required settings It was failing giving error reboot required. I have rebooted my machine several time and result was same. After...
More Posts